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_UC_EXPORT_TO_OSS dependencies on IGS_AD_APPL_ALL

Line 67: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c

63: -- Smaddali modified this cursor to add check for c.alt_appl_id , bug 2643048 UCFD012
64: CURSOR c_match_adm_appl(cp_app_no igs_uc_app_choices.app_no%TYPE ,
65: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
66: SELECT c.admission_appl_number, c.person_id
67: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c
68: WHERE a.app_no = b.app_no AND
69: TO_CHAR(a.app_no) = c.alt_appl_id AND
70: a.oss_person_id = c.person_id AND
71: b.choice_no = c.choice_number AND

Line 82: CURSOR c_match_adm_appl_inst ( cp_person_id igs_ad_appl_all.person_id%TYPE,

78: c.adm_appl_status <> 'COMPLETED';
79: c_match_adm_appl_rec c_match_adm_appl%ROWTYPE ;
80:
81: -- Get the admission application instance sequence number corresponding to the passed OSS details
82: CURSOR c_match_adm_appl_inst ( cp_person_id igs_ad_appl_all.person_id%TYPE,
83: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
84: cp_oss_program_code igs_uc_app_choices.oss_program_code%TYPE,
85: cp_oss_program_version igs_uc_app_choices.oss_program_version%TYPE,
86: cp_oss_location igs_uc_app_choices.oss_location%TYPE,

Line 83: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,

79: c_match_adm_appl_rec c_match_adm_appl%ROWTYPE ;
80:
81: -- Get the admission application instance sequence number corresponding to the passed OSS details
82: CURSOR c_match_adm_appl_inst ( cp_person_id igs_ad_appl_all.person_id%TYPE,
83: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
84: cp_oss_program_code igs_uc_app_choices.oss_program_code%TYPE,
85: cp_oss_program_version igs_uc_app_choices.oss_program_version%TYPE,
86: cp_oss_location igs_uc_app_choices.oss_location%TYPE,
87: cp_oss_attendance_mode igs_uc_app_choices.oss_attendance_mode%TYPE,

Line 831: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c

827: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
828: CURSOR c_adm_appl( cp_app_no igs_uc_app_choices.app_no%TYPE,
829: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
830: SELECT c.person_id , c.admission_appl_number
831: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c
832: WHERE a.app_no = b.app_no AND
833: a.oss_person_id = c.person_id AND
834: TO_CHAR(a.app_no) = c.alt_appl_id AND
835: b.choice_no = c.choice_number AND

Line 845: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c

841: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
842: CURSOR c_match_adm_appl(cp_app_no igs_uc_app_choices.app_no%TYPE,
843: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
844: SELECT c.person_id,c.admission_appl_number ,b.choice_no
845: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c
846: WHERE a.app_no = b.app_no AND
847: a.oss_person_id = c.person_id AND
848: TO_CHAR(a.app_no) = c.alt_appl_id AND
849: b.choice_no = c.choice_number AND

Line 868: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,

864: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
865: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,
866: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS
867: SELECT 'X'
868: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,
869: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e
870: WHERE a.app_no = b.app_no AND
871: a.oss_person_id = c.person_id AND
872: TO_CHAR(a.app_no) = c.alt_appl_id AND

Line 907: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,

903: c.person_id , c.admission_appl_number ,c.choice_number, e.sequence_number,
904: e.decision_date , e.decision_reason_id , e.decision_make_id ,e.adm_outcome_status ,
905: e.nominated_course_cd , c.adm_cal_type , c.adm_ci_sequence_number,
906: c.acad_cal_type , c.acad_ci_sequence_number ,c.admission_cat ,c.s_admission_process_type
907: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,
908: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e
909: WHERE a.app_no = b.app_no AND
910: a.oss_person_id = c.person_id AND
911: TO_CHAR(a.app_no) = c.alt_appl_id AND

Line 942: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS

938:
939: -- Get the application to be voided ,i.e the currently active application instance
940: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
941: CURSOR c_obsol_appl_cnt(cp_app_no igs_uc_applicants.app_no%TYPE ,
942: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS
943: SELECT COUNT(*)
944: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,
945: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou
946: WHERE a.app_no = cp_app_no AND

Line 944: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,

940: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
941: CURSOR c_obsol_appl_cnt(cp_app_no igs_uc_applicants.app_no%TYPE ,
942: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS
943: SELECT COUNT(*)
944: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,
945: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou
946: WHERE a.app_no = cp_app_no AND
947: a.oss_person_id = c.person_id AND
948: TO_CHAR(a.app_no) = c.alt_appl_id AND

Line 962: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS

958:
959: -- Get the application to be voided ,i.e the currently active application instance
960: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
961: CURSOR c_obsol_appl(cp_app_no igs_uc_applicants.app_no%TYPE ,
962: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS
963: SELECT c.person_id , c.admission_appl_number ,c.choice_number, e.sequence_number,
964: e.decision_date , e.decision_reason_id , e.decision_make_id ,e.adm_outcome_status ,
965: e.nominated_course_cd , c.adm_cal_type , c.adm_ci_sequence_number,
966: c.acad_cal_type , c.acad_ci_sequence_number ,c.admission_cat ,c.s_admission_process_type

Line 967: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,

963: SELECT c.person_id , c.admission_appl_number ,c.choice_number, e.sequence_number,
964: e.decision_date , e.decision_reason_id , e.decision_make_id ,e.adm_outcome_status ,
965: e.nominated_course_cd , c.adm_cal_type , c.adm_ci_sequence_number,
966: c.acad_cal_type , c.acad_ci_sequence_number ,c.admission_cat ,c.s_admission_process_type
967: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,
968: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou
969: WHERE a.app_no = cp_app_no AND
970: a.oss_person_id = c.person_id AND
971: TO_CHAR(a.app_no) = c.alt_appl_id AND

Line 1104: IGS_AD_APPL_ALL apl,

1100: p_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE ) IS
1101: SELECT apl.person_id,apl.admission_appl_number
1102: FROM IGS_UC_APP_CHOICES uac,
1103: IGS_UC_APPLICANTS ua,
1104: IGS_AD_APPL_ALL apl,
1105: IGS_AD_PS_APPL_ALL aplps,
1106: IGS_AD_PS_APPL_INST_ALL aplinst
1107: WHERE uac.app_no = p_app_no
1108: AND uac.choice_no = p_choice_no

Line 1136: igs_ad_appl_all apl,

1132: 'X'
1133: FROM
1134: igs_uc_app_choices uac,
1135: igs_uc_sys_calndrs ucal,
1136: igs_ad_appl_all apl,
1137: igs_ad_ps_appl_inst_all aplinst,
1138: igs_en_unit_set us,
1139: igs_en_unit_set_cat usc,
1140: igs_ps_us_prenr_cfg cnfg,