APPS.OKL_OPT_RUL_TMP_PUB SQL Statements

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

Line: 4

PROCEDURE insert_Opt_Rul_Tmp(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT Fnd_Api.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_ovd_id                IN  NUMBER
    ,p_rgrv_rec              IN  rgrv_rec_type
    ,x_rgrv_rec              OUT  NOCOPY rgrv_rec_type) IS


l_api_version NUMBER ;

Line: 25

SAVEPOINT Opt_Rul_Tmp_insert;

Line: 41

		   Okl_Opt_Rul_Tmp_Pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
						 ,p_ovd_id
                         ,lp_rgrv_rec
                         ,lx_rgrv_rec);

Line: 73

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 81

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 89

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 93

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PUB','insert_Opt_Rul_Tmp');

Line: 97

END insert_Opt_Rul_Tmp;

Line: 99

PROCEDURE insert_Opt_Rul_Tmp(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_ovd_id                IN  NUMBER
    ,p_rgrv_tbl              IN  rgrv_tbl_type
    ,x_rgrv_tbl              OUT  NOCOPY rgrv_tbl_type) IS

l_api_version NUMBER;

Line: 118

SAVEPOINT Opt_Rul_Tmp_insert;

Line: 133

		   Okl_Opt_Rul_Tmp_Pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
						 ,p_ovd_id
                         ,lp_rgrv_tbl
                         ,lx_rgrv_tbl);

Line: 166

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 174

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 182

      ROLLBACK TO Opt_Rul_Tmp_insert;

Line: 186

      Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Opt_Rul_Tmp_Pub','insert_Opt_Rul_Tmp');

Line: 191

END insert_Opt_Rul_Tmp;

Line: 217

PROCEDURE update_Opt_Rul_Tmp(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_rgrv_rec              IN  rgrv_rec_type
    ,x_rgrv_rec              OUT  NOCOPY rgrv_rec_type) IS

BEGIN
	 NULL;

Line: 228

END update_Opt_Rul_Tmp;

Line: 230

PROCEDURE update_Opt_Rul_Tmp(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_rgrv_tbl              IN  rgrv_tbl_type
    ,x_rgrv_tbl              OUT  NOCOPY rgrv_tbl_type) IS

BEGIN
	 NULL;

Line: 241

END update_Opt_Rul_Tmp;

Line: 244

PROCEDURE delete_Opt_Rul_Tmp(
     p_api_version           IN  NUMBER
    ,p_init_msg_list         IN  VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status         OUT  NOCOPY VARCHAR2
    ,x_msg_count             OUT  NOCOPY NUMBER
    ,x_msg_data              OUT  NOCOPY VARCHAR2
    ,p_rgrv_rec              IN rgrv_rec_type) IS
BEGIN
	 NULL;

Line: 253

END delete_Opt_Rul_Tmp;

Line: 255

PROCEDURE delete_Opt_Rul_Tmp(
     p_api_version        IN NUMBER
    ,p_init_msg_list      IN VARCHAR2 DEFAULT FND_API.G_FALSE
    ,x_return_status      OUT NOCOPY VARCHAR2
    ,x_msg_count          OUT NOCOPY NUMBER
    ,x_msg_data           OUT NOCOPY VARCHAR2
    ,p_rgrv_tbl           IN rgrv_tbl_type) IS

BEGIN
	 NULL;

Line: 265

END delete_Opt_Rul_Tmp;