Now supports FETCH INTO

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD G_TIMEOUT_SECS_PER_1000_LINES increase to 180 since the change to get_next with i_search2, takes 3* as long.
--Now supports FETCH cursor INTO single variable (bind, non-bind or rec.col)
--MOD PROCEDURE AOP_block
--  NEW G_REGEX_FETCH_INTO - with new section in main CASE, which then searched for G_REGEX_VAR,G_REGEX_REC_COL or G_REGEX_BIND_VAR
--  NEW SUB-PROCEDURE find_bind_var
--  NEW SUB-PROCEDURE find_non_bind_var
--  NEW SUB-PROCEDURE find_rec_col_var
Now supports FETCH INTO

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD G_TIMEOUT_SECS_PER_1000_LINES increase to 180 since the change to get_next with i_search2, takes 3* as long.
--Now supports FETCH cursor INTO single variable (bind, non-bind or rec.col)
--MOD PROCEDURE AOP_block
--  NEW G_REGEX_FETCH_INTO - with new section in main CASE, which then searched for G_REGEX_VAR,G_REGEX_REC_COL or G_REGEX_BIND_VAR
--  NEW SUB-PROCEDURE find_bind_var
--  NEW SUB-PROCEDURE find_non_bind_var
--  NEW SUB-PROCEDURE find_rec_col_var

--Caveat
--G_REGEX_FETCH_INTO needs a review.
--Need to handle SELECT INTO and FETCH INTO
--Need to process multiple assignments into a list
--then advance to the ;
--then add the notes for each var in the list.
--don't use i_modifier = 'in' that caused a bizarre value error in get_next.
Tidy-up: Move functionality from ms_logger to ms_api, Delete draft APEX pages

Modified   apex/f104/application/create_application.sql
Modified   apex/f104/application/pages/page_00008.sql --Fixed for prog unit location
Modified   apex/f104/application/pages/page_00009.sql --Fixed for prog unit location
Modified   apex/f104/application/pages/page_00022.sql --Removed unneeded CLOB code
Modified   apex/f104/application/pages/page_00025.sql --Removed unneeded CLOB code
Modified   apex/f104/application/set_environment.sql
Modified   apex/f104/application/shared_components/navigation/breadcrumbs.sql
Modified   apex/f104/install.sql
Modified   database/LOGGER/Packages/ms_api.pkb
Modified   database/LOGGER/Packages/ms_api.pks
--NEW from ms_logger
--FUNCTION   msg_level_string
--FUNCTION   unit_message_count
--FUNCTION   unit_traversal_count
--PROCEDURE  set_module_debug
--PROCEDURE  set_module_normal
--PROCEDURE  set_module_quiet
--PROCEDURE  set_module_disabled
--PROCEDURE  set_unit_debug
--PROCEDURE  set_unit_normal
--PROCEDURE  set_unit_quiet
--PROCEDURE  set_unit_disabled
--PROCEDURE  purge_old_processes

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--MOVED 12 routines above, to ms_api
Modified   database/LOGGER/UnitTest/aop_test.sql --Fixed for prog unit location
Modified   database/LOGGER/UnitTest/ms_test.sql  --Fixed for prog unit location
Modified   database/LOGGER/Views/ms_views.vw     --Fixed for prog unit location
Support for select into and fetch into with multiple targets

Modified   database/LOGGER/Packages/aop_processor.pkb
--Reinstated FUNCTION regex_match - with default case insensitive
--Replace all use of REGEXP_LIKE with regex_match
--MOD PROCEDURE AOP_block - new  l_into_var_list, G_REGEX_SELECT_FETCH_INTO
--Replace find_bind_var      with find_var + note_var
--Replace find_non_bind_var  with find_var + note_non_bind_var
--Replace find_rec_col_var   with find_var + note_rec_col_var
--  MOD WHEN G_REGEX_SELECT_FETCH_INTO
--      Find each variable until a ";" is reached.
--      Loop thru the variables after all have been found,
--        noting each variable, using note_var, note_non_bind_var, or note_rec_col_var as appropriate
Modified   database/LOGGER/UnitTest/aop_test.pkb
--New test for select into and fetch into with multiple targets
Get_Next - Search is split into i_srch_before, i_stop, i_srch_after in that order of priority.

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD FUNCTION get_next
--  Rename params i_search TO i_srch_before,  i_search2 TO i_srch_after
--  NEW sub-proc   PROCEDURE consume_search
--  Logic to determine l_use_srch_before, assumes i_srch_before may be null
--  l_any_search is either  i_srch_before|i_stop or i_stop|i_srch_after
--  When testing which componant matched, refer back to order of priority.
Merge branch 'feature/logger/LOG-01' of E:/GitRepos/SmartLogger into feature/logger/LOG-01

Conflicts:
	database/LOGGER/Packages/aop_processor.pkb
Basically just used local copy.
I don't know why there was a conflict.
Merge branch 'feature/logger/LOG-01' of H:/GitRepos/SmartLogger into feature/logger/LOG-01
Support for $ and # in identifiers

Add # and $ to REGEXs for WORD.  Cascade these thru all word searches.
NB alters the calculation of sub elements returned by REGEXP_SUBSTR

Modified   database/LOGGER/Packages/aop_processor.pkb
--NEW G_REGEX_WORD_CHAR - Word Char  = non-quoted Oracle identifier chars include "A-Z,_,#,$"
--MOD G_REGEX_WORD - uses G_REGEX_WORD_CHAR - Word is at least 1 Word Char
--MOD G_REGEX_2WORDS and G_REGEX_2_QUOTED_WORDS - use G_REGEX_WORD
--MOD G_REGEX_END_BEGIN - uses G_REGEX_WORD_CHAR
--MOD PROCEDURE AOP_pu_params - use G_REGEX_WORD in REGEXs, adjust sub-element numbers to account for embedded () in G_REGEX_WORD
--MOD FUNCTION AOP_var_defs   - use G_REGEX_WORD in REGEXs, adjust sub-element numbers to account for embedded () in G_REGEX_WORD
--MOD PROCEDURE AOP_block - use G_REGEX_WORD and G_REGEX_2WORDS
--FIX  PROCEDURE AOP_block - correct order of evaluation of var assign types.
--MOD procedure restore_comments_and_quotes and procedure stash_comments_and_quotes
--Change tags around quote and comments to << >> instead of ##  ## since # is a legal identifier char

Modified   database/LOGGER/UnitTest/aop_test.pkb
--Added $ and # to some identifiers
NEW Patch: LOG-01_12A_12B_LOGGER - Supports additional features

* Support for $ and # in identifiers
* Support for select into and fetch into with multiple targets