14: AND cv1.course_cd = spat.program_cd
15: AND cv1.version_number = spat.program_version
16: AND
17: ( (
18: NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y'
19: AND cv1.course_type = (SELECT cv2.course_type
20: FROM IGS_PS_VER cv2
21: WHERE cv2.course_cd = cp_program_cd
22: AND cv2.version_number = cp_program_version)
21: WHERE cv2.course_cd = cp_program_cd
22: AND cv2.version_number = cp_program_version)
23: )
24: OR
25: ( NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N'
26: AND spat.program_cd = cp_program_cd
27: )
28: );
29:
409: AND cv1.course_cd = spat.program_cd
410: AND cv1.version_number = spat.program_version
411: AND
412: ( (
413: NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y'
414: AND cv1.course_type = (SELECT cv2.course_type
415: FROM IGS_PS_VER cv2
416: WHERE cv2.course_cd = cp_program_cd
417: AND cv2.version_number = cp_program_version)
416: WHERE cv2.course_cd = cp_program_cd
417: AND cv2.version_number = cp_program_version)
418: )
419: OR
420: ( NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N'
421: AND spat.program_cd = cp_program_cd
422: )
423: );
424:
698: v_changed_term_rec EN_SPAT_REC_TYPE%TYPE;
699: BEGIN
700:
701: -- check if Career Model is enabled for the System and if called from program transfer
702: IF (p_program_changed AND NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'Y' ) THEN
703: v_check_othr_prgms := 'Y';
704: ELSE
705: v_check_othr_prgms := 'N';
706: END IF;
810: v_term_rec EN_SPAT_REC_TYPE%TYPE;
811: vc_career_model_enabled varchar2(1);
812: BEGIN
813: -- fetch if Career Model is enabled for the System or not
814: vc_career_model_enabled := nvl(fnd_profile.value('CAREER_MODEL_ENABLED'),'N');
815: v_term_rec := p_term_rec;
816: -- if Career Model is enabled
817: -- if Career Model is enabled
818: IF vc_career_model_enabled = 'Y' THEN
1048:
1049: BEGIN
1050:
1051: -- fetch if Career Model is enabled for the System or not
1052: vc_career_model_enabled := NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N');
1053:
1054: -- if Career Model is enabled
1055: IF vc_career_model_enabled = 'Y' THEN
1056:
2310:
2311: BEGIN
2312:
2313: -- check whether Career profile is set or not
2314: l_profile :=NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N');
2315:
2316: -- if system is in Career model
2317: IF l_profile='Y' THEN
2318: OPEN cur_c1;