APPS.IGS_UC_CYC_DEFAULTS_PKG dependencies on IGS_UC_CYC_DEFAULTS

Line 1: PACKAGE BODY igs_uc_cyc_defaults_pkg AS

1: PACKAGE BODY igs_uc_cyc_defaults_pkg AS
2: /* $Header: IGSXI53B.pls 120.0 2005/06/02 03:52:36 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cyc_defaults%ROWTYPE;

Line 5: old_references igs_uc_cyc_defaults%ROWTYPE;

1: PACKAGE BODY igs_uc_cyc_defaults_pkg AS
2: /* $Header: IGSXI53B.pls 120.0 2005/06/02 03:52:36 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cyc_defaults%ROWTYPE;
6: new_references igs_uc_cyc_defaults%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_cyc_defaults%ROWTYPE;

2: /* $Header: IGSXI53B.pls 120.0 2005/06/02 03:52:36 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cyc_defaults%ROWTYPE;
6: new_references igs_uc_cyc_defaults%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM igs_uc_cyc_defaults

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_uc_cyc_defaults
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 99: FROM igs_uc_cyc_defaults

95: || Bug# 3022067. Removed columns referring to calendars.
96: */
97: CURSOR cur_rowid IS
98: SELECT rowid
99: FROM igs_uc_cyc_defaults
100: WHERE system_code = x_system_code
101: AND ucas_cycle = x_ucas_cycle
102: FOR UPDATE NOWAIT;
103:

Line 239: fnd_message.set_token ('ROUTINE', 'IGS_UC_CYC_DEFAULTS_PKG.INSERT_ROW');

235: x_last_update_login := -1;
236: END IF;
237: ELSE
238: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
239: fnd_message.set_token ('ROUTINE', 'IGS_UC_CYC_DEFAULTS_PKG.INSERT_ROW');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: END IF;
243:

Line 261: INSERT INTO igs_uc_cyc_defaults (

257: x_last_updated_by => x_last_updated_by,
258: x_last_update_login => x_last_update_login
259: );
260:
261: INSERT INTO igs_uc_cyc_defaults (
262: system_code,
263: ucas_cycle,
264: ucas_interface,
265: marvin_seq,

Line 320: FROM igs_uc_cyc_defaults

316: marvin_seq,
317: clearing_flag,
318: extra_flag,
319: cvname_flag
320: FROM igs_uc_cyc_defaults
321: WHERE rowid = x_rowid
322: FOR UPDATE NOWAIT;
323:
324: tlinfo c1%ROWTYPE;

Line 400: fnd_message.set_token ('ROUTINE', 'IGS_UC_CYC_DEFAULTS_PKG.UPDATE_ROW');

396: x_last_update_login := -1;
397: END IF;
398: ELSE
399: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
400: fnd_message.set_token ('ROUTINE', 'IGS_UC_CYC_DEFAULTS_PKG.UPDATE_ROW');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: END IF;
404:

Line 422: UPDATE igs_uc_cyc_defaults

418: x_last_updated_by => x_last_updated_by,
419: x_last_update_login => x_last_update_login
420: );
421:
422: UPDATE igs_uc_cyc_defaults
423: SET
424: ucas_interface = new_references.ucas_interface,
425: marvin_seq = new_references.marvin_seq,
426: clearing_flag = new_references.clearing_flag,

Line 465: FROM igs_uc_cyc_defaults

461: || Bug# 3022067. Removed columns referring to calendars.
462: */
463: CURSOR c1 IS
464: SELECT rowid
465: FROM igs_uc_cyc_defaults
466: WHERE system_code = x_system_code
467: AND ucas_cycle = x_ucas_cycle;
468:
469: BEGIN

Line 527: DELETE FROM igs_uc_cyc_defaults

523: p_action => 'DELETE',
524: x_rowid => x_rowid
525: );
526:
527: DELETE FROM igs_uc_cyc_defaults
528: WHERE rowid = x_rowid;
529:
530: IF (SQL%NOTFOUND) THEN
531: RAISE NO_DATA_FOUND;

Line 537: END igs_uc_cyc_defaults_pkg;

533:
534: END delete_row;
535:
536:
537: END igs_uc_cyc_defaults_pkg;