[Home] [Help]
4: PROCEDURE Create_UCAS_Transactions(
5: p_ucas_id IN igs_pe_person.api_person_id%TYPE,
6: p_choice_number IN igs_uc_transactions.choice_no%TYPE,
7: p_person_number IN igs_pe_person.person_number%TYPE,
8: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
9: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
10: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
11: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
12: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
5: p_ucas_id IN igs_pe_person.api_person_id%TYPE,
6: p_choice_number IN igs_uc_transactions.choice_no%TYPE,
7: p_person_number IN igs_pe_person.person_number%TYPE,
8: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
9: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
10: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
11: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
12: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
13: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE DEFAULT NULL,
6: p_choice_number IN igs_uc_transactions.choice_no%TYPE,
7: p_person_number IN igs_pe_person.person_number%TYPE,
8: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
9: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
10: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
11: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
12: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
13: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE DEFAULT NULL,
14: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE DEFAULT NULL,
7: p_person_number IN igs_pe_person.person_number%TYPE,
8: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
9: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
10: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
11: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
12: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
13: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE DEFAULT NULL,
14: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE DEFAULT NULL,
15: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE DEFAULT NULL,
8: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
9: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
10: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
11: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
12: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
13: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE DEFAULT NULL,
14: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE DEFAULT NULL,
15: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE DEFAULT NULL,
16: p_uc_tran_id OUT NOCOPY NUMBER