eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEC_AGREEMENT_PVT SQL Statements

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

Line: 136


    SELECT mo_global.get_current_org_id() l_fnd_profile
    FROM dual;

Line: 141


    select cust_trx_type_id l_cust_trx_type_id
    from ra_cust_trx_types
    where name = 'Investor-OKL';

Line: 147


    select ct.object1_id1 id
    from   okc_contacts        ct,
           okc_contact_sources csrc,
           okc_k_party_roles_b pty,
           okc_k_headers_b     chr
    where  ct.cpl_id               = pty.id
          and    ct.cro_code             = csrc.cro_code
          and    ct.jtot_object1_code    = csrc.jtot_object_code
          and    ct.dnz_chr_id           =  chr.id
          and    pty.rle_code            = csrc.rle_code
          and    csrc.cro_code           = 'SALESPERSON'
          and    csrc.rle_code           = 'LESSOR'
          and    csrc.buy_or_sell        = chr.buy_or_sell
          and    pty.dnz_chr_id          = chr.id
          and    pty.chr_id              = chr.id
          and    chr.id                  = chrId;

Line: 168


    select object1_id1 cust_acct_site_id
    from okc_rules_b rul
    where  rul.rule_information_category = 'BTO'
         and exists (select '1'
                     from okc_rule_groups_b rgp
                     where rgp.id = rul.rgp_id
                          and   rgp.rgd_code = 'LABILL'
                          and   rgp.dnz_chr_id = chrId );

Line: 180


    SELECT pdt.id                       product_id
          ,pdt.name                     product_name
          ,khr.sts_code                 contract_status
          ,khr.start_date               start_date
          ,khr.currency_code            currency_code
          ,khr.authoring_org_id         authoring_org_id
          ,khr.currency_conversion_rate currency_conversion_rate
          ,khr.currency_conversion_type currency_conversion_type
          ,khr.currency_conversion_date currency_conversion_date
          --Bug# 4622198
          ,khr.scs_code
    FROM   okl_products_v        pdt
          ,okl_k_headers_full_v  khr
    WHERE  khr.id = p_contract_id
    AND    khr.pdt_id = pdt.id;

Line: 203


    SELECT id       trx_try_id
    FROM  okl_trx_types_tl
    WHERE  name = p_transaction_type
         AND LANGUAGE = 'US';

Line: 209


    SELECT description,
           lookup_code
    FROM   fnd_lookup_values
    WHERE LANGUAGE = 'US'
         AND lookup_type = lkp_type
         AND meaning = mng;

Line: 217


    SELECT txh.ID HeaderTransID,
           txl.ID LineTransID,
           txh.date_transaction_occurred date_transaction_occurred
    FROM okl_trx_contracts txh,
         okl_txl_cntrct_lns txl
    WHERE  txl.tcn_id = txh.id
         AND txh.tcn_type = tcntype
   --rkuttiya added for 12.1.1 Multi GAAP
         AND  txh.representation_type = 'PRIMARY'
     --
         AND txl.khr_id = khrId;

Line: 232


      SELECT rul.rule_information1 investor_code
    FROM okc_rules_b rul,
         okc_rule_groups_b rgp
    WHERE rgp.id = rul.rgp_id
    AND   rul.rule_information_category = G_RULE_GRP_LASEAC --'LASEAC'
    AND   rgp.rgd_code = G_RULE_LASEAC --'LASEAC'
    AND   rul.dnz_chr_id = chrId
    ;

Line: 681


	       -- Pls. update this code appropriately in future, if only accounting distribution
	       -- alone should be done while activating an Investor Agreement with already existing
	       -- Accounting entries
		    --------------------------------------------------------------------------
		    -- Refer transaction line ID if already exists -- future needs
		    --------------------------------------------------------------------------

			l_dist_info_rec.SOURCE_ID := l_trx_rec.LineTransId;

Line: 731


	    --need to be updated back on the contract
	    l_tclv_tbl := x_tclv_tbl;

