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


    p_to.last_updated_by := p_from.last_updated_by;

Line: 114


    p_to.last_update_date := p_from.last_update_date;

Line: 115


    p_to.last_update_login := p_from.last_update_login;

Line: 127


    p_to.last_updated_by := p_from.last_updated_by;

Line: 128


    p_to.last_update_date := p_from.last_update_date;

Line: 129


    p_to.last_update_login := p_from.last_update_login;

Line: 150


    p_to.deleted_yn := p_from.deleted_yn;

Line: 156


    p_to.last_updated_by := p_from.last_updated_by;

Line: 157


    p_to.last_update_date := p_from.last_update_date;

Line: 184


    p_to.last_update_login := p_from.last_update_login;

Line: 193


    p_to.program_update_date   := p_from.program_update_date;

Line: 259


    p_to.deleted_yn := p_from.deleted_yn;

Line: 265


    p_to.last_updated_by := p_from.last_updated_by;

Line: 266


    p_to.last_update_date := p_from.last_update_date;

Line: 293


    p_to.last_update_login := p_from.last_update_login;

Line: 302


    p_to.program_update_date   := p_from.program_update_date;

Line: 367


    p_to.last_updated_by := p_from.last_updated_by;

Line: 368


    p_to.last_update_date := p_from.last_update_date;

Line: 381


    p_to.last_update_login := p_from.last_update_login;

Line: 394


    p_to.program_update_date       := p_from.program_update_date;

Line: 462


    p_to.last_updated_by := p_from.last_updated_by;

Line: 463


    p_to.last_update_date := p_from.last_update_date;

Line: 476


    p_to.last_update_login := p_from.last_update_login;

Line: 489


    p_to.program_update_date       := p_from.program_update_date;

Line: 560


    x_cimv_rec_type.last_updated_by := p_cimv_rec_type.last_updated_by;

Line: 561


    x_cimv_rec_type.last_update_date := p_cimv_rec_type.last_update_date;

Line: 562


    x_cimv_rec_type.last_update_login := p_cimv_rec_type.last_update_login;

Line: 587


    x_cimv_rec_type.last_updated_by := p_cimv_rec_type.last_updated_by;

Line: 588


    x_cimv_rec_type.last_update_date := p_cimv_rec_type.last_update_date;

Line: 589


    x_cimv_rec_type.last_update_login := p_cimv_rec_type.last_update_login;

Line: 609


    x_cplv_rec_type.last_updated_by := p_cplv_rec_type.last_updated_by;

Line: 610


    x_cplv_rec_type.last_update_date := p_cplv_rec_type.last_update_date;

Line: 616


    x_cplv_rec_type.last_update_login := p_cplv_rec_type.last_update_login;

Line: 659


    x_cplv_rec_type.last_updated_by := p_cplv_rec_type.last_updated_by;

Line: 660


    x_cplv_rec_type.last_update_date := p_cplv_rec_type.last_update_date;

Line: 666


    x_cplv_rec_type.last_update_login := p_cplv_rec_type.last_update_login;

Line: 708


    p_to.last_updated_by := p_from.last_updated_by;

Line: 709


    p_to.last_update_date := p_from.last_update_date;

Line: 710


    p_to.last_update_login := p_from.last_update_login;

Line: 729


    p_to.last_updated_by := p_from.last_updated_by;

Line: 730


    p_to.last_update_date := p_from.last_update_date;

Line: 731


    p_to.last_update_login := p_from.last_update_login;

Line: 749


    x_ctcv_rec_type.last_updated_by := p_ctcv_rec_type.last_updated_by;

Line: 750


    x_ctcv_rec_type.last_update_date := p_ctcv_rec_type.last_update_date;

Line: 752


    x_ctcv_rec_type.last_update_login := p_ctcv_rec_type.last_update_login;

Line: 788


    x_ctcv_rec_type.last_updated_by := p_ctcv_rec_type.last_updated_by;

Line: 789


    x_ctcv_rec_type.last_update_date := p_ctcv_rec_type.last_update_date;

Line: 791


    x_ctcv_rec_type.last_update_login := p_ctcv_rec_type.last_update_login;

Line: 831


    p_to.last_updated_by := p_from.last_updated_by;

Line: 832


    p_to.last_update_date := p_from.last_update_date;

Line: 833


    p_to.last_update_login := p_from.last_update_login;

Line: 871


    p_to.last_updated_by := p_from.last_updated_by;

Line: 872


    p_to.last_update_date := p_from.last_update_date;

Line: 873


    p_to.last_update_login := p_from.last_update_login;

Line: 911


    p_to.last_updated_by := p_from.last_updated_by;

Line: 912


    p_to.last_update_date := p_from.last_update_date;

Line: 913


    p_to.last_update_login := p_from.last_update_login;

Line: 929


    p_to.last_updated_by := p_from.last_updated_by;

Line: 930


    p_to.last_update_date := p_from.last_update_date;

Line: 931


    p_to.last_update_login := p_from.last_update_login;

Line: 1098


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


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


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

Line: 1328


    SELECT dnz_chr_id
    FROM   OKC_K_ITEMS_V
    WHERE  id = p_id;

Line: 1395


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


   END update_contract_item;

Line: 1442


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


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


   END update_contract_item;

Line: 1507


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


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

Line: 1537


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


   END delete_contract_item;

Line: 1577


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


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


   END delete_contract_item;

Line: 1654


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

Line: 1882


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


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

Line: 1896


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

Line: 1955


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


   END update_k_party_role;

Line: 2024


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


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


   END update_k_party_role;

Line: 2089


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


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

Line: 2102


    SELECT DNZ_CHR_ID
    FROM   OKC_K_PARTY_ROLES_B
    WHERE  ID = P_CPL_ID;

Line: 2164


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


   END delete_k_party_role;

Line: 2204


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


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


   END delete_k_party_role;

Line: 2282


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


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


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

Line: 2488


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


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


   END update_contact;

Line: 2616


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


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


   END update_contact;

Line: 2681


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


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

Line: 2694


    SELECT DNZ_CHR_ID
    FROM   OKC_CONTACTS
    WHERE  ID = P_CTC_ID;

Line: 2754


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


   END delete_contact;

Line: 2794


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


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


   END delete_contact;

Line: 2953


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


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

Line: 2995


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


  END update_contract_header;

Line: 3049


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


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

Line: 3088


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


  END delete_contract_header;

Line: 3316


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


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

Line: 3408


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


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

Line: 3469


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


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

Line: 3511


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


  END update_contract_line;

Line: 3563


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


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


   END update_contract_line;

Line: 3631


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


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

Line: 3670


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


  END delete_contract_line;

Line: 3719


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


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


   END delete_contract_line;

Line: 4044


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


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

Line: 4084


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


  END update_governance;

Line: 4137


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


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

Line: 4175


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


  END delete_governance;

Line: 4418


    SELECT FND_GLOBAL.conc_request_id
      FROM dual;

Line: 4422


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


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


    SELECT dnz_chr_id
      FROM okc_k_lines_b
     WHERE id = p_serv_top_line_id;

Line: 4505


           l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;

Line: 4514


           l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;

Line: 4519


           l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;

Line: 4528


             l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;

Line: 4546


             l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;

Line: 4556


             l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;

Line: 4572


             l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;

Line: 4629


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


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

Line: 4659


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


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


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


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


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

Line: 5029


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


  END update_rg_mode_pty_role;

Line: 5076


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


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

Line: 5104


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


  END delete_rg_mode_pty_role;