PACKAGE: APPS.PAY_PAYCNSOE_XMLP_PKG

Source

1 PACKAGE PAY_PAYCNSOE_XMLP_PKG AS
2 /* $Header: PAYCNSOES.pls 120.1 2008/01/07 13:13:51 srikrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_CONC_REQUEST_ID	number;
5 	P_PAYROLL_ID	varchar2(40);
6 	P_CONSOLIDATION_SET_ID	varchar2(40);
7 	P_PAYOUT_LOCATION	varchar2(40);
8 	/*P_START_DATE	date;
9 	P_END_DATE	date;*/
10 	P_START_DATE	varchar2(40);
11 	P_END_DATE	varchar2(40);
12 	/* ADDED as fix:*/
13 	P_START_DATE_t	date;
14 	P_END_DATE_t	date;
15 	P_START_DATE_DISP varchar2(40);
16 	P_END_DATE_DISP varchar2(40);
17 	P_SORT_ORDER_1	varchar2(40);
18 	P_SORT_ORDER_2	varchar2(40);
19 	P_SORT_ORDER_3	varchar2(40);
20 	P_SORT_ORDER_4	varchar2(40);
21 	CP_Taxable_This_Pay	number;
22 	CP_Taxable_YTD	number;
23 	CP_Non_Taxable_This_Pay	number;
24 	CP_Non_Taxable_YTD	number;
25 	CP_Voluntary_This_Pay	number;
26 	CP_Voluntary_YTD	number;
27 	CP_Statutory_This_Pay	number;
28 	CP_Statutory_YTD	number;
29 	CP_ORDER_BY	varchar2(200);
30 	CP_Payroll_name	varchar2(100);
31 	CP_Consolidation_Set_name	varchar2(100);
32 	CP_Payroll_Location	varchar2(100);
33 	CP_Business_Group_name	varchar2(100);
34 	CP_Start_Date	date;
35 	CP_End_date	date;
36 	CP_Sort_Order_1	varchar2(40);
37 	CP_Sort_Order_2	varchar2(40);
38 	CP_Sort_Order_3	varchar2(40);
39 	CP_Sort_Order_4	varchar2(40);
40 	function BeforeReport return boolean  ;
41 	function AfterReport return boolean  ;
42 	function CF_business_groupFormula return VARCHAR2  ;
43 	function CF_legislation_codeFormula return VARCHAR2  ;
44 	function cf_currency_format_maskformula(cf_legislation_code in varchar2) return varchar2  ;
45 	PROCEDURE set_currency_format_mask  ;
46 	function P_BUSINESS_GROUP_IDValidTrigge return boolean  ;
47 	function CF_Net_This_PayFormula return Number  ;
48 	function CF_Net_YTDFormula return Number  ;
49 	function cf_balancesformula(balance_org_name in varchar2, balances_this_Pay in number, balances_YTD in number) return number  ;
50 	PROCEDURE construct_order_by  ;
51 	PROCEDURE get_parameters_name  ;
52 	Function CP_Taxable_This_Pay_p return number;
53 	Function CP_Taxable_YTD_p return number;
54 	Function CP_Non_Taxable_This_Pay_p return number;
55 	Function CP_Non_Taxable_YTD_p return number;
56 	Function CP_Voluntary_This_Pay_p return number;
57 	Function CP_Voluntary_YTD_p return number;
58 	Function CP_Statutory_This_Pay_p return number;
59 	Function CP_Statutory_YTD_p return number;
60 	Function CP_ORDER_BY_p return varchar2;
61 	Function CP_Payroll_name_p return varchar2;
62 	Function CP_Consolidation_Set_name_p return varchar2;
63 	Function CP_Payroll_Location_p return varchar2;
64 	Function CP_Business_Group_name_p return varchar2;
65 	Function CP_Start_Date_p return date;
66 	Function CP_End_date_p return date;
67 	Function CP_Sort_Order_1_p return varchar2;
68 	Function CP_Sort_Order_2_p return varchar2;
69 	Function CP_Sort_Order_3_p return varchar2;
70 	Function CP_Sort_Order_4_p return varchar2;
71 END PAY_PAYCNSOE_XMLP_PKG;