APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 1475: Update CSI_T_TXN_LINE_DETAILS

1471: --
1472: -- Update any pending TLD for the same config keys (fetched from lock table)
1473: -- with the instance_id so that when regular fulfillment happens for this
1474: -- tangible item (DISCONNECT), only the order line_id will be updated in the item instance
1475: Update CSI_T_TXN_LINE_DETAILS
1476: Set changed_instance_id = l_p_instances_tbl(J).instance_id
1477: ,overriding_csi_txn_id = l_csi_trxn_rec.transaction_id
1478: Where config_inst_hdr_id = l_p_instances_tbl(J).config_inst_hdr_id
1479: and config_inst_item_id = l_p_instances_tbl(J).config_inst_item_id

Line 1550: UPDATE csi_t_txn_line_details a

1546: --Assign the literals.. bug 4311676
1547: l_literal1 := 'IN_PROCESS';
1548: l_literal2 := 'OE_ORDER_LINES_ALL';
1549:
1550: UPDATE csi_t_txn_line_details a
1551: SET error_code = NULL,
1552: error_explanation = NULL,
1553: processing_status = 'PROCESSED',
1554: csi_transaction_id = l_csi_trxn_rec.transaction_id