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

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

Line: 4


PROCEDURE insert_exclusion_hist(
     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_iehv_rec              IN  iehv_rec_type
    ,x_iehv_rec              OUT  NOCOPY iehv_rec_type) IS


l_api_version NUMBER ;

Line: 24


SAVEPOINT exclusion_hist_insert;

Line: 37


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'B', 'C')) THEN
	iex_exclusion_hist_cuhk.insert_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                           ,x_iehv_rec => lx_iehv_rec) ;

Line: 60


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'B', 'V')) THEN
	iex_exclusion_hist_vuhk.insert_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                             ,x_iehv_rec => lx_iehv_rec );

Line: 80


iex_ieh_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iehv_rec
                         ,lx_iehv_rec);

Line: 100


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'A', 'V')) THEN
	iex_exclusion_hist_vuhk.insert_exclusion_hist_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_iehv_rec => lp_iehv_rec);

Line: 117


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'A', 'C')) THEN
	iex_exclusion_hist_cuhk.insert_exclusion_hist_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_iehv_rec => lp_iehv_rec);

Line: 142


      ROLLBACK TO exclusion_hist_insert;

Line: 150


      ROLLBACK TO exclusion_hist_insert;

Line: 158


      ROLLBACK TO exclusion_hist_insert;

Line: 162


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');

Line: 166


END insert_exclusion_hist;

Line: 168


PROCEDURE insert_exclusion_hist(
     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_iehv_tbl              IN  iehv_tbl_type
    ,x_iehv_tbl              OUT  NOCOPY iehv_tbl_type) IS

l_api_version NUMBER;

Line: 187


SAVEPOINT exclusion_hist_insert;

Line: 200


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'B', 'C')) THEN
	iex_exclusion_hist_cuhk.insert_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
	                                           ,x_iehv_tbl => lx_iehv_tbl);

Line: 221


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'B', 'V')) THEN
	iex_exclusion_hist_vuhk.insert_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
	                                           ,x_iehv_tbl => lx_iehv_tbl);

Line: 241


iex_ieh_pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iehv_tbl
                         ,lx_iehv_tbl);

Line: 261


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'A', 'V')) THEN
	iex_exclusion_hist_vuhk.insert_exclusion_hist_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_iehv_tbl => lp_iehv_tbl) ;

Line: 277


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'insert_exclusion_hist', 'A', 'C')) THEN
	iex_exclusion_hist_cuhk.insert_exclusion_hist_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_iehv_tbl  => lp_iehv_tbl) ;

Line: 303


      ROLLBACK TO exclusion_hist_insert;

Line: 311


      ROLLBACK TO exclusion_hist_insert;

Line: 319


      ROLLBACK TO exclusion_hist_insert;

Line: 323


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','insert_exclusion_hist');

Line: 327


END insert_exclusion_hist;

Line: 413


PROCEDURE update_exclusion_hist(
     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_iehv_rec              IN  iehv_rec_type
    ,x_iehv_rec              OUT  NOCOPY iehv_rec_type) IS

l_api_version NUMBER ;

Line: 432


SAVEPOINT exclusion_hist_update;

Line: 445


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'B', 'C')) THEN
	iex_exclusion_hist_cuhk.update_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                           ,x_iehv_rec => lx_iehv_rec) ;

Line: 467


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'B', 'V')) THEN
	iex_exclusion_hist_vuhk.update_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                           ,x_iehv_rec => lx_iehv_rec) ;

Line: 487


    iex_ieh_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_iehv_rec
                             ,lx_iehv_rec);

Line: 506


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'A', 'V')) THEN
	iex_exclusion_hist_vuhk.update_exclusion_hist_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_iehv_rec => lp_iehv_rec) ;

Line: 523


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'A', 'C')) THEN
	iex_exclusion_hist_cuhk.update_exclusion_hist_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_iehv_rec => lp_iehv_rec) ;

Line: 548


      ROLLBACK TO exclusion_hist_update;

Line: 556


      ROLLBACK TO exclusion_hist_update;

Line: 564


      ROLLBACK TO exclusion_hist_update;

Line: 568


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');

Line: 572


END update_exclusion_hist;

Line: 574


PROCEDURE update_exclusion_hist(
     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_iehv_tbl              IN  iehv_tbl_type
    ,x_iehv_tbl              OUT  NOCOPY iehv_tbl_type) IS

l_api_version NUMBER;

Line: 593


SAVEPOINT exclusion_hist_update;

Line: 605


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'B', 'C')) THEN
	iex_exclusion_hist_cuhk.update_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
	                                             ,x_iehv_tbl => lx_iehv_tbl) ;

Line: 627


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'B', 'V')) THEN
	iex_exclusion_hist_vuhk.update_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
	                                             ,x_iehv_tbl => lx_iehv_tbl) ;

Line: 647


    iex_ieh_pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_iehv_tbl
                             ,lx_iehv_tbl);

Line: 667


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'A', 'V')) THEN
	iex_exclusion_hist_vuhk.update_exclusion_hist_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_iehv_tbl => lp_iehv_tbl) ;

Line: 683


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'update_exclusion_hist', 'A', 'C')) THEN
	iex_exclusion_hist_cuhk.update_exclusion_hist_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_iehv_tbl => lp_iehv_tbl) ;

Line: 708


      ROLLBACK TO exclusion_hist_update;

Line: 716


      ROLLBACK TO exclusion_hist_update;

Line: 724


      ROLLBACK TO exclusion_hist_update;

Line: 728


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','update_exclusion_hist');

Line: 732


END update_exclusion_hist;

Line: 735


PROCEDURE delete_exclusion_hist(
     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_iehv_rec              IN iehv_rec_type) IS

i	                    NUMBER :=0;

Line: 754


SAVEPOINT exclusion_hist_delete_rec;

Line: 767


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'B', 'C')) THEN
	iex_exclusion_hist_cuhk.delete_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                             ,x_iehv_rec => lx_iehv_rec) ;

Line: 789


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'B', 'V')) THEN
	iex_exclusion_hist_vuhk.delete_exclusion_hist_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_iehv_rec => lp_iehv_rec
	                                             ,x_iehv_rec => lx_iehv_rec) ;

Line: 810


iex_ieh_pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_iehv_rec);

Line: 826


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'A', 'V')) THEN
iex_exclusion_hist_vuhk.delete_exclusion_hist_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_iehv_rec => lp_iehv_rec) ;

Line: 843


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'A', 'C')) THEN
iex_exclusion_hist_cuhk.delete_exclusion_hist_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_iehv_rec => lp_iehv_rec) ;

Line: 866


      ROLLBACK TO exclusion_hist_delete_rec;

Line: 874


      ROLLBACK TO exclusion_hist_delete_rec;

Line: 882


      ROLLBACK TO exclusion_hist_delete_rec;

Line: 886


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');

Line: 890


END delete_exclusion_hist;

Line: 892


PROCEDURE delete_exclusion_hist(
     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_iehv_tbl           IN iehv_tbl_type) IS

i NUMBER := 0;

Line: 911


SAVEPOINT exclusion_hist_delete_tbl;

Line: 924


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'B', 'C')) THEN
iex_exclusion_hist_cuhk.delete_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
                                             ,x_iehv_tbl => lx_iehv_tbl) ;

Line: 946


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'B', 'V')) THEN
iex_exclusion_hist_vuhk.delete_exclusion_hist_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_iehv_tbl => lp_iehv_tbl
                                             ,x_iehv_tbl => lx_iehv_tbl) ;

Line: 973


          delete_exclusion_hist(
                               l_api_version
                              ,l_init_msg_list
                              ,l_return_status
                              ,l_msg_count
                              ,l_msg_data
                              ,lp_iehv_tbl(i));

Line: 994


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'A', 'V')) THEN
iex_exclusion_hist_vuhk.delete_exclusion_hist_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_iehv_tbl => lp_iehv_tbl) ;

Line: 1011


IF (JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, 'delete_exclusion_hist', 'A', 'C')) THEN
iex_exclusion_hist_cuhk.delete_exclusion_hist_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_iehv_tbl => lp_iehv_tbl) ;

Line: 1035


      ROLLBACK TO exclusion_hist_delete_tbl;

Line: 1043


      ROLLBACK TO exclusion_hist_delete_tbl;

Line: 1051


      ROLLBACK TO exclusion_hist_delete_tbl;

Line: 1055


      FND_MSG_PUB.ADD_EXC_MSG('IEX_EXCLUSION_HIST_PUB','delete_exclusion_hist');

Line: 1059


END delete_exclusion_hist;