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

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

Line: 4


PROCEDURE insert_repos_objects(
     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_repv_rec              IN  repv_rec_type
    ,x_repv_rec              OUT  NOCOPY repv_rec_type) AS


l_api_version NUMBER ;

Line: 24


SAVEPOINT repos_objects_insert;

Line: 37


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'B', 'C')) THEN
	iex_repos_objects_cuhk.insert_repos_objects_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_repv_rec => lp_repv_rec
	                                           ,x_repv_rec => lx_repv_rec) ;

Line: 60


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'B', 'V')) THEN
	iex_repos_objects_vuhk.insert_repos_objects_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_repv_rec => lp_repv_rec
	                                             ,x_repv_rec => lx_repv_rec );

Line: 80


iex_rep_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_repv_rec
                         ,lx_repv_rec);

Line: 99


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'A', 'V')) THEN
	iex_repos_objects_vuhk.insert_repos_objects_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_repv_rec => lp_repv_rec);

Line: 116


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'A', 'C')) THEN
	iex_repos_objects_cuhk.insert_repos_objects_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_repv_rec => lp_repv_rec);

Line: 141


      ROLLBACK TO repos_objects_insert;

Line: 149


      ROLLBACK TO repos_objects_insert;

Line: 157


      ROLLBACK TO repos_objects_insert;

Line: 161


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','insert_repos_objects');

Line: 165


END insert_repos_objects;

Line: 167


PROCEDURE insert_repos_objects(
     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_repv_tbl              IN  repv_tbl_type
    ,x_repv_tbl              OUT  NOCOPY repv_tbl_type) AS

l_api_version NUMBER;

Line: 186


SAVEPOINT repos_objects_insert;

Line: 198


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'B', 'C')) THEN
	iex_repos_objects_cuhk.insert_repos_objects_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_repv_tbl => lp_repv_tbl
	                                           ,x_repv_tbl => lx_repv_tbl);

Line: 219


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'B', 'V')) THEN
	iex_repos_objects_vuhk.insert_repos_objects_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_repv_tbl => lp_repv_tbl
	                                           ,x_repv_tbl => lx_repv_tbl);

Line: 239


iex_rep_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_repv_tbl
                         ,lx_repv_tbl);

Line: 258


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'A', 'V')) THEN
	iex_repos_objects_vuhk.insert_repos_objects_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_repv_tbl => lp_repv_tbl) ;

Line: 274


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_repos_objects', 'A', 'C')) THEN
	iex_repos_objects_cuhk.insert_repos_objects_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_repv_tbl  => lp_repv_tbl) ;

Line: 299


      ROLLBACK TO repos_objects_insert;

Line: 307


      ROLLBACK TO repos_objects_insert;

Line: 315


      ROLLBACK TO repos_objects_insert;

Line: 319


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','insert_repos_objects');

Line: 323


END insert_repos_objects;

Line: 409


PROCEDURE update_repos_objects(
     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_repv_rec              IN  repv_rec_type
    ,x_repv_rec              OUT  NOCOPY repv_rec_type) AS

l_api_version NUMBER ;

Line: 428


SAVEPOINT repos_objects_update;

Line: 441


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'B', 'C')) THEN
	iex_repos_objects_cuhk.update_repos_objects_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_repv_rec => lp_repv_rec
	                                           ,x_repv_rec => lx_repv_rec) ;

Line: 463


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'B', 'V')) THEN
	iex_repos_objects_vuhk.update_repos_objects_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_repv_rec => lp_repv_rec
	                                           ,x_repv_rec => lx_repv_rec) ;

Line: 483


    iex_rep_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_repv_rec
                             ,lx_repv_rec);

Line: 502


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'A', 'V')) THEN
	iex_repos_objects_vuhk.update_repos_objects_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_repv_rec => lp_repv_rec) ;

Line: 519


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'A', 'C')) THEN
	iex_repos_objects_cuhk.update_repos_objects_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_repv_rec => lp_repv_rec) ;

Line: 544


      ROLLBACK TO repos_objects_update;

Line: 552


      ROLLBACK TO repos_objects_update;

Line: 560


      ROLLBACK TO repos_objects_update;

Line: 564


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','update_repos_objects');

Line: 568


END update_repos_objects;

Line: 570


PROCEDURE update_repos_objects(
     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_repv_tbl              IN  repv_tbl_type
    ,x_repv_tbl              OUT  NOCOPY repv_tbl_type) AS

l_api_version NUMBER;

Line: 589


SAVEPOINT repos_objects_update;

Line: 601


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'B', 'C')) THEN
	iex_repos_objects_cuhk.update_repos_objects_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_repv_tbl => lp_repv_tbl
	                                             ,x_repv_tbl => lx_repv_tbl) ;

Line: 623


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'B', 'V')) THEN
	iex_repos_objects_vuhk.update_repos_objects_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_repv_tbl => lp_repv_tbl
	                                             ,x_repv_tbl => lx_repv_tbl) ;

Line: 643


    iex_rep_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_repv_tbl
                             ,lx_repv_tbl);

Line: 662


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'A', 'V')) THEN
	iex_repos_objects_vuhk.update_repos_objects_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_repv_tbl => lp_repv_tbl) ;

Line: 678


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_repos_objects', 'A', 'C')) THEN
	iex_repos_objects_cuhk.update_repos_objects_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_repv_tbl => lp_repv_tbl) ;

Line: 703


      ROLLBACK TO repos_objects_update;

Line: 711


      ROLLBACK TO repos_objects_update;

Line: 719


      ROLLBACK TO repos_objects_update;

Line: 723


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','update_repos_objects');

Line: 727


END update_repos_objects;

Line: 730


PROCEDURE delete_repos_objects(
     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_repv_rec              IN repv_rec_type) AS

i	                    NUMBER :=0;

Line: 749


SAVEPOINT repos_objects_delete_rec;

Line: 760


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'B', 'C')) THEN
	iex_repos_objects_cuhk.delete_repos_objects_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_repv_rec => lp_repv_rec
	                                             ,x_repv_rec => lx_repv_rec) ;

Line: 782


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'B', 'V')) THEN
	iex_repos_objects_vuhk.delete_repos_objects_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_repv_rec => lp_repv_rec
	                                             ,x_repv_rec => lx_repv_rec) ;

Line: 803


iex_rep_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_repv_rec);

Line: 819


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'A', 'V')) THEN
iex_repos_objects_vuhk.delete_repos_objects_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_repv_rec => lp_repv_rec) ;

Line: 836


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'A', 'C')) THEN
iex_repos_objects_cuhk.delete_repos_objects_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_repv_rec => lp_repv_rec) ;

Line: 859


      ROLLBACK TO repos_objects_delete_rec;

Line: 867


      ROLLBACK TO repos_objects_delete_rec;

Line: 875


      ROLLBACK TO repos_objects_delete_rec;

Line: 879


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','delete_repos_objects');

Line: 883


END delete_repos_objects;

Line: 885


PROCEDURE delete_repos_objects(
     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_repv_tbl           IN repv_tbl_type) AS

i NUMBER := 0;

Line: 904


SAVEPOINT repos_objects_delete_tbl;

Line: 915


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'B', 'C')) THEN
iex_repos_objects_cuhk.delete_repos_objects_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_repv_tbl => lp_repv_tbl
                                             ,x_repv_tbl => lx_repv_tbl) ;

Line: 937


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'B', 'V')) THEN
iex_repos_objects_vuhk.delete_repos_objects_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_repv_tbl => lp_repv_tbl
                                             ,x_repv_tbl => lx_repv_tbl) ;

Line: 964


          delete_repos_objects(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_repv_tbl(i));

Line: 985


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'A', 'V')) THEN
iex_repos_objects_vuhk.delete_repos_objects_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_repv_tbl => lp_repv_tbl) ;

Line: 1002


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_repos_objects', 'A', 'C')) THEN
iex_repos_objects_cuhk.delete_repos_objects_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_repv_tbl => lp_repv_tbl) ;

Line: 1026


      ROLLBACK TO repos_objects_delete_tbl;

Line: 1034


      ROLLBACK TO repos_objects_delete_tbl;

Line: 1042


      ROLLBACK TO repos_objects_delete_tbl;

Line: 1046


      FND_MSG_PUB.ADD_EXC_MSG('IEX_REPOS_OBJECTS_PUB','delete_repos_objects');

Line: 1050


END delete_repos_objects;