7: ---------------------------------------------------------------------------
8: -- GLOBAL VARIABLES
9: ---------------------------------------------------------------------------
10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15:
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15:
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UPDT_CASH_DTLS';
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
19: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
20: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15:
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UPDT_CASH_DTLS';
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
19: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
20: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
15:
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_UPDT_CASH_DTLS';
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
19: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
20: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
21: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
22: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24:
25:
26: TYPE okl_cash_dtls_rec_type IS RECORD (
27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
24:
25:
26: TYPE okl_cash_dtls_rec_type IS RECORD (
27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
25:
26: TYPE okl_cash_dtls_rec_type IS RECORD (
27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
26: TYPE okl_cash_dtls_rec_type IS RECORD (
27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
28: customer_name hz_Parties.Party_Name%TYPE := Okl_Api.G_MISS_CHAR,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
32: contract_id Okl_cnsld_ar_strms_b.KHR_ID%TYPE := Okl_Api.G_MISS_NUM,
33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
36: ext_cash_apps_id NUMBER,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
37: xtl_cash_apps_id NUMBER,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
48:
41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
48:
49: TYPE okl_cash_dtls_tbl_type IS TABLE OF okl_cash_dtls_rec_type
42: asset_name fa_Additions_v.description%TYPE := Okl_Api.G_MISS_CHAR,
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
48:
49: TYPE okl_cash_dtls_tbl_type IS TABLE OF okl_cash_dtls_rec_type
50: INDEX BY BINARY_INTEGER;
43: lsm_id Okl_cnsld_ar_strms_b.ID%TYPE := Okl_Api.G_MISS_NUM,
44: stream_id Okl_strm_Type_v.ID%TYPE := Okl_Api.G_MISS_NUM,
45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,
46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);
48:
49: TYPE okl_cash_dtls_tbl_type IS TABLE OF okl_cash_dtls_rec_type
50: INDEX BY BINARY_INTEGER;
51: