The following lines contain the word 'select', 'insert', 'update' or 'delete':
delete any data in the DB.
Now the EOY Process is
aborted if one of the child
process has an error.
30/07/96 J.Alloun Added error handling.
05/08/96 aswong Added exit at the end.
07/10/99 P Davies Changed each occurrence of
DBMS_Output.Put_Line with
hr_utility.trace.
*/
PROCEDURE eoy_control( ERRBUF OUT VARCHAR2
,RETCODE OUT NUMBER
,p_permit_no IN VARCHAR2
,p_tax_year IN NUMBER
,p_eoy_mode IN VARCHAR2
,p_business_group_id IN NUMBER
,p_tax_dist_ref IN VARCHAR2
,p_sort_order1 IN VARCHAR2
,p_sort_order2 IN VARCHAR2
,p_sort_order3 IN VARCHAR2
,p_sort_order4 IN VARCHAR2
,p_sort_order5 IN VARCHAR2
,p_sort_order6 IN VARCHAR2
,p_sort_order7 IN VARCHAR2
,p_align IN VARCHAR2
,p_ni_y_flag In VARCHAR2) IS
--
-- This procedure controls the execution of the EOY process.
-- The extract is called first followed by the mag tape process,
-- the p35 listing and, only if the full eoy mode is set, the p60
-- report is run last.
--
l_extract_id NUMBER;