APPS.IGS_AS_PROD_DOC dependencies on FND_PROFILE

Line 276: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') <> 'Y' THEN

272: -- 5. Determine if the document request specified to "Hold for Degree Award".
273: --
274: IF NVL(rec_cur_ord_itm_int.hold_degree_expected,'N') = 'Y' THEN
275: IF rec_cur_ord_itm_int.programs_on_file = 'ALL' THEN
276: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') <> 'Y' THEN
277: OPEN cur_ps_att(rec_cur_ord_itm_int.person_id,
278: rec_cur_ord_itm_int.creation_date,
279: NULL /* To check for all Program Attempts*/);
280: FETCH cur_ps_att INTO rec_cur_ps_att;

Line 288: ELSIF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'Y' THEN

284: p_error_mesg := 'IGS_AS_DEG_AWD_HLD';
285: RETURN;
286: END IF;
287: CLOSE cur_ps_att;
288: ELSIF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'Y' THEN
289: OPEN cur_en_sca(rec_cur_ord_itm_int.person_id,
290: rec_cur_ord_itm_int.creation_date,
291: NULL /* To check for all Careers*/);
292: FETCH cur_en_sca INTO rec_cur_en_sca;

Line 302: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') <> 'Y' THEN

298: END IF;
299: CLOSE cur_en_sca;
300: END IF;
301: ELSE
302: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') <> 'Y' THEN
303: OPEN cur_ps_att(rec_cur_ord_itm_int.person_id,
304: rec_cur_ord_itm_int.creation_date,
305: rec_cur_ord_itm_int.programs_on_file);
306: FETCH cur_ps_att INTO rec_cur_ps_att;

Line 314: ELSIF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'Y' THEN

310: p_error_mesg := 'IGS_AS_DEG_AWD_HLD';
311: RETURN;
312: END IF;
313: CLOSE cur_ps_att;
314: ELSIF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'Y' THEN
315: OPEN cur_en_sca(rec_cur_ord_itm_int.person_id,
316: rec_cur_ord_itm_int.creation_date,
317: rec_cur_ord_itm_int.programs_on_file);
318: FETCH cur_en_sca INTO rec_cur_en_sca;