Country Dimension - m_o2w_countries_h.sql

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