1 PACKAGE PQH_PQIPED10_XMLP_PKG AS
2 /* $Header: PQIPED10S.pls 120.1 2007/12/21 17:26:39 vjaganat noship $ */
3 P_BUSINESS_GROUP_ID varchar2(40);
4 P_CONC_REQUEST_ID number;
5 P_REPORT_DATE date;
6 CP_FR varchar2(2000);
7 CP_FT varchar2(2000);
8 CP_PR varchar2(2000);
9 CP_PT varchar2(2000);
10 line_num number := 2 ;
11 LastLineNo number := 10 ;
12 totTitle varchar2(52) := 'Total Full-Time Employees (sum of lines 1,3-9)' ;
13 function cf_1formula(SUMNRMenNonInstr in number, Sum_Instr_NRMen in number) return number ;
14 function cf_2formula(SUMNRWMenNonInstr in number, Sum_Instr_NRWMen in number) return number ;
15 function cf_3formula(SUMBnHMenNonInstr in number, Sum_Instr_BnHMen in number) return number ;
16 function cf_4formula(SUMBnHWMenNonInstr in number, Sum_Instr_BnHWMen in number) return number ;
17 function cf_4formula0004(SUMAm_AlMenNonInstr in number, Sum_Instr_Am_AlMen in number) return number ;
18 function cf_sumam_alwmenformula(SUMAm_AlWMenNonInstr in number, Sum_Instr_Am_AlWMen in number) return number ;
19 function cf_sumapmenformula(SUMAPMenNonInstr in number, Sum_Instr_APMen in number) return number ;
20 function cf_sumapwmenformula(SUMAPWmenNonInstr in number, Sum_Instr_APWmen in number) return number ;
21 function cf_sumhmenformula(SUMHMenNonInstr in number, Sum_Instr_HMen in number) return number ;
22 function cf_sumhwmenformula(SUMHWMenNonInstr in number, Sum_Instr_HWMen in number) return number ;
23 function cf_sumwnhmenformula(SUMWnHMenNonInstr in number, Sum_Instr_WnHMen in number) return number ;
24 function cf_sumwnhwmenformula(SUMWnHWMenNonInstr in number, Sum_Instr_WnHWMen in number) return number ;
25 function cf_sumurmenformula(SUMURMenNonInstr in number, Sum_Instr_URMen in number) return number ;
26 function cf_sumurwmenformula(SUMURWMenNonInstr in number, Sum_Instr_URWMen in number) return number ;
27 function cf_totmenformula(SUMTotMenNonInstr in number, Sum_Instr_TotMen in number) return number ;
28 function cf_11formula(SUMTotWMenNonInstr in number, Sum_Instr_TotWMen in number) return number ;
29 function BeforeReport return boolean ;
30 function line_noFormula return Number ;
31 function AfterReport return boolean ;
32 Function CP_FR_p return varchar2;
33 Function CP_FT_p return varchar2;
34 Function CP_PR_p return varchar2;
35 Function CP_PT_p return varchar2;
36 Function line_num_p return number;
37 Function LastLineNo_p return number;
38 Function totTitle_p return varchar2;
39 END PQH_PQIPED10_XMLP_PKG;