eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_AD_PS_APPL_INST

Line 7: lv_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE;

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;
11: lv_system_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;

Line 8: lv_sequence_number igs_ad_ps_appl_inst.sequence_number%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;
11: lv_system_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
12: lv_return1 igs_uc_transactions.return1%TYPE;

Line 9: lv_out_come_status igs_ad_ps_appl_inst.adm_outcome_status%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;
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;

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

Line 19: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

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,
23: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%TYPE,

Line 20: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

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,
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,

Line 21: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%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,
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,

Line 22: p_outcome_status IN igs_ad_ps_appl_inst.adm_outcome_status%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,
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,

Line 23: p_cond_offer_status IN igs_ad_ps_appl_inst.adm_cndtnl_offer_status%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,
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