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_AD_TI_COMP dependencies on IGS_CA_INST_ALL

Line 740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

736: AND aa.tracking_id = ti.tracking_id
737: AND ti.tracking_status = ts.tracking_status
738: AND ts.s_tracking_status = 'ACTIVE' ; -- the tracking status should be mapped to system tracking status of 'ACTIVE' ( rghosh, bug#2919317)
739:
740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;

Line 741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

737: AND ti.tracking_status = ts.tracking_status
738: AND ts.s_tracking_status = 'ACTIVE' ; -- the tracking status should be mapped to system tracking status of 'ACTIVE' ( rghosh, bug#2919317)
739:
740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

Line 742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;

738: AND ts.s_tracking_status = 'ACTIVE' ; -- the tracking status should be mapped to system tracking status of 'ACTIVE' ( rghosh, bug#2919317)
739:
740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
746: l_count NUMBER;

Line 743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

739:
740: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
741: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
742: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
743: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
744: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
745: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
746: l_count NUMBER;
747: l_records_not_found BOOLEAN := TRUE;