APPS.EGO_PUBLICATION_PKG dependencies on DUAL

Line 133: FROM DUAL;

129: ------------- Concatenate Translatable and Non- Translatable Attributes to Generate Attribute Group Element
130:
131: Select xmlElement("AttributeGroup",x_doc, x_temp)
132: INTO x_doc
133: FROM DUAL;
134:
135:
136: EXCEPTION
137: WHEN no_data_found THEN

Line 417: FROM DUAL;

413: ------ Concatenate ITEM_IDENTIFICATION AND ITEM_BASE ------------------------
414:
415: SELECT XMLCONCAT(x_temp,x_doc)
416: INTO x_doc
417: FROM DUAL;
418:
419: ------ Call getUDAAttributes to capture UDA XML if itemAttrGroup is not null-
420:
421: If extension_id IS NOT NULL THEN

Line 439: FROM DUAL;

435: XMLELEMENT("SyncItemPrimaryAttribute",
436: XMLCONCAT(x_doc,
437: x_uda))))
438: INTO x_doc
439: FROM DUAL;
440:
441:
442:
443: EXCEPTION

Line 651: FROM DUAL;

647: ----- Generate CATALOGBASE ELEMENT -------------------------------------
648:
649: SELECT XMLELEMENT("CatalogBase",x_desc)
650: INTO x_desc
651: FROM DUAL;
652:
653:
654: ------ Generate ClassificationCode Element if parentCategory Id is not NULL ----
655:

Line 683: FROM DUAL;

679: SELECT XMLELEMENT("CatalogClassification",
680: XMLELEMENT("CatalogClassificationStructure",
681: x_temp1,x_temp2))
682: INTO x_temp1
683: FROM DUAL;
684:
685: select XMLCONCAT(x_iden,x_desc,x_temp1) into x_doc from dual;
686:
687: EXCEPTION

Line 685: select XMLCONCAT(x_iden,x_desc,x_temp1) into x_doc from dual;

681: x_temp1,x_temp2))
682: INTO x_temp1
683: FROM DUAL;
684:
685: select XMLCONCAT(x_iden,x_desc,x_temp1) into x_doc from dual;
686:
687: EXCEPTION
688: WHEN no_data_found THEN
689: x_error_message := 'unexpected_error';

Line 764: FROM DUAL;

760: XMLELEMENT("DataArea",
761: XMLELEMENT("SyncCatalog",
762: x_cat)))
763: INTO x_doc
764: FROM DUAL;
765:
766:
767: EXCEPTION
768: WHEN no_data_found THEN

Line 1031: FROM dual;

1027: );
1028:
1029: SELECT xmlconcat(l_item_id_info, l_item_base_info)
1030: INTO l_item_id_info
1031: FROM dual;
1032:
1033: -- 3. get Supplier info
1034: getSupplierAttributes
1035: (

Line 1062: FROM DUAL;

1058: l_uda_xml
1059: )
1060: )))
1061: INTO x_doc
1062: FROM DUAL;
1063:
1064: EXCEPTION
1065: WHEN no_data_found THEN
1066: x_error_message := 'No Data found';

Line 1151: FROM dual;

1147: );
1148:
1149: SELECT xmlconcat(l_item_id_info, l_item_base_info)
1150: INTO l_item_id_info
1151: FROM dual;
1152:
1153: -- 3. get Supplier info
1154: getSupplierSiteAttributes
1155: (

Line 1183: FROM DUAL;

1179: l_uda_xml)
1180: ))
1181: )
1182: INTO x_doc
1183: FROM DUAL;
1184:
1185: EXCEPTION
1186: WHEN no_data_found THEN
1187: x_error_message := 'No Data found';

Line 1452: FROM dual;

1448: );
1449:
1450: SELECT xmlconcat(l_item_id_info, l_item_base_info)
1451: INTO l_item_id_info
1452: FROM dual;
1453:
1454: -- 2. fetch the catalog informations for the given item from mtl_item_categories
1455: -- categories from this can be across multiple catalogs
1456: -- group all of the categories unders its own catalog

Line 1475: FROM dual;

1471: IF l_catalog_info IS NOT NULL THEN
1472: SELECT XMLELEMENT("ItemCatalog",
1473: XMLELEMENT("CatalogReference",l_catalog_info))
1474: INTO l_catalog_info
1475: FROM dual;
1476: END IF;
1477:
1478: IF (l_item_id_info IS NOT NULL)
1479: OR (l_catalog_info IS NOT NULL) THEN

Line 1486: FROM dual;

1482: XMLELEMENT("SyncItemCatalog",
1483: XMLCONCAT(l_item_id_info, l_catalog_info)
1484: )))
1485: INTO x_doc
1486: FROM dual;
1487: END IF;
1488:
1489: EXCEPTION
1490: WHEN OTHERS then