APPS.IGS_EN_GEN_011 dependencies on IGS_EN_SPA_TERMS_API

Line 271: p_version_number = igs_en_spa_terms_api.get_spat_program_version

267: p_group_id is NOT NULL) OR
268: (p_group_id is NULL))
269: AND
270: (p_version_number IS NULL OR
271: p_version_number = igs_en_spa_terms_api.get_spat_program_version
272: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
273: (p_acad_cal_type = igs_en_spa_terms_api.get_spat_acad_cal_type
274: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
275: (p_location_cd IS NULL OR

Line 273: (p_acad_cal_type = igs_en_spa_terms_api.get_spat_acad_cal_type

269: AND
270: (p_version_number IS NULL OR
271: p_version_number = igs_en_spa_terms_api.get_spat_program_version
272: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
273: (p_acad_cal_type = igs_en_spa_terms_api.get_spat_acad_cal_type
274: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
275: (p_location_cd IS NULL OR
276: p_location_cd = igs_en_spa_terms_api.get_spat_location
277: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND

Line 276: p_location_cd = igs_en_spa_terms_api.get_spat_location

272: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
273: (p_acad_cal_type = igs_en_spa_terms_api.get_spat_acad_cal_type
274: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
275: (p_location_cd IS NULL OR
276: p_location_cd = igs_en_spa_terms_api.get_spat_location
277: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
278: (p_attendance_mode IS NULL OR
279: p_attendance_mode= igs_en_spa_terms_api.get_spat_att_mode
280: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND

Line 279: p_attendance_mode= igs_en_spa_terms_api.get_spat_att_mode

275: (p_location_cd IS NULL OR
276: p_location_cd = igs_en_spa_terms_api.get_spat_location
277: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
278: (p_attendance_mode IS NULL OR
279: p_attendance_mode= igs_en_spa_terms_api.get_spat_att_mode
280: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
281: (p_attendance_type IS NULL OR
282: p_attendance_type= igs_en_spa_terms_api.get_spat_att_type
283: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND

Line 282: p_attendance_type= igs_en_spa_terms_api.get_spat_att_type

278: (p_attendance_mode IS NULL OR
279: p_attendance_mode= igs_en_spa_terms_api.get_spat_att_mode
280: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
281: (p_attendance_type IS NULL OR
282: p_attendance_type= igs_en_spa_terms_api.get_spat_att_type
283: (sca.person_id, sca.course_cd, p_term_cal_type, p_term_sequence_number)) AND
284: sca.course_attempt_status IN (
285: p_course_attempt_status1,
286: NVL(p_course_attempt_status2, p_course_attempt_status1),

Line 732: igs_en_spa_terms_api.create_update_term_rec(

728: X_ATTRIBUTE19 => v_sca_upd_exists.ATTRIBUTE19,
729: X_ATTRIBUTE20 => v_sca_upd_exists.ATTRIBUTE20,
730: X_FUTURE_DATED_TRANS_FLAG => v_sca_upd_exists.FUTURE_DATED_TRANS_FLAG);
731:
732: igs_en_spa_terms_api.create_update_term_rec(
733: p_person_id => v_sca_upd_exists.PERSON_ID,
734: p_program_cd => v_sca_upd_exists.COURSE_CD,
735: p_term_cal_type => p_term_cal_type,
736: p_term_sequence_number => p_term_sequence_number,

Line 1385: AND (igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id,sca.course_cd,

1381: sua.location_cd = NVL(p_unit_loc_cd,sua.location_cd) AND
1382: sua.unit_class = NVL(p_unit_class,sua.unit_class) AND
1383: sua.cal_type = p_teach_cal_type AND
1384: sua.ci_sequence_number = p_teach_ci_sequence_number))
1385: AND (igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id,sca.course_cd,
1386: p_load_cal_type,p_load_cal_seq) = 'PRIMARY'
1387: OR NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N') = 'N')
1388: ORDER BY sca.person_id,
1389: sca.course_cd

Line 2798: p_location_cd = igs_en_spa_terms_api.get_spat_location(

2794: WHERE (
2795: (p_course_cd IS NULL OR sca.course_cd LIKE p_course_cd) AND
2796: (sca.course_attempt_status NOT IN ('LAPSED','DISCONTIN')) AND
2797: (p_location_cd IS NULL OR
2798: p_location_cd = igs_en_spa_terms_api.get_spat_location(
2799: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND
2800: (p_attendance_mode IS NULL OR
2801: p_attendance_mode = igs_en_spa_terms_api.get_spat_att_mode(
2802: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND

Line 2801: p_attendance_mode = igs_en_spa_terms_api.get_spat_att_mode(

2797: (p_location_cd IS NULL OR
2798: p_location_cd = igs_en_spa_terms_api.get_spat_location(
2799: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND
2800: (p_attendance_mode IS NULL OR
2801: p_attendance_mode = igs_en_spa_terms_api.get_spat_att_mode(
2802: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND
2803: (p_attendance_type IS NULL OR
2804: p_attendance_type = igs_en_spa_terms_api.get_spat_att_type(
2805: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND

Line 2804: p_attendance_type = igs_en_spa_terms_api.get_spat_att_type(

2800: (p_attendance_mode IS NULL OR
2801: p_attendance_mode = igs_en_spa_terms_api.get_spat_att_mode(
2802: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND
2803: (p_attendance_type IS NULL OR
2804: p_attendance_type = igs_en_spa_terms_api.get_spat_att_type(
2805: sca.person_id, sca.course_cd, cp_load_cal_type, cp_load_ci_sequence_number)) AND
2806: sca.person_id = sua.person_id AND
2807: sca.course_cd = sua.course_cd AND
2808: sua.unit_cd = p_from_unit_cd AND