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.

APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_TRANSACTIONS

Line 5: l_uc_tran_id igs_uc_transactions.UC_Tran_Id%TYPE;

1: PACKAGE BODY igs_uc_tran_processor_pkg AS
2: /* $Header: IGSUC23B.pls 120.9 2006/08/21 03:52:08 jbaber noship $ */
3:
4: lv_rowid VARCHAR2(26);
5: l_uc_tran_id igs_uc_transactions.UC_Tran_Id%TYPE;
6: l_tranid NUMBER := 0;
7:
8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,

Line 8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,

4: lv_rowid VARCHAR2(26);
5: l_uc_tran_id igs_uc_transactions.UC_Tran_Id%TYPE;
6: l_tranid NUMBER := 0;
7:
8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,

Line 9: P_App_no IN igs_uc_transactions.app_no%TYPE,

5: l_uc_tran_id igs_uc_transactions.UC_Tran_Id%TYPE;
6: l_tranid NUMBER := 0;
7:
8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,

Line 10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,

6: l_tranid NUMBER := 0;
7:
8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,

Line 11: P_Decision IN igs_uc_transactions.decision%TYPE,

7:
8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,

Line 12: P_Course IN igs_uc_transactions.program_code%TYPE,

8: PROCEDURE trans_build ( P_Tran_type IN igs_uc_transactions.transaction_type%TYPE,
9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,

Line 13: P_Campus IN igs_uc_transactions.campus%TYPE,

9: P_App_no IN igs_uc_transactions.app_no%TYPE,
10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,

Line 14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,

10: P_Choice_no IN igs_uc_transactions.choice_no%TYPE,
11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,

Line 15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,

11: P_Decision IN igs_uc_transactions.decision%TYPE,
12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,

Line 16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,

12: P_Course IN igs_uc_transactions.program_code%TYPE,
13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,

Line 17: P_SOC IN igs_uc_transactions.SOC%TYPE,

13: P_Campus IN igs_uc_transactions.campus%TYPE,
14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,

Line 18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,

14: P_Entry_month IN igs_uc_transactions.entry_month%TYPE,
15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,

Line 19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,

15: P_Entry_year IN igs_uc_transactions.entry_year%TYPE,
16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,

Line 20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,

16: P_Entry_point IN igs_uc_transactions.entry_point%TYPE,
17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,

Line 21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,

17: P_SOC IN igs_uc_transactions.SOC%TYPE,
18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,

Line 22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,

18: P_Free_Format IN igs_uc_transactions.comments_in_offer%TYPE,
19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,

Line 23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,

19: P_Hold IN igs_uc_transactions.hold_flag%TYPE,
20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,

Line 24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,

20: P_return1 OUT NOCOPY igs_uc_transactions.return1%TYPE,
21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,

Line 25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,

21: P_return2 OUT NOCOPY igs_uc_transactions.return2%TYPE,
22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,

Line 26: p_system_code IN igs_uc_transactions.system_code%TYPE,

22: P_Inst_reference IN igs_uc_transactions.inst_reference%TYPE ,
23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
30: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,

Line 27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,

23: P_cond_cat IN igs_uc_transactions.test_cond_cat%TYPE ,
24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
30: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,
31: p_validate_error_cd OUT NOCOPY igs_lookup_values.lookup_code%TYPE,

Line 28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,

24: P_cond_name IN igs_uc_transactions.test_cond_name%TYPE ,
25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
30: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,
31: p_validate_error_cd OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
32: p_mode IN VARCHAR2

Line 29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,

25: P_auto_generated IN igs_uc_transactions.auto_generated_flag%TYPE,
26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
30: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,
31: p_validate_error_cd OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
32: p_mode IN VARCHAR2
33: ) IS

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

26: p_system_code IN igs_uc_transactions.system_code%TYPE,
27: p_ucas_cycle IN igs_uc_transactions.ucas_cycle%TYPE,
28: p_modular IN igs_uc_transactions.modular%TYPE DEFAULT NULL,
29: p_part_time IN igs_uc_transactions.part_time%TYPE DEFAULT NULL,
30: p_uc_tran_id OUT NOCOPY igs_uc_transactions.uc_tran_id%TYPE,
31: p_validate_error_cd OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
32: p_mode IN VARCHAR2
33: ) IS
34:

Line 39: IGS_UC_TRANSACTIONS.

