APPS.IGS_AD_APL_REV_PRF_PKG dependencies on IGS_AD_APL_REV_PRF_ALL

Line 5: old_references igs_ad_apl_rev_prf_all%ROWTYPE;

1: PACKAGE BODY igs_ad_apl_rev_prf_pkg AS
2: /* $Header: IGSAIF2B.pls 115.9 2003/10/30 13:17:39 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_apl_rev_prf_all%ROWTYPE;
6: new_references igs_ad_apl_rev_prf_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_apl_rev_prf_all%ROWTYPE;

2: /* $Header: IGSAIF2B.pls 115.9 2003/10/30 13:17:39 akadam noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_apl_rev_prf_all%ROWTYPE;
6: new_references igs_ad_apl_rev_prf_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 40: FROM igs_ad_apl_rev_prf_all

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

Line 125: FROM igs_ad_apl_rev_prf_all

121: || (reverse chronological order - newest change first)
122: */
123: CURSOR cur_rowid IS
124: SELECT rowid
125: FROM igs_ad_apl_rev_prf_all
126: WHERE ((appl_rev_profile_gr_cd = x_appl_rev_profile_gr_cd));
127:
128: lv_rowid cur_rowid%RowType;
129:

Line 189: FROM igs_ad_apl_rev_prf_all

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_ad_apl_rev_prf_all
190: WHERE appl_rev_profile_id = x_appl_rev_profile_id AND
191: closed_ind = NVL(x_closed_ind,closed_ind)
192: FOR UPDATE NOWAIT;
193:

Line 364: FROM igs_ad_apl_rev_prf_all

360: || (reverse chronological order - newest change first)
361: */
362: CURSOR c IS
363: SELECT rowid
364: FROM igs_ad_apl_rev_prf_all
365: WHERE appl_rev_profile_id = x_appl_rev_profile_id;
366:
367: x_last_update_date DATE;
368: x_last_updated_by NUMBER;

Line 416: INSERT INTO igs_ad_apl_rev_prf_all (

412: x_last_updated_by => x_last_updated_by,
413: x_last_update_login => x_last_update_login
414: );
415:
416: INSERT INTO igs_ad_apl_rev_prf_all (
417: appl_rev_profile_id,
418: org_id,
419: review_profile_name,
420: start_date,

Line 500: FROM igs_ad_apl_rev_prf_all

496: sequential_concurrent_ind,
497: appl_rev_profile_gr_cd,
498: site_use_code,
499: closed_ind
500: FROM igs_ad_apl_rev_prf_all
501: WHERE rowid = x_rowid
502: FOR UPDATE NOWAIT;
503:
504: tlinfo c1%ROWTYPE;

Line 613: UPDATE igs_ad_apl_rev_prf_all

609: x_last_updated_by => x_last_updated_by,
610: x_last_update_login => x_last_update_login
611: );
612:
613: UPDATE igs_ad_apl_rev_prf_all
614: SET
615: review_profile_name = new_references.review_profile_name,
616: start_date = new_references.start_date,
617: end_date = new_references.end_date,

Line 663: FROM igs_ad_apl_rev_prf_all

659: || (reverse chronological order - newest change first)
660: */
661: CURSOR c1 IS
662: SELECT rowid
663: FROM igs_ad_apl_rev_prf_all
664: WHERE appl_rev_profile_id = x_appl_rev_profile_id;
665:
666: BEGIN
667:

Line 730: DELETE FROM igs_ad_apl_rev_prf_all

726: p_action => 'DELETE',
727: x_rowid => x_rowid
728: );
729:
730: DELETE FROM igs_ad_apl_rev_prf_all
731: WHERE rowid = x_rowid;
732:
733: IF (SQL%NOTFOUND) THEN
734: RAISE NO_DATA_FOUND;