Country Dimension - m_s2v_countries_h.sql

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