APPS.PON_SGD_PKG dependencies on XMLAGG

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

63: FOR REC IN C_ATTR_GRP LOOP
64: IF REC.MULTI_ROW = 'Y' THEN
65: IF L_O_CTR > 0 THEN
66: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
67: || '", XMLAgg(XMLForest(' ;
68: ELSE
69: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
70: XMLAgg(XMLForest(';
71: END IF;

Line 70: XMLAgg(XMLForest(';

66: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
67: || '", XMLAgg(XMLForest(' ;
68: ELSE
69: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
70: XMLAgg(XMLForest(';
71: END IF;
72: ELSE
73: IF L_O_CTR > 0 THEN
74: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

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

322: FOR REC IN C_ATTR_GRP LOOP
323: IF REC.MULTI_ROW = 'Y' THEN
324: IF L_O_CTR > 0 THEN
325: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
326: || '", XMLAgg(XMLForest(' ;
327: ELSE
328: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
329: XMLAgg(XMLForest(';
330: END IF;

Line 329: XMLAgg(XMLForest(';

325: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
326: || '", XMLAgg(XMLForest(' ;
327: ELSE
328: L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
329: XMLAgg(XMLForest(';
330: END IF;
331: ELSE
332: IF L_O_CTR > 0 THEN
333: L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP

Line 491: SELECT (XMLAgg(XMLElement("ATTRIBUTE" , XMLAttributes(diff.label_message_code as "name",

487: BEGIN
488:
489: IF p_mod_pk1_value IS NOT NULL AND p_entity_name IS NOT NULL AND p_document_type IS NOT NULL THEN
490:
491: SELECT (XMLAgg(XMLElement("ATTRIBUTE" , XMLAttributes(diff.label_message_code as "name",
492: diff.disp_data_type as "datatype",
493: diff.sub_entity_name as "sub_entity"),
494: XMLElement("orig_id", diff.orig_value),
495: XMLElement("mod_id", diff.mod_value),