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.IEX_OPEN_INT_HST_PUB SQL Statements

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

Line: 6


PROCEDURE insert_open_int_hst(
     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_iohv_rec              IN  iohv_rec_type
    ,x_iohv_rec              OUT  NOCOPY iohv_rec_type) AS


l_api_version NUMBER ;

Line: 26


SAVEPOINT open_int_hst_insert;

Line: 39


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'B', 'C')) THEN
	iex_open_int_hst_cuhk.insert_open_int_hst_pre (
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_rec => lp_iohv_rec
	                                           ,x_iohv_rec => lx_iohv_rec) ;

Line: 62


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'B', 'V')) THEN
	iex_open_int_hst_vuhk.insert_open_int_hst_pre (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_rec => lp_iohv_rec
	                                             ,x_iohv_rec => lx_iohv_rec );

Line: 82


iex_ioh_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iohv_rec
                         ,lx_iohv_rec);

Line: 101


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'A', 'V')) THEN
	iex_open_int_hst_vuhk.insert_open_int_hst_post(
	                                               p_init_msg_list => l_init_msg_list
	                                              ,x_msg_data => l_msg_data
	                                              ,x_msg_count => l_msg_count
	                                              ,x_return_status => l_return_status
	                                              ,p_iohv_rec => lp_iohv_rec);

Line: 118


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'A', 'C')) THEN
	iex_open_int_hst_cuhk.insert_open_int_hst_post(
	                                               p_init_msg_list => l_init_msg_list
	                                              ,x_msg_data => l_msg_data
	                                              ,x_msg_count => l_msg_count
	                                              ,x_return_status => l_return_status
	                                              ,p_iohv_rec => lp_iohv_rec);

Line: 143


      ROLLBACK TO open_int_hst_insert;

Line: 151


      ROLLBACK TO open_int_hst_insert;

Line: 159


      ROLLBACK TO open_int_hst_insert;

Line: 163


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');

Line: 167


END insert_open_int_hst;

Line: 169


PROCEDURE insert_open_int_hst(
     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_iohv_tbl              IN  iohv_tbl_type
    ,x_iohv_tbl              OUT  NOCOPY iohv_tbl_type) AS

l_api_version NUMBER;

Line: 188


SAVEPOINT open_int_hst_insert;

Line: 200


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'B', 'C')) THEN
	iex_open_int_hst_cuhk.insert_open_int_hst_pre(
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_tbl => lp_iohv_tbl
	                                           ,x_iohv_tbl => lx_iohv_tbl);

Line: 221


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'B', 'V')) THEN
	iex_open_int_hst_vuhk.insert_open_int_hst_pre(
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_tbl => lp_iohv_tbl
	                                           ,x_iohv_tbl => lx_iohv_tbl);

Line: 241


iex_ioh_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iohv_tbl
                         ,lx_iohv_tbl);

Line: 260


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'A', 'V')) THEN
	iex_open_int_hst_vuhk.insert_open_int_hst_post (
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_tbl => lp_iohv_tbl) ;

Line: 276


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_open_int_hst', 'A', 'C')) THEN
	iex_open_int_hst_cuhk.insert_open_int_hst_post (
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_tbl  => lp_iohv_tbl) ;

Line: 301


      ROLLBACK TO open_int_hst_insert;

Line: 309


      ROLLBACK TO open_int_hst_insert;

Line: 317


      ROLLBACK TO open_int_hst_insert;

Line: 321


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','insert_open_int_hst');

Line: 325


END insert_open_int_hst;

Line: 411


PROCEDURE update_open_int_hst(
     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_iohv_rec              IN  iohv_rec_type
    ,x_iohv_rec              OUT  NOCOPY iohv_rec_type) AS

l_api_version NUMBER ;

Line: 430


SAVEPOINT open_int_hst_update;

Line: 443


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'B', 'C')) THEN
	iex_open_int_hst_cuhk.update_open_int_hst_pre (
	                                            p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_rec => lp_iohv_rec
	                                           ,x_iohv_rec => lx_iohv_rec) ;

Line: 465


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'B', 'V')) THEN
	iex_open_int_hst_vuhk.update_open_int_hst_pre (
	                                           p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_rec => lp_iohv_rec
	                                           ,x_iohv_rec => lx_iohv_rec) ;

Line: 485


    iex_ioh_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_iohv_rec
                             ,lx_iohv_rec);

Line: 504


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'A', 'V')) THEN
	iex_open_int_hst_vuhk.update_open_int_hst_post (
	                                           p_init_msg_list => l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_rec => lp_iohv_rec) ;

Line: 521


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'A', 'C')) THEN
	iex_open_int_hst_cuhk.update_open_int_hst_post (
	                                           p_init_msg_list=>l_init_msg_list
	                                           ,x_msg_data => l_msg_data
	                                           ,x_msg_count => l_msg_count
	                                           ,x_return_status => l_return_status
	                                           ,p_iohv_rec => lp_iohv_rec) ;

Line: 546


      ROLLBACK TO open_int_hst_update;

Line: 554


      ROLLBACK TO open_int_hst_update;

Line: 562


      ROLLBACK TO open_int_hst_update;

Line: 566


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');

Line: 570


END update_open_int_hst;

Line: 572


PROCEDURE update_open_int_hst(
     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_iohv_tbl              IN  iohv_tbl_type
    ,x_iohv_tbl              OUT  NOCOPY iohv_tbl_type) AS

l_api_version NUMBER;

Line: 591


SAVEPOINT open_int_hst_update;

Line: 603


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'B', 'C')) THEN
	iex_open_int_hst_cuhk.update_open_int_hst_pre (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_tbl => lp_iohv_tbl
	                                             ,x_iohv_tbl => lx_iohv_tbl) ;

Line: 625


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'B', 'V')) THEN
	iex_open_int_hst_vuhk.update_open_int_hst_pre (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_tbl => lp_iohv_tbl
	                                             ,x_iohv_tbl => lx_iohv_tbl) ;

Line: 645


    iex_ioh_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_iohv_tbl
                             ,lx_iohv_tbl);

Line: 664


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'A', 'V')) THEN
	iex_open_int_hst_vuhk.update_open_int_hst_post (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_tbl => lp_iohv_tbl) ;

Line: 680


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_open_int_hst', 'A', 'C')) THEN
	iex_open_int_hst_cuhk.update_open_int_hst_post (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_tbl => lp_iohv_tbl) ;

Line: 706


      ROLLBACK TO open_int_hst_update;

Line: 714


      ROLLBACK TO open_int_hst_update;

Line: 722


      ROLLBACK TO open_int_hst_update;

Line: 726


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','update_open_int_hst');

Line: 730


END update_open_int_hst;

Line: 733


PROCEDURE delete_open_int_hst(
     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_iohv_rec              IN iohv_rec_type) AS

i	                    NUMBER;

Line: 752


SAVEPOINT open_int_hst_delete_rec;

Line: 764


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'B', 'C')) THEN
	iex_open_int_hst_cuhk.delete_open_int_hst_pre (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_rec => lp_iohv_rec
	                                             ,x_iohv_rec => lx_iohv_rec) ;

Line: 786


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'B', 'V')) THEN
	iex_open_int_hst_vuhk.delete_open_int_hst_pre (
	                                              p_init_msg_list => l_init_msg_list
	                                             ,x_msg_data => l_msg_data
	                                             ,x_msg_count => l_msg_count
	                                             ,x_return_status => l_return_status
	                                             ,p_iohv_rec => lp_iohv_rec
	                                             ,x_iohv_rec => lx_iohv_rec) ;

Line: 807


iex_ioh_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iohv_rec);

Line: 823


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'A', 'V')) THEN
iex_open_int_hst_vuhk.delete_open_int_hst_post (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_rec => lp_iohv_rec) ;

Line: 840


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'A', 'C')) THEN
iex_open_int_hst_cuhk.delete_open_int_hst_post (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_rec => lp_iohv_rec) ;

Line: 863


      ROLLBACK TO open_int_hst_delete_rec;

Line: 871


      ROLLBACK TO open_int_hst_delete_rec;

Line: 879


      ROLLBACK TO open_int_hst_delete_rec;

Line: 883


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');

Line: 887


END delete_open_int_hst;

Line: 889


PROCEDURE delete_open_int_hst(
     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_iohv_tbl           IN iohv_tbl_type) AS

i NUMBER := 0;

Line: 908


SAVEPOINT open_int_hst_delete_tbl;

Line: 921


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'B', 'C')) THEN
iex_open_int_hst_cuhk.delete_open_int_hst_pre (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_tbl => lp_iohv_tbl
                                             ,x_iohv_tbl => lx_iohv_tbl) ;

Line: 943


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'B', 'V')) THEN
iex_open_int_hst_vuhk.delete_open_int_hst_pre (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_tbl => lp_iohv_tbl
                                             ,x_iohv_tbl => lx_iohv_tbl) ;

Line: 971


          delete_open_int_hst(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_iohv_tbl(i));

Line: 992


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'A', 'V')) THEN
iex_open_int_hst_vuhk.delete_open_int_hst_post (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_tbl => lp_iohv_tbl) ;

Line: 1009


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_open_int_hst', 'A', 'C')) THEN
iex_open_int_hst_cuhk.delete_open_int_hst_post (
                                              p_init_msg_list => l_init_msg_list
                                             ,x_msg_data => l_msg_data
                                             ,x_msg_count => l_msg_count
                                             ,x_return_status => l_return_status
                                             ,p_iohv_tbl => lp_iohv_tbl) ;

Line: 1033


      ROLLBACK TO open_int_hst_delete_tbl;

Line: 1041


      ROLLBACK TO open_int_hst_delete_tbl;

Line: 1049


      ROLLBACK TO open_int_hst_delete_tbl;

Line: 1053


      FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INT_HST_PUB','delete_open_int_hst');

Line: 1057


END delete_open_int_hst;