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

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

Line: 4


PROCEDURE insert_itm_cat_rv_prcs(
     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_icpv_rec              IN  icpv_rec_type
    ,x_icpv_rec              OUT  NOCOPY icpv_rec_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'insert_itm_cat_rv_prcs';

Line: 14


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (REC)';

Line: 28


  okl_icp_pvt.insert_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_rec      => p_icpv_rec,
                         x_icpv_rec      => x_icpv_rec);

Line: 82


END insert_itm_cat_rv_prcs;

Line: 85


PROCEDURE insert_itm_cat_rv_prcs(
     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_icpv_tbl              IN  icpv_tbl_type
    ,x_icpv_tbl              OUT  NOCOPY icpv_tbl_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'insert_itm_cat_rv_prcs';

Line: 95


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (TBL)';

Line: 109


  okl_icp_pvt.insert_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_tbl      => p_icpv_tbl,
                         x_icpv_tbl      => x_icpv_tbl);

Line: 163


END insert_itm_cat_rv_prcs;

Line: 324


PROCEDURE update_itm_cat_rv_prcs(
     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_icpv_rec              IN  icpv_rec_type
    ,x_icpv_rec              OUT  NOCOPY icpv_rec_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'update_itm_cat_rv_prcs';

Line: 334


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (REC)';

Line: 348


  okl_icp_pvt.update_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_rec      => p_icpv_rec,
                         x_icpv_rec      => x_icpv_rec);

Line: 402


END update_itm_cat_rv_prcs;

Line: 405


PROCEDURE update_itm_cat_rv_prcs(
     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_icpv_tbl              IN  icpv_tbl_type
    ,x_icpv_tbl              OUT  NOCOPY icpv_tbl_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'update_itm_cat_rv_prcs';

Line: 415


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (TBL)';

Line: 429


  okl_icp_pvt.update_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_tbl      => p_icpv_tbl,
                         x_icpv_tbl      => x_icpv_tbl);

Line: 483


END update_itm_cat_rv_prcs;

Line: 486


PROCEDURE delete_itm_cat_rv_prcs(
     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_icpv_rec              IN icpv_rec_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'delete_itm_cat_rv_prcs';

Line: 495


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (REC)';

Line: 509


  okl_icp_pvt.delete_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_rec      => p_icpv_rec);

Line: 562


END delete_itm_cat_rv_prcs;

Line: 565


PROCEDURE delete_itm_cat_rv_prcs(
     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_icpv_tbl           IN icpv_tbl_type) IS

  l_program_name         CONSTANT VARCHAR2(35) := 'delete_itm_cat_rv_prcs';

Line: 574


  l_api_name             CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (TBL)';

Line: 588


  okl_icp_pvt.delete_row(p_api_version   => G_API_VERSION,
                         p_init_msg_list => G_FALSE,
                         x_return_status => lx_return_status,
                         x_msg_count     => x_msg_count,
                         x_msg_data      => x_msg_data,
                         p_icpv_tbl      => p_icpv_tbl);

Line: 641


END delete_itm_cat_rv_prcs;