eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PAY_PYAURECP_XMLP_PKG

Source


1 PACKAGE PAY_PYAURECP_XMLP_PKG AS
2 /* $Header: PYAURECPS.pls 120.0 2007/12/13 11:58:16 amakrish noship $ */
3   P_ASSIGNMENT_ID VARCHAR2(40);
4 
5   P_PAYROLL_ID VARCHAR2(40);
6 
7   P_REGISTERED_EMPLOYER VARCHAR2(40);
8 
9   P_FINANCIAL_YEAR VARCHAR2(32767);
10 
11   P_EMPLOYEE_TYPE VARCHAR2(40);
12 
13   P_CONC_REQUEST_ID NUMBER := 3487554;
14 
15   P_BUSINESS_GROUP_ID NUMBER;
16 
17   CLAUSE VARCHAR2(100);
18 
19   P_LST_YR_TERM VARCHAR2(10);
20 
21   WHERECLAUSE VARCHAR2(100):= ' ';
22 
23   P_PAYROLL_ACTION_ID NUMBER;
24 
25   MANUAL_PS_ISSUED VARCHAR2(20);
26 
27   CP_FIN_YR_START DATE;
28 
29   CP_FIN_YR_END DATE;
30 
31   CP_FBT_YR_START DATE;
32 
33   CP_FBT_YR_END DATE;
34 
35   CP_TOTAL_STANDARD NUMBER;
36 
37   CP_TOTAL_ETP NUMBER;
38 
39   CP_TOTAL_CURRENT_EMPLOYEES NUMBER;
40 
41   CP_TOTAL_TERMINATED_EMPLOYEES NUMBER;
42 
43   CP_TOTAL_GROSS NUMBER;
44 
45   CP_TOTAL_RFB NUMBER;
46 
47   CP_TOTAL_LUMPSUM_A_PAY NUMBER;
48 
49   CP_TOTAL_LUMPSUM_B_PAY NUMBER;
50 
51   CP_TOTAL_LUMPSUM_D_PAY NUMBER;
52 
53   CP_TOTAL_LUMPSUM_E_PAY NUMBER;
54 
55   CP_TOTAL_UNION_FEES NUMBER;
56 
57   CP_TOTAL_TID NUMBER;
58 
59   CP_TOTAL_OTHER_INCOME NUMBER;
60 
61   CP_TOTAL_PRE_JUL_83 NUMBER;
62 
63   CP_TOTAL_JUN_83_UNT NUMBER;
64 
65   CP_TOTAL_JUN_83_TAX NUMBER;
66 
67   CP_TOTAL_JUN_94_INV NUMBER;
68 
69   CP_TOTAL_GROSS_ETP NUMBER;
70 
71   CP_TOTAL_ETP_TID NUMBER;
72 
73   CP_TOTAL_ASSESSABLE_INCOME NUMBER;
74 
75   CP_TOTAL_ALLOWANCES NUMBER;
76 
77   CP_TOTAL_CDEP NUMBER;
78 
79   CP_FINANCIAL_YEAR VARCHAR2(40);
80 
81   CP_REG_EMP VARCHAR2(102);
82 
83   CP_PAYROLL_NAME VARCHAR2(80);
84 
85   CP_EMP_TYPE VARCHAR2(80);
86 
87   CP_ASSIGNMENT_NUMBER VARCHAR2(80);
88 
89   CP_FBT_GLOBAL VARCHAR2(240);
90 
91   CP_ML_GLOBAL VARCHAR2(240);
92 
93   CP_DIMENSION VARCHAR2(20);
94 
95   CP_ASSGT_COUNTER NUMBER := 0;
96 
97   CP_ASSGT_TOTAL NUMBER;
98 
99   CP_LST_YR_START DATE;
100 
101   CP_LST_YR_TERM VARCHAR2(80);
102 
103   CP_TOTAL_WORKPLACE NUMBER;
104 
105   CP_MAN_TOTAL_STANDARD NUMBER;
106 
107   CP_MAN_TOTAL_ETP NUMBER;
108 
109   CP_MAN_TOTAL_CURR_EMPLOYEES NUMBER;
110 
111   CP_MAN_TOTAL_TERM_EMPLOYEES NUMBER;
112 
113   CP_MAN_TOTAL_GROSS NUMBER;
114 
115   CP_MAN_TOTAL_RFB NUMBER;
116 
117   CP_MAN_TOTAL_LUMPSUM_A_PAY NUMBER;
118 
119   CP_MAN_TOTAL_LUMPSUM_B_PAY NUMBER;
120 
121   CP_MAN_TOTAL_LUMPSUM_D_PAY NUMBER;
122 
123   CP_MAN_TOTAL_LUMPSUM_E_PAY NUMBER;
124 
125   CP_MAN_TOTAL_UNION_FEES NUMBER;
126 
127   CP_MAN_TOTAL_TID NUMBER;
128 
129   CP_MAN_TOTAL_OTHER_INCOME NUMBER;
130 
131   CP_MAN_TOTAL_PRE_JUL_83 NUMBER;
132 
133   CP_MAN_TOTAL_JUN_83_UNT NUMBER;
134 
135   CP_MAN_TOTAL_JUN_83_TAX NUMBER;
136 
137   CP_MAN_TOTAL_JUN_94_INV NUMBER;
138 
139   CP_MAN_TOTAL_GROSS_ETP NUMBER;
140 
141   CP_MAN_TOTAL_ETP_TID NUMBER;
142 
143   CP_MAN_TOTAL_ASSESSABLE_INCOME NUMBER;
144 
145   CP_MAN_TOTAL_ALLOWANCES NUMBER;
146 
147   CP_MAN_TOTAL_CDEP NUMBER;
148 
149   CP_MAN_TOTAL_WORKPLACE NUMBER;
150   /*ADDED AS FIX*/
151     LP_PAYROLL_ACTION_ID  NUMBER;
152     LP_ASSIGNMENT_ID VARCHAR2(40);
153     LP_BUSINESS_GROUP_ID NUMBER;
154     LP_EMPLOYEE_TYPE VARCHAR2(40);
155     LP_FINANCIAL_YEAR  VARCHAR2(32767);
156     LP_LST_YR_TERM VARCHAR2(10);
157     LP_PAYROLL_ID VARCHAR2(40);
158     LP_REGISTERED_EMPLOYER VARCHAR2(40);
159 
160 
161   FUNCTION BEFOREREPORT RETURN BOOLEAN;
162 
163   FUNCTION CF_CALC_TOTALSFORMULA(ASSIGNMENT_ID IN NUMBER
164                                 ,TAX_UNIT_ID IN NUMBER
165                                 ,EMP_TYPE IN VARCHAR2
166                                 ,TERM_DATE IN DATE
167                                 ,DATE_EARNED IN DATE
168                                 ,ASSIGNMENT_ACTION_ID IN NUMBER) RETURN NUMBER;
169 
170   FUNCTION AFTERREPORT RETURN BOOLEAN;
171 
172   FUNCTION CF_CALC_GROUP_TOTALSFORMULA RETURN NUMBER;
173 
174   FUNCTION MANUAL_PS_ISSUED_P RETURN VARCHAR2;
175 
176   FUNCTION CP_FIN_YR_START_P RETURN DATE;
177 
178   FUNCTION CP_FIN_YR_END_P RETURN DATE;
179 
180   FUNCTION CP_FBT_YR_START_P RETURN DATE;
181 
182   FUNCTION CP_FBT_YR_END_P RETURN DATE;
183 
184   FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER;
185 
186   FUNCTION CP_TOTAL_ETP_P RETURN NUMBER;
187 
188   FUNCTION CP_TOTAL_CURRENT_EMPLOYEES_P RETURN NUMBER;
189 
190   --FUNCTION CP_TOTAL_TERMINATED_EMPLOYEES RETURN NUMBER;
191   FUNCTION CP_TOTAL_TERMINATED_EMPLOY_P RETURN NUMBER;
192   FUNCTION CP_TOTAL_GROSS_P RETURN NUMBER;
193 
194   FUNCTION CP_TOTAL_RFB_P RETURN NUMBER;
195 
196   FUNCTION CP_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER;
197 
198   FUNCTION CP_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER;
199 
200   FUNCTION CP_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER;
201 
202   FUNCTION CP_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER;
203 
204   FUNCTION CP_TOTAL_UNION_FEES_P RETURN NUMBER;
205 
206   FUNCTION CP_TOTAL_TID_P RETURN NUMBER;
207 
208   FUNCTION CP_TOTAL_OTHER_INCOME_P RETURN NUMBER;
209 
210   FUNCTION CP_TOTAL_PRE_JUL_83_P RETURN NUMBER;
211 
212   FUNCTION CP_TOTAL_JUN_83_UNT_P RETURN NUMBER;
213 
214   FUNCTION CP_TOTAL_JUN_83_TAX_P RETURN NUMBER;
215 
216   FUNCTION CP_TOTAL_JUN_94_INV_P RETURN NUMBER;
217 
218   FUNCTION CP_TOTAL_GROSS_ETP_P RETURN NUMBER;
219 
220   FUNCTION CP_TOTAL_ETP_TID_P RETURN NUMBER;
221 
222   FUNCTION CP_TOTAL_ASSESSABLE_INCOME_P RETURN NUMBER;
223 
224   FUNCTION CP_TOTAL_ALLOWANCES_P RETURN NUMBER;
225 
226   FUNCTION CP_TOTAL_CDEP_P RETURN NUMBER;
227 
228   FUNCTION CP_FINANCIAL_YEAR_P RETURN VARCHAR2;
229 
230   FUNCTION CP_REG_EMP_P RETURN VARCHAR2;
231 
232   FUNCTION CP_PAYROLL_NAME_P RETURN VARCHAR2;
233 
234   FUNCTION CP_EMP_TYPE_P RETURN VARCHAR2;
235 
236   FUNCTION CP_ASSIGNMENT_NUMBER_P RETURN VARCHAR2;
237 
238   FUNCTION CP_FBT_GLOBAL_P RETURN VARCHAR2;
239 
240   FUNCTION CP_ML_GLOBAL_P RETURN VARCHAR2;
241 
242   FUNCTION CP_DIMENSION_P RETURN VARCHAR2;
243 
244   FUNCTION CP_ASSGT_COUNTER_P RETURN NUMBER;
245 
246   FUNCTION CP_ASSGT_TOTAL_P RETURN NUMBER;
247 
248   FUNCTION CP_LST_YR_START_P RETURN DATE;
249 
250   FUNCTION CP_LST_YR_TERM_P RETURN VARCHAR2;
251 
252   FUNCTION CP_TOTAL_WORKPLACE_P RETURN NUMBER;
253 
254   FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER;
255 
256   FUNCTION CP_MAN_TOTAL_ETP_P RETURN NUMBER;
257 
258   FUNCTION CP_MAN_TOTAL_CURR_EMPLOYEES_P RETURN NUMBER;
259 
260   FUNCTION CP_MAN_TOTAL_TERM_EMPLOYEES_P RETURN NUMBER;
261 
262   FUNCTION CP_MAN_TOTAL_GROSS_P RETURN NUMBER;
263 
264   FUNCTION CP_MAN_TOTAL_RFB_P RETURN NUMBER;
265 
266   FUNCTION CP_MAN_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER;
267 
268   FUNCTION CP_MAN_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER;
269 
270   FUNCTION CP_MAN_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER;
271 
272   FUNCTION CP_MAN_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER;
273 
274   FUNCTION CP_MAN_TOTAL_UNION_FEES_P RETURN NUMBER;
275 
276   FUNCTION CP_MAN_TOTAL_TID_P RETURN NUMBER;
277 
278   FUNCTION CP_MAN_TOTAL_OTHER_INCOME_P RETURN NUMBER;
279 
280   FUNCTION CP_MAN_TOTAL_PRE_JUL_83_P RETURN NUMBER;
281 
282   FUNCTION CP_MAN_TOTAL_JUN_83_UNT_P RETURN NUMBER;
283 
284   FUNCTION CP_MAN_TOTAL_JUN_83_TAX_P RETURN NUMBER;
285 
286   FUNCTION CP_MAN_TOTAL_JUN_94_INV_P RETURN NUMBER;
287 
288   FUNCTION CP_MAN_TOTAL_GROSS_ETP_P RETURN NUMBER;
289 
290   FUNCTION CP_MAN_TOTAL_ETP_TID_P RETURN NUMBER;
291 
292   FUNCTION CP_MAN_TOTAL_ASSESSABLE_INCOM RETURN NUMBER;
293 
294   FUNCTION CP_MAN_TOTAL_ALLOWANCES_P RETURN NUMBER;
295 
296   FUNCTION CP_MAN_TOTAL_CDEP_P RETURN NUMBER;
297 
298   FUNCTION CP_MAN_TOTAL_WORKPLACE_P RETURN NUMBER;
299 
300 END PAY_PYAURECP_XMLP_PKG;