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

Line 1706: Procedure Check_FeeExists(p_person_id IN igs_ad_appl_all.person_id%TYPE,

1702: END IF;
1703: END;
1704:
1705: -- Check to see if there exists any fee for this Application
1706: Procedure Check_FeeExists(p_person_id IN igs_ad_appl_all.person_id%TYPE,
1707: p_adm_appl_num IN igs_ad_appl_all.admission_appl_number%TYPE,
1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_message_data OUT NOCOPY VARCHAR2) AS
1710:

Line 1707: p_adm_appl_num IN igs_ad_appl_all.admission_appl_number%TYPE,

1703: END;
1704:
1705: -- Check to see if there exists any fee for this Application
1706: Procedure Check_FeeExists(p_person_id IN igs_ad_appl_all.person_id%TYPE,
1707: p_adm_appl_num IN igs_ad_appl_all.admission_appl_number%TYPE,
1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_message_data OUT NOCOPY VARCHAR2) AS
1710:
1711: l_fee_amount NUMBER;

Line 2168: --l_adm_cat IGS_AD_APPL_ALL.ADMISSION_CAT%TYPE; changed to cursor now Bug 2405076

2164:
2165: l_one_stop VARCHAR2(1);
2166: c_course_rec c_course%ROWTYPE;
2167: l_return_status VARCHAR2(1);
2168: --l_adm_cat IGS_AD_APPL_ALL.ADMISSION_CAT%TYPE; changed to cursor now Bug 2405076
2169: --l_adm_proc_type IGS_AD_APPL_ALL. S_ADMISSION_PROCESS_TYPE%TYPE; changed to cursor now Bug 2405076
2170: l_msg_count NUMBER;
2171: l_msg_data VARCHAR2(1000);
2172: l_message_data VARCHAR2(1000);

Line 2169: --l_adm_proc_type IGS_AD_APPL_ALL. S_ADMISSION_PROCESS_TYPE%TYPE; changed to cursor now Bug 2405076

2165: l_one_stop VARCHAR2(1);
2166: c_course_rec c_course%ROWTYPE;
2167: l_return_status VARCHAR2(1);
2168: --l_adm_cat IGS_AD_APPL_ALL.ADMISSION_CAT%TYPE; changed to cursor now Bug 2405076
2169: --l_adm_proc_type IGS_AD_APPL_ALL. S_ADMISSION_PROCESS_TYPE%TYPE; changed to cursor now Bug 2405076
2170: l_msg_count NUMBER;
2171: l_msg_data VARCHAR2(1000);
2172: l_message_data VARCHAR2(1000);
2173: v_warn_level VARCHAR2(10);

Line 2223: From IGS_AD_APPL_ALL

2219: --tray: Select without cursor is not allowed, so changing this to cursor Bug 2405076
2220: /*
2221: Select ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE
2222: Into l_adm_cat, l_adm_proc_type
2223: From IGS_AD_APPL_ALL
2224: Where person_id = p_person_id
2225: And admission_appl_number = p_admission_appl_number;
2226: */
2227: Check_OneStop(p_person_id => p_person_id,

Line 2525: CURSOR c_admission_process_type(cp_person_id igs_ad_appl_all.person_id%TYPE,

2521: AND acai.nominated_course_cd = cp_nominated_course_cd
2522: AND acai.sequence_number = cp_sequence_number
2523: FOR UPDATE OF acai.adm_doc_status, acai.adm_entry_qual_status NOWAIT;
2524:
2525: CURSOR c_admission_process_type(cp_person_id igs_ad_appl_all.person_id%TYPE,
2526: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
2527: SELECT s_admission_process_type
2528: FROM igs_ad_appl_all
2529: WHERE person_id = cp_person_id

Line 2526: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

2522: AND acai.sequence_number = cp_sequence_number
2523: FOR UPDATE OF acai.adm_doc_status, acai.adm_entry_qual_status NOWAIT;
2524:
2525: CURSOR c_admission_process_type(cp_person_id igs_ad_appl_all.person_id%TYPE,
2526: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
2527: SELECT s_admission_process_type
2528: FROM igs_ad_appl_all
2529: WHERE person_id = cp_person_id
2530: AND admission_appl_number = cp_admission_appl_number;

Line 2528: FROM igs_ad_appl_all

2524:
2525: CURSOR c_admission_process_type(cp_person_id igs_ad_appl_all.person_id%TYPE,
2526: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
2527: SELECT s_admission_process_type
2528: FROM igs_ad_appl_all
2529: WHERE person_id = cp_person_id
2530: AND admission_appl_number = cp_admission_appl_number;
2531:
2532: Rec_IGS_AD_PS_APPL_Inst c_upd_acai_eqdo%ROWTYPE;

Line 2539: l_admission_process_type IGS_AD_APPL_ALL.s_admission_process_type%TYPE;

2535: l_application_status IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE;
2536:
2537: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
2538: l_entry_qual_status IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE;
2539: l_admission_process_type IGS_AD_APPL_ALL.s_admission_process_type%TYPE;
2540: lv_mode VARCHAR2(1) DEFAULT 'R';
2541:
2542: l_sc_encoded_text VARCHAR2(4000);
2543: l_sc_msg_count NUMBER;