APPS.PO_SGD_PKG dependencies on XMLAGG

Line 239: || '", XMLAgg(XMLForest(' ;

235: FOR REC IN C_ATTR_GRP LOOP
236: IF REC.MULTI_ROW = 'Y' THEN
237: IF L_O_CTR > 0 THEN
238: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
239: || '", XMLAgg(XMLForest(' ;
240: ELSE
241: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
242: END IF;
243: ELSE

Line 241: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';

237: IF L_O_CTR > 0 THEN
238: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
239: || '", XMLAgg(XMLForest(' ;
240: ELSE
241: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
242: END IF;
243: ELSE
244: IF L_O_CTR > 0 THEN
245: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

Line 337: || '", XMLAgg(XMLForest(' ;

333: FOR REC IN C_ATTR_GRP LOOP
334: IF REC.MULTI_ROW = 'Y' THEN
335: IF L_O_CTR > 0 THEN
336: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
337: || '", XMLAgg(XMLForest(' ;
338: ELSE
339: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
340: END IF;
341: ELSE

Line 339: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';

335: IF L_O_CTR > 0 THEN
336: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
337: || '", XMLAgg(XMLForest(' ;
338: ELSE
339: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
340: END IF;
341: ELSE
342: IF L_O_CTR > 0 THEN
343: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

Line 436: || '", XMLAgg(XMLForest(' ;

432: FOR REC IN C_ATTR_GRP LOOP
433: IF REC.MULTI_ROW = 'Y' THEN
434: IF L_O_CTR > 0 THEN
435: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
436: || '", XMLAgg(XMLForest(' ;
437: ELSE
438: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP
439: || '", XMLAgg(XMLForest(';
440: END IF;

Line 439: || '", XMLAgg(XMLForest(';

435: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
436: || '", XMLAgg(XMLForest(' ;
437: ELSE
438: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP
439: || '", XMLAgg(XMLForest(';
440: END IF;
441: ELSE
442: IF L_O_CTR > 0 THEN
443: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

Line 644: l_sql_stmt := 'select XMLAgg(XMLElement("ATTRIBUTE" , XMLATTRIBUTES( nvl(fnd_message.get_string(''PO'', c.label_message_code), d.column_name) as "name",

640:
641: l_where_stmt := l_where_stmt || ' and document_type = ''' || p_document_type || ''' and entity_name = ''' || p_entity_name ||'''';
642:
643: -- forming the final sql stmt
644: l_sql_stmt := 'select XMLAgg(XMLElement("ATTRIBUTE" , XMLATTRIBUTES( nvl(fnd_message.get_string(''PO'', c.label_message_code), d.column_name) as "name",
645: c.disp_data_type as "datatype",
646: c.sub_entity_name as "sub_entity" ),
647: XMLELement("orig_id", d.orig_value),
648: XMLELement("mod_id", d.mod_value),

Line 1735: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))

1731:
1732: l_req_nums XMLType;
1733: BEGIN
1734:
1735: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1736: INTO l_req_nums
1737: FROM (SELECT distinct h.segment1
1738: FROM po_distributions_merge_v pod,
1739: po_req_distributions_all prd,

Line 1758: SELECT XMLAgg(XMLElement("REF_PR_NUM", requisition_number))

1754:
1755: l_req_nums XMLType;
1756: BEGIN
1757:
1758: SELECT XMLAgg(XMLElement("REF_PR_NUM", requisition_number))
1759: INTO l_req_nums
1760: FROM (SELECT distinct requisition_number
1761: FROM pon_backing_requisitions
1762: WHERE auction_header_id = p_auction_header_id

Line 1773: SELECT XMLAgg(XMLElement("ACRN", acrn))

1769: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1770:
1771: l_acrns XMLType;
1772: BEGIN
1773: SELECT XMLAgg(XMLElement("ACRN", acrn))
1774: INTO l_acrns
1775: FROM (SELECT distinct pod.acrn
1776: FROM po_distributions_merge_v pod
1777: WHERE pod.po_header_id = p_header_id