PACKAGE: APPS.PQH_PQIPED5_XMLP_PKG

Source

1 PACKAGE PQH_PQIPED5_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PQIPED5S.pls 120.2 2010/04/13 12:53:06 lbodired ship $ */
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         --Bug#7033011
31 	function sumnh_opmenperreportformula(Sum_GT9_NH_OPMen in number, Sum_LT9_NH_OPMen in number) return number  ;
32 	function sumnh_opwmenperreportformula(Sum_GT9_NH_OPWmen in number, Sum_LT9_NH_OPWmen in number) return number  ;
33         function sumtmrmenperreportformula(Sum_GT9_TmRMen in number, Sum_LT9_TmRMen in number) return number  ;
34 	function sumtmrwmenperreportformula(Sum_GT9_TmRWmen in number, Sum_LT9_TmRWmen in number) return number  ;
35 
36 	function CF_GroupTotTitleFormula(SC in varchar2) return Char  ;
37 	function cf_linenogroupformula(SC in varchar2) return number  ;
38 	function BeforeReport return boolean  ;
39 	function AfterReport return boolean  ;
40 	Function line_num_p return number;
41 	Function CP_ReportTotTitle_p return varchar2;
42 	Function CP_lastLineNum_p return number;
43 	Function CP_FT_p return varchar2;
44 	Function CP_FR_p return varchar2;
45 	Function CP_PT_p return varchar2;
46 	Function CP_PR_p return varchar2;
47 END PQH_PQIPED5_XMLP_PKG;