The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
INTO g_rhi_row
FROM rcv_headers_interface
WHERE header_interface_id = p_header_interface_id;
PROCEDURE update_rhi_row(
p_rhi_row IN rcv_headers_interface%ROWTYPE
) IS
BEGIN
asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);
UPDATE rcv_headers_interface
SET ROW = p_rhi_row
WHERE header_interface_id = p_rhi_row.header_interface_id;
SELECT *
INTO g_rti_row
FROM rcv_transactions_interface
WHERE interface_transaction_id = p_interface_transaction_id;
PROCEDURE update_rti_row(
p_rti_row IN rcv_transactions_interface%ROWTYPE
) IS
BEGIN
asn_debug.put_line('Updating RTI INTERFACE_TRANSACTION_ID=' || p_rti_row.interface_transaction_id);
UPDATE rcv_transactions_interface
SET ROW = p_rti_row
WHERE interface_transaction_id = p_rti_row.interface_transaction_id
AND processing_status_code <> 'ERROR'; --BUG: 5598140
SELECT *
INTO g_rt_row
FROM rcv_transactions
WHERE transaction_id = p_transaction_id;
SELECT *
INTO g_rsh_row
FROM rcv_shipment_headers
WHERE shipment_num = p_shipment_num
AND ( vendor_site_id = NVL(p_vendor_site_id, vendor_site_id)
OR vendor_site_id IS NULL)
AND ( vendor_id = NVL(p_vendor_id, vendor_id)
OR vendor_id IS NULL)
AND ship_to_org_id = NVL(p_ship_to_org_id, ship_to_org_id)
AND shipped_date >= ADD_MONTHS(NVL(p_shipped_date, SYSDATE), -12)
AND receipt_source_code=p_receipt_source_code;
SELECT *
INTO g_rsh_row
FROM rcv_shipment_headers
WHERE shipment_header_id = p_shipment_header_id;
SELECT *
INTO g_rsl_row
FROM rcv_shipment_lines
WHERE line_num = p_line_num
AND shipment_header_id = p_shipment_header_id;
SELECT *
INTO g_rsl_row
FROM rcv_shipment_lines
WHERE shipment_line_id = p_shipment_line_id;
PROCEDURE update_rsl_row(
p_rsl_row IN rcv_shipment_lines%ROWTYPE
) IS
BEGIN
asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);
UPDATE rcv_shipment_lines
SET ROW = p_rsl_row
WHERE shipment_line_id = p_rsl_row.shipment_line_id;
SELECT *
INTO g_poh_row
FROM po_headers_all
WHERE po_header_id IN(SELECT po_header_id
FROM po_headers
WHERE segment1 = p_po_num
-- Bug 13720644 Begin: type_lookup_code for Planned Purchase Order is 'PLANNED'
--AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
--Bug 13720644 End
AND org_id = NVL(p_org_id, org_id));
SELECT *
INTO g_poh_row
FROM po_headers_all
WHERE segment1 = p_po_num
-- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
--AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
--Bug 13720644 End
AND org_id = NVL(p_org_id, org_id);
SELECT *
INTO g_poh_row
FROM po_headers_all
WHERE segment1 = p_po_num
-- Bug 13720644: type_lookup_code for Planned Purchase Order is 'PLANNED'
--AND type_lookup_code IN('STANDARD', 'BLANKET', 'SCHEDULED')
AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED')
--Bug 13720644 End
AND org_id = g_default_org_id;
SELECT *
INTO g_poh_row
FROM po_headers_all
WHERE po_header_id = p_header_id;
SELECT *
INTO g_pol_row
FROM po_lines_all
WHERE po_line_id IN(SELECT po_line_id
FROM po_lines
WHERE po_header_id = p_header_id
AND ( line_num = x_line_num
OR x_line_num IS NULL)
AND ( item_id = x_item_id
OR x_item_id IS NULL )
AND ( item_description = x_item_description
OR x_item_description IS NULL)
AND ( vendor_product_num = x_vendor_product_num
OR x_vendor_product_num IS NULL));
SELECT *
INTO g_pol_row
FROM po_lines_all
WHERE po_header_id = p_header_id
AND ( line_num = x_line_num
OR x_line_num IS NULL)
AND ( item_id = x_item_id
OR x_item_id IS NULL )
AND ( item_description = x_item_description
OR x_item_description IS NULL)
AND ( vendor_product_num = x_vendor_product_num
OR x_vendor_product_num IS NULL);
SELECT *
INTO g_pol_row
FROM po_lines_all
WHERE po_line_id = p_line_id;
SELECT *
INTO g_pll_row
FROM po_line_locations_all
WHERE line_location_id IN(SELECT line_location_id
FROM po_line_locations
WHERE shipment_num = p_shipment_num
AND po_line_id = p_line_id);
SELECT *
INTO g_pll_row
FROM po_line_locations_all
WHERE shipment_num = p_shipment_num
AND po_line_id = p_line_id;
SELECT *
INTO g_pll_row
FROM po_line_locations_all
WHERE line_location_id = p_line_location_id;
SELECT *
INTO g_pod_row
FROM po_distributions_all
WHERE po_distribution_id IN(SELECT po_distribution_id
FROM po_distributions
WHERE distribution_num = p_distribution_num
AND line_location_id = p_line_location_id);
SELECT *
INTO g_pod_row
FROM po_distributions_all
WHERE distribution_num = p_distribution_num
AND line_location_id = p_line_location_id;
SELECT *
INTO g_pod_row
FROM po_distributions_all
WHERE po_distribution_id = p_distribution_id;
SELECT *
INTO g_oeh_row
FROM oe_order_headers_all
WHERE header_id IN(SELECT header_id
FROM oe_order_headers
WHERE order_number = p_order_number
AND order_type_id = NVL(p_order_type_id, order_type_id)
AND version_number = NVL(p_version_number, version_number)
AND org_id = NVL(p_org_id, org_id))
AND ROWNUM = 1
ORDER BY version_number DESC;
SELECT *
INTO g_oeh_row
FROM oe_order_headers_all
WHERE order_number = p_order_number
AND order_type_id = NVL(p_order_type_id, order_type_id)
AND version_number = NVL(p_version_number, version_number)
AND org_id = NVL(p_org_id, org_id)
AND ROWNUM = 1
ORDER BY version_number DESC;
SELECT *
INTO g_oeh_row
FROM oe_order_headers_all
WHERE order_number = p_order_number
AND order_type_id = NVL(p_order_type_id, order_type_id)
AND version_number = NVL(p_version_number, version_number)
AND org_id = g_default_org_id
AND ROWNUM = 1
ORDER BY version_number DESC;
SELECT *
INTO g_oeh_row
FROM oe_order_headers_all
WHERE header_id = p_header_id;
SELECT *
INTO g_oel_row
FROM oe_order_lines_all
WHERE line_id IN(SELECT line_id
FROM oe_order_lines
WHERE line_number = p_line_number
AND header_id = p_header_id
AND flow_status_code = 'AWAITING_RETURN');
SELECT *
INTO g_oel_row
FROM oe_order_lines_all
WHERE line_number = p_line_number
AND header_id = p_header_id
AND flow_status_code = 'AWAITING_RETURN';
SELECT *
INTO g_oel_row
FROM oe_order_lines_all
WHERE line_id = p_line_id;
SELECT *
INTO g_prl_row
FROM po_requisition_lines_all
WHERE requisition_line_id = p_requisition_line_id;
SELECT *
INTO g_prd_row
FROM po_req_distributions_all
WHERE distribution_id = p_req_distribution_id;
SELECT *
INTO g_msi_row
FROM mtl_system_items
WHERE inventory_item_id = p_item_id
AND organization_id = p_org_id;
SELECT *
INTO g_mic_row
FROM mtl_item_categories
WHERE inventory_item_id = p_item_id
AND organization_id = p_org_id;
SELECT *
INTO g_mp_row
FROM mtl_parameters
WHERE organization_id = p_org_id
AND rownum = 1;
SELECT *
INTO g_rp_row
FROM rcv_parameters
WHERE organization_id = p_org_id
AND rownum = 1;
SELECT *
INTO g_fc_row
FROM fnd_currencies
WHERE currency_code = p_currency_code;
SELECT *
INTO g_fsp_row
FROM financials_system_parameters;
SELECT *
INTO g_pvs_row
FROM po_vendor_sites_all
WHERE vendor_site_id = p_vendor_site_id;
SELECT *
INTO g_muom_row
FROM mtl_units_of_measure
WHERE unit_of_measure = p_unit_of_measure;
SELECT displayed_field
INTO g_po_lookups(l_key)
FROM po_lookup_codes
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code
AND enabled_flag = 'Y';
SELECT nvl(lcm_flag,'N')
INTO g_lcm_flag
FROM po_line_locations_all
WHERE line_location_id = p_po_line_location_id;
SELECT nvl(lcm_enabled_flag,'N')
INTO g_lcm_enabled_flag
FROM mtl_parameters
WHERE organization_id = p_organization_id;
SELECT nvl(pre_receive,'N')
INTO g_pre_rcv_flag
FROM rcv_parameters
WHERE organization_id = p_organization_id;