APPS.AR_GTA_CONSOLIDATE_PROC dependencies on AR_GTA_CONSOL_INVS_TEMP

Line 199: FROM AR_gta_consol_invs_temp jgcit

195: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
196: --modified by Jixun for bug#16274922 end
197: )))
198: INTO l_success_invs
199: FROM AR_gta_consol_invs_temp jgcit
200: WHERE jgcit.seq = l_consol_seq;
201: SELECT xmlelement("ConsolidationInv",
202: xmlforest(jgct.seq AS "SEQ",
203: jgct.consolidation_inv_number AS

Line 249: FROM AR_gta_consol_invs_temp jgcit

245: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
246: --modified by Jixun for bug#16274922 end
247: )))
248: INTO l_warning_invs
249: FROM AR_gta_consol_invs_temp jgcit
250: WHERE jgcit.seq = l_consol_seq;
251: SELECT xmlagg(xmlelement("ConsolidationInv",
252: xmlforest(jgct.SEQ AS "SEQ",
253: jgct.consolidation_inv_number AS

Line 300: FROM AR_gta_consol_invs_temp jgcit

296: ar_gta_trx_util.format_monetary_amount(l_org_id, jgcit.amount) AS "Amount"
297: --modified by Jixun for bug#16274922 end
298: )))
299: INTO l_failed_invs
300: FROM AR_gta_consol_invs_temp jgcit
301: WHERE jgcit.seq = l_consol_seq;
302: SELECT xmlagg(xmlelement("ConsolidationInv",
303: xmlforest(jgct.SEQ AS "SEQ",
304: jgct.consolidation_inv_number AS

Line 1418: --insert csldted invs to table ar_gta_consol_invs_temp

1414: ,l_invoice_type
1415: ,l_sum_amount
1416: ,l_error_string
1417: FROM dual;
1418: --insert csldted invs to table ar_gta_consol_invs_temp
1419: --init l_csldted_invs_index
1420: l_csldted_invs_index:=l_csldted_invs.FIRST;
1421: WHILE l_csldted_invs_index IS NOT NULL
1422: LOOP

Line 1450: INSERT INTO AR_gta_consol_invs_temp

1446: 'Unknown error' || SQLCODE || SQLERRM);
1447: END IF;
1448: RAISE;
1449: END;
1450: INSERT INTO AR_gta_consol_invs_temp
1451: (seq
1452: ,consolidated_inv_number
1453: ,gl_period
1454: ,ra_trx_num