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_PS_APPL_INST

Line 60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;

56: l_aca_seq_no igs_uc_sys_calndrs.aca_cal_seq_no%TYPE;
57: l_adm_cal_type igs_uc_sys_calndrs.adm_cal_type%TYPE ;
58: l_adm_seq_no igs_uc_sys_calndrs.adm_cal_seq_no%TYPE ;
59: l_update_adm_appl_number igs_ad_apl_int.update_adm_appl_number%TYPE;
60: l_update_adm_seq_number igs_ad_ps_appl_inst_int.update_adm_seq_number%TYPE;
61:
62: -- Get the admission application corresponding to the passed choice record
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 ,

Line 92: FROM igs_ad_ps_appl_inst acai

88: cp_oss_attendance_type igs_uc_app_choices.oss_attendance_type%TYPE,
89: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
90: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE ) IS
91: SELECT acai.sequence_number
92: FROM igs_ad_ps_appl_inst acai
93: WHERE acai.person_id = cp_person_id
94: AND acai.admission_appl_number = cp_admission_appl_number
95: AND acai.nominated_course_cd = cp_oss_program_code
96: AND acai.crv_version_number = cp_oss_program_version

Line 134: SELECT igs_ad_ps_appl_inst_int_s.NEXTVAL appl_inst_int_id

130: FROM dual;
131: c_int_appl_id_rec c_int_appl_id%ROWTYPE;
132: -- Get application instance interface id
133: CURSOR c_appl_inst_int_id IS
134: SELECT igs_ad_ps_appl_inst_int_s.NEXTVAL appl_inst_int_id
135: FROM dual;
136: appl_inst_int_id_rec c_appl_inst_int_id%ROWTYPE;
137: -- Get ucas application source from code classes
138: CURSOR cur_code_id IS

Line 544: INSERT INTO igs_ad_ps_appl_inst_int

