APPS.CSD_RECEIVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 555: -- Locator information is not passed to rcv_transactions_interface.

551: l_source_document_code := 'RMA';
552: l_receipt_source_Code := 'CUSTOMER';
553: end if;
554: -- bug#7509332,12.1 FP, subhat.
555: -- Locator information is not passed to rcv_transactions_interface.
556: -- currently we insert the locator_id into location_id column. Where as locator_id should be
557: -- inserted into locator_id of rcv_transactions_interface.
558: -- the column descriptions from eTRM.
559: -- LOCATOR_ID NUMBER Destination locator unique identifier

Line 557: -- inserted into locator_id of rcv_transactions_interface.

553: end if;
554: -- bug#7509332,12.1 FP, subhat.
555: -- Locator information is not passed to rcv_transactions_interface.
556: -- currently we insert the locator_id into location_id column. Where as locator_id should be
557: -- inserted into locator_id of rcv_transactions_interface.
558: -- the column descriptions from eTRM.
559: -- LOCATOR_ID NUMBER Destination locator unique identifier
560: -- LOCATION_ID NUMBER Receiving location unique identifier
561:

Line 562: INSERT INTO rcv_transactions_interface

558: -- the column descriptions from eTRM.
559: -- LOCATOR_ID NUMBER Destination locator unique identifier
560: -- LOCATION_ID NUMBER Receiving location unique identifier
561:
562: INSERT INTO rcv_transactions_interface
563: (interface_transaction_id, header_interface_id,
564: GROUP_ID, transaction_date,
565: quantity, unit_of_measure,
566: oe_order_header_id,

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

Line 1460: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/

1456: END rcv_req_online;
1457:
1458: /*-----------------------------------------------------------------------------------------------------------*/
1459: /* procedure name: DELETE_INTF_TBLS */
1460: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1461: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1462: /* Called from : receive_item api */
1463: /* Input Parm : */
1464: /* p_request_group_id NUMBER Required */

Line 1490: FROM RCV_TRANSACTIONS_INTERFACE

1486: WHERE GROUP_ID = p_group_id;
1487: --Cursor to get the transactions interface records.
1488: CURSOR cur_transactions(p_group_Id NUMBER) is
1489: SELECT INTERFACE_TRANSACTION_ID
1490: FROM RCV_TRANSACTIONS_INTERFACE
1491: WHERE GROUP_ID = p_group_id;
1492: BEGIN
1493:
1494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 1588: DELETE FROM rcv_transactions_interface

1584: );
1585: END IF;
1586:
1587: BEGIN
1588: DELETE FROM rcv_transactions_interface
1589: WHERE GROUP_ID = p_request_group_id;
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND
1592: THEN

Line 1664: FROM rcv_transactions_interface

1660: END IF;
1661:
1662: SELECT COUNT (1)
1663: INTO l_rec_count
1664: FROM rcv_transactions_interface
1665: WHERE GROUP_ID = p_group_id;
1666:
1667: IF (l_rec_count = 0)
1668: THEN