APPS.EGO_PUBLICATION_PKG dependencies on XMLAGG

Line 22: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))

18:
19: CURSOR C1(p_ext_id NUMBER,p_lang VARCHAR2) IS
20: Select xmlElement("Attribute",xmlElement("Id",attribute_id),
21: xmlElement("Name",attribute_name),
22: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))
23: FROM EGO_ALL_ATTR_LANG_V
24: WHERE extension_id =p_ext_id AND ATTRIBUTE_TRANSLATABLE_VALUE IS NOT NULL
25: AND LANGUAGE = p_lang GROUP BY ATTRIBUTE_ID, ATTRIBUTE_NAME;
26:

Line 31: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))

27:
28: CURSOR C2(p_ext_id NUMBER) IS
29: Select xmlElement("Attribute",xmlElement("Id",attribute_id),
30: xmlElement("Name",attribute_name),
31: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))
32: FROM EGO_ALL_ATTR_LANG_V
33: WHERE extension_id =p_ext_id AND ATTRIBUTE_TRANSLATABLE_VALUE IS NOT NULL
34: GROUP BY ATTRIBUTE_ID, ATTRIBUTE_NAME;
35:

Line 39: xmlagg(xmlelement("Attribute",

35:
36: CURSOR C3(p_ext_id NUMBER) IS
37: SELECT xmlConcat(xmlElement("Id",attributegroup_id),
38: xmlElement("Name", attribute_group_name),
39: xmlagg(xmlelement("Attribute",
40: xmlelement("Id",attribute_id),
41: xmlelement("Name",attribute_name),
42: xmlForest(attribute_char_value AS "Value",
43: attribute_number_value AS "ValueNumeric",

Line 300: x_query := 'SELECT XMLAGG(XMLCONCAT(XMLELEMENT("DESCRIPTION",XMLATTRIBUTES(MSIT.language AS "languageId"),

296: -------- Generate Description Elements with p_language where clause ---------------------------------
297:
298: IF (p_language IS NOT NULL) THEN
299:
300: x_query := 'SELECT XMLAGG(XMLCONCAT(XMLELEMENT("DESCRIPTION",XMLATTRIBUTES(MSIT.language AS "languageId"),
301: MSIT.description))) FROM MTL_SYSTEM_ITEMS_TL MSIT WHERE MSIT.INVENTORY_ITEM_ID = '|| itemId || 'AND MSIT.ORGANIZATION_ID = ' || orgId || '
302: AND MSIT.language = '|| '''' || p_language || '''' ;
303:
304: Execute Immediate x_query

Line 310: SELECT XMLAGG(XMLCONCAT(XMLELEMENT("Description",XMLATTRIBUTES(MSIT.language AS "languageID"),

306:
307:
308: ELSE
309: --- Generate Description Elements without Language clause--------
310: SELECT XMLAGG(XMLCONCAT(XMLELEMENT("Description",XMLATTRIBUTES(MSIT.language AS "languageID"),
311: MSIT.description)))
312: INTO x_temp
313: FROM MTL_SYSTEM_ITEMS_TL msit
314: WHERE msit.INVENTORY_ITEM_ID = itemId

Line 520: XMLAGG(XMLELEMENT("AttributeGroup",

516:
517: IF (getFlexAttributesFlag = 'Y') THEN
518:
519: SELECT XMLCONCAT(
520: XMLAGG(XMLELEMENT("AttributeGroup",
521: XMLELEMENT("Id",catId),
522: XMLELEMENT("Name", FND.DESCRIPTIVE_FLEX_CONTEXT_CODE),
523: XMLAGG(XMLELEMENT("Attribute",
524: XMLELEMENT("Name",FND.END_USER_COLUMN_NAME),

Line 523: XMLAGG(XMLELEMENT("Attribute",

519: SELECT XMLCONCAT(
520: XMLAGG(XMLELEMENT("AttributeGroup",
521: XMLELEMENT("Id",catId),
522: XMLELEMENT("Name", FND.DESCRIPTIVE_FLEX_CONTEXT_CODE),
523: XMLAGG(XMLELEMENT("Attribute",
524: XMLELEMENT("Name",FND.END_USER_COLUMN_NAME),
525: XMLELEMENT("Value",DECODE(APPLICATION_COLUMN_NAME,'ATTRIBUTE1',CAT.ATTRIBUTE1,'ATTRIBUTE2',CAT.ATTRIBUTE2,
526: 'ATTRIBUTE3',CAT.ATTRIBUTE3,'ATTRIBUTE4',CAT.ATTRIBUTE4,'ATTRIBUTE5',CAT.ATTRIBUTE5,
527: 'ATTRIBUTE6',CAT.ATTRIBUTE6,'ATTRIBUTE7',CAT.ATTRIBUTE7,'ATTRIBUTE8',CAT.ATTRIBUTE8,

Line 632: x_query := 'SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))

628: ------ Based on p_language, construct the DESCRIPTION ELEMENT --------------
629:
630: IF (p_language IS NOT NULL) THEN
631:
632: x_query := 'SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))
633: FROM mtl_category_sets_tl
634: WHERE category_set_id = '|| cat_set_id || 'AND language = '|| '''' || p_language || '''' ;
635:
636: Execute Immediate x_query

Line 641: SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))

637: INTO x_desc;
638:
639: ELSE
640:
641: SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))
642: INTO x_desc
643: FROM mtl_category_sets_tl
644: WHERE category_set_id =cat_set_id;
645: END IF;

Line 1358: (SELECT XMLAGG(

1354: xmlforest(s.bill_sequence_id AS "ID",
1355: nvl(s.alternate_bom_designator,'PRIMARY') AS "NAME")
1356: )),
1357: XMLELEMENT("ItemReference",l_assly_item_info_xml),
1358: (SELECT XMLAGG(
1359: XMLELEMENT("ComponentItem",
1360: -- XMLELEMENT("COMPONENT_SEQUENCE_ID",c.COMPONENT_SEQUENCE_ID),
1361: XMLELEMENT("ItemReference",getItemIdentification(c.component_item_id, l_assly_item_org_id)),
1362: xmlelement("ComponentItemBase",