35: /*************************************************************
36: Created By : solakshm
37: Date Created By : 23-JAN-2002
38: Purpose : To build transaction records from parameter values and store in
39: IGS_UC_TRANSACTIONS.
40: Know limitations, enhancements or remarks
41: Change History
42: Who When What
43: rbezawad 19-Oct-2002 Modified for Bug 2628587

Line 48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag

44: While generating the LD transaction, removed the validation which is
45: checking the P_free_format value to be not null when decision = W.
46: smaddali 02-oct-2002 modified for bug 2603384
47: 1) added 3 new parameters p_cond_cat, p_cond_nae ,p_auto_generated
48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag
49: 3) passing calues of p_cond_cat and p_cond_name to x_test_cond_cat and x_test_cond_name
50: instead of NULL in tbh calls of igs_uc_transactions_pkg
51: rbezawad 02-Apr-2002 Modified w.r.t. UCCR002 DLD. Bug No:2278817.
52: 1) Passed Entry year, Entry month fields for LC type transactions.

Line 50: instead of NULL in tbh calls of igs_uc_transactions_pkg

46: smaddali 02-oct-2002 modified for bug 2603384
47: 1) added 3 new parameters p_cond_cat, p_cond_nae ,p_auto_generated
48: 2) modifying tbh calls igs_uc_transactions_pkg to add x_auto_generated_flag
49: 3) passing calues of p_cond_cat and p_cond_name to x_test_cond_cat and x_test_cond_name
50: instead of NULL in tbh calls of igs_uc_transactions_pkg
51: rbezawad 02-Apr-2002 Modified w.r.t. UCCR002 DLD. Bug No:2278817.
52: 1) Passed Entry year, Entry month fields for LC type transactions.
53: 2) RX Transactions are validated to always accept decision value 'A'.
54: 3) Inst_reference field is added as data model is effected.

Line 69: CURSOR cur_find_trans(cp_transaction_type igs_uc_transactions.transaction_type%TYPE) IS

65: SELECT b.deceased_ind FROM igs_uc_applicants a,igs_pe_hz_parties b
66: WHERE a.app_no = P_App_no AND a.oss_person_id = b.party_id;
67:
68: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
69: CURSOR cur_find_trans(cp_transaction_type igs_uc_transactions.transaction_type%TYPE) IS
70: SELECT COUNT(*)
71: FROM igs_uc_transactions
72: WHERE app_no = P_App_no
73: AND choice_no = P_Choice_no

Line 71: FROM igs_uc_transactions

67:
68: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
69: CURSOR cur_find_trans(cp_transaction_type igs_uc_transactions.transaction_type%TYPE) IS
70: SELECT COUNT(*)
71: FROM igs_uc_transactions
72: WHERE app_no = P_App_no
73: AND choice_no = P_Choice_no
74: AND ucas_cycle = p_ucas_cycle
75: AND transaction_type = cp_transaction_type;

Line 84: SELECT COUNT(*) FROM igs_uc_transactions

80: AND choice_no = P_Choice_no
81: AND ucas_cycle = p_ucas_cycle;
82:
83: CURSOR cur_find_RD IS
84: SELECT COUNT(*) FROM igs_uc_transactions
85: WHERE app_no = P_App_no
86: AND ucas_cycle = p_ucas_cycle
87: AND transaction_type = 'RD';
88:

Line 121: CURSOR c_transactions(cp_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE) IS

117: AND ucas_cycle = cp_ucas_cycle
118: AND system_code = cp_system_code;
119: l_rec_found VARCHAR2(1);
120:
121: CURSOR c_transactions(cp_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE) IS
122: SELECT t.ROWID, t.* FROM igs_uc_transactions t
123: WHERE uc_tran_id = cp_uc_tran_id;
124:
125: l_transactions c_transactions%ROWTYPE;

Line 122: SELECT t.ROWID, t.* FROM igs_uc_transactions t

118: AND system_code = cp_system_code;
119: l_rec_found VARCHAR2(1);
120:
121: CURSOR c_transactions(cp_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE) IS
122: SELECT t.ROWID, t.* FROM igs_uc_transactions t
123: WHERE uc_tran_id = cp_uc_tran_id;
124:
125: l_transactions c_transactions%ROWTYPE;
126:

Line 132: l_return1 igs_uc_transactions.return1%TYPE;

128: l_reply igs_uc_app_choices.reply%TYPE;
129: l_cnt NUMBER;
130: l_cnt1 NUMBER;
131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
132: l_return1 igs_uc_transactions.return1%TYPE;
133: l_return2 igs_uc_transactions.return2%TYPE;
134: l_generate VARCHAR2(1);
135: l_generate_tran VARCHAR2(1);
136: l_soc igs_uc_transactions.soc%TYPE;

Line 133: l_return2 igs_uc_transactions.return2%TYPE;

129: l_cnt NUMBER;
130: l_cnt1 NUMBER;
131: l_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
132: l_return1 igs_uc_transactions.return1%TYPE;
133: l_return2 igs_uc_transactions.return2%TYPE;
134: l_generate VARCHAR2(1);
135: l_generate_tran VARCHAR2(1);
136: l_soc igs_uc_transactions.soc%TYPE;
137: l_comments_in_offer igs_uc_transactions.comments_in_offer%TYPE;

Line 136: l_soc igs_uc_transactions.soc%TYPE;

132: l_return1 igs_uc_transactions.return1%TYPE;
133: l_return2 igs_uc_transactions.return2%TYPE;
134: l_generate VARCHAR2(1);
135: l_generate_tran VARCHAR2(1);
136: l_soc igs_uc_transactions.soc%TYPE;
137: l_comments_in_offer igs_uc_transactions.comments_in_offer%TYPE;
138: l_error_code igs_lookup_values.lookup_code%TYPE;
139: l_hold igs_uc_transactions.hold_flag%TYPE;
140: l_transaction_toy igs_uc_ucas_control.transaction_toy_code%TYPE;

Line 137: l_comments_in_offer igs_uc_transactions.comments_in_offer%TYPE;

133: l_return2 igs_uc_transactions.return2%TYPE;
134: l_generate VARCHAR2(1);
135: l_generate_tran VARCHAR2(1);
136: l_soc igs_uc_transactions.soc%TYPE;
137: l_comments_in_offer igs_uc_transactions.comments_in_offer%TYPE;
138: l_error_code igs_lookup_values.lookup_code%TYPE;
139: l_hold igs_uc_transactions.hold_flag%TYPE;
140: l_transaction_toy igs_uc_ucas_control.transaction_toy_code%TYPE;
141:

Line 139: l_hold igs_uc_transactions.hold_flag%TYPE;

135: l_generate_tran VARCHAR2(1);
136: l_soc igs_uc_transactions.soc%TYPE;
137: l_comments_in_offer igs_uc_transactions.comments_in_offer%TYPE;
138: l_error_code igs_lookup_values.lookup_code%TYPE;
139: l_hold igs_uc_transactions.hold_flag%TYPE;
140: l_transaction_toy igs_uc_ucas_control.transaction_toy_code%TYPE;
141:
142: BEGIN
143:

Line 212: igs_uc_transactions_pkg.insert_row (

208: CLOSE cur_find_trans;
209:
210: IF l_cnt > 0 THEN
211: P_return1 := 0;
212: igs_uc_transactions_pkg.insert_row (
213: x_mode => p_mode, --jchakrab modified for 4380412
214: x_rowid => lv_rowid,
215: x_uc_tran_id => l_uc_tran_id,
216: x_transaction_id => NULL,

Line 258: igs_uc_transactions_pkg.update_row(

254: OPEN c_transactions(l_uc_tran_id);
255: FETCH c_transactions INTO l_transactions;
256: CLOSE c_transactions;
257:
258: igs_uc_transactions_pkg.update_row(
259: x_rowid => l_transactions.rowid,
260: x_uc_tran_id => l_transactions.uc_tran_id,
261: x_transaction_id => l_transactions.transaction_id,
262: x_datetimestamp => l_transactions.datetimestamp,

Line 308: igs_uc_transactions_pkg.insert_row (

304: IF P_App_no IS NOT NULL AND P_Choice_no IS NOT NULL AND P_Hold IS NOT NULL
305: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
306: IF P_Course IS NOT NULL OR P_Entry_point IS NOT NULL THEN
307: P_return1 := 0;
308: igs_uc_transactions_pkg.insert_row (
309: x_mode => p_mode, --jchakrab modified for 4380412
310: x_rowid => lv_rowid,
311: x_uc_tran_id => l_uc_tran_id,
312: x_transaction_id => NULL,

Line 357: igs_uc_transactions_pkg.insert_row (

353: IF P_App_no IS NOT NULL AND P_Choice_no IS NOT NULL AND P_Decision IS NOT NULL AND P_Hold IS NOT NULL
354: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
355: P_return1 := 0;
356:
357: igs_uc_transactions_pkg.insert_row (
358: x_mode => p_mode, --jchakrab modified for 4380412
359: x_rowid => lv_rowid,
360: x_uc_tran_id => l_uc_tran_id,
361: x_transaction_id => NULL,

Line 403: igs_uc_transactions_pkg.update_row(

399: OPEN c_transactions(l_uc_tran_id);
400: FETCH c_transactions INTO l_transactions;
401: CLOSE c_transactions;
402:
403: igs_uc_transactions_pkg.update_row(
404: x_rowid => l_transactions.rowid,
405: x_uc_tran_id => l_transactions.uc_tran_id,
406: x_transaction_id => l_transactions.transaction_id,
407: x_datetimestamp => l_transactions.datetimestamp,

Line 458: igs_uc_transactions_pkg.insert_row (

454: P_return1 := 1;
455: P_return2:= 'IGS_UC_NO_LK_FOR_LA';
456: ELSE
457: P_return1 := 0;
458: igs_uc_transactions_pkg.insert_row (
459: x_mode => p_mode, --jchakrab modified for 4380412
460: x_rowid => lv_rowid,
461: x_uc_tran_id => l_uc_tran_id,
462: x_transaction_id => NULL,

Line 530: igs_uc_transactions_pkg.insert_row (

526: END IF;
527:
528: IF l_generate = 'Y' THEN
529: P_return1 := 0;
530: igs_uc_transactions_pkg.insert_row (
531: x_mode => p_mode, --jchakrab modified for 4380412
532: x_rowid => lv_rowid,
533: x_uc_tran_id => l_uc_tran_id,
534: x_transaction_id => NULL,

Line 583: igs_uc_transactions_pkg.insert_row (

579: CLOSE cur_app_choice_decision;
580:
581: IF l_decision = 'U' AND l_reply = 'F' THEN
582: P_return1 := 0;
583: igs_uc_transactions_pkg.insert_row (
584: x_mode => p_mode, --jchakrab modified for 4380412
585: x_rowid => lv_rowid,
586: x_uc_tran_id => l_uc_tran_id,
587: x_transaction_id => NULL,

Line 633: igs_uc_transactions_pkg.insert_row (

629: IF (P_Decision IN ('C','I') AND ((P_Course IS NOT NULL AND P_Campus IS NOT NULL) OR
630: (P_Entry_month IS NOT NULL AND P_Entry_Year IS NOT NULL) OR (P_Entry_point IS NOT NULL)))
631: OR (P_Decision NOT IN ('C','I') AND (P_Course IS NULL AND P_Campus IS NULL AND P_Entry_month IS NULL AND P_Entry_year IS NULL AND P_Entry_point IS NULL)) THEN
632: P_return1 := 0;
633: igs_uc_transactions_pkg.insert_row (
634: x_mode => p_mode, --jchakrab modified for 4380412
635: x_rowid => lv_rowid,
636: x_uc_tran_id => l_uc_tran_id,
637: x_transaction_id => NULL,

Line 716: igs_uc_transactions_pkg.insert_row (

712: END IF;
713:
714: IF l_generate_tran = 'Y' THEN
715: P_return1 := 0;
716: igs_uc_transactions_pkg.insert_row (
717: x_mode => p_mode, --jchakrab modified for 4380412
718: x_rowid => lv_rowid,
719: x_uc_tran_id => l_uc_tran_id,
720: x_transaction_id => NULL,

Line 768: igs_uc_transactions_pkg.insert_row (

764: FETCH cur_find_RD INTO l_cnt;
765: CLOSE cur_find_RD;
766: IF l_cnt > 0 THEN
767: P_return1 := 0;
768: igs_uc_transactions_pkg.insert_row (
769: x_mode => p_mode, --jchakrab modified for 4380412
770: x_rowid => lv_rowid,
771: x_uc_tran_id => l_uc_tran_id,
772: x_transaction_id => NULL,

Line 852: igs_uc_transactions_pkg.insert_row (

848: END IF;
849:
850: IF l_generate_tran = 'Y' THEN
851: P_return1 := 0;
852: igs_uc_transactions_pkg.insert_row (
853: x_mode => p_mode, --jchakrab modified for 4380412
854: x_rowid => lv_rowid,
855: x_uc_tran_id => l_uc_tran_id,
856: x_transaction_id => NULL,

Line 904: igs_uc_transactions_pkg.insert_row (

900: AND p_system_code IS NOT NULL AND p_ucas_cycle IS NOT NULL THEN
901: IF P_Free_Format ='.R1' OR P_Free_Format = '.R2' OR P_Free_Format = '.R3'
902: OR P_Free_Format = '.R4' OR P_Free_Format = '.R5' OR P_Free_Format = '.R6' THEN
903: P_return1 := 0;
904: igs_uc_transactions_pkg.insert_row (
905: x_mode => p_mode, --jchakrab modified for 4380412
906: x_rowid => lv_rowid,
907: x_uc_tran_id => l_uc_tran_id,
908: x_transaction_id => NULL,

Line 955: igs_uc_transactions_pkg.insert_row (

951: CLOSE cur_app_choice_decision;
952:
953: IF l_decision = 'U' AND l_reply = 'F' THEN
954: P_return1 := 0;
955: igs_uc_transactions_pkg.insert_row (
956: x_mode => p_mode, --jchakrab modified for 4380412
957: x_rowid => lv_rowid,
958: x_uc_tran_id => l_uc_tran_id,
959: x_transaction_id => NULL,

Line 1011: igs_uc_transactions_pkg.insert_row (

1007: ELSE
1008: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1009: END IF;
1010:
1011: igs_uc_transactions_pkg.insert_row (
1012: x_mode => p_mode, --jchakrab modified for 4380412
1013: x_rowid => lv_rowid,
1014: x_uc_tran_id => l_uc_tran_id,
1015: x_transaction_id => NULL,

Line 1065: igs_uc_transactions_pkg.insert_row (

1061: CLOSE cur_find_trans;
1062:
1063: IF l_cnt > 0 THEN
1064: P_return1 := 0;
1065: igs_uc_transactions_pkg.insert_row (
1066: x_mode => p_mode, --jchakrab modified for 4380412
1067: x_rowid => lv_rowid,
1068: x_uc_tran_id => l_uc_tran_id,
1069: x_transaction_id => NULL,

Line 1111: igs_uc_transactions_pkg.update_row(

1107: OPEN c_transactions(l_uc_tran_id);
1108: FETCH c_transactions INTO l_transactions;
1109: CLOSE c_transactions;
1110:
1111: igs_uc_transactions_pkg.update_row(
1112: x_rowid => l_transactions.rowid,
1113: x_uc_tran_id => l_transactions.uc_tran_id,
1114: x_transaction_id => l_transactions.transaction_id,
1115: x_datetimestamp => l_transactions.datetimestamp,

Line 1163: igs_uc_transactions_pkg.insert_row (

1159: IF P_Decision IN ('W','X') THEN
1160: IF P_Free_Format IS NOT NULL THEN
1161: P_return1 := 0;
1162:
1163: igs_uc_transactions_pkg.insert_row (
1164: x_mode => p_mode, --jchakrab modified for 4380412
1165: x_rowid => lv_rowid,
1166: x_uc_tran_id => l_uc_tran_id,
1167: x_transaction_id => NULL,

Line 1209: igs_uc_transactions_pkg.update_row(

1205: OPEN c_transactions(l_uc_tran_id);
1206: FETCH c_transactions INTO l_transactions;
1207: CLOSE c_transactions;
1208:
1209: igs_uc_transactions_pkg.update_row(
1210: x_rowid => l_transactions.rowid,
1211: x_uc_tran_id => l_transactions.uc_tran_id,
1212: x_transaction_id => l_transactions.transaction_id,
1213: x_datetimestamp => l_transactions.datetimestamp,

Line 1276: igs_uc_transactions_pkg.insert_row (

1272: ELSE
1273: l_hold := NVL(fnd_profile.value('IGS_UC_HOLD_UCAS_TRANSACTION'),'N');
1274: END IF;
1275:
1276: igs_uc_transactions_pkg.insert_row (
1277: x_mode => p_mode, --jchakrab modified for 4380412
1278: x_rowid => lv_rowid,
1279: x_uc_tran_id => l_uc_tran_id,
1280: x_transaction_id => NULL,

Line 1335: PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE ,

1331: RAISE;
1332:
1333: END trans_build;
1334:
1335: PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE ,
1336: p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE ,
1337: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,
1338: p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE ) IS
1339:

Line 1336: p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE ,

1332:
1333: END trans_build;
1334:
1335: PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE ,
1336: p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE ,
1337: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,
1338: p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE ) IS
1339:
1340: /*********************************************************************

Line 1337: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,

1333: END trans_build;
1334:
1335: PROCEDURE transaction_population(p_condition_category1 IN igs_uc_transactions.test_cond_cat%TYPE ,
1336: p_condition_name1 IN igs_uc_transactions.test_cond_name%TYPE ,
1337: p_soc1 OUT NOCOPY igs_uc_transactions.SOC%TYPE,
1338: p_comments_in_offer OUT NOCOPY igs_uc_offer_conds.marvin_code%TYPE ) IS
1339:
1340: /*********************************************************************
1341: Created By : pmarada

Line 1371: PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%TYPE,

1367: p_comments_in_offer := l_offer_conds.marvin_code;
1368:
1369: END transaction_population;
1370:
1371: PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%TYPE,
1372: p_decision IN igs_uc_transactions.decision%TYPE,
1373: p_comments_in_offer IN igs_uc_transactions.comments_in_offer%TYPE,
1374: p_error_code OUT NOCOPY igs_lookup_values.lookup_code%TYPE) IS
1375:

Line 1372: p_decision IN igs_uc_transactions.decision%TYPE,

1368:
1369: END transaction_population;
1370:
1371: PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%TYPE,
1372: p_decision IN igs_uc_transactions.decision%TYPE,
1373: p_comments_in_offer IN igs_uc_transactions.comments_in_offer%TYPE,
1374: p_error_code OUT NOCOPY igs_lookup_values.lookup_code%TYPE) IS
1375:
1376: /*********************************************************************

Line 1373: p_comments_in_offer IN igs_uc_transactions.comments_in_offer%TYPE,

1369: END transaction_population;
1370:
1371: PROCEDURE transaction_validation(p_transaction_type IN igs_uc_transactions.transaction_type%TYPE,
1372: p_decision IN igs_uc_transactions.decision%TYPE,
1373: p_comments_in_offer IN igs_uc_transactions.comments_in_offer%TYPE,
1374: p_error_code OUT NOCOPY igs_lookup_values.lookup_code%TYPE) IS
1375:
1376: /*********************************************************************
1377: Created By : pmarada

Line 1426: Also updates igs_uc_transactions with info. from TRANIN and update the

1422: Created By : solakshm
1423: Date Created By : 23-JAN-2002
1424: Purpose: To write into TRANIN when the 'sent_to_ucas' and 'hold_flag' flag is no.
1425: and cycle is 2003 then write the transaction details in Tranin and
1426: Also updates igs_uc_transactions with info. from TRANIN and update the
1427: igs_uc_offer_conds table with status
1428: Know limitations, enhancements or remarks
1429: Change History
1430: Who When What

Line 1442: 1) added new column auto_generated_flag to tbh calls to igs_uc_transactions_pkg

1438: rbezawad 16-Jul-2002 While inserting Transactions into Tranin, for the program_code and Campus fields, logic is added to replace the '*' character with ' '.
1439: Added logic for better reporting while exporting transactions. Modifications are done w.r.t. Bug 2462096
1440: rbezawad 16-Jul-2002 Added logic to populate the columns SUMM_OF_COND, LETTER_TEXT columns of table IGS_UC_OFFER_CONDS w.r.t. Bug 2461913.
1441: smaddali 02-oct-2002 Modified for bug 2603384
1442: 1) added new column auto_generated_flag to tbh calls to igs_uc_transactions_pkg
1443: 2) modified cursor cur_records_to_write to fetch column auto_generated_flag
1444: 3) modified igs_uc_transactions.update_row call to update test_cond_cat and name
1445: fields with proper values rather than with NULL
1446: ayedubat 05-DEC-2002 Changed the Log file generations of transactions being processed in the current run for bug: 2462078

Line 1444: 3) modified igs_uc_transactions.update_row call to update test_cond_cat and name

1440: rbezawad 16-Jul-2002 Added logic to populate the columns SUMM_OF_COND, LETTER_TEXT columns of table IGS_UC_OFFER_CONDS w.r.t. Bug 2461913.
1441: smaddali 02-oct-2002 Modified for bug 2603384
1442: 1) added new column auto_generated_flag to tbh calls to igs_uc_transactions_pkg
1443: 2) modified cursor cur_records_to_write to fetch column auto_generated_flag
1444: 3) modified igs_uc_transactions.update_row call to update test_cond_cat and name
1445: fields with proper values rather than with NULL
1446: ayedubat 05-DEC-2002 Changed the Log file generations of transactions being processed in the current run for bug: 2462078
1447: Replaced the message, IGS_UC_TRANS_PROC_LOG with the new message 'IGS_UC_TRANS_LOG_HEADER' for dsiplaying
1448: the header line for the transaction records.

Line 1451: arvsrini 26-APR-04 Added code to update IGS_UC_TRANSACTIONS.SOC based on errorcode value Bug#3576288

1447: Replaced the message, IGS_UC_TRANS_PROC_LOG with the new message 'IGS_UC_TRANS_LOG_HEADER' for dsiplaying
1448: the header line for the transaction records.
1449: ayedubat 21-Mar-03 Removed local variable l_log_text w.r.t. Bug 2841582.
1450: pmarada 09-Jun-03 created this procedure Proc_Tranin_2003 and added cycle in required places. as per UCFD203 Multiple cycles
1451: arvsrini 26-APR-04 Added code to update IGS_UC_TRANSACTIONS.SOC based on errorcode value Bug#3576288
1452:
1453: (reverse chronological order - newest change first)
1454: ***************************************************************/
1455:

