DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT SQL Statements

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

Line: 108

    SELECT ID,
           OBJECT_VERSION_NUMBER,
           ICA_ID,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           TAS_TYPE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           TSU_CODE,
           TRY_ID,
           DATE_TRANS_OCCURRED,
           TRANS_NUMBER,
           COMMENTS,
           REQ_ASSET_ID,
           TOTAL_MATCH_AMOUNT
    FROM OKL_TRX_ASSETS
    WHERE id = p_tas_id;
Line: 167

           x_trxv_rec.LAST_UPDATED_BY,
           x_trxv_rec.LAST_UPDATE_DATE,
           x_trxv_rec.LAST_UPDATE_LOGIN,
           x_trxv_rec.TSU_CODE,
           x_trxv_rec.TRY_ID,
           x_trxv_rec.DATE_TRANS_OCCURRED,
           x_trxv_rec.TRANS_NUMBER,
           x_trxv_rec.COMMENTS,
           x_trxv_rec.REQ_ASSET_ID,
           x_trxv_rec.TOTAL_MATCH_AMOUNT;
Line: 208

    SELECT CIM.ID,
           CIM.OBJECT_VERSION_NUMBER,
           CIM.CLE_ID,
           CIM.CHR_ID,
           CIM.CLE_ID_FOR,
           CIM.DNZ_CHR_ID,
           CIM.OBJECT1_ID1,
           CIM.OBJECT1_ID2,
           CIM.JTOT_OBJECT1_CODE,
           CIM.UOM_CODE,
           CIM.EXCEPTION_YN,
           CIM.NUMBER_OF_ITEMS,
           CIM.UPG_ORIG_SYSTEM_REF,
           CIM.UPG_ORIG_SYSTEM_REF_ID,
           CIM.PRICED_ITEM_YN,
           CIM.CREATED_BY,
           CIM.CREATION_DATE,
           CIM.LAST_UPDATED_BY,
           CIM.LAST_UPDATE_DATE,
           CIM.LAST_UPDATE_LOGIN
    FROM okc_k_items_v cim
    WHERE cim.dnz_chr_id = p_dnz_chr_id
    AND cim.cle_id = p_cle_id;
Line: 254

              x_cimv_rec.LAST_UPDATED_BY,
              x_cimv_rec.LAST_UPDATE_DATE,
              x_cimv_rec.LAST_UPDATE_LOGIN;
Line: 288

    SELECT ID,
           OBJECT_VERSION_NUMBER,
           SFWT_FLAG,
           CHR_ID_RESPONSE,
           CHR_ID_AWARD,
           INV_ORGANIZATION_ID,
           STS_CODE,
           QCL_ID,
           SCS_CODE,
           CONTRACT_NUMBER,
           CURRENCY_CODE,
           CONTRACT_NUMBER_MODIFIER,
           ARCHIVED_YN,
           DELETED_YN,
           CUST_PO_NUMBER_REQ_YN,
           PRE_PAY_REQ_YN,
           CUST_PO_NUMBER,
           SHORT_DESCRIPTION,
           COMMENTS,
           DESCRIPTION,
           DPAS_RATING,
           COGNOMEN,
           TEMPLATE_YN,
           TEMPLATE_USED,
           DATE_APPROVED,
           DATETIME_CANCELLED,
           AUTO_RENEW_DAYS,
           DATE_ISSUED,
           DATETIME_RESPONDED,
           NON_RESPONSE_REASON,
           NON_RESPONSE_EXPLAIN,
           RFP_TYPE,
           CHR_TYPE,
           KEEP_ON_MAIL_LIST,
           SET_ASIDE_REASON,
           SET_ASIDE_PERCENT,
           RESPONSE_COPIES_REQ,
           DATE_CLOSE_PROJECTED,
           DATETIME_PROPOSED,
           DATE_SIGNED,
           DATE_TERMINATED,
           DATE_RENEWED,
           TRN_CODE,
           START_DATE,
           END_DATE,
           AUTHORING_ORG_ID,
           BUY_OR_SELL,
           ISSUE_OR_RECEIVE,
           ESTIMATED_AMOUNT,
           ESTIMATED_AMOUNT_RENEWED,
           CURRENCY_CODE_RENEWED,
	   UPG_ORIG_SYSTEM_REF,
           UPG_ORIG_SYSTEM_REF_ID,
           APPLICATION_ID,
           ORIG_SYSTEM_SOURCE_CODE,
           ORIG_SYSTEM_ID1,
           ORIG_SYSTEM_REFERENCE1,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
     FROM okc_k_headers_v chrv
     WHERE chrv.id = p_id;
Line: 385

          x_chrv_rec.DELETED_YN,
          x_chrv_rec.CUST_PO_NUMBER_REQ_YN,
          x_chrv_rec.PRE_PAY_REQ_YN,
          x_chrv_rec.CUST_PO_NUMBER,
          x_chrv_rec.SHORT_DESCRIPTION,
          x_chrv_rec.COMMENTS,
          x_chrv_rec.DESCRIPTION,
          x_chrv_rec.DPAS_RATING,
          x_chrv_rec.COGNOMEN,
          x_chrv_rec.TEMPLATE_YN,
          x_chrv_rec.TEMPLATE_USED,
          x_chrv_rec.DATE_APPROVED,
          x_chrv_rec.DATETIME_CANCELLED,
          x_chrv_rec.AUTO_RENEW_DAYS,
          x_chrv_rec.DATE_ISSUED,
          x_chrv_rec.DATETIME_RESPONDED,
          x_chrv_rec.NON_RESPONSE_REASON,
          x_chrv_rec.NON_RESPONSE_EXPLAIN,
          x_chrv_rec.RFP_TYPE,
          x_chrv_rec.CHR_TYPE,
          x_chrv_rec.KEEP_ON_MAIL_LIST,
          x_chrv_rec.SET_ASIDE_REASON,
          x_chrv_rec.SET_ASIDE_PERCENT,
          x_chrv_rec.RESPONSE_COPIES_REQ,
          x_chrv_rec.DATE_CLOSE_PROJECTED,
          x_chrv_rec.DATETIME_PROPOSED,
          x_chrv_rec.DATE_SIGNED,
          x_chrv_rec.DATE_TERMINATED,
          x_chrv_rec.DATE_RENEWED,
          x_chrv_rec.TRN_CODE,
          x_chrv_rec.START_DATE,
          x_chrv_rec.END_DATE,
          x_chrv_rec.AUTHORING_ORG_ID,
          x_chrv_rec.BUY_OR_SELL,
          x_chrv_rec.ISSUE_OR_RECEIVE,
          x_chrv_rec.ESTIMATED_AMOUNT,
          x_chrv_rec.ESTIMATED_AMOUNT_RENEWED,
          x_chrv_rec.CURRENCY_CODE_RENEWED,
          x_chrv_rec.UPG_ORIG_SYSTEM_REF,
          x_chrv_rec.UPG_ORIG_SYSTEM_REF_ID,
          x_chrv_rec.APPLICATION_ID,
          x_chrv_rec.ORIG_SYSTEM_SOURCE_CODE,
          x_chrv_rec.ORIG_SYSTEM_ID1,
          x_chrv_rec.ORIG_SYSTEM_REFERENCE1,
          x_chrv_rec.ATTRIBUTE_CATEGORY,
          x_chrv_rec.ATTRIBUTE1,
          x_chrv_rec.ATTRIBUTE2,
          x_chrv_rec.ATTRIBUTE3,
          x_chrv_rec.ATTRIBUTE4,
          x_chrv_rec.ATTRIBUTE5,
          x_chrv_rec.ATTRIBUTE6,
          x_chrv_rec.ATTRIBUTE7,
          x_chrv_rec.ATTRIBUTE8,
          x_chrv_rec.ATTRIBUTE9,
          x_chrv_rec.ATTRIBUTE10,
          x_chrv_rec.ATTRIBUTE11,
          x_chrv_rec.ATTRIBUTE12,
          x_chrv_rec.ATTRIBUTE13,
          x_chrv_rec.ATTRIBUTE14,
          x_chrv_rec.ATTRIBUTE15,
          x_chrv_rec.CREATED_BY,
          x_chrv_rec.CREATION_DATE,
          x_chrv_rec.LAST_UPDATED_BY,
          x_chrv_rec.LAST_UPDATE_DATE,
          x_chrv_rec.LAST_UPDATE_LOGIN;
Line: 478

    SELECT ID,
           OBJECT_VERSION_NUMBER,
           SFWT_FLAG,
           CHR_ID,
           CLE_ID,
           LSE_ID,
           LINE_NUMBER,
           STS_CODE,
           DISPLAY_SEQUENCE,
           TRN_CODE,
           DNZ_CHR_ID,
           COMMENTS,
           ITEM_DESCRIPTION,
           OKE_BOE_DESCRIPTION,
           COGNOMEN,
           HIDDEN_IND,
           PRICE_UNIT,
           PRICE_UNIT_PERCENT,
           PRICE_NEGOTIATED,
           PRICE_NEGOTIATED_RENEWED,
           PRICE_LEVEL_IND,
           INVOICE_LINE_LEVEL_IND,
           DPAS_RATING,
           BLOCK23TEXT,
           EXCEPTION_YN,
           TEMPLATE_USED,
           DATE_TERMINATED,
           NAME,
           START_DATE,
           END_DATE,
           DATE_RENEWED,
           UPG_ORIG_SYSTEM_REF,
           UPG_ORIG_SYSTEM_REF_ID,
           ORIG_SYSTEM_SOURCE_CODE,
           ORIG_SYSTEM_ID1,
           ORIG_SYSTEM_REFERENCE1,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           PRICE_LIST_ID,
           PRICING_DATE,
           PRICE_LIST_LINE_ID,
           LINE_LIST_PRICE,
           ITEM_TO_PRICE_YN,
           PRICE_BASIS_YN,
           CONFIG_HEADER_ID,
           CONFIG_REVISION_NUMBER,
           CONFIG_COMPLETE_YN,
           CONFIG_VALID_YN,
           CONFIG_TOP_MODEL_LINE_ID,
           CONFIG_ITEM_TYPE,
           CONFIG_ITEM_ID ,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           PRICE_TYPE,
           CURRENCY_CODE,
	   CURRENCY_CODE_RENEWED,
           LAST_UPDATE_LOGIN
    FROM Okc_K_Lines_V
    WHERE okc_k_lines_v.id  = p_cle_id;
Line: 602

              x_clev_rec.program_update_date,
              x_clev_rec.price_list_id,
              x_clev_rec.pricing_date,
              x_clev_rec.price_list_line_id,
              x_clev_rec.line_list_price,
              x_clev_rec.item_to_price_yn,
              x_clev_rec.price_basis_yn,
              x_clev_rec.config_header_id,
              x_clev_rec.config_revision_number,
              x_clev_rec.config_complete_yn,
              x_clev_rec.config_valid_yn,
              x_clev_rec.config_top_model_line_id,
              x_clev_rec.config_item_type,
              x_clev_rec.CONFIG_ITEM_ID ,
              x_clev_rec.ATTRIBUTE_CATEGORY,
              x_clev_rec.ATTRIBUTE1,
              x_clev_rec.ATTRIBUTE2,
              x_clev_rec.ATTRIBUTE3,
              x_clev_rec.ATTRIBUTE4,
              x_clev_rec.ATTRIBUTE5,
              x_clev_rec.ATTRIBUTE6,
              x_clev_rec.ATTRIBUTE7,
              x_clev_rec.ATTRIBUTE8,
              x_clev_rec.ATTRIBUTE9,
              x_clev_rec.ATTRIBUTE10,
              x_clev_rec.ATTRIBUTE11,
              x_clev_rec.ATTRIBUTE12,
              x_clev_rec.ATTRIBUTE13,
              x_clev_rec.ATTRIBUTE14,
              x_clev_rec.ATTRIBUTE15,
              x_clev_rec.CREATED_BY,
              x_clev_rec.CREATION_DATE,
              x_clev_rec.LAST_UPDATED_BY,
              x_clev_rec.LAST_UPDATE_DATE,
              x_clev_rec.PRICE_TYPE,
              x_clev_rec.CURRENCY_CODE,
	      x_clev_rec.CURRENCY_CODE_RENEWED,
              x_clev_rec.LAST_UPDATE_LOGIN;
Line: 667

      SELECT ID,
             OBJECT_VERSION_NUMBER,
             KLE_ID,
             STY_ID,
             PRC_CODE,
             FCG_CODE,
             NTY_CODE,
             ESTIMATED_OEC,
             LAO_AMOUNT,
             TITLE_DATE,
             FEE_CHARGE,
             LRS_PERCENT,
             INITIAL_DIRECT_COST,
             PERCENT_STAKE,
             PERCENT,
             EVERGREEN_PERCENT,
             AMOUNT_STAKE,
             OCCUPANCY,
             COVERAGE,
             RESIDUAL_PERCENTAGE,
             DATE_LAST_INSPECTION,
             DATE_SOLD,
             LRV_AMOUNT,
             CAPITAL_REDUCTION,
             DATE_NEXT_INSPECTION_DUE,
             DATE_RESIDUAL_LAST_REVIEW,
             DATE_LAST_REAMORTISATION,
             VENDOR_ADVANCE_PAID,
             WEIGHTED_AVERAGE_LIFE,
             TRADEIN_AMOUNT,
             BOND_EQUIVALENT_YIELD,
             TERMINATION_PURCHASE_AMOUNT,
             REFINANCE_AMOUNT,
             YEAR_BUILT,
             DELIVERED_DATE,
             CREDIT_TENANT_YN,
             DATE_LAST_CLEANUP,
             YEAR_OF_MANUFACTURE,
             COVERAGE_RATIO,
             REMARKETED_AMOUNT,
             GROSS_SQUARE_FOOTAGE,
             PRESCRIBED_ASSET_YN,
             DATE_REMARKETED,
             NET_RENTABLE,
             REMARKET_MARGIN,
             DATE_LETTER_ACCEPTANCE,
             REPURCHASED_AMOUNT,
             DATE_COMMITMENT_EXPIRATION,
             DATE_REPURCHASED,
             DATE_APPRAISAL,
             RESIDUAL_VALUE,
             APPRAISAL_VALUE,
             SECURED_DEAL_YN,
             GAIN_LOSS,
             FLOOR_AMOUNT,
             RE_LEASE_YN,
             PREVIOUS_CONTRACT,
             TRACKED_RESIDUAL,
             DATE_TITLE_RECEIVED,
             AMOUNT,
             ATTRIBUTE_CATEGORY,
             ATTRIBUTE1,
             ATTRIBUTE2,
             ATTRIBUTE3,
             ATTRIBUTE4,
             ATTRIBUTE5,
             ATTRIBUTE6,
             ATTRIBUTE7,
             ATTRIBUTE8,
             ATTRIBUTE9,
             ATTRIBUTE10,
             ATTRIBUTE11,
             ATTRIBUTE12,
             ATTRIBUTE13,
             ATTRIBUTE14,
             ATTRIBUTE15,
             STY_ID_FOR,
             CLG_ID,
             CREATED_BY,
             CREATION_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN,
             DATE_FUNDING,
             DATE_FUNDING_REQUIRED,
             DATE_ACCEPTED,
             DATE_DELIVERY_EXPECTED,
             OEC,
             CAPITAL_AMOUNT,
             RESIDUAL_GRNTY_AMOUNT,
             RESIDUAL_CODE,
             RVI_PREMIUM,
             CREDIT_NATURE,
             CAPITALIZED_INTEREST,
             CAPITAL_REDUCTION_PERCENT,
             FEE_TYPE
    FROM OKL_K_LINES_V
    WHERE OKL_K_LINES_V.id     = p_kle_id;
Line: 851

        x_klev_rec.LAST_UPDATED_BY,
        x_klev_rec.LAST_UPDATE_DATE,
        x_klev_rec.LAST_UPDATE_LOGIN,
        x_klev_rec.DATE_FUNDING,
        x_klev_rec.DATE_FUNDING_REQUIRED,
        x_klev_rec.DATE_ACCEPTED,
        x_klev_rec.DATE_DELIVERY_EXPECTED,
        x_klev_rec.OEC,
        x_klev_rec.CAPITAL_AMOUNT,
        x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
        x_klev_rec.RESIDUAL_CODE,
        x_klev_rec.RVI_PREMIUM,
        x_klev_rec.CREDIT_NATURE,
        x_klev_rec.CAPITALIZED_INTEREST,
        x_klev_rec.CAPITAL_REDUCTION_PERCENT,
        x_klev_rec.FEE_TYPE;
Line: 919

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKC_K_HEADERS_B
                  WHERE ID = p_chr_id);
Line: 927

    SELECT id
    FROM okl_trx_contracts
    WHERE khr_id = p_chr_id
    AND tcn_type = 'SPLC'
   --rkuttiya added for 12.1.1 Multi GAAP
    AND representation_type = 'PRIMARY'
  --
    AND tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED');
Line: 938

    SELECT id
    FROM  okc_k_headers_b
    WHERE orig_system_id1 = p_chr_id
    AND   orig_system_source_code = 'OKL_SPLIT'
    ORDER BY CREATION_DATE;
Line: 1055

  PROCEDURE l_update_contract_header(p_api_version        IN  NUMBER,
                                      p_init_msg_list     IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                                      x_return_status     OUT NOCOPY VARCHAR2,
                                      x_msg_count         OUT NOCOPY NUMBER,
                                      x_msg_data          OUT NOCOPY VARCHAR2,
                                      p_restricted_update IN  VARCHAR2 DEFAULT 'F',
                                      p_chrv_rec          IN  chrv_rec_type,
                                      p_khrv_rec          IN  khrv_rec_type,
                                      x_chrv_rec          OUT NOCOPY chrv_rec_type,
                                      x_khrv_rec          OUT NOCOPY khrv_rec_type) IS
    l_api_name      CONSTANT VARCHAR2(30) := 'L_UPDATE_CONTRACT_HEADER';
Line: 1094

    OKL_CONTRACT_PUB.update_contract_header(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  => p_restricted_update,
                                            p_chrv_rec           => l_chrv_rec,
                                            p_khrv_rec           => l_khrv_rec,
                                            x_chrv_rec           => x_chrv_rec,
                                            x_khrv_rec           => x_khrv_rec);
Line: 1136

  END l_update_contract_header;
Line: 1153

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT 1
                  FROM OKC_SUBCLASS_TOP_LINE stl,
                       OKC_LINE_STYLES_V lse,
                       OKC_K_LINES_V cle
                  WHERE cle.id = p_top_line_id
                  AND 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.lty_code = G_FIN_LINE_LTY_CODE
                  AND lse.lse_type = G_TLS_TYPE
                  AND lse.lse_parent_id IS NULL
                  AND lse.id = stl.lse_id
                  AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE));
Line: 1259

    SELECT CHR.contract_number
    FROM OKC_K_HEADERS_B CHR
    WHERE CHR.id = p_chr_id;
Line: 1330

    SELECT id
    FROM okc_qa_check_lists_v
    WHERE name = p_qcl_name;
Line: 1335

    SELECT NVL(qcl_id,0)
    FROM okc_k_headers_b
    WHERE id  = p_chr_id;
Line: 1548

  PROCEDURE l_delete_contract_line(p_api_version      IN  NUMBER,
                                   p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                                   x_return_status    OUT NOCOPY VARCHAR2,
                                   x_msg_count        OUT NOCOPY NUMBER,
                                   x_msg_data         OUT NOCOPY VARCHAR2,
                                   p_contract_id      IN  OKC_K_HEADERS_V.ID%TYPE) IS

    l_api_name      CONSTANT VARCHAR2(30) := 'LOCAL_DEL_CONTRACT_LINE';
Line: 1565

    SELECT id stm_id
    FROM OKL_STREAMS
    WHERE khr_id = p_khr_id;
Line: 1570

    SELECT id trx_id
    FROM OKL_TRX_CONTRACTS
    WHERE khr_id = p_khr_id
  --rkuttiya added for 12.1.1 Multi GAAP
    AND   representation_type = 'PRIMARY';
Line: 1577

    SELECT id
    FROM OKL_TXL_CNTRCT_LNS
    WHERE khr_id = p_khr_id;
Line: 1582

    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_TLS_TYPE;
Line: 1594

    SELECT orig_system_id1
    FROM okc_k_headers_b
    WHERE id = p_chr_id;
Line: 1600

    SELECT trx.id trx_id
    FROM okl_trx_contracts trx,
         okl_trx_types_tl  try,
         okc_k_headers_b CHR
    WHERE try.name = 'Split Contract'
    AND try.LANGUAGE = 'US'
    AND trx.try_id = try.id
    AND trx.tsu_code = 'ENTERED'
    AND trx.khr_id = CHR.orig_system_id1
    --rkuttiya added for 12.1.1 Multi GAAP Project
    AND trx.representation_type = 'PRIMARY'
    --
    AND CHR.orig_system_source_code = 'OKL_SPLIT'
    AND CHR.orig_system_id1= p_org_sys_id;
Line: 1647

      Okl_Trx_Contracts_Pub.update_trx_contracts(
                            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_tcnv_rec      => l_tcnv_rec,
                            x_tcnv_rec      => lx_tcnv_rec);
Line: 1664

    OKL_CONTRACT_STATUS_PUB.update_contract_status(
                            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_khr_status    => 'INCOMPLETE',
                            p_chr_id        => p_contract_id);
Line: 1692

      OKL_ACCOUNT_DIST_PUB.DELETE_ACCT_ENTRIES(
                            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_source_id     => r_get_source_id.id,
                            p_source_table  => 'OKL_TXL_CNTRCT_LNS');
Line: 1714

      OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
                            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_tcnv_rec      => r_tcnv_rec);
Line: 1735

      OKL_STREAMS_PUB.delete_streams(
                              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_stmv_rec      => l_stmv_rec);
Line: 1755

      OKL_CONTRACT_PUB.delete_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_line_id            => r_get_k_top_line.top_line);
Line: 1776

    OKL_CONTRACT_PUB.delete_contract_header(
                     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_chrv_rec           => l_chrv_rec,
                     p_khrv_rec           => l_khrv_rec);
Line: 1872

  END l_delete_contract_line;
Line: 1900

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKC_K_HEADERS_B
                  WHERE ID = p_chr_id);
Line: 1908

    SELECT trx.id trx_id
    FROM okl_trx_contracts trx,
         okl_trx_types_tl  try
    WHERE try.name = 'Split Contract'
    AND try.LANGUAGE = 'US'
    AND trx.try_id = try.id
    AND trx.tsu_code IN ('ENTERED','WORKING','WAITING','SUBMITTED')
    AND trx.tcn_type = 'SPLC'
   --rkuttiya added for 12.1.1 Multi GAAP
    AND trx.representation_type = 'PRIMARY'
   --
    AND trx.khr_id = p_chr_id;
Line: 1923

    SELECT id
    FROM  okc_k_headers_b
    WHERE orig_system_id1 = p_chr_id
    AND   orig_system_source_code = 'OKL_SPLIT';
Line: 1985

        Okl_Trx_Contracts_Pub.update_trx_contracts(
                              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_tcnv_rec      => l_tcnv_rec,
                              x_tcnv_rec      => lx_tcnv_rec);
Line: 2005

      l_delete_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_contract_id    => ln_split_contract1);
Line: 2094

  PROCEDURE l_delete_fee_service_lines(p_api_version      IN  NUMBER,
                                       p_init_msg_list    IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                                       x_return_status    OUT NOCOPY VARCHAR2,
                                       x_msg_count        OUT NOCOPY NUMBER,
                                       x_msg_data         OUT NOCOPY VARCHAR2,
                                       p_contract_id      IN  OKC_K_HEADERS_V.ID%TYPE) IS

    l_api_name      CONSTANT VARCHAR2(30) := 'L_DEL_FEE_SERV_LINES';
Line: 2109

    SELECT cle.id id
    FROM   okl_k_lines_v kle,
           okc_k_lines_v cle,
           okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code IN (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
    AND lse.lse_type = 'TLS'
    AND cle.cle_id IS NULL
    AND cle.id NOT IN (SELECT DISTINCT(cle_sl.cle_id) cle_id
                       FROM okl_k_lines_v kle_sl,
                            okc_k_lines_v cle_sl,
                            okc_line_styles_b lse_sl
                       WHERE cle_sl.dnz_chr_id = p_chr_id
                       AND cle_sl.id = kle_sl.id
                       AND cle_sl.lse_id = lse_sl.id
                       AND lse_sl.lty_code IN (G_FEL_LINE_LTY_CODE, G_SRL_LINE_LTY_CODE));
Line: 2146

      OKL_CONTRACT_PUB.delete_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_line_id       => r_get_fee_service_lines.id);
Line: 2201

  END l_delete_fee_service_lines;
Line: 2248

    SELECT '1'
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKC_K_LINES_B cle,
                       OKC_LINE_STYLES_b lse
                  WHERE cle.dnz_chr_id = p_chr_id
                  AND lse.id = cle.lse_id
                  AND lse.lty_code IN (G_SER_LINE_LTY_CODE,
                                       G_SRL_LINE_LTY_CODE,
                                       G_FEE_LINE_LTY_CODE,
                                       G_FEL_LINE_LTY_CODE,
                                       G_USG_LINE_LTY_CODE,
                                       G_USL_LINE_LTY_CODE));
Line: 2264

    SELECT orig_system_id1
    FROM okc_k_headers_b
    WHERE id = p_chr_id;
Line: 2270

    SELECT sum(cle.capital_amount) total_capital_amount
    FROM okl_k_lines_full_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_FIN_LINE_LTY_CODE
    AND lse.lse_type = G_TLS_TYPE;*/
Line: 2282

    select tcle.id id
    from okc_k_items tcim,
         okc_k_lines_b tcle,
         okc_line_styles_b lse
    where tcim.dnz_chr_id = p_dnz_chr_id
    and tcle.lse_id = lse.id
    and tcim.cle_id = tcle.id
    and tcim.dnz_chr_id = tcle.dnz_chr_id
    and lse.lty_code in (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
    and exists (select 1
                from okc_k_items cim,
                     okc_k_lines_b cle
                where cim.dnz_chr_id = p_dnz_chr_id
                and cle.cle_id = tcle.id
                and cim.cle_id = cle.id
                and cim.jtot_object1_code = 'OKX_COVASST'
                and not exists
                    (select 1
                     from okc_k_lines_b cle,
                          okc_line_styles_b lse
                     where cle.dnz_chr_id = p_dnz_chr_id
                     and cle.lse_id = lse.id
                     and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
                     and lse.lse_type = G_TLS_TYPE
                     and cle.id = cim.object1_id1))
    and not exists
    (select 1
     from okc_k_lines_b cle,
          okc_line_styles_b lse
     where cle.dnz_chr_id = p_dnz_chr_id
     and cle.lse_id = lse.id
     and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
     and lse.lse_type = G_TLS_TYPE
     and exists(select 1
                from okc_k_lines_b scle,
                     okc_k_items scim
                where scle.id = scim.cle_id -- sub line join with item
                and scim.dnz_chr_id = p_dnz_chr_id
                and scim.dnz_chr_id = tcle.dnz_chr_id
                and scle.cle_id = tcle.id -- fee top line join
                and scim.object1_id1 = cle.id));
Line: 2327

    SELECT DISTINCT(cle.id) id
    FROM okl_k_lines_full_v cle,
         okc_k_items cim
    WHERE cle.dnz_chr_id = p_dnz_chr_Id
    AND cle.id = cim.cle_id
    AND cim.jtot_object1_code = 'OKX_COVASST'
    AND cim.object1_id1 NOT IN (SELECT cle.id
                                FROM okc_k_lines_b cle,
                                     okc_line_styles_b lse
                                WHERE cle.dnz_chr_id = p_dnz_chr_Id
                                AND cle.lse_id = lse.id
                                AND lse.lty_code IN (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
                                AND lse.lse_type = G_TLS_TYPE);
Line: 2345

    SELECT cle.cle_id fee_top_line_id, cim.cle_id linked_asset_id
    FROM okc_k_items cim,
         okc_k_lines_b cle
    WHERE cim.dnz_chr_id = p_dnz_chr_Id
    AND cim.cle_id = cle.id
    AND cim.dnz_chr_id = cle.dnz_chr_id
    AND cim.jtot_object1_code = 'OKX_COVASST'
    AND cim.object1_id1 not in (SELECT cle.id
                                FROM okc_k_lines_b cle,
                                     okc_line_styles_b lse
                                WHERE cle.dnz_chr_id = p_dnz_chr_Id
                                AND cle.lse_id = lse.id
                                AND lse.lty_code = G_FIN_LINE_LTY_CODE
                                AND lse.lse_type = G_TLS_TYPE);
Line: 2362

    SELECT cim.cle_id cle_id
    FROM okc_k_items cim
    WHERE cim.dnz_chr_id = p_dnz_chr_Id
    AND cim.jtot_object1_code = 'OKX_COVASST'
    AND cim.object1_id1 not in (SELECT cle.id
                                FROM okc_k_lines_b cle,
                                     okc_line_styles_b lse
                                WHERE cle.dnz_chr_id = p_dnz_chr_Id
                                AND cle.lse_id = lse.id
                                AND lse.lty_code = G_FIN_LINE_LTY_CODE
                                AND lse.lse_type = G_TLS_TYPE);*/
Line: 2378

    SELECT nvl(kle.amount,0) amount,
           nvl(kle.initial_direct_cost,0) initial_direct_cost,
           cle.id id
    FROM okl_k_lines_v kle,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL;*/
Line: 2395

    SELECT DISTINCT(cle.id) id,
           NVL(kle.amount,0) amount,
           NVL(kle.initial_direct_cost,0) initial_direct_cost
    FROM okl_k_lines_v kle_sl,
         okc_k_lines_v cle_sl,
         okc_line_styles_b lse_sl,
         okl_k_lines_v kle,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code IN (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL
    AND cle.id = cle_sl.cle_id
    AND cle_sl.id = kle_sl.id
    AND cle_sl.lse_id = lse_sl.id
    AND lse_sl.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
Line: 2419

    SELECT SUM(kle.CAPITAL_AMOUNT)
    FROM   okl_k_lines_v kle,
           okc_line_styles_b lse,
           okc_k_lines_v cle
    WHERE cle.cle_id = p_cle_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code IN (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE);
Line: 2431

    SELECT sum(nvl(kle_sl.capital_amount,0)) amount,
           cle.id id,
           cle.orig_system_id1 orig_system_id1
    FROM okl_k_lines_v kle_sl,
         okc_k_lines_v cle_sl,
         okc_line_styles_b lse_sl,
         okl_k_lines_v kle,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL
    AND cle.id = cle_sl.cle_id
    and cle_sl.id = kle_sl.id
    AND cle_sl.lse_id = lse_sl.id
    AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE)
    group by cle.id,
             cle.orig_system_id1;*/
Line: 2456

    SELECT rl.id,
           rl.rule_information6 payment_amount,
           rl.rule_information2 rl_date
    FROM okc_rule_groups_b rg,
         okc_rules_b rl,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = p_cle_id
    AND cle.lse_id = lse.id
    AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL
    AND rg.dnz_chr_id = cle.dnz_chr_id
    AND rg.cle_id = cle.id
    AND rg.chr_id IS NULL
    AND rg.id = rl.rgp_id
    AND rg.rgd_code = 'LALEVL'
    AND rl.rule_information_category = 'LASLL'
    AND not exists (SELECT '1'
                    FROM okc_k_lines_v cle_sl,
                         okc_line_styles_b lse_sl
                    WHERE cle_sl.dnz_chr_id = p_chr_id
                    AND cle_sl.cle_id  = cle.id
                    AND cle_sl.lse_id = lse_sl.id
                    AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
Line: 2486

    SELECT rl.id,
           rl.rule_information6 payment_amount
    FROM okc_rule_groups_b rg,
         okc_rules_b rl,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = p_cle_id
    AND cle.lse_id = lse.id
    AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL
    AND rg.dnz_chr_id = cle.dnz_chr_id
    AND rg.cle_id = cle.id
    AND rg.chr_id IS NULL
    AND rg.id = rl.rgp_id
    AND rg.rgd_code = 'LALEVL'
    AND rl.rule_information_category = 'LASLL'
    AND exists (SELECT '1'
                    FROM okc_k_lines_v cle_sl,
                         okc_line_styles_b lse_sl
                    WHERE cle_sl.dnz_chr_id = p_chr_id
                    AND cle_sl.cle_id  = cle.id
                    AND cle_sl.lse_id = lse_sl.id
                    AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/
Line: 2516

    SELECT  rl.id,
            cle.currency_code
    FROM okc_rule_groups_b rg,
         okc_rules_b rl,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = p_cle_id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_SER_LINE_LTY_CODE
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL
    AND rg.dnz_chr_id = cle.dnz_chr_id
    AND rg.cle_id = cle.id
    AND rg.chr_id IS NULL
    AND rg.id = rl.rgp_id
    AND rg.rgd_code = 'LAFEXP'
    AND rl.rule_information_category = 'LAFEXP';
Line: 2539

    SELECT crl.RULE_INFORMATION1,
           crl.RULE_INFORMATION2
    FROM   OKC_RULE_GROUPS_B crg,
           OKC_RULES_B crl
    WHERE  crl.rgp_id = crg.id
           AND crg.RGD_CODE = p_rgd_code
           AND crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
           AND crg.dnz_chr_id = p_chr_id
           AND NVL(crg.cle_id,-1) = p_cle_id;
Line: 2551

    SELECT cle.id id,
           NVL(kle.amount,0) amount
    FROM okl_k_lines_v kle,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_SER_LINE_LTY_CODE
    AND lse.lse_type  = G_TLS_TYPE
    AND cle.cle_id IS NULL;
Line: 2567

    SELECT cle.id id,
           NVL(kle.amount,0) amount
    FROM okl_k_lines_v kle,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_old_chr_id
    AND cle.id = kle.id
    AND cle.lse_id = lse.id
    AND lse.lty_code = 'SOLD_SERVICE'
    AND lse.lse_type  = 'TLS'
    AND cle.cle_id IS NULL
    AND cle.id = (SELECT klfv.ORIG_SYSTEM_ID1
                  FROM okl_k_lines_full_v klfv
                  WHERE klfv.id = p_new_cle_id
                  AND klfv.dnz_chr_id = p_new_chr_id);
Line: 2588

    SELECT  rl.id,
            rl.rule_information2,
            rl.rule_information3,
            rl.rule_information6,
            rl.rule_information7,
            rl.rule_information8,
            cle.currency_code
    FROM okc_rule_groups_b rg,
         okc_rules_b rl,
         okc_k_lines_v cle,
         okc_line_styles_b lse
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.id = p_cle_id
    AND cle.lse_id = lse.id
    AND cle.cle_id IS NULL
    AND rg.dnz_chr_id = cle.dnz_chr_id
    AND rg.cle_id = cle.id
    AND rg.id = rl.rgp_id
    AND rg.rgd_code = p_rgd_code
    AND rl.rule_information_category = p_rgp_cat;
Line: 2609

    /*SELECT crl.id,
           crl.RULE_INFORMATION3,
           crl.RULE_INFORMATION6
    FROM   OKC_RULE_GROUPS_B crg,
           OKC_RULES_B crl
    WHERE  crl.rgp_id = crg.id
           and crg.RGD_CODE = p_rgd_code
           and crl.RULE_INFORMATION_CATEGORY = p_rgp_cat
           and crg.dnz_chr_id = p_chr_id
           and nvl(crg.cle_id,-1) = p_cle_id;  */
Line: 2669

        OKL_CONTRACT_PUB.delete_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_line_id       => r_get_item_info_tls.id);
Line: 2700

        OKL_CONTRACT_PUB.delete_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_line_id       => r_get_item_info.id);
Line: 2775

        OKL_CONTRACT_PUB.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_clev_rec      => l_clev_rec,
                         p_klev_rec      => l_klev_rec,
                         x_clev_rec      => lx_clev_rec,
                         x_klev_rec      => lx_klev_rec);
Line: 2841

            OKL_RULE_PUB.update_rule(
                         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_rulv_rec      => l_rulv_rec,
                         x_rulv_rec      => lx_rulv_rec);
Line: 2918

            OKL_RULE_PUB.update_rule(
                         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_rulv_rec      => lp_rulv_rec,
                         x_rulv_rec      => lx_rulv_rec);
Line: 2973

          OKL_RULE_PUB.update_rule(
                         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_rulv_rec      => l_rulv_rec,
                         x_rulv_rec      => lx_rulv_rec);
Line: 2996

          OKL_RULE_PUB.update_rule(
                       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_rulv_rec      => l_rulv_rec,
                       x_rulv_rec      => lx_rulv_rec);
Line: 3048

        OKL_CONTRACT_PUB.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_clev_rec      => l_clev_rec,
                         p_klev_rec      => l_klev_rec,
                         x_clev_rec      => lx_clev_rec,
                         x_klev_rec      => lx_klev_rec);
Line: 3073

                OKL_RULE_PUB.update_rule(
                             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_rulv_rec      => r_rulv_rec,
                             x_rulv_rec      => rx_rulv_rec);
Line: 3314

    SELECT object1_id1 service_contract_id
    FROM okc_k_rel_objs_v rel
    WHERE rel.chr_id = P_chr_id;
Line: 3320

    SELECT '1'
    FROM DUAL
    WHERE EXISTS (SELECT '1'
                  FROM OKC_K_LINES_B cle,
                       OKC_LINE_STYLES_b lse
                  WHERE cle.dnz_chr_id = p_chr_id
                  AND lse.id = cle.lse_id
                  AND lse.lty_code IN (G_USG_LINE_LTY_CODE,
                                       G_USL_LINE_LTY_CODE));
Line: 3332

    SELECT 1
    FROM dual
    WHERE EXISTS (SELECT 1
                  FROM okl_trx_contracts trx,
                       okl_trx_types_tl  try,
                       okl_k_headers khr
                  WHERE try.name = 'Split Contract'
                  AND try.LANGUAGE = 'US'
                  AND trx.try_id = try.id
                --rkuttiya added for 12.1.1 Multi GAAP
                  AND trx.representation_type = 'PRIMARY'
                --
                  AND trx.tsu_code = 'ENTERED'
                  AND khr.id = trx.khr_id
                  AND trx.khr_id = p_chr_id);
Line: 3350

    SELECT orig_system_id1
    FROM okc_k_headers_b
    WHERE id = p_chr_id
    AND orig_system_source_code = 'OKL_SPLIT';
Line: 3357

    SELECT CHR.id chr_id,
           sts_code sts_code,
           trx.id trx_id
    FROM okl_trx_contracts trx,
         okl_trx_types_tl  try,
         okc_k_headers_b CHR
    WHERE try.name = 'Split Contract'
    AND try.LANGUAGE = 'US'
    AND trx.try_id = try.id
    AND trx.tsu_code = 'ENTERED'
    AND trx.khr_id = CHR.orig_system_id1
  --rkuttiya added for 12.1.1 Multi GAAP
    AND trx.representation_type = 'PRIMARY'
 --
    AND CHR.orig_system_source_code = 'OKL_SPLIT'
    AND CHR.orig_system_id1= p_chr_id;
Line: 3376

    SELECT orig_system_id1 orig_cle_fa,
           txl.tas_id tas_id_fa,
           cle.id id
    FROM OKC_K_LINES_V cle,
         OKC_LINE_STYLES_V lse,
         OKL_TXL_ASSETS_B txl
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_FA_LINE_LTY_CODE
    AND cle.id = txl.kle_id;
Line: 3389

    SELECT orig_system_id1 orig_cle_ib,
           iti.tas_id tas_id_ib,
           cle.id id
    FROM OKC_K_LINES_V cle,
         OKC_LINE_STYLES_V lse,
         OKL_TXL_ITM_INSTS iti
    WHERE cle.dnz_chr_id = p_chr_id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_IB_LINE_LTY_CODE
    AND cle.id = iti.kle_id;
Line: 3403

    SELECT object1_id1,
           object1_id2
    FROM  okc_k_items
    WHERE cle_id = p_orig_cle_id
    AND dnz_chr_Id = p_orig_chr_id;
Line: 3412

    SELECT KHR.ID, KHR.CONTRACT_NUMBER, KHR.START_DATE, TRX.DATE_TRANSACTION_OCCURRED
    FROM   OKC_K_HEADERS_B KHR,
           OKL_TRX_CONTRACTS TRX
    WHERE  TRX.KHR_ID = KHR.ID
    AND    TRX.TSU_CODE = 'PROCESSED'
    AND    TRX.TCN_TYPE = 'SPLC'
   --rkuttiya added for 12.1.1 Multi GAAP
    AND    TRX.REPRESENTATION_TYPE = 'PRIMARY'
   --
    AND    KHR.ID = p_chr_id;
Line: 3536

        OKL_OKC_MIGRATION_PVT.update_contract_item(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_cimv_rec      => l_cimv_rec,
                                                   x_cimv_rec      => lx_cimv_rec);
Line: 3566

        OKL_TRX_ASSETS_PUB.update_trx_ass_h_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_thpv_rec       => l_trxv_rec,
                           x_thpv_rec       => lx_trxv_rec);
Line: 3630

        OKL_OKC_MIGRATION_PVT.update_contract_item(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_cimv_rec      => l_cimv_rec,
                                                   x_cimv_rec      => lx_cimv_rec);
Line: 3660

        OKL_TRX_ASSETS_PUB.update_trx_ass_h_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_thpv_rec       => l_trxv_rec,
                           x_thpv_rec       => lx_trxv_rec);
Line: 3721

      OKL_CONTRACT_STATUS_PUB.update_contract_status(
                              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_khr_status    => 'BOOKED',
                              p_chr_id        => p_chr_id);
Line: 3736

        FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_CONTRACT_STATUS_PUB.update_contract_status
          procedure finished with status ' || x_return_status || ' in
          split_contract_after_yield procedure');
Line: 3792

        Okl_Trx_Contracts_Pub.update_trx_contracts(
                                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_tcnv_rec      => l_tcnv_rec,
                                x_tcnv_rec      => lx_tcnv_rec);
Line: 3848

        OKL_CONTRACT_STATUS_PUB.update_contract_status(
                                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_khr_status    => 'AMENDED',
                                p_chr_id        => ln_orig_system_id1);
Line: 3881

          OKL_CONTRACT_STATUS_PUB.update_contract_status(
                                  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_khr_status    => 'AMENDED',
                                  p_chr_id        => ln_service_id);
Line: 4124

    SELECT id
    FROM OKC_K_HEADERS_V
    WHERE contract_number = p_contract_number;
Line: 4129

    SELECT contract_number
    FROM OKC_K_HEADERS_V
    WHERE id = p_header_id;
Line: 4134

    SELECT COUNT(cle.id)
    FROM OKC_SUBCLASS_TOP_LINE stl,
         OKC_LINE_STYLES_V lse,
         OKC_K_LINES_V cle,
         OKC_K_HEADERS_V chrv
    WHERE chrv.contract_number = p_contract_number
    AND chrv.id = cle.dnz_chr_id
    AND cle.cle_id IS NULL
    AND cle.chr_id = chrv.id
    AND cle.lse_id = lse.id
    AND lse.lty_code = G_FIN_LINE_LTY_CODE
    AND lse.lse_type = G_TLS_TYPE
    AND lse.lse_parent_id IS NULL
    AND lse.id = stl.lse_id
    AND stl.scs_code IN (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
Line: 4224

          l_update_contract_header(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_chrv_rec      => l_chrv_rec,
                                   p_khrv_rec      => l_khrv_rec,
                                   x_chrv_rec      => lx_chrv_rec,
                                   x_khrv_rec      => lx_khrv_rec);
Line: 4490

    SELECT a.id,
           a.sis_code,
           h.sts_code
    FROM  okl_stream_interfaces a,
          okc_k_headers_b h
    WHERE a.khr_id = p_khr_id
    AND h.id = a.khr_id
    AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
                                   FROM okl_stream_interfaces b
                                   WHERE b.khr_id = p_khr_id);
Line: 4502

    SELECT NVL(SUBSTRB(TRANSLATE(LTRIM(value),',',' '), 1,
               INSTR(TRANSLATE(LTRIM(value),',',' '),' ') - 1),value)
    FROM v$parameter
    WHERE name = 'utl_file_dir';
Line: 4508

    SELECT sts_code
    FROM  okc_k_headers_b
    WHERE id = p_khr_id;
Line: 4513

    SELECT contract_number
    FROM okc_k_headers_b
    WHERE id = (SELECT ORIG_SYSTEM_ID1
                FROM okc_k_headers_b
                WHERE id = p_khr_id);
Line: 4521

    SELECT a.sis_code,
           h.sts_code
    FROM  okl_stream_interfaces a,
          okc_k_headers_b h
    WHERE a.id = p_stream_id
    AND a.khr_id = p_khr_id
    AND h.id = a.khr_id
    AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
                                   FROM okl_stream_interfaces b
                                   WHERE b.khr_id = p_khr_id);
Line: 4533

    SELECT id
    FROM OKL_TXL_CNTRCT_LNS
    WHERE khr_id = p_khr_id;
Line: 4538

    SELECT authoring_org_id
    FROM   okc_k_headers_b
    WHERE  id = p_chr_id;
Line: 4555

      SELECT chrb.orig_system_id1 old_chr_id
     		,trxb.date_transaction_occurred date_transaction_occurred
      FROM   okc_k_headers_b chrb
       	   ,okl_trx_contracts trxb
 		  ,okl_trx_types_b tryv
      WHERE  chrb.id = p_khr_id
      -- AND    trxb.khr_id_old = chrb.orig_system_id1
     AND trxb.khr_id = chrb.id
      AND    trxb.tsu_code = 'PROCESSED'
      AND    trxb.try_id = tryv.id;
Line: 4568

      SELECT chrb.orig_system_id1 old_chr_id
                     ,trxb2.date_transaction_occurred date_transaction_occurred
      FROM   okc_k_headers_b chrb
                    ,okl_trx_contracts trxb1
                    ,okl_trx_types_b tryv
                    ,okl_trx_contracts trxb2
      WHERE  chrb.id = p_khr_id
      AND trxb1.khr_id = chrb.id
      AND    trxb1.tsu_code = 'PROCESSED'
      --rkuttiya added for 12.1.1 MUlti GAAP
      AND    trxb1.representation_type = 'PRIMARY'
      --
      AND    trxb1.try_id = tryv.id
      AND    trxb2.khr_id = chrb.orig_system_id1
      AND    trxb2.TCN_TYPE = 'SPLC'
      AND    trxb2.tsu_code = 'PROCESSED'
      AND    trxb2.try_id = tryv.id;
Line: 4743

    l_delete_fee_service_lines(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_contract_id    => p_new2_contract_id);
Line: 4750

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'l_delete_fee_service_lines procedure completed with '
                                         || x_return_status || ' for second Split contract');
Line: 5282

      OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL(
                            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_source_id     => r_get_source_id.id,
                            p_source_table  => 'OKL_TXL_CNTRCT_LNS');
Line: 5298

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL
       procedure completed for first contract with status ' || x_return_status);
Line: 5312

      OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL(
                            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_source_id     => r_get_source_id.id,
                            p_source_table  => 'OKL_TXL_CNTRCT_LNS');
Line: 5328

      FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'OKL_ACCOUNT_DIST_PUB.UPDATE_POST_TO_GL
       procedure completed for second contract with status ' || x_return_status);
Line: 5376

      l_delete_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_contract_id    => p_new1_contract_id);
Line: 5389

      l_delete_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_contract_id    => p_new2_contract_id);
Line: 5425

      l_delete_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_contract_id    => p_new1_contract_id);
Line: 5438

      l_delete_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_contract_id    => p_new2_contract_id);
Line: 5474

      l_delete_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_contract_id    => p_new1_contract_id);
Line: 5487

      l_delete_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_contract_id    => p_new2_contract_id);