APPS.PO_DATATEMPLATE_PKG dependencies on XMLAGG

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

289: FOR REC IN C_ATTR_GRP LOOP
290: IF REC.MULTI_ROW = 'Y' THEN
291: IF L_O_CTR > 0 THEN
292: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
293: || '", XMLAgg(XMLForest(' ;
294: ELSE
295: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
296: END IF;
297: ELSE

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

291: IF L_O_CTR > 0 THEN
292: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
293: || '", XMLAgg(XMLForest(' ;
294: ELSE
295: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
296: END IF;
297: ELSE
298: IF L_O_CTR > 0 THEN
299: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

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

387: FOR REC IN C_ATTR_GRP LOOP
388: IF REC.MULTI_ROW = 'Y' THEN
389: IF L_O_CTR > 0 THEN
390: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
391: || '", XMLAgg(XMLForest(' ;
392: ELSE
393: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP
394: || '", XMLAgg(XMLForest(';
395: END IF;

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

390: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
391: || '", XMLAgg(XMLForest(' ;
392: ELSE
393: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP
394: || '", XMLAgg(XMLForest(';
395: END IF;
396: ELSE
397: IF L_O_CTR > 0 THEN
398: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

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

488: FOR REC IN C_ATTR_GRP LOOP
489: IF REC.MULTI_ROW = 'Y' THEN
490: IF L_O_CTR > 0 THEN
491: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
492: || '", XMLAgg(XMLForest(' ;
493: ELSE
494: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
495: END IF;
496: ELSE

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

490: IF L_O_CTR > 0 THEN
491: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
492: || '", XMLAgg(XMLForest(' ;
493: ELSE
494: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';
495: END IF;
496: ELSE
497: IF L_O_CTR > 0 THEN
498: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

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

1003:
1004: l_req_nums XMLType;
1005: BEGIN
1006:
1007: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1008: INTO l_req_nums
1009: FROM (SELECT distinct h.segment1
1010: FROM po_distributions_merge_v pod,
1011: po_req_distributions_all prd,

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

1026:
1027: l_req_nums XMLType;
1028: BEGIN
1029:
1030: SELECT XMLAgg(XMLElement("REF_PR_NUM", requisition_number))
1031: INTO l_req_nums
1032: FROM (SELECT distinct requisition_number
1033: FROM pon_backing_requisitions
1034: WHERE auction_header_id = p_auction_header_id

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

1041: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType IS
1042:
1043: l_acrns XMLType;
1044: BEGIN
1045: SELECT XMLAgg(XMLElement("ACRN", acrn))
1046: INTO l_acrns
1047: FROM (SELECT distinct pod.acrn
1048: FROM po_distributions_merge_v pod
1049: WHERE pod.po_header_id = p_header_id