APPS.IGS_EN_NSTD_USEC_DL_PKG dependencies on IGS_EN_NSTD_USEC_DL

Line 1: PACKAGE BODY igs_en_nstd_usec_dl_pkg AS

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

Line 5: old_references igs_en_nstd_usec_dl%ROWTYPE;

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

Line 6: new_references igs_en_nstd_usec_dl%ROWTYPE;

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

Line 42: FROM IGS_EN_NSTD_USEC_DL

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_EN_NSTD_USEC_DL
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 168: FROM igs_en_nstd_usec_dl

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_en_nstd_usec_dl
169: WHERE nstd_usec_dl_id = x_nstd_usec_dl_id
170: FOR UPDATE NOWAIT;
171:
172: lv_rowid cur_rowid%RowType;

Line 204: FROM igs_en_nstd_usec_dl

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM igs_en_nstd_usec_dl
205: WHERE ((function_name = x_function_name) OR (function_name IS NULL AND x_function_name IS NULL))
206: AND uoo_id = x_uoo_id
207: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
208:

Line 240: FROM igs_en_nstd_usec_dl

236: || (reverse chronological order - newest change first)
237: */
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM igs_en_nstd_usec_dl
241: WHERE ((uoo_id = x_uoo_id));
242:
243: lv_rowid cur_rowid%RowType;
244:

Line 275: FROM igs_en_nstd_usec_dl

271: || (reverse chronological order - newest change first)
272: */
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM igs_en_nstd_usec_dl
276: WHERE ((non_std_usec_dls_id = x_non_std_usec_dls_id));
277:
278: lv_rowid cur_rowid%RowType;
279:

Line 415: FROM igs_en_nstd_usec_dl

411: || (reverse chronological order - newest change first)
412: */
413: CURSOR c IS
414: SELECT rowid
415: FROM igs_en_nstd_usec_dl
416: WHERE nstd_usec_dl_id = x_nstd_usec_dl_id;
417:
418: x_last_update_date DATE;
419: x_last_updated_by NUMBER;

Line 443: SELECT igs_en_nstd_usec_dl_s.NEXTVAL

439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442:
443: SELECT igs_en_nstd_usec_dl_s.NEXTVAL
444: INTO x_nstd_usec_dl_id
445: FROM dual;
446:
447: before_dml(

Line 470: INSERT INTO igs_en_nstd_usec_dl (

466: x_last_updated_by => x_last_updated_by,
467: x_last_update_login => x_last_update_login
468: );
469:
470: INSERT INTO igs_en_nstd_usec_dl (
471: nstd_usec_dl_id,
472: non_std_usec_dls_id,
473: function_name,
474: definition_code,

Line 560: FROM igs_en_nstd_usec_dl

556: uoo_id,
557: enr_dl_date,
558: enr_dl_total_days,
559: enr_dl_offset_days
560: FROM igs_en_nstd_usec_dl
561: WHERE rowid = x_rowid
562: FOR UPDATE NOWAIT;
563:
564: tlinfo c1%ROWTYPE;

Line 679: UPDATE igs_en_nstd_usec_dl

675: x_last_updated_by => x_last_updated_by,
676: x_last_update_login => x_last_update_login
677: );
678:
679: UPDATE igs_en_nstd_usec_dl
680: SET
681: non_std_usec_dls_id = new_references.non_std_usec_dls_id,
682: function_name = new_references.function_name,
683: definition_code = new_references.definition_code,

Line 733: FROM igs_en_nstd_usec_dl

729: || (reverse chronological order - newest change first)
730: */
731: CURSOR c1 IS
732: SELECT rowid
733: FROM igs_en_nstd_usec_dl
734: WHERE nstd_usec_dl_id = x_nstd_usec_dl_id;
735:
736: BEGIN
737:

Line 804: DELETE FROM igs_en_nstd_usec_dl

800: p_action => 'DELETE',
801: x_rowid => x_rowid
802: );
803:
804: DELETE FROM igs_en_nstd_usec_dl
805: WHERE rowid = x_rowid;
806:
807: IF (SQL%NOTFOUND) THEN
808: RAISE NO_DATA_FOUND;

Line 814: END igs_en_nstd_usec_dl_pkg;

810:
811: END delete_row;
812:
813:
814: END igs_en_nstd_usec_dl_pkg;