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,
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,
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,
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,
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,
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
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
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: ---------------------------------------------------------------------------
137: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
138:
139:
140: --GLOBAL VARIABLES
141: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CNSLD_AR_HDRS_V';
142: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
143:
144: ---------------------------------------------------------------------------
145: -- Procedures and Functions