eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on XMLSEQUENCE

Line 126: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/Bundles/Bundle'))) xml_tab;

122: IS
123: CURSOR c_bundles(p_bundles_xml XMLTYPE)
124: IS
125: SELECT Value(xml_tab) bundle
126: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/Bundles/Bundle'))) xml_tab;
127:
128: CURSOR c_bundle_items(p_bundles_xml XMLTYPE)
129: IS
130: SELECT Value(xml_tab) bundle

Line 131: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '//ItemBundle'))) xml_tab;

127:
128: CURSOR c_bundle_items(p_bundles_xml XMLTYPE)
129: IS
130: SELECT Value(xml_tab) bundle
131: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '//ItemBundle'))) xml_tab;
132:
133: l_bundle_collection_id NUMBER;
134: l_bundle_id NUMBER;
135: p_bundles_xml XMLTYPE;

Line 850: FROM TABLE(XMLSEQUENCE(EXTRACT(p_collection_xml, '/TL/'||p_entity_name))) xml_tab;

846: IS
847: CURSOR c_entries(p_collection_xml XMLTYPE)
848: IS
849: SELECT Value(xml_tab) entry
850: FROM TABLE(XMLSEQUENCE(EXTRACT(p_collection_xml, '/TL/'||p_entity_name))) xml_tab;
851:
852: BEGIN
853: FOR trans_entry IN c_entries(p_xml_data)
854: LOOP

Line 908: FROM TABLE(XMLSEQUENCE(EXTRACT(p_entity_xml, '/'||p_entity_name||'/AttributeGroup'))) xml_tab;

904: -- Attribute Groups
905: CURSOR c_AttributeGrps(p_entity_xml XMLTYPE, p_entity_name VARCHAR2)
906: IS
907: SELECT Value(xml_tab) attributeGroups
908: FROM TABLE(XMLSEQUENCE(EXTRACT(p_entity_xml, '/'||p_entity_name||'/AttributeGroup'))) xml_tab;
909:
910: -- Attributes
911: CURSOR c_Attributes(p_attrGrp_xml XMLTYPE)
912: IS

Line 914: FROM TABLE(XMLSEQUENCE(EXTRACT(p_attrGrp_xml, '/AttributeGroup/Attribute'))) xml_tab;

910: -- Attributes
911: CURSOR c_Attributes(p_attrGrp_xml XMLTYPE)
912: IS
913: SELECT Value(xml_tab) attributes
914: FROM TABLE(XMLSEQUENCE(EXTRACT(p_attrGrp_xml, '/AttributeGroup/Attribute'))) xml_tab;
915:
916: l_row_identifier NUMBER;
917: l_attr_group_int_name VARCHAR2(255);
918: l_attr_int_name VARCHAR2(255);

Line 1140: FROM TABLE(XMLSEQUENCE(EXTRACT(p_collection_xml, '/XMLEntries/SyncItemPublication/ItemPublicationLine'))) xml_tab;

1136: -- Bundles
1137: CURSOR c_bundles(p_collection_xml XMLTYPE)
1138: IS
1139: SELECT Value(xml_tab) bundles
1140: FROM TABLE(XMLSEQUENCE(EXTRACT(p_collection_xml, '/XMLEntries/SyncItemPublication/ItemPublicationLine'))) xml_tab;
1141:
1142: -- Items
1143: CURSOR c_items(p_bundles_xml XMLTYPE)
1144: IS

Line 1146: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/Item'))) xml_tab;

1142: -- Items
1143: CURSOR c_items(p_bundles_xml XMLTYPE)
1144: IS
1145: SELECT Value(xml_tab) items
1146: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/Item'))) xml_tab;
1147:
1148: -- Classification
1149: CURSOR c_classifications(p_items_xml XMLTYPE)
1150: IS

Line 1152: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemCatalog'))) xml_tab;

1148: -- Classification
1149: CURSOR c_classifications(p_items_xml XMLTYPE)
1150: IS
1151: SELECT Value(xml_tab) classifications
1152: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemCatalog'))) xml_tab;
1153:
1154: -- Suppliers
1155: CURSOR c_suppliers(p_items_xml XMLTYPE)
1156: IS

Line 1158: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemSupplier'))) xml_tab;

1154: -- Suppliers
1155: CURSOR c_suppliers(p_items_xml XMLTYPE)
1156: IS
1157: SELECT Value(xml_tab) suppliers
1158: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemSupplier'))) xml_tab;
1159:
1160: -- Suppliers
1161: CURSOR c_supplierLocations(p_suppliers_xml XMLTYPE)
1162: IS

Line 1164: FROM TABLE(XMLSEQUENCE(EXTRACT(p_suppliers_xml, '/ItemSupplier/ItemSupplierLocation'))) xml_tab;

1160: -- Suppliers
1161: CURSOR c_supplierLocations(p_suppliers_xml XMLTYPE)
1162: IS
1163: SELECT Value(xml_tab) supplierLocations
1164: FROM TABLE(XMLSEQUENCE(EXTRACT(p_suppliers_xml, '/ItemSupplier/ItemSupplierLocation'))) xml_tab;
1165:
1166: -- Structures
1167: CURSOR c_structure(p_bundles_xml XMLTYPE)
1168: IS

Line 1170: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/ItemStructure'))) xml_tab;

1166: -- Structures
1167: CURSOR c_structure(p_bundles_xml XMLTYPE)
1168: IS
1169: SELECT Value(xml_tab) structures
1170: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/ItemStructure'))) xml_tab;
1171:
1172: -- Components
1173: CURSOR c_component(p_structures_xml XMLTYPE)
1174: IS

Line 1176: FROM TABLE(XMLSEQUENCE(EXTRACT(p_structures_xml, '/ItemStructure/ComponentItem'))) xml_tab;

1172: -- Components
1173: CURSOR c_component(p_structures_xml XMLTYPE)
1174: IS
1175: SELECT Value(xml_tab) components
1176: FROM TABLE(XMLSEQUENCE(EXTRACT(p_structures_xml, '/ItemStructure/ComponentItem'))) xml_tab;
1177:
1178: -- Alternate Category concatenated segments
1179: CURSOR c_alt_cat_concat_seg(c_alt_cat_code VARCHAR2)
1180: IS