APPS.PO_PDOI_UTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

  DELETE FROM PO_SESSION_GT
  WHERE key = p_key;

Line: 134

  SELECT NVL(MAX(batch_id), 0) + 1
  INTO l_batch_id
  FROM po_headers_interface;

Line: 198

      UPDATE po_headers_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_header_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id;

Line: 284

      UPDATE po_lines_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_header_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
    RETURNING interface_line_id, interface_header_id
    BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;

Line: 296

      UPDATE po_lines_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
    RETURNING interface_line_id, interface_header_id
    BULK COLLECT INTO l_intf_line_id_tbl, l_intf_header_id_tbl;

Line: 402

      UPDATE po_line_locations_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
	        <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
    RETURNING interface_line_location_id, interface_header_id
    BULK COLLECT INTO l_intf_line_loc_id_tbl, l_intf_header_id_tbl;

Line: 415

      UPDATE po_line_locations_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_location_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
	        <> PO_PDOI_CONSTANTS.g_PROCESS_CODE_OBSOLETE
    RETURNING interface_line_location_id, interface_header_id
    BULK COLLECT INTO l_intf_line_loc_id_tbl, l_intf_header_id_tbl;

Line: 503

      UPDATE po_distributions_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_location_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 514

      UPDATE po_distributions_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_distribution_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 589

      UPDATE po_price_diff_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 600

      UPDATE po_price_diff_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE price_diff_interface_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 681

      UPDATE po_attr_values_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 692

      UPDATE po_attr_values_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_attr_values_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 767

      UPDATE po_attr_values_tlp_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_line_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
       RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 779

      UPDATE po_attr_values_tlp_interface
      SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
          processing_id = -PO_PDOI_PARAMS.g_processing_id
      WHERE interface_attr_values_tlp_id = p_id_tbl(i)
      AND processing_id = PO_PDOI_PARAMS.g_processing_id
      RETURNING interface_header_id
      BULK COLLECT INTO l_intf_header_id_tbl;

Line: 1190

  UPDATE po_lines_interface
  SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
      processing_id = -PO_PDOI_PARAMS.g_processing_id
  WHERE interface_header_id = p_intf_header_id
  AND processing_id = PO_PDOI_PARAMS.g_processing_id
  AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
        IN (PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING,
            PO_PDOI_CONSTANTS.g_PROCESS_CODE_VAL_AND_REJECT);

Line: 1202

  UPDATE po_line_locations_interface
  SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
      processing_id = -PO_PDOI_PARAMS.g_processing_id
  WHERE interface_header_id = p_intf_header_id
  AND processing_id = PO_PDOI_PARAMS.g_processing_id
  AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
        = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line: 1213

  UPDATE po_price_diff_interface
  SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
      processing_id = -PO_PDOI_PARAMS.g_processing_id
  WHERE interface_header_id = p_intf_header_id
  AND processing_id = PO_PDOI_PARAMS.g_processing_id
  AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
        = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line: 1224

  UPDATE po_attr_values_interface
  SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
      processing_id = -PO_PDOI_PARAMS.g_processing_id
  WHERE interface_header_id = p_intf_header_id
  AND processing_id = PO_PDOI_PARAMS.g_processing_id
  AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
        = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;

Line: 1233

  UPDATE po_attr_values_tlp_interface
  SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_REJECTED,
      processing_id = -PO_PDOI_PARAMS.g_processing_id
  WHERE interface_header_id = p_intf_header_id
  AND processing_id = PO_PDOI_PARAMS.g_processing_id
  AND NVL(process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
        = PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING;