PACKAGE: APPS.PAY_PAYUSDED_XMLP_PKG

Source

1 PACKAGE PAY_PAYUSDED_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYUSDEDS.pls 120.0 2007/12/28 06:44:29 srikrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE	date;
5 	P_REPORT_TITLE	varchar2(60);
6 	P_CONC_REQUEST_ID	number;
7 	P_CONSOLIDATION_SET_ID	number;
8 	P_PAYROLL_ID	number;
9 	P_START_DATE	date;
10 	P_END_DATE	date;
11 	P_ELEMENT_TYPE_ID	number;
12 	P_SORT_OPTION1	varchar2(32767);
13 	P_SORT_OPTION2	varchar2(32767);
14 	P_SORT_OPTION3	varchar2(32767);
15 	P_TAX_UNIT_ID	number;
16 	P_LOCATION_ID	number;
17 	P_ORGANIZATION_ID	number;
18 	P_PERSON_ID	number;
19 	P_CLASSIFICATION_ID	number;
20 	P_ELEMENT_SET_ID	number;
21 	P_SELECTION_CRITERION	varchar2(30);
22 	P_where_clause	varchar2(4000) := ' ' ;
23 	P_hint	varchar2(1000);
24 	C_BUSINESS_GROUP_NAME	varchar2(240);
25 	C_REPORT_SUBTITLE	varchar2(60);
26 	C_Consolidation_set	varchar2(60);
27 	C_Payroll	varchar2(80);
28 	C_Classification	varchar2(80);
29 	C_Element_name	varchar2(80);
30 	C_GRE	varchar2(240);
31 	C_Location	varchar2(60);
32 	C_Organization	varchar2(240);
33 	C_Person	varchar2(240);
34 	C_ELEMENT_SET	varchar2(50);
35 	function BeforeReport return boolean  ;
36 	function C_REPORT_SUBTITLEFormula return VARCHAR2  ;
37 	function scheduled_dednformula(primary_balance in number, not_taken_balance in number, arrears_taken in number) return number  ;
38 	function current_arrearsformula(arrears_balance in number) return number  ;
39 	function arrears_takenformula(arrears_balance in number) return number  ;
40 	function remainingformula(total_owed in number, CF_Accrued in number) return number  ;
41 	function element_total_textformula(element_name in varchar2) return varchar2  ;
42 	function classification_total_textformu(classification_name in varchar2) return varchar2  ;
43 	function s3_total_textformula(sort_option1_value in varchar2, sort_option2_value in varchar2, sort_option3_value in varchar2) return varchar2  ;
44 	function s2_total_textformula(sort_option1_value in varchar2, sort_option2_value in varchar2) return varchar2  ;
45 	function s1_total_textformula(sort_option1_value in varchar2) return varchar2  ;
46 	function person_total_textformula(full_name in varchar2) return varchar2  ;
47 	function cf_sort1formula(Sort_option1 in varchar2) return varchar2  ;
48 	function cf_sort2formula(Sort_option2 in varchar2) return varchar2  ;
49 	function cf_sort3formula(Sort_option3 in varchar2) return varchar2  ;
50 	function cf_sort1_valueformula(Sort_option1_value in varchar2) return varchar2  ;
51 	function cf_sort2_valueformula(Sort_option2_value in varchar2) return varchar2  ;
52 	function cf_sort3_valueformula(Sort_option3_value in varchar2) return varchar2  ;
53 	function cf_accruedformula(accrued_balance in varchar2, Primary_balance in number, Total_owed in number) return number  ;
54 	function s3_textformula(sort_option1_value in varchar2, Sort_option1 in varchar2, sort_option2_value in varchar2, Sort_option2 in varchar2, sort_option3_value in varchar2, Sort_option3 in varchar2) return varchar2  ;
55 	function AfterPForm return boolean  ;
56 	function AfterReport return boolean  ;
57 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
58 	Function C_REPORT_SUBTITLE_p return varchar2;
59 	Function C_Consolidation_set_p return varchar2;
60 	Function C_Payroll_p return varchar2;
61 	Function C_Classification_p return varchar2;
62 	Function C_Element_name_p return varchar2;
63 	Function C_GRE_p return varchar2;
64 	Function C_Location_p return varchar2;
65 	Function C_Organization_p return varchar2;
66 	Function C_Person_p return varchar2;
67 	Function C_ELEMENT_SET_p return varchar2;
68 END PAY_PAYUSDED_XMLP_PKG;