APPS.DPP_EXECUTIONPROCESS_PUB SQL Statements

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

Line: 48

   SELECT dpp.transaction_header_id
    FROM dpp_transaction_headers_all dpp
   WHERE dpp.transaction_status = 'APPROVED'
     AND dpp.effective_start_date <= sysdate
     AND to_number(dpp.org_id) = p_in_org_id
     AND dpp.transaction_number = nvl(p_txn_number,dpp.transaction_number)
     AND NOT EXISTS (SELECT dep.transaction_header_id
                       FROM DPP_EXECUTION_PROCESSES dep
                      WHERE dep.transaction_header_id = dpp.transaction_header_id);

Line: 61

    SELECT dppl.lookup_code
      FROM dpp_lookups dppl,
           OZF_PROCESS_SETUP_ALL opsa
     WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
       AND dppl.tag is not null
       AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
       AND opsa.enabled_flag = 'Y'
       AND opsa.org_id = p_in_org_id
       AND dppl.lookup_code = opsa.process_code;

Line: 73

   SELECT dpp.transaction_header_id,
          dpp.transaction_number,
          dpp.vendor_id,
          dpp.vendor_site_id
    FROM dpp_transaction_headers_all dpp
   WHERE dpp.transaction_status = 'APPROVED'
     AND dpp.effective_start_date <= sysdate
     AND to_number(dpp.org_id) = p_in_org_id
     AND dpp.transaction_number = nvl(p_txn_number,dpp.transaction_number)
     AND NOT EXISTS (SELECT dep.transaction_header_id
                       FROM DPP_EXECUTION_PROCESSES dep
                      WHERE dep.transaction_header_id = dpp.transaction_header_id);

Line: 88

    SELECT nvl(automatic_flag,'N') automatic_flag
      FROM OZF_PROCESS_SETUP_ALL
     WHERE nvl(supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
       AND process_code = p_process_code
       AND enabled_flag = 'Y'
       AND org_id = p_in_org_id;

Line: 98

    SELECT dpp.transaction_header_id
      FROM dpp_transaction_headers_all dpp
     WHERE dpp.transaction_header_id = p_txn_header_id
       AND NOT EXISTS (SELECT DISTINCT dcc.transaction_header_id
                     FROM dpp_customer_claims_all dcc
                    WHERE dcc.transaction_header_id = dpp.transaction_header_id);

Line: 106

CURSOR get_lines_for_updatepo_csr(p_txn_hdr_id IN NUMBER)
  IS
     SELECT dpp.transaction_header_id
      FROM dpp_transaction_headers_all dpp
     WHERE dpp.transaction_header_id = p_txn_hdr_id
       AND EXISTS (SELECT update_purchasing_docs
                     FROM dpp_transaction_lines_all dtl
                    WHERE nvl(update_purchasing_docs,'N') = 'N'
                      AND dtl.transaction_header_id = p_txn_hdr_id);

Line: 118

     SELECT dpp.transaction_header_id
      FROM dpp_transaction_headers_all dpp
     WHERE dpp.transaction_header_id = p_txn_hdr_id;

Line: 122

CURSOR get_lines_for_updateinv_csr(p_txn_hdr_id IN NUMBER)
  IS
    SELECT dtl.transaction_line_id
      FROM dpp_transaction_lines_all dtl
     WHERE dtl.transaction_header_id = p_txn_hdr_id
       AND EXISTS (SELECT UPDATE_INVENTORY_COSTING
                     FROM dpp_transaction_lines_all
                    WHERE nvl(UPDATE_INVENTORY_COSTING,'N') = 'N'
                      AND transaction_header_id = p_txn_hdr_id)
      AND rownum = 1;

Line: 135

    SELECT dtl.transaction_line_id,
           dtl.UPDATE_ITEM_LIST_PRICE
      FROM dpp_transaction_lines_all dtl
     WHERE dtl.transaction_header_id = p_txn_hdr_id
       AND EXISTS (SELECT UPDATE_ITEM_LIST_PRICE
                     FROM dpp_transaction_lines_all
                    WHERE nvl(UPDATE_ITEM_LIST_PRICE,'N') = 'N'
                      AND transaction_header_id = p_txn_hdr_id)
      AND rownum = 1;

Line: 147

    SELECT dtl.transaction_line_id,
           dtl.NOTIFY_INBOUND_PRICELIST
      FROM dpp_transaction_lines_all dtl
     WHERE dtl.transaction_header_id = p_txn_hdr_id
      AND rownum = 1;

Line: 155

    SELECT dtl.transaction_line_id,
           dtl.NOTIFY_OUTBOUND_PRICELIST
      FROM dpp_transaction_lines_all dtl
     WHERE dtl.transaction_header_id = p_txn_hdr_id
      AND rownum = 1;

Line: 163

    SELECT dtl.transaction_line_id,
           dtl.NOTIFY_PROMOTIONS_PRICELIST
      FROM dpp_transaction_lines_all dtl
     WHERE dtl.transaction_header_id = p_txn_hdr_id
       AND rownum = 1;

Line: 179

           SELECT supp_trade_profile_id
             INTO l_supp_trade_profile_id
             FROM ozf_supp_trd_prfls_all
            WHERE supplier_id = get_approved_txn_rec.vendor_id
              AND supplier_site_id = get_approved_txn_rec.vendor_site_id;

Line: 205

          FOR get_lines_for_updatepo_rec IN get_lines_for_updatepo_csr(get_approved_txn_rec.transaction_header_id) LOOP
          l_txn_hdr_rec := NULL;

Line: 207

          l_txn_line_id.delete();

Line: 250

          l_txn_line_id.delete();

Line: 290

          FOR get_lines_for_updateinv_rec IN get_lines_for_updateinv_csr(get_approved_txn_rec.transaction_header_id)
          LOOP
          l_txn_hdr_rec := NULL;

Line: 293

          l_txn_line_id.delete();

Line: 336

          l_txn_line_id.delete();

Line: 379

          l_txn_line_id.delete();

Line: 422

          l_txn_line_id.delete();

Line: 465

          l_txn_line_id.delete();

Line: 501

        l_txn_line_id.delete();

Line: 530

            l_txn_line_id.delete();

Line: 570

           UPDATE dpp_transaction_headers_all
              SET transaction_status = 'ACTIVE',
                  object_version_number = object_version_number + 1,
                  last_updated_by = l_user_id,
                  last_update_date = sysdate,
                  last_update_login = l_login_id
            WHERE transaction_header_id = get_valid_transaction_rec.transaction_header_id;

Line: 588

              INSERT INTO DPP_EXECUTION_PROCESSES (process_code,
                                                   transaction_header_id,
                                                   created_by,
                                                   creation_date,
                                                   last_updated_by,
                                                   last_update_date,
                                                   last_update_login
                                                  )
              VALUES (get_process_codes_rec.lookup_code,
                      get_valid_transaction_rec.transaction_header_id,
                      l_user_id,
                      sysdate,
                      l_user_id,
                      sysdate,
                      l_login_id
                     );