3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ael_rec_type IS RECORD (
7: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ael_rec_type IS RECORD (
7: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE ael_rec_type IS RECORD (
7: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
6: TYPE ael_rec_type IS RECORD (
7: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
7: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
8: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
9: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
11: org_id NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
12: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
13: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
14: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
15: source_id NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
17: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
18: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
19: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
20: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
21: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
22: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
23: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
24: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
25: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
26: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
27: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
28: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
29: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
30: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
31: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
32: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
33: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
34: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
35: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
36: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
37: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
38: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
39: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
40: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
41: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
42: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
43: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
44: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
45: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
46: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
47: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
48: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
49: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
50: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
51: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
52: program_id NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
53: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
54: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
55: request_id NUMBER := Okc_Api.G_MISS_NUM,
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
56: created_by NUMBER := Okc_Api.G_MISS_NUM,
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
64: g_miss_ael_rec ael_rec_type;
57: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
64: g_miss_ael_rec ael_rec_type;
65: TYPE ael_tbl_type IS TABLE OF ael_rec_type
58: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
64: g_miss_ael_rec ael_rec_type;
65: TYPE ael_tbl_type IS TABLE OF ael_rec_type
66: INDEX BY BINARY_INTEGER;
59: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
60: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
61: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
62: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
63: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
64: g_miss_ael_rec ael_rec_type;
65: TYPE ael_tbl_type IS TABLE OF ael_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE aelv_rec_type IS RECORD (
64: g_miss_ael_rec ael_rec_type;
65: TYPE ael_tbl_type IS TABLE OF ael_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE aelv_rec_type IS RECORD (
68: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
65: TYPE ael_tbl_type IS TABLE OF ael_rec_type
66: INDEX BY BINARY_INTEGER;
67: TYPE aelv_rec_type IS RECORD (
68: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
66: INDEX BY BINARY_INTEGER;
67: TYPE aelv_rec_type IS RECORD (
68: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
67: TYPE aelv_rec_type IS RECORD (
68: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
68: AE_LINE_ID NUMBER := Okc_Api.G_MISS_NUM,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
69: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
70: AE_HEADER_ID NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
71: currency_conversion_type OKL_AE_LINES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
72: code_combination_id NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
73: org_id NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
74: AE_LINE_NUMBER NUMBER := Okc_Api.G_MISS_NUM,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
75: AE_LINE_TYPE_CODE OKL_AE_LINES.AE_LINE_TYPE_CODE%TYPE := Okc_Api.G_MISS_CHAR,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
76: currency_conversion_date OKL_AE_LINES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
77: currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
78: ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
79: ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
80: ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
81: ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
82: source_table OKL_AE_LINES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
83: source_id NUMBER := Okc_Api.G_MISS_NUM,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
84: reference1 OKL_AE_LINES.REFERENCE1%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
85: reference2 OKL_AE_LINES.REFERENCE2%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
86: reference3 OKL_AE_LINES.REFERENCE3%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
87: reference4 OKL_AE_LINES.REFERENCE4%TYPE := Okc_Api.G_MISS_CHAR,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
88: reference5 OKL_AE_LINES.REFERENCE5%TYPE := Okc_Api.G_MISS_CHAR,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
89: reference6 OKL_AE_LINES.REFERENCE6%TYPE := Okc_Api.G_MISS_CHAR,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
90: reference7 OKL_AE_LINES.REFERENCE7%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
91: reference8 OKL_AE_LINES.REFERENCE8%TYPE := Okc_Api.G_MISS_CHAR,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
92: reference9 OKL_AE_LINES.REFERENCE9%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
93: reference10 OKL_AE_LINES.REFERENCE10%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
94: description OKL_AE_LINES.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
95: third_party_id NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
96: third_party_sub_id NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
97: STAT_AMOUNT NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
98: ussgl_transaction_code OKL_AE_LINES.USSGL_TRANSACTION_CODE%TYPE := Okc_Api.G_MISS_CHAR,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
99: subledger_doc_sequence_id NUMBER := Okc_Api.G_MISS_NUM,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
100: accounting_error_code OKL_AE_LINES.ACCOUNTING_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
101: gl_transfer_error_code OKL_AE_LINES.GL_TRANSFER_ERROR_CODE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
102: GL_SL_LINK_ID NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
103: taxable_ENTERED_DR NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
104: taxable_ENTERED_CR NUMBER := Okc_Api.G_MISS_NUM,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
105: taxable_ACCOUNTED_DR NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
106: taxable_ACCOUNTED_CR NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
107: applied_from_trx_hdr_table OKL_AE_LINES.APPLIED_FROM_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
108: applied_from_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
109: applied_to_trx_hdr_table OKL_AE_LINES.APPLIED_TO_TRX_HDR_TABLE%TYPE := Okc_Api.G_MISS_CHAR,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
110: applied_to_trx_hdr_id NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
111: tax_link_id NUMBER := Okc_Api.G_MISS_NUM,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
112: currency_code OKL_AE_LINES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
113: program_id NUMBER := Okc_Api.G_MISS_NUM,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
114: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
115: program_update_date OKL_AE_LINES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
116: request_id NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
117: aeh_tbl_index NUMBER := Okc_Api.G_MISS_NUM,
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
118: created_by NUMBER := Okc_Api.G_MISS_NUM,
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
126: g_miss_aelv_rec aelv_rec_type;
119: creation_date OKL_AE_LINES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
126: g_miss_aelv_rec aelv_rec_type;
127: TYPE aelv_tbl_type IS TABLE OF aelv_rec_type
120: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
126: g_miss_aelv_rec aelv_rec_type;
127: TYPE aelv_tbl_type IS TABLE OF aelv_rec_type
128: INDEX BY BINARY_INTEGER;
121: last_update_date OKL_AE_LINES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
122: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
123: ACCOUNT_OVERLAY_SOURCE_ID NUMBER := Okc_Api.G_MISS_NUM,
124: SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER := Okc_Api.G_MISS_NUM,
125: TAX_CODE_ID NUMBER := Okc_Api.G_MISS_NUM);
126: g_miss_aelv_rec aelv_rec_type;
127: TYPE aelv_tbl_type IS TABLE OF aelv_rec_type
128: INDEX BY BINARY_INTEGER;
129: --gboomina bug#4648697.changes for perf start
246:
247: ---------------------------------------------------------------------------
248: -- GLOBAL MESSAGE CONSTANTS
249: ---------------------------------------------------------------------------
250: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
247: ---------------------------------------------------------------------------
248: -- GLOBAL MESSAGE CONSTANTS
249: ---------------------------------------------------------------------------
250: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
248: -- GLOBAL MESSAGE CONSTANTS
249: ---------------------------------------------------------------------------
250: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
249: ---------------------------------------------------------------------------
250: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
250: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
251: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
252: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
260: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
253: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
260: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
261: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
254: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
260: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
261: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
262: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
255: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
256: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
257: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
258: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
259: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
260: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
261: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
262: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
263: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
266: ---------------------------------------------------------------------------
267: -- GLOBAL VARIABLES
268: ---------------------------------------------------------------------------
269: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AEL_PVT';
270: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
271: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
272:
273: ---------------------------------------------------------------------------
274: -- Procedures and Functions
278: PROCEDURE change_version;
279: PROCEDURE api_copy;
280: PROCEDURE insert_row(
281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2,
286: p_aelv_rec IN aelv_rec_type,
287: x_aelv_rec OUT NOCOPY aelv_rec_type);
288:
289: PROCEDURE insert_row(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_aelv_tbl IN aelv_tbl_type,
298: --gboomina bug#4648697.changes for perf start
299: --added new procedure for bulk insert
300: PROCEDURE insert_row_perf(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
303: x_return_status OUT NOCOPY VARCHAR2,
304: x_msg_count OUT NOCOPY NUMBER,
305: x_msg_data OUT NOCOPY VARCHAR2,
306: p_aelv_tbl IN aelv_tbl_type,
308: --gboomina bug#4648697.changes for perf end
309:
310: PROCEDURE lock_row(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_aelv_rec IN aelv_rec_type);
316: p_aelv_rec IN aelv_rec_type);
317:
318: PROCEDURE lock_row(
319: p_api_version IN NUMBER,
320: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
321: x_return_status OUT NOCOPY VARCHAR2,
322: x_msg_count OUT NOCOPY NUMBER,
323: x_msg_data OUT NOCOPY VARCHAR2,
324: p_aelv_tbl IN aelv_tbl_type);
324: p_aelv_tbl IN aelv_tbl_type);
325:
326: PROCEDURE update_row(
327: p_api_version IN NUMBER,
328: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2,
332: p_aelv_rec IN aelv_rec_type,
333: x_aelv_rec OUT NOCOPY aelv_rec_type);
334:
335: PROCEDURE update_row(
336: p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_aelv_tbl IN aelv_tbl_type,
342: x_aelv_tbl OUT NOCOPY aelv_tbl_type);
343:
344: PROCEDURE delete_row(
345: p_api_version IN NUMBER,
346: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: p_aelv_rec IN aelv_rec_type);
350: p_aelv_rec IN aelv_rec_type);
351:
352: PROCEDURE delete_row(
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
355: x_return_status OUT NOCOPY VARCHAR2,
356: x_msg_count OUT NOCOPY NUMBER,
357: x_msg_data OUT NOCOPY VARCHAR2,
358: p_aelv_tbl IN aelv_tbl_type);
358: p_aelv_tbl IN aelv_tbl_type);
359:
360: PROCEDURE validate_row(
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_msg_data OUT NOCOPY VARCHAR2,
366: p_aelv_rec IN aelv_rec_type);
366: p_aelv_rec IN aelv_rec_type);
367:
368: PROCEDURE validate_row(
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: p_aelv_tbl IN aelv_tbl_type);