APPS.CSD_RECEIVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 588: VALUES (rcv_transactions_interface_s.NEXTVAL, l_hdr_intf_id,

584: shipment_header_id,
585: shipment_line_id,
586: org_id -- MOAC change Bug#4245577
587: )
588: VALUES (rcv_transactions_interface_s.NEXTVAL, l_hdr_intf_id,
589: x_request_group_id, p_receive_rec.transaction_date,
590: p_receive_rec.quantity, p_receive_rec.unit_of_measure,
591: p_receive_rec.order_header_id,
592: p_receive_rec.doc_number,

Line 652: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM ='

648: IF (p_receive_rec.order_number IS NOT NULL)
649: THEN
650: /**********************Commented for 4277749
651: sql_str :=
652: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM ='
653: || p_receive_rec.order_number
654: || ' WHERE INTERFACE_TRANSACTION_ID='
655: || l_intf_txn_id;
656: *******************************/

Line 659: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM = :1'

655: || l_intf_txn_id;
656: *******************************/
657: -- bug fix for performance bug 4277749 begin
658: sql_str :=
659: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM = :1'
660: || ' WHERE INTERFACE_TRANSACTION_ID=:2' ;
661:
662: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
663: THEN