DBA Data[Home] [Help]

APPS.OKL_BPD_CAP_PURPOSE_PVT dependencies on OKL_TXL_RCPT_APPS_B

Line 10: -- table OKL_TXL_RCPT_APPS_B

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

Line 33: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;

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;

Line 34: l_total_amount_applied OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE 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;

Line 35: l_receipt_amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE 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;

Line 36: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

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;

Line 220: -- table OKL_TXL_RCPT_APPS_B

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

Line 242: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

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;

Line 377: -- table OKL_TXL_RCPT_APPS_B

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

Line 399: l_org_id OKL_TXL_RCPT_APPS_B.ORG_ID%TYPE DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();

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;