DBA Data[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 627: VALUES (rcv_transactions_interface_s.NEXTVAL, l_hdr_intf_id,

623: attribute13,
624: attribute14,
625: attribute15
626: )
627: VALUES (rcv_transactions_interface_s.NEXTVAL, l_hdr_intf_id,
628: x_request_group_id, p_receive_rec.transaction_date,
629: p_receive_rec.quantity, p_receive_rec.unit_of_measure,
630: p_receive_rec.order_header_id,
631: p_receive_rec.doc_number,

Line 708: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM ='

704: IF (p_receive_rec.order_number IS NOT NULL)
705: THEN
706: /**********************Commented for 4277749
707: sql_str :=
708: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM ='
709: || p_receive_rec.order_number
710: || ' WHERE INTERFACE_TRANSACTION_ID='
711: || l_intf_txn_id;
712: *******************************/

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

711: || l_intf_txn_id;
712: *******************************/
713: -- bug fix for performance bug 4277749 begin
714: sql_str :=
715: ' UPDATE RCV_TRANSACTIONS_INTERFACE SET OE_ORDER_NUM = :1'
716: || ' WHERE INTERFACE_TRANSACTION_ID=:2' ;
717:
718: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
719: THEN