1 PACKAGE igs_uc_tran_processor_pkg AS
2 /* $Header: IGSUC23S.pls 120.3 2006/08/21 03:51:54 jbaber ship $ */
3
4 PROCEDURE trans_build (
5 P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
6 P_App_no IN igs_uc_transactions.app_no%TYPE,
7 P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
8 P_Decision IN igs_uc_transactions.decision%TYPE,
9 P_Course IN igs_uc_transactions.program_code%TYPE,
10 P_Campus IN igs_uc_transactions.campus%TYPE,
11 P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
12 P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
13 P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
14 P_SOC IN igs_uc_transactions.SOC%TYPE,
15 P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
16 P_Hold IN igs_uc_transactions.hold_flag%TYPE,
17 P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
18 P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
19 P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
20 P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE DEFAULT NULL,
21 P_cond_name IN igs_uc_transactions.test_cond_name%TYPE DEFAULT NULL,
22 P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE DEFAULT NULL,
23 p_system_code IN igs_uc_transactions.system_code%TYPE DEFAULT NULL,
24 p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE DEFAULT NULL,
25 p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
26 p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
27 p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,
28 p_validate_error_cd OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
29 p_mode IN VARCHAR2 DEFAULT 'R');
30
31 PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE,
32 p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE,
33 p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,
34 p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE );
35
36 PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%TYPE,
37 p_decision IN igs_uc_transactions.decision%TYPE,
38 p_comments_in_offer IN igs_uc_transactions.comments_in_offer%TYPE,
39 p_error_code OUT NOCOPY igs_lookup_values.lookup_code%TYPE);
40
41 PROCEDURE trans_write( p_system_code IN igs_uc_ucas_control.system_code%TYPE,
42 errbuf OUT NOCOPY VARCHAR2,
43 retcode OUT NOCOPY NUMBER );
44
45 -- rghosh bug# 2860860 (UCAS Conditional Offer build)
46 -- added the function get_adm_offer_resp_stat
47 -- this function will return the user defined offer response status mapped with
48 -- which the Admission Application instance has to be updated with, after validating
49 -- the Old and New Outcome statuses and Offer Response Status against UCAS setup.
50
51 FUNCTION get_adm_offer_resp_stat (
52 p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,
53 p_choice_number IN igs_ad_appl_all.choice_number%TYPE,
54 p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
55 p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
56 p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
57 p_message_name OUT NOCOPY VARCHAR2
58 ) RETURN VARCHAR2 ;
59
60 END igs_uc_tran_processor_pkg;