DBA Data[Home] [Help]

APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_TRANSACTIONS

Line 5: P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,

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,

Line 6: P_App_no IN igs_uc_transactions.app_no%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,

Line 7: P_Choice_no IN igs_uc_transactions.choice_no%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,

Line 8: P_Decision IN igs_uc_transactions.decision%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,

Line 9: P_Course IN igs_uc_transactions.program_code%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,

Line 10: P_Campus IN igs_uc_transactions.campus%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,

Line 11: P_Entry_month IN igs_uc_transactions.entry_month%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,

Line 12: P_Entry_year IN igs_uc_transactions.entry_year%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,

Line 13: P_Entry_point IN igs_uc_transactions.entry_point%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,

Line 14: P_SOC IN igs_uc_transactions.SOC%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,

Line 15: P_Free_Format IN igs_uc_transactions.comments_in_offer%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 ,

Line 16: P_Hold IN igs_uc_transactions.hold_flag%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,

Line 17: P_return1 OUT NOCOPY igs_uc_transactions.return1%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,

Line 18: P_return2 OUT NOCOPY igs_uc_transactions.return2%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,

Line 19: P_Inst_reference IN igs_uc_transactions.inst_reference%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,

Line 20: P_cond_cat IN igs_uc_transactions.test_cond_cat%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,

Line 21: P_cond_name IN igs_uc_transactions.test_cond_name%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,

Line 22: P_auto_generated IN igs_uc_transactions.auto_generated_flag%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,

Line 23: p_system_code IN igs_uc_transactions.system_code%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,

Line 24: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE DEFAULT NULL,

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,

Line 25: p_modular IN igs_uc_transactions.modular%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');

Line 26: p_part_time IN igs_uc_transactions.part_time%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:

Line 27: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,

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,

Line 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:

Line 32: p_condition_name1 IN igs_uc_transactions.test_cond_name%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,

Line 33: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%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,

Line 36: PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%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:

Line 37: p_decision IN igs_uc_transactions.decision%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,

Line 38: p_comments_in_offer IN igs_uc_transactions.comments_in_offer%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,