APPS.PAY_CALENDARS_PKG dependencies on PAY_CALENDARS

Line 1: PACKAGE BODY PAY_CALENDARS_PKG as

1: PACKAGE BODY PAY_CALENDARS_PKG as
2: /* $Header: pycal01t.pkb 120.1 2005/10/05 21:59:16 saurgupt noship $ */
3: --
4: /*===========================================================================+
5: | Copyright (c) 1993 Oracle Corporation |

Line 10: pay_calendars_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +============================================================================+
9: Name
10: pay_calendars_pkg
11: Purpose
12: Table Handler for the block CAL in the Define Budgetary Calendar form.
13: Notes
14: Used by the PAYWSDCL (Define Budgetary Calendar) form.

Line 29: g_package varchar2(33) := ' PAY_CALENDARS_PKG.'; -- Global package name

25:
26: -- ----------------------------------------------------------------------------
27: -- | Private Global Definitions |
28: -- ----------------------------------------------------------------------------
29: g_package varchar2(33) := ' PAY_CALENDARS_PKG.'; -- Global package name
30:
31:
32:
33: -- ----------------------------------------------------------------------------

Line 127: CURSOR C IS SELECT rowid FROM pay_calendars

123: X_Attribute20 VARCHAR2,
124: -- Extra Columns
125: X_Midpoint_Offset NUMBER) IS
126: --
127: CURSOR C IS SELECT rowid FROM pay_calendars
128: WHERE period_set_name = X_Period_Set_Name;
129: --
130: BEGIN
131: --

Line 132: INSERT INTO pay_calendars

128: WHERE period_set_name = X_Period_Set_Name;
129: --
130: BEGIN
131: --
132: INSERT INTO pay_calendars
133: (period_set_name,
134: actual_period_type,
135: proc_period_type,
136: start_date,

Line 192: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.insert_row');

188: FETCH C INTO X_Rowid;
189: if (C%NOTFOUND) then
190: CLOSE C;
191: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
192: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.insert_row');
193: hr_utility.set_message_token('STEP','1');
194: hr_utility.raise_error;
195: end if;
196: CLOSE C;

Line 247: CURSOR C IS SELECT * FROM pay_calendars

243: X_Attribute18 VARCHAR2,
244: X_Attribute19 VARCHAR2,
245: X_Attribute20 VARCHAR2) IS
246: --
247: CURSOR C IS SELECT * FROM pay_calendars
248: WHERE rowid = X_Rowid FOR UPDATE of Period_Set_Name NOWAIT;
249: --
250: Recinfo C%ROWTYPE;
251: --

Line 259: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.lock_row');

255: FETCH C INTO Recinfo;
256: if (C%NOTFOUND) then
257: CLOSE C;
258: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
259: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.lock_row');
260: hr_utility.set_message_token('STEP','1');
261: hr_utility.raise_error;
262: end if;
263: CLOSE C;

Line 421: UPDATE pay_calendars

417: X_Attribute20 VARCHAR2) IS
418: --
419: BEGIN
420: --
421: UPDATE pay_calendars
422: SET period_set_name = X_Period_Set_Name,
423: actual_period_type = X_Actual_Period_Type,
424: proc_period_type = X_Proc_Period_Type,
425: start_date = X_Start_Date,

Line 452: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.update_row');

448: WHERE rowid = X_rowid;
449: --
450: if (SQL%NOTFOUND) then
451: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
452: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.update_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;
455: end if;
456: --

Line 487: DELETE FROM pay_calendars

483: (x_period_set_name,
484: 0, -- number of years
485: false); -- at least one year to be kept
486: --
487: DELETE FROM pay_calendars
488: WHERE rowid = X_Rowid;
489: --
490: if (SQL%NOTFOUND) then
491: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 492: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.delete_row');

488: WHERE rowid = X_Rowid;
489: --
490: if (SQL%NOTFOUND) then
491: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
492: hr_utility.set_message_token('PROCEDURE','pay_calendars_pkg.delete_row');
493: hr_utility.set_message_token('STEP','1');
494: hr_utility.raise_error;
495: end if;
496: --

Line 499: END PAY_CALENDARS_PKG;

495: end if;
496: --
497: END Delete_Row;
498: --
499: END PAY_CALENDARS_PKG;