99: INDEX BY BINARY_INTEGER;
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
159: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
159: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM
160: );
186: ---------------------------------------------------------------------------
187: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XPI_PVT';
188: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
189: -- Post-Gen Begin-0
190: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_PAY_INVS_V';
191: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
192: -- Post-Gen End-0
193: ---------------------------------------------------------------------------
194: -- Procedures and Functions