APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 376: FROM csi_t_transaction_lines

372: debug('Transaction Detail Found for the RMA line.');
373: BEGIN
374: SELECT processing_status
375: INTO l_processing_status
376: FROM csi_t_transaction_lines
377: WHERE source_transaction_table = l_src_txn_table
378: AND source_transaction_id = p_rma_line_id;
379:
380: IF l_processing_status = 'PROCESSED' THEN

Line 389: UPDATE csi_t_transaction_lines

385: fnd_msg_pub.add;
386: RAISE fnd_api.g_exc_error;
387: END IF;
388:
389: UPDATE csi_t_transaction_lines
390: SET processing_status = 'IN_PROCESS'
391: WHERE source_transaction_table = l_src_txn_table
392: AND source_transaction_id = p_rma_line_id;
393:

Line 437: FROM csi_t_transaction_lines

433: END IF;
434: /*
435: SELECT transaction_line_id
436: INTO l_g_txn_line_rec.transaction_line_id
437: FROM csi_t_transaction_lines
438: WHERE source_transaction_table = l_src_txn_table
439: AND source_transaction_id = p_rma_line_id;
440: */
441:

Line 547: UPDATE csi_t_transaction_lines

543: l_error_rec.error_text := l_error_message;
544: debug('Error :'||l_error_rec.error_text);
545: px_trx_error_rec := l_error_rec;
546:
547: UPDATE csi_t_transaction_lines
548: SET processing_status = 'ERROR'
549: WHERE source_transaction_id = p_rma_line_id
550: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
551:

Line 571: UPDATE csi_t_transaction_lines

567: l_error_rec.error_text := l_error_message;
568: debug('Error :'||l_error_rec.error_text);
569: px_trx_error_rec := l_error_rec;
570:
571: UPDATE csi_t_transaction_lines
572: SET processing_status = 'ERROR'
573: WHERE source_transaction_id = p_rma_line_id
574: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
575:

Line 1557: FROM csi_t_transaction_lines b

1553: processing_status = 'PROCESSED',
1554: csi_transaction_id = l_csi_trxn_rec.transaction_id
1555: WHERE a.processing_status = l_literal1
1556: AND a.transaction_line_id in (SELECT b.transaction_line_id
1557: FROM csi_t_transaction_lines b
1558: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug 4311676
1559: b.source_transaction_id = p_rma_line_rec.line_id
1560: AND b.source_transaction_table = l_literal2);
1561: Exception when others Then