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_ADMAPPLICATION_PUB dependencies on HZ_PARTIES

Line 473: CURSOR c_person_id(cp_party_number hz_parties.party_number%TYPE) IS

469: AND admission_appl_number = p_admission_appl_number
470: AND nominated_course_cd = p_nominated_program_cd
471: AND sequence_number = p_sequence_number;
472:
473: CURSOR c_person_id(cp_party_number hz_parties.party_number%TYPE) IS
474: SELECT party_id FROM hz_parties WHERE party_number = cp_party_number;
475: l_adm_otcm_status_auth_per_id hz_parties.party_id%TYPE;
476: l_check_reconsider VARCHAR2(1);
477: l_pre_enroll VARCHAR2(2);

Line 474: SELECT party_id FROM hz_parties WHERE party_number = cp_party_number;

470: AND nominated_course_cd = p_nominated_program_cd
471: AND sequence_number = p_sequence_number;
472:
473: CURSOR c_person_id(cp_party_number hz_parties.party_number%TYPE) IS
474: SELECT party_id FROM hz_parties WHERE party_number = cp_party_number;
475: l_adm_otcm_status_auth_per_id hz_parties.party_id%TYPE;
476: l_check_reconsider VARCHAR2(1);
477: l_pre_enroll VARCHAR2(2);
478: l_c_aplinst_cur c_aplinst_cur%ROWTYPE;

Line 475: l_adm_otcm_status_auth_per_id hz_parties.party_id%TYPE;

471: AND sequence_number = p_sequence_number;
472:
473: CURSOR c_person_id(cp_party_number hz_parties.party_number%TYPE) IS
474: SELECT party_id FROM hz_parties WHERE party_number = cp_party_number;
475: l_adm_otcm_status_auth_per_id hz_parties.party_id%TYPE;
476: l_check_reconsider VARCHAR2(1);
477: l_pre_enroll VARCHAR2(2);
478: l_c_aplinst_cur c_aplinst_cur%ROWTYPE;
479: l_c_ps_appl_cur c_ps_appl_cur%ROWTYPE;

Line 501: l_adm_otcm_status_auth_per_num hz_parties.party_number%TYPE;

497: l_adm_offer_resp_status igs_ad_ps_appl_inst.adm_offer_resp_status%TYPE ;
498: l_cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst.cndtnl_offer_satisfied_dt%TYPE ;
499: l_adm_cndtl_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE ;
500: l_adm_outcome_status_auth_dt igs_ad_ps_appl_inst.adm_outcome_status_auth_dt%TYPE;
501: l_adm_otcm_status_auth_per_num hz_parties.party_number%TYPE;
502: l_adm_outcome_status_reason igs_ad_ps_appl_inst.adm_outcome_status_reason%TYPE;
503:
504: l_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE;
505: l_s_adm_outcome_status igs_ad_ou_Stat.s_adm_outcome_status%TYPE;