APPS.IGS_EN_USEC_DISC_DL_PKG dependencies on IGS_EN_USEC_DISC_DL

Line 1: PACKAGE BODY igs_en_usec_disc_dl_pkg AS

1: PACKAGE BODY igs_en_usec_disc_dl_pkg AS
2: /* $Header: IGSEI49B.pls 115.7 2003/03/21 08:10:24 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_usec_disc_dl%ROWTYPE;

Line 5: old_references igs_en_usec_disc_dl%ROWTYPE;

1: PACKAGE BODY igs_en_usec_disc_dl_pkg AS
2: /* $Header: IGSEI49B.pls 115.7 2003/03/21 08:10:24 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_usec_disc_dl%ROWTYPE;
6: new_references igs_en_usec_disc_dl%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_en_usec_disc_dl%ROWTYPE;

2: /* $Header: IGSEI49B.pls 115.7 2003/03/21 08:10:24 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_en_usec_disc_dl%ROWTYPE;
6: new_references igs_en_usec_disc_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_USEC_DISC_DL

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

Line 168: FROM igs_en_usec_disc_dl

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

Line 204: FROM igs_en_usec_disc_dl

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM igs_en_usec_disc_dl
205: WHERE ((administrative_unit_status = x_administrative_unit_status) OR (administrative_unit_status IS NULL AND x_administrative_unit_status 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_usec_disc_dl

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

Line 275: FROM igs_en_usec_disc_dl

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

Line 417: FROM igs_en_usec_disc_dl

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

Line 445: SELECT igs_en_usec_disc_dl_s.NEXTVAL

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

Line 472: INSERT INTO igs_en_usec_disc_dl (

468: x_last_updated_by => x_last_updated_by,
469: x_last_update_login => x_last_update_login
470: );
471:
472: INSERT INTO igs_en_usec_disc_dl (
473: usec_disc_dl_id,
474: non_std_disc_dl_stp_id,
475: administrative_unit_status,
476: definition_code,

Line 562: FROM igs_en_usec_disc_dl

558: uoo_id,
559: usec_disc_dl_date,
560: usec_disc_total_days,
561: usec_disc_offset_days
562: FROM igs_en_usec_disc_dl
563: WHERE rowid = x_rowid
564: FOR UPDATE NOWAIT;
565:
566: tlinfo c1%ROWTYPE;

Line 681: UPDATE igs_en_usec_disc_dl

677: x_last_updated_by => x_last_updated_by,
678: x_last_update_login => x_last_update_login
679: );
680:
681: UPDATE igs_en_usec_disc_dl
682: SET
683: non_std_disc_dl_stp_id = new_references.non_std_disc_dl_stp_id,
684: administrative_unit_status = new_references.administrative_unit_status,
685: definition_code = new_references.definition_code,

Line 735: FROM igs_en_usec_disc_dl

731: || (reverse chronological order - newest change first)
732: */
733: CURSOR c1 IS
734: SELECT rowid
735: FROM igs_en_usec_disc_dl
736: WHERE usec_disc_dl_id = x_usec_disc_dl_id;
737:
738: BEGIN
739:

Line 806: DELETE FROM igs_en_usec_disc_dl

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

Line 816: END igs_en_usec_disc_dl_pkg;

812:
813: END delete_row;
814:
815:
816: END igs_en_usec_disc_dl_pkg;