DBA Data[Home] [Help]

APPS.OKL_UPDT_CASH_DTLS dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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:

Line 17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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;

Line 18: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;

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;

Line 19: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;

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;

Line 27: customer_id Okl_cnsld_ar_hdrs_b.ixx_Id%TYPE := Okl_Api.G_MISS_NUM,

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,

Line 28: customer_name hz_Parties.Party_Name%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,

Line 29: customer_number hz_cUst_Accounts.Account_Number%TYPE := Okl_Api.G_MISS_CHAR,

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,

Line 30: consolidated_invoice_id Okl_cnsld_ar_hdrs_b.ID%TYPE := Okl_Api.G_MISS_NUM,

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,

Line 31: consolidated_invoice_number Okl_cnsld_ar_hdrs_b.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

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,

Line 32: contract_id Okl_cnsld_ar_strms_b.KHR_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,
36: ext_cash_apps_id NUMBER,

Line 33: contract_number Okc_k_Headers_All_b.CONTRACT_NUMBER%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,
37: xtl_cash_apps_id NUMBER,

Line 34: contract_line_id Okl_cnsld_ar_strms_b.KLE_ID%TYPE := Okl_Api.G_MISS_NUM,

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,

Line 35: receipt_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

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,

Line 38: receivables_invoice_id Okl_cnsld_ar_strms_b.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,

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,

Line 39: ar_invoice_number ar_Payment_Schedules_All.TRX_NUMBER%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,

Line 40: asset_id fa_Additions_v.ASSET_ID%TYPE, --:= Okl_Api.G_MISS_NUM, -- causes an error.

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,

Line 41: asset_number fa_Additions_v.ASSET_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,

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,

Line 42: asset_name fa_Additions_v.description%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,

Line 43: lsm_id Okl_cnsld_ar_strms_b.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,
47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);

Line 44: stream_id Okl_strm_Type_v.ID%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:

Line 45: stream_name Okl_strm_Type_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,

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

Line 46: outstanding_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM,

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;

Line 47: applied_stream_amount OKL_RECEIPT_APPLICATIONS_UV.line_applied%TYPE := Okl_Api.G_MISS_NUM);

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: