DBA Data[Home] [Help]

APPS.OKL_XCR_PUB SQL Statements

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

Line: 37

   SAVEPOINT save_Insert_row;
Line: 85

      ROLLBACK TO save_Insert_row;
Line: 93

      ROLLBACK TO save_Insert_row;
Line: 101

      ROLLBACK TO save_Insert_row;
Line: 105

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','insert_row');
Line: 114

PROCEDURE update_ext_ar_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: 142

   SAVEPOINT save_update_row;
Line: 156

	Okl_Extrn_Pvt.UPDATE_EXT_CSH_TXNS(
    	p_api_version
       ,p_init_msg_list
   	   ,x_return_status
   	   ,x_msg_count
   	   ,x_msg_data
   	   ,p_xcrv_rec
   	   ,p_xcav_tbl
   	   ,x_xcrv_rec
   	   ,x_xcav_tbl
	);
Line: 186

      ROLLBACK TO save_update_row;
Line: 194

      ROLLBACK TO save_update_row;
Line: 202

      ROLLBACK TO save_update_row;
Line: 206

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','update_row');
Line: 212

END update_ext_ar_txns;
Line: 214

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

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

   SAVEPOINT save_update_row;
Line: 250

    Okl_Extrn_Pvt.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: 278

      ROLLBACK TO save_update_row;
Line: 286

      ROLLBACK TO save_update_row;
Line: 294

      ROLLBACK TO save_update_row;
Line: 298

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','update_row');
Line: 304

END update_ext_csh_txns;
Line: 307

PROCEDURE delete_ext_ar_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: 335

   SAVEPOINT save_update_row;
Line: 349

	Okl_Extrn_Pvt.DELETE_EXT_CSH_TXNS(
    	p_api_version
       ,p_init_msg_list
   	   ,x_return_status
   	   ,x_msg_count
   	   ,x_msg_data
   	   ,p_xcrv_rec
   	   ,p_xcav_tbl
   	   ,x_xcrv_rec
   	   ,x_xcav_tbl
	);
Line: 379

      ROLLBACK TO save_update_row;
Line: 387

      ROLLBACK TO save_update_row;
Line: 395

      ROLLBACK TO save_update_row;
Line: 399

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCR_PUB','delete_row');
Line: 405

END delete_ext_ar_txns;