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_UC_APPLICANTS

Line 22: p_app_no IN igs_uc_applicants.app_no%TYPE,

18: l_org_id CONSTANT igs_ps_ver.org_id%TYPE := IGS_GE_GEN_003.GET_ORG_ID ;
19:
20:
21: PROCEDURE populate_imp_int (
22: p_app_no IN igs_uc_applicants.app_no%TYPE,
23: p_choice_no IN igs_uc_app_choices.choice_no%TYPE ,
24: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
25: p_batch_id NUMBER,
26: p_orgid NUMBER) AS

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 116: igs_uc_applicants e

112: pp.date_of_birth birth_dt, p.known_as preferred_given_name,
113: pd.level_of_qual level_of_qual_id, pd.military_service_reg,
114: pd.veteran, e.application_date
115: FROM igs_pe_HZ_parties pd, hz_parties p , hz_person_profiles pp ,
116: igs_uc_applicants e
117: WHERE p.party_id = e.oss_person_id AND e.app_no = p_app_no AND
118: pp.party_id(+)=p.party_id AND p.party_id=pd.party_id(+) AND
119: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
120: c_pe_person_rec c_pe_person%ROWTYPE;

Line 153: FROM igs_uc_app_choices a, igs_uc_applicants b

149: CURSOR c_uc_app_ch IS
150: SELECT DISTINCT a.ucas_program_code, a.campus, a.choice_no, a.oss_program_code, a.oss_program_version,
151: a.oss_location, a.point_of_entry, a.deferred, a.oss_attendance_type, a.oss_attendance_mode,
152: a.route_b_pref_round, b.application_source , a.app_no , a.system_code, a.ucas_cycle, a.entry_year, a.entry_month
153: FROM igs_uc_app_choices a, igs_uc_applicants b
154: WHERE a.app_no=b.app_no AND
155: b.app_no=NVL(p_app_no ,b.app_no) AND
156: a.institute_code = (SELECT df.current_inst_code FROM igs_uc_defaults df
157: WHERE df.system_code = a.system_code) AND

Line 748: p_app_no igs_uc_applicants.app_no%TYPE ,

744:
745: END import_process;
746:
747: PROCEDURE obsolete_applications(
748: p_app_no igs_uc_applicants.app_no%TYPE ,
749: p_choice_no igs_uc_app_choices.choice_no%TYPE
750: ) IS
751: /******************************************************************
752: Created By : smaddali

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 941: CURSOR c_obsol_appl_cnt(cp_app_no igs_uc_applicants.app_no%TYPE ,

937: l_interface_run_id NUMBER ;
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

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 961: CURSOR c_obsol_appl(cp_app_no igs_uc_applicants.app_no%TYPE ,

957: l_obsol_appl_cnt NUMBER;
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,

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 1103: IGS_UC_APPLICANTS ua,

1099: p_choice_no igs_uc_app_choices.choice_no%TYPE,
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

Line 2196: p_app_no igs_uc_applicants.app_no%TYPE ,

2192:
2193:
2194:
2195: PROCEDURE export_applications(
2196: p_app_no igs_uc_applicants.app_no%TYPE ,
2197: p_choice_no igs_uc_app_choices.choice_no%TYPE
2198: ) IS
2199: /******************************************************************
2200: Created By : smaddali

Line 2218: l_app_no IGS_UC_APPLICANTS.APP_NO%TYPE;

2214: --jchakrab added for 3691186
2215: TYPE t_oc_app_ch IS REF CURSOR;
2216: c_oc_app_ch t_oc_app_ch;
2217:
2218: l_app_no IGS_UC_APPLICANTS.APP_NO%TYPE;
2219:
2220: l_imp_batch_id NUMBER;
2221: l_export_to_oss_status igs_uc_app_choices.export_to_oss_status%TYPE ;
2222: l_ch_error igs_uc_app_choices.error_code%TYPE ;

Line 2265: igs_uc_app_choices ch , igs_uc_applicants ap

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
2269: b.interface_appl_id = c.interface_appl_id AND

Line 2279: igs_uc_app_choices ch , igs_uc_applicants ap

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
2283: b.interface_appl_id = c.interface_appl_id AND

Line 2295: CURSOR cur_app_dtls(cp_app_no igs_uc_applicants.app_no%TYPE) IS

2291: ch.choice_no = cp_choice_no ;
2292: c_appl_int_rec c_appl_int%ROWTYPE ;
2293:
2294: /* Cursors used to import domicile code */
2295: CURSOR cur_app_dtls(cp_app_no igs_uc_applicants.app_no%TYPE) IS
2296: SELECT a.oss_person_id, a.domicile_apr, b.party_number
2297: FROM igs_uc_applicants a, hz_parties b
2298: WHERE a.oss_person_id = b.party_id
2299: AND app_no = cp_app_no;

Line 2297: FROM igs_uc_applicants a, hz_parties b

2293:
2294: /* Cursors used to import domicile code */
2295: CURSOR cur_app_dtls(cp_app_no igs_uc_applicants.app_no%TYPE) IS
2296: SELECT a.oss_person_id, a.domicile_apr, b.party_number
2297: FROM igs_uc_applicants a, hz_parties b
2298: WHERE a.oss_person_id = b.party_id
2299: AND app_no = cp_app_no;
2300: l_app_dtls cur_app_dtls%ROWTYPE;
2301:

Line 2340: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2336: -- jchakrab changed c_oc_app_ch to a ref cursor to execute different queries based on parameter values (3691186)
2337: IF p_app_no IS NOT NULL AND p_choice_no IS NOT NULL THEN
2338: OPEN c_oc_app_ch FOR
2339: SELECT DISTINCT AP.APP_NO
2340: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2341: WHERE AP.APP_NO = CH.APP_NO AND
2342: CH.APP_NO = P_APP_NO AND
2343: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2344: CH.EXPORT_TO_OSS_STATUS = 'OC' AND

Line 2352: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2348:
2349: ELSIF p_app_no IS NOT NULL AND p_choice_no IS NULL THEN
2350: OPEN c_oc_app_ch FOR
2351: SELECT DISTINCT AP.APP_NO
2352: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2353: WHERE AP.APP_NO = CH.APP_NO AND
2354: CH.APP_NO = P_APP_NO AND
2355: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2356: CH.EXPORT_TO_OSS_STATUS = 'OC' AND

Line 2363: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF

2359:
2360: ELSE
2361: OPEN c_oc_app_ch FOR
2362: SELECT DISTINCT AP.APP_NO
2363: FROM IGS_UC_APP_CHOICES CH , IGS_UC_APPLICANTS AP, IGS_UC_DEFAULTS DF
2364: WHERE AP.APP_NO = CH.APP_NO AND
2365: DF.SYSTEM_CODE = CH.SYSTEM_CODE AND
2366: CH.EXPORT_TO_OSS_STATUS = 'OC' AND
2367: CH.INSTITUTE_CODE = DF.CURRENT_INST_CODE

Line 2644: p_app_no igs_uc_applicants.app_no%TYPE ,

2640:
2641: PROCEDURE main_process(
2642: errbuf OUT NOCOPY VARCHAR2,
2643: retcode OUT NOCOPY NUMBER,
2644: p_app_no igs_uc_applicants.app_no%TYPE ,
2645: p_choice_no igs_uc_app_choices.choice_no%TYPE
2646: ) IS
2647: /******************************************************************
2648: Created By : smaddali