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.CZ_IB_TRANSACTIONS dependencies on CZ_IB_TRANSACTIONS

Line 1: PACKAGE BODY CZ_IB_TRANSACTIONS AS

1: PACKAGE BODY CZ_IB_TRANSACTIONS AS
2: /* $Header: czibtxb.pls 120.8.12010000.4 2008/11/27 11:40:35 kdande ship $ */
3:
4: G_IB_TXN_STATUS_PROCESSED CONSTANT VARCHAR2(10) := 'PROCESSED';
5:

Line 32: 'CZ_IB_TRANSACTIONS',

28: VALUES (p_run_id,
29: SYSDATE,
30: USER,
31: 1,
32: 'CZ_IB_TRANSACTIONS',
33: 11276,
34: p_error_message,
35: m_COUNTER);
36: COMMIT;

Line 38: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,

34: p_error_message,
35: m_COUNTER);
36: COMMIT;
37:
38: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,
39: p_error_message, fnd_log.LEVEL_ERROR);
40:
41: ELSE
42: FOR i IN 1..p_count

Line 59: 'CZ_IB_TRANSACTIONS',

55: (p_run_id,
56: SYSDATE,
57: USER,
58: 1,
59: 'CZ_IB_TRANSACTIONS',
60: 11276,
61: fnd_msg_pub.GET(i,fnd_api.g_false),
62: m_COUNTER);
63: COMMIT;

Line 65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,

61: fnd_msg_pub.GET(i,fnd_api.g_false),
62: m_COUNTER);
63: COMMIT;
64:
65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,
66: fnd_msg_pub.GET(i,fnd_api.g_false), fnd_log.LEVEL_ERROR);
67: END LOOP;
68:
69: END IF;

Line 188: ' ,x_return_status => CZ_IB_TRANSACTIONS.m_return_status ' ||

184: ' ,p_init_msg_list => :3 ' ||
185: ' ,p_validation_level => :4 ' ||
186: ' ,p_api_caller_identity => :5 ' ||
187: ' ,p_transaction_line_id => :6 ' ||
188: ' ,x_return_status => CZ_IB_TRANSACTIONS.m_return_status ' ||
189: ' ,x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count ' ||
190: ' ,x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
191: ' ); ' ||
192: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level,

Line 189: ' ,x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count ' ||

185: ' ,p_validation_level => :4 ' ||
186: ' ,p_api_caller_identity => :5 ' ||
187: ' ,p_transaction_line_id => :6 ' ||
188: ' ,x_return_status => CZ_IB_TRANSACTIONS.m_return_status ' ||
189: ' ,x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count ' ||
190: ' ,x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
191: ' ); ' ||
192: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level,
193: p_api_caller_identity,p_transaction_line_id;

Line 190: ' ,x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||

186: ' ,p_api_caller_identity => :5 ' ||
187: ' ,p_transaction_line_id => :6 ' ||
188: ' ,x_return_status => CZ_IB_TRANSACTIONS.m_return_status ' ||
189: ' ,x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count ' ||
190: ' ,x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
191: ' ); ' ||
192: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level,
193: p_api_caller_identity,p_transaction_line_id;
194:

Line 195: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;

191: ' ); ' ||
192: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level,
193: p_api_caller_identity,p_transaction_line_id;
194:
195: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
196: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
197: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
198: EXCEPTION
199: WHEN OTHERS THEN

Line 196: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;

192: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level,
193: p_api_caller_identity,p_transaction_line_id;
194:
195: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
196: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
197: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
198: EXCEPTION
199: WHEN OTHERS THEN
200: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 197: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;

193: p_api_caller_identity,p_transaction_line_id;
194:
195: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
196: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
197: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
198: EXCEPTION
199: WHEN OTHERS THEN
200: x_return_status := FND_API.g_ret_sts_unexp_error;
201: x_msg_count := 1;

Line 202: x_msg_data := 'CZ_IB_TRANSACTIONS.delete_transaction_dtls : '||SQLERRM;

198: EXCEPTION
199: WHEN OTHERS THEN
200: x_return_status := FND_API.g_ret_sts_unexp_error;
201: x_msg_count := 1;
202: x_msg_data := 'CZ_IB_TRANSACTIONS.delete_transaction_dtls : '||SQLERRM;
203: LOG_REPORT(m_RUN_ID,x_msg_data);
204: END delete_transaction_dtls;
205:
206:

Line 242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||

238: ' t_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl; ' ||
239: ' t_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl; ' ||
240: ' t_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl; ' ||
241: ' BEGIN ' ||
242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||
243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||

Line 243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||

239: ' t_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl; ' ||
240: ' t_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl; ' ||
241: ' BEGIN ' ||
242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||
243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||

Line 244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||

240: ' t_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl; ' ||
241: ' BEGIN ' ||
242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||
243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||

Line 245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||

241: ' BEGIN ' ||
242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||
243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||

Line 246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||

242: ' t_txn_line_rec.TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID; ' ||
243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||

Line 247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||

243: ' t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||

Line 248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||

244: ' t_txn_line_rec.SOURCE_TRANSACTION_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||

Line 249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||

245: ' t_txn_line_rec.SOURCE_TXN_HEADER_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||

Line 250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||

246: ' t_txn_line_rec.SOURCE_TRANSACTION_TABLE := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||

Line 251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||

247: ' t_txn_line_rec.CONFIG_SESSION_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||

Line 252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||

248: ' t_txn_line_rec.CONFIG_SESSION_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||

Line 253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||

249: ' t_txn_line_rec.CONFIG_SESSION_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||

Line 254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||

250: ' t_txn_line_rec.CONFIG_VALID_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS; ' ||
251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||

Line 255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||

251: ' t_txn_line_rec.SOURCE_TRANSACTION_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||

Line 256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||

252: ' t_txn_line_rec.API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY; ' ||
253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||

Line 257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||

253: ' t_txn_line_rec.ERROR_CODE := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE; ' ||
254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||

Line 258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||

254: ' t_txn_line_rec.ERROR_EXPLANATION := CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION; ' ||
255: ' t_txn_line_rec.PROCESSING_STATUS := CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS; ' ||
256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||

Line 260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||

256: ' t_txn_line_rec.OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||

Line 261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||

257: ' IF CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.COUNT > 0 THEN ' ||
258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||

Line 262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||

258: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl.LAST ' ||
259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||

Line 263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||

259: ' LOOP ' ||
260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||

Line 264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||

260: ' t_txn_line_detail_tbl(i).config_inst_hdr_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_hdr_id; ' ||
261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||

Line 265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||

261: ' t_txn_line_detail_tbl(i).config_inst_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_rev_num; ' ||
262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||

Line 266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||

262: ' t_txn_line_detail_tbl(i).config_inst_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_item_id; ' ||
263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||

Line 267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||

263: ' t_txn_line_detail_tbl(i).source_transaction_flag:= CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).source_transaction_flag; ' ||
264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||

Line 268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||

264: ' t_txn_line_detail_tbl(i).instance_exists_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_exists_flag; ' ||
265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||

Line 269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||

265: ' t_txn_line_detail_tbl(i).quantity := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).quantity; ' ||
266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||

Line 270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||

266: ' t_txn_line_detail_tbl(i).unit_of_measure := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).unit_of_measure; ' ||
267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||

Line 271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||

267: ' t_txn_line_detail_tbl(i).location_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_id; ' ||
268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||

Line 272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||

268: ' t_txn_line_detail_tbl(i).location_type_code := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).location_type_code; ' ||
269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||

Line 273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||

269: ' t_txn_line_detail_tbl(i).inventory_item_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inventory_item_id; ' ||
270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||

Line 274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||

270: ' t_txn_line_detail_tbl(i).inv_organization_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).inv_organization_id; ' ||
271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||
278: ' END IF; ' ||

Line 275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||

271: ' t_txn_line_detail_tbl(i).mfg_serial_number_flag := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).mfg_serial_number_flag; ' ||
272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||
278: ' END IF; ' ||
279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||

Line 276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||

272: ' t_txn_line_detail_tbl(i).sub_type_id := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).sub_type_id; ' ||
273: ' t_txn_line_detail_tbl(i).instance_description := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).instance_description; ' ||
274: ' t_txn_line_detail_tbl(i).config_inst_baseline_rev_num := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).config_inst_baseline_rev_num; ' ||
275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||
278: ' END IF; ' ||
279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||
280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||

Line 279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||

275: ' t_txn_line_detail_tbl(i).active_end_date := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).active_end_date; ' ||
276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||
278: ' END IF; ' ||
279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||
280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||
281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||

Line 280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||

276: ' t_txn_line_detail_tbl(i).object_version_number := CZ_IB_TRANSACTIONS.m_txn_line_detail_tbl(i).object_version_number; ' ||
277: ' END LOOP; ' ||
278: ' END IF; ' ||
279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||
280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||
281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||

Line 282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||

278: ' END IF; ' ||
279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||
280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||
281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||

Line 283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||

279: ' IF CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.COUNT > 0 THEN ' ||
280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||
281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||

Line 284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||

280: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl.LAST ' ||
281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||

Line 285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||

281: ' LOOP ' ||
282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||

Line 286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||

282: ' t_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_ATTRIB_DETAIL_ID; ' ||
283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||

Line 287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||

283: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAIL_ID; ' ||
284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||

Line 288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||

284: ' t_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIB_SOURCE_TABLE; ' ||
285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||

Line 289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||

285: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_SOURCE_ID; ' ||
286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||

Line 290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||

286: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_VALUE; ' ||
287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||

Line 291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||

287: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_CODE; ' ||
288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||

Line 292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||

288: ' t_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ATTRIBUTE_LEVEL; ' ||
289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||
296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||

Line 293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||

289: ' t_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).API_CALLER_IDENTITY; ' ||
290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||
296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||
297: ' END LOOP; ' ||

Line 294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||

290: ' t_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PROCESS_FLAG; ' ||
291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||
296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||
297: ' END LOOP; ' ||
298: ' END IF; ' ||

Line 295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||

291: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_START_DATE; ' ||
292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||
296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||
297: ' END LOOP; ' ||
298: ' END IF; ' ||
299: ' csi_t_txn_details_grp.create_transaction_dtls ' ||

Line 296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||

292: ' t_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).ACTIVE_END_DATE; ' ||
293: ' t_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).PRESERVE_DETAIL_FLAG; ' ||
294: ' t_txn_ext_attrib_vals_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).CONTEXT; ' ||
295: ' t_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).TXN_LINE_DETAILS_INDEX; ' ||
296: ' t_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ext_attrib_vals_tbl(i).OBJECT_VERSION_NUMBER; ' ||
297: ' END LOOP; ' ||
298: ' END IF; ' ||
299: ' csi_t_txn_details_grp.create_transaction_dtls ' ||
300: ' ( ' ||

Line 313: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||

309: ' px_txn_ii_rltns_tbl => t_txn_ii_rltns_tbl, ' ||
310: ' px_txn_org_assgn_tbl => t_txn_org_assgn_tbl, ' ||
311: ' px_txn_ext_attrib_vals_tbl => t_txn_ext_attrib_vals_tbl, ' ||
312: ' px_txn_systems_tbl => t_txn_systems_tbl, ' ||
313: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||

Line 314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||

310: ' px_txn_org_assgn_tbl => t_txn_org_assgn_tbl, ' ||
311: ' px_txn_ext_attrib_vals_tbl => t_txn_ext_attrib_vals_tbl, ' ||
312: ' px_txn_systems_tbl => t_txn_systems_tbl, ' ||
313: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||

Line 315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||

311: ' px_txn_ext_attrib_vals_tbl => t_txn_ext_attrib_vals_tbl, ' ||
312: ' px_txn_systems_tbl => t_txn_systems_tbl, ' ||
313: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||

Line 317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||

313: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||

Line 318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||

314: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||

Line 319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||

315: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||

Line 320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||

316: ' ); ' ||
317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||

Line 321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||

317: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.TRANSACTION_LINE_ID := t_txn_line_rec.TRANSACTION_LINE_ID; ' ||
318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||

Line 322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||

318: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID := t_txn_line_rec.SOURCE_TRANSACTION_TYPE_ID; ' ||
319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||

Line 323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||

319: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_ID := t_txn_line_rec.SOURCE_TRANSACTION_ID; ' ||
320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||

Line 324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||

320: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TXN_HEADER_ID := t_txn_line_rec.SOURCE_TXN_HEADER_ID; ' ||
321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||

Line 325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||

321: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_TABLE := t_txn_line_rec.SOURCE_TRANSACTION_TABLE; ' ||
322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||

Line 326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||

322: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_HDR_ID := t_txn_line_rec.CONFIG_SESSION_HDR_ID; ' ||
323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||

Line 327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||

323: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_REV_NUM := t_txn_line_rec.CONFIG_SESSION_REV_NUM; ' ||
324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||
331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||

Line 328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||

324: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_SESSION_ITEM_ID := t_txn_line_rec.CONFIG_SESSION_ITEM_ID; ' ||
325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||
331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
332: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;

Line 329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||

325: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.CONFIG_VALID_STATUS := t_txn_line_rec.CONFIG_VALID_STATUS; ' ||
326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||
331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
332: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;
333:

Line 330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||

326: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.SOURCE_TRANSACTION_STATUS := t_txn_line_rec.SOURCE_TRANSACTION_STATUS; ' ||
327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||
331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
332: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;
333:
334: px_txn_line_rec:=m_txn_line_rec;

Line 331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||

327: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.API_CALLER_IDENTITY := t_txn_line_rec.API_CALLER_IDENTITY; ' ||
328: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_CODE := t_txn_line_rec.ERROR_CODE; ' ||
329: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.ERROR_EXPLANATION := t_txn_line_rec.ERROR_EXPLANATION; ' ||
330: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.PROCESSING_STATUS := t_txn_line_rec.PROCESSING_STATUS; ' ||
331: ' CZ_IB_TRANSACTIONS.m_txn_line_rec.OBJECT_VERSION_NUMBER := t_txn_line_rec.OBJECT_VERSION_NUMBER; ' ||
332: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;
333:
334: px_txn_line_rec:=m_txn_line_rec;
335: px_txn_line_detail_tbl:=m_txn_line_detail_tbl;

Line 341: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;

337:
338: m_txn_line_detail_tbl.DELETE;
339: m_txn_ext_attrib_vals_tbl.DELETE;
340:
341: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
342: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
343: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
344: EXCEPTION
345: WHEN OTHERS THEN

Line 342: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;

338: m_txn_line_detail_tbl.DELETE;
339: m_txn_ext_attrib_vals_tbl.DELETE;
340:
341: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
342: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
343: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
344: EXCEPTION
345: WHEN OTHERS THEN
346: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 343: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;

339: m_txn_ext_attrib_vals_tbl.DELETE;
340:
341: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
342: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
343: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
344: EXCEPTION
345: WHEN OTHERS THEN
346: x_return_status := FND_API.g_ret_sts_unexp_error;
347: x_msg_count := 1;

Line 348: x_msg_data := 'CZ_IB_TRANSACTIONS.create_transaction_dtls : '||SQLERRM;

344: EXCEPTION
345: WHEN OTHERS THEN
346: x_return_status := FND_API.g_ret_sts_unexp_error;
347: x_msg_count := 1;
348: x_msg_data := 'CZ_IB_TRANSACTIONS.create_transaction_dtls : '||SQLERRM;
349: LOG_REPORT(m_RUN_ID,x_msg_data);
350: END create_transaction_dtls;
351:
352:

Line 371: ' IF CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.COUNT>0 THEN ' ||

367: EXECUTE IMMEDIATE
368: ' DECLARE ' ||
369: ' t_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl; ' ||
370: ' BEGIN ' ||
371: ' IF CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||
373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||

Line 372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||

368: ' DECLARE ' ||
369: ' t_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl; ' ||
370: ' BEGIN ' ||
371: ' IF CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||
373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||

Line 374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||

370: ' BEGIN ' ||
371: ' IF CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||
373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||

Line 375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||

371: ' IF CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||
373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||

Line 376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||

372: ' FOR i IN CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.FIRST..CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl.LAST ' ||
373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||

Line 377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||

373: ' LOOP ' ||
374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||

Line 378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||

374: ' t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||

Line 379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||

375: ' t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||

Line 380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||

376: ' t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||

Line 381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||

377: ' t_txn_ii_rltns_tbl(i).SUBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||

Line 382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||

378: ' t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||

Line 383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||

379: ' t_txn_ii_rltns_tbl(i).SUBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||

Line 384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||

380: ' t_txn_ii_rltns_tbl(i).OBJECT_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||

Line 385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||

381: ' t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||

Line 386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||

382: ' t_txn_ii_rltns_tbl(i).OBJECT_TYPE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||

Line 387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||

383: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||

Line 388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||

384: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||

Line 389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||

385: ' t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||

Line 390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||

386: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||

Line 391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||

387: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||

Line 392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||

388: ' t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||

Line 393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||

389: ' t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||

Line 394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||

390: ' t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||
398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||

Line 395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||

391: ' t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||
398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
399: ' END LOOP; ' ||

Line 396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||

392: ' t_txn_ii_rltns_tbl(i).DISPLAY_ORDER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||
398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
399: ' END LOOP; ' ||
400: ' END IF; ' ||

Line 397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||

393: ' t_txn_ii_rltns_tbl(i).POSITION_REFERENCE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||
398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
399: ' END LOOP; ' ||
400: ' END IF; ' ||
401: ' csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls ' ||

Line 398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||

394: ' t_txn_ii_rltns_tbl(i).MANDATORY_FLAG := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
395: ' t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
396: ' t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
397: ' t_txn_ii_rltns_tbl(i).CONTEXT := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT; ' ||
398: ' t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
399: ' END LOOP; ' ||
400: ' END IF; ' ||
401: ' csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls ' ||
402: ' ( ' ||

Line 408: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||

404: ' p_commit => :2, ' ||
405: ' p_init_msg_list => :3, ' ||
406: ' p_validation_level => :4, ' ||
407: ' px_txn_ii_rltns_tbl => t_txn_ii_rltns_tbl, ' ||
408: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
409: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
410: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
411: ' ); ' ||
412: ' IF t_txn_ii_rltns_tbl.COUNT>0 THEN ' ||

Line 409: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||

405: ' p_init_msg_list => :3, ' ||
406: ' p_validation_level => :4, ' ||
407: ' px_txn_ii_rltns_tbl => t_txn_ii_rltns_tbl, ' ||
408: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
409: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
410: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
411: ' ); ' ||
412: ' IF t_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
413: ' FOR i IN t_txn_ii_rltns_tbl.FIRST..t_txn_ii_rltns_tbl.LAST ' ||

Line 410: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||

406: ' p_validation_level => :4, ' ||
407: ' px_txn_ii_rltns_tbl => t_txn_ii_rltns_tbl, ' ||
408: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
409: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
410: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data ' ||
411: ' ); ' ||
412: ' IF t_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
413: ' FOR i IN t_txn_ii_rltns_tbl.FIRST..t_txn_ii_rltns_tbl.LAST ' ||
414: ' LOOP ' ||

Line 415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||

411: ' ); ' ||
412: ' IF t_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
413: ' FOR i IN t_txn_ii_rltns_tbl.FIRST..t_txn_ii_rltns_tbl.LAST ' ||
414: ' LOOP ' ||
415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||

Line 416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||

412: ' IF t_txn_ii_rltns_tbl.COUNT>0 THEN ' ||
413: ' FOR i IN t_txn_ii_rltns_tbl.FIRST..t_txn_ii_rltns_tbl.LAST ' ||
414: ' LOOP ' ||
415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||

Line 417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||

413: ' FOR i IN t_txn_ii_rltns_tbl.FIRST..t_txn_ii_rltns_tbl.LAST ' ||
414: ' LOOP ' ||
415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||

Line 418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||

414: ' LOOP ' ||
415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||

Line 419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||

415: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).TXN_RELATIONSHIP_ID; ' ||
416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||

Line 420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||

416: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID := t_txn_ii_rltns_tbl(i).TRANSACTION_LINE_ID; ' ||
417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||

Line 421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||

417: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID := t_txn_ii_rltns_tbl(i).CSI_INST_RELATIONSHIP_ID; ' ||
418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||

Line 422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||

418: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_ID := t_txn_ii_rltns_tbl(i).SUBJECT_ID; ' ||
419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||

Line 423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||

419: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).SUBJECT_INDEX_FLAG; ' ||
420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||

Line 424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||

420: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUBJECT_TYPE := t_txn_ii_rltns_tbl(i).SUBJECT_TYPE; ' ||
421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||

Line 425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||

421: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_ID := t_txn_ii_rltns_tbl(i).OBJECT_ID; ' ||
422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||

Line 426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||

422: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG := t_txn_ii_rltns_tbl(i).OBJECT_INDEX_FLAG; ' ||
423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||

Line 427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||

423: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_TYPE := t_txn_ii_rltns_tbl(i).OBJECT_TYPE; ' ||
424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||

Line 428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||

424: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_HDR_ID; ' ||
425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||

Line 429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||

425: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_REV_NUM; ' ||
426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||

Line 430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||

426: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).SUB_CONFIG_INST_ITEM_ID; ' ||
427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||

Line 431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||

427: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_HDR_ID; ' ||
428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||

Line 432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||

428: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_REV_NUM; ' ||
429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||

Line 433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||

429: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID := t_txn_ii_rltns_tbl(i).OBJ_CONFIG_INST_ITEM_ID; ' ||
430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||

Line 434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||

430: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE := t_txn_ii_rltns_tbl(i).TARGET_COMMITMENT_DATE; ' ||
431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||

Line 435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||

431: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY := t_txn_ii_rltns_tbl(i).API_CALLER_IDENTITY; ' ||
432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||
439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||

