DBA Data[Home] [Help]

PACKAGE: APPS.IGS_UC_TRX_GEN_HOOK

Source


1 PACKAGE igs_uc_trx_gen_hook AUTHID CURRENT_USER AS
2 /* $Header: IGSUC21S.pls 115.8 2003/11/21 14:35:01 ayedubat noship $ */
3 
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,
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
17   );
18 
19 END igs_uc_trx_gen_hook;