APPS.IGS_AD_APL_RVPF_RSL_PKG dependencies on IGS_AD_CODE_CLASSES

Line 125: ELSIF NOT igs_ad_code_classes_pkg.get_uk2_for_validation (

121:
122: IF (((old_references.rating_type_id = new_references.rating_type_id)) OR
123: ((new_references.rating_type_id IS NULL))) THEN
124: NULL;
125: ELSIF NOT igs_ad_code_classes_pkg.get_uk2_for_validation (
126: new_references.rating_type_id ,
127: 'RATING_TYPE',
128: 'N'
129: ) THEN

Line 161: igs_ad_code_classes cc

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
164: AND ars.rating_type_id = l_rating_type_id
165: AND ars.appl_rev_profile_id=l_appl_rev_profile_id;

Line 296: PROCEDURE get_fk_igs_ad_code_classes (

292:
293: END get_fk_igs_ad_apl_rev_prf;
294:
295:
296: PROCEDURE get_fk_igs_ad_code_classes (
297: x_code_id IN NUMBER
298: ) AS
299: /*
300: || Created By : [email protected]

Line 328: END get_fk_igs_ad_code_classes;

324: RETURN;
325: END IF;
326: CLOSE cur_rowid;
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