Line 436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||

432: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE := t_txn_ii_rltns_tbl(i).RELATIONSHIP_TYPE_CODE; ' ||
433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||
439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
440: ' END LOOP; ' ||

Line 437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||

433: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).DISPLAY_ORDER := t_txn_ii_rltns_tbl(i).DISPLAY_ORDER; ' ||
434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||
439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
440: ' END LOOP; ' ||
441: ' END IF; ' ||

Line 438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||

434: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).POSITION_REFERENCE := t_txn_ii_rltns_tbl(i).POSITION_REFERENCE; ' ||
435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||
439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
440: ' END LOOP; ' ||
441: ' END IF; ' ||
442: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;

Line 439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||

435: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).MANDATORY_FLAG := t_txn_ii_rltns_tbl(i).MANDATORY_FLAG; ' ||
436: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_START_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_START_DATE; ' ||
437: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).ACTIVE_END_DATE := t_txn_ii_rltns_tbl(i).ACTIVE_END_DATE; ' ||
438: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).CONTEXT := t_txn_ii_rltns_tbl(i).CONTEXT; ' ||
439: ' CZ_IB_TRANSACTIONS.m_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER := t_txn_ii_rltns_tbl(i).OBJECT_VERSION_NUMBER; ' ||
440: ' END LOOP; ' ||
441: ' END IF; ' ||
442: ' END;' USING p_api_version,p_commit,p_init_msg_list,p_validation_level;
443:

Line 447: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;

443:
444: px_txn_ii_rltns_tbl:=m_txn_ii_rltns_tbl;
445: m_txn_ii_rltns_tbl.DELETE;
446:
447: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
448: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
449: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
450:
451: EXCEPTION

Line 448: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;

444: px_txn_ii_rltns_tbl:=m_txn_ii_rltns_tbl;
445: m_txn_ii_rltns_tbl.DELETE;
446:
447: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
448: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
449: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
450:
451: EXCEPTION
452: WHEN OTHERS THEN

Line 449: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;

445: m_txn_ii_rltns_tbl.DELETE;
446:
447: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
448: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
449: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 455: x_msg_data := 'CZ_IB_TRANSACTIONS.create_txn_ii_rltns_dtls : '||SQLERRM;

451: EXCEPTION
452: WHEN OTHERS THEN
453: x_return_status := FND_API.g_ret_sts_unexp_error;
454: x_msg_count := 1;
455: x_msg_data := 'CZ_IB_TRANSACTIONS.create_txn_ii_rltns_dtls : '||SQLERRM;
456: LOG_REPORT(m_RUN_ID,x_msg_data);
457: END create_txn_ii_rltns_dtls;
458:
459:

Line 480: ' IF CZ_IB_TRANSACTIONS.m_config_query_table.COUNT > 0 THEN ' ||

476: ' t_config_query_table CSI_CZ_INT.config_query_table; ' ||
477: ' t_config_pair_table CSI_CZ_INT.config_pair_table; ' ||
478: ' l_ndebug NUMBER := 0; ' ||
479: ' BEGIN ' ||
480: ' IF CZ_IB_TRANSACTIONS.m_config_query_table.COUNT > 0 THEN ' ||
481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||
482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||

Line 481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||

477: ' t_config_pair_table CSI_CZ_INT.config_pair_table; ' ||
478: ' l_ndebug NUMBER := 0; ' ||
479: ' BEGIN ' ||
480: ' IF CZ_IB_TRANSACTIONS.m_config_query_table.COUNT > 0 THEN ' ||
481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||
482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||
485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

Line 483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||

479: ' BEGIN ' ||
480: ' IF CZ_IB_TRANSACTIONS.m_config_query_table.COUNT > 0 THEN ' ||
481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||
482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||
485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
487: ' ''csi_cz_int.get_connected_configurations() : parameters p_config_query_table(''||TO_CHAR(i)|| ' ||

Line 484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||

480: ' IF CZ_IB_TRANSACTIONS.m_config_query_table.COUNT > 0 THEN ' ||
481: ' FOR i IN CZ_IB_TRANSACTIONS.m_config_query_table.FIRST..CZ_IB_TRANSACTIONS.m_config_query_table.LAST ' ||
482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||
485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
487: ' ''csi_cz_int.get_connected_configurations() : parameters p_config_query_table(''||TO_CHAR(i)|| ' ||
488: ' '').config_header_id = ''||TO_CHAR(t_config_query_table(i).config_header_id)|| ' ||

Line 486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

482: ' LOOP ' ||
483: ' t_config_query_table(i).config_header_id := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_header_id; ' ||
484: ' t_config_query_table(i).config_revision_number := CZ_IB_TRANSACTIONS.m_config_query_table(i).config_revision_number; ' ||
485: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
486: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
487: ' ''csi_cz_int.get_connected_configurations() : parameters p_config_query_table(''||TO_CHAR(i)|| ' ||
488: ' '').config_header_id = ''||TO_CHAR(t_config_query_table(i).config_header_id)|| ' ||
489: ' '' p_config_query_table(''||TO_CHAR(i)|| ' ||
490: ' '').config_revision_number = ''||TO_CHAR(t_config_query_table(i).config_revision_number)|| ' ||

Line 497: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

493: ' END IF; ' ||
494: ' END LOOP; ' ||
495: ' END IF; ' ||
496: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
497: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
498: ' ''csi_cz_int.get_connected_configurations() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
499: ' fnd_log.LEVEL_STATEMENT); ' ||
500: ' END IF; ' ||
501: ' csi_cz_int.get_connected_configurations ' ||

