DBA Data[Home] [Help]

APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_TRANSACTIONS

Line 4: lv_choice_no igs_uc_transactions.choice_no%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;

Line 6: lv_admission_appl_number igs_uc_transactions.app_no%TYPE;

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;
10: lv_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;

Line 12: lv_return1 igs_uc_transactions.return1%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;
10: lv_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
11: lv_system_outcome_status igs_ad_ou_stat.s_adm_outcome_status%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,

Line 13: lv_return2 igs_uc_transactions.return2%TYPE;

9: lv_out_come_status igs_ad_ps_appl_inst.adm_outcome_status%TYPE;
10: lv_cond_offer_status igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE;
11: lv_system_outcome_status igs_ad_ou_stat.s_adm_outcome_status%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,

Line 17: p_choice_number IN igs_uc_transactions.choice_no%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,
21: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

Line 113: l_transaction_type igs_uc_transactions.transaction_type%TYPE;

109:
110: app_clr_rnd_rec cur_app_clr_rnd%ROWTYPE;
111:
112: l_decision_value igs_uc_app_choices.decision%TYPE;
113: l_transaction_type igs_uc_transactions.transaction_type%TYPE;
114: l_decision igs_uc_app_choices.decision%TYPE;
115: l_reply igs_uc_app_choices.reply%TYPE;
116: l_ucas_program_code igs_uc_app_choices.ucas_program_code%TYPE;
117: l_campus igs_uc_app_choices.campus%TYPE;