APPS.IGS_AD_APL_RVPF_RSL_PKG dependencies on IGS_AD_RATING_SCALES

Line 138: ELSIF NOT igs_ad_rating_scales_pkg.get_pk_for_validation (

134:
135: IF (((old_references.rating_scale_id = new_references.rating_scale_id)) OR
136: ((new_references.rating_scale_id IS NULL))) THEN
137: NULL;
138: ELSIF NOT igs_ad_rating_scales_pkg.get_pk_for_validation (
139: new_references.rating_scale_id ,
140: 'N'
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 159: SELECT end_date FROM igs_ad_rating_scales rs,

155: x_rating_type_id IN NUMBER
156: ) AS
157: CURSOR c_rating_scale_closed(l_appl_rev_profile_id igs_ad_apl_rvpf_rsl.appl_rev_profile_id%TYPE,
158: l_rating_type_id NUMBER) IS
159: SELECT end_date FROM igs_ad_rating_scales rs,
160: igs_ad_apl_rvpf_rsl ars,
161: igs_ad_code_classes cc
162: WHERE rs.rating_scale_id = ars.rating_scale_id
163: AND cc.code_id = ars.rating_type_id

Line 167: lv_end_date igs_ad_rating_scales.end_date%TYPE;

163: AND cc.code_id = ars.rating_type_id
164: AND ars.rating_type_id = l_rating_type_id
165: AND ars.appl_rev_profile_id=l_appl_rev_profile_id;
166:
167: lv_end_date igs_ad_rating_scales.end_date%TYPE;
168:
169: BEGIN
170: OPEN c_rating_scale_closed(x_appl_rev_profile_id, x_rating_type_id);
171: FETCH c_rating_scale_closed INTO lv_end_date;

Line 331: PROCEDURE get_fk_igs_ad_rating_scales (

327:
328: END get_fk_igs_ad_code_classes;
329:
330:
331: PROCEDURE get_fk_igs_ad_rating_scales (
332: x_rating_scale_id IN NUMBER
333: ) AS
334: /*
335: || Created By : [email protected]

Line 345: FROM igs_ad_rating_scales

341: || (reverse chronological order - newest change first)
342: */
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM igs_ad_rating_scales
346: WHERE ((rating_scale_id = x_rating_scale_id));
347:
348: lv_rowid cur_rowid%RowType;
349:

Line 363: END get_fk_igs_ad_rating_scales;

359: RETURN;
360: END IF;
361: CLOSE cur_rowid;
362:
363: END get_fk_igs_ad_rating_scales;
364:
365:
366:
367: PROCEDURE before_dml (