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_OKC_MIGRATION_PVT SQL Statements

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

Line: 41


   G_WF_EVT_CONTRACT_TERM_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_filing_terms_updated';

Line: 42


   G_WF_EVT_ASSET_FILING_UPDATED  CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_filing_updated';

Line: 43


   G_WF_EVT_ASSET_PROPTAX_UPDATED CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.asset_property_tax_updated';

Line: 44


   G_WF_EVT_SERV_PASS_UPDATED     CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.service_fee_passthrough_updated';

Line: 45


   G_WF_EVT_FEE_PASS_UPDATED      CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.fee_passthrough_updated';

Line: 46


   G_WF_EVT_SERV_FEXP_UPDATED     CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.service_fee_expense_updated';

Line: 47


   G_WF_EVT_FEE_EXP_UPDATED       CONSTANT VARCHAR2(70):= 'oracle.apps.okl.la.lease_contract.fee_expense_updated';

Line: 122


    p_to.last_updated_by := p_from.last_updated_by;

Line: 123


    p_to.last_update_date := p_from.last_update_date;

Line: 124


    p_to.last_update_login := p_from.last_update_login;

Line: 136


    p_to.last_updated_by := p_from.last_updated_by;

Line: 137


    p_to.last_update_date := p_from.last_update_date;

Line: 138


    p_to.last_update_login := p_from.last_update_login;

Line: 159


    p_to.deleted_yn := p_from.deleted_yn;

Line: 165


    p_to.last_updated_by := p_from.last_updated_by;

Line: 166


    p_to.last_update_date := p_from.last_update_date;

Line: 193


    p_to.last_update_login := p_from.last_update_login;

Line: 202


    p_to.program_update_date   := p_from.program_update_date;

Line: 268


    p_to.deleted_yn := p_from.deleted_yn;

Line: 274


    p_to.last_updated_by := p_from.last_updated_by;

Line: 275


    p_to.last_update_date := p_from.last_update_date;

Line: 302


    p_to.last_update_login := p_from.last_update_login;

Line: 311


    p_to.program_update_date   := p_from.program_update_date;

Line: 376


    p_to.last_updated_by := p_from.last_updated_by;

Line: 377


    p_to.last_update_date := p_from.last_update_date;

Line: 390


    p_to.last_update_login := p_from.last_update_login;

Line: 403


    p_to.program_update_date       := p_from.program_update_date;

Line: 471


    p_to.last_updated_by := p_from.last_updated_by;

Line: 472


    p_to.last_update_date := p_from.last_update_date;

Line: 485


    p_to.last_update_login := p_from.last_update_login;

Line: 498


    p_to.program_update_date       := p_from.program_update_date;

Line: 569


    x_cimv_rec_type.last_updated_by := p_cimv_rec_type.last_updated_by;

Line: 570


    x_cimv_rec_type.last_update_date := p_cimv_rec_type.last_update_date;

Line: 571


    x_cimv_rec_type.last_update_login := p_cimv_rec_type.last_update_login;

Line: 596


    x_cimv_rec_type.last_updated_by := p_cimv_rec_type.last_updated_by;

Line: 597


    x_cimv_rec_type.last_update_date := p_cimv_rec_type.last_update_date;

Line: 598


    x_cimv_rec_type.last_update_login := p_cimv_rec_type.last_update_login;

Line: 618


    x_cplv_rec_type.last_updated_by := p_cplv_rec_type.last_updated_by;

Line: 619


    x_cplv_rec_type.last_update_date := p_cplv_rec_type.last_update_date;

Line: 625


    x_cplv_rec_type.last_update_login := p_cplv_rec_type.last_update_login;

Line: 668


    x_cplv_rec_type.last_updated_by := p_cplv_rec_type.last_updated_by;

Line: 669


    x_cplv_rec_type.last_update_date := p_cplv_rec_type.last_update_date;

Line: 675


    x_cplv_rec_type.last_update_login := p_cplv_rec_type.last_update_login;

Line: 717


    p_to.last_updated_by := p_from.last_updated_by;

