DBA Data[Home] [Help]

APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_AD_APPL_ALL

Line 52: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,

48: -- which the Admission Application instance has to be updated with, after validating
49: -- the Old and New Outcome statuses and Offer Response Status against UCAS setup.
50:
51: FUNCTION get_adm_offer_resp_stat (
52: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,
53: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,
54: p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
55: p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
56: p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

Line 53: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,

49: -- the Old and New Outcome statuses and Offer Response Status against UCAS setup.
50:
51: FUNCTION get_adm_offer_resp_stat (
52: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,
53: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,
54: p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
55: p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
56: p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
57: p_message_name OUT NOCOPY VARCHAR2