Line: 805


    Okl_Trx_Contracts_Pub.update_trx_contracts(
             p_api_version      => l_api_version
            ,p_init_msg_list    => l_init_msg_list
            ,x_return_status    => l_return_status
            ,x_msg_count        => l_msg_count
            ,x_msg_data         => l_msg_data
            ,p_tcnv_rec         => l_trxH_in_rec
            ,x_tcnv_rec         => l_trxH_out_rec);

Line: 820


    Okl_Trx_Contracts_Pub.update_trx_cntrct_lines(
             p_api_version      => l_api_version
            ,p_init_msg_list    => l_init_msg_list
            ,x_return_status    => l_return_status
            ,x_msg_count        => l_msg_count
            ,x_msg_data         => l_msg_data
 	    ,p_tclv_tbl         => l_tclv_tbl
            ,x_tclv_tbl         => x_tclv_tbl);

Line: 902


    SELECT 'X'
      FROM okc_k_headers_b k
     WHERE k.contract_number = p_contract_number
    ;

Line: 909


    SELECT 'X'
      FROM okc_k_headers_b k
     WHERE k.contract_number = p_contract_number
     AND   k.id <> p_id -- except itself
  ;

Line: 973


  SELECT 'x'
  FROM okl_products_v
  WHERE id = p_secAgreement_rec.pdt_id
;

Line: 1042


  SELECT 'x'
  FROM okl_pools
  WHERE id = p_secAgreement_rec.pol_id
;

Line: 1108


  SELECT 'x'
  FROM okl_pools
  WHERE khr_id IS NOT NULL
  AND id = p_secAgreement_rec.pol_id
;

Line: 1115


  SELECT 'x'
  FROM okl_pools
  WHERE khr_id IS NOT NULL
  AND id = p_secAgreement_rec.pol_id
  AND khr_id <> p_secAgreement_rec.id
;

Line: 1263


  SELECT 'x'
  FROM fnd_lookups
  WHERE lookup_type = 'OKL_SECURITIZATION_TYPE'
  AND lookup_code = p_secAgreement_rec.SECURITIZATION_TYPE
;

Line: 1332


  SELECT 'x'
  FROM fnd_lookups
  WHERE lookup_type = 'OKL_SEC_RECOURSE'
;

Line: 1386


  SELECT 'x'
  FROM fnd_lookups
  WHERE lookup_type = 'OKL_SEC_SERVICE_ORG'
;

Line: 1578


 SELECT qcl.id
   FROM  OKC_QA_CHECK_LISTS_TL qcl,
         OKC_QA_CHECK_LISTS_B qclv
   WHERE qclv.Id = qcl.id
          AND UPPER(qcl.name) = 'OKL LA QA INVESTOR AGMNT'
          AND qcl.LANGUAGE = 'US'
;

Line: 1588


    SELECT  access_level
    FROM    OKC_ROLE_SOURCES
    WHERE rle_code = p_rle_code
    AND     buy_or_sell = 'S';

Line: 1662


    lp_chrv_rec.deleted_yn := 'N';

Line: 1922


      OKL_POOL_PVT.update_pool(
        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_polv_rec      => l_polv_rec,
        x_polv_rec      => x_polv_rec);

Line: 1984


 PROCEDURE update_sec_agreement(
    p_api_version                  IN NUMBER
   ,p_init_msg_list                IN VARCHAR2
   ,x_return_status                OUT NOCOPY VARCHAR2
   ,x_msg_count                    OUT NOCOPY NUMBER
   ,x_msg_data                     OUT NOCOPY VARCHAR2
   ,p_secAgreement_rec             IN secAgreement_rec_type
   ,x_secAgreement_rec             OUT NOCOPY secAgreement_rec_type)
IS
  l_api_name         CONSTANT VARCHAR2(30) := 'update_sec_agreement_pvt';

Line: 2015


SELECT id
FROM okl_pools
WHERE khr_id = p_secAgreement_rec.id
AND id <> p_secAgreement_rec.pol_id
;

Line: 2026


SELECT cle.id
FROM  apps.okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_khr_id
;

Line: 2033


SELECT clet.id
FROM   okc_k_lines_b clet
WHERE  clet.dnz_chr_id = p_khr_id
AND    clet.cle_id IS NULL;

Line: 2040


SELECT cles.id
FROM   okc_k_lines_b cles
WHERE  cles.dnz_chr_id = p_khr_id
AND    cles.cle_id     = p_kle_id;

Line: 2047


SELECT  access_level
FROM    OKC_ROLE_SOURCES
WHERE rle_code = p_rle_code
AND     buy_or_sell = 'S';

Line: 2057


  SAVEPOINT update_sec_agreement_PVT;

Line: 2129


    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_chrv_rec       => lp_chrv_rec,
      p_khrv_rec       => lp_khrv_rec,
      x_chrv_rec       => lx_chrv_rec,
      x_khrv_rec       => lx_khrv_rec);

Line: 2230


    OKC_CONTRACT_PARTY_PUB.update_k_party_role(
      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_cplv_rec       => lp_cplv_rec,
      x_cplv_rec       => lx_cplv_rec);

Line: 2274


      OKL_POOL_PVT.update_pool(
        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_polv_rec      => l_polv_rec,
        x_polv_rec      => x_polv_rec);

Line: 2299


      OKL_POOL_PVT.update_pool(
        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_polv_rec      => l_polv_rec,
        x_polv_rec      => x_polv_rec);

Line: 2341


    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      => lp_clev_rec,
      p_klev_rec      => lp_klev_rec,
      x_clev_rec      => lx_clev_rec,
      x_klev_rec      => lx_klev_rec);

Line: 2372


      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      => lp_clev_rec,
        p_klev_rec      => lp_klev_rec,
        x_clev_rec      => lx_clev_rec,
        x_klev_rec      => lx_klev_rec);

Line: 2398


      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      => lp_clev_rec,
        p_klev_rec      => lp_klev_rec,
        x_clev_rec      => lx_clev_rec,
        x_klev_rec      => lx_klev_rec);

Line: 2428


    ROLLBACK TO update_sec_agreement_PVT;

Line: 2436


    ROLLBACK TO update_sec_agreement_PVT;

Line: 2443


	ROLLBACK TO update_sec_agreement_PVT;

Line: 2509


SELECT pol.id,
       pol.currency_code,
       pol.org_id,
       pol.legal_entity_id
FROM okl_pools pol
WHERE pol.khr_id = p_khr_id
;

Line: 2518


SELECT poc.id
FROM okl_pool_contents poc
WHERE poc.pol_id = l_pol_id
;

Line: 2526


SELECT poc.khr_id
FROM  apps.okl_pool_contents poc
WHERE poc.pol_id = l_pol_id
;

Line: 2532


SELECT poc.khr_id
FROM  okl_pool_contents poc
WHERE poc.pol_id = l_pol_id
;

Line: 2543


  SELECT 1
  FROM   okl_pools polb
	    ,okl_strm_type_b styb
	    ,okl_pool_contents pocb
  WHERE  polb.khr_id = p_khr_id
  AND    pocb.pol_id = polb.id
  AND    pocb.sty_id = styb.id
  AND    styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
    AND pocb.status_code='NEW';

Line: 2672


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');

Line: 2673


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');

Line: 2694


    OKL_POOL_PVT.update_pool_contents(
        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_pocv_rec      => lp_pocv_rec,
        x_pocv_rec      => lx_pocv_rec);

Line: 2705


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);

Line: 2717


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');

Line: 2729


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');

Line: 2747


    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_chrv_rec      => lp_chrv_rec,
      p_khrv_rec      => lp_khrv_rec,
      x_chrv_rec      => lx_chrv_rec,
      x_khrv_rec      => lx_khrv_rec);

Line: 2759


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

Line: 2771


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');

Line: 2988


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');

Line: 2989


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');

Line: 2992


    Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(
      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_sec_agreement_status  => G_STS_CODE_ACTIVE,
      p_sec_agreement_id      => p_khr_id);

Line: 3002


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Sec_Agreement_Pvt.update_sec_agreement_sts x_return_status :' || x_return_status);

Line: 3012


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: END');

Line: 3020


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');

Line: 3021


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');

Line: 3024


    OKL_POOL_PVT.update_pool_status_active(
        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_pol_id        => l_pol_id);

Line: 3033


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

Line: 3043


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: END');

Line: 3095


 PROCEDURE update_sec_agreement_sts(
    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_sec_agreement_status         IN okc_k_headers_b.sts_code%TYPE
   ,p_sec_agreement_id             IN okc_k_headers_b.id%TYPE)
IS
  l_api_name         CONSTANT VARCHAR2(30) := 'update_sec_agreement_sts';

Line: 3129


SELECT cle.id
FROM  apps.okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_sec_agreement_id
;

Line: 3135


SELECT cle.id
FROM  okc_k_lines_b cle
WHERE cle.dnz_chr_id = p_sec_agreement_id
;

Line: 3142


  SAVEPOINT update_sec_agreement_sts_PVT;

Line: 3172


    Okl_Sec_Agreement_Pvt.update_sec_agreement(
      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_secagreement_rec => lp_secagreement_rec,
      x_secagreement_rec => lx_secagreement_rec);

Line: 3207


    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      => lp_clev_rec,
      p_klev_rec      => lp_klev_rec,
      x_clev_rec      => lx_clev_rec,
      x_klev_rec      => lx_klev_rec);

Line: 3237


    ROLLBACK TO update_sec_agreement_sts_PVT;

Line: 3244


    ROLLBACK TO update_sec_agreement_sts_PVT;

Line: 3251


	ROLLBACK TO update_sec_agreement_sts_PVT;

Line: 3263


END update_sec_agreement_sts;

Line: 3284


	SELECT ID
	FROM OKL_POOLS
	WHERE KHR_ID = p_chr_id
	AND STATUS_CODE = 'ACTIVE';

Line: 3449


    SELECT pol.id
    FROM okl_pools pol
    WHERE pol.khr_id = p_khr_id;

Line: 3455


    SELECT poc.khr_id,
           poc.id
    FROM  okl_pool_contents poc
    WHERE poc.pol_id = p_pol_id
	AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;

Line: 3468


    SELECT 1
    FROM   okl_pools polb
	      ,okl_strm_type_b styb
	      ,okl_pool_contents pocb
    WHERE  polb.khr_id = p_khr_id
    AND    pocb.pol_id = polb.id
    AND    pocb.sty_id = styb.id
  AND    styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
  AND pocb.status_code='PENDING';

Line: 3482


	SELECT POX.ID
	FROM OKL_POOL_TRANSACTIONS POX
	WHERE POX.POL_ID = p_pol_id
	AND POX.TRANSACTION_STATUS = 'APPROVED'
	AND POX.TRANSACTION_TYPE = 'ADD'
	AND POX.TRANSACTION_REASON = 'ADJUSTMENTS';

Line: 3493


    SELECT TOP_KLE.ID,
           TOP_KLE.AMOUNT original_Stake,
           TOP_KLE.AMOUNT_STAKE additional_Stake
    FROM OKC_K_LINES_B        TOP_LINE,
         OKL_K_LINES          TOP_KLE,
         OKC_K_PARTY_ROLES_B  PARTY_ROLE
    WHERE TOP_LINE.dnz_chr_id       = p_khr_id
    AND   TOP_KLE.ID                = TOP_LINE.ID
    AND   PARTY_ROLE.cle_id         = TOP_LINE.id
    AND   PARTY_ROLE.dnz_chr_id     = TOP_LINE.dnz_chr_id
    AND   PARTY_ROLE.rle_code       = 'INVESTOR'
    AND   PARTY_ROLE.jtot_object1_code = 'OKX_PARTY';

Line: 3602


	   --Update the status of the Pool Transaction to INCOMPLETE and Halt processing
       lp_poxv_rec.id := l_pox_id;

Line: 3606


       OKL_POOL_PVT.update_pool_transaction(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_poxv_rec      => lp_poxv_rec,
                                         x_poxv_rec      => lx_poxv_rec);

Line: 3630


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');

Line: 3646


      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_chrv_rec      => lp_chrv_rec,
         p_khrv_rec      => lp_khrv_rec,
         x_chrv_rec      => lx_chrv_rec,
         x_khrv_rec      => lx_khrv_rec);

Line: 3658


         fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

Line: 3670


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');

Line: 3853


        fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

Line: 3863


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


          fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);

Line: 3893


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool contents status to active: START');

Line: 3894


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');

Line: 3903


      Okl_Pool_Pvt.update_pool_contents(
        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_pocv_rec      => lp_pocv_rec,
        x_pocv_rec      => lx_pocv_rec);

Line: 3913


        fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

Line: 3926


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');

Line: 3927


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');

Line: 3934


    OKL_POOL_PVT.update_pool_transaction(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_poxv_rec      => lp_poxv_rec,
                                         x_poxv_rec      => lx_poxv_rec);

Line: 3950


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_transaction x_return_status :' || x_return_status);

Line: 3960


      fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Update investor stake');

Line: 4034


    SELECT pox.id
    FROM okl_pool_transactions pox
    WHERE pox.pol_id = p_pool_id
    AND pox.TRANSACTION_STATUS IN (G_POOL_TRX_STATUS_NEW, G_POOL_TRX_STS_APPR_REJECTED, G_POOL_TRX_STATUS_INCOMPLETE);

Line: 4103


      OKL_POOL_PVT.update_pool_transaction(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_poxv_rec      => lp_poxv_rec,
                                         x_poxv_rec      => lx_poxv_rec);

Line: 4125


      OKL_POOL_PVT.update_pool_transaction(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_poxv_rec      => lp_poxv_rec,
                                         x_poxv_rec      => lx_poxv_rec);

Line: 4143


      OKL_POOL_PVT.update_pool_transaction(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_poxv_rec      => lp_poxv_rec,
                                           x_poxv_rec      => lx_poxv_rec);

Line: 4246


  SELECT ID
  FROM OKL_POOLS
  WHERE KHR_ID = p_chr_id
  AND STATUS_CODE = 'ACTIVE';

Line: 4253


  SELECT ID
  FROM OKL_POOL_TRANSACTIONS
  WHERE pol_id = p_pol_id
  AND TRANSACTION_STATUS <> 'COMPLETE';

Line: 4261


  SELECT ID
  FROM OKL_POOL_CONTENTS
  WHERE pox_id = p_pox_id
  AND STATUS_CODE <> 'ACTIVE';

Line: 4269


    SELECT TOP_KLE.ID,
           TOP_KLE.AMOUNT original_Stake,
           TOP_KLE.AMOUNT_STAKE additional_Stake
    FROM OKC_K_LINES_B        TOP_LINE,
         OKL_K_LINES          TOP_KLE,
         OKC_K_PARTY_ROLES_B  PARTY_ROLE
    WHERE TOP_LINE.dnz_chr_id       = p_khr_id
    AND   TOP_KLE.ID                = TOP_LINE.ID
    AND   PARTY_ROLE.cle_id         = TOP_LINE.id
    AND   PARTY_ROLE.dnz_chr_id     = TOP_LINE.dnz_chr_id
    AND   PARTY_ROLE.rle_code       = 'INVESTOR'
    AND   PARTY_ROLE.jtot_object1_code = 'OKX_PARTY';

Line: 4353


           OKL_POC_PVT.delete_row(
                                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_pocv_tbl => l_pocv_tbl);

Line: 4373


           OKL_POX_PVT.delete_row(
                                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_poxv_rec => l_poxv_rec);

Line: 4391


        fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

Line: 4401


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


          fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.cancel_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);