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.CSI_TRANSACTIONS_PVT dependencies on DBMS_SQL

Line 27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);

23: )
24: IS
25: BEGIN
26:
27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);
28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);

Line 28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);

24: IS
25: BEGIN
26:
27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);
28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);

Line 29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);

25: BEGIN
26:
27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);
28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );

Line 30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);

26:
27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);
28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);

Line 31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);

27: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 1, p_txnfind_rec.transaction_id);
28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);

Line 32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);

28: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 2, p_txnfind_rec.transaction_date);
29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);

Line 33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );

29: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 3, p_txnfind_rec.source_transaction_date);
30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);

Line 34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);

30: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 4, p_txnfind_rec.transaction_type_id);
31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);

Line 35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);

31: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 5, p_txnfind_rec.source_group_ref_id);
32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);

Line 36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);

32: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 6, p_txnfind_rec.source_group_ref,50);
33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);

Line 37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);

33: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 7, p_txnfind_rec.source_header_ref_id );
34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);

Line 38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);

34: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 8, p_txnfind_rec.source_header_ref,50);
35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);

Line 39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);

35: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 9, p_txnfind_rec.source_line_ref_id);
36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);

Line 40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);

36: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 10, p_txnfind_rec.source_line_ref,50);
37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);

Line 41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);

37: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 11, p_txnfind_rec.source_dist_ref_id1);
38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);

Line 42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);

38: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 12, p_txnfind_rec.source_dist_ref_id2);
39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);

Line 43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);

39: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 13, p_txnfind_rec.inv_material_transaction_id);
40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);

Line 44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);

40: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 14, p_txnfind_rec.transaction_quantity);
41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);

Line 45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);

41: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 15, p_txnfind_rec.transaction_uom_code,3);
42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);

Line 46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);

42: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 16, p_txnfind_rec.transacted_by);
43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);

Line 47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);

43: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 17, p_txnfind_rec.transaction_status_code,30);
44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);

Line 48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);

44: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 18, p_txnfind_rec.transaction_action_code,30);
45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);

Line 49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);

45: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 19, p_txnfind_rec.message_id);
46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);

Line 50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);

46: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 21, p_txnfind_rec.attribute1,150);
47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);

Line 51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);

47: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 22, p_txnfind_rec.attribute2,150);
48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);

Line 52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);

48: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 23, p_txnfind_rec.attribute3,150);
49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);

Line 53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);

49: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 24, p_txnfind_rec.attribute4,150);
50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);

Line 54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);

50: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 25, p_txnfind_rec.attribute5,150);
51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);

Line 55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);

51: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 26, p_txnfind_rec.attribute6,150);
52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);

Line 56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);

52: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 27, p_txnfind_rec.attribute7,150);
53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);

Line 57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);

53: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 28, p_txnfind_rec.attribute8,150);
54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);

Line 58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);

54: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 29, p_txnfind_rec.attribute9,150);
55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);

Line 59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);

55: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 30, p_txnfind_rec.attribute10,150);
56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);

Line 60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);

56: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 31, p_txnfind_rec.attribute11,150);
57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);

Line 61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);

57: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 32, p_txnfind_rec.attribute12,150);
58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);
65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);

Line 62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);

58: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 33, p_txnfind_rec.attribute13,150);
59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);
65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);
66: END define_columns;

Line 63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);

59: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 34, p_txnfind_rec.attribute14,150);
60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);
65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);
66: END define_columns;
67:

Line 64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);

60: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 35, p_txnfind_rec.attribute15,150);
61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);
65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);
66: END define_columns;
67:
68: -- This procudure gets column values by the dynamic sql.

Line 65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);

61: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 36, p_txnfind_rec.object_version_number);
62: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 37, p_txnfind_rec.txn_sub_type_id);
63: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 38, p_txnfind_rec.transaction_status_code,30);
64: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 39, p_txnfind_rec.split_reason_code,30);
65: DBMS_SQL.DEFINE_COLUMN(p_cur_get_transactions, 40, p_txnfind_rec.txn_user_id);
66: END define_columns;
67:
68: -- This procudure gets column values by the dynamic sql.
69: PROCEDURE get_column_values(

Line 76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);

72: )
73: IS
74: BEGIN
75: -- get all column values for csi_transactions table
76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);

Line 77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);

73: IS
74: BEGIN
75: -- get all column values for csi_transactions table
76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);

Line 78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);

74: BEGIN
75: -- get all column values for csi_transactions table
76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);

Line 79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);

75: -- get all column values for csi_transactions table
76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);

Line 80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);

76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);

Line 81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);

77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);

Line 82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);

78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);

Line 83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);

79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);
80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);

Line 84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);

80: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 5, x_txnfind_rec.source_group_ref_id);
81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);

Line 85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);

81: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 6, x_txnfind_rec.source_group_ref);
82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);

