Get HTML - ctl_get_html_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: ctl_get_html_h.sql -- -- Author: Steve Roach -- -- Date: 24-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- interacting with the CTL objects for the get_html -- -- sub-system. -- -- -- -- Procedures: init_html_page_access -- -- Create HTML Page Access row. -- -- p_web_page IN VARCHAR2 - Local name of the web -- -- page to be initialised. Matches -- -- HTML_PAGES.NAME. -- -- p_run_no IN NUMBER - Run number of the -- -- current run. Matches -- -- MAPPING_HISTORIES.RUN_NO. -- -- -- -- html_page_access_update_status -- -- Update the status column of html_page_access. -- -- p_run_no IN NUMBER - Run number of the -- -- row to be updated. Matches -- -- MAPPING_HISTORIES.RUN_NO. -- -- p_new_status IN VARCHAR2 - Status the row to be -- -- changed to. -- -- -- -- init_html_parse_passes -- -- Create HTML Parse Passes row. -- -- p_parse_run_no IN NUMBER - Run number of the -- -- current parse run. Matches -- -- MAPPING_HISTORIES.RUN_NO. -- -- p_raw_run_no IN NUMBER - Run number of the -- -- current raw run. Matches -- -- HTML_PAGE_ACCESS.RUN_NO. -- -- -- -- html_parse_passes_update_stat -- -- Update the status column of html_parse_passes. -- -- p_parse_run_no IN NUMBER - Parse Run number of the -- -- row to be updated. Matches -- -- MAPPING_HISTORIES.RUN_NO. -- -- p_raw_run_no IN NUMBER - Run number of the -- -- raw row to be updated. Matches -- -- HTML_PAGE_ACCESS.RUN_NO. -- -- p_new_status IN VARCHAR2 - Status the row to be -- -- changed to. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE ctl_get_html AS PROCEDURE init_html_page_access ( p_web_page IN VARCHAR2 ,p_run_no IN NUMBER ); PROCEDURE html_page_access_update_status ( p_run_no IN NUMBER ,p_new_status IN VARCHAR2 ); PROCEDURE init_html_parse_passes ( p_parse_run_no IN NUMBER ,p_raw_run_no IN NUMBER ); PROCEDURE html_parse_passes_update_stat ( p_parse_run_no IN NUMBER ,p_raw_run_no IN NUMBER ,p_new_status IN VARCHAR2 ); END ctl_get_html; / SHOW ERRORS