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

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

Line: 4


PROCEDURE insert_ext_agncy(
     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_ieav_rec              IN  ieav_rec_type
    ,x_ieav_rec              OUT  NOCOPY ieav_rec_type) AS


l_api_version NUMBER ;

Line: 24


SAVEPOINT ext_agncy_insert;

Line: 38


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'B', 'C')) THEN
	iex_ext_agncy_cuhk.insert_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                           ,x_ieav_rec => lx_ieav_rec) ;

Line: 59


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'B', 'V')) THEN
	iex_ext_agncy_vuhk.insert_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                             ,x_ieav_rec => lx_ieav_rec );

Line: 80


iex_iea_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_ieav_rec
                         ,lx_ieav_rec);

Line: 99


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'A', 'V')) THEN
	iex_ext_agncy_vuhk.insert_ext_agncy_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_ieav_rec => lp_ieav_rec);

Line: 116


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'A', 'C')) THEN
	iex_ext_agncy_cuhk.insert_ext_agncy_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_ieav_rec => lp_ieav_rec);

Line: 141


      ROLLBACK TO ext_agncy_insert;

Line: 149


      ROLLBACK TO ext_agncy_insert;

Line: 157


      ROLLBACK TO ext_agncy_insert;

Line: 161


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');

Line: 165


END insert_ext_agncy;

Line: 167


PROCEDURE insert_ext_agncy(
     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_ieav_tbl              IN  ieav_tbl_type
    ,x_ieav_tbl              OUT  NOCOPY ieav_tbl_type) AS

l_api_version NUMBER;

Line: 186


SAVEPOINT ext_agncy_insert;

Line: 199


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'B', 'C')) THEN
	iex_ext_agncy_cuhk.insert_ext_agncy_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_ieav_tbl => lp_ieav_tbl
	                                           ,x_ieav_tbl => lx_ieav_tbl);

Line: 218


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'B', 'V')) THEN
	iex_ext_agncy_vuhk.insert_ext_agncy_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_ieav_tbl => lp_ieav_tbl
	                                           ,x_ieav_tbl => lx_ieav_tbl);

Line: 240


iex_iea_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_ieav_tbl
                         ,lx_ieav_tbl);

Line: 259


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'A', 'V')) THEN
	iex_ext_agncy_vuhk.insert_ext_agncy_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_ieav_tbl => lp_ieav_tbl) ;

Line: 275


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_ext_agncy', 'A', 'C')) THEN
	iex_ext_agncy_cuhk.insert_ext_agncy_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_ieav_tbl  => lp_ieav_tbl) ;

Line: 300


      ROLLBACK TO ext_agncy_insert;

Line: 308


      ROLLBACK TO ext_agncy_insert;

Line: 316


      ROLLBACK TO ext_agncy_insert;

Line: 320


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','insert_ext_agncy');

Line: 324


END insert_ext_agncy;

Line: 410


PROCEDURE update_ext_agncy(
     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_ieav_rec              IN  ieav_rec_type
    ,x_ieav_rec              OUT  NOCOPY ieav_rec_type) AS

l_api_version NUMBER ;

Line: 429


SAVEPOINT ext_agncy_update;

Line: 442


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'B', 'C')) THEN
	iex_ext_agncy_cuhk.update_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                           ,x_ieav_rec => lx_ieav_rec) ;

Line: 462


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'B', 'V')) THEN
	iex_ext_agncy_vuhk.update_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                           ,x_ieav_rec => lx_ieav_rec) ;

Line: 484


    iex_iea_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_ieav_rec
                             ,lx_ieav_rec);

Line: 503


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'A', 'V')) THEN
	iex_ext_agncy_vuhk.update_ext_agncy_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_ieav_rec => lp_ieav_rec) ;

Line: 520


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'A', 'C')) THEN
	iex_ext_agncy_cuhk.update_ext_agncy_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_ieav_rec => lp_ieav_rec) ;

Line: 545


      ROLLBACK TO ext_agncy_update;

Line: 553


      ROLLBACK TO ext_agncy_update;

Line: 561


      ROLLBACK TO ext_agncy_update;

Line: 565


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');

Line: 569


END update_ext_agncy;

Line: 571


PROCEDURE update_ext_agncy(
     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_ieav_tbl              IN  ieav_tbl_type
    ,x_ieav_tbl              OUT  NOCOPY ieav_tbl_type) AS

l_api_version NUMBER;

Line: 590


SAVEPOINT ext_agncy_update;

Line: 603


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'B', 'C')) THEN
	iex_ext_agncy_cuhk.update_ext_agncy_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_ieav_tbl => lp_ieav_tbl
	                                             ,x_ieav_tbl => lx_ieav_tbl) ;

Line: 623


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'B', 'V')) THEN
	iex_ext_agncy_vuhk.update_ext_agncy_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_ieav_tbl => lp_ieav_tbl
	                                             ,x_ieav_tbl => lx_ieav_tbl) ;

Line: 644


    iex_iea_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_ieav_tbl
                             ,lx_ieav_tbl);

Line: 663


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'A', 'V')) THEN
	iex_ext_agncy_vuhk.update_ext_agncy_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_ieav_tbl => lp_ieav_tbl) ;

Line: 679


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_ext_agncy', 'A', 'C')) THEN
	iex_ext_agncy_cuhk.update_ext_agncy_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_ieav_tbl => lp_ieav_tbl) ;

Line: 704


      ROLLBACK TO ext_agncy_update;

Line: 712


      ROLLBACK TO ext_agncy_update;

Line: 720


      ROLLBACK TO ext_agncy_update;

Line: 724


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','update_ext_agncy');

Line: 728


END update_ext_agncy;

Line: 731


PROCEDURE delete_ext_agncy(
     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_ieav_rec              IN ieav_rec_type) AS

i	                    NUMBER :=0;

Line: 750


SAVEPOINT ext_agncy_delete_rec;

Line: 762


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'B', 'C')) THEN
	iex_ext_agncy_cuhk.delete_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                             ,x_ieav_rec => lx_ieav_rec) ;

Line: 782


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'B', 'V')) THEN
	iex_ext_agncy_vuhk.delete_ext_agncy_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_ieav_rec => lp_ieav_rec
	                                             ,x_ieav_rec => lx_ieav_rec) ;

Line: 804


iex_iea_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_ieav_rec);

Line: 821


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'A', 'V')) THEN
iex_ext_agncy_vuhk.delete_ext_agncy_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_ieav_rec => lp_ieav_rec) ;

Line: 836


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'A', 'C')) THEN
iex_ext_agncy_cuhk.delete_ext_agncy_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_ieav_rec => lp_ieav_rec) ;

Line: 860


      ROLLBACK TO ext_agncy_delete_rec;

Line: 868


      ROLLBACK TO ext_agncy_delete_rec;

Line: 876


      ROLLBACK TO ext_agncy_delete_rec;

Line: 880


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');

Line: 884


END delete_ext_agncy;

Line: 886


PROCEDURE delete_ext_agncy(
     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_ieav_tbl           IN ieav_tbl_type) AS

i NUMBER := 0;

Line: 905


SAVEPOINT ext_agncy_delete_tbl;

Line: 917


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'B', 'C')) THEN
iex_ext_agncy_cuhk.delete_ext_agncy_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_ieav_tbl => lp_ieav_tbl
                                             ,x_ieav_tbl => lx_ieav_tbl) ;

Line: 939


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'B', 'V')) THEN
iex_ext_agncy_vuhk.delete_ext_agncy_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_ieav_tbl => lp_ieav_tbl
                                             ,x_ieav_tbl => lx_ieav_tbl) ;

Line: 969


          delete_ext_agncy(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_ieav_tbl(i));

Line: 990


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'A', 'V')) THEN
iex_ext_agncy_vuhk.delete_ext_agncy_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_ieav_tbl => lp_ieav_tbl) ;

Line: 1007


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_ext_agncy', 'A', 'C')) THEN
iex_ext_agncy_cuhk.delete_ext_agncy_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_ieav_tbl => lp_ieav_tbl) ;

Line: 1031


      ROLLBACK TO ext_agncy_delete_tbl;

Line: 1039


      ROLLBACK TO ext_agncy_delete_tbl;

Line: 1047


      ROLLBACK TO ext_agncy_delete_tbl;

Line: 1051


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXT_AGNCY_PUB','delete_ext_agncy');

Line: 1055


END delete_ext_agncy;