APPS.OKL_BPD_CAP_PURPOSE_PVT dependencies on OKL_TXL_RCPT_APPS_B

Line 13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,

9: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10:
11:
12: TYPE okl_cash_dtls_rec_type IS RECORD (
13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,

Line 14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,

10:
11:
12: TYPE okl_cash_dtls_rec_type IS RECORD (
13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL

Line 15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,

11:
12: TYPE okl_cash_dtls_rec_type IS RECORD (
13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL
19: );

Line 16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,

12: TYPE okl_cash_dtls_rec_type IS RECORD (
13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL
19: );
20:

Line 17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,

13: id OKL_TXL_RCPT_APPS_B.ID%TYPE DEFAULT NULL,
14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL
19: );
20:
21:

Line 18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL

14: customer_id OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE DEFAULT NULL,
15: contract_id OKL_TXL_RCPT_APPS_B.KHR_ID%TYPE DEFAULT NULL,
16: receipt_id OKL_TXL_RCPT_APPS_B.RCT_ID_DETAILS%TYPE DEFAULT NULL,
17: sty_id OKL_TXL_RCPT_APPS_B.STY_ID%TYPE DEFAULT NULL,
18: amount OKL_TXL_RCPT_APPS_B.AMOUNT%TYPE DEFAULT NULL
19: );
20:
21:
22:

Line 36: -- table OKL_TXL_RCPT_APPS_B

32: -- Start of comments
33: --
34: -- Procedure Name : create_purpose
35: -- Description : procedure for inserting the records in
36: -- table OKL_TXL_RCPT_APPS_B
37: -- Business Rules :
38: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
39: -- x_msg_data, p_strm_tbl, x_strm_tbl.
40: -- Version : 1.0

Line 59: -- table OKL_TXL_RCPT_APPS_B

55: -- Start of comments
56: --
57: -- Procedure Name : update_purpose
58: -- Description : procedure for updating the records in
59: -- table OKL_TXL_RCPT_APPS_B
60: -- Business Rules :
61: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
62: -- x_msg_data, p_strm_tbl, x_strm_tbl.
63: -- Version : 1.0

Line 83: -- table OKL_TXL_RCPT_APPS_B

79: -- Start of comments
80: --
81: -- Procedure Name : delete_purpose
82: -- Description : procedure for deleting the records in
83: -- table OKL_TXL_RCPT_APPS_B
84: -- Business Rules :
85: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
86: -- x_msg_data, p_strm_tbl, x_strm_tbl.
87: -- Version : 1.0