APPS.IGS_EN_NSC_OPTIONS_PKG dependencies on IGS_EN_NSC_OPTIONS

Line 1: PACKAGE BODY igs_en_nsc_options_pkg AS

1: PACKAGE BODY igs_en_nsc_options_pkg AS
2: /* $Header: IGSEI62B.pls 115.2 2002/11/28 23:47:32 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsc_options%ROWTYPE;

Line 5: old_references igs_en_nsc_options%ROWTYPE;

1: PACKAGE BODY igs_en_nsc_options_pkg AS
2: /* $Header: IGSEI62B.pls 115.2 2002/11/28 23:47:32 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsc_options%ROWTYPE;
6: new_references igs_en_nsc_options%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_nsc_options%ROWTYPE;

2: /* $Header: IGSEI62B.pls 115.2 2002/11/28 23:47:32 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_nsc_options%ROWTYPE;
6: new_references igs_en_nsc_options%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igs_en_nsc_options

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

Line 112: FROM igs_en_nsc_options

108: || (reverse chronological order - newest change first)
109: */
110: CURSOR cur_rowid IS
111: SELECT rowid
112: FROM igs_en_nsc_options
113: WHERE opt_type = x_opt_type
114: AND opt_val = x_opt_val
115: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
116:

Line 205: FROM igs_en_nsc_options

201: || (reverse chronological order - newest change first)
202: */
203: CURSOR c IS
204: SELECT rowid
205: FROM igs_en_nsc_options
206: WHERE opt_type = x_opt_type
207: AND opt_val = x_opt_val ;
208:
209: x_last_update_date DATE;

Line 247: INSERT INTO igs_en_nsc_options (

243: x_last_updated_by => x_last_updated_by,
244: x_last_update_login => x_last_update_login
245: );
246:
247: INSERT INTO igs_en_nsc_options (
248: opt_type,
249: opt_val,
250: priority,
251: creation_date,

Line 298: FROM igs_en_nsc_options

294: SELECT
295: opt_type,
296: opt_val,
297: priority
298: FROM igs_en_nsc_options
299: WHERE rowid = x_rowid
300: FOR UPDATE NOWAIT;
301:
302: tlinfo c1%ROWTYPE;

Line 388: UPDATE igs_en_nsc_options

384: x_last_updated_by => x_last_updated_by,
385: x_last_update_login => x_last_update_login
386: );
387:
388: UPDATE igs_en_nsc_options
389: SET
390: opt_type = new_references.opt_type,
391: opt_val = new_references.opt_val,
392: priority = new_references.priority,

Line 423: FROM igs_en_nsc_options

419: || (reverse chronological order - newest change first)
420: */
421: CURSOR c1 IS
422: SELECT rowid
423: FROM igs_en_nsc_options
424: WHERE opt_type = x_opt_type
425: AND opt_val = x_opt_val ;
426:
427: BEGIN

Line 475: DELETE FROM igs_en_nsc_options

471: p_action => 'DELETE',
472: x_rowid => x_rowid
473: );
474:
475: DELETE FROM igs_en_nsc_options
476: WHERE rowid = x_rowid;
477:
478: IF (SQL%NOTFOUND) THEN
479: RAISE NO_DATA_FOUND;

Line 485: END igs_en_nsc_options_pkg;

481:
482: END delete_row;
483:
484:
485: END igs_en_nsc_options_pkg;