[Home] [Help]
PACKAGE: APPS.PAY_PAYUSDED_XMLP_PKG
Source
1 PACKAGE PAY_PAYUSDED_XMLP_PKG 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;