540: l_update_adm_seq_number := c_match_adm_appl_inst_rec.sequence_number ;
541: END IF ;
542: CLOSE c_match_adm_appl_inst ;
543:
544: INSERT INTO igs_ad_ps_appl_inst_int
545: ( interface_appl_id
546: ,interface_ps_appl_inst_id
547: ,nominated_course_cd
548: ,req_for_adv_standing_ind

Line 864: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

860: -- smaddali added unit set cd and version number parameters and in where clause using these parameters ,bug2630219
861: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
862: CURSOR c_adm_appl_inst (cp_app_no igs_uc_app_choices.app_no%TYPE,
863: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
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,

Line 865: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,

861: -- smaddali modified this cursor to add check for alt_appl_id ,bug 2643048 UCFD102 build
862: CURSOR c_adm_appl_inst (cp_app_no igs_uc_app_choices.app_no%TYPE,
863: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
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

Line 866: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS

862: CURSOR c_adm_appl_inst (cp_app_no igs_uc_app_choices.app_no%TYPE,
863: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
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

Line 869: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e

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
873: b.choice_no = c.choice_number AND

Line 899: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,

895: -- and the current application status is 'RECEIVED', and current outcome status is 'PENDING'/'WITHDRAWN'
896:
897: CURSOR c_cancel_appl (cp_app_no igs_uc_app_choices.app_no%TYPE,
898: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
899: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
900: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,
901: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS
902: SELECT
903: c.person_id , c.admission_appl_number ,c.choice_number, e.sequence_number,

Line 900: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,

896:
897: CURSOR c_cancel_appl (cp_app_no igs_uc_app_choices.app_no%TYPE,
898: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
899: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
900: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,
901: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS
902: SELECT
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 ,

Line 901: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS

897: CURSOR c_cancel_appl (cp_app_no igs_uc_app_choices.app_no%TYPE,
898: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
899: cp_adm_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
900: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,
901: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS
902: SELECT
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,

Line 908: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e

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
912: b.choice_no = c.choice_number AND

Line 945: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou

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
949: c.choice_number = cp_choice_number AND

Line 968: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou

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
972: c.choice_number = cp_choice_number AND

Line 983: CURSOR c_upd_appl_inst ( cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,

979: ou.s_adm_outcome_status NOT IN ('SUSPEND','VOIDED','WITHDRAWN');
980: c_obsol_appl_rec c_obsol_appl%ROWTYPE ;
981:
982: -- Get the application instance details for incrementing preference number
983: CURSOR c_upd_appl_inst ( cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
984: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ) IS
985: SELECT a.ROWID , a.*
986: FROM igs_ad_ps_appl_inst_all a
987: WHERE a.person_id = cp_person_id AND

Line 984: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ) IS

980: c_obsol_appl_rec c_obsol_appl%ROWTYPE ;
981:
982: -- Get the application instance details for incrementing preference number
983: CURSOR c_upd_appl_inst ( cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
984: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ) IS
985: SELECT a.ROWID , a.*
986: FROM igs_ad_ps_appl_inst_all a
987: WHERE a.person_id = cp_person_id AND
988: a.admission_appl_number = cp_admission_appl_number

Line 986: FROM igs_ad_ps_appl_inst_all a

982: -- Get the application instance details for incrementing preference number
983: CURSOR c_upd_appl_inst ( cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
984: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ) IS
985: SELECT a.ROWID , a.*
986: FROM igs_ad_ps_appl_inst_all a
987: WHERE a.person_id = cp_person_id AND
988: a.admission_appl_number = cp_admission_appl_number
989: ORDER BY a.preference_number DESC ;
990:

Line 1106: IGS_AD_PS_APPL_INST_ALL aplinst

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
1109: AND uac.ucas_cycle= p_ucas_cycle
1110: AND ua.app_no = uac.app_no

Line 1130: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS

1126: cp_app_no igs_uc_app_choices.app_no%TYPE,
1127: cp_choice_no igs_uc_app_choices.choice_no%TYPE,
1128: cp_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE,
1129: cp_person_id igs_pe_person.person_id%TYPE,
1130: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE) IS
1131: SELECT
1132: 'X'
1133: FROM
1134: igs_uc_app_choices uac,

Line 1137: igs_ad_ps_appl_inst_all aplinst,

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,
1141: igs_uc_map_out_stat mos,

Line 1690: igs_ad_ps_appl_inst_pkg.update_row (

1686:
1687: c_upd_appl_inst_rec.preference_number := c_upd_appl_inst_rec.preference_number + 1;
1688: -- call TBH update row
1689: l_pref_excep := FALSE;
1690: igs_ad_ps_appl_inst_pkg.update_row (
1691: x_rowid => c_upd_appl_inst_rec.ROWID ,
1692: x_person_id => c_upd_appl_inst_rec.person_id ,
1693: x_admission_appl_number => c_upd_appl_inst_rec.admission_appl_number ,
1694: x_nominated_course_cd => c_upd_appl_inst_rec.nominated_course_cd ,

Line 2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

2260: CURSOR c_appl_int( cp_batch_id igs_uc_app_choices.batch_id%TYPE,
2261: cp_app_no igs_uc_app_choices.app_no%TYPE ,
2262: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
2263: SELECT a.interface_id -- if application details import fails
2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2265: igs_uc_app_choices ch , igs_uc_applicants ap
2266: WHERE a.batch_id = cp_batch_id AND
2267: a.interface_id = b.interface_id AND
2268: b.choice_number = ch.choice_no AND

Line 2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

2274: ch.app_no = cp_app_no AND
2275: ch.choice_no = cp_choice_no
2276: UNION -- if person or person details import fail
2277: SELECT a.interface_id
2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2279: igs_uc_app_choices ch , igs_uc_applicants ap
2280: WHERE a.batch_id = cp_batch_id AND
2281: a.interface_id = b.interface_id AND
2282: b.choice_number = ch.choice_no AND

Line 2306: FROM igs_ad_ps_appl_inst_all

2302: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
2303: SELECT admission_appl_number,
2304: nominated_course_cd,
2305: sequence_number
2306: FROM igs_ad_ps_appl_inst_all
2307: WHERE person_id = p_per_id;
2308:
2309: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
2310: SELECT COUNT(*)