PACKAGE: APPS.PAY_PAYJPFLI_XMLP_PKG

Source

1 PACKAGE PAY_PAYJPFLI_XMLP_PKG AS
2 /* $Header: PAYJPFLIS.pls 120.0 2007/12/13 11:59:48 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_FISCAL_YEAR	number;
5 	P_ORGANIZATION_ID	number;
6 	P_CONC_REQUEST_ID	number;
7 	CP_SALARY_CATEGORY	varchar2(8);
8 	CP_TARGET_YEAR	number;
9 	CP_TARGET_MONTH	number;
10 	CP_WAI_COUNT	number;
11 	CP_WAI_SAL_AMT	number;
12 	CP_UI_COUNT	number;
13 	CP_UI_SAL_AMT	number;
14 	CP_REPORT_TITLE	varchar2(255);
15 	CP_WAI_SAL_AMT_SUM	number;
16 	CP_UI_SAL_AMT_SUM	number;
17 	CP_UI_AGED_SAL_AMT_SUM	number;
18 	CP_UI_NET_SAL_AMT_SUM	number;
19 	CP_WAI_COUNT_SALARY_AVG	number;
20 	CP_UI_COUNT_SALARY_AVG	number;
21 	CP_UI_AGED_COUNT_SALARY_AVG	number;
22 	CP_WAI_COUNT_SALARY_SUM	number := 0 ;
23 	CP_UI_COUNT_SALARY_SUM	number := 0 ;
24 	CP_UI_AGED_COUNT_SALARY_SUM	number := 0 ;
25 	CP_NUM_OF_SALARY_MONTHS	number := 0 ;
26 	function cf_li_dummyformula(SALARY_CATEGORY in varchar2, TARGET_MONTH in varchar2, WAI_EE_COUNT in number, WAI_EX_COUNT in number, WAI_TW_COUNT in number,
27 	WAI_EE_SAL_AMT in number, WAI_EX_SAL_AMT in number, WAI_TW_SAL_AMT in number, UI_EE_COUNT in number, UI_EX_COUNT in number, UI_EE_SAL_AMT in number, UI_EX_SAL_AMT in number, UI_AGED_COUNT in number) return number  ;
28 	function BeforeReport return boolean  ;
29 	function cf_report_dummyformula(CS_CP_WAI_SAL_AMT_SUM in number, CS_CP_UI_SAL_AMT_SUM in number, CS_UI_AGED_SAL_AMT_SUM in number) return number  ;
30 	function AfterReport return boolean  ;
31 	Function CP_SALARY_CATEGORY_p return varchar2;
32 	Function CP_TARGET_YEAR_p return number;
33 	Function CP_TARGET_MONTH_p return number;
34 	Function CP_WAI_COUNT_p return number;
35 	Function CP_WAI_SAL_AMT_p return number;
36 	Function CP_UI_COUNT_p return number;
37 	Function CP_UI_SAL_AMT_p return number;
38 	Function CP_REPORT_TITLE_p return varchar2;
39 	Function CP_WAI_SAL_AMT_SUM_p return number;
40 	Function CP_UI_SAL_AMT_SUM_p return number;
41 	Function CP_UI_AGED_SAL_AMT_SUM_p return number;
42 	Function CP_UI_NET_SAL_AMT_SUM_p return number;
43 	Function CP_WAI_COUNT_SALARY_AVG_p return number;
44 	Function CP_UI_COUNT_SALARY_AVG_p return number;
45 	Function CP_UI_AGED_COUNT_SALARY_AVG_p return number;
46 	Function CP_WAI_COUNT_SALARY_SUM_p return number;
47 	Function CP_UI_COUNT_SALARY_SUM_p return number;
48 	Function CP_UI_AGED_COUNT_SALARY_SUM_p return number;
49 	Function CP_NUM_OF_SALARY_MONTHS_p return number;
50 END PAY_PAYJPFLI_XMLP_PKG;