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.

[Home] [Help]

APPS.IGS_EN_GEN_017 dependencies on IGS_CA_INST

Line 56: l_cal_type igs_ca_inst.cal_type%TYPE;

52: || (reverse chronological order - newest change first)
53: */
54: l_person_id igs_pe_person_base_v.person_id%TYPE;
55: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
56: l_cal_type igs_ca_inst.cal_type%TYPE;
57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;
59: l_primary_version igs_ps_ver.version_number%TYPE;
60: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

Line 57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

53: */
54: l_person_id igs_pe_person_base_v.person_id%TYPE;
55: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
56: l_cal_type igs_ca_inst.cal_type%TYPE;
57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;
59: l_primary_version igs_ps_ver.version_number%TYPE;
60: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
61: l_us_status igs_en_su_attempt.unit_attempt_status%TYPE;

Line 354: l_cal_type igs_ca_inst.cal_type%TYPE;

350: || Who When What
351: */
352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;

Line 355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

351: */
352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

Line 374: cp_cal_type igs_ca_inst.cal_type%TYPE,

370: l_message_data VARCHAR2(1000);
371:
372: CURSOR cur_uoo_id (cp_person_id igs_pe_person.person_id%TYPE,
373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
374: cp_cal_type igs_ca_inst.cal_type%TYPE,
375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
376: SELECT uoo_id
377: FROM igs_en_su_attempt
378: WHERE person_id = cp_person_id

Line 375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS

371:
372: CURSOR cur_uoo_id (cp_person_id igs_pe_person.person_id%TYPE,
373: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
374: cp_cal_type igs_ca_inst.cal_type%TYPE,
375: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)IS
376: SELECT uoo_id
377: FROM igs_en_su_attempt
378: WHERE person_id = cp_person_id
379: AND unit_attempt_status IN ('INVALID','WAITLIST','ENROLLED')

Line 560: FROM igs_ca_inst ci,

556: --or equal to sysdate. The instance with most recent absolute value will be considered as defaulted.
557: CURSOR c_cur_alt_code IS
558: SELECT currterm.alternate_code
559: FROM (SELECT ci.alternate_code
560: FROM igs_ca_inst ci,
561: igs_ca_type ct,
562: igs_ca_stat cs,
563: igs_ca_da_inst dai
564: WHERE ci.cal_type = ct.cal_type

Line 716: FROM igs_ca_inst ci,

712: */
713:
714: CURSOR c_alt_code IS
715: SELECT ci.alternate_code
716: FROM igs_ca_inst ci,
717: igs_ca_type ca,
718: igs_ca_stat cs
719: WHERE ci.cal_type =ca.cal_type
720: AND ci.cal_status = cs.cal_status

Line 857: l_cal_type igs_ca_inst.cal_type%TYPE;

853: || Who When What
854: || (reverse chronological order - newest change first)
855: */
856:
857: l_cal_type igs_ca_inst.cal_type%TYPE;
858: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
859:
860: CURSOR c_uoo_id IS
861: SELECT 'X'

Line 858: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

854: || (reverse chronological order - newest change first)
855: */
856:
857: l_cal_type igs_ca_inst.cal_type%TYPE;
858: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
859:
860: CURSOR c_uoo_id IS
861: SELECT 'X'
862: FROM igs_ps_unit_ofr_opt

Line 866: CURSOR c_chk_call_num_term (cp_cal_type igs_ca_inst.cal_type%TYPE,

862: FROM igs_ps_unit_ofr_opt
863: WHERE call_number = p_call_number;
864: l_dummy VARCHAR2(1);
865:
866: CURSOR c_chk_call_num_term (cp_cal_type igs_ca_inst.cal_type%TYPE,
867: cp_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
868: SELECT uoo_id
869: FROM igs_ps_unit_ofr_opt
870: WHERE call_number = p_call_number

Line 867: cp_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS

863: WHERE call_number = p_call_number;
864: l_dummy VARCHAR2(1);
865:
866: CURSOR c_chk_call_num_term (cp_cal_type igs_ca_inst.cal_type%TYPE,
867: cp_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
868: SELECT uoo_id
869: FROM igs_ps_unit_ofr_opt
870: WHERE call_number = p_call_number
871: AND ( cal_type, ci_sequence_number ) IN

Line 964: l_cal_type igs_ca_inst.cal_type%TYPE;

960: l_error_message VARCHAR2(2000);
961: l_ret_status VARCHAR2(10);
962: l_primary_program_code igs_ps_ver.course_cd%TYPE;
963: l_primary_program_version igs_ps_ver.version_number%TYPE;
964: l_cal_type igs_ca_inst.cal_type%TYPE;
965: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
966: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
967: l_return_status VARCHAR2(10);
968: l_message_count NUMBER;

Line 965: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

961: l_ret_status VARCHAR2(10);
962: l_primary_program_code igs_ps_ver.course_cd%TYPE;
963: l_primary_program_version igs_ps_ver.version_number%TYPE;
964: l_cal_type igs_ca_inst.cal_type%TYPE;
965: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
966: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
967: l_return_status VARCHAR2(10);
968: l_message_count NUMBER;
969: l_message_data VARCHAR2(2000);

Line 1261: FROM igs_ca_inst ci,

1257:
1258: CURSOR c_alt_code IS
1259: SELECT ci.cal_type,
1260: ci.sequence_number
1261: FROM igs_ca_inst ci,
1262: igs_ca_type ca,
1263: igs_ca_stat cs
1264: WHERE ci.alternate_code = p_term_alt_code
1265: AND ci.cal_type = ca.cal_type