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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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 ,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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');
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:
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,
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:
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,
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,
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:
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,
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,