Line 506: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||

502: ' ( ' ||
503: ' p_config_query_table => t_config_query_table, ' ||
504: ' p_instance_level => :1, ' ||
505: ' x_config_pair_table => t_config_pair_table, ' ||
506: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
507: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
508: ' ); ' ||
509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

Line 507: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||

503: ' p_config_query_table => t_config_query_table, ' ||
504: ' p_instance_level => :1, ' ||
505: ' x_config_pair_table => t_config_pair_table, ' ||
506: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
507: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
508: ' ); ' ||
509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
511: ' ''csi_cz_int.get_connected_configurations() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||

Line 510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

506: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
507: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
508: ' ); ' ||
509: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
510: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
511: ' ''csi_cz_int.get_connected_configurations() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
512: ' fnd_log.LEVEL_STATEMENT); ' ||
513: ' END IF; ' ||
514: ' IF t_config_pair_table.COUNT > 0 THEN ' ||

Line 517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||

513: ' END IF; ' ||
514: ' IF t_config_pair_table.COUNT > 0 THEN ' ||
515: ' FOR i IN t_config_pair_table.FIRST..t_config_pair_table.LAST ' ||
516: ' LOOP ' ||
517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||
518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||

Line 518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||

514: ' IF t_config_pair_table.COUNT > 0 THEN ' ||
515: ' FOR i IN t_config_pair_table.FIRST..t_config_pair_table.LAST ' ||
516: ' LOOP ' ||
517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||
518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||

Line 519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||

515: ' FOR i IN t_config_pair_table.FIRST..t_config_pair_table.LAST ' ||
516: ' LOOP ' ||
517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||
518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||

Line 520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||

516: ' LOOP ' ||
517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||
518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||

Line 521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||

517: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_header_id := t_config_pair_table(i).subject_header_id; ' ||
518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||

Line 522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||

518: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_revision_number:= t_config_pair_table(i).subject_revision_number; ' ||
519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||

Line 523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||

519: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).subject_item_id := t_config_pair_table(i).subject_item_id; ' ||
520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||

Line 524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||

520: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_header_id := t_config_pair_table(i).object_header_id; ' ||
521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||

Line 525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||

521: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_revision_number := t_config_pair_table(i).object_revision_number; ' ||
522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||

Line 526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||

522: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).object_item_id := t_config_pair_table(i).object_item_id; ' ||
523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||

Line 527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||

523: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_header_id := t_config_pair_table(i).root_header_id; ' ||
524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||

Line 528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||

524: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_revision_number := t_config_pair_table(i).root_revision_number; ' ||
525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||

Line 529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||

525: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).root_item_id := t_config_pair_table(i).root_item_id; ' ||
526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

Line 530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||

526: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_APPLICATION_ID := t_config_pair_table(i).SOURCE_APPLICATION_ID; ' ||
527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

Line 531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||

527: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_HEADER_REF := t_config_pair_table(i).SOURCE_TXN_HEADER_REF; ' ||
528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
535: ' ''Out array for get_connected_configurations() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||

Line 532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||

528: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF1 := t_config_pair_table(i).SOURCE_TXN_LINE_REF1; ' ||
529: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF2 := t_config_pair_table(i).SOURCE_TXN_LINE_REF2; ' ||
530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
535: ' ''Out array for get_connected_configurations() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
536: ' fnd_log.LEVEL_STATEMENT); ' ||

Line 534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||

530: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).SOURCE_TXN_LINE_REF3 := t_config_pair_table(i).SOURCE_TXN_LINE_REF3; ' ||
531: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_ID := t_config_pair_table(i).LOCK_ID; ' ||
532: ' CZ_IB_TRANSACTIONS.m_config_pair_table(i).LOCK_STATUS := t_config_pair_table(i).LOCK_STATUS; ' ||
533: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
534: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_connected_configurations'', l_ndebug, ' ||
535: ' ''Out array for get_connected_configurations() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
536: ' fnd_log.LEVEL_STATEMENT); ' ||
537: ' END IF; ' ||
538: ' END LOOP; ' ||

Line 545: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;

541:
542: x_config_pair_table := m_config_pair_table;
543: m_config_pair_table.DELETE;
544:
545: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
546: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
547:
548: EXCEPTION
549: WHEN OTHERS THEN

Line 546: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;

542: x_config_pair_table := m_config_pair_table;
543: m_config_pair_table.DELETE;
544:
545: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
546: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 551: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Connected_Configurations : '||SQLERRM;

547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: x_return_status := FND_API.g_ret_sts_unexp_error;
551: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Connected_Configurations : '||SQLERRM;
552:
553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,
555: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),

Line 554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,

550: x_return_status := FND_API.g_ret_sts_unexp_error;
551: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Connected_Configurations : '||SQLERRM;
552:
553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,
555: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
556: fnd_log.LEVEL_ERROR);
557: END IF;
558:

Line 578: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,

574:
575: BEGIN
576:
577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,
579: 'csi_cz_int.get_configuration_revision() parameters : p_config_header_id='||TO_CHAR(p_config_header_id)||
580: ' p_target_commitment_date='||TO_CHAR(p_target_commitment_date,'DD-MM-YYYY HH24-MI-SS')||
581: ' px_instance_level='||px_instance_level||
582: ' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),

Line 593: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

589: ' l_config_rec CSI_CZ_INT.config_rec; ' ||
590: ' l_ndebug NUMBER := 1; ' ||
591: ' BEGIN ' ||
592: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
593: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
594: ' ''csi_cz_int.get_configuration_revision() will be called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
595: ' fnd_log.LEVEL_STATEMENT); ' ||
596: ' END IF; ' ||
597: ' csi_cz_int.get_configuration_revision ' ||

Line 603: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||

599: ' p_config_header_id => :1, ' ||
600: ' p_target_commitment_date => :2, ' ||
601: ' px_instance_level => v_instance_level, ' ||
602: ' x_install_config_rec => l_config_rec, ' ||
603: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
604: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
605: ' ); ' ||
606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

Line 604: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||

600: ' p_target_commitment_date => :2, ' ||
601: ' px_instance_level => v_instance_level, ' ||
602: ' x_install_config_rec => l_config_rec, ' ||
603: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
604: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
605: ' ); ' ||
606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||

Line 607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

603: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
604: ' x_return_message => CZ_IB_TRANSACTIONS.m_return_message ' ||
605: ' ); ' ||
606: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||

Line 611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||

607: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||

Line 612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||

608: ' ''csi_cz_int.get_configuration_revision() has been called : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||

Line 613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||

609: ' fnd_log.LEVEL_STATEMENT); ' ||
610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||

Line 614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||

610: ' END IF; ' ||
611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||

Line 615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||

611: ' CZ_IB_TRANSACTIONS.m_config_rec.source_application_id := l_config_rec.source_application_id; ' ||
612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||

Line 616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||

612: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_header_ref := l_config_rec.source_txn_header_ref; ' ||
613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||

Line 617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||

613: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref1 := l_config_rec.source_txn_line_ref1; ' ||
614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||

Line 618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||

614: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref2 := l_config_rec.source_txn_line_ref2; ' ||
615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

Line 619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||

615: ' CZ_IB_TRANSACTIONS.m_config_rec.source_txn_line_ref3 := l_config_rec.source_txn_line_ref3; ' ||
616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

Line 620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||

616: ' CZ_IB_TRANSACTIONS.m_config_rec.instance_id := l_config_rec.instance_id; ' ||
617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
624: ' ''Out array for get_configuration_revision() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||

Line 621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||

617: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_id := l_config_rec.lock_id; ' ||
618: ' CZ_IB_TRANSACTIONS.m_config_rec.lock_status := l_config_rec.lock_status; ' ||
619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
624: ' ''Out array for get_configuration_revision() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
625: ' fnd_log.LEVEL_STATEMENT); ' ||

Line 623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||

619: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id; ' ||
620: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id; ' ||
621: ' CZ_IB_TRANSACTIONS.m_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num; ' ||
622: ' IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
623: ' cz_utils.log_report(''CZ_IB_TRANSACTIONS'', ''get_configuration_revision'', l_ndebug, ' ||
624: ' ''Out array for get_configuration_revision() has been populated : current time : ''||TO_CHAR(SYSDATE,''DD-MM-YYYY HH24-MI-SS''), ' ||
625: ' fnd_log.LEVEL_STATEMENT); ' ||
626: ' END IF; ' ||
627: ' END;' USING p_config_header_id,p_target_commitment_date;

Line 629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;

625: ' fnd_log.LEVEL_STATEMENT); ' ||
626: ' END IF; ' ||
627: ' END;' USING p_config_header_id,p_target_commitment_date;
628:
629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;
630: x_config_rec := CZ_IB_TRANSACTIONS.m_config_rec;
631: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
633:

Line 630: x_config_rec := CZ_IB_TRANSACTIONS.m_config_rec;

626: ' END IF; ' ||
627: ' END;' USING p_config_header_id,p_target_commitment_date;
628:
629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;
630: x_config_rec := CZ_IB_TRANSACTIONS.m_config_rec;
631: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
633:
634: EXCEPTION

Line 631: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;

627: ' END;' USING p_config_header_id,p_target_commitment_date;
628:
629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;
630: x_config_rec := CZ_IB_TRANSACTIONS.m_config_rec;
631: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
633:
634: EXCEPTION
635: WHEN OTHERS THEN

Line 632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;

628:
629: x_config_rev_number := CZ_IB_TRANSACTIONS.m_config_rev_number;
630: x_config_rec := CZ_IB_TRANSACTIONS.m_config_rec;
631: x_return_status := CZ_IB_TRANSACTIONS.m_return_status;
632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 637: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Configuration_Revision : '||SQLERRM;

633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: x_return_status := FND_API.g_ret_sts_unexp_error;
637: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Configuration_Revision : '||SQLERRM;
638: LOG_REPORT(m_RUN_ID,x_return_message);
639:
640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,

Line 641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,

637: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Configuration_Revision : '||SQLERRM;
638: LOG_REPORT(m_RUN_ID,x_return_message);
639:
640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_configuration_revision', l_ndebug,
642: 'Fatal error : '||SQLERRM||' : current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24-MI-SS'),
643: fnd_log.LEVEL_ERROR);
644: END IF;
645: END get_configuration_revision;

Line 1958: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||

1954: ' p_org_assignments_tbl => v_org_assignments_tbl, ' ||
1955: ' p_asset_assignment_tbl => v_asset_assignment_tbl, ' ||
1956: ' p_txn_rec => v_txn_rec, ' ||
1957: ' x_instance_id_lst => x_instance_id_lst, ' ||
1958: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
1959: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||
1961: ' END LOOP; ' ||
1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;

Line 1959: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||

1955: ' p_asset_assignment_tbl => v_asset_assignment_tbl, ' ||
1956: ' p_txn_rec => v_txn_rec, ' ||
1957: ' x_instance_id_lst => x_instance_id_lst, ' ||
1958: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
1959: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||
1961: ' END LOOP; ' ||
1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;
1963:

