APPS.PO_DISTRIBUTIONS_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_distributions_draft_all PDD
                  WHERE  PDD.draft_id = p_draft_id_tbl(i)
                  AND    PDD.po_distribution_id =
                           NVL(p_po_distribution_id_tbl(i),
                               PDD.po_distribution_id)
                  AND    NVL(PDD.change_accepted_flag, 'Y') = 'Y');

Line: 110

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

Line: 292

, 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: 310

  x_delete_list := PO_TBL_NUMBER();

Line: 311

  x_insert_list := PO_TBL_NUMBER();

Line: 312

  x_update_list := PO_TBL_NUMBER();

Line: 315

  SELECT PDD.po_distribution_id,
         NVL(PDD.delete_flag, 'N'),
         DECODE(PD.po_distribution_id, NULL, 'N', 'Y')
  BULK COLLECT
  INTO l_id_list,
       l_del_flag_list,
       l_txn_exists_list
  FROM po_distributions_draft_all PDD,
       po_distributions_all PD
  WHERE PDD.draft_id = p_draft_info.draft_id
  AND   NVL(PDD.change_accepted_flag, 'Y') = 'Y'
  AND   PDD.po_distribution_id = PD.po_distribution_id(+);

Line: 332

        x_delete_list.extend;

Line: 333

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

Line: 337

        x_update_list.extend;

Line: 338

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

Line: 340

        x_insert_list.extend;

Line: 341

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