APPS.IGS_SS_ENR_DETAILS dependencies on IGS_EN_SPA_TERMS

Line 1266: AND pv.version_number = igs_en_spa_terms_api.get_spat_program_version(sca.person_id, sca.course_cd, p_term_cal_type,

1262: pv.title
1263: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1264: IGS_PS_VER_ALL pv
1265: WHERE pv.course_cd = sca.course_cd
1266: AND pv.version_number = igs_en_spa_terms_api.get_spat_program_version(sca.person_id, sca.course_cd, p_term_cal_type,
1267: p_term_sequence_number)
1268: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
1269: AND sca.person_id = p_person_id
1270: AND pv.course_type = p_carrer

Line 1271: AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, p_term_cal_type,

1267: p_term_sequence_number)
1268: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
1269: AND sca.person_id = p_person_id
1270: AND pv.course_type = p_carrer
1271: AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, p_term_cal_type,
1272: p_term_sequence_number) = 'PRIMARY';
1273:
1274:
1275:

Line 2487: AND ((igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) = 'PRIMARY') OR

2483: AND pv.version_number = sca.version_number
2484: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2485: AND sca.person_id = cp_person_id
2486: AND sca.course_cd = cp_program_cd
2487: AND ((igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) = 'PRIMARY') OR
2488: (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N')= 'N')
2489: );
2490:
2491: l_prg_title igs_ps_ver_all.title%TYPE;

Line 2533: AND igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) <> 'PRIMARY'

2529: WHERE pv.course_cd = sca.course_cd
2530: AND pv.version_number = sca.version_number
2531: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2532: AND sca.person_id = cp_person_id
2533: AND igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) <> 'PRIMARY'
2534: AND pv.course_type = (SELECT course_type
2535: FROM igs_ps_ver_all
2536: WHERE course_cd = cp_program_cd
2537: AND version_number = cp_version_number);

Line 4684: FROM igs_en_spa_terms

4680: cp_course_cd IN VARCHAR2,
4681: cp_load_cal_type IN VARCHAR2,
4682: cp_load_seq_num IN NUMBER) IS
4683: SELECT plan_sht_status
4684: FROM igs_en_spa_terms
4685: WHERE person_id= cp_person_id
4686: AND program_cd=cp_course_cd
4687: AND term_cal_type=cp_load_cal_type
4688: AND term_sequence_number=cp_load_seq_num;

Line 4708: l_spat_plan_flag igs_en_spa_terms.plan_sht_status%TYPE;

4704: l_planning_open BOOLEAN;
4705: l_schedule_open BOOLEAN;
4706: l_calling_object VARCHAR2(100);
4707:
4708: l_spat_plan_flag igs_en_spa_terms.plan_sht_status%TYPE;
4709: l_system_type igs_pe_person_types.system_type%TYPE;
4710:
4711:
4712: BEGIN