Get HTML - Package CTL.CTL_GET_HTML Specification

• Package: ctl_get_html
• Description: Container for all procedures and functions relating to interacting with the CTL objects for the get_html sub-system.
• Procedure: init_html_page_access
• Description: Create HTML Page Access row.
• Parameters:
• p_web_page:
• Datatype: VARCHAR2
• Direction: IN
  
• Description: Local name of the web page to be accessed. Matches HTML_PAGES.NAME.
• p_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Run number of the current run. Matches MAPPING_HISTORIES.RUN_NO.
• Action:
• Create a HTML_PAGE_ACCESS row with columns based on the following criteria:
• run_no: p_run_no
  
• html_page_name: p_run_no
  
• status: FETCHING
  
• start_tsp: SYSDATE
• Procedure: html_page_access_update_status
• Description: Update the status column of html_page_access.
• Parameters:
• p_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Run number of the row to be updated. Matches MAPPING_HISTORIES.RUN_NO.
• p_new_status:
• Datatype: VARCHAR2
  
• Direction: IN
• Description: Status of the row to be changed to.
• Action:
• Get the current status.
• Check that the status change follows the sequence; FETCHING -> FETCHED -> PARSING -> PARSED. The status FAILED may be assigned at any time.
• Update html_page_access setting status to p_new status where run_no = p_run_no.
  
• Procedure: init_html_parse_passes
• Description: Create HTML Parse Passes row.
• Parameters:
• p_parse_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Run number of the current parse run. Matches MAPPING_HISTORIES.RUN_NO.
• p_raw_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Run number of the current raw run. Matches HTML_PAGE_ACCESS.RUN_NO.
• Action:
• Call html_page_access_update_status with parameters p_raw_run_no and PARSING.
  
• Create a HTML_PARSE_PASSES row with columns based on the following criteria:
• parse_run_no: p_parse_run_no
• raw_run_no: p_raw_run_no
• status: PARSING
  
• start_tsp: SYSDATE
• Procedure: html_parse_passes_update_stat
• Description: Update the status column of html_parse_passes.
• Parameters:
• p_parse_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Parse Run number of the row to be updated. Matches MAPPING_HISTORIES.RUN_NO.
• p_raw_run_no:
• Datatype: NUMBER
• Direction: IN
• Description: Run number of the raw row to be updated. Matches HTML_PAGE_ACCESS.RUN_NO.
• p_new_status:
• Datatype: VARCHAR2
  
• Direction: IN
• Description: Status of the row to be changed to.
• Action:
• Get the current status.
• Check that the status change follows the sequence; PARSING -> PARSED. The status FAILED may be assigned at any time.
• Update html_parse_passes setting status to p_new status where parse_run_no = p_parse_run_no and raw_run_no = p_raw_run_no.