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 BODY: APPS.PSP_PAYROLL_CONTROLS_PKG

Source


1 package body PSP_PAYROLL_CONTROLS_PKG AS
2  /* $Header: PSPPIPCB.pls 120.3 2006/09/01 21:09:52 vdharmap noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PAYROLL_CONTROL_ID in NUMBER,
6   X_SUBLINES_DR_AMOUNT in NUMBER,
7   X_SUBLINES_CR_AMOUNT in NUMBER,
8   X_DIST_DR_AMOUNT in NUMBER,
9   X_DIST_CR_AMOUNT in NUMBER,
10   X_OGM_DR_AMOUNT in NUMBER,
11   X_OGM_CR_AMOUNT in NUMBER,
12   X_GL_DR_AMOUNT in NUMBER,
13   X_GL_CR_AMOUNT in NUMBER,
14   X_STATUS_CODE in VARCHAR2,
15   X_TOTAL_DR_AMOUNT in NUMBER,
16   X_TOTAL_CR_AMOUNT in NUMBER,
17   X_NUMBER_OF_CR in NUMBER,
18   X_NUMBER_OF_DR in NUMBER,
19   X_PAYROLL_SOURCE_CODE in VARCHAR2,
20   X_SOURCE_TYPE in VARCHAR2,
21   X_PAYROLL_ID in NUMBER,
22   X_TIME_PERIOD_ID in NUMBER,
23   X_BATCH_NAME in VARCHAR2,
24   X_PAYROLL_ACTION_ID in NUMBER,
25   X_MODE in VARCHAR2 default 'R',
26   X_GL_POSTING_OVERRIDE_DATE in DATE,
27   X_GMS_POSTING_OVERRIDE_DATE in DATE,
28   X_SET_OF_BOOKS_ID in NUMBER,
29   X_BUSINESS_GROUP_ID in NUMBER,
30   X_GL_PHASE in VARCHAR2,
31   X_GMS_PHASE in VARCHAR2,
32   X_ADJ_SUM_BATCH_NAME in VARCHAR2,
33   X_CURRENCY_CODE   in VARCHAR2,
34   X_EXCHANGE_RATE_TYPE in VARCHAR2,
35   X_PARENT_PAYROLL_CONTROL_ID in NUMBER default null
36   ) is
37     cursor C is select ROWID from PSP_PAYROLL_CONTROLS
38       where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID;
39     X_LAST_UPDATE_DATE DATE;
40     X_LAST_UPDATED_BY NUMBER;
41     X_LAST_UPDATE_LOGIN NUMBER;
42 begin
43   X_LAST_UPDATE_DATE := SYSDATE;
44   if(X_MODE = 'I') then
45     X_LAST_UPDATED_BY := 1;
46     X_LAST_UPDATE_LOGIN := 0;
47   elsif (X_MODE = 'R') then
48     X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
49     if X_LAST_UPDATED_BY is NULL then
50       X_LAST_UPDATED_BY := -1;
51     end if;
52     X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
53     if X_LAST_UPDATE_LOGIN is NULL then
54       X_LAST_UPDATE_LOGIN := -1;
55     end if;
56   else
57     FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
58     app_exception.raise_exception;
59   end if;
60   insert into PSP_PAYROLL_CONTROLS (
61     SUBLINES_DR_AMOUNT,
62     SUBLINES_CR_AMOUNT,
63     DIST_DR_AMOUNT,
64     DIST_CR_AMOUNT,
65     OGM_DR_AMOUNT,
66     OGM_CR_AMOUNT,
67     GL_DR_AMOUNT,
68     GL_CR_AMOUNT,
69     STATUS_CODE,
70     TOTAL_DR_AMOUNT,
71     TOTAL_CR_AMOUNT,
72     NUMBER_OF_CR,
73     NUMBER_OF_DR,
74     PAYROLL_SOURCE_CODE,
75     SOURCE_TYPE,
76     PAYROLL_ID,
77     TIME_PERIOD_ID,
78     BATCH_NAME,
79     PAYROLL_CONTROL_ID,
80     PAYROLL_ACTION_ID,
81     GL_POSTING_OVERRIDE_DATE,
82     GMS_POSTING_OVERRIDE_DATE,
83     SET_OF_BOOKS_ID,
84     BUSINESS_GROUP_ID,
85     GL_PHASE,
86     GMS_PHASE,
87     ADJ_SUM_BATCH_NAME,
88     CREATION_DATE,
89     CREATED_BY,
90     LAST_UPDATE_DATE,
91     LAST_UPDATED_BY,
92     LAST_UPDATE_LOGIN,
93     CURRENCY_CODE,
94     EXCHANGE_RATE_TYPE,
95     PARENT_PAYROLL_CONTROL_ID
96   ) values (
97     X_SUBLINES_DR_AMOUNT,
98     X_SUBLINES_CR_AMOUNT,
99     X_DIST_DR_AMOUNT,
100     X_DIST_CR_AMOUNT,
101     X_OGM_DR_AMOUNT,
102     X_OGM_CR_AMOUNT,
103     X_GL_DR_AMOUNT,
104     X_GL_CR_AMOUNT,
105     X_STATUS_CODE,
106     X_TOTAL_DR_AMOUNT,
107     X_TOTAL_CR_AMOUNT,
108     X_NUMBER_OF_CR,
109     X_NUMBER_OF_DR,
110     X_PAYROLL_SOURCE_CODE,
111     X_SOURCE_TYPE,
112     X_PAYROLL_ID,
113     X_TIME_PERIOD_ID,
114     X_BATCH_NAME,
115     X_PAYROLL_CONTROL_ID,
116     X_PAYROLL_ACTION_ID,
117     X_GL_POSTING_OVERRIDE_DATE,
118     X_GMS_POSTING_OVERRIDE_DATE,
119     X_SET_OF_BOOKS_ID,
120     X_BUSINESS_GROUP_ID,
121     X_GL_PHASE,
122     X_GMS_PHASE,
123     X_ADJ_SUM_BATCH_NAME,
124     X_LAST_UPDATE_DATE,
125     X_LAST_UPDATED_BY,
126     X_LAST_UPDATE_DATE,
127     X_LAST_UPDATED_BY,
128     X_LAST_UPDATE_LOGIN,
129     X_CURRENCY_CODE,
130     X_EXCHANGE_RATE_TYPE,
131     X_PARENT_PAYROLL_CONTROL_ID
132   );
133 
134   open c;
135   fetch c into X_ROWID;
136   if (c%notfound) then
137     close c;
138     raise no_data_found;
139   end if;
140   close c;
141 
142 end INSERT_ROW;
143 
144 procedure LOCK_ROW (
145   X_PAYROLL_CONTROL_ID in NUMBER,
146   X_SUBLINES_DR_AMOUNT in NUMBER,
147   X_SUBLINES_CR_AMOUNT in NUMBER,
148   X_DIST_DR_AMOUNT in NUMBER,
149   X_DIST_CR_AMOUNT in NUMBER,
150   X_OGM_DR_AMOUNT in NUMBER,
151   X_OGM_CR_AMOUNT in NUMBER,
152   X_GL_DR_AMOUNT in NUMBER,
153   X_GL_CR_AMOUNT in NUMBER,
154   X_STATUS_CODE in VARCHAR2,
155   X_TOTAL_DR_AMOUNT in NUMBER,
156   X_TOTAL_CR_AMOUNT in NUMBER,
157   X_NUMBER_OF_CR in NUMBER,
158   X_NUMBER_OF_DR in NUMBER,
159   X_PAYROLL_SOURCE_CODE in VARCHAR2,
160   X_SOURCE_TYPE in VARCHAR2,
161   X_PAYROLL_ID in NUMBER,
162   X_TIME_PERIOD_ID in NUMBER,
163   X_BATCH_NAME in VARCHAR2,
164   X_PAYROLL_ACTION_ID in NUMBER,
165   X_GL_POSTING_OVERRIDE_DATE in DATE,
166   X_GMS_POSTING_OVERRIDE_DATE in DATE,
167   X_SET_OF_BOOKS_ID in NUMBER,
168   X_BUSINESS_GROUP_ID in NUMBER,
169   X_GL_PHASE in VARCHAR2,
170   X_GMS_PHASE in VARCHAR2,
171   X_ADJ_SUM_BATCH_NAME in VARCHAR2,
172   X_CURRENCY_CODE  in VARCHAR2,
173   X_EXCHANGE_RATE_TYPE in VARCHAR2
174 ) is
175   cursor c1 is select
176       SUBLINES_DR_AMOUNT,
177       SUBLINES_CR_AMOUNT,
178       DIST_DR_AMOUNT,
179       DIST_CR_AMOUNT,
180       OGM_DR_AMOUNT,
181       OGM_CR_AMOUNT,
182       GL_DR_AMOUNT,
183       GL_CR_AMOUNT,
184       STATUS_CODE,
185       TOTAL_DR_AMOUNT,
186       TOTAL_CR_AMOUNT,
187       NUMBER_OF_CR,
188       NUMBER_OF_DR,
189       PAYROLL_SOURCE_CODE,
190       SOURCE_TYPE,
191       PAYROLL_ID,
192       TIME_PERIOD_ID,
193       BATCH_NAME,
194       PAYROLL_ACTION_ID,
195       GL_POSTING_OVERRIDE_DATE,
196       GMS_POSTING_OVERRIDE_DATE,
197       SET_OF_BOOKS_ID,
198       BUSINESS_GROUP_ID,
199       GL_PHASE,
200       GMS_PHASE,
201       ADJ_SUM_BATCH_NAME,
202       CURRENCY_CODE,
203       EXCHANGE_RATE_TYPE
204     from PSP_PAYROLL_CONTROLS
205     where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
206     for update of PAYROLL_CONTROL_ID nowait;
207   tlinfo c1%rowtype;
208 
209 begin
210   open c1;
211   fetch c1 into tlinfo;
212   if (c1%notfound) then
213     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
214     app_exception.raise_exception;
215     close c1;
216     return;
217   end if;
218   close c1;
219 
220       if ( ((tlinfo.SUBLINES_DR_AMOUNT = X_SUBLINES_DR_AMOUNT)
221            OR ((tlinfo.SUBLINES_DR_AMOUNT is null)
222                AND (X_SUBLINES_DR_AMOUNT is null)))
223       AND ((tlinfo.SUBLINES_CR_AMOUNT = X_SUBLINES_CR_AMOUNT)
224            OR ((tlinfo.SUBLINES_CR_AMOUNT is null)
225                AND (X_SUBLINES_CR_AMOUNT is null)))
226       AND ((tlinfo.DIST_DR_AMOUNT = X_DIST_DR_AMOUNT)
227            OR ((tlinfo.DIST_DR_AMOUNT is null)
228                AND (X_DIST_DR_AMOUNT is null)))
229       AND ((tlinfo.DIST_CR_AMOUNT = X_DIST_CR_AMOUNT)
230            OR ((tlinfo.DIST_CR_AMOUNT is null)
231                AND (X_DIST_CR_AMOUNT is null)))
232       AND ((tlinfo.OGM_DR_AMOUNT = X_OGM_DR_AMOUNT)
233            OR ((tlinfo.OGM_DR_AMOUNT is null)
234                AND (X_OGM_DR_AMOUNT is null)))
235       AND ((tlinfo.OGM_CR_AMOUNT = X_OGM_CR_AMOUNT)
236            OR ((tlinfo.OGM_CR_AMOUNT is null)
237                AND (X_OGM_CR_AMOUNT is null)))
238       AND ((tlinfo.GL_DR_AMOUNT = X_GL_DR_AMOUNT)
239            OR ((tlinfo.GL_DR_AMOUNT is null)
240                AND (X_GL_DR_AMOUNT is null)))
241       AND ((tlinfo.GL_CR_AMOUNT = X_GL_CR_AMOUNT)
242            OR ((tlinfo.GL_CR_AMOUNT is null)
243                AND (X_GL_CR_AMOUNT is null)))
244       AND (tlinfo.STATUS_CODE = X_STATUS_CODE)
245       AND ((tlinfo.TOTAL_DR_AMOUNT = X_TOTAL_DR_AMOUNT)
246            OR ((tlinfo.TOTAL_DR_AMOUNT is null)
247                AND (X_TOTAL_DR_AMOUNT is null)))
248       AND ((tlinfo.TOTAL_CR_AMOUNT = X_TOTAL_CR_AMOUNT)
249            OR ((tlinfo.TOTAL_CR_AMOUNT is null)
250                AND (X_TOTAL_CR_AMOUNT is null)))
251       AND ((tlinfo.NUMBER_OF_CR = X_NUMBER_OF_CR)
252            OR ((tlinfo.NUMBER_OF_CR is null)
253                AND (X_NUMBER_OF_CR is null)))
254       AND ((tlinfo.NUMBER_OF_DR = X_NUMBER_OF_DR)
255            OR ((tlinfo.NUMBER_OF_DR is null)
256                AND (X_NUMBER_OF_DR is null)))
257       AND (tlinfo.PAYROLL_SOURCE_CODE = X_PAYROLL_SOURCE_CODE)
258       AND (tlinfo.SOURCE_TYPE = X_SOURCE_TYPE)
259       AND (tlinfo.PAYROLL_ID = X_PAYROLL_ID)
260       AND (tlinfo.TIME_PERIOD_ID = X_TIME_PERIOD_ID)
261       AND ((tlinfo.BATCH_NAME = X_BATCH_NAME)
262            OR ((tlinfo.BATCH_NAME is null)
263                AND (X_BATCH_NAME is null)))
264       AND (tlinfo.PAYROLL_ACTION_ID = X_PAYROLL_ACTION_ID)
265       AND (tlinfo.CURRENCY_CODE = X_CURRENCY_CODE)
266       AND ((tlinfo.EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE)
267            OR ((tlinfo.EXCHANGE_RATE_TYPE is null)
268                AND (X_EXCHANGE_RATE_TYPE is null)))
269 
270   ) then
271     null;
272   else
273     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
274     app_exception.raise_exception;
275   end if;
276   return;
277 end LOCK_ROW;
278 
279 procedure UPDATE_ROW (
280   X_PAYROLL_CONTROL_ID in NUMBER,
281   X_SUBLINES_DR_AMOUNT in NUMBER,
282   X_SUBLINES_CR_AMOUNT in NUMBER,
283   X_DIST_DR_AMOUNT in NUMBER,
284   X_DIST_CR_AMOUNT in NUMBER,
285   X_OGM_DR_AMOUNT in NUMBER,
286   X_OGM_CR_AMOUNT in NUMBER,
287   X_GL_DR_AMOUNT in NUMBER,
288   X_GL_CR_AMOUNT in NUMBER,
289   X_STATUS_CODE in VARCHAR2,
290   X_TOTAL_DR_AMOUNT in NUMBER,
291   X_TOTAL_CR_AMOUNT in NUMBER,
292   X_NUMBER_OF_CR in NUMBER,
293   X_NUMBER_OF_DR in NUMBER,
294   X_PAYROLL_SOURCE_CODE in VARCHAR2,
295   X_SOURCE_TYPE in VARCHAR2,
296   X_PAYROLL_ID in NUMBER,
297   X_TIME_PERIOD_ID in NUMBER,
298   X_BATCH_NAME in VARCHAR2,
299   X_PAYROLL_ACTION_ID in NUMBER,
300   X_MODE in VARCHAR2 default 'R',
301   X_GL_POSTING_OVERRIDE_DATE in DATE,
302   X_GMS_POSTING_OVERRIDE_DATE in DATE,
303   X_SET_OF_BOOKS_ID in NUMBER,
304   X_BUSINESS_GROUP_ID in NUMBER,
305   X_GL_PHASE in VARCHAR2,
306   X_GMS_PHASE in VARCHAR2,
307   X_ADJ_SUM_BATCH_NAME in VARCHAR2,
308   X_CURRENCY_CODE   in VARCHAR2,
309   X_EXCHANGE_RATE_TYPE in VARCHAR2
310   ) is
311     X_LAST_UPDATE_DATE DATE;
312     X_LAST_UPDATED_BY NUMBER;
313     X_LAST_UPDATE_LOGIN NUMBER;
314 begin
315   X_LAST_UPDATE_DATE := SYSDATE;
316   if(X_MODE = 'I') then
317     X_LAST_UPDATED_BY := 1;
318     X_LAST_UPDATE_LOGIN := 0;
319   elsif (X_MODE = 'R') then
320     X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
321     if X_LAST_UPDATED_BY is NULL then
322       X_LAST_UPDATED_BY := -1;
323     end if;
324     X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
325     if X_LAST_UPDATE_LOGIN is NULL then
326       X_LAST_UPDATE_LOGIN := -1;
327     end if;
328   else
329     FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
330     app_exception.raise_exception;
331   end if;
332   update PSP_PAYROLL_CONTROLS set
333     SUBLINES_DR_AMOUNT = X_SUBLINES_DR_AMOUNT,
334     SUBLINES_CR_AMOUNT = X_SUBLINES_CR_AMOUNT,
335     DIST_DR_AMOUNT = X_DIST_DR_AMOUNT,
336     DIST_CR_AMOUNT = X_DIST_CR_AMOUNT,
337     OGM_DR_AMOUNT = X_OGM_DR_AMOUNT,
338     OGM_CR_AMOUNT = X_OGM_CR_AMOUNT,
339     GL_DR_AMOUNT = X_GL_DR_AMOUNT,
340     GL_CR_AMOUNT = X_GL_CR_AMOUNT,
341     STATUS_CODE = X_STATUS_CODE,
342     TOTAL_DR_AMOUNT = X_TOTAL_DR_AMOUNT,
343     TOTAL_CR_AMOUNT = X_TOTAL_CR_AMOUNT,
344     NUMBER_OF_CR = X_NUMBER_OF_CR,
345     NUMBER_OF_DR = X_NUMBER_OF_DR,
346     PAYROLL_SOURCE_CODE = X_PAYROLL_SOURCE_CODE,
347     SOURCE_TYPE = X_SOURCE_TYPE,
348     PAYROLL_ID = X_PAYROLL_ID,
349     TIME_PERIOD_ID = X_TIME_PERIOD_ID,
350     BATCH_NAME = X_BATCH_NAME,
351     PAYROLL_ACTION_ID = X_PAYROLL_ACTION_ID,
352     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
353     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
354     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
355     GL_POSTING_OVERRIDE_DATE = X_GL_POSTING_OVERRIDE_DATE,
356     GMS_POSTING_OVERRIDE_DATE = X_GMS_POSTING_OVERRIDE_DATE,
357     SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
358     BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
359     GL_PHASE  = X_GL_PHASE,
360     GMS_PHASE  = X_GMS_PHASE,
361     ADJ_SUM_BATCH_NAME  = X_ADJ_SUM_BATCH_NAME,
362     CURRENCY_CODE = X_CURRENCY_CODE,
363     EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE
364   where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
365   ;
366   if (sql%notfound) then
367     raise no_data_found;
368   end if;
369 end UPDATE_ROW;
370 
371 procedure ADD_ROW (
372   X_ROWID in out NOCOPY VARCHAR2,
373   X_PAYROLL_CONTROL_ID in NUMBER,
374   X_SUBLINES_DR_AMOUNT in NUMBER,
375   X_SUBLINES_CR_AMOUNT in NUMBER,
376   X_DIST_DR_AMOUNT in NUMBER,
377   X_DIST_CR_AMOUNT in NUMBER,
378   X_OGM_DR_AMOUNT in NUMBER,
379   X_OGM_CR_AMOUNT in NUMBER,
380   X_GL_DR_AMOUNT in NUMBER,
381   X_GL_CR_AMOUNT in NUMBER,
382   X_STATUS_CODE in VARCHAR2,
383   X_TOTAL_DR_AMOUNT in NUMBER,
384   X_TOTAL_CR_AMOUNT in NUMBER,
385   X_NUMBER_OF_CR in NUMBER,
386   X_NUMBER_OF_DR in NUMBER,
387   X_PAYROLL_SOURCE_CODE in VARCHAR2,
388   X_SOURCE_TYPE in VARCHAR2,
389   X_PAYROLL_ID in NUMBER,
390   X_TIME_PERIOD_ID in NUMBER,
391   X_BATCH_NAME in VARCHAR2,
392   X_PAYROLL_ACTION_ID in NUMBER,
393   X_MODE in VARCHAR2 default 'R',
394   X_GL_POSTING_OVERRIDE_DATE in DATE,
395   X_GMS_POSTING_OVERRIDE_DATE in DATE,
396   X_SET_OF_BOOKS_ID in NUMBER,
397   X_BUSINESS_GROUP_ID in NUMBER,
398   X_GL_PHASE in VARCHAR2,
399   X_GMS_PHASE in VARCHAR2,
400   X_ADJ_SUM_BATCH_NAME in VARCHAR2,
401   X_CURRENCY_CODE in VARCHAR2,
402   X_EXCHANGE_RATE_TYPE in VARCHAR2
403   ) is
404   cursor c1 is select rowid from PSP_PAYROLL_CONTROLS
405      where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID
406   ;
407   dummy c1%rowtype;
408 begin
409   open c1;
410   fetch c1 into dummy;
411   if (c1%notfound) then
412     close c1;
413     INSERT_ROW (
414      X_ROWID,
415      X_PAYROLL_CONTROL_ID,
416      X_SUBLINES_DR_AMOUNT,
417      X_SUBLINES_CR_AMOUNT,
418      X_DIST_DR_AMOUNT,
419      X_DIST_CR_AMOUNT,
420      X_OGM_DR_AMOUNT,
421      X_OGM_CR_AMOUNT,
422      X_GL_DR_AMOUNT,
423      X_GL_CR_AMOUNT,
424      X_STATUS_CODE,
425      X_TOTAL_DR_AMOUNT,
426      X_TOTAL_CR_AMOUNT,
427      X_NUMBER_OF_CR,
428      X_NUMBER_OF_DR,
429      X_PAYROLL_SOURCE_CODE,
430      X_SOURCE_TYPE,
431      X_PAYROLL_ID,
432      X_TIME_PERIOD_ID,
433      X_BATCH_NAME,
434      X_PAYROLL_ACTION_ID,
435      X_MODE,
436      X_GL_POSTING_OVERRIDE_DATE,
437      X_GMS_POSTING_OVERRIDE_DATE,
438      X_SET_OF_BOOKS_ID,
439      X_BUSINESS_GROUP_ID,
440      X_GL_PHASE,
441      X_GMS_PHASE,
442      X_ADJ_SUM_BATCH_NAME,
443      X_CURRENCY_CODE,
444      X_EXCHANGE_RATE_TYPE, null);
445     return;
446   end if;
447   close c1;
448   UPDATE_ROW (
449    X_PAYROLL_CONTROL_ID,
450    X_SUBLINES_DR_AMOUNT,
451    X_SUBLINES_CR_AMOUNT,
452    X_DIST_DR_AMOUNT,
453    X_DIST_CR_AMOUNT,
454    X_OGM_DR_AMOUNT,
455    X_OGM_CR_AMOUNT,
456    X_GL_DR_AMOUNT,
457    X_GL_CR_AMOUNT,
458    X_STATUS_CODE,
459    X_TOTAL_DR_AMOUNT,
460    X_TOTAL_CR_AMOUNT,
461    X_NUMBER_OF_CR,
462    X_NUMBER_OF_DR,
463    X_PAYROLL_SOURCE_CODE,
464    X_SOURCE_TYPE,
465    X_PAYROLL_ID,
466    X_TIME_PERIOD_ID,
467    X_BATCH_NAME,
468    X_PAYROLL_ACTION_ID,
469    X_MODE,
470    X_GL_POSTING_OVERRIDE_DATE,
471    X_GMS_POSTING_OVERRIDE_DATE,
472    X_SET_OF_BOOKS_ID,
473    X_BUSINESS_GROUP_ID,
474    X_GL_PHASE,
475    X_GMS_PHASE,
476    X_ADJ_SUM_BATCH_NAME,
477    X_CURRENCY_CODE,
478    X_EXCHANGE_RATE_TYPE);
479 end ADD_ROW;
480 
481 procedure DELETE_ROW (
482   X_PAYROLL_CONTROL_ID in NUMBER
483 ) is
484 begin
485   delete from PSP_PAYROLL_CONTROLS
486   where PAYROLL_CONTROL_ID = X_PAYROLL_CONTROL_ID;
487   if (sql%notfound) then
488     raise no_data_found;
489   end if;
490 end DELETE_ROW;
491 
492 end PSP_PAYROLL_CONTROLS_PKG;