APPS.GMI_SHIPPING_UTIL dependencies on RCV_TRANSACTIONS_INTERFACE

Line 2569: GMI_RESERVATION_UTIL.println('Inserting Detail ' || l_detail_rec.delivery_detail_id || ' into RCV_TRANSACTIONS_INTERFACE ');

2565: Open get_item_desc;
2566: Fetch get_item_desc INTO l_item_desc;
2567: Close get_item_desc;
2568:
2569: GMI_RESERVATION_UTIL.println('Inserting Detail ' || l_detail_rec.delivery_detail_id || ' into RCV_TRANSACTIONS_INTERFACE ');
2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;
2571: l_group_id := p_group_id;
2572:
2573: l_secondary_unit_of_measure := null;

Line 2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;

2566: Fetch get_item_desc INTO l_item_desc;
2567: Close get_item_desc;
2568:
2569: GMI_RESERVATION_UTIL.println('Inserting Detail ' || l_detail_rec.delivery_detail_id || ' into RCV_TRANSACTIONS_INTERFACE ');
2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;
2571: l_group_id := p_group_id;
2572:
2573: l_secondary_unit_of_measure := null;
2574:

Line 2602: -- PK Also changed values to these local variable for Insert into rcv_transactions_interface

2598: l_unit_of_measure := l_secondary_unit_of_measure;
2599:
2600: END IF;
2601: -- PK End Bug 3925583
2602: -- PK Also changed values to these local variable for Insert into rcv_transactions_interface
2603:
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);

Line 2664: INSERT INTO RCV_TRANSACTIONS_INTERFACE

2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2661:
2662: /* Bug # 3363725 , punkumar , modified insert sql to insert delivery_detail_id in comments column */
2663:
2664: INSERT INTO RCV_TRANSACTIONS_INTERFACE
2665: (
2666: INTERFACE_TRANSACTION_ID,
2667: GROUP_ID,
2668: INTERFACE_SOURCE_CODE,

Line 2793: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');

2789: );
2790: --decode(l_trx_action_id,3,l_transfer_organization,l_detail_rec.organization_id), /* from_organization_id */
2791: --decode(l_trx_action_id,3,l_detail_rec.organization_id,l_transfer_organization), /* to_organization_id */
2792: GMI_reservation_Util.PrintLn(
2793: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');
2794: End if;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: GMI_reservation_Util.PrintLn(

Line 2798: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');

2794: End if;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: GMI_reservation_Util.PrintLn(
2798: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');
2799:
2800: END create_rcv_transaction;
2801:
2802: /* this procedure process_OPM_orders is created for internal orders only *

Line 2832: -- side is not inserted again in rcv_transactions_interface.

2828: st.stop_location_id = dl.initial_pickup_location_id AND
2829: dg.delivery_id = dl.delivery_id ;
2830:
2831: -- Bug 3764091 Added NOT EXISTS to the cursor below so that wdd which is already synchronized to PO
2832: -- side is not inserted again in rcv_transactions_interface.
2833: CURSOR c_detail_in_delivery is
2834: SELECT dd.delivery_detail_id, dd.source_line_id
2835: FROM wsh_delivery_details dd, wsh_delivery_assignments da
2836: WHERE dd.delivery_detail_id = da.delivery_detail_id

Line 2935: -- internal orders, insert into rcv_transactions_interface

2931: oe_debug_pub.add('Found Trip Stop '|| p_stop_id);
2932: CLOSE c_trip_stop;
2933:
2934: GMI_RESERVATION_UTIL.Println ('found internal order line in this delivery ' || l_delivery_id);
2935: -- internal orders, insert into rcv_transactions_interface
2936: Oe_Debug_Pub.Add('This line is part of an internal order');
2937: GMI_SHIPPING_UTIL.create_rcv_transaction
2938: ( p_shipping_line => l_detail_rec
2939: , p_trip_stop_rec => l_trip_stop_rec