APPS.IGS_UC_HRC_TIMSTMPS_PKG dependencies on IGS_UC_HRC_TIMSTMPS

Line 1: PACKAGE BODY igs_uc_hrc_timstmps_pkg AS

1: PACKAGE BODY igs_uc_hrc_timstmps_pkg AS
2: /* $Header: IGSXI48B.pls 120.0 2005/06/02 04:23:54 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_hrc_timstmps%ROWTYPE;

Line 5: old_references igs_uc_hrc_timstmps%ROWTYPE;

1: PACKAGE BODY igs_uc_hrc_timstmps_pkg AS
2: /* $Header: IGSXI48B.pls 120.0 2005/06/02 04:23:54 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_hrc_timstmps%ROWTYPE;
6: new_references igs_uc_hrc_timstmps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_hrc_timstmps%ROWTYPE;

2: /* $Header: IGSXI48B.pls 120.0 2005/06/02 04:23:54 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_hrc_timstmps%ROWTYPE;
6: new_references igs_uc_hrc_timstmps%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_uc_hrc_timstmps

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_uc_hrc_timstmps
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 87: FROM igs_uc_hrc_timstmps

83: || (reverse chronological order - newest change first)
84: */
85: CURSOR cur_rowid IS
86: SELECT rowid
87: FROM igs_uc_hrc_timstmps
88: WHERE view_name = x_view_name
89: AND ucas_cycle = x_ucas_cycle
90: FOR UPDATE NOWAIT;
91:

Line 211: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.INSERT_ROW');

207: x_last_update_login := -1;
208: END IF;
209: ELSE
210: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
211: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.INSERT_ROW');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: END IF;
215:

Line 229: INSERT INTO igs_uc_hrc_timstmps(

225: x_last_updated_by => x_last_updated_by,
226: x_last_update_login => x_last_update_login
227: );
228:
229: INSERT INTO igs_uc_hrc_timstmps(
230: view_name,
231: ucas_cycle,
232: timestamp,
233: creation_date,

Line 270: FROM igs_uc_hrc_timstmps

266: */
267: CURSOR c1 IS
268: SELECT
269: timestamp
270: FROM igs_uc_hrc_timstmps
271: WHERE rowid = x_rowid
272: FOR UPDATE NOWAIT;
273:
274: tlinfo c1%ROWTYPE;

Line 341: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.UPDATE_ROW');

337: x_last_update_login := -1;
338: END IF;
339: ELSE
340: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
341: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.UPDATE_ROW');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345:

Line 359: UPDATE igs_uc_hrc_timstmps

355: x_last_updated_by => x_last_updated_by,
356: x_last_update_login => x_last_update_login
357: );
358:
359: UPDATE igs_uc_hrc_timstmps
360: SET
361: timestamp = new_references.timestamp,
362: last_update_date = x_last_update_date,
363: last_updated_by = x_last_updated_by,

Line 392: FROM igs_uc_hrc_timstmps

388: || (reverse chronological order - newest change first)
389: */
390: CURSOR c1 IS
391: SELECT rowid
392: FROM igs_uc_hrc_timstmps
393: WHERE view_name = x_view_name
394: AND ucas_cycle = x_ucas_cycle;
395:
396: BEGIN

Line 444: DELETE FROM igs_uc_hrc_timstmps

440: p_action => 'DELETE',
441: x_rowid => x_rowid
442: );
443:
444: DELETE FROM igs_uc_hrc_timstmps
445: WHERE rowid = x_rowid;
446:
447: IF (SQL%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;

Line 454: END igs_uc_hrc_timstmps_pkg;

450:
451: END delete_row;
452:
453:
454: END igs_uc_hrc_timstmps_pkg;