APPS.OKL_BPD_CAP_PURPOSE_PVT SQL Statements

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

Line: 68

  SELECT int.id
  FROM OKL_TRX_CSH_RECEIPT_B int--,
--       OKL_EXT_CSH_RCPTS_B ext
--  WHERE int.id = ext.RCT_ID
--   and ext.ID = cp_receipt_id;

Line: 80

  SELECT amount
  FROM ar_cash_receipts_all b
  WHERE b.cash_receipt_id = cp_receipt_id;

Line: 87

   SELECT  authoring_org_id
   FROM   OKC_K_HEADERS_B
   WHERE  id = cp_contract_id;

Line: 167

   okl_Txl_Rcpt_Apps_Pub.insert_txl_rcpt_apps( l_api_version,
                                               l_init_msg_list,
                                               l_return_status,
                                               l_msg_count,
                                               l_msg_data,
                                               l_rcav_tbl,
                                               x_rcav_tbl
                                             );

Line: 228

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

---------------------------
-- DECLARE Local Variables
---------------------------
  l_strm_rec                 okl_cash_dtls_rec_type;

Line: 273

   SELECT  authoring_org_id
   FROM   OKC_K_HEADERS_B
   WHERE  id = cp_contract_id;

Line: 282

SAVEPOINT update_purpose_PVT;

Line: 323

   okl_Txl_Rcpt_Apps_Pub.update_txl_rcpt_apps( l_api_version,
                                               l_init_msg_list,
                                               l_return_status,
                                               l_msg_count,
                                               l_msg_data,
                                               l_rcav_tbl,
                                               x_rcav_tbl
                                             );

Line: 343

        ROLLBACK TO update_purpose_PVT;

Line: 352

       ROLLBACK TO update_purpose_PVT;

Line: 360

       ROLLBACK TO update_purpose_PVT;

Line: 368

END update_purpose;

Line: 385

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

---------------------------
-- DECLARE Local Variables
---------------------------
  l_strm_rec                 okl_cash_dtls_rec_type;

Line: 430

   SELECT  authoring_org_id
   FROM   OKC_K_HEADERS_B
   WHERE  id = cp_contract_id;

Line: 439

SAVEPOINT delete_purpose_PVT;

Line: 474

   okl_Txl_Rcpt_Apps_Pub.delete_txl_rcpt_apps( l_api_version,
                                               l_init_msg_list,
                                               l_return_status,
                                               l_msg_count,
                                               l_msg_data,
                                               l_rcav_tbl
                                             );

Line: 493

        ROLLBACK TO delete_purpose_PVT;

Line: 502

       ROLLBACK TO delete_purpose_PVT;

Line: 510

       ROLLBACK TO delete_purpose_PVT;

Line: 518

END delete_purpose;