APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 1447: Update CSI_T_TXN_LINE_DETAILS

1443: --
1444: -- Update any pending TLD for the same config keys (fetched from lock table)
1445: -- with the instance_id so that when regular fulfillment happens for this
1446: -- tangible item (DISCONNECT), only the order line_id will be updated in the item instance
1447: Update CSI_T_TXN_LINE_DETAILS
1448: Set changed_instance_id = l_p_instances_tbl(J).instance_id
1449: ,overriding_csi_txn_id = l_csi_trxn_rec.transaction_id
1450: Where config_inst_hdr_id = l_p_instances_tbl(J).config_inst_hdr_id
1451: and config_inst_item_id = l_p_instances_tbl(J).config_inst_item_id

Line 1522: UPDATE csi_t_txn_line_details a

1518: --Assign the literals.. bug 4311676
1519: l_literal1 := 'IN_PROCESS';
1520: l_literal2 := 'OE_ORDER_LINES_ALL';
1521:
1522: UPDATE csi_t_txn_line_details a
1523: SET error_code = NULL,
1524: error_explanation = NULL,
1525: processing_status = 'PROCESSED',
1526: csi_transaction_id = l_csi_trxn_rec.transaction_id