Line: 718


    p_to.last_update_date := p_from.last_update_date;

Line: 719


    p_to.last_update_login := p_from.last_update_login;

Line: 738


    p_to.last_updated_by := p_from.last_updated_by;

Line: 739


    p_to.last_update_date := p_from.last_update_date;

Line: 740


    p_to.last_update_login := p_from.last_update_login;

Line: 758


    x_ctcv_rec_type.last_updated_by := p_ctcv_rec_type.last_updated_by;

Line: 759


    x_ctcv_rec_type.last_update_date := p_ctcv_rec_type.last_update_date;

Line: 761


    x_ctcv_rec_type.last_update_login := p_ctcv_rec_type.last_update_login;

Line: 797


    x_ctcv_rec_type.last_updated_by := p_ctcv_rec_type.last_updated_by;

Line: 798


    x_ctcv_rec_type.last_update_date := p_ctcv_rec_type.last_update_date;

Line: 800


    x_ctcv_rec_type.last_update_login := p_ctcv_rec_type.last_update_login;

Line: 840


    p_to.last_updated_by := p_from.last_updated_by;

Line: 841


    p_to.last_update_date := p_from.last_update_date;

Line: 842


    p_to.last_update_login := p_from.last_update_login;

Line: 880


    p_to.last_updated_by := p_from.last_updated_by;

Line: 881


    p_to.last_update_date := p_from.last_update_date;

Line: 882


    p_to.last_update_login := p_from.last_update_login;

Line: 920


    p_to.last_updated_by := p_from.last_updated_by;

Line: 921


    p_to.last_update_date := p_from.last_update_date;

Line: 922


    p_to.last_update_login := p_from.last_update_login;

Line: 938


    p_to.last_updated_by := p_from.last_updated_by;

Line: 939


    p_to.last_update_date := p_from.last_update_date;

Line: 940


    p_to.last_update_login := p_from.last_update_login;

Line: 1151


     SELECT lse.lty_code lty_code,
           lines.id fee_line_id
     FROM okc_line_styles_b lse,
         okc_k_lines_b subline,
         okc_k_lines_b lines
     WHERE subline.id = p_line_id
     AND lines.id = subline.cle_id
     AND lse.id = subline.lse_id;

Line: 1365


  PROCEDURE update_contract_item(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cimv_rec                     IN cimv_rec_type,
    x_cimv_rec                     OUT NOCOPY cimv_rec_type) AS

    lr_cimv_rec_type_in            OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

Line: 1376


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_ITEM';

Line: 1381


    SELECT dnz_chr_id
    FROM   OKC_K_ITEMS_V
    WHERE  id = p_id;

Line: 1448


    OKC_CONTRACT_ITEM_PUB.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      => lr_cimv_rec_type_in,
                                               x_cimv_rec      => lr_cimv_rec_type_out);

Line: 1493


   END update_contract_item;

Line: 1495


  PROCEDURE update_contract_item(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_cimv_tbl      IN  cimv_tbl_type,
    x_cimv_tbl      OUT NOCOPY  cimv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_ITEM';

Line: 1512


         update_contract_item(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_cimv_rec      =>p_cimv_tbl(i),
                             x_cimv_rec      =>x_cimv_tbl(i));

Line: 1558


   END update_contract_item;

Line: 1560


  PROCEDURE delete_contract_item(
    p_api_version   IN  NUMBER,
    p_init_msg_list IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY  VARCHAR2,
    x_msg_count     OUT NOCOPY  NUMBER,
    x_msg_data      OUT NOCOPY  VARCHAR2,
    p_cimv_rec      IN  cimv_rec_type) AS

    lr_cimv_rec_type_in            OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

Line: 1569


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_K_ITEM';

Line: 1590


    OKC_CONTRACT_ITEM_PUB.delete_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      => lr_cimv_rec_type_in);

Line: 1628


   END delete_contract_item;

Line: 1630


  PROCEDURE delete_contract_item(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_cimv_tbl      IN  cimv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_ITEM';

Line: 1646


         delete_contract_item(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_cimv_rec      =>p_cimv_tbl(i));

Line: 1691


   END delete_contract_item;

Line: 1707


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

Line: 1935


  PROCEDURE update_k_party_role(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cplv_rec                     IN cplv_rec_type,
    x_cplv_rec                     OUT NOCOPY cplv_rec_type) AS

    lr_cplv_rec_type_in            OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

Line: 1946


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';

Line: 1949


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

Line: 2008


    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      => lr_cplv_rec_type_in,
                                               x_cplv_rec      => lr_cplv_rec_type_out);

Line: 2075


   END update_k_party_role;

Line: 2077


  PROCEDURE update_k_party_role(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_cplv_tbl      IN  cplv_tbl_type,
    x_cplv_tbl      OUT NOCOPY  cplv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_K_PARTY_ROLE';

Line: 2094


         update_k_party_role(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_cplv_rec      =>p_cplv_tbl(i),
                             x_cplv_rec      =>x_cplv_tbl(i));

Line: 2140


   END update_k_party_role;

Line: 2142


  PROCEDURE delete_k_party_role(
    p_api_version   IN  NUMBER,
    p_init_msg_list IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY  VARCHAR2,
    x_msg_count     OUT NOCOPY  NUMBER,
    x_msg_data      OUT NOCOPY  VARCHAR2,
    p_cplv_rec      IN  cplv_rec_type) AS

    lr_cplv_rec_type_in            OKC_CONTRACT_PARTY_PUB.cplv_rec_type;

Line: 2151


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_K_PARTY_ROLE';

Line: 2155


    SELECT DNZ_CHR_ID
    FROM   OKC_K_PARTY_ROLES_B
    WHERE  ID = P_CPL_ID;

Line: 2217


    OKC_CONTRACT_PARTY_PUB.delete_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      => lr_cplv_rec_type_in);

Line: 2255


   END delete_k_party_role;

Line: 2257


  PROCEDURE delete_k_party_role(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_cplv_tbl      IN  cplv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_K_PARTY_ROLE';

Line: 2273


         delete_k_party_role(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_cplv_rec      =>p_cplv_tbl(i));

Line: 2318


   END delete_k_party_role;

Line: 2335


    SELECT  access_level
    FROM    OKC_CONTACT_SOURCES a, okc_k_party_roles_b b
    WHERE  a.cro_code = p_cro_code
    AND    b.id       = p_cpl_id
    AND    a.rle_code = b.rle_code
    AND    a.buy_or_sell = 'S';

Line: 2527


  PROCEDURE update_contact(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ctcv_rec                     IN ctcv_rec_type,
    x_ctcv_rec                     OUT NOCOPY ctcv_rec_type) AS

    lr_ctcv_rec_type_in            OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

Line: 2538


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_CONTACT';

Line: 2541


    SELECT  access_level
    FROM    OKC_CONTACT_SOURCES a, okc_k_party_roles_b b
    WHERE  a.cro_code = p_cro_code
    AND    b.id       = p_cpl_id
    AND    a.rle_code = b.rle_code
    AND    a.buy_or_sell = 'S';

Line: 2601


    OKC_CONTRACT_PARTY_PUB.update_contact(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_ctcv_rec      => lr_ctcv_rec_type_in,
                                          x_ctcv_rec      => lr_ctcv_rec_type_out);

Line: 2667


   END update_contact;

Line: 2669


  PROCEDURE update_contact(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_ctcv_tbl      IN  ctcv_tbl_type,
    x_ctcv_tbl      OUT NOCOPY  ctcv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_CONTACT';

Line: 2686


         update_contact(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_ctcv_rec      =>p_ctcv_tbl(i),
                             x_ctcv_rec      =>x_ctcv_tbl(i));

Line: 2732


   END update_contact;

Line: 2734


  PROCEDURE delete_contact(
    p_api_version   IN  NUMBER,
    p_init_msg_list IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY  VARCHAR2,
    x_msg_count     OUT NOCOPY  NUMBER,
    x_msg_data      OUT NOCOPY  VARCHAR2,
    p_ctcv_rec      IN  ctcv_rec_type) AS

    lr_ctcv_rec_type_in            OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;

Line: 2743


    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_CONTACT';

Line: 2747


    SELECT DNZ_CHR_ID
    FROM   OKC_CONTACTS
    WHERE  ID = P_CTC_ID;

Line: 2807


    OKC_CONTRACT_PARTY_PUB.delete_contact(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_ctcv_rec      => lr_ctcv_rec_type_in);

Line: 2845


   END delete_contact;

Line: 2847


  PROCEDURE delete_contact(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_ctcv_tbl      IN  ctcv_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_CONTACT';

Line: 2863


         delete_contact(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_ctcv_rec      =>p_ctcv_tbl(i));

Line: 2908


   END delete_contact;

Line: 3006


PROCEDURE update_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_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 OKC_API.G_FALSE,
    p_chrv_rec                     IN chrv_rec_type,
    x_chrv_rec                     OUT NOCOPY chrv_rec_type) IS

    l_chrv_rec      chrv_rec_type;

Line: 3019


    l_api_name      CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';

Line: 3048


    OKC_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_okc_chrv_rec_in,
      x_chrv_rec            => l_okc_chrv_rec_out);

Line: 3099


  END update_contract_header;

Line: 3102


  PROCEDURE delete_contract_header(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_chrv_rec                     IN chrv_rec_type) IS

    l_chrv_rec      chrv_rec_type;

Line: 3113


    l_api_name      CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';

Line: 3141


    OKC_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_okc_chrv_rec_in);