Line 1466: FROM igs_uc_transactions a, igs_uc_cyc_defaults b

1462: a.hold_flag, a.created_by, a.creation_date,
1463: a.last_updated_by, a.last_update_date, a.last_update_login,
1464: a.sent_to_ucas, a.test_cond_cat, a.test_cond_name, a.inst_reference ,
1465: a.auto_generated_flag, a.system_code , a.ucas_cycle, a.modular, a.part_time
1466: FROM igs_uc_transactions a, igs_uc_cyc_defaults b
1467: WHERE a.sent_to_ucas = 'N' AND a.hold_flag = 'N'
1468: AND a.ucas_cycle = cp_conf_cycle
1469: AND a.system_code = b.system_code
1470: AND a.ucas_cycle = b.ucas_cycle

Line 1474: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS

1470: AND a.ucas_cycle = b.ucas_cycle
1471: AND b.ucas_interface = 'H'
1472: ORDER BY a.creation_date;
1473:
1474: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS
1475: SELECT appno, choiceno, transactionID, errorcode,
1476: timestamp, updater, return1, return2, soc
1477: FROM igs_uc_u_tranin_2003
1478: WHERE appno = cp_appno

Line 1483: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,

1479: AND transactionID = (SELECT MAX(TransactionID)
1480: FROM igs_uc_u_tranin_2003
1481: WHERE appno = cp_appno);
1482:
1483: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1484: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS
1485: SELECT a.ROWID,a.condition_category, a.condition_name,
1486: a.effective_from, a.effective_to, a.status, a.marvin_code,
1487: a.summ_of_cond, a.letter_text, a.created_by,

