APPS.OKL_MAINTAIN_CONTRACT_PVT SQL Statements

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

Line: 40

    SELECT cle.id top_line
    FROM okc_line_styles_b lse,
         okc_k_lines_b cle
    WHERE cle.dnz_chr_id = p_dnz_chr_id
    AND cle.cle_id IS NULL
    AND cle.chr_id = cle.dnz_chr_id
    AND cle.lse_id = lse.id
    AND lse.lse_parent_id IS NULL
    AND lse.lse_type = G_TOP_LINE_STYLE
    and lse.lty_code = 'FREE_FORM1';

Line: 53

    SELECT name
    FROM   okc_k_lines_tl
    WHERE  id = p_fin_ast_id;

Line: 59

    select 'CANCEL_'||TO_CHAR(OKL_FAN_SEQ.NEXTVAL)
    FROM dual;

Line: 64

    SELECT 'Y'
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKL_TXL_ASSETS_V
                  WHERE asset_number = p_asset_number)
    OR EXISTS (SELECT '1'
                  FROM OKL_TXD_ASSETS_V
                  WHERE asset_number = p_asset_number)
    OR EXISTS (SELECT '1'
                  FROM OKX_ASSETS_V
                  WHERE asset_number = p_asset_number);

Line: 77

    SELECT 'Y'
    FROM DUAL
    WHERE EXISTS (select '1'
                  from   okc_k_lines_v kle,
                         okc_line_styles_b  lse
                  where  kle.name = p_asset_number
                  and    kle.lse_id = lse.id
                  and    lse.lty_code = 'FREE_FORM1');

Line: 98

    Select txlv.id,
           txlv.asset_number
    From   OKL_TXL_ASSETS_V  txlv,
           OKC_K_LINES_B     cle,
           OKC_LINE_STYLES_B lse
    Where  txlv.kle_id    = cle.id
    And    cle.lse_id     = lse.id
    And    lse.lty_code   = 'FIXED_ASSET'
    And    cle.cle_id     = p_finasst_id
    And    txlv.asset_number = p_asstNo;

Line: 114

    Select txdv.id,
           txdv.asset_number
    From   OKL_TXD_ASSETS_V  txdv,
           OKL_TXL_ASSETS_V  txlv,
           OKC_K_LINES_B     cle,
           OKC_LINE_STYLES_B lse
    Where  txdv.tal_id    = txlv.id
    And    txlv.kle_id    = cle.id
    And    cle.lse_id     = lse.id
    And    lse.lty_code   = 'FIXED_ASSET'
    And    cle.cle_id     = p_finasst_id
    And    txdv.asset_number = p_asstno;

Line: 199

         okl_okc_migration_pvt.update_contract_line(
             p_api_version       => p_api_version,
             p_init_msg_list     => p_init_msg_list,
             x_return_status     => x_return_status,
             x_msg_count         => x_msg_count,
             x_msg_data          => x_msg_data,
             p_restricted_update => OKC_API.G_FALSE,
             p_clev_rec          => l_clev_rec,
             x_clev_rec          => lx_clev_rec);

Line: 230

                  okl_txl_assets_pub.update_txl_asset_Def(
                                         p_api_version   => p_api_version,
                                         p_init_msg_list => p_init_msg_list,
                                         x_return_status => x_return_status,
                                         x_msg_count     => x_msg_count,
                                         x_msg_data      => x_msg_data,
                                         p_tlpv_rec      => l_tlpv_rec,
                                         x_tlpv_rec      => lx_tlpv_rec);

Line: 261

                 okl_txd_assets_pub.update_txd_asset_Def(
                                         p_api_version   => p_api_version,
                                         p_init_msg_list => p_init_msg_list,
                                         x_return_status => x_return_status,
                                         x_msg_count     => x_msg_count,
                                         x_msg_data      => x_msg_data,
                                         p_adpv_rec      => l_adpv_rec,
                                         x_adpv_rec      => lx_adpv_rec);

Line: 327

SELECT contract_number
FROM   okc_k_headers_v
WHERE  id = p_chr_id;

Line: 332

    SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status
    FROM iex_bankruptcies ban
    WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
                  WHERE rle.dnz_chr_id = p_contract_id
                  AND rle.rle_code = 'LESSEE'
                  AND TO_NUMBER(rle.object1_id1) = ban.party_id);

Line: 340

    SELECT sts_code
    FROM   okc_k_headers_b chrb
    WHERE  chrb.id = p_contract_id
    AND    chrb.scs_code  = 'LEASE'
    AND    chrb.sts_code in ('BOOKED', 'EVERGREEN', 'EXPIRED', 'TERMINATED', 'REVERSED', 'ABANDONED');

Line: 347

    SELECT funding_type_code
    FROM   okl_trx_ap_invoices_b
    WHERE  khr_id = p_contract_id
--    AND    ((funding_type_code = 'MANUAL_DISB') OR
-- Added for bug #5944260/5981076(Forward R12 cklee)
    AND  (trx_status_code in ('SUBMITTED', 'APPROVED', 'PROCESSED'));

Line: 357

    SELECT meaning
    FROM   fnd_lookups
    WHERE  lookup_type = 'OKL_FUNDING_TYPE'
    AND    lookup_code = p_code;

Line: 363

    SELECT '!'
    FROM   okl_trx_ar_invoices_b
    WHERE  khr_id = p_contract_id
    AND    trx_status_code <> 'ERROR';

Line: 369

    SELECT '!'
    FROM   okl_trx_csh_receipt_v otcr, okl_txl_rcpt_apps_v otra
    WHERE  otcr.id = otra.rct_id_details
    AND    otcr.receipt_type = 'ADV'
    AND    otra.khr_id = p_contract_id;

Line: 555

      SELECT h.VENDOR_INVOICE_NUMBER,
             h.PAY_GROUP_LOOKUP_CODE,
             h.NETTABLE_YN,
             h.FUNDING_TYPE_CODE,
             h.INVOICE_TYPE
        FROM OKL_TRX_AP_INVOICES_B h
       WHERE h.id = p_funding_id;

Line: 595

    OKL_TRX_AP_INVOICES_PUB.UPDATE_TRX_AP_INVOICES(
      p_api_version   => p_api_version,
      p_init_msg_list => p_init_msg_list,
      x_return_status => x_return_status,
      x_msg_count     => x_msg_count,
      x_msg_data      => x_msg_data,
      p_tapv_rec      => l_tapv_rec,
      x_tapv_rec      => x_tapv_rec);

Line: 670

SELECT contract_number, orig_system_source_code,
       orig_system_id1
FROM   okc_k_headers_v
WHERE  id = p_chr_id;

Line: 676

    SELECT id
    FROM   okl_trx_ap_invoices_b
    WHERE  khr_id = p_contract_id
    AND  trx_status_code not in ('CANCELED','SUBMITTED', 'APPROVED', 'PROCESSED');

Line: 745

      SELECT okl_rbk_seq.NEXTVAL
      INTO   l_seq_no
      FROM   DUAL;

Line: 774

    UPDATE okc_k_headers_b
    SET    sts_code = 'ABANDONED',
           contract_number = l_new_contract_number,
           datetime_cancelled = SYSDATE
    WHERE  id = p_contract_id;

Line: 792

    UPDATE okc_k_lines_b
    SET    sts_code = 'ABANDONED'
    WHERE  dnz_chr_id = p_contract_id;