Control Repository - ctl_gen_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: ctl_gen_h.sql -- -- Author: Steve Roach -- -- Date: 23-AUG-2006 -- -- Version: 01.00 -- -- -- -- Description: A package header for general control procedures. -- -- -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- initialise_mapping -- -- -- -- Generate a run number for the run. Create a mapping_histories row -- -- to start the run. -- -- -- -- p_mapping IN VARCHAR2 - Mapping Name. -- -- p_run_no OUT NUMBER - Number assigned to mapping run. -- -- ------------------------------------------------------------------------ -- -- finalise_mapping -- -- -- -- Close the mapping_histories row by adding an end timestamp. -- -- -- -- p_run_no IN NUMBER - Number assigned to mapping run. -- -- ------------------------------------------------------------------------ -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 23-AUG-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE ctl_gen AS PROCEDURE initialise_mapping( p_mapping IN VARCHAR2 ,p_run_no OUT NUMBER); PROCEDURE finalise_mapping( p_run_no IN NUMBER); END ctl_gen; / SHOW ERRORS