1 PACKAGE PQH_PQIPED5_XMLP_PKG AS
2 /* $Header: PQIPED5S.pls 120.1 2007/12/21 17:27:59 vjaganat noship $ */
3 P_BUSINESS_GROUP_ID varchar2(40);
4 P_CONC_REQUEST_ID number;
5 P_REPORT_DATE date;
6 line_num number := 2 ;
7 CP_ReportTotTitle varchar2(50) := 'Part A Total (sum of lines 1 ,9,17)' ;
8 CP_lastLineNum number := 18 ;
9 CP_FT varchar2(2000);
10 CP_FR varchar2(2000);
11 CP_PT varchar2(2000);
12 CP_PR varchar2(2000);
13 function CF_1Formula return Number ;
14 function sumnrmenperreportformula(Sum_GT9_NRMen in number, Sum_LT9_NRMen in number) return number ;
15 function sumnrwmenperreportformula(Sum_GT9_NRWmen in number, Sum_Lt9_NRWmen in number) return number ;
16 function sumbnhmenperreportformula(Sum_GT9_BnHMen in number, Sum_LT9_BnhMen in number) return number ;
17 function sumbnhwmenperreportformula(Sum_GT9_BnHWmen in number, Sum_LT9_BnHWmen in number) return number ;
18 function sumam_almenperreportformula(Sum_GT9_Am_AlMen in number, Sum_LT9_Am_AlMen in number) return number ;
19 function sumam_alwmenperreportformula(Sum_GT9_Am_AlWmen in number, Sum_LT9_Am_AlWmen in number) return number ;
20 function sumapmenperreportformula(Sum_GT9_A_PMen in number, Sum_LT9_APMen in number) return number ;
21 function sumapwmenperreportformula(Sum_GT9_A_PWmen in number, Sum_LT9_APWmen in number) return number ;
22 function sumhmenperreportformula(Sum_GT9_HMen in number, Sum_Lt9_HMen in number) return number ;
23 function sumhwmenperreportformula(Sum_GT9_HWmen in number, Sum_LT9_HWmen in number) return number ;
24 function sumwnhmenperreportformula(Sum_GT9_WnHMen in number, Sum_LT9_WnHMen in number) return number ;
25 function sumwnhwmenperreportformula(Sum_GT9_WnHWmen in number, Sum_LT9_WnHWmen in number) return number ;
26 function sumurmenperreportformula(Sum_GT9_URMen in number, Sum_LT9_URMen in number) return number ;
27 function sumurwmenperreportformula(Sum_GT9_URWmen in number, Sum_LT9_URWmen in number) return number ;
28 function sumtotmenperreportformula(Sum_GT9_totMen in number, Sum_LT9_TotMen in number) return number ;
29 function sumtotwmenperreportformula(Sum_GT9_TotWmen in number, Sum_LT9_TotWmen in number) return number ;
30 function CF_GroupTotTitleFormula(SC in varchar2) return Char ;
31 function cf_linenogroupformula(SC in varchar2) return number ;
32 function BeforeReport return boolean ;
33 function AfterReport return boolean ;
34 Function line_num_p return number;
35 Function CP_ReportTotTitle_p return varchar2;
36 Function CP_lastLineNum_p return number;
37 Function CP_FT_p return varchar2;
38 Function CP_FR_p return varchar2;
39 Function CP_PT_p return varchar2;
40 Function CP_PR_p return varchar2;
41 END PQH_PQIPED5_XMLP_PKG;