APPS.OKL_MAINTAIN_CONTRACT_PVT SQL Statements

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

Line: 31

SELECT contract_number
FROM   okc_k_headers_v
WHERE  id = p_chr_id;

Line: 36

    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: 44

    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: 51

    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: 61

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

Line: 67

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

Line: 73

    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: 259

      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: 299

    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: 374

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

Line: 380

    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: 449

      SELECT okl_rbk_seq.NEXTVAL
      INTO   l_seq_no
      FROM   DUAL;

Line: 478

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

Line: 485

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