Line 1484: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS

1480: FROM igs_uc_u_tranin_2003
1481: WHERE appno = cp_appno);
1482:
1483: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1484: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS
1485: SELECT a.ROWID,a.condition_category, a.condition_name,
1486: a.effective_from, a.effective_to, a.status, a.marvin_code,
1487: a.summ_of_cond, a.letter_text, a.created_by,
1488: a.creation_date, a.last_updated_by,

Line 1494: l_app_no igs_uc_transactions.app_no%TYPE;

1490: FROM igs_uc_offer_conds a
1491: WHERE a.condition_category = cp_test_cond_cat
1492: AND a.condition_name = cp_test_cond_name;
1493:
1494: l_app_no igs_uc_transactions.app_no%TYPE;
1495: l_user_id Varchar2(20) := fnd_global.user_id;
1496: l_soc igs_uc_transactions.soc%TYPE;
1497:
1498: BEGIN

Line 1496: l_soc igs_uc_transactions.soc%TYPE;

1492: AND a.condition_name = cp_test_cond_name;
1493:
1494: l_app_no igs_uc_transactions.app_no%TYPE;
1495: l_user_id Varchar2(20) := fnd_global.user_id;
1496: l_soc igs_uc_transactions.soc%TYPE;
1497:
1498: BEGIN
1499:
1500: -- get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2003 View.

