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