APPS.OKL_BPD_CAP_PURPOSE_PUB SQL Statements

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

Line: 95

       Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');

Line: 116

PROCEDURE update_purpose ( p_api_version	    IN  NUMBER
                          ,p_init_msg_list   IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                          ,x_return_status   OUT NOCOPY VARCHAR2
                          ,x_msg_count	      OUT NOCOPY NUMBER
                          ,x_msg_data	       OUT NOCOPY VARCHAR2
                          ,p_strm_tbl        IN  okl_cash_dtls_tbl_type
                          ,x_strm_tbl        OUT NOCOPY okl_cash_dtls_tbl_type
                         ) IS

--Initialize return status.
   l_return_status     VARCHAR2(1) DEFAULT Okl_Api.G_RET_STS_SUCCESS;

Line: 134

   SAVEPOINT save_update_purpose;

Line: 142

   Okl_Bpd_Cap_Purpose_Pvt.update_purpose(  p_api_version
                                           ,p_init_msg_list
                                           ,x_return_status
                                           ,x_msg_count
                                           ,x_msg_data
                                           ,p_strm_tbl
                                           ,x_strm_tbl
                                          );

Line: 175

        ROLLBACK TO save_update_purpose;

Line: 182

       ROLLBACK TO save_update_purpose;

Line: 189

       ROLLBACK TO save_update_purpose;

Line: 193

       Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');

Line: 197

END update_purpose ;

Line: 214

PROCEDURE delete_purpose ( p_api_version	    IN  NUMBER
                          ,p_init_msg_list   IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
                          ,x_return_status   OUT NOCOPY VARCHAR2
                          ,x_msg_count	      OUT NOCOPY NUMBER
                          ,x_msg_data	       OUT NOCOPY VARCHAR2
                          ,p_strm_tbl        IN  okl_cash_dtls_tbl_type
                          ,x_strm_tbl        OUT NOCOPY okl_cash_dtls_tbl_type
                         ) IS

--Initialize return status.
   l_return_status     VARCHAR2(1) DEFAULT Okl_Api.G_RET_STS_SUCCESS;

Line: 232

   SAVEPOINT save_delete_purpose;

Line: 240

   Okl_Bpd_Cap_Purpose_Pvt.delete_purpose(  p_api_version
                                           ,p_init_msg_list
                                           ,x_return_status
                                           ,x_msg_count
                                           ,x_msg_data
                                           ,p_strm_tbl
                                           ,x_strm_tbl
                                          );

Line: 273

        ROLLBACK TO save_delete_purpose;

Line: 280

       ROLLBACK TO save_delete_purpose;

Line: 287

       ROLLBACK TO save_delete_purpose;

Line: 291

       Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');

Line: 295

END delete_purpose ;