APPS.AR_GTA_CONSOLIDATE_PROC dependencies on XMLAGG

Line 187: SELECT xmlagg(xmlelement("ConsolidatedInv",

183: FETCH c_consol_seq
184: INTO l_consol_seq;
185: EXIT WHEN c_consol_seq%NOTFOUND;
186: --Yao Zhang add end;
187: SELECT xmlagg(xmlelement("ConsolidatedInv",
188: xmlforest(jgcit.consolidated_inv_number AS
189: "Consolidated",
190: jgcit.gl_period AS "GLPeriod",
191: jgcit.ra_trx_num AS "RATrxNum",

Line 237: SELECT xmlagg(xmlelement("ConsolidatedInv",

233: LOOP
234: FETCH c_consol_seq
235: INTO l_consol_seq;
236: EXIT WHEN c_consol_seq%NOTFOUND;
237: SELECT xmlagg(xmlelement("ConsolidatedInv",
238: xmlforest(jgcit.consolidated_inv_number AS
239: "Consolidated",
240: jgcit.gl_period AS "GLPeriod",
241: jgcit.ra_trx_num AS "RATrxNum",

Line 251: SELECT xmlagg(xmlelement("ConsolidationInv",

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
254: "ConsolidationInvNum",
255: jgct.customer_name AS "CustomerName",

Line 288: SELECT xmlagg(xmlelement("ConsolidatedInv",

284: LOOP
285: FETCH c_consol_seq
286: INTO l_consol_seq;
287: EXIT WHEN c_consol_seq%NOTFOUND;
288: SELECT xmlagg(xmlelement("ConsolidatedInv",
289: xmlforest(jgcit.consolidated_inv_number AS
290: "Consolidated",
291: jgcit.gl_period AS "GLPeriod",
292: jgcit.ra_trx_num AS "RATrxNum",

Line 302: SELECT xmlagg(xmlelement("ConsolidationInv",

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
305: "ConsolidationInvNum",
306: jgct.customer_name AS