APPS.CSD_RECEIVE_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

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

528: l_source_document_code := 'RMA';
529: l_receipt_source_Code := 'CUSTOMER';
530: end if;
531: -- bug#7509332,12.1 FP, subhat.
532: -- Locator information is not passed to rcv_transactions_interface.
533: -- currently we insert the locator_id into location_id column. Where as locator_id should be
534: -- inserted into locator_id of rcv_transactions_interface.
535: -- the column descriptions from eTRM.
536: -- LOCATOR_ID NUMBER Destination locator unique identifier

Line 534: -- inserted into locator_id of rcv_transactions_interface.

530: end if;
531: -- bug#7509332,12.1 FP, subhat.
532: -- Locator information is not passed to rcv_transactions_interface.
533: -- currently we insert the locator_id into location_id column. Where as locator_id should be
534: -- inserted into locator_id of rcv_transactions_interface.
535: -- the column descriptions from eTRM.
536: -- LOCATOR_ID NUMBER Destination locator unique identifier
537: -- LOCATION_ID NUMBER Receiving location unique identifier
538:

Line 539: INSERT INTO rcv_transactions_interface

535: -- the column descriptions from eTRM.
536: -- LOCATOR_ID NUMBER Destination locator unique identifier
537: -- LOCATION_ID NUMBER Receiving location unique identifier
538:
539: INSERT INTO rcv_transactions_interface
540: (interface_transaction_id, header_interface_id,
541: GROUP_ID, transaction_date,
542: quantity, unit_of_measure,
543: oe_order_header_id,

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

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

1369: END rcv_req_online;
1370:
1371: /*-----------------------------------------------------------------------------------------------------------*/
1372: /* procedure name: DELETE_INTF_TBLS */
1373: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1374: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1375: /* Called from : receive_item api */
1376: /* Input Parm : */
1377: /* p_request_group_id NUMBER Required */

Line 1403: FROM RCV_TRANSACTIONS_INTERFACE

1399: WHERE GROUP_ID = p_group_id;
1400: --Cursor to get the transactions interface records.
1401: CURSOR cur_transactions(p_group_Id NUMBER) is
1402: SELECT INTERFACE_TRANSACTION_ID
1403: FROM RCV_TRANSACTIONS_INTERFACE
1404: WHERE GROUP_ID = p_group_id;
1405: BEGIN
1406:
1407: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 1501: DELETE FROM rcv_transactions_interface

1497: );
1498: END IF;
1499:
1500: BEGIN
1501: DELETE FROM rcv_transactions_interface
1502: WHERE GROUP_ID = p_request_group_id;
1503: EXCEPTION
1504: WHEN NO_DATA_FOUND
1505: THEN

Line 1577: FROM rcv_transactions_interface

1573: END IF;
1574:
1575: SELECT COUNT (1)
1576: INTO l_rec_count
1577: FROM rcv_transactions_interface
1578: WHERE GROUP_ID = p_group_id;
1579:
1580: IF (l_rec_count = 0)
1581: THEN