DBA Data[Home] [Help]

APPS.RCV_PROCESSOR_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 37: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

33: l_lot_count NUMBER;
34: l_organization_id NUMBER;
35: l_lpn_id rcv_supply.lpn_id%TYPE;
36: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
37: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
38:
39: CURSOR lot_numbers(
40: l_interface_id NUMBER
41: ) IS

Line 459: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

455: l_transaction_id rcv_transactions.transaction_id%TYPE;
456: l_serial_count NUMBER;
457: l_lpn_id rcv_supply.lpn_id%TYPE;
458: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
459: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
460: l_item_id rcv_transactions_interface.item_id%TYPE;
461: BEGIN
462: IF (g_asn_debug = 'Y') THEN
463: asn_debug.put_line('p_interface_transaction_id ' || p_interface_transaction_id);

Line 819: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

815: /* l_sublot_num VARCHAR2(32); */
816: /*end , INVCONV*/
817: l_lpn_id rcv_supply.lpn_id%TYPE;
818: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
819: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
820:
821: CURSOR supply_quantity(
822: l_lot_num VARCHAR2,
823: /* INVCONV*/

Line 1421: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;

1417: l_update_shipment_supply VARCHAR2(1) := 'N';
1418: l_parent_trans_type rcv_transactions.transaction_type%TYPE;
1419: l_lpn_id rcv_supply.lpn_id%TYPE;
1420: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1421: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
1422: l_item_id rcv_transactions_interface.item_id%TYPE;
1423: BEGIN
1424: IF (g_asn_debug = 'Y') THEN
1425: asn_debug.put_line('Enter update_rcv_serials_supply ');