APPS.OKL_UPDT_CASH_DTLS dependencies on OKL_TXL_RCPT_APPS_B

Line 23: l_lsm_id OKL_TXL_RCPT_APPS_B.LSM_ID%TYPE;

19: ---------------------------
20:
21: l_strm_tbl okl_cash_dtls_tbl_type;
22:
23: l_lsm_id OKL_TXL_RCPT_APPS_B.LSM_ID%TYPE;
24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;
25: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
26: l_xcr_id_details NUMBER DEFAULT NULL;
27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id

Line 24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;

20:
21: l_strm_tbl okl_cash_dtls_tbl_type;
22:
23: l_lsm_id OKL_TXL_RCPT_APPS_B.LSM_ID%TYPE;
24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;
25: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
26: l_xcr_id_details NUMBER DEFAULT NULL;
27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id
28: l_khr_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL; -- contract id

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

21: l_strm_tbl okl_cash_dtls_tbl_type;
22:
23: l_lsm_id OKL_TXL_RCPT_APPS_B.LSM_ID%TYPE;
24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;
25: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
26: l_xcr_id_details NUMBER DEFAULT NULL;
27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id
28: l_khr_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL; -- contract id
29:

Line 27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id

23: l_lsm_id OKL_TXL_RCPT_APPS_B.LSM_ID%TYPE;
24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;
25: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
26: l_xcr_id_details NUMBER DEFAULT NULL;
27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id
28: l_khr_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL; -- contract id
29:
30:
31: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;

Line 28: l_khr_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL; -- contract id

24: l_rca_id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL;
25: l_rct_id_details OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL;
26: l_xcr_id_details NUMBER DEFAULT NULL;
27: l_cnr_id OKL_TXL_RCPT_APPS_B.CNR_ID%TYPE DEFAULT NULL; -- consolidated bill id
28: l_khr_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL; -- contract id
29:
30:
31: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT NULL;
32:

Line 179: DELETE FROM OKL_TXL_RCPT_APPS_B

175: DELETE FROM OKL_TRX_CSH_RECEIPT_B
176: WHERE ID = l_rct_id_details;
177:
178: -- clear up internal receipt lines
179: DELETE FROM OKL_TXL_RCPT_APPS_B
180: WHERE RCT_ID_DETAILS = l_rct_id_details;
181:
182: -- clear up external receipt
183: DELETE FROM OKL_EXT_CSH_RCPTS_B