APPS.IGS_EN_DISC_DL_CONS_PKG dependencies on IGS_EN_DISC_DL_CONS

Line 1: PACKAGE BODY igs_en_disc_dl_cons_pkg AS

1: PACKAGE BODY igs_en_disc_dl_cons_pkg AS
2: /* $Header: IGSEI44B.pls 115.6 2002/11/28 23:43:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_disc_dl_cons%ROWTYPE;

Line 5: old_references igs_en_disc_dl_cons%ROWTYPE;

1: PACKAGE BODY igs_en_disc_dl_cons_pkg AS
2: /* $Header: IGSEI44B.pls 115.6 2002/11/28 23:43:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_disc_dl_cons%ROWTYPE;
6: new_references igs_en_disc_dl_cons%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_disc_dl_cons%ROWTYPE;

2: /* $Header: IGSEI44B.pls 115.6 2002/11/28 23:43:05 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_disc_dl_cons%ROWTYPE;
6: new_references igs_en_disc_dl_cons%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_EN_DISC_DL_CONS

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_EN_DISC_DL_CONS
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 141: FROM igs_en_disc_dl_cons

137: || (reverse chronological order - newest change first)
138: */
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM igs_en_disc_dl_cons
142: WHERE disc_dl_cons_id = x_disc_dl_cons_id
143: FOR UPDATE NOWAIT;
144:
145: lv_rowid cur_rowid%RowType;

Line 177: FROM igs_en_disc_dl_cons

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igs_en_disc_dl_cons
178: WHERE offset_cons_type_cd = x_offset_cons_type_cd
179: AND non_std_disc_dl_stp_id = x_non_std_disc_dl_stp_id
180: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
181:

Line 213: FROM igs_en_disc_dl_cons

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igs_en_disc_dl_cons
214: WHERE ((non_std_disc_dl_stp_id = x_non_std_disc_dl_stp_id));
215:
216: lv_rowid cur_rowid%RowType;
217:

Line 329: FROM igs_en_disc_dl_cons

325: || (reverse chronological order - newest change first)
326: */
327: CURSOR c IS
328: SELECT rowid
329: FROM igs_en_disc_dl_cons
330: WHERE disc_dl_cons_id = x_disc_dl_cons_id;
331:
332: x_last_update_date DATE;
333: x_last_updated_by NUMBER;

Line 357: SELECT igs_en_disc_dl_cons_s.NEXTVAL

353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356:
357: SELECT igs_en_disc_dl_cons_s.NEXTVAL
358: INTO x_disc_dl_cons_id
359: FROM dual;
360:
361: before_dml(

Line 376: INSERT INTO igs_en_disc_dl_cons (

372: x_last_updated_by => x_last_updated_by,
373: x_last_update_login => x_last_update_login
374: );
375:
376: INSERT INTO igs_en_disc_dl_cons (
377: disc_dl_cons_id,
378: offset_cons_type_cd,
379: constraint_condition,
380: constraint_resolution,

Line 434: FROM igs_en_disc_dl_cons

430: offset_cons_type_cd,
431: constraint_condition,
432: constraint_resolution,
433: non_std_disc_dl_stp_id
434: FROM igs_en_disc_dl_cons
435: WHERE rowid = x_rowid
436: FOR UPDATE NOWAIT;
437:
438: tlinfo c1%ROWTYPE;

Line 529: UPDATE igs_en_disc_dl_cons

525: x_last_updated_by => x_last_updated_by,
526: x_last_update_login => x_last_update_login
527: );
528:
529: UPDATE igs_en_disc_dl_cons
530: SET
531: offset_cons_type_cd = new_references.offset_cons_type_cd,
532: constraint_condition = new_references.constraint_condition,
533: constraint_resolution = new_references.constraint_resolution,

Line 567: FROM igs_en_disc_dl_cons

563: || (reverse chronological order - newest change first)
564: */
565: CURSOR c1 IS
566: SELECT rowid
567: FROM igs_en_disc_dl_cons
568: WHERE disc_dl_cons_id = x_disc_dl_cons_id;
569:
570: BEGIN
571:

Line 622: DELETE FROM igs_en_disc_dl_cons

618: p_action => 'DELETE',
619: x_rowid => x_rowid
620: );
621:
622: DELETE FROM igs_en_disc_dl_cons
623: WHERE rowid = x_rowid;
624:
625: IF (SQL%NOTFOUND) THEN
626: RAISE NO_DATA_FOUND;

Line 632: END igs_en_disc_dl_cons_pkg;

628:
629: END delete_row;
630:
631:
632: END igs_en_disc_dl_cons_pkg;