1 PACKAGE PQH_PQIPED7_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQIPED7S.pls 120.3 2010/04/13 12:56:11 lbodired ship $ */
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 -- Bug#7033011
31 function cf_sumnh_opmenformula(SUMNH_OPMenNonInstr in number, Sum_Instr_NH_OPMen in number) return number ;
32 function cf_sumnh_opwmenformula(SUMNH_OPWMenNonInstr in number, Sum_Instr_NH_OPWMen in number) return number ;
33 function cf_sumtmrmenformula(SUMTmRMenNonInstr in number, Sum_Instr_TmRMen in number) return number ;
34 function cf_sumtmrwmenformula(SUMTmRWMenNonInstr in number, Sum_Instr_TmRWMen in number) return number ;
35 function BeforeReport return boolean ;
36 function line_noFormula return Number ;
37 function AfterReport return boolean ;
38 Function CP_FR_p return varchar2;
39 Function CP_FT_p return varchar2;
40 Function CP_PR_p return varchar2;
41 Function CP_PT_p return varchar2;
42 Function line_num_p return number;
43 Function LastLineNo_p return number;
44 Function totTitle_p return varchar2;
45 END PQH_PQIPED7_XMLP_PKG;
[Home] [Help]