APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_AD_APPL

Line 3: l_alt_appl_id igs_ad_appl.alt_appl_id%TYPE;

1: PACKAGE BODY igs_uc_trx_gen_hook AS
2: /* $Header: IGSUC21B.pls 120.2 2006/08/21 03:51:45 jbaber noship $ */
3: l_alt_appl_id igs_ad_appl.alt_appl_id%TYPE;
4: lv_choice_no igs_uc_transactions.choice_no%TYPE;
5: lv_person_number igs_pe_person.person_number%TYPE;
6: lv_admission_appl_number igs_uc_transactions.app_no%TYPE;
7: lv_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE;

Line 24: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE,

20: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
21: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
22: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%TYPE,
23: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,
24: p_alt_appl_id IN igs_ad_appl.alt_appl_id%TYPE,
25: p_condition_category IN igs_uc_offer_conds.condition_category%TYPE DEFAULT NULL,
26: p_condition_name IN igs_uc_offer_conds.condition_name%TYPE DEFAULT NULL,
27: p_uc_tran_id OUT NOCOPY NUMBER
28: ) IS