Country Dimension - m_v2o_countries_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: m_v2o_countries_h.sql -- -- Author: Steve Roach -- -- Date: 26-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- mapping data for the Countries Dimension from VAL to ODS. -- -- -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- map - Overload 1 -- -- -- -- Wrapper to do mapping with housekeeping. -- -- ------------------------------------------------------------------------ -- -- map - Overload 2 -- -- -- -- Map VAL.V_COUNTRIES to ODS.COUNTRIES. -- -- -- -- p_run_no IN NUMBER - Run number of this map run. -- -- ------------------------------------------------------------------------- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 26-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE m_v2o_countries AS PROCEDURE map; -- Overload 1. PROCEDURE map -- Overload 2. ( p_run_no IN NUMBER ); END m_v2o_countries; / SHOW ERRORS