Line 1500: -- get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2003 View.

1496: l_soc igs_uc_transactions.soc%TYPE;
1497:
1498: BEGIN
1499:
1500: -- get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2003 View.
1501: FOR uc_transaction_rec IN cur_records_to_write(p_conf_cycle)
1502: LOOP
1503: l_app_no := uc_transaction_rec.app_no;
1504:

Line 1545: -- the newly inserted record from TranIn and Update the IGS_UC_TRANSACTIONS Table.

1541: uc_transaction_rec.inst_reference
1542: );
1543:
1544: -- Get back the values for transactionID,errorcode,timestamp,updater,return1,return2 columns for
1545: -- the newly inserted record from TranIn and Update the IGS_UC_TRANSACTIONS Table.
1546:
1547: FOR tranin_rec IN cur_update_info(l_app_no)
1548: LOOP
1549:

Line 1556: igs_uc_transactions_pkg.update_row (

1552: ELSE
1553: l_soc:=uc_transaction_rec.SOC;
1554: END IF;
1555:
1556: igs_uc_transactions_pkg.update_row (
1557: x_mode => 'R',
1558: x_rowid => uc_transaction_rec.ROWID,
1559: x_uc_tran_id => uc_transaction_rec.UC_Tran_Id,
1560: x_transaction_id => tranin_rec.transactionid,

Line 1656: Also updates igs_uc_transactions with info. from TRANIN, and update the

1652: Created By : pmarada
1653: Date Created By : 10-June-2003
1654: Purpose: To write into TRANIN when the 'sent_to_ucas' and 'hold_flag' flag is no.
1655: and cycle is 2004 then write the transaction details into Tranin and
1656: Also updates igs_uc_transactions with info. from TRANIN, and update the
1657: igs_uc_offer_conds table with status.
1658: Know limitations, enhancements or remarks
1659: Change History (reverse chronological order - newest change first)
1660:

Line 1667: arvsrini 26-Apr-2004 Added code to update IGS_UC_TRANSACTIONS.SOC based on

1663: jbaber 19-Aug-2005 Modified for UC307 - HERCULES Small Systems Support
1664: Added p_system_code parameter
1665: jbaber 12-Jul-2004 Modified for UC315 - UCAS 2006 Support
1666: Appended check_digit to appno when configured cycle > 2005
1667: arvsrini 26-Apr-2004 Added code to update IGS_UC_TRANSACTIONS.SOC based on
1668: the errorcode value Bug#3576288
1669: **********************************************************************/
1670:
1671: CURSOR cur_records_to_write(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS

Line 1681: FROM igs_uc_transactions a, igs_uc_cyc_defaults b

1677: a.hold_flag, a.created_by, a.creation_date,
1678: a.last_updated_by, a.last_update_date, a.last_update_login,
1679: a.sent_to_ucas, a.test_cond_cat, a.test_cond_name, a.inst_reference ,
1680: a.auto_generated_flag, a.system_code , a.ucas_cycle, a.modular, a.part_time
1681: FROM igs_uc_transactions a, igs_uc_cyc_defaults b
1682: WHERE a.sent_to_ucas = 'N' AND a.hold_flag = 'N'
1683: AND a.ucas_cycle = cp_conf_cycle
1684: AND a.system_code = p_system_code
1685: AND a.system_code = b.system_code

Line 1690: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS

1686: AND a.ucas_cycle = b.ucas_cycle
1687: AND b.ucas_interface = 'H'
1688: ORDER BY a.creation_date;
1689:
1690: CURSOR cur_update_info(cp_appno igs_uc_transactions.app_no%TYPE) IS
1691: SELECT appno, choiceno, transactionID, errorcode,
1692: timestamp, updater, return1, return2, soc, roundno
1693: FROM igs_uc_u_tranin_2004
1694: WHERE appno = cp_appno

Line 1699: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,

1695: AND transactionID = (SELECT MAX(TransactionID)
1696: FROM igs_uc_u_tranin_2004
1697: WHERE appno = cp_appno);
1698:
1699: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1700: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS
1701: SELECT a.ROWID,a.condition_category, a.condition_name,
1702: a.effective_from, a.effective_to, a.status, a.marvin_code,
1703: a.summ_of_cond, a.letter_text, a.created_by,

Line 1700: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS

1696: FROM igs_uc_u_tranin_2004
1697: WHERE appno = cp_appno);
1698:
1699: CURSOR cur_offer_conds(cp_test_cond_cat igs_uc_transactions.test_cond_cat%TYPE,
1700: cp_test_cond_name igs_uc_transactions.test_cond_name%TYPE) IS
1701: SELECT a.ROWID,a.condition_category, a.condition_name,
1702: a.effective_from, a.effective_to, a.status, a.marvin_code,
1703: a.summ_of_cond, a.letter_text, a.created_by,
1704: a.creation_date, a.last_updated_by,

Line 1717: l_soc igs_uc_transactions.soc%TYPE;

1713: FROM igs_uc_applicants
1714: WHERE app_no = cp_appno;
1715:
1716: l_user_id Varchar2(20) := fnd_global.user_id;
1717: l_soc igs_uc_transactions.soc%TYPE;
1718: l_appno igs_uc_u_tranin_2004.appno%TYPE;
1719:
1720: BEGIN
1721:

Line 1722: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .

1718: l_appno igs_uc_u_tranin_2004.appno%TYPE;
1719:
1720: BEGIN
1721:
1722: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .
1723: FOR uc_transaction_rec IN cur_records_to_write(p_conf_cycle)
1724: LOOP
1725:
1726: -- For cycle 2004 syscode, roundno, modular, parttime columns are added in tranin table

Line 1834: -- the newly inserted record from igs_uc_u_tranin_2004 and Update the IGS_UC_TRANSACTIONS Table.

1830:
1831: END IF;
1832:
1833: -- Get back the values for transactionID,errorcode,timestamp,updater,return1,return2 columns for
1834: -- the newly inserted record from igs_uc_u_tranin_2004 and Update the IGS_UC_TRANSACTIONS Table.
1835:
1836: FOR tranin_rec IN cur_update_info(l_appno)
1837: LOOP
1838:

Line 1845: igs_uc_transactions_pkg.update_row (

1841: ELSE
1842: l_soc:=uc_transaction_rec.SOC;
1843: END IF;
1844:
1845: igs_uc_transactions_pkg.update_row (
1846: x_mode => 'R',
1847: x_rowid => uc_transaction_rec.ROWID,
1848: x_uc_tran_id => uc_transaction_rec.UC_Tran_Id,
1849: x_transaction_id => tranin_rec.transactionid,