APPS.IGS_AD_APL_REV_PRF_PKG dependencies on IGS_AD_APL_REV_PRF

Line 1: PACKAGE BODY igs_ad_apl_rev_prf_pkg AS

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;

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 159: igs_ad_apl_rprf_rgr_pkg.get_fk_igs_ad_apl_rev_prf (

155: || (reverse chronological order - newest change first)
156: */
157: BEGIN
158:
159: igs_ad_apl_rprf_rgr_pkg.get_fk_igs_ad_apl_rev_prf (
160: old_references.appl_rev_profile_id
161: );
162:
163: igs_ad_apl_rvpf_rsl_pkg.get_fk_igs_ad_apl_rev_prf (

Line 163: igs_ad_apl_rvpf_rsl_pkg.get_fk_igs_ad_apl_rev_prf (

159: igs_ad_apl_rprf_rgr_pkg.get_fk_igs_ad_apl_rev_prf (
160: old_references.appl_rev_profile_id
161: );
162:
163: igs_ad_apl_rvpf_rsl_pkg.get_fk_igs_ad_apl_rev_prf (
164: old_references.appl_rev_profile_id
165: );
166:
167: igs_ad_appl_arp_pkg.get_fk_igs_ad_apl_rev_prf (

Line 167: igs_ad_appl_arp_pkg.get_fk_igs_ad_apl_rev_prf (

163: igs_ad_apl_rvpf_rsl_pkg.get_fk_igs_ad_apl_rev_prf (
164: old_references.appl_rev_profile_id
165: );
166:
167: igs_ad_appl_arp_pkg.get_fk_igs_ad_apl_rev_prf (
168: old_references.appl_rev_profile_id
169: );
170:
171: END check_child_existance;

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 226: FROM igs_ad_apl_rev_prf

222: || (reverse chronological order - newest change first)
223: */
224: CURSOR cur_rowid IS
225: SELECT rowid
226: FROM igs_ad_apl_rev_prf
227: WHERE review_profile_name = x_review_profile_name
228: AND ((l_rowid IS NULL) OR (rowid <> l_rowid))
229: AND closed_ind = NVL(x_closed_ind,closed_ind);
230:

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 435: igs_ad_apl_rev_prf_s.NEXTVAL,

431: last_update_date,
432: last_updated_by,
433: last_update_login
434: ) VALUES (
435: igs_ad_apl_rev_prf_s.NEXTVAL,
436: new_references.org_id,
437: new_references.review_profile_name,
438: new_references.start_date,
439: new_references.end_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;

Line 740: END igs_ad_apl_rev_prf_pkg;

736:
737: END delete_row;
738:
739:
740: END igs_ad_apl_rev_prf_pkg;