DBA Data[Home] [Help]

APPS.OKL_INCSH_PVT SQL Statements

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

Line: 94

PROCEDURE update_internal_trans(
    p_api_version                  IN NUMBER
   ,p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
   ,x_return_status                OUT NOCOPY VARCHAR2
   ,x_msg_count                    OUT NOCOPY NUMBER
   ,x_msg_data                     OUT NOCOPY VARCHAR2
   ,p_rctv_rec                     IN rctv_rec_type
   ,p_rcav_tbl                     IN rcav_tbl_type
   ,x_rctv_rec                     OUT NOCOPY rctv_rec_type
   ,x_rcav_tbl                     OUT NOCOPY rcav_tbl_type
    ) IS
   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
Line: 108

    update_internal_trans(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_rctv_rec,
    	x_rctv_rec);
Line: 125

    update_internal_trans(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_tbl,
    x_rcav_tbl);
Line: 155

PROCEDURE delete_internal_trans(
    p_api_version                  IN NUMBER
   ,p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
   ,x_return_status                OUT NOCOPY VARCHAR2
   ,x_msg_count                    OUT NOCOPY NUMBER
   ,x_msg_data                     OUT NOCOPY VARCHAR2
   ,p_rctv_rec                     IN rctv_rec_type
   ,p_rcav_tbl                     IN rcav_tbl_type
   ,x_rctv_rec                     OUT NOCOPY rctv_rec_type
   ,x_rcav_tbl                     OUT NOCOPY rcav_tbl_type
    ) IS
   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
Line: 169

    delete_internal_trans(
    	p_api_version,
    	p_init_msg_list,
    	x_return_status,
    	x_msg_count,
    	x_msg_data,
    	p_rctv_rec);
Line: 185

    delete_internal_trans(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_tbl);
Line: 284

    Okl_Rct_Pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rctv_rec,
    x_rctv_rec);
Line: 311

    Okl_Rct_Pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rctv_tbl,
    x_rctv_tbl);
Line: 355

PROCEDURE update_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rctv_rec		    IN rctv_rec_type,
    x_rctv_rec              OUT NOCOPY rctv_rec_type) IS
BEGIN
    Okl_Rct_Pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rctv_rec,
    x_rctv_rec);
Line: 377

END update_internal_trans;
Line: 379

PROCEDURE update_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rctv_tbl		    IN rctv_tbl_type,
    x_rctv_tbl              OUT NOCOPY rctv_tbl_type) IS
BEGIN
    Okl_Rct_Pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rctv_tbl,
    x_rctv_tbl);
Line: 396

END update_internal_trans;
Line: 398

	--Put custom code for cascade delete by developer
PROCEDURE delete_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rctv_rec		    IN rctv_rec_type) IS
    i	                    NUMBER :=0;
Line: 409

	--Delete the Master
        Okl_Rct_Pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_rctv_rec);
Line: 441

END delete_internal_trans;
Line: 443

PROCEDURE delete_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rctv_tbl		    IN rctv_tbl_type) IS
    i	                    NUMBER :=0;
Line: 459

          delete_internal_trans(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_rctv_tbl(i));
Line: 489

END delete_internal_trans;
Line: 534

    Okl_Rca_Pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_rec,
    x_rcav_rec);
Line: 559

    Okl_Rca_Pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_tbl,
    x_rcav_tbl);
Line: 603

PROCEDURE update_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rcav_rec		    IN rcav_rec_type,
    x_rcav_rec              OUT NOCOPY rcav_rec_type) IS
BEGIN
    Okl_Rca_Pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_rec,
    x_rcav_rec);
Line: 625

END update_internal_trans;
Line: 627

PROCEDURE update_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rcav_tbl		    IN rcav_tbl_type,
    x_rcav_tbl              OUT NOCOPY rcav_tbl_type) IS
BEGIN
    Okl_Rca_Pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rcav_tbl,
    x_rcav_tbl);
Line: 644

END update_internal_trans;
Line: 646

	--Put custom code for cascade delete by developer
PROCEDURE delete_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rcav_rec		    IN rcav_rec_type) IS
    i	                    NUMBER :=0;
Line: 657

	--Delete the Master
        Okl_Rca_Pvt.delete_row(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_rcav_rec);
Line: 689

END delete_internal_trans;
Line: 691

PROCEDURE delete_internal_trans(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rcav_tbl		    IN rcav_tbl_type) IS
    i	                    NUMBER :=0;
Line: 707

          delete_internal_trans(
    		p_api_version,
    		p_init_msg_list,
    		x_return_status,
    		x_msg_count,
    		x_msg_data,
    		p_rcav_tbl(i));
Line: 737

END delete_internal_trans;