[Home] [Help]
PACKAGE: APPS.PAY_PYAURECD_XMLP_PKG
Source
1 PACKAGE PAY_PYAURECD_XMLP_PKG AS
2 /* $Header: PYAURECDS.pls 120.0 2007/12/13 11:58:04 amakrish noship $ */
3
4 P_BUSINESS_GROUP_ID NUMBER;
5
6 P_CONC_REQUEST_ID NUMBER;
7
8 ORDERBY_CLAUSE VARCHAR2(200);
9
10 P_ASSIGNMENT_ID NUMBER;
11
12 P_EMPLOYEE_TYPE VARCHAR2(1);
13
14 P_END_DATE DATE;
15
16 P_NEGATIVE_RECORDS VARCHAR2(32767);
17
18 P_ORGANIZATION_ID NUMBER;
19
20 P_PAYROLL_ACTION_ID NUMBER;
21
22 P_PAYROLL_ID NUMBER;
23
24 P_PAYROLL_RUN_ID VARCHAR2(32767);
25
26 P_PERIOD_END_DATE DATE;
27
28 P_REGISTERED_EMPLOYER NUMBER;
29
30 P_SORT_ORDER_1 VARCHAR2(32767);
31
32 P_SORT_ORDER_2 VARCHAR2(32767);
33
34 P_SORT_ORDER_3 VARCHAR2(32767);
35
36 P_SORT_ORDER_4 VARCHAR2(32767);
37
38 P_START_DATE DATE;
39
40 P_YTD_TOTALS VARCHAR2(32767);
41
42 P_ZERO_RECORDS VARCHAR2(32767);
43
44 P_PAYSUM_FLAG VARCHAR2(32767);
45
46 P_LST_YEAR_TERM VARCHAR2(32767);
47
48 P_DELETE_ACTIONS VARCHAR2(3);
49
50 CP_TAXABLE_EARNINGS NUMBER;
51
52 CP_NON_TAXABLE_EARNINGS NUMBER;
53
54 CP_DEDUCTIONS NUMBER;
55
56 CP_PRE_TAX_DEDUCTIONS NUMBER;
57
58 CP_DIRECT_PAYMENTS NUMBER;
59
60 CP_TAX NUMBER;
61
62 CP_GROSS_EARNINGS NUMBER;
63
64 CP_NET_PAYMENT NUMBER;
65
66 CP_YTD_TAXABLE_EARNINGS NUMBER;
67
68 CP_YTD_NON_TAXABLE_EARNINGS NUMBER;
69
70 CP_YTD_GROSS_EARNINGS NUMBER;
71
72 CP_YTD_PRE_TAX_DEDUCTIONS NUMBER;
73
74 CP_YTD_DIRECT_PAYMENTS NUMBER;
75
76 CP_YTD_DEDUCTIONS NUMBER;
77
78 CP_YTD_TAX NUMBER;
79
80 CP_YTD_NET_PAYMENT NUMBER;
81
82 CP_EMP_CHG NUMBER;
83
84 CP_YTD_EMP_CHG NUMBER;
85
86 CP_END_REPORT VARCHAR2(50) := 'End of Report';
87
88 CP_NO_DATA_FOUND VARCHAR2(50) := 'No Data Found';
89
90 CP_PS_WORKPLACE_GIVING NUMBER;
91
92 CP_MAN_PS_WORKPLACE_GIVING NUMBER;
93
94 CP_PS_PAYSUM_GROSS NUMBER;
95
96 CP_MAN_PS_PAYSUM_GROSS NUMBER;
97
98 CP_PS_REP_ALLOWANCES NUMBER;
99
100 CP_MAN_PS_REP_ALLOWANCES NUMBER;
101
102 CP_PS_ETP NUMBER;
103
104 CP_MAN_PS_ETP NUMBER;
105
106 CP_PS_RFB NUMBER;
107
108 CP_MAN_PS_RFB NUMBER;
109
110 CP_PS_ASSESSABLE_ETP NUMBER;
111
112 CP_MAN_PS_ASSESSABLE_ETP NUMBER;
113
114 CP_PS_CDEP NUMBER;
115
116 CP_MAN_PS_CDEP NUMBER;
117
118 CP_PS_OTHER_INCOME NUMBER;
119
120 CP_MAN_PS_OTHER_INCOME NUMBER;
121
122 CP_PS_UNION_FEES NUMBER;
123
124 CP_MAN_PS_UNION_FEES NUMBER;
125
126 CP_PS_LUMPSUM_PAYMENTS NUMBER;
127
128 CP_MAN_PS_LUMPSUM_PAYMENTS NUMBER;
129
130 CP_PRINTED_COUNT NUMBER;
131
132 CP_MANUAL_COUNT NUMBER;
133
134 /*added as fix:*/
135 LP_PAYROLL_ACTION_ID number;
136 LP_BUSINESS_GROUP_ID number;
137 LP_ORGANIZATION_ID number;
138 LP_PAYROLL_ID number;
139 LP_REGISTERED_EMPLOYER number;
140 LP_ASSIGNMENT_ID number;
141 LP_START_DATE date;
142 LP_END_DATE date;
143 LP_PAYROLL_RUN_ID varchar2(100);
144 LP_PERIOD_END_DATE date;
145 LP_EMPLOYEE_TYPE varchar2(100);
146 LP_START_DATE_D VARCHAR2(100);
147 LP_END_DATE_D VARCHAR2(100);
148 LP_PERIOD_END_DATE_D VARCHAR2(100);
149 LP_YTD_TOTALS varchar2(100);
150 LP_ZERO_RECORDS varchar2(100);
151 LP_NEGATIVE_RECORDS varchar2(100);
152 LP_SORT_ORDER_1 varchar2(100);
153 LP_SORT_ORDER_2 varchar2(100);
154 LP_SORT_ORDER_3 varchar2(100);
155 LP_SORT_ORDER_4 varchar2(100);
156 LP_PAYSUM_FLAG varchar2(100);
157 LP_LST_YEAR_TERM varchar2(100);
158 LP_DELETE_ACTIONS varchar2(100) := 'Y';
159 /*fix ends*/
160 FUNCTION BEFOREREPORT RETURN BOOLEAN;
161
162 FUNCTION AFTERREPORT RETURN BOOLEAN;
163
164 FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
165
166 FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2;
167
168 FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
169
170 PROCEDURE SET_CURRENCY_FORMAT_MASK;
171
172 FUNCTION P_BUSINESS_GROUP_IDVALIDTRIGGE RETURN BOOLEAN;
173
174 FUNCTION CF_EMPLOYEE_TYPE_DISPLAYFORMUL RETURN CHAR;
175
176 FUNCTION CF_EMP_DISPLAYFORMULA RETURN CHAR;
177
178 FUNCTION CF_LEG_EMP_DISPLAYFORMULA RETURN CHAR;
179
180 FUNCTION CF_NEG_RECORDS_DISPLAYFORMULA RETURN CHAR;
181
182 FUNCTION CF_NO_DATA_END_REPORTFORMULA(CS_DATA_EXISTS IN NUMBER) RETURN CHAR;
183
184 FUNCTION CF_ORG_ID_DISPLAYFORMULA RETURN CHAR;
185
186 FUNCTION CF_PAYROLL_NAMEFORMULA RETURN VARCHAR2;
187
188 FUNCTION CF_PAYROLL_RUN_DISPLAYFORMUL RETURN CHAR;
189
190 FUNCTION CF_PERIOD_PAYROLLFORMULA(CF_PAYROLL_RUN_DISPLAY IN VARCHAR2) RETURN CHAR;
191
192 FUNCTION CF_YTD_TOTALS_DISPLAYFORMULA RETURN CHAR;
193
194 FUNCTION CF_ZERO_RECORDS_DISPLAYFORMULA RETURN CHAR;
195
196 FUNCTION CF_RETURN_BALANCESFORMULA(CS_ASG_TAXABLE_EARNINGS IN NUMBER
197 ,CS_ASG_NON_TAX_EARNINGS IN NUMBER
198 ,CS_ASG_DEDUCTIONS IN NUMBER
199 ,CS_ASG_TAX IN NUMBER
200 ,CS_ASG_NET_PAYMENT_RUN IN NUMBER
201 ,CS_ASG_EMP_CHG IN NUMBER
202 ,CS_ASG_GROSS_EARNINGS IN NUMBER
203 ,CS_ASG_PRE_TAX_DEDUCTIONS IN NUMBER
204 ,CS_ASG_DIRECT_PAYMENTS IN NUMBER
205 ,CS_ASG_YTD_GROSS_EARNINGS IN NUMBER
206 ,CS_ASG_YTD_PRE_TAX_DEDUCTIONS IN NUMBER
207 ,CS_ASG_YTD_DIRECT_PAYMENTS IN NUMBER
208 ,CS_ASG_YTD_TAX_EARN IN NUMBER
209 ,CS_ASG_YTD_NON_TAX IN NUMBER
210 ,CS_ASG_YTD_DEDUCTIONS IN NUMBER
211 ,CS_ASG_YTD_TAX IN NUMBER
212 ,CS_ASG_YTD_NET_PAY IN NUMBER
213 ,CS_ASG_YTD_EMP_CHG IN NUMBER
214 ,MANUAL_PS_ISSUED IN VARCHAR2
215 ,CS_PS_PAYSUM_GROSS IN NUMBER
216 ,CS_PS_WORKPLACE_GIVING IN NUMBER
217 ,CS_PS_REP_ALLOWANCES IN NUMBER
218 ,CS_PS_ETP IN NUMBER
219 ,CS_PS_RFB IN NUMBER
220 ,CS_PS_ASSESSABLE_ETP IN NUMBER
221 ,CS_PS_CDEP IN NUMBER
222 ,CS_PS_OTHER_INCOME IN NUMBER
223 ,CS_PS_UNION_FEES IN NUMBER
224 ,CS_PS_LUMPSUM_PAYMENTS IN NUMBER) RETURN NUMBER;
225
226 FUNCTION CF_FIN_YEAR_DISPLAYFORMULA RETURN CHAR;
227
228 FUNCTION CF_LST_YEAR_TERM_DISPLAYFORMUL RETURN CHAR;
229
230 FUNCTION CF_TITLE_DISPLAYFORMULA RETURN CHAR;
231
232 FUNCTION CP_TAXABLE_EARNINGS_P RETURN NUMBER;
233
234 FUNCTION CP_NON_TAXABLE_EARNINGS_P RETURN NUMBER;
235
236 FUNCTION CP_DEDUCTIONS_P RETURN NUMBER;
237
238 FUNCTION CP_PRE_TAX_DEDUCTIONS_P RETURN NUMBER;
239
240 FUNCTION CP_DIRECT_PAYMENTS_P RETURN NUMBER;
241
242 FUNCTION CP_TAX_P RETURN NUMBER;
243
244 FUNCTION CP_GROSS_EARNINGS_P RETURN NUMBER;
245
246 FUNCTION CP_NET_PAYMENT_P RETURN NUMBER;
247
248 FUNCTION CP_YTD_TAXABLE_EARNINGS_P RETURN NUMBER;
249
250 FUNCTION CP_YTD_NON_TAXABLE_EARNINGS_P RETURN NUMBER;
251
252 FUNCTION CP_YTD_GROSS_EARNINGS_P RETURN NUMBER;
253
254 FUNCTION CP_YTD_PRE_TAX_DEDUCTIONS_P RETURN NUMBER;
255
256 FUNCTION CP_YTD_DIRECT_PAYMENTS_P RETURN NUMBER;
257
258 FUNCTION CP_YTD_DEDUCTIONS_P RETURN NUMBER;
259
260 FUNCTION CP_YTD_TAX_P RETURN NUMBER;
261
262 FUNCTION CP_YTD_NET_PAYMENT_P RETURN NUMBER;
263
264 FUNCTION CP_EMP_CHG_P RETURN NUMBER;
265
266 FUNCTION CP_YTD_EMP_CHG_P RETURN NUMBER;
267
268 FUNCTION CP_END_REPORT_P RETURN VARCHAR2;
269
270 FUNCTION CP_NO_DATA_FOUND_P RETURN VARCHAR2;
271
272 FUNCTION CP_PS_WORKPLACE_GIVING_P RETURN NUMBER;
273
274 FUNCTION CP_MAN_PS_WORKPLACE_GIVING_P RETURN NUMBER;
275
276 FUNCTION CP_PS_PAYSUM_GROSS_P RETURN NUMBER;
277
278 FUNCTION CP_MAN_PS_PAYSUM_GROSS_P RETURN NUMBER;
279
280 FUNCTION CP_PS_REP_ALLOWANCES_P RETURN NUMBER;
281
282 FUNCTION CP_MAN_PS_REP_ALLOWANCES_P RETURN NUMBER;
283
284 FUNCTION CP_PS_ETP_P RETURN NUMBER;
285
286 FUNCTION CP_MAN_PS_ETP_P RETURN NUMBER;
287
288 FUNCTION CP_PS_RFB_P RETURN NUMBER;
289
290 FUNCTION CP_MAN_PS_RFB_P RETURN NUMBER;
291
292 FUNCTION CP_PS_ASSESSABLE_ETP_P RETURN NUMBER;
293
294 FUNCTION CP_MAN_PS_ASSESSABLE_ETP_P RETURN NUMBER;
295
296 FUNCTION CP_PS_CDEP_P RETURN NUMBER;
297
298 FUNCTION CP_MAN_PS_CDEP_P RETURN NUMBER;
299
300 FUNCTION CP_PS_OTHER_INCOME_P RETURN NUMBER;
301
302 FUNCTION CP_MAN_PS_OTHER_INCOME_P RETURN NUMBER;
303
304 FUNCTION CP_PS_UNION_FEES_P RETURN NUMBER;
305
306 FUNCTION CP_MAN_PS_UNION_FEES_P RETURN NUMBER;
307
308 FUNCTION CP_PS_LUMPSUM_PAYMENTS_P RETURN NUMBER;
309
310 FUNCTION CP_MAN_PS_LUMPSUM_PAYMENTS_P RETURN NUMBER;
311
312 FUNCTION CP_PRINTED_COUNT_P RETURN NUMBER;
313
314 FUNCTION CP_MANUAL_COUNT_P RETURN NUMBER;
315
316 END PAY_PYAURECD_XMLP_PKG;
317