APPS.IGS_EN_INTM_RCONDS_PKG dependencies on IGS_EN_INTM_RCONDS

Line 1: PACKAGE BODY igs_en_intm_rconds_pkg AS

1: PACKAGE BODY igs_en_intm_rconds_pkg AS
2: /* $Header: IGSEI80B.pls 120.0 2006/04/10 04:55:42 bdeviset noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_rconds%ROWTYPE;

Line 5: old_references igs_en_intm_rconds%ROWTYPE;

1: PACKAGE BODY igs_en_intm_rconds_pkg AS
2: /* $Header: IGSEI80B.pls 120.0 2006/04/10 04:55:42 bdeviset noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_rconds%ROWTYPE;
6: new_references igs_en_intm_rconds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_intm_rconds%ROWTYPE;

2: /* $Header: IGSEI80B.pls 120.0 2006/04/10 04:55:42 bdeviset noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_intm_rconds%ROWTYPE;
6: new_references igs_en_intm_rconds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_en_intm_rconds

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

Line 86: FROM igs_en_intm_rconds

82: || (reverse chronological order - newest change first)
83: */
84: CURSOR cur_rowid IS
85: SELECT rowid
86: FROM igs_en_intm_rconds
87: WHERE return_condition = x_return_condition
88: FOR UPDATE NOWAIT;
89:
90: lv_rowid cur_rowid%RowType;

Line 207: fnd_message.set_token ('ROUTINE', 'IGS_EN_INTM_RCONDS_PKG.INSERT_ROW');

203: x_last_update_login := -1;
204: END IF;
205: ELSE
206: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
207: fnd_message.set_token ('ROUTINE', 'IGS_EN_INTM_RCONDS_PKG.INSERT_ROW');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211:

Line 227: INSERT INTO igs_en_intm_rconds (

223: x_last_updated_by => x_last_updated_by,
224: x_last_update_login => x_last_update_login
225: );
226:
227: INSERT INTO igs_en_intm_rconds (
228: return_condition,
229: description,
230: closed_flag,
231: creation_date,

Line 269: FROM igs_en_intm_rconds

265: CURSOR c1 IS
266: SELECT
267: description,
268: closed_flag
269: FROM igs_en_intm_rconds
270: WHERE rowid = x_rowid
271: FOR UPDATE NOWAIT;
272:
273: tlinfo c1%ROWTYPE;

Line 341: fnd_message.set_token ('ROUTINE', 'IGS_EN_INTM_RCONDS_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_EN_INTM_RCONDS_PKG.UPDATE_ROW');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345:

Line 359: UPDATE igs_en_intm_rconds

355: x_last_updated_by => x_last_updated_by,
356: x_last_update_login => x_last_update_login
357: );
358:
359: UPDATE igs_en_intm_rconds
360: SET
361: description = new_references.description,
362: closed_flag = new_references.closed_flag,
363: last_update_date = x_last_update_date,

Line 393: FROM igs_en_intm_rconds

389: || (reverse chronological order - newest change first)
390: */
391: CURSOR c1 IS
392: SELECT rowid
393: FROM igs_en_intm_rconds
394: WHERE return_condition = x_return_condition;
395:
396: BEGIN
397:

Line 444: DELETE FROM igs_en_intm_rconds

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

Line 454: END igs_en_intm_rconds_pkg;

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