APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 580: FROM csi_t_transaction_lines

576: BEGIN
577:
578: SELECT processing_status
579: INTO l_processing_status
580: FROM csi_t_transaction_lines
581: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
582: AND source_transaction_id = p_parent_line_id;
583:
584: EXCEPTION

Line 7933: FROM csi_t_transaction_lines

7929:
7930: BEGIN
7931: SELECT transaction_line_id
7932: INTO l_transaction_line_id
7933: FROM csi_t_transaction_lines
7934: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7935: AND source_transaction_id = p_order_line_rec.line_id;
7936: EXCEPTION
7937: WHEN no_data_found THEN

Line 7941: FROM csi_t_transaction_lines

7937: WHEN no_data_found THEN
7938: BEGIN
7939: SELECT transaction_line_id
7940: INTO l_transaction_line_id
7941: FROM csi_t_transaction_lines
7942: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
7943: AND source_transaction_id = p_order_line_rec.top_model_line_id;
7944:
7945: SELECT ordered_quantity

Line 8964: UPDATE csi_t_transaction_lines

8960: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8961: RAISE fnd_api.g_exc_error;
8962: END IF;
8963:
8964: UPDATE csi_t_transaction_lines
8965: SET processing_status = 'PROCESSED'
8966: WHERE transaction_line_id = l_p_tl_rec.transaction_line_id;
8967:
8968: EXCEPTION

Line 9545: FROM CSI_T_TRANSACTION_LINES ctl,

9541: l_ul_instance_rec.instance_id := NULL;
9542: Begin
9543: SELECT changed_instance_id,ctl.transaction_line_id
9544: INTO l_ul_instance_rec.instance_id,l_ul_txn_line_id
9545: FROM CSI_T_TRANSACTION_LINES ctl,
9546: CSI_T_TXN_LINE_DETAILS ctld
9547: WHERE ctl.source_transaction_table = 'CONFIGURATOR'
9548: AND ctl.config_session_hdr_id = l_om_session_key.session_hdr_id
9549: AND ctl.config_session_rev_num = l_om_session_key.session_rev_num

Line 10045: FROM csi_t_transaction_lines

10041: IF l_order_line_rec.top_model_line_id is not null THEN
10042: BEGIN
10043: SELECT 'Y'
10044: INTO l_cascade_eligible
10045: FROM csi_t_transaction_lines
10046: WHERE source_transaction_table = l_src_txn_table
10047: AND source_transaction_id = l_order_line_rec.top_model_line_id;
10048: EXCEPTION
10049: WHEN others THEN

Line 10111: FROM csi_t_transaction_lines

10107: SELECT processing_status ,
10108: transaction_line_id
10109: INTO l_processing_status,
10110: l_transaction_line_id
10111: FROM csi_t_transaction_lines
10112: WHERE source_transaction_table = l_src_txn_table
10113: AND source_transaction_id = p_order_line_id;
10114:
10115: l_default_info_rec.transaction_line_id := l_transaction_line_id;

Line 10126: UPDATE csi_t_transaction_lines

10122: fnd_msg_pub.add;
10123: RAISE fnd_api.g_exc_error;
10124: END IF;
10125:
10126: UPDATE csi_t_transaction_lines
10127: SET processing_status = 'IN_PROCESS'
10128: WHERE transaction_line_id = l_transaction_line_id;
10129:
10130: END;

Line 10225: UPDATE csi_t_transaction_lines

10221: END IF;
10222:
10223: l_p_order_line_rec.trx_line_id := l_txn_line_rec.transaction_line_id;
10224:
10225: UPDATE csi_t_transaction_lines
10226: SET processing_status = 'IN_PROCESS'
10227: WHERE transaction_line_id = l_txn_line_rec.transaction_line_id;
10228:
10229: /* transaction details found case */

Line 10419: UPDATE csi_t_transaction_lines

10415: l_error_rec.error_text := l_error_message;
10416: debug('Error(E) :'||l_error_message);
10417: px_trx_error_rec := l_error_rec;
10418:
10419: UPDATE csi_t_transaction_lines
10420: SET processing_status = 'ERROR'
10421: WHERE source_transaction_id = p_order_line_id
10422: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10423:

Line 10442: UPDATE csi_t_transaction_lines

10438: l_error_rec.error_text := l_error_message;
10439: debug('Error(O) :'||l_error_message);
10440: px_trx_error_rec := l_error_rec;
10441:
10442: UPDATE csi_t_transaction_lines
10443: SET processing_status = 'ERROR'
10444: WHERE source_transaction_id = p_order_line_id
10445: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
10446:

Line 10530: FROM csi_t_transaction_lines

10526: BEGIN
10527:
10528: SELECT transaction_line_id
10529: INTO l_trx_line_id
10530: FROM csi_t_transaction_lines
10531: WHERE source_transaction_id = l_c_tl_rec.source_transaction_id
10532: AND source_transaction_table = l_c_tl_rec.source_transaction_table
10533: AND source_transaction_type_id = l_c_tl_rec.source_transaction_type_id;
10534:

Line 10546: csi_t_transaction_lines_pkg.insert_row(

10542: BEGIN
10543:
10544: debug('Transaction Detail-Hdr NOT found. So, creating one.');
10545:
10546: csi_t_transaction_lines_pkg.insert_row(
10547: px_transaction_line_id => l_c_tl_rec.transaction_line_id,
10548: p_source_transaction_type_id => l_c_tl_rec.source_transaction_type_id,
10549: p_source_transaction_table => l_c_tl_rec.source_transaction_table,
10550: