APPS.IGS_AD_IMP_015 dependencies on FND_PROFILE

Line 231: IF (fnd_profile.value('IGS_RECRUITING_ENABLED') IS NULL OR fnd_profile.value('IGS_RECRUITING_ENABLED') = 'N') THEN

227:
228: END IF; -- g_person_recruit_dtls_inc
229:
230: --Dynamic Code block to be executed when IGR functionality is enabled.
231: IF (fnd_profile.value('IGS_RECRUITING_ENABLED') IS NULL OR fnd_profile.value('IGS_RECRUITING_ENABLED') = 'N') THEN
232:
233: IF igs_ad_gen_016.chk_src_cat (p_source_type_id, 'INQUIRY_INSTANCE') = TRUE THEN
234: --Log error "Inquiry Instance related information is not Processed as Oracle Student Recruiting functionality is not enabled for the user".
235: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET_STRING('IGS','IGS_AD_INQ_NOT_PRCSD'));

Line 247: ELSIF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

243: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET_STRING('IGS','IGS_AD_INQ_NOT_PRCSD'));
244: END IF;
245:
246: END IF;
247: ELSIF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
248:
249: BEGIN
250: l_stmt := ' BEGIN
251: igr_imp_002.prc_ad_category(:1,:2,:3,:4);

Line 954: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

950: l_category_entity_ad_table(24).category_name := 'APPLICANT_NOTES'; l_category_entity_ad_table(24).entity_name := 'IGS_AD_NOTES_INT';
951: l_category_entity_ad_table(25).category_name := 'APPLICANT_UNITSETS_APPLIED'; l_category_entity_ad_table(25).entity_name := 'IGS_AD_UNITSETS_INT';
952: l_category_entity_ad_table(26).category_name := 'APPLICANT_EDU_GOALS'; l_category_entity_ad_table(26).entity_name := 'IGS_AD_EDUGOAL_INT';
953:
954: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
955: l_category_entity_ad_table(27).category_name := 'INQUIRY_INSTANCE'; l_category_entity_ad_table(27).entity_name := 'IGR_I_APPL_INT';
956: l_category_entity_ad_table(28).category_name := 'INQUIRY_INSTANCE'; l_category_entity_ad_table(28).entity_name := 'IGR_I_LINES_INT';
957: l_category_entity_ad_table(29).category_name := 'INQUIRY_INSTANCE'; l_category_entity_ad_table(29).entity_name := 'IGR_I_PKG_INT';
958: l_category_entity_ad_table(30).category_name := 'INQUIRY_INSTANCE'; l_category_entity_ad_table(30).entity_name := 'IGR_I_INFO_INT';

Line 1139: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN

1135: COMMIT;
1136: END IF; -- g_test_result_inc
1137:
1138: --Dynamic Code block to be executed when IGR functionality is enabled.
1139: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN
1140: BEGIN
1141: l_stmt := ' BEGIN
1142: igr_imp_002.del_cmpld_rct_records(:1,:2);
1143: END; ';