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_PS_GEN_001 dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 2394: CURSOR cur_ftci(cp_c_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,

2390: l_resp_flag BOOLEAN ;
2391: l_dest_lead_inst_id igs_ps_usec_tch_resp.instructor_id%TYPE;
2392:
2393: ---------------------------
2394: CURSOR cur_ftci(cp_c_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
2396: SELECT sup_cal_type cal_type, sup_ci_sequence_number sequence_number
2397: FROM igs_ca_inst_rel
2398: WHERE (sub_cal_type,sub_ci_sequence_number) IN (SELECT load_cal_type, load_ci_sequence_number

Line 2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS

2391: l_dest_lead_inst_id igs_ps_usec_tch_resp.instructor_id%TYPE;
2392:
2393: ---------------------------
2394: CURSOR cur_ftci(cp_c_cal_type igs_ca_teach_to_load_v.teach_cal_type%TYPE,
2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
2396: SELECT sup_cal_type cal_type, sup_ci_sequence_number sequence_number
2397: FROM igs_ca_inst_rel
2398: WHERE (sub_cal_type,sub_ci_sequence_number) IN (SELECT load_cal_type, load_ci_sequence_number
2399: FROM igs_ca_teach_to_load_v

Line 2399: FROM igs_ca_teach_to_load_v

2395: cp_n_sequence_number igs_ca_teach_to_load_v.teach_ci_sequence_number%TYPE) IS
2396: SELECT sup_cal_type cal_type, sup_ci_sequence_number sequence_number
2397: FROM igs_ca_inst_rel
2398: WHERE (sub_cal_type,sub_ci_sequence_number) IN (SELECT load_cal_type, load_ci_sequence_number
2399: FROM igs_ca_teach_to_load_v
2400: WHERE teach_cal_type = cp_c_cal_type
2401: AND teach_ci_sequence_number = cp_n_sequence_number);
2402: TYPE teach_cal_rec IS RECORD(
2403: cal_type igs_ca_inst_all.cal_type%TYPE,

Line 4609: ' FROM igs_ca_teach_to_load_v WHERE teach_cal_type = :1 AND'||

4605:
4606: /* Cursor for to get Load calendar when Teach cal is passed */
4607:
4608: OPEN c_get_cal FOR 'SELECT load_cal_type,load_ci_sequence_number'||
4609: ' FROM igs_ca_teach_to_load_v WHERE teach_cal_type = :1 AND'||
4610: ' teach_ci_sequence_number = :2 ' USING p_c_cal_type,p_n_cal_seq_num;
4611:
4612: ELSIF l_c_cal_cat_code = 'ACADEMIC' THEN
4613: