3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cnr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cnr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cnr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
6: TYPE cnr_rec_type IS RECORD (
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
7: id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
8: consolidated_invoice_number OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
9: trx_status_code OKL_CNSLD_AR_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
10: currency_code OKL_CNSLD_AR_HDRS_B.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
11: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
12: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
14: irm_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
15: inf_id NUMBER := Okc_Api.G_MISS_NUM,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
16: amount NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
17: date_consolidated OKL_CNSLD_AR_HDRS_B.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
18: invoice_pull_yn OKL_CNSLD_AR_HDRS_B.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
19: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
20: request_id NUMBER := Okc_Api.G_MISS_NUM,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
21: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
22: program_id NUMBER := Okc_Api.G_MISS_NUM,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
23: program_update_date OKL_CNSLD_AR_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
24: org_id NUMBER := Okc_Api.G_MISS_NUM,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
25: due_date OKL_CNSLD_AR_HDRS_B.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
26: attribute_category OKL_CNSLD_AR_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
27: attribute1 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
28: attribute2 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
29: attribute3 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
30: attribute4 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
31: attribute5 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
32: attribute6 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
33: attribute7 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
34: attribute8 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
35: attribute9 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
36: attribute10 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
37: attribute11 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
38: attribute12 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
39: attribute13 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47: legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
40: attribute14 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47: legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
48: g_miss_cnr_rec cnr_rec_type;
41: attribute15 OKL_CNSLD_AR_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47: legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
48: g_miss_cnr_rec cnr_rec_type;
49: TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
42: created_by NUMBER := Okc_Api.G_MISS_NUM,
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47: legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
48: g_miss_cnr_rec cnr_rec_type;
49: TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
50: INDEX BY BINARY_INTEGER;
43: creation_date OKL_CNSLD_AR_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
44: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
45: last_update_date OKL_CNSLD_AR_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
46: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
47: legal_entity_id OKL_CNSLD_AR_HDRS_B.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
48: g_miss_cnr_rec cnr_rec_type;
49: TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
48: g_miss_cnr_rec cnr_rec_type;
49: TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
52: id NUMBER := Okc_Api.G_MISS_NUM,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
49: TYPE cnr_tbl_type IS TABLE OF cnr_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
52: id NUMBER := Okc_Api.G_MISS_NUM,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
50: INDEX BY BINARY_INTEGER;
51: TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
52: id NUMBER := Okc_Api.G_MISS_NUM,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
51: TYPE okl_cnsld_ar_hdrs_tl_rec_type IS RECORD (
52: id NUMBER := Okc_Api.G_MISS_NUM,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
52: id NUMBER := Okc_Api.G_MISS_NUM,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
53: LANGUAGE OKL_CNSLD_AR_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
54: source_lang OKL_CNSLD_AR_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
62: GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
55: sfwt_flag OKL_CNSLD_AR_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
62: GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
63: TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
56: private_label_logo_url OKL_CNSLD_AR_HDRS_TL.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
62: GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
63: TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
64: INDEX BY BINARY_INTEGER;
57: created_by NUMBER := Okc_Api.G_MISS_NUM,
58: creation_date OKL_CNSLD_AR_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
60: last_update_date OKL_CNSLD_AR_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okc_Api.G_MISS_NUM);
62: GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
63: TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE cnrv_rec_type IS RECORD (
62: GMissOklCnsldArHdrsTlRec okl_cnsld_ar_hdrs_tl_rec_type;
63: TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE cnrv_rec_type IS RECORD (
66: id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
63: TYPE okl_cnsld_ar_hdrs_tl_tbl_type IS TABLE OF okl_cnsld_ar_hdrs_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE cnrv_rec_type IS RECORD (
66: id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
64: INDEX BY BINARY_INTEGER;
65: TYPE cnrv_rec_type IS RECORD (
66: id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
65: TYPE cnrv_rec_type IS RECORD (
66: id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
66: id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
67: object_version_number NUMBER := Okc_Api.G_MISS_NUM,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
68: sfwt_flag OKL_CNSLD_AR_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
69: ibt_id NUMBER := Okc_Api.G_MISS_NUM,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
70: ixx_id NUMBER := Okc_Api.G_MISS_NUM,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
71: currency_code OKL_CNSLD_AR_HDRS_V.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
72: irm_id NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
73: inf_id NUMBER := Okc_Api.G_MISS_NUM,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
74: set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
75: consolidated_invoice_number OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
76: trx_status_code OKL_CNSLD_AR_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
77: invoice_pull_yn OKL_CNSLD_AR_HDRS_V.INVOICE_PULL_YN%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
78: date_consolidated OKL_CNSLD_AR_HDRS_V.DATE_CONSOLIDATED%TYPE := Okc_Api.G_MISS_DATE,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
79: private_label_logo_url OKL_CNSLD_AR_HDRS_V.PRIVATE_LABEL_LOGO_URL%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
80: amount NUMBER := Okc_Api.G_MISS_NUM,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
81: due_date OKL_CNSLD_AR_HDRS_V.DUE_DATE%TYPE := Okc_Api.G_MISS_DATE,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
82: attribute_category OKL_CNSLD_AR_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
83: attribute1 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
84: attribute2 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
85: attribute3 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
86: attribute4 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
87: attribute5 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
88: attribute6 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
89: attribute7 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
90: attribute8 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
91: attribute9 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
92: attribute10 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
93: attribute11 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
94: attribute12 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
95: attribute13 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
96: attribute14 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
97: attribute15 OKL_CNSLD_AR_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
98: request_id NUMBER := Okc_Api.G_MISS_NUM,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
99: program_application_id NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
100: program_id NUMBER := Okc_Api.G_MISS_NUM,
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108: legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
101: program_update_date OKL_CNSLD_AR_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108: legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
109: g_miss_cnrv_rec cnrv_rec_type;
102: org_id NUMBER := Okc_Api.G_MISS_NUM,
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108: legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
109: g_miss_cnrv_rec cnrv_rec_type;
110: TYPE cnrv_tbl_type IS TABLE OF cnrv_rec_type
103: created_by NUMBER := Okc_Api.G_MISS_NUM,
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108: legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
109: g_miss_cnrv_rec cnrv_rec_type;
110: TYPE cnrv_tbl_type IS TABLE OF cnrv_rec_type
111: INDEX BY BINARY_INTEGER;
104: creation_date OKL_CNSLD_AR_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
105: last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
106: last_update_date OKL_CNSLD_AR_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
107: last_update_login NUMBER := Okc_Api.G_MISS_NUM,
108: legal_entity_id OKL_CNSLD_AR_HDRS_V.LEGAL_ENTITY_ID%TYPE := Okc_Api.G_MISS_NUM); -- for LE Uptake project 08-11-2006
109: g_miss_cnrv_rec cnrv_rec_type;
110: TYPE cnrv_tbl_type IS TABLE OF cnrv_rec_type
111: INDEX BY BINARY_INTEGER;
112: ---------------------------------------------------------------------------
111: INDEX BY BINARY_INTEGER;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
128: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNR_PVT';
125: ---------------------------------------------------------------------------
126: -- GLOBAL VARIABLES
127: ---------------------------------------------------------------------------
128: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CNR_PVT';
129: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
130:
131: /*************ADDED AFTER TAPI, Sunil T. Mathew (04/19/2001) ****************/
132: --GLOBAL MESSAGES
133: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
150: PROCEDURE api_copy;
151: PROCEDURE add_language;
152: PROCEDURE insert_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_cnrv_rec IN cnrv_rec_type,
159: x_cnrv_rec OUT NOCOPY cnrv_rec_type);
160:
161: PROCEDURE insert_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_cnrv_tbl IN cnrv_tbl_type,
168: x_cnrv_tbl OUT NOCOPY cnrv_tbl_type);
169:
170: PROCEDURE lock_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_cnrv_rec IN cnrv_rec_type);
176: p_cnrv_rec IN cnrv_rec_type);
177:
178: PROCEDURE lock_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cnrv_tbl IN cnrv_tbl_type);
184: p_cnrv_tbl IN cnrv_tbl_type);
185:
186: PROCEDURE update_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_cnrv_rec IN cnrv_rec_type,
193: x_cnrv_rec OUT NOCOPY cnrv_rec_type);
194:
195: PROCEDURE update_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_cnrv_tbl IN cnrv_tbl_type,
202: x_cnrv_tbl OUT NOCOPY cnrv_tbl_type);
203:
204: PROCEDURE delete_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_cnrv_rec IN cnrv_rec_type);
210: p_cnrv_rec IN cnrv_rec_type);
211:
212: PROCEDURE delete_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_cnrv_tbl IN cnrv_tbl_type);
218: p_cnrv_tbl IN cnrv_tbl_type);
219:
220: PROCEDURE validate_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_cnrv_rec IN cnrv_rec_type);
226: p_cnrv_rec IN cnrv_rec_type);
227:
228: PROCEDURE validate_row(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_cnrv_tbl IN cnrv_tbl_type);