APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 540: FROM csi_t_transaction_lines

536: BEGIN
537:
538: SELECT processing_status
539: INTO l_processing_status
540: FROM csi_t_transaction_lines
541: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
542: AND source_transaction_id = p_parent_line_id;
543:
544: EXCEPTION

Line 7136: FROM csi_t_transaction_lines

7132:
7133: BEGIN
7134: SELECT transaction_line_id
7135: INTO l_transaction_line_id
7136: FROM csi_t_transaction_lines
7137: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7138: AND source_transaction_id = p_order_line_rec.line_id;
7139: EXCEPTION
7140: WHEN no_data_found THEN

Line 7144: FROM csi_t_transaction_lines

7140: WHEN no_data_found THEN
7141: BEGIN
7142: SELECT transaction_line_id
7143: INTO l_transaction_line_id
7144: FROM csi_t_transaction_lines
7145: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7146: AND source_transaction_id = p_order_line_rec.top_model_line_id;
7147:
7148: SELECT ordered_quantity

Line 8114: UPDATE csi_t_transaction_lines

8110: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8111: RAISE fnd_api.g_exc_error;
8112: END IF;
8113:
8114: UPDATE csi_t_transaction_lines
8115: SET processing_status = 'PROCESSED'
8116: WHERE transaction_line_id = l_p_tl_rec.transaction_line_id;
8117:
8118: EXCEPTION

Line 8590: FROM CSI_T_TRANSACTION_LINES ctl,

8586: l_ul_instance_rec.instance_id := NULL;
8587: Begin
8588: SELECT changed_instance_id,ctl.transaction_line_id
8589: INTO l_ul_instance_rec.instance_id,l_ul_txn_line_id
8590: FROM CSI_T_TRANSACTION_LINES ctl,
8591: CSI_T_TXN_LINE_DETAILS ctld
8592: WHERE ctl.source_transaction_table = 'CONFIGURATOR'
8593: AND ctl.config_session_hdr_id = l_om_session_key.session_hdr_id
8594: AND ctl.config_session_rev_num = l_om_session_key.session_rev_num

Line 9035: FROM csi_t_transaction_lines

9031: IF l_order_line_rec.top_model_line_id is not null THEN
9032: BEGIN
9033: SELECT 'Y'
9034: INTO l_cascade_eligible
9035: FROM csi_t_transaction_lines
9036: WHERE source_transaction_table = l_src_txn_table
9037: AND source_transaction_id = l_order_line_rec.top_model_line_id;
9038: EXCEPTION
9039: WHEN others THEN

Line 9101: FROM csi_t_transaction_lines

9097: SELECT processing_status ,
9098: transaction_line_id
9099: INTO l_processing_status,
9100: l_transaction_line_id
9101: FROM csi_t_transaction_lines
9102: WHERE source_transaction_table = l_src_txn_table
9103: AND source_transaction_id = p_order_line_id;
9104:
9105: l_default_info_rec.transaction_line_id := l_transaction_line_id;

Line 9116: UPDATE csi_t_transaction_lines

9112: fnd_msg_pub.add;
9113: RAISE fnd_api.g_exc_error;
9114: END IF;
9115:
9116: UPDATE csi_t_transaction_lines
9117: SET processing_status = 'IN_PROCESS'
9118: WHERE transaction_line_id = l_transaction_line_id;
9119:
9120: END;

Line 9215: UPDATE csi_t_transaction_lines

9211: END IF;
9212:
9213: l_p_order_line_rec.trx_line_id := l_txn_line_rec.transaction_line_id;
9214:
9215: UPDATE csi_t_transaction_lines
9216: SET processing_status = 'IN_PROCESS'
9217: WHERE transaction_line_id = l_txn_line_rec.transaction_line_id;
9218:
9219: /* transaction details found case */

Line 9403: UPDATE csi_t_transaction_lines

9399: l_error_rec.error_text := l_error_message;
9400: debug('Error(E) :'||l_error_message);
9401: px_trx_error_rec := l_error_rec;
9402:
9403: UPDATE csi_t_transaction_lines
9404: SET processing_status = 'ERROR'
9405: WHERE source_transaction_id = p_order_line_id
9406: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
9407:

Line 9426: UPDATE csi_t_transaction_lines

9422: l_error_rec.error_text := l_error_message;
9423: debug('Error(O) :'||l_error_message);
9424: px_trx_error_rec := l_error_rec;
9425:
9426: UPDATE csi_t_transaction_lines
9427: SET processing_status = 'ERROR'
9428: WHERE source_transaction_id = p_order_line_id
9429: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
9430:

Line 9514: FROM csi_t_transaction_lines

9510: BEGIN
9511:
9512: SELECT transaction_line_id
9513: INTO l_trx_line_id
9514: FROM csi_t_transaction_lines
9515: WHERE source_transaction_id = l_c_tl_rec.source_transaction_id
9516: AND source_transaction_table = l_c_tl_rec.source_transaction_table
9517: AND source_transaction_type_id = l_c_tl_rec.source_transaction_type_id;
9518:

Line 9530: csi_t_transaction_lines_pkg.insert_row(

9526: BEGIN
9527:
9528: debug('Transaction Detail-Hdr NOT found. So, creating one.');
9529:
9530: csi_t_transaction_lines_pkg.insert_row(
9531: px_transaction_line_id => l_c_tl_rec.transaction_line_id,
9532: p_source_transaction_type_id => l_c_tl_rec.source_transaction_type_id,
9533: p_source_transaction_table => l_c_tl_rec.source_transaction_table,
9534: