PACKAGE: APPS.PAY_PAYAUSOE_XMLP_PKG

Source

1 PACKAGE PAY_PAYAUSOE_XMLP_PKG AS
2 /* $Header: PAYAUSOES.pls 120.1 2008/03/26 14:04:31 amakrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_ASSIGNMENT_ID NUMBER;
8 
9   P_LOCATION_ID NUMBER;
10 
11   P_ORGANISATION_NAME VARCHAR2(60);
12 
13   P_PAYROLL_ACTION_ID NUMBER;
14 
15   P_PAYROLL_ID NUMBER;
16 
17   P_SORT_ORDER_1 VARCHAR2(32767);
18 
19   P_SORT_ORDER_2 VARCHAR2(32767);
20 
21   P_SORT_ORDER_3 VARCHAR2(32767);
22 
23   P_SORT_ORDER_4 VARCHAR2(32767);
24 
25   PRINT_LEAVE_TAKEN VARCHAR2(1) := 'N';
26 
27   PRINT_LEAVE_BALANCES VARCHAR2(1) := 'N';
28 
29   PRINT_MESSAGES VARCHAR2(1) := 'N';
30 
31   CP_ADDRESS_LINE_1 VARCHAR2(60);
32 
33   CP_ADDRESS_LINE_2 VARCHAR2(60);
34 
35   CP_ADDRESS_LINE_3 VARCHAR2(60);
36 
37   CP_POSTAL_CODE VARCHAR2(30);
38 
39   CP_TOWN_CITY VARCHAR2(30);
40 
41   CP_COUNTRY VARCHAR2(60);
42 
43   CP_PRE_TAX_DEDUCTIONS_THIS_PAY NUMBER;
44 
45   CP_DIRECT_PAYMENTS_YTD NUMBER;
46 
47   CP_TAXABLE_INCOME_YTD NUMBER;
48 
49   CP_DIRECT_PAYMENTS_THIS_PAY NUMBER;
50 
51   CP_TAXABLE_INCOME_THIS_PAY NUMBER;
52 
53   CP_PRE_TAX_DEDUCTIONS_YTD NUMBER;
54 
55   CP_NON_TAX_ALLOW_YTD NUMBER;
56 
57   CP_GROSS_THIS_PAY NUMBER;
58 
59   CP_NON_TAX_ALLOW_THIS_PAY NUMBER;
60 
61   CP_OTHER_DEDUCTIONS_THIS_PAY NUMBER;
62 
63   CP_TAX_DEDUCTIONS_THIS_PAY NUMBER;
64 
65   CP_GROSS_YTD NUMBER;
66 
67   CP_OTHER_DEDUCTIONS_YTD NUMBER;
68 
69   CP_TAX_DEDUCTIONS_YTD NUMBER;
70 
71   CP_START_DATE DATE;
72 
73   CP_END_DATE DATE;
74 
75   CP_ACCRUAL_END_DATE DATE;
76 
77   CP_ACCRUAL NUMBER;
78 
79   CP_NET_ENTITLEMENT NUMBER;
80 
81   CP_WHERE_CLAUSE VARCHAR2(2000);
82 
83   CP_ORDER_BY VARCHAR2(2000);
84 
85   FUNCTION AFTERREPORT RETURN BOOLEAN;
86 
87   FUNCTION BEFOREREPORT RETURN BOOLEAN;
88 
89   FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA RETURN VARCHAR2;
90 
91   FUNCTION CF_NET_ACCRUALFORMULA(LEAVE_BALANCE_ABSENCE_TYPE IN VARCHAR2
92                                 ,ASSIGNMENT_ACTION_ID_LB IN NUMBER
93                                 ,ASSIGNMENT_ID_LB IN NUMBER
94                                 ,PAYROLL_ID_LB IN NUMBER
95                                 ,BUSINESS_GROUP_ID_LB IN NUMBER
96                                 ,ACCRUAL_PLAN_ID_LB IN NUMBER
97                                 ,PERIOD_END_DATE IN DATE) RETURN NUMBER;
98 
99   PROCEDURE CONSTRUCT_WHERE_CLAUSE;
100 
101   PROCEDURE CONSTRUCT_ORDER_BY;
102 
103   FUNCTION CF_NET_THIS_PAYFORMULA RETURN NUMBER;
104 
105   FUNCTION CF_NET_YTDFORMULA RETURN NUMBER;
106 
107   FUNCTION CF_GET_MISCELLANEOUS_VALUESFOR(EXPENSE_CHECK_SEND_TO_ADDRESS IN VARCHAR2
108                                          ,PERSON_ID IN NUMBER
109                                          ,LOCATION_ID IN NUMBER
110                                          ,ASSIGNMENT_ID IN NUMBER
111                                          ,ASSIGNMENT_ACTION_ID IN NUMBER
112                                          ,DATE_EARNED IN DATE) RETURN NUMBER;
113 
114   FUNCTION CF_HOURS_FORMAT_MASKFORMULA RETURN CHAR;
115 
116   FUNCTION CF_CHANGE_PRINT_MESSAGESFORMUL(PAY_ADVICE_MESSAGE IN VARCHAR2) RETURN NUMBER;
117   FUNCTION CF_GRADE_STEPFORMULA(ASSIGNMENT_ID IN NUMBER
118                                ,DATE_EARNED IN DATE) RETURN NUMBER;
119 
120   FUNCTION CF_CHANGE_PRINT_LEAVE_TAKENFOR RETURN NUMBER;
121 
122   FUNCTION CF_CHANGE_PRINT_LEAVE_BALANCES RETURN NUMBER;
123 
124   PROCEDURE SET_PRINT_FLAGS;
125 
126   --FUNCTION CF_PERIOD_START_DATEFORMULA(ASSIGNMENT_ACTION_ID IN NUMBER) RETURN DATE;
127   FUNCTION CF_PERIOD_START_DATEFORMULA(ASSIGNMENT_ACTION_ID_V IN NUMBER) RETURN DATE ;
128   FUNCTION CP_ADDRESS_LINE_1_P RETURN VARCHAR2;
129 
130   FUNCTION CP_ADDRESS_LINE_2_P RETURN VARCHAR2;
131 
132   FUNCTION CP_ADDRESS_LINE_3_P RETURN VARCHAR2;
133 
134   FUNCTION CP_POSTAL_CODE_P RETURN VARCHAR2;
135 
136   FUNCTION CP_TOWN_CITY_P RETURN VARCHAR2;
137 
138   FUNCTION CP_COUNTRY_P RETURN VARCHAR2;
139 
140   FUNCTION CP_PRE_TAX_DEDUCTIONS_THIS_PA RETURN NUMBER;
141 
142   FUNCTION CP_DIRECT_PAYMENTS_YTD_P RETURN NUMBER;
143 
144   FUNCTION CP_TAXABLE_INCOME_YTD_P RETURN NUMBER;
145 
146   FUNCTION CP_DIRECT_PAYMENTS_THIS_PAY_P RETURN NUMBER;
147 
148   FUNCTION CP_TAXABLE_INCOME_THIS_PAY_P RETURN NUMBER;
149 
150   FUNCTION CP_PRE_TAX_DEDUCTIONS_YTD_P RETURN NUMBER;
151 
152   FUNCTION CP_NON_TAX_ALLOW_YTD_P RETURN NUMBER;
153 
154   FUNCTION CP_GROSS_THIS_PAY_P RETURN NUMBER;
155 
156   FUNCTION CP_NON_TAX_ALLOW_THIS_PAY_P RETURN NUMBER;
157 
158   FUNCTION CP_OTHER_DEDUCTIONS_THIS_PAY_P RETURN NUMBER;
159 
160   FUNCTION CP_TAX_DEDUCTIONS_THIS_PAY_P RETURN NUMBER;
161 
162   FUNCTION CP_GROSS_YTD_P RETURN NUMBER;
163 
164   FUNCTION CP_OTHER_DEDUCTIONS_YTD_P RETURN NUMBER;
165 
166   FUNCTION CP_TAX_DEDUCTIONS_YTD_P RETURN NUMBER;
167 
168   FUNCTION CP_START_DATE_P RETURN DATE;
169 
170   FUNCTION CP_END_DATE_P RETURN DATE;
171 
172   FUNCTION CP_ACCRUAL_END_DATE_P RETURN DATE;
173 
174   FUNCTION CP_ACCRUAL_P RETURN NUMBER;
175 
176   FUNCTION CP_NET_ENTITLEMENT_P RETURN NUMBER;
177 
178   FUNCTION CP_WHERE_CLAUSE_P RETURN VARCHAR2;
179 
180   FUNCTION CP_ORDER_BY_P RETURN VARCHAR2;
181 
182 END PAY_PAYAUSOE_XMLP_PKG;