DBA Data[Home] [Help]

APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_PE_PERSON

Line 5: lv_person_number igs_pe_person.person_number%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;
8: lv_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
9: lv_out_come_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE;

Line 16: p_ucas_id IN igs_pe_person.api_person_id%TYPE,

12: lv_return1 igs_uc_transactions.return1%TYPE;
13: lv_return2 igs_uc_transactions.return2%TYPE;
14:
15: PROCEDURE create_ucas_transactions(
16: p_ucas_id IN igs_pe_person.api_person_id%TYPE,
17: p_choice_number IN igs_uc_transactions.choice_no%TYPE,
18: p_person_number IN igs_pe_person.person_number%TYPE,
19: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
20: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

Line 18: p_person_number IN igs_pe_person.person_number%TYPE,

14:
15: PROCEDURE create_ucas_transactions(
16: p_ucas_id IN igs_pe_person.api_person_id%TYPE,
17: p_choice_number IN igs_uc_transactions.choice_no%TYPE,
18: p_person_number IN igs_pe_person.person_number%TYPE,
19: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%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,