119: INDEX BY BINARY_INTEGER;
120: TYPE tapv_rec_type IS RECORD (
121: id NUMBER := OKL_API.G_MISS_NUM,
122: object_version_number NUMBER := OKL_API.G_MISS_NUM,
123: sfwt_flag OKL_TRX_AP_INVOICES_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
124: cct_id NUMBER := OKL_API.G_MISS_NUM,
125: currency_code OKL_TRX_AP_INVOICES_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
126: ccf_id NUMBER := OKL_API.G_MISS_NUM,
127: funding_type_code OKL_TRX_AP_INVOICES_V.FUNDING_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
121: id NUMBER := OKL_API.G_MISS_NUM,
122: object_version_number NUMBER := OKL_API.G_MISS_NUM,
123: sfwt_flag OKL_TRX_AP_INVOICES_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
124: cct_id NUMBER := OKL_API.G_MISS_NUM,
125: currency_code OKL_TRX_AP_INVOICES_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
126: ccf_id NUMBER := OKL_API.G_MISS_NUM,
127: funding_type_code OKL_TRX_AP_INVOICES_V.FUNDING_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
128: khr_id NUMBER := OKL_API.G_MISS_NUM,
129: art_id NUMBER := OKL_API.G_MISS_NUM,
123: sfwt_flag OKL_TRX_AP_INVOICES_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
124: cct_id NUMBER := OKL_API.G_MISS_NUM,
125: currency_code OKL_TRX_AP_INVOICES_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
126: ccf_id NUMBER := OKL_API.G_MISS_NUM,
127: funding_type_code OKL_TRX_AP_INVOICES_V.FUNDING_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR,
128: khr_id NUMBER := OKL_API.G_MISS_NUM,
129: art_id NUMBER := OKL_API.G_MISS_NUM,
130: tap_id_reverses NUMBER := OKL_API.G_MISS_NUM,
131: ippt_id NUMBER := OKL_API.G_MISS_NUM,
134: tcn_id NUMBER := OKL_API.G_MISS_NUM,
135: vpa_id NUMBER := OKL_API.G_MISS_NUM,
136: ipt_id NUMBER := OKL_API.G_MISS_NUM,
137: qte_id NUMBER := OKL_API.G_MISS_NUM,
138: invoice_category_code OKL_TRX_AP_INVOICES_V.INVOICE_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
139: payment_method_code OKL_TRX_AP_INVOICES_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
140: cplv_id NUMBER := OKL_API.G_MISS_NUM,
141: pox_id NUMBER := OKL_API.G_MISS_NUM,
142: amount NUMBER := OKL_API.G_MISS_NUM,
135: vpa_id NUMBER := OKL_API.G_MISS_NUM,
136: ipt_id NUMBER := OKL_API.G_MISS_NUM,
137: qte_id NUMBER := OKL_API.G_MISS_NUM,
138: invoice_category_code OKL_TRX_AP_INVOICES_V.INVOICE_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
139: payment_method_code OKL_TRX_AP_INVOICES_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
140: cplv_id NUMBER := OKL_API.G_MISS_NUM,
141: pox_id NUMBER := OKL_API.G_MISS_NUM,
142: amount NUMBER := OKL_API.G_MISS_NUM,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
139: payment_method_code OKL_TRX_AP_INVOICES_V.PAYMENT_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
140: cplv_id NUMBER := OKL_API.G_MISS_NUM,
141: pox_id NUMBER := OKL_API.G_MISS_NUM,
142: amount NUMBER := OKL_API.G_MISS_NUM,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144: invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145: date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
140: cplv_id NUMBER := OKL_API.G_MISS_NUM,
141: pox_id NUMBER := OKL_API.G_MISS_NUM,
142: amount NUMBER := OKL_API.G_MISS_NUM,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144: invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145: date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
141: pox_id NUMBER := OKL_API.G_MISS_NUM,
142: amount NUMBER := OKL_API.G_MISS_NUM,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144: invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145: date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
142: amount NUMBER := OKL_API.G_MISS_NUM,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144: invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145: date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
143: date_invoiced OKL_TRX_AP_INVOICES_V.DATE_INVOICED%TYPE := OKL_API.G_MISS_DATE,
144: invoice_number OKL_TRX_AP_INVOICES_V.INVOICE_NUMBER%TYPE := OKL_API.G_MISS_CHAR,
145: date_funding_approved OKL_TRX_AP_INVOICES_V.DATE_FUNDING_APPROVED%TYPE := OKL_API.G_MISS_DATE,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151: wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
146: date_gl OKL_TRX_AP_INVOICES_V.DATE_GL%TYPE := OKL_API.G_MISS_DATE,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151: wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
152: date_requisition OKL_TRX_AP_INVOICES_V.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
153: description OKL_TRX_AP_INVOICES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
154: CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
147: workflow_yn OKL_TRX_AP_INVOICES_V.WORKFLOW_YN%TYPE := OKL_API.G_MISS_CHAR,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151: wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
152: date_requisition OKL_TRX_AP_INVOICES_V.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
153: description OKL_TRX_AP_INVOICES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
154: CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
155: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
148: match_required_yn OKL_TRX_AP_INVOICES_B.MATCH_REQUIRED_YN%TYPE := OKL_API.G_MISS_CHAR,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151: wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
152: date_requisition OKL_TRX_AP_INVOICES_V.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
153: description OKL_TRX_AP_INVOICES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
154: CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
155: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
156: CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
149: ipt_frequency OKL_TRX_AP_INVOICES_B.IPT_FREQUENCY%TYPE := OKL_API.G_MISS_CHAR,
150: consolidate_yn OKL_TRX_AP_INVOICES_V.CONSOLIDATE_YN%TYPE := OKL_API.G_MISS_CHAR,
151: wait_vendor_invoice_yn OKL_TRX_AP_INVOICES_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
152: date_requisition OKL_TRX_AP_INVOICES_V.DATE_REQUISITION%TYPE := OKL_API.G_MISS_DATE,
153: description OKL_TRX_AP_INVOICES_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
154: CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
155: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
156: CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
157: vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
154: CURRENCY_CONVERSION_TYPE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
155: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
156: CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
157: vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
158: attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
155: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
156: CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
157: vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
158: attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
156: CURRENCY_CONVERSION_DATE OKL_TRX_AP_INVOICES_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
157: vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
158: attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
157: vendor_id OKL_TRX_AP_INVOICES_B.vendor_id%TYPE := OKL_API.G_MISS_NUM,
158: attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
158: attribute_category OKL_TRX_AP_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
159: attribute1 OKL_TRX_AP_INVOICES_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
160: attribute2 OKL_TRX_AP_INVOICES_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
161: attribute3 OKL_TRX_AP_INVOICES_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
162: attribute4 OKL_TRX_AP_INVOICES_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
163: attribute5 OKL_TRX_AP_INVOICES_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
164: attribute6 OKL_TRX_AP_INVOICES_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
165: attribute7 OKL_TRX_AP_INVOICES_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
166: attribute8 OKL_TRX_AP_INVOICES_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
167: attribute9 OKL_TRX_AP_INVOICES_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175: trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
168: attribute10 OKL_TRX_AP_INVOICES_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175: trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
176: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
169: attribute11 OKL_TRX_AP_INVOICES_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175: trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
176: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
177: try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
170: attribute12 OKL_TRX_AP_INVOICES_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175: trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
176: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
177: try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
178: request_id NUMBER := OKL_API.G_MISS_NUM,
171: attribute13 OKL_TRX_AP_INVOICES_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
172: attribute14 OKL_TRX_AP_INVOICES_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
173: attribute15 OKL_TRX_AP_INVOICES_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
174: date_entered OKL_TRX_AP_INVOICES_V.DATE_ENTERED%TYPE := OKL_API.G_MISS_DATE,
175: trx_status_code OKL_TRX_AP_INVOICES_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR, -- Post postgen changes
176: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, -- Post postgen changes
177: try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
178: request_id NUMBER := OKL_API.G_MISS_NUM,
179: program_application_id NUMBER := OKL_API.G_MISS_NUM,
177: try_id NUMBER := OKL_API.G_MISS_NUM, -- Post postgen changes
178: request_id NUMBER := OKL_API.G_MISS_NUM,
179: program_application_id NUMBER := OKL_API.G_MISS_NUM,
180: program_id NUMBER := OKL_API.G_MISS_NUM,
181: program_update_date OKL_TRX_AP_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
182: org_id NUMBER := OKL_API.G_MISS_NUM,
183: created_by NUMBER := OKL_API.G_MISS_NUM,
184: creation_date OKL_TRX_AP_INVOICES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
185: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
180: program_id NUMBER := OKL_API.G_MISS_NUM,
181: program_update_date OKL_TRX_AP_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
182: org_id NUMBER := OKL_API.G_MISS_NUM,
183: created_by NUMBER := OKL_API.G_MISS_NUM,
184: creation_date OKL_TRX_AP_INVOICES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
185: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
186: last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187: last_update_login NUMBER := OKL_API.G_MISS_NUM,
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
182: org_id NUMBER := OKL_API.G_MISS_NUM,
183: created_by NUMBER := OKL_API.G_MISS_NUM,
184: creation_date OKL_TRX_AP_INVOICES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
185: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
186: last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187: last_update_login NUMBER := OKL_API.G_MISS_NUM,
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189: pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
184: creation_date OKL_TRX_AP_INVOICES_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
185: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
186: last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187: last_update_login NUMBER := OKL_API.G_MISS_NUM,
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189: pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
185: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
186: last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187: last_update_login NUMBER := OKL_API.G_MISS_NUM,
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189: pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
186: last_update_date OKL_TRX_AP_INVOICES_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
187: last_update_login NUMBER := OKL_API.G_MISS_NUM,
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189: pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
194: legal_entity_id OKL_TRX_AP_INVOICES_V.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
188: invoice_type OKL_TRX_AP_INVOICES_V.invoice_type%TYPE,
189: pay_group_lookup_code OKL_TRX_AP_INVOICES_V.pay_group_lookup_code%TYPE,
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
194: legal_entity_id OKL_TRX_AP_INVOICES_V.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
195: ,transaction_date OKL_TRX_AP_INVOICES_V.transaction_date%TYPE := OKL_API.G_MISS_DATE);
196: g_miss_tapv_rec tapv_rec_type;
190: vendor_invoice_number OKL_TRX_AP_INVOICES_V.vendor_invoice_number%TYPE,
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
194: legal_entity_id OKL_TRX_AP_INVOICES_V.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
195: ,transaction_date OKL_TRX_AP_INVOICES_V.transaction_date%TYPE := OKL_API.G_MISS_DATE);
196: g_miss_tapv_rec tapv_rec_type;
197: TYPE tapv_tbl_type IS TABLE OF tapv_rec_type
198: INDEX BY BINARY_INTEGER;
191: nettable_yn OKL_TRX_AP_INVOICES_B.nettable_yn%TYPE,
192: ASSET_TAP_ID OKL_TRX_AP_INVOICES_V.ASSET_TAP_ID%TYPE := OKL_API.G_MISS_NUM ,
193: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
194: legal_entity_id OKL_TRX_AP_INVOICES_V.legal_entity_id%TYPE := OKL_API.G_MISS_NUM
195: ,transaction_date OKL_TRX_AP_INVOICES_V.transaction_date%TYPE := OKL_API.G_MISS_DATE);
196: g_miss_tapv_rec tapv_rec_type;
197: TYPE tapv_tbl_type IS TABLE OF tapv_rec_type
198: INDEX BY BINARY_INTEGER;
199: ---------------------------------------------------------------------------
221: ---------------------------------------------------------------------------
222: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAP_PVT';
223: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
224: -- Post-Gen Begin-0
225: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AP_INVOICES_V';
226: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
227: -- Post-Gen End-0
228: ---------------------------------------------------------------------------
229: -- Procedures and Functions