Line: 3187


  END delete_contract_header;

Line: 3369


    p_restricted_update            IN VARCHAR2 DEFAULT 'F',
    p_clev_rec                     IN  clev_rec_type,
    x_clev_rec                     OUT NOCOPY  clev_rec_type) IS

    l_clev_rec      clev_rec_type;

Line: 3408


                     p_restricted_update  => p_restricted_update,
                     p_clev_rec       => l_okc_clev_rec_in,
                     x_clev_rec       => l_okc_clev_rec_out);

Line: 3461


    p_restricted_update         IN VARCHAR2 DEFAULT 'F',
    p_clev_tbl                     IN clev_tbl_type,
    x_clev_tbl                     OUT NOCOPY clev_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_CREATE_LINE';

Line: 3478


                             p_restricted_update => p_restricted_update,
                             p_clev_rec          =>p_clev_tbl(i),
                             x_clev_rec          =>x_clev_tbl(i));

Line: 3522


  PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_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 OKC_API.G_FALSE,
    p_clev_rec                     IN  clev_rec_type,
    x_clev_rec                     OUT NOCOPY clev_rec_type) IS

    l_clev_rec      clev_rec_type;

Line: 3535


    l_api_name      CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';

Line: 3564


    OKC_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_restricted_update    => p_restricted_update,
      p_clev_rec            => l_okc_clev_rec_in,
      x_clev_rec            => l_okc_clev_rec_out);

Line: 3614


  END update_contract_line;

Line: 3616


    PROCEDURE update_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_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 OKC_API.G_FALSE,
    p_clev_tbl                     IN clev_tbl_type,
    x_clev_tbl                     OUT NOCOPY clev_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_UPDATE_LINE';

Line: 3634


         update_contract_line(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             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_clev_rec      =>p_clev_tbl(i),
                             x_clev_rec      =>x_clev_tbl(i));

Line: 3681


   END update_contract_line;

Line: 3684


  PROCEDURE delete_contract_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_clev_rec                     IN clev_rec_type) IS

    l_clev_rec      clev_rec_type;

Line: 3695


    l_api_name      CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';

Line: 3723


    OKC_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_clev_rec        => l_okc_clev_rec_in);

Line: 3770


  END delete_contract_line;

Line: 3772


PROCEDURE delete_contract_line(
    p_api_version   IN NUMBER,
    p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count     OUT NOCOPY NUMBER,
    x_msg_data      OUT NOCOPY VARCHAR2,
    p_clev_tbl      IN  clev_tbl_type) AS

    l_api_name            CONSTANT VARCHAR2(30) := 'OKL_DELETE_LINE';

