APPS.AR_GTA_TRX_UTIL dependencies on AR_GTA_TRX_LINES_ALL

Line 245: --This record is the data type of AR_GTA_TRX_LINES_ALL;

241: ,consolidation_trx_num ar_gta_trx_headers_all.consolidation_trx_num%TYPE
242: --Yao Zhang add end for bug8605196 ER3 consolidation invoice
243: );
244:
245: --This record is the data type of AR_GTA_TRX_LINES_ALL;
246: TYPE trx_line_rec_type IS RECORD
247: (
248: row_id VARCHAR2(30)
249: ,org_id ar_gta_trx_lines_all.org_id%TYPE

Line 249: ,org_id ar_gta_trx_lines_all.org_id%TYPE

245: --This record is the data type of AR_GTA_TRX_LINES_ALL;
246: TYPE trx_line_rec_type IS RECORD
247: (
248: row_id VARCHAR2(30)
249: ,org_id ar_gta_trx_lines_all.org_id%TYPE
250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE

Line 250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE

246: TYPE trx_line_rec_type IS RECORD
247: (
248: row_id VARCHAR2(30)
249: ,org_id ar_gta_trx_lines_all.org_id%TYPE
250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE

Line 251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE

247: (
248: row_id VARCHAR2(30)
249: ,org_id ar_gta_trx_lines_all.org_id%TYPE
250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE

Line 252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE

248: row_id VARCHAR2(30)
249: ,org_id ar_gta_trx_lines_all.org_id%TYPE
250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE

Line 253: ,line_number ar_gta_trx_lines_all.line_number%TYPE

249: ,org_id ar_gta_trx_lines_all.org_id%TYPE
250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE

Line 254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE

250: ,gta_trx_header_id ar_gta_trx_lines_all.gta_trx_header_id%TYPE
251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE

Line 255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE

251: ,gta_trx_line_id ar_gta_trx_lines_all.gta_trx_line_id%TYPE
252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE

Line 256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE

252: ,matched_flag ar_gta_trx_lines_all.matched_flag%TYPE
253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE

Line 257: ,item_description ar_gta_trx_lines_all.item_description%TYPE

253: ,line_number ar_gta_trx_lines_all.line_number%TYPE
254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE

Line 258: ,item_model ar_gta_trx_lines_all.item_model%TYPE

254: ,ar_trx_line_id ar_gta_trx_lines_all.ar_trx_line_id%TYPE
255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE

Line 259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE

255: ,inventory_item_id ar_gta_trx_lines_all.inventory_item_id%TYPE
256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE

Line 260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE

256: ,item_number VARCHAR2(30)--ar_gta_trx_lines_all.item_number%TYPE
257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE

Line 261: ,uom ar_gta_trx_lines_all.uom%TYPE

257: ,item_description ar_gta_trx_lines_all.item_description%TYPE
258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE

Line 262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE

258: ,item_model ar_gta_trx_lines_all.item_model%TYPE
259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE

Line 263: ,quantity ar_gta_trx_lines_all.quantity%TYPE

259: ,item_tax_denomination ar_gta_trx_lines_all.item_tax_denomination%TYPE
260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE

Line 264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE

260: ,tax_rate ar_gta_trx_lines_all.tax_rate%TYPE
261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE

Line 265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE

261: ,uom ar_gta_trx_lines_all.uom%TYPE
262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE

Line 266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE

262: ,uom_name ar_gta_trx_lines_all.uom_name%TYPE
263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE

Line 267: ,amount ar_gta_trx_lines_all.amount%TYPE

263: ,quantity ar_gta_trx_lines_all.quantity%TYPE
264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE

Line 268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE

264: ,price_flag ar_gta_trx_lines_all.price_flag%TYPE
265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE

Line 269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE

265: ,unit_price ar_gta_trx_lines_all.unit_price%TYPE
266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE

Line 270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE

266: ,unit_tax_price ar_gta_trx_lines_all.unit_tax_price%TYPE
267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE

Line 271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE

267: ,amount ar_gta_trx_lines_all.amount%TYPE
268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE

Line 272: ,request_id ar_gta_trx_lines_all.request_id%TYPE

268: ,original_currency_amount ar_gta_trx_lines_all.original_currency_amount%TYPE
269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE

Line 273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE

269: ,tax_amount ar_gta_trx_lines_all.tax_amount%TYPE
270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE

Line 274: ,program_id ar_gta_trx_lines_all.program_id%TYPE

270: ,discount_flag ar_gta_trx_lines_all.discount_flag%TYPE
271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE

Line 275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE

271: ,enabled_flag ar_gta_trx_lines_all.enabled_flag%TYPE
272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE

Line 276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE

272: ,request_id ar_gta_trx_lines_all.request_id%TYPE
273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE

Line 277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE

273: ,program_applicaton_id ar_gta_trx_lines_all.program_application_id%TYPE
274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE

Line 278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE

274: ,program_id ar_gta_trx_lines_all.program_id%TYPE
275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE

Line 279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE

275: ,program_update_date ar_gta_trx_lines_all.program_update_date%TYPE
276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE

Line 280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE

276: ,attribute_category ar_gta_trx_lines_all.attribute_category%TYPE
277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE

Line 281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE

277: ,attribute1 ar_gta_trx_lines_all.attribute1%TYPE
278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE

Line 282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE

278: ,attribute2 ar_gta_trx_lines_all.attribute2%TYPE
279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE

Line 283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE

279: ,attribute3 ar_gta_trx_lines_all.attribute3%TYPE
280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE

Line 284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE

280: ,attribute4 ar_gta_trx_lines_all.attribute4%TYPE
281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE

Line 285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE

281: ,attribute5 ar_gta_trx_lines_all.attribute5%TYPE
282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE

Line 286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE

282: ,attribute6 ar_gta_trx_lines_all.attribute6%TYPE
283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE

Line 287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE

283: ,attribute7 ar_gta_trx_lines_all.attribute7%TYPE
284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE

Line 288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE

284: ,attribute8 ar_gta_trx_lines_all.attribute8%TYPE
285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE

Line 289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE

285: ,attribute9 ar_gta_trx_lines_all.attribute9%TYPE
286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE

Line 290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE

286: ,attribute10 ar_gta_trx_lines_all.attribute10%TYPE
287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE

Line 291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE

287: ,attribute11 ar_gta_trx_lines_all.attribute11%TYPE
288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE

Line 292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE

288: ,attribute12 ar_gta_trx_lines_all.attribute12%TYPE
289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE
296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE

Line 293: ,created_by ar_gta_trx_lines_all.created_by%TYPE

289: ,attribute13 ar_gta_trx_lines_all.attribute13%TYPE
290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE
296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE
297: ,fp_tax_registration_number VARCHAR2(50)

Line 294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE

290: ,attribute14 ar_gta_trx_lines_all.attribute14%TYPE
291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE
296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE
297: ,fp_tax_registration_number VARCHAR2(50)
298: ,tp_tax_registration_number VARCHAR2(50)

Line 295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE

291: ,attribute15 ar_gta_trx_lines_all.attribute15%TYPE
292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE
296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE
297: ,fp_tax_registration_number VARCHAR2(50)
298: ,tp_tax_registration_number VARCHAR2(50)
299: --add begin by Yao Zhang for bug#8605196 to support discount line

Line 296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE

292: ,creation_date ar_gta_trx_lines_all.creation_date%TYPE
293: ,created_by ar_gta_trx_lines_all.created_by%TYPE
294: ,last_update_date ar_gta_trx_lines_all.last_update_date%TYPE
295: ,last_updated_by ar_gta_trx_lines_all.last_updated_by%TYPE
296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE
297: ,fp_tax_registration_number VARCHAR2(50)
298: ,tp_tax_registration_number VARCHAR2(50)
299: --add begin by Yao Zhang for bug#8605196 to support discount line
300: ,discount_amount ar_gta_trx_lines_all.discount_amount%TYPE

Line 300: ,discount_amount ar_gta_trx_lines_all.discount_amount%TYPE

296: ,last_update_login ar_gta_trx_lines_all.last_update_login%TYPE
297: ,fp_tax_registration_number VARCHAR2(50)
298: ,tp_tax_registration_number VARCHAR2(50)
299: --add begin by Yao Zhang for bug#8605196 to support discount line
300: ,discount_amount ar_gta_trx_lines_all.discount_amount%TYPE
301: ,discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE
302: ,discount_rate ar_gta_trx_lines_all.discount_rate%TYPE
303: --add end by Yao Zhang for bug#8605196 to support discount line
304: );

Line 301: ,discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE

297: ,fp_tax_registration_number VARCHAR2(50)
298: ,tp_tax_registration_number VARCHAR2(50)
299: --add begin by Yao Zhang for bug#8605196 to support discount line
300: ,discount_amount ar_gta_trx_lines_all.discount_amount%TYPE
301: ,discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE
302: ,discount_rate ar_gta_trx_lines_all.discount_rate%TYPE
303: --add end by Yao Zhang for bug#8605196 to support discount line
304: );
305:

Line 302: ,discount_rate ar_gta_trx_lines_all.discount_rate%TYPE

298: ,tp_tax_registration_number VARCHAR2(50)
299: --add begin by Yao Zhang for bug#8605196 to support discount line
300: ,discount_amount ar_gta_trx_lines_all.discount_amount%TYPE
301: ,discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE
302: ,discount_rate ar_gta_trx_lines_all.discount_rate%TYPE
303: --add end by Yao Zhang for bug#8605196 to support discount line
304: );
305:
306: -- This type is a group of TRX_line_rec_TYPE;

Line 374: -- AND AR_GTA_TRX_LINES_ALL.

370: --
371: -- DESCRIPTION:
372: --
373: -- This package can insert a set of trx to AR_GTA_TRX_HEADS_ALL
374: -- AND AR_GTA_TRX_LINES_ALL.
375: --
376: -- PARAMETERS:
377: -- In: p_gta_trxs trx_tbl_type
378: --