Now recognises %ROWTYPE variables in the declaration.

Next teach %TYPE and broaden support to include the spec params

Added      database/LOGGER/Functions/supported_data_type.fnc
--Intended to be granted to the indiv user.
Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD g_weave_timeout_secs - add 2 extra seconds so can't evaluate to 0.
--MOD FUNCTION AOP_pu_params - uses supported_data_type
--MOD FUNCTION AOP_var_defs --Looking for ROWTYPE VARS
--stores multiple var names, one for the RECORD and one for each column.
--MOD PROCEDURE AOP_block
--  fix use only G_REGEX_WHEN_EXCEPT_THEN in the main search (also matches for G_REGEX_WHEN_OTHERS_THEN)
--    to avoid failure of REGEX to complete evaulation. (some interaction with G_REGEX_ASSIGN_TO_REC_COL_
--  added support for "l_unit :="  and for "l_unit.unit_name :="
--MOD function weave - go past DECLARE to highlight it.
Modified   database/LOGGER/UnitTest/aop_test.pkb
Modified   database/LOGGER/UnitTest/aop_test.pks
--Addd test cases.
Modified   database/SYS/Users/logger.user
--grant select on DBA_TAB_COLUMNS to logger; - NOT YET USED
Recognises variables with %TYPE definitions.

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD FUNCTION AOP_var_defs --LOOKING FOR TAB COL TYPE VARS
Modified   database/LOGGER/UnitTest/aop_test.pkb
--Added test case
Creating API to expose logger data for other programs.

Modified   database/LOGGER/Functions/supported_data_type.fnc --Extra datatypes
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--NEW FUNCTION f_dba_source
--MOD PROCEDURE warn_user_source_error_lines - uses f_dba_source instead of f_user_source
--NEW FUNCTION process_ref_cursor - returns a ref cursor of formatted lines for output in email by other programs.
Modified   database/LOGGER/Views/aop_source_v.vw
--added COLUMN aop_html.load_datetime  AS html_load_datetime
Modified   database/SYS/Users/logger.user
--grant select on DBA_SOURCE to logger;
Prepare a process report in both plain text and HTML forms
HTML version now resembles the messages browser in f104 on p8

Modified   database/LOGGER/Grants/sun.grt
--grant select on ms_unit_traversal_vw to sun;
--grant select on ms_message_vw to sun;
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--NEW FUNCTION get_plain_text_process_report
--NEW FUNCTION get_html_process_report
--DEL FUNCTION process_ref_cursor
Modified   database/LOGGER/UnitTest/ms_test.pkb --test order change.
Modified   database/LOGGER/Views/aop_source_v.vw --add COLUMN using_aop
Modified   database/LOGGER/Views/ms_views.vw
--FIX VIEW ms_message_vw - fixed msg_type for 'Param'
Created a new SmartLoggerAPI

Modified   apex/f104/application/pages/page_00002.sql
--Display HTML_LOAD_DATETIME and USING_AOP
Modified   apex/f104/application/pages/page_00008.sql
--Stop clear cache RP (pagination) when clicking on links within the page.
--Only the process link now resets the RIR (interactive report to primary)
Modified   apex/f104/application/pages/page_00009.sql -- region name changed - defaulted new report columns
Modified   apex/f104/application/pages/page_00010.sql -- region name changed - defaulted new report columns
Modified   apex/f104/application/pages/page_00021.sql -- Char restrictions on field module_name
--new process SubmitNextShowProcessing
Modified   apex/f104/install.sql - new page page_00024.sql
Modified   database/LOGGER/Grants/sun.grt
--grant execute on ms_api to sun;
--removed view grants to sun;
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
-- EXPOSED FOR THE MS_API
FUNCTION f_process_id
FUNCTION f_process_is_closed
FUNCTION f_process_is_open
-- MOVED to ms_api.pkb
--FUNCTION get_plain_text_process_report
--FUNCTION get_html_process_report
Add        apex/f104/application/pages/page_00024.sql --Public User Feedback page.
Add        database/LOGGER/Packages/ms_api.pkb
Add        database/LOGGER/Packages/ms_api.pks
--ALL NEW
--FUNCTION get_plain_text_process_report RETURN CLOB;
--FUNCTION get_html_process_report RETURN CLOB;
--FUNCTION get_user_feedback_URL RETURN VARCHAR2;
--FUNCTION get_user_feedback_anchor RETURN VARCHAR2;
--FUNCTION get_support_feedback_anchor RETURN VARCHAR2;
New synonym
NEW Patch: LOG-01_06A_06B_SYS - New grants for LOGGER
NEW Patch: LOG-01_06A_06B_LOGGER - Composite patch as below

+ New synonym
+ Created a new SmartLoggerAPI
+ Prepare a process report in both plain text and HTML forms
+ Creating API to expose logger data for other programs.
+ Recognises variables with %TYPE definitions.
+ Now recognises %ROWTYPE variables in the declaration.
+ Implemented Variable Assignment Notes - recognised variables are noted after assignment
+ New feature SHOW_ME_LINE - code lines with trailing --@@ are exposed in a comment.
+ Adding warning for a WHEN OTHERS THEN
+ Creates Note after assignment to a bind variable.
+ Add a PACKAGE_NAME to the Quick AOP screen and use that as the module_name in AOP code.
+ Fixed failure to recognise "-- comment" and ")"
+ New ability to add annotations.
+ Mild refactor of get_next
Commit stashed change

Modified   database/LOGGER/Packages/aop_processor.pkb
--RENAME PROCEDURE splice_here TO wedge
Minor refactor AOP_pu_params

Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD FUNCTION AOP_pu_params - refactor existing recognition of "name in out type" with sub-expr
AOP_pu_params now searches for %ROWTYPE and %TYPE params

Modified   database/LOGGER/Packages/aop_processor.pkb
--NEW TYPE param_list_typ - used instead of the l_inject_params CLOB.
--MOD FUNCTION NOW PROCEDURE AOP_pu_params  (embedded PROCEDURE store_var_def)
-- Searches 'LOOKING FOR ATOMIC VARS', 'LOOKING FOR ROWTYPE VARS', 'LOOKING FOR TAB COL TYPE VARS'
--Uses store_var_def to compile 2 lists, IN in params and OUT in VARS
--RETURNS io_param_list AND io_var_list
--MOD PROCEDURE AOP_is_as passes empty param_list to AOP_pu_params and then onto AOP_pu_block
--MOD PROCEDURE AOP_pu_block - now takes io_param_list and inject individual params from the list
Modified   database/LOGGER/UnitTest/aop_test.pkb
--New tests.
Removing extra lines from Injection.

Modified   apex/f104/application/pages/page_00023.sql
--DEL 'P23_ORIG_TEXT','P23_AOP_TEXT' - not used.
--FIX beforeBranchtoQuickAOPUploadOrigTextToRawInput - set display values to NULL.
--2 other DA's set to never - remaining issues may require change to NAVBAR.
Modified   database/LOGGER/Packages/aop_processor.pkb
--MOD procedure splice - removing extra NLs when injecting consecutive params.
--MOD PROCEDURE AOP_pu_block - format param lines with RPAD
Modified   database/LOGGER/UnitTest/aop_test.pkb
Ensuring we can start a process passing a report_id and then retrieve the results from forms with that report_id.

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--MOD FUNCTION f_process_id - added params i_process_id IN INTEGER  DEFAULT NULL
                                          ,i_ext_ref    IN VARCHAR2 DEFAULT NULL
--  now checks for existance of i_process_id or for process_id of i_ext_ref or returns g_process_id
--MOD PROCEDURE log_process - now takes i_origin instead of i_module_name and i_unit_name.
--REMOVED Register operations - unused.
--REPLACE proc new_process with FUNCTION new_process
--The function returns a value for process_id.  Importantly it can be added to a prog unit header above the l_node, to ensure the process is started before the node is created.  The call can be used to add an ext_ref as below.
--    l_process_id      INTEGER := ms_logger.new_process('PB','report',:p_report_run_id);
--    l_node ms_logger.node_typ := ms_logger.new_func('PB' ,'beforepform');
Modified   database/LOGGER/Packages/ms_api.pkb
Modified   database/LOGGER/Packages/ms_api.pks
--NEW FUNCTION get_trace_URL - uses f_process_id's new params
Ensure trace file link only when a process has created a traversal.

Modified   apex/f104/application/pages/page_00008.sql
--Redo the Saved reports, adding Highlight for "Info ?"
--Now have "Primary", "Exceptions", "Messages", "Params and Notes"
--New DA HideControlPanel js toggles ControlPanel off.
Modified   apex/f104/application/pages/page_00024.sql
--Recopied IR from p8, use "Messages" as the default.
--New DA HideControlPanel js toggles ControlPanel off.
Modified   database/LOGGER/Packages/aop_processor.pkb
--FIX PROCEDURE AOP_block - bind variables do not need to be recognised in var list.
--MOD PROCEDURE AOP_prog_units
--BEFOREPFORM signifies beginning of report. Create a new process before the node
Modified   database/LOGGER/Packages/ms_api.pkb
--MOD FUNCTION get_trace_URL
              ,get_user_feedback_URL
              ,get_user_feedback_anchor
              ,get_support_feedback_anchor
-- no URL if not traced.  uses ms_logger.f_process_traced
Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--NEW FUNCTION f_process_traced
Improving Quiet Mode - relogging nodes in DEBUG mode.

Modified   database/LOGGER/Packages/ms_logger.pkb
Modified   database/LOGGER/Packages/ms_logger.pks
--MOD PROCEDURE log_node
--Log traversal or update it if already logged.
--Log any unlogged refs.
--MOD PROCEDURE dump_nodes
--Log traversals (using the given msg_mode) that have not yet been logged,
--or were logged at a higher msg_mode.
--search back recursively to first logged traversal, at an equal msg_mode
--log_node will update node with the new msg_mode
--and log any remaining unlogged refs.
--MOD PROCEDURE create_ref --don't create refs unless node at debug level