APPS.JMF_GTA_TRX_UTIL dependencies on JMF_GTA_TRX_LINES_ALL

Line 218: --This record is the data type of JMF_GTA_TRX_LINES_ALL;

214: ,last_update_login jmf_gta_trx_headers_all.last_update_login%TYPE
215: ,invoice_type jmf_gta_trx_headers_all.invoice_type%TYPE --added by subba for R12.1
216: );
217:
218: --This record is the data type of JMF_GTA_TRX_LINES_ALL;
219: TYPE trx_line_rec_type IS RECORD
220: (
221: row_id VARCHAR2(30)
222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE

Line 222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE

218: --This record is the data type of JMF_GTA_TRX_LINES_ALL;
219: TYPE trx_line_rec_type IS RECORD
220: (
221: row_id VARCHAR2(30)
222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE
223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE

Line 223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE

219: TYPE trx_line_rec_type IS RECORD
220: (
221: row_id VARCHAR2(30)
222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE
223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE

Line 224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE

220: (
221: row_id VARCHAR2(30)
222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE
223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE

Line 225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE

221: row_id VARCHAR2(30)
222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE
223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE

Line 226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE

222: ,org_id jmf_gta_trx_lines_all.org_id%TYPE
223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE

Line 227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE

223: ,gta_trx_header_id jmf_gta_trx_lines_all.gta_trx_header_id%TYPE
224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE

Line 228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE

224: ,gta_trx_line_id jmf_gta_trx_lines_all.gta_trx_line_id%TYPE
225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE

Line 229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE

225: ,matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE
226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE

Line 230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE

226: ,line_number jmf_gta_trx_lines_all.line_number%TYPE
227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE

Line 231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE

227: ,ar_trx_line_id jmf_gta_trx_lines_all.ar_trx_line_id%TYPE
228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE

Line 232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE

228: ,inventory_item_id jmf_gta_trx_lines_all.inventory_item_id%TYPE
229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE

Line 233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE

229: ,item_number VARCHAR2(30)--jmf_gta_trx_lines_all.item_number%TYPE
230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE

Line 234: ,uom jmf_gta_trx_lines_all.uom%TYPE

230: ,item_description jmf_gta_trx_lines_all.item_description%TYPE
231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE

Line 235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE

231: ,item_model jmf_gta_trx_lines_all.item_model%TYPE
232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE

Line 236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE

232: ,item_tax_denomination jmf_gta_trx_lines_all.item_tax_denomination%TYPE
233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE

Line 237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE

233: ,tax_rate jmf_gta_trx_lines_all.tax_rate%TYPE
234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE

Line 238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE

234: ,uom jmf_gta_trx_lines_all.uom%TYPE
235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE

Line 239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE

235: ,uom_name jmf_gta_trx_lines_all.uom_name%TYPE
236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE

Line 240: ,amount jmf_gta_trx_lines_all.amount%TYPE

236: ,quantity jmf_gta_trx_lines_all.quantity%TYPE
237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE

Line 241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE

237: ,price_flag jmf_gta_trx_lines_all.price_flag%TYPE
238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE

Line 242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE

238: ,unit_price jmf_gta_trx_lines_all.unit_price%TYPE
239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE

Line 243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE

239: ,unit_tax_price jmf_gta_trx_lines_all.unit_tax_price%TYPE
240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE

Line 244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE

240: ,amount jmf_gta_trx_lines_all.amount%TYPE
241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE

Line 245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE

241: ,original_currency_amount jmf_gta_trx_lines_all.original_currency_amount%TYPE
242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE

Line 246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE

242: ,tax_amount jmf_gta_trx_lines_all.tax_amount%TYPE
243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE

Line 247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE

243: ,discount_flag jmf_gta_trx_lines_all.discount_flag%TYPE
244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE

Line 248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE

244: ,enabled_flag jmf_gta_trx_lines_all.enabled_flag%TYPE
245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE

Line 249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE

245: ,request_id jmf_gta_trx_lines_all.request_id%TYPE
246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE

Line 250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE

246: ,program_applicaton_id jmf_gta_trx_lines_all.program_application_id%TYPE
247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE

Line 251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE

247: ,program_id jmf_gta_trx_lines_all.program_id%TYPE
248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE

Line 252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE

248: ,program_update_date jmf_gta_trx_lines_all.program_update_date%TYPE
249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE

Line 253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE

249: ,attribute_category jmf_gta_trx_lines_all.attribute_category%TYPE
250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE

Line 254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE

250: ,attribute1 jmf_gta_trx_lines_all.attribute1%TYPE
251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE

Line 255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE

251: ,attribute2 jmf_gta_trx_lines_all.attribute2%TYPE
252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE

Line 256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE

252: ,attribute3 jmf_gta_trx_lines_all.attribute3%TYPE
253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE

Line 257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE

253: ,attribute4 jmf_gta_trx_lines_all.attribute4%TYPE
254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE

Line 258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE

254: ,attribute5 jmf_gta_trx_lines_all.attribute5%TYPE
255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE

Line 259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE

255: ,attribute6 jmf_gta_trx_lines_all.attribute6%TYPE
256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE

Line 260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE

256: ,attribute7 jmf_gta_trx_lines_all.attribute7%TYPE
257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE

Line 261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE

257: ,attribute8 jmf_gta_trx_lines_all.attribute8%TYPE
258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE

Line 262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE

258: ,attribute9 jmf_gta_trx_lines_all.attribute9%TYPE
259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE

Line 263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE

259: ,attribute10 jmf_gta_trx_lines_all.attribute10%TYPE
260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE

Line 264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE

260: ,attribute11 jmf_gta_trx_lines_all.attribute11%TYPE
261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE

Line 265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE

261: ,attribute12 jmf_gta_trx_lines_all.attribute12%TYPE
262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE
269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE

Line 266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE

262: ,attribute13 jmf_gta_trx_lines_all.attribute13%TYPE
263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE
269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE
270: ,fp_tax_registration_number VARCHAR2(50)

Line 267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE

263: ,attribute14 jmf_gta_trx_lines_all.attribute14%TYPE
264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE
269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE
270: ,fp_tax_registration_number VARCHAR2(50)
271: ,tp_tax_registration_number VARCHAR2(50)

Line 268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE

264: ,attribute15 jmf_gta_trx_lines_all.attribute15%TYPE
265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE
269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE
270: ,fp_tax_registration_number VARCHAR2(50)
271: ,tp_tax_registration_number VARCHAR2(50)
272: );

Line 269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE

265: ,creation_date jmf_gta_trx_lines_all.creation_date%TYPE
266: ,created_by jmf_gta_trx_lines_all.created_by%TYPE
267: ,last_update_date jmf_gta_trx_lines_all.last_update_date%TYPE
268: ,last_updated_by jmf_gta_trx_lines_all.last_updated_by%TYPE
269: ,last_update_login jmf_gta_trx_lines_all.last_update_login%TYPE
270: ,fp_tax_registration_number VARCHAR2(50)
271: ,tp_tax_registration_number VARCHAR2(50)
272: );
273:

Line 342: -- AND JMF_GTA_TRX_LINES_ALL.

338: --
339: -- DESCRIPTION:
340: --
341: -- This package can insert a set of trx to JMF_GTA_TRX_HEADS_ALL
342: -- AND JMF_GTA_TRX_LINES_ALL.
343: --
344: -- PARAMETERS:
345: -- In: p_gta_trxs trx_tbl_type
346: --