23: l_return_status VARCHAR2(1);
24: l_msg_count NUMBER := 0;
25: l_msg_data VARCHAR2(2000);
26:
27: l_trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE DEFAULT NULL;
28:
29: i NUMBER DEFAULT NULL;
30: j NUMBER DEFAULT NULL;
31: k NUMBER DEFAULT NULL;
30: j NUMBER DEFAULT NULL;
31: k NUMBER DEFAULT NULL;
32:
33: /*
34: l_org_id OKL_TRX_CSH_BATCH_B.ORG_ID%TYPE DEFAULT NULL;
35:
36: l_id OKL_TRX_CSH_BATCH_B.ID%TYPE DEFAULT NULL;
37: l_name OKL_TRX_CSH_BATCH_TL.NAME%TYPE DEFAULT NULL;
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
32:
33: /*
34: l_org_id OKL_TRX_CSH_BATCH_B.ORG_ID%TYPE DEFAULT NULL;
35:
36: l_id OKL_TRX_CSH_BATCH_B.ID%TYPE DEFAULT NULL;
37: l_name OKL_TRX_CSH_BATCH_TL.NAME%TYPE DEFAULT NULL;
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
34: l_org_id OKL_TRX_CSH_BATCH_B.ORG_ID%TYPE DEFAULT NULL;
35:
36: l_id OKL_TRX_CSH_BATCH_B.ID%TYPE DEFAULT NULL;
37: l_name OKL_TRX_CSH_BATCH_TL.NAME%TYPE DEFAULT NULL;
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
41: l_date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE DEFAULT NULL;
42: l_date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE DEFAULT NULL;
35:
36: l_id OKL_TRX_CSH_BATCH_B.ID%TYPE DEFAULT NULL;
37: l_name OKL_TRX_CSH_BATCH_TL.NAME%TYPE DEFAULT NULL;
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
41: l_date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE DEFAULT NULL;
42: l_date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE DEFAULT NULL;
43: l_trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE DEFAULT NULL;
37: l_name OKL_TRX_CSH_BATCH_TL.NAME%TYPE DEFAULT NULL;
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
41: l_date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE DEFAULT NULL;
42: l_date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE DEFAULT NULL;
43: l_trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE DEFAULT NULL;
44: */
45:
38: l_batch_qty OKL_TRX_CSH_BATCH_B.BATCH_QTY%TYPE DEFAULT NULL;
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
41: l_date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE DEFAULT NULL;
42: l_date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE DEFAULT NULL;
43: l_trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE DEFAULT NULL;
44: */
45:
46: ------------------------------
39: l_batch_total OKL_TRX_CSH_BATCH_B.BATCH_TOTAL%TYPE DEFAULT NULL;
40: l_currency_code OKL_TRX_CSH_RECEIPT_B.CURRENCY_CODE%TYPE DEFAULT NULL;
41: l_date_deposit OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE DEFAULT NULL;
42: l_date_gl_requested OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE DEFAULT NULL;
43: l_trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE DEFAULT NULL;
44: */
45:
46: ------------------------------
47: -- DECLARE Record/Table Types