DBA Data[Home] [Help]

APPS.OKL_EXTRN_PVT SQL Statements

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

Line: 91

 PROCEDURE update_ext_csh_txns( 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_xcrv_rec                     IN xcrv_rec_type
   							   ,p_xcav_tbl                     IN xcav_tbl_type
							   ,x_xcrv_rec                     OUT NOCOPY xcrv_rec_type
   							   ,x_xcav_tbl                     OUT NOCOPY xcav_tbl_type
    						  ) IS

   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
Line: 107

    update_ext_csh_txns( p_api_version
    					,p_init_msg_list
    					,x_return_status
    					,x_msg_count
    					,x_msg_data
    					,p_xcrv_rec
    					,x_xcrv_rec
					   );
Line: 125

    update_ext_csh_txns( p_api_version
    				    ,p_init_msg_list
    					,x_return_status
    					,x_msg_count
    					,x_msg_data
    					,p_xcav_tbl
    					,x_xcav_tbl
					   );
Line: 157

END update_ext_csh_txns;
Line: 160

 PROCEDURE delete_ext_csh_txns( 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_xcrv_rec                     IN xcrv_rec_type
   							   ,p_xcav_tbl                     IN xcav_tbl_type
							   ,x_xcrv_rec                     OUT NOCOPY xcrv_rec_type
   							   ,x_xcav_tbl                     OUT NOCOPY xcav_tbl_type
    						  ) IS

   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
Line: 176

    delete_ext_csh_txns( p_api_version
    					,p_init_msg_list
    					,x_return_status
    					,x_msg_count
    					,x_msg_data
    					,p_xcrv_rec
					   );
Line: 194

    delete_ext_csh_txns( p_api_version
    				    ,p_init_msg_list
    					,x_return_status
    					,x_msg_count
    					,x_msg_data
    					,p_xcav_tbl
					   );
Line: 225

 END delete_ext_csh_txns;
Line: 298

    Okl_Xcr_Pvt.insert_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcrv_rec
    					   ,x_xcrv_rec
						  );
Line: 323

    Okl_Xcr_Pvt.insert_row( p_api_version
    					   ,p_init_msg_list
    				 	   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcrv_tbl
    					   ,x_xcrv_tbl
						  );
Line: 368

PROCEDURE update_ext_csh_txns( 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_xcrv_rec		    IN xcrv_rec_type
    						  ,x_xcrv_rec           OUT NOCOPY xcrv_rec_type
							 ) IS

BEGIN
    Okl_Xcr_Pvt.update_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcrv_rec
    					   ,x_xcrv_rec
						  );
Line: 391

END update_ext_csh_txns;
Line: 393

PROCEDURE update_ext_csh_txns( 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_xcrv_tbl		  IN xcrv_tbl_type
    						  ,x_xcrv_tbl         OUT NOCOPY xcrv_tbl_type
							 ) IS
BEGIN
    Okl_Xcr_Pvt.update_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcrv_tbl
    					   ,x_xcrv_tbl
						  );
Line: 410

END update_ext_csh_txns;
Line: 412

	--Put custom code for cascade delete by developer
PROCEDURE delete_ext_csh_txns( 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_xcrv_rec		    IN xcrv_rec_type
							 ) IS

    i	                    NUMBER :=0;
Line: 424

	--Delete the Master
        Okl_Xcr_Pvt.delete_row( p_api_version
    						   ,p_init_msg_list
    						   ,x_return_status
    						   ,x_msg_count
    						   ,x_msg_data
    						   ,p_xcrv_rec
							  );
Line: 457

END delete_ext_csh_txns;
Line: 459

PROCEDURE delete_ext_csh_txns( 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_xcrv_tbl		    IN xcrv_tbl_type
							 ) IS

    i	                    NUMBER :=0;
Line: 477

          delete_ext_csh_txns( p_api_version
    						  ,p_init_msg_list
    						  ,x_return_status
    						  ,x_msg_count
    						  ,x_msg_data
    						  ,p_xcrv_tbl(i)
							 );
Line: 507

END delete_ext_csh_txns;
Line: 553

    Okl_Xca_Pvt.insert_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcav_rec
    					   ,x_xcav_rec
						  );
Line: 578

    Okl_Xca_Pvt.insert_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcav_tbl
    					   ,x_xcav_tbl
						  );
Line: 622

PROCEDURE update_ext_csh_txns( 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_xcav_rec		    IN xcav_rec_type
    						  ,x_xcav_rec           OUT NOCOPY xcav_rec_type
							 ) IS
BEGIN
    Okl_Xca_Pvt.update_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcav_rec
    					   ,x_xcav_rec
						  );
Line: 644

END update_ext_csh_txns;
Line: 646

PROCEDURE update_ext_csh_txns( 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_xcav_tbl		    IN xcav_tbl_type
    						  ,x_xcav_tbl           OUT NOCOPY xcav_tbl_type
							 ) IS
BEGIN
    Okl_Xca_Pvt.update_row( p_api_version
    					   ,p_init_msg_list
    					   ,x_return_status
    					   ,x_msg_count
    					   ,x_msg_data
    					   ,p_xcav_tbl
    					   ,x_xcav_tbl
						  );
Line: 663

END update_ext_csh_txns;
Line: 665

	--Put custom code for cascade delete by developer
PROCEDURE delete_ext_csh_txns( 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_xcav_rec		    IN xcav_rec_type
	) IS
    i	                    NUMBER :=0;
Line: 676

	--Delete the Master
        Okl_Xca_Pvt.delete_row( p_api_version
    						   ,p_init_msg_list
    						   ,x_return_status
    						   ,x_msg_count
    						   ,x_msg_data
    						   ,p_xcav_rec
							  );
Line: 709

END delete_ext_csh_txns;
Line: 711

PROCEDURE delete_ext_csh_txns( 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_xcav_tbl		    IN xcav_tbl_type
							 ) IS

    i	                    NUMBER :=0;
Line: 728

          delete_ext_csh_txns( p_api_version
    						  ,p_init_msg_list
    						  ,x_return_status
    						  ,x_msg_count
    						  ,x_msg_data
    						  ,p_xcav_tbl(i)
							 );
Line: 759

END delete_ext_csh_txns;