APPS.IGS_EN_DL_OFFSET_CONS_PKG dependencies on IGS_EN_DL_OFFSET_CONS

Line 1: PACKAGE BODY igs_en_dl_offset_cons_pkg AS

1: PACKAGE BODY igs_en_dl_offset_cons_pkg AS
2: /* $Header: IGSEI45B.pls 120.0 2005/06/01 23:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_dl_offset_cons%ROWTYPE;

Line 5: old_references igs_en_dl_offset_cons%ROWTYPE;

1: PACKAGE BODY igs_en_dl_offset_cons_pkg AS
2: /* $Header: IGSEI45B.pls 120.0 2005/06/01 23:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_dl_offset_cons%ROWTYPE;
6: new_references igs_en_dl_offset_cons%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_dl_offset_cons%ROWTYPE;

2: /* $Header: IGSEI45B.pls 120.0 2005/06/01 23:46:34 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_dl_offset_cons%ROWTYPE;
6: new_references igs_en_dl_offset_cons%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_EN_DL_OFFSET_CONS

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

Line 186: FROM igs_en_dl_offset_cons

182: || (reverse chronological order - newest change first)
183: */
184: CURSOR cur_rowid IS
185: SELECT rowid
186: FROM igs_en_dl_offset_cons
187: WHERE enr_dl_offset_cons_id = x_enr_dl_offset_cons_id
188: FOR UPDATE NOWAIT;
189:
190: lv_rowid cur_rowid%RowType;

Line 223: FROM igs_en_dl_offset_cons

219: || (reverse chronological order - newest change first)
220: */
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igs_en_dl_offset_cons
224: WHERE offset_cons_type_cd = x_offset_cons_type_cd
225: AND non_std_usec_dls_id = x_non_std_usec_dls_id
226: AND deadline_type = x_deadline_type
227: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 260: FROM igs_en_dl_offset_cons

256: || (reverse chronological order - newest change first)
257: */
258: CURSOR cur_rowid IS
259: SELECT rowid
260: FROM igs_en_dl_offset_cons
261: WHERE non_std_usec_dls_id = x_non_std_usec_dls_id
262: AND deadline_type = 'E' ;
263:
264: lv_rowid cur_rowid%RowType;

Line 295: FROM igs_en_dl_offset_cons

291: || (reverse chronological order - newest change first)
292: */
293: CURSOR cur_rowid IS
294: SELECT rowid
295: FROM igs_en_dl_offset_cons
296: WHERE non_std_usec_dls_id = x_non_std_usec_dls_id
297: AND DEADLINE_TYPE = 'R';
298:
299: lv_rowid cur_rowid%RowType;

Line 417: FROM igs_en_dl_offset_cons

413: || (reverse chronological order - newest change first)
414: */
415: CURSOR c IS
416: SELECT rowid
417: FROM igs_en_dl_offset_cons
418: WHERE enr_dl_offset_cons_id = x_enr_dl_offset_cons_id;
419:
420: x_last_update_date DATE;
421: x_last_updated_by NUMBER;

Line 445: SELECT igs_en_dl_offset_cons_s.NEXTVAL

441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
445: SELECT igs_en_dl_offset_cons_s.NEXTVAL
446: INTO x_enr_dl_offset_cons_id
447: FROM dual;
448:
449: before_dml(

Line 465: INSERT INTO igs_en_dl_offset_cons (

461: x_last_updated_by => x_last_updated_by,
462: x_last_update_login => x_last_update_login
463: );
464:
465: INSERT INTO igs_en_dl_offset_cons (
466: enr_dl_offset_cons_id,
467: offset_cons_type_cd,
468: constraint_condition,
469: constraint_resolution,

Line 527: FROM igs_en_dl_offset_cons

523: constraint_condition,
524: constraint_resolution,
525: non_std_usec_dls_id,
526: deadline_type
527: FROM igs_en_dl_offset_cons
528: WHERE rowid = x_rowid
529: FOR UPDATE NOWAIT;
530:
531: tlinfo c1%ROWTYPE;

Line 625: UPDATE igs_en_dl_offset_cons

621: x_last_updated_by => x_last_updated_by,
622: x_last_update_login => x_last_update_login
623: );
624:
625: UPDATE igs_en_dl_offset_cons
626: SET
627: offset_cons_type_cd = new_references.offset_cons_type_cd,
628: constraint_condition = new_references.constraint_condition,
629: constraint_resolution = new_references.constraint_resolution,

Line 665: FROM igs_en_dl_offset_cons

661: || (reverse chronological order - newest change first)
662: */
663: CURSOR c1 IS
664: SELECT rowid
665: FROM igs_en_dl_offset_cons
666: WHERE enr_dl_offset_cons_id = x_enr_dl_offset_cons_id;
667:
668: BEGIN
669:

Line 722: DELETE FROM igs_en_dl_offset_cons

718: p_action => 'DELETE',
719: x_rowid => x_rowid
720: );
721:
722: DELETE FROM igs_en_dl_offset_cons
723: WHERE rowid = x_rowid;
724:
725: IF (SQL%NOTFOUND) THEN
726: RAISE NO_DATA_FOUND;

Line 732: END igs_en_dl_offset_cons_pkg;

728:
729: END delete_row;
730:
731:
732: END igs_en_dl_offset_cons_pkg;