Line 1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||

1956: ' p_txn_rec => v_txn_rec, ' ||
1957: ' x_instance_id_lst => x_instance_id_lst, ' ||
1958: ' x_return_status => CZ_IB_TRANSACTIONS.m_return_status, ' ||
1959: ' x_msg_count => CZ_IB_TRANSACTIONS.m_msg_count, ' ||
1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||
1961: ' END LOOP; ' ||
1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;
1963:
1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN

1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||
1961: ' END LOOP; ' ||
1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;
1963:
1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN
1965: x_run_id:=m_RUN_ID;
1966: LOG_REPORT(m_RUN_ID,'csi_item_instance_pub.update_item_instance() failed : '||CZ_IB_TRANSACTIONS.m_msg_data,CZ_IB_TRANSACTIONS.m_msg_count);
1967: END IF;
1968:

Line 1966: LOG_REPORT(m_RUN_ID,'csi_item_instance_pub.update_item_instance() failed : '||CZ_IB_TRANSACTIONS.m_msg_data,CZ_IB_TRANSACTIONS.m_msg_count);

1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;
1963:
1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN
1965: x_run_id:=m_RUN_ID;
1966: LOG_REPORT(m_RUN_ID,'csi_item_instance_pub.update_item_instance() failed : '||CZ_IB_TRANSACTIONS.m_msg_data,CZ_IB_TRANSACTIONS.m_msg_count);
1967: END IF;
1968:
1969: END update_CSI_Item_Inst_Status;
1970:

Line 2042: ' CZ_IB_TRANSACTIONS.m_csi_rev_nbr_tbl(i.config_inst_item_id) := i.config_inst_rev_num; ' ||

2038: ' FOR i IN(SELECT config_inst_item_id,config_inst_rev_num FROM CSI_ITEM_INSTANCES ' ||
2039: ' WHERE config_inst_hdr_id=:1 ' ||
2040: ' ORDER BY config_inst_item_id,config_inst_rev_num) ' ||
2041: ' LOOP ' ||
2042: ' CZ_IB_TRANSACTIONS.m_csi_rev_nbr_tbl(i.config_inst_item_id) := i.config_inst_rev_num; ' ||
2043: ' END LOOP; ' ||
2044: ' END;'
2045: USING p_config_inst_hdr_id;
2046:

Line 2101: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||

2097: 'BEGIN ' ||
2098: ' SELECT ' ||
2099: ' a.attribute_category,a.attribute_code,b.attribute_value ' ||
2100: ' BULK COLLECT INTO ' ||
2101: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||
2102: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||
2103: ' FROM CSI_I_EXTENDED_ATTRIBS a, CSI_IEA_VALUES b, CSI_ITEM_INSTANCES c ' ||
2104: ' WHERE a.attribute_id = b.attribute_id AND ' ||
2105: ' b.instance_id = c.instance_id AND ' ||

Line 2102: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||

2098: ' SELECT ' ||
2099: ' a.attribute_category,a.attribute_code,b.attribute_value ' ||
2100: ' BULK COLLECT INTO ' ||
2101: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||
2102: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||
2103: ' FROM CSI_I_EXTENDED_ATTRIBS a, CSI_IEA_VALUES b, CSI_ITEM_INSTANCES c ' ||
2104: ' WHERE a.attribute_id = b.attribute_id AND ' ||
2105: ' b.instance_id = c.instance_id AND ' ||
2106: ' c.config_inst_hdr_id = :1 AND ' ||

Line 2178: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||

2174: 'BEGIN ' ||
2175: ' SELECT ' ||
2176: ' attribute_category, attribute_code, attribute_value ' ||
2177: ' BULK COLLECT INTO ' ||
2178: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||
2179: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||
2180: ' FROM CSI_T_EXTEND_ATTRIBS_V a ' ||
2181: ' WHERE txn_line_detail_id IN ' ||
2182: ' (SELECT txn_line_detail_id ' ||

Line 2179: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||

2175: ' SELECT ' ||
2176: ' attribute_category, attribute_code, attribute_value ' ||
2177: ' BULK COLLECT INTO ' ||
2178: ' CZ_IB_TRANSACTIONS.m_attribute_category_tbl,CZ_IB_TRANSACTIONS.m_attribute_name_tbl, ' ||
2179: ' CZ_IB_TRANSACTIONS.m_attribute_value_tbl ' ||
2180: ' FROM CSI_T_EXTEND_ATTRIBS_V a ' ||
2181: ' WHERE txn_line_detail_id IN ' ||
2182: ' (SELECT txn_line_detail_id ' ||
2183: ' FROM CSI_T_TXN_LINE_DETAILS ' ||

Line 2277: ' CZ_IB_TRANSACTIONS.m_config_item_tbl ' ||

2273: 'BEGIN ' ||
2274: 'SELECT ' ||
2275: ' config_item_id ' ||
2276: 'BULK COLLECT INTO ' ||
2277: ' CZ_IB_TRANSACTIONS.m_config_item_tbl ' ||
2278: 'FROM CZ_CONFIG_ITEMS_V ' ||
2279: 'WHERE instance_hdr_id=:1 AND instance_rev_nbr=:2 ' ||
2280: ' AND CZ_UTILS.conv_num(item_val) IS NOT NULL AND ib_trackable=''1''; ' ||
2281: 'END;'

Line 2877: END CZ_IB_TRANSACTIONS;

2873:
2874: END Test_Configuration_Revision;
2875:
2876:
2877: END CZ_IB_TRANSACTIONS;