6: -- Start of comments
7: --
8: -- Procedure Name : create_purpose
9: -- Description : procedure for inserting the records in
10: -- table OKL_TXL_RCPT_APPS_B
11: -- Business Rules :
12: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
13: -- x_msg_data, p_strm_tbl, x_strm_tbl.
14: -- Version : 1.0
29: ---------------------------
30: l_strm_rec okl_cash_dtls_rec_type;
31: l_strm_tbl okl_cash_dtls_tbl_type;
32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
37: i NUMBER DEFAULT NULL;
30: l_strm_rec okl_cash_dtls_rec_type;
31: l_strm_tbl okl_cash_dtls_tbl_type;
32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
37: i NUMBER DEFAULT NULL;
38: j NUMBER DEFAULT NULL;
31: l_strm_tbl okl_cash_dtls_tbl_type;
32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
37: i NUMBER DEFAULT NULL;
38: j NUMBER DEFAULT NULL;
39: l_api_version NUMBER := 1.0;
32: l_cust_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL;
33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL;
36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
37: i NUMBER DEFAULT NULL;
38: j NUMBER DEFAULT NULL;
39: l_api_version NUMBER := 1.0;
40: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
216: -- Start of comments
217: --
218: -- Procedure Name : update_purpose
219: -- Description : procedure for updating the records in
220: -- table OKL_TXL_RCPT_APPS_B
221: -- Business Rules :
222: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
223: -- x_msg_data, p_strm_tbl, x_strm_tbl.
224: -- Version : 1.0
238: -- DECLARE Local Variables
239: ---------------------------
240: l_strm_rec okl_cash_dtls_rec_type;
241: l_strm_tbl okl_cash_dtls_tbl_type;
242: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
243: i NUMBER DEFAULT NULL;
244: j NUMBER DEFAULT NULL;
245: l_api_version NUMBER := 1.0;
246: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
373: -- Start of comments
374: --
375: -- Procedure Name : delete_purpose
376: -- Description : procedure for deleting the records in
377: -- table OKL_TXL_RCPT_APPS_B
378: -- Business Rules :
379: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
380: -- x_msg_data, p_strm_tbl, x_strm_tbl.
381: -- Version : 1.0
395: -- DECLARE Local Variables
396: ---------------------------
397: l_strm_rec okl_cash_dtls_rec_type;
398: l_strm_tbl okl_cash_dtls_tbl_type;
399: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
400: i NUMBER DEFAULT NULL;
401: j NUMBER DEFAULT NULL;
402: l_api_version NUMBER := 1.0;
403: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;