Line 86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);

82: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 7, x_txnfind_rec.source_header_ref_id);
83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);

Line 87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);

83: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 8, x_txnfind_rec.source_header_ref);
84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);

Line 88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);

84: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 9, x_txnfind_rec.source_line_ref_id);
85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);

Line 89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);

85: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 10, x_txnfind_rec.source_line_ref);
86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);

Line 90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);

86: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 11, x_txnfind_rec.source_dist_ref_id1);
87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);

Line 91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);

87: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 12, x_txnfind_rec.source_dist_ref_id2);
88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);

Line 92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);

88: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 13, x_txnfind_rec.inv_material_transaction_id);
89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);

Line 93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);

89: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 14, x_txnfind_rec.transaction_quantity);
90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);

Line 94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);

90: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 15, x_txnfind_rec.transaction_uom_code);
91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);

Line 95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);

91: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 16, x_txnfind_rec.transacted_by);
92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);

Line 96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);

92: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 17, x_txnfind_rec.transaction_status_code);
93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);

Line 97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);

93: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 18, x_txnfind_rec.transaction_action_code);
94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);

Line 98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);

94: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 19, x_txnfind_rec.message_id);
95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);

Line 99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);

95: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 21, x_txnfind_rec.attribute1);
96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);

Line 100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);

96: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 22, x_txnfind_rec.attribute2);
97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);

Line 101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);

97: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 23, x_txnfind_rec.attribute3);
98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);

Line 102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);

98: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 24, x_txnfind_rec.attribute4);
99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);

Line 103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);

99: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 25, x_txnfind_rec.attribute5);
100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);

Line 104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);

100: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 26, x_txnfind_rec.attribute6);
101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);

Line 105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);

101: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 27, x_txnfind_rec.attribute7);
102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);

Line 106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);

102: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 28, x_txnfind_rec.attribute8);
103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);

Line 107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);

103: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 29, x_txnfind_rec.attribute9);
104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);

Line 108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);

104: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 30, x_txnfind_rec.attribute10);
105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);

Line 109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);

105: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 31, x_txnfind_rec.attribute11);
106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);

Line 110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);

106: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 32, x_txnfind_rec.attribute12);
107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);
114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);

Line 111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);

107: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 33, x_txnfind_rec.attribute13);
108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);
114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);
115: END get_column_values;

Line 112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);

108: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 34, x_txnfind_rec.attribute14);
109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);
114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);
115: END get_column_values;
116:

Line 113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);

109: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 35, x_txnfind_rec.attribute15);
110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);
114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);
115: END get_column_values;
116:
117:

Line 114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);

110: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 36, x_txnfind_rec.object_version_number);
111: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 37, x_txnfind_rec.txn_sub_type_id);
112: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 38, x_txnfind_rec.transaction_status_code);
113: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 39, x_txnfind_rec.split_reason_code);
114: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 40, x_txnfind_rec.txn_user_id);
115: END get_column_values;
116:
117:
118: PROCEDURE gen_transactions_order_cl(

Line 154: dbms_sql.bind_variable(p_cur_get_transactions, 'transaction_id', p_txnfind_rec.transaction_id);

150: IS
151: BEGIN
152: IF( (p_txnfind_rec.transaction_id IS NOT NULL) AND (p_txnfind_rec.transaction_id <> fnd_api.g_miss_num) )
153: THEN
154: dbms_sql.bind_variable(p_cur_get_transactions, 'transaction_id', p_txnfind_rec.transaction_id);
155: END IF;
156:
157: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )
158: THEN

Line 159: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_type_id', p_txnfind_rec.transaction_type_id);

155: END IF;
156:
157: IF( (p_txnfind_rec.transaction_type_id IS NOT NULL) AND (p_txnfind_rec.transaction_type_id <> fnd_api.g_miss_num) )
158: THEN
159: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_type_id', p_txnfind_rec.transaction_type_id);
160: END IF;
161:
162: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )
163: THEN

Line 164: dbms_sql.bind_variable(p_cur_get_transactions, ':txn_sub_type_id', p_txnfind_rec.txn_sub_type_id);

160: END IF;
161:
162: IF( (p_txnfind_rec.txn_sub_type_id IS NOT NULL) AND (p_txnfind_rec.txn_sub_type_id <> fnd_api.g_miss_num) )
163: THEN
164: dbms_sql.bind_variable(p_cur_get_transactions, ':txn_sub_type_id', p_txnfind_rec.txn_sub_type_id);
165: END IF;
166:
167: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id<> fnd_api.g_miss_num) )
168: THEN

Line 169: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref_id', p_txnfind_rec.source_group_ref_id);

165: END IF;
166:
167: IF( (p_txnfind_rec.source_group_ref_id IS NOT NULL) AND (p_txnfind_rec.source_group_ref_id<> fnd_api.g_miss_num) )
168: THEN
169: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref_id', p_txnfind_rec.source_group_ref_id);
170: END IF;
171:
172: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )
173: THEN

Line 174: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref', p_txnfind_rec.source_group_ref);

170: END IF;
171:
172: IF( (p_txnfind_rec.source_group_ref IS NOT NULL) AND (p_txnfind_rec.source_group_ref <> fnd_api.g_miss_char) )
173: THEN
174: dbms_sql.bind_variable(p_cur_get_transactions, ':source_group_ref', p_txnfind_rec.source_group_ref);
175: END IF;
176:
177: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )
178: THEN

Line 179: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref_id', p_txnfind_rec.source_header_ref_id);

175: END IF;
176:
177: IF( (p_txnfind_rec.source_header_ref_id IS NOT NULL) AND (p_txnfind_rec.source_header_ref_id <> fnd_api.g_miss_num) )
178: THEN
179: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref_id', p_txnfind_rec.source_header_ref_id);
180: END IF;
181:
182: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )
183: THEN

Line 184: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref', p_txnfind_rec.source_header_ref);

180: END IF;
181:
182: IF( (p_txnfind_rec.source_header_ref IS NOT NULL) AND (p_txnfind_rec.source_header_ref <> fnd_api.g_miss_char) )
183: THEN
184: dbms_sql.bind_variable(p_cur_get_transactions, ':source_header_ref', p_txnfind_rec.source_header_ref);
185: END IF;
186:
187: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )
188: THEN

Line 189: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref_id', p_txnfind_rec.source_line_ref_id);

185: END IF;
186:
187: IF( (p_txnfind_rec.source_line_ref_id IS NOT NULL) AND (p_txnfind_rec.source_line_ref_id <> fnd_api.g_miss_num) )
188: THEN
189: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref_id', p_txnfind_rec.source_line_ref_id);
190: END IF;
191:
192: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )
193: THEN

Line 194: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref', rtrim(ltrim(p_txnfind_rec.source_line_ref)));

190: END IF;
191:
192: IF( (p_txnfind_rec.source_line_ref IS NOT NULL) AND (p_txnfind_rec.source_line_ref <> fnd_api.g_miss_char) )
193: THEN
194: dbms_sql.bind_variable(p_cur_get_transactions, ':source_line_ref', rtrim(ltrim(p_txnfind_rec.source_line_ref)));
195: END IF;
196:
197: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )
198: THEN

Line 199: dbms_sql.bind_variable(p_cur_get_transactions, ':source_txn_date', p_txnfind_rec.source_transaction_date);

195: END IF;
196:
197: IF( (p_txnfind_rec.source_transaction_date IS NOT NULL) AND (p_txnfind_rec.source_transaction_date <> fnd_api.g_miss_date) )
198: THEN
199: dbms_sql.bind_variable(p_cur_get_transactions, ':source_txn_date', p_txnfind_rec.source_transaction_date);
200: END IF;
201:
202: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )
203: THEN

Line 204: dbms_sql.bind_variable(p_cur_get_transactions, ':inv_material_transaction_id', p_txnfind_rec.inv_material_transaction_id);

200: END IF;
201:
202: IF( (p_txnfind_rec.inv_material_transaction_id IS NOT NULL) AND (p_txnfind_rec.inv_material_transaction_id <> fnd_api.g_miss_num) )
203: THEN
204: dbms_sql.bind_variable(p_cur_get_transactions, ':inv_material_transaction_id', p_txnfind_rec.inv_material_transaction_id);
205: END IF;
206:
207: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )
208: THEN

Line 209: dbms_sql.bind_variable(p_cur_get_transactions, ':message_id', p_txnfind_rec.message_id);

205: END IF;
206:
207: IF( (p_txnfind_rec.message_id IS NOT NULL) AND (p_txnfind_rec.message_id <> fnd_api.g_miss_num) )
208: THEN
209: dbms_sql.bind_variable(p_cur_get_transactions, ':message_id', p_txnfind_rec.message_id);
210: END IF;
211:
212: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )
213: THEN

Line 214: dbms_sql.bind_variable(p_cur_get_transactions, ':instance_id', p_txnfind_rec.instance_id);

210: END IF;
211:
212: IF( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) )
213: THEN
214: dbms_sql.bind_variable(p_cur_get_transactions, ':instance_id', p_txnfind_rec.instance_id);
215: END IF;
216:
217:
218: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )

Line 220: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_start_date', p_txnfind_rec.transaction_start_date);

216:
217:
218: IF( (p_txnfind_rec.transaction_start_date IS NOT NULL) AND (p_txnfind_rec.transaction_start_date <> fnd_api.g_miss_date) )
219: THEN
220: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_start_date', p_txnfind_rec.transaction_start_date);
221: END IF;
222:
223:
224: IF( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )

Line 226: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_end_date', p_txnfind_rec.transaction_end_date);

222:
223:
224: IF( (p_txnfind_rec.transaction_end_date IS NOT NULL) AND (p_txnfind_rec.transaction_end_date <> fnd_api.g_miss_date) )
225: THEN
226: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_end_date', p_txnfind_rec.transaction_end_date);
227: END IF;
228:
229: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )
230: THEN

Line 231: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_status_code', p_txnfind_rec.transaction_status_code);

227: END IF;
228:
229: IF( (p_txnfind_rec.transaction_status_code IS NOT NULL) AND (p_txnfind_rec.transaction_status_code <> fnd_api.g_miss_char) )
230: THEN
231: dbms_sql.bind_variable(p_cur_get_transactions, ':transaction_status_code', p_txnfind_rec.transaction_status_code);
232: END IF;
233:
234: END bind;
235:

Line 733: IF dbms_sql.is_open(l_cur_get_transactions) THEN

729: gen_select(l_crit_transaction_rec,l_select_cl);
730: gen_transactions_where(l_crit_transaction_rec, l_transactions_where);
731: gen_transactions_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
732:
733: IF dbms_sql.is_open(l_cur_get_transactions) THEN
734: dbms_sql.close_cursor(l_cur_get_transactions);
735: END IF;
736:
737: l_cur_get_transactions := dbms_sql.open_cursor;

Line 734: dbms_sql.close_cursor(l_cur_get_transactions);

730: gen_transactions_where(l_crit_transaction_rec, l_transactions_where);
731: gen_transactions_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
732:
733: IF dbms_sql.is_open(l_cur_get_transactions) THEN
734: dbms_sql.close_cursor(l_cur_get_transactions);
735: END IF;
736:
737: l_cur_get_transactions := dbms_sql.open_cursor;
738: dbms_sql.parse(l_cur_get_transactions, l_select_cl|| l_transactions_where || l_order_by_cl , dbms_sql.native);

Line 737: l_cur_get_transactions := dbms_sql.open_cursor;

733: IF dbms_sql.is_open(l_cur_get_transactions) THEN
734: dbms_sql.close_cursor(l_cur_get_transactions);
735: END IF;
736:
737: l_cur_get_transactions := dbms_sql.open_cursor;
738: dbms_sql.parse(l_cur_get_transactions, l_select_cl|| l_transactions_where || l_order_by_cl , dbms_sql.native);
739: bind(l_crit_transaction_rec, l_cur_get_transactions);
740: define_columns(l_def_transaction_rec, l_cur_get_transactions);
741: l_ignore := dbms_sql.execute(l_cur_get_transactions);

Line 738: dbms_sql.parse(l_cur_get_transactions, l_select_cl|| l_transactions_where || l_order_by_cl , dbms_sql.native);

734: dbms_sql.close_cursor(l_cur_get_transactions);
735: END IF;
736:
737: l_cur_get_transactions := dbms_sql.open_cursor;
738: dbms_sql.parse(l_cur_get_transactions, l_select_cl|| l_transactions_where || l_order_by_cl , dbms_sql.native);
739: bind(l_crit_transaction_rec, l_cur_get_transactions);
740: define_columns(l_def_transaction_rec, l_cur_get_transactions);
741: l_ignore := dbms_sql.execute(l_cur_get_transactions);
742:

Line 741: l_ignore := dbms_sql.execute(l_cur_get_transactions);

737: l_cur_get_transactions := dbms_sql.open_cursor;
738: dbms_sql.parse(l_cur_get_transactions, l_select_cl|| l_transactions_where || l_order_by_cl , dbms_sql.native);
739: bind(l_crit_transaction_rec, l_cur_get_transactions);
740: define_columns(l_def_transaction_rec, l_cur_get_transactions);
741: l_ignore := dbms_sql.execute(l_cur_get_transactions);
742:
743: LOOP
744:
745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)

Line 745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)

741: l_ignore := dbms_sql.execute(l_cur_get_transactions);
742:
743: LOOP
744:
745: IF((dbms_sql.fetch_rows(l_cur_get_transactions)>0) AND ((p_return_tot_count = fnd_api.g_true)
746: OR (l_returned_rec_count 747: THEN
748: get_column_values(l_cur_get_transactions, l_txn_rec);
749: l_tot_rec_count := l_tot_rec_count + 1;

Line 828: dbms_sql.close_cursor(l_cur_get_transactions);

824: END LOOP;
825: --
826: -- end of api body
827: --
828: dbms_sql.close_cursor(l_cur_get_transactions);
829:
830: -- standard call to get message count and if count is 1, get message info.
831: fnd_msg_pub.count_and_get
832: ( p_count => x_msg_count,