APPS.CSI_TRANSACTION_LINES_PVT dependencies on CSI_BATCH_TXN_LINES

Line 36: TYPE header_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_HEADER_ID%TYPE ;

32: l_request_id NUMBER;
33: l_start_timestamp TIMESTAMP;
34: l_end_timestamp TIMESTAMP;
35:
36: TYPE header_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_HEADER_ID%TYPE ;
37: TYPE line_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_LINE_ID%TYPE ;
38: TYPE transaction_id_type is TABLE of CSI_BATCH_TXN_LINES.transaction_id%type;
39: TYPE transaction_type is TABLE of CSI_BATCH_TXN_LINES.transaction_type%type;
40:

Line 37: TYPE line_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_LINE_ID%TYPE ;

33: l_start_timestamp TIMESTAMP;
34: l_end_timestamp TIMESTAMP;
35:
36: TYPE header_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_HEADER_ID%TYPE ;
37: TYPE line_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_LINE_ID%TYPE ;
38: TYPE transaction_id_type is TABLE of CSI_BATCH_TXN_LINES.transaction_id%type;
39: TYPE transaction_type is TABLE of CSI_BATCH_TXN_LINES.transaction_type%type;
40:
41: l_header_id_tbl header_id_array_type;

Line 38: TYPE transaction_id_type is TABLE of CSI_BATCH_TXN_LINES.transaction_id%type;

34: l_end_timestamp TIMESTAMP;
35:
36: TYPE header_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_HEADER_ID%TYPE ;
37: TYPE line_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_LINE_ID%TYPE ;
38: TYPE transaction_id_type is TABLE of CSI_BATCH_TXN_LINES.transaction_id%type;
39: TYPE transaction_type is TABLE of CSI_BATCH_TXN_LINES.transaction_type%type;
40:
41: l_header_id_tbl header_id_array_type;
42: l_line_id_tbl line_id_array_type;

Line 39: TYPE transaction_type is TABLE of CSI_BATCH_TXN_LINES.transaction_type%type;

35:
36: TYPE header_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_HEADER_ID%TYPE ;
37: TYPE line_id_array_type is TABLE OF CSI_BATCH_TXN_LINES.ORDER_LINE_ID%TYPE ;
38: TYPE transaction_id_type is TABLE of CSI_BATCH_TXN_LINES.transaction_id%type;
39: TYPE transaction_type is TABLE of CSI_BATCH_TXN_LINES.transaction_type%type;
40:
41: l_header_id_tbl header_id_array_type;
42: l_line_id_tbl line_id_array_type;
43: l_transaction_id_tbl transaction_id_type;

Line 48: FROM CSI_BATCH_TXN_LINES

44: l_transaction_type_tbl transaction_type;
45:
46: CURSOR transaction_lines_cur IS
47: SELECT transaction_type,transaction_id,order_header_id,order_line_id
48: FROM CSI_BATCH_TXN_LINES
49: WHERE batch_id = p_batch_id
50: AND processed_flag = 2
51: order by order_header_id,order_line_id;
52: --l_txn_lines_rec transaction_lines_cur%rowtype;

Line 65: update CSI_BATCH_TXN_LINES

61:
62: debug('BEGIN CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);
63:
64: -- mark the rows as being processed by worker
65: update CSI_BATCH_TXN_LINES
66: set processed_flag = 2,last_update_date = sysdate,last_updated_by = fnd_global.user_id
67: where batch_id = p_batch_id
68: and processed_flag = 1;
69:

Line 101: UPDATE CSI_BATCH_TXN_LINES

97:
98: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
99: debug('Call to csi_inv_txnstub_pkg.execute_trx_dpl fails with status '||l_return_status);
100:
101: UPDATE CSI_BATCH_TXN_LINES
102: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
103: WHERE batch_id = p_batch_id
104: AND processed_flag = 2
105: and order_line_id = l_line_id_tbl(i);

Line 125: UPDATE CSI_BATCH_TXN_LINES

121: IF (l_return_status is null OR l_return_status <> fnd_api.g_ret_sts_success) THEN
122: fnd_file.put_line(fnd_file.log,'Error Occured while processing Order Line '||l_line_id_tbl(i));
123: debug('Call to csi_order_ship_pub.order_shipment fails with status '||l_return_status);
124:
125: UPDATE CSI_BATCH_TXN_LINES
126: SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
127: WHERE batch_id = p_batch_id
128: AND processed_flag = 2
129: AND order_line_id = l_line_id_tbl(i);

Line 155: delete from csi_batch_txn_lines

151:
152: if p_purge_option = 'Y' then
153:
154: --delete processed rows from the table
155: delete from csi_batch_txn_lines
156: where batch_id = p_batch_id
157: AND processed_flag = 2;
158: else
159:

Line 161: UPDATE csi_batch_txn_lines

157: AND processed_flag = 2;
158: else
159:
160: -- mark the processed rows as success
161: UPDATE csi_batch_txn_lines
162: SET processed_flag = 3,last_update_date = sysdate,last_updated_by = fnd_global.user_id
163: where batch_id = p_batch_id
164: and processed_flag = 2;
165:

Line 197: update csi_batch_txn_lines

193:
194:
195: ROLLBACK TO process_txn_lines;
196:
197: update csi_batch_txn_lines
198: set batch_id = -1,processed_flag = 0,last_update_date = sysdate,last_updated_by = fnd_global.user_id
199: where batch_id = p_batch_id;
200:
201: commit;