Country Dimension - m_s2s_countries_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: m_s2s_countries_h.sql -- -- Author: Steve Roach -- -- Date: 07-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- extracting data for the countries dimension and putting it -- -- into the STA schema. -- -- -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- map - Overload 1 -- -- -- -- Wrapper to do mapping with housekeeping. -- -- ------------------------------------------------------------------------ -- -- map - Overload 2 -- -- -- -- Map PARSED_HTML to STA.S_COUNTRIES. -- -- -- -- p_run_no IN NUMBER - Run number of this map run. -- -- ------------------------------------------------------------------------- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 07-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE m_s2s_countries AS PROCEDURE map; -- Overload 1. PROCEDURE map -- Overload 2. ( p_run_no IN NUMBER ); END m_s2s_countries; / SHOW ERRORS