eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_011 dependencies on IGS_EN_SPA_TERMS

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 1029: FROM igs_en_spa_terms

1025: ------------------------------------------------------------------------------
1026:
1027: CURSOR c_terms IS
1028: SELECT attendance_type, attendance_mode, location_cd
1029: FROM igs_en_spa_terms
1030: WHERE
1031: person_id = p_sca_person_id AND
1032: program_cd = p_sca_course_cd AND
1033: term_cal_type = p_term_cal_type AND

Line 1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;

1034: term_sequence_number = p_term_sequence_number;
1035:
1036: lc_terms c_terms%ROWTYPE;
1037: l_return_status VARCHAR2(1);
1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;
1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;
1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;

Line 1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;

1035:
1036: lc_terms c_terms%ROWTYPE;
1037: l_return_status VARCHAR2(1);
1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;
1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;
1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;
1043:

Line 1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;

1036: lc_terms c_terms%ROWTYPE;
1037: l_return_status VARCHAR2(1);
1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;
1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;
1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;
1043:
1044: BEGIN

Line 1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;

1037: l_return_status VARCHAR2(1);
1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;
1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;
1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;
1043:
1044: BEGIN
1045: l_return_status := 'N';

Line 1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;

1038: l_para_course_cd igs_en_spa_terms.program_cd%TYPE;
1039: l_para_version_number igs_en_spa_terms.program_version%TYPE;
1040: l_para_attendance_type igs_en_spa_terms.attendance_type%TYPE;
1041: l_para_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;
1042: l_para_location_cd igs_en_spa_terms.location_cd%TYPE;
1043:
1044: BEGIN
1045: l_return_status := 'N';
1046: IF (NVL(p_para_course_cd,'%')='%') THEN

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

Line 3100: igs_en_spa_terms spat

3096: cp_load_sequence_number IN NUMBER)
3097: IS
3098: SELECT NVL(spat.coo_id, spa.coo_id) coo_id
3099: FROM igs_en_stdnt_ps_att spa,
3100: igs_en_spa_terms spat
3101: WHERE
3102: spa.course_cd = cp_course_cd AND
3103: spa.person_id = cp_person_id AND
3104: spat.term_cal_type(+) = cp_load_cal_type AND