APPS.WMS_PARAMETER_PVT dependencies on RCV_SHIPMENT_LINES

Line 5371: CURSOR l_rcv_shipment_lines_curs IS

5367: FROM po_line_locations_all
5368: WHERE line_location_id = p_reference_id;
5369:
5370: --bug13949783
5371: CURSOR l_rcv_shipment_lines_curs IS
5372: SELECT po_header_id,
5373: po_line_id
5374: FROM rcv_shipment_lines
5375: WHERE shipment_line_id=p_reference_id;

Line 5374: FROM rcv_shipment_lines

5370: --bug13949783
5371: CURSOR l_rcv_shipment_lines_curs IS
5372: SELECT po_header_id,
5373: po_line_id
5374: FROM rcv_shipment_lines
5375: WHERE shipment_line_id=p_reference_id;
5376: --bug13949783
5377:
5378: CURSOR l_rcv_transactions_curs IS

Line 5413: OPEN l_rcv_shipment_lines_curs;

5409: FETCH l_po_line_locations_curs INTO l_po_header_id, l_po_line_id;
5410: CLOSE l_po_line_locations_curs;
5411: --bug13949783
5412: ELSIF (p_reference = 'SHIPMENT_LINE_ID') THEN
5413: OPEN l_rcv_shipment_lines_curs;
5414: FETCH l_rcv_shipment_lines_curs INTO l_po_header_id, l_po_line_id;
5415: CLOSE l_rcv_shipment_lines_curs;
5416: --bug13949783
5417: -- =========================================================

Line 5414: FETCH l_rcv_shipment_lines_curs INTO l_po_header_id, l_po_line_id;

5410: CLOSE l_po_line_locations_curs;
5411: --bug13949783
5412: ELSIF (p_reference = 'SHIPMENT_LINE_ID') THEN
5413: OPEN l_rcv_shipment_lines_curs;
5414: FETCH l_rcv_shipment_lines_curs INTO l_po_header_id, l_po_line_id;
5415: CLOSE l_rcv_shipment_lines_curs;
5416: --bug13949783
5417: -- =========================================================
5418: -- transaction_source_type_id =1 indicates that mmtt record

Line 5415: CLOSE l_rcv_shipment_lines_curs;

5411: --bug13949783
5412: ELSIF (p_reference = 'SHIPMENT_LINE_ID') THEN
5413: OPEN l_rcv_shipment_lines_curs;
5414: FETCH l_rcv_shipment_lines_curs INTO l_po_header_id, l_po_line_id;
5415: CLOSE l_rcv_shipment_lines_curs;
5416: --bug13949783
5417: -- =========================================================
5418: -- transaction_source_type_id =1 indicates that mmtt record
5419: -- has reference to PO. This case, p_reference_id is