Line: 3788


         delete_contract_line(p_api_version   =>p_api_version,
                             p_init_msg_list =>OKC_API.G_FALSE,
                             x_return_status =>x_return_status,
                             x_msg_count     =>x_msg_count,
                             x_msg_data      =>x_msg_data,
                             p_clev_rec      =>p_clev_tbl(i));

Line: 3833


   END delete_contract_line;

Line: 4097


  PROCEDURE update_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN gvev_rec_type,
    x_gvev_rec                     OUT NOCOPY gvev_rec_type) IS

    l_gvev_rec      gvev_rec_type;

Line: 4109


    l_api_name      CONSTANT VARCHAR2(30) := 'UPDATE_GOVERNANCE';

Line: 4137


    OKC_CONTRACT_PUB.update_governance(
     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_gvev_rec        => l_okc_gvev_rec_in,
      x_gvev_rec        => l_okc_gvev_rec_out);

Line: 4187


  END update_governance;

Line: 4190


  PROCEDURE delete_governance(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_gvev_rec                     IN gvev_rec_type) IS

    l_gvev_rec      gvev_rec_type;

Line: 4201


    l_api_name      CONSTANT VARCHAR2(30) := 'DELETE_GOVERNANCE';

Line: 4228


    OKC_CONTRACT_PUB.delete_governance(
     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_gvev_rec        => l_okc_gvev_rec_in);

Line: 4275


  END delete_governance;

Line: 4471


    SELECT FND_GLOBAL.conc_request_id
      FROM dual;

Line: 4475


    SELECT lty_code
      FROM okc_k_lines_b line,
           okc_line_styles_b style
     WHERE line.lse_id = style.id
       AND line.id = p_line_id;

Line: 4485


    SELECT rlobj.object1_id1
      FROM okc_k_rel_objs_v rlobj
     WHERE rlobj.chr_id = p_chr_id
       AND rlobj.cle_id = p_line_id
       AND rlobj.rty_code = 'OKLSRV'
       AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';

Line: 4495


    SELECT dnz_chr_id
      FROM okc_k_lines_b
     WHERE id = p_serv_top_line_id;

Line: 4558


           l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;

Line: 4567


           l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;

Line: 4572


           l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

Line: 4581


             l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;

Line: 4599


             l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;

Line: 4609


             l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;

Line: 4625


             l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

Line: 4682


PROCEDURE update_rule_group(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type,
    x_rgpv_rec                     OUT NOCOPY rgpv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 4692


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_rule_group';

Line: 4712


    OKC_RULE_PUB.update_rule_group(
      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_rgpv_rec      => l_okc_rgpv_rec_in,
      x_rgpv_rec      => l_okc_rgpv_rec_out);

Line: 4760


  PROCEDURE delete_rule_group(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 4788


    OKC_RULE_PUB.delete_rule_group(
      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_rgpv_rec      => l_okc_rgpv_rec_in);

Line: 5053


  PROCEDURE update_rg_mode_pty_role(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rmpv_rec                     IN  rmpv_rec_type,
    x_rmpv_rec                     OUT NOCOPY rmpv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 5063


    l_api_name                     CONSTANT VARCHAR2(30) := 'update_rg_mode_pty_role';

Line: 5082


    OKC_RULE_PUB.update_rg_mode_pty_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_rmpv_rec      => l_okc_rmpv_rec_in,
      x_rmpv_rec      => l_okc_rmpv_rec_in);

Line: 5127


  END update_rg_mode_pty_role;

Line: 5129


  PROCEDURE delete_rg_mode_pty_role(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rmpv_rec                     IN  rmpv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 5138


    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_rg_mode_pty_role';

Line: 5157


    OKC_RULE_PUB.delete_rg_mode_pty_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_rmpv_rec      => l_okc_rmpv_rec_in);

Line: 5197


  END delete_rg_mode_pty_role;