APPS.IGS_AD_RVGR_INC_EXC_PKG dependencies on IGS_AD_RVGR_INC_EXC

Line 1: PACKAGE BODY igs_ad_rvgr_inc_exc_pkg AS

1: PACKAGE BODY igs_ad_rvgr_inc_exc_pkg AS
2: /* $Header: IGSAIF5B.pls 115.7 2003/01/23 04:46:37 knag noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_inc_exc%ROWTYPE;

Line 5: old_references igs_ad_rvgr_inc_exc%ROWTYPE;

1: PACKAGE BODY igs_ad_rvgr_inc_exc_pkg AS
2: /* $Header: IGSAIF5B.pls 115.7 2003/01/23 04:46:37 knag noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_inc_exc%ROWTYPE;
6: new_references igs_ad_rvgr_inc_exc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_rvgr_inc_exc%ROWTYPE;

2: /* $Header: IGSAIF5B.pls 115.7 2003/01/23 04:46:37 knag noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_rvgr_inc_exc%ROWTYPE;
6: new_references igs_ad_rvgr_inc_exc%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 39: FROM igs_ad_rvgr_inc_exc

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM igs_ad_rvgr_inc_exc
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 126: FROM igs_ad_rvgr_inc_exc

122: || (reverse chronological order - newest change first)
123: */
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM igs_ad_rvgr_inc_exc
127: WHERE revgr_incl_excl_id = x_revgr_incl_excl_id
128: FOR UPDATE NOWAIT;
129:
130: lv_rowid cur_rowid%RowType;

Line 161: FROM igs_ad_rvgr_inc_exc

157: || (reverse chronological order - newest change first)
158: */
159: CURSOR cur_rowid IS
160: SELECT rowid
161: FROM igs_ad_rvgr_inc_exc
162: WHERE ((appl_revprof_revgr_id = x_appl_revprof_revgr_id));
163:
164: lv_rowid cur_rowid%RowType;
165:

Line 287: FROM igs_ad_rvgr_inc_exc

283: || (reverse chronological order - newest change first)
284: */
285: CURSOR c IS
286: SELECT rowid
287: FROM igs_ad_rvgr_inc_exc
288: WHERE revgr_incl_excl_id = x_revgr_incl_excl_id;
289:
290: x_last_update_date DATE;
291: x_last_updated_by NUMBER;

Line 336: INSERT INTO igs_ad_rvgr_inc_exc (

332: x_last_updated_by => x_last_updated_by,
333: x_last_update_login => x_last_update_login
334: );
335:
336: INSERT INTO igs_ad_rvgr_inc_exc (
337: revgr_incl_excl_id,
338: appl_revprof_revgr_id,
339: incl_excl_ind,
340: start_value,

Line 353: IGS_AD_RVGR_INC_EXC_S.NEXTVAL,

349: last_update_date,
350: last_updated_by,
351: last_update_login
352: ) VALUES (
353: IGS_AD_RVGR_INC_EXC_S.NEXTVAL,
354: new_references.appl_revprof_revgr_id,
355: new_references.incl_excl_ind,
356: new_references.start_value,
357: new_references.end_value,

Line 414: FROM igs_ad_rvgr_inc_exc

410: country,
411: postal_incl_excl_ind,
412: postal_start_value,
413: postal_end_value
414: FROM igs_ad_rvgr_inc_exc
415: WHERE rowid = x_rowid
416: FOR UPDATE NOWAIT;
417:
418: tlinfo c1%ROWTYPE;

Line 524: UPDATE igs_ad_rvgr_inc_exc

520: x_last_updated_by => x_last_updated_by,
521: x_last_update_login => x_last_update_login
522: );
523:
524: UPDATE igs_ad_rvgr_inc_exc
525: SET
526: appl_revprof_revgr_id = new_references.appl_revprof_revgr_id,
527: incl_excl_ind = new_references.incl_excl_ind,
528: start_value = new_references.start_value,

Line 572: FROM igs_ad_rvgr_inc_exc

568: || (reverse chronological order - newest change first)
569: */
570: CURSOR c1 IS
571: SELECT rowid
572: FROM igs_ad_rvgr_inc_exc
573: WHERE revgr_incl_excl_id = x_revgr_incl_excl_id;
574:
575: BEGIN
576:

Line 637: DELETE FROM igs_ad_rvgr_inc_exc

633: p_action => 'DELETE',
634: x_rowid => x_rowid
635: );
636:
637: DELETE FROM igs_ad_rvgr_inc_exc
638: WHERE rowid = x_rowid;
639:
640: IF (SQL%NOTFOUND) THEN
641: RAISE NO_DATA_FOUND;

Line 647: END igs_ad_rvgr_inc_exc_pkg;

643:
644: END delete_row;
645:
646:
647: END igs_ad_rvgr_inc_exc_pkg;