APPS.PO_LINE_LOCATIONS_DRAFT_PVT SQL Statements

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

Line: 13

, x_delete_list OUT NOCOPY PO_TBL_NUMBER
, x_insert_list OUT NOCOPY PO_TBL_NUMBER
, x_update_list OUT NOCOPY PO_TBL_NUMBER
);

Line: 90

    INSERT INTO po_session_gt
    ( key,
      num1
    )
    SELECT l_key,
           l_index_tbl(i)
    FROM DUAL
    WHERE EXISTS (SELECT 1
                  FROM   po_line_locations_draft_all PLLD
                  WHERE  PLLD.draft_id = p_draft_id_tbl(i)
                  AND    PLLD.line_location_id = NVL(p_line_location_id_tbl(i),
                                                     PLLD.line_location_id)
                  AND    NVL(PLLD.change_accepted_flag, 'Y') = 'Y');

Line: 109

  DELETE FROM po_session_gt
  WHERE key = l_key
  RETURNING num1
  BULK COLLECT INTO l_dft_exists_index_tbl;

Line: 227

l_delete_list PO_TBL_NUMBER;

Line: 228

l_insert_list PO_TBL_NUMBER;

Line: 229

l_update_list PO_TBL_NUMBER;

Line: 248

  , x_delete_list => l_delete_list
  , x_insert_list => l_insert_list
  , x_update_list => l_update_list
  );

Line: 253

  IF (l_delete_list.COUNT > 0) THEN
    d_position := 20;    FOR i IN 1..l_delete_list.COUNT LOOP

Line: 256

      PO_REQ_LINES_SV.remove_req_from_po (l_delete_list(i), 'SHIPMENT');

Line: 258

      FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
      ( 'PO_SHIPMENTS',
        l_delete_list(i),
        '','','','','', 'Y'
      );

Line: 314

l_delete_flag_tbl PO_TBL_VARCHAR1;

Line: 336

  INSERT INTO po_session_gt
  ( key,
    num1
  )
  SELECT l_key,
         POLLD.po_line_id
  FROM po_line_locations_draft_all POLLD,
       po_line_locations_all POLL
  WHERE POLLD.draft_id = p_draft_info.draft_id
  AND   POLLD.line_location_id = POLL.line_location_id (+)
  AND   NVL(POLLD.change_accepted_flag, 'Y') = 'Y'
  AND   (NVL(POLLD.delete_flag, 'N') = 'Y' OR
         POLL.line_location_id IS NULL);

Line: 354

  INSERT INTO po_session_gt
  ( key,
    num1
  )
  SELECT l_key,
         POLLD.po_line_id
  FROM po_line_locations_draft_all POLLD,
       po_line_locations_all POLL
  WHERE POLLD.draft_id = p_draft_info.draft_id
  AND   POLLD.line_location_id = POLL.line_location_id
  AND   NVL(POLLD.change_accepted_flag, 'Y') = 'Y'
  AND   NVL(POLLD.delete_flag, 'N') = 'N'
  AND   (DECODE (POLLD.ship_to_organization_id,
                 POLL.ship_to_organization_id, 'Y', 'N') = 'N' OR
         DECODE (POLLD.ship_to_location_id,
                 POLL.ship_to_location_id, 'Y', 'N') = 'N' OR
         DECODE (POLLD.quantity,
                 POLL.quantity, 'Y', 'N') = 'N' OR
         DECODE (POLLD.price_override,
                 POLL.price_override, 'Y', 'N') = 'N' OR
         DECODE (POLLD.price_discount,
                 POLL.price_discount, 'Y', 'N') = 'N' OR
         DECODE (POLLD.start_date,
                 POLL.start_date, 'Y', 'N') = 'N' OR
         DECODE (POLLD.end_date,
                 POLL.end_date, 'Y', 'N') = 'N');

Line: 384

  DELETE FROM po_session_gt
  WHERE key = l_key
  RETURNING num1, p_draft_info.draft_id, NULL
  BULK COLLECT
  INTO l_po_line_id_tbl, l_draft_id_tbl, l_delete_flag_tbl;

Line: 395

    p_delete_flag_tbl => l_delete_flag_tbl,
    x_record_already_exist_tbl => l_record_exist_tbl
  );

Line: 402

    UPDATE po_lines_draft_all
    SET    retroactive_date = SYSDATE
    WHERE  draft_id = p_draft_info.draft_id
    AND    po_line_id = l_po_line_id_tbl(i);

Line: 456

, x_delete_list OUT NOCOPY PO_TBL_NUMBER
, x_insert_list OUT NOCOPY PO_TBL_NUMBER
, x_update_list OUT NOCOPY PO_TBL_NUMBER
) IS

d_api_name CONSTANT VARCHAR2(30) := 'group_records_by_dml_type';

Line: 475

  x_delete_list := PO_TBL_NUMBER();

Line: 476

  x_insert_list := PO_TBL_NUMBER();

Line: 477

  x_update_list := PO_TBL_NUMBER();

Line: 480

  SELECT PLLD.line_location_id,
         NVL(PLLD.delete_flag, 'N'),
         DECODE(PLL.po_line_id, NULL, 'N', 'Y')
  BULK COLLECT
  INTO l_id_list,
       l_del_flag_list,
       l_txn_exists_list
  FROM po_line_locations_draft_all PLLD,
       po_line_locations_all PLL
  WHERE PLLD.draft_id = p_draft_info.draft_id
  AND   NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
  AND   PLLD.line_location_id = PLL.line_location_id(+);

Line: 497

        x_delete_list.extend;

Line: 498

        x_delete_list(x_delete_list.LAST) := l_id_list(i);

Line: 502

        x_update_list.extend;

Line: 503

        x_update_list(x_update_list.LAST) := l_id_list(i);

Line: 505

        x_insert_list.extend;

Line: 506

        x_insert_list(x_insert_list.LAST) := l_id_list(i);