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 XMLTYPE

Line 5: FUNCTION GET_DATE_FROM_XML(l_xml_date IN XMLTYPE)

1: package body ego_orchestration_util_pub as
2: /* $Header: EGOORCHB.pls 120.21 2007/12/04 14:00:15 bbpatel noship $ */
3:
4:
5: FUNCTION GET_DATE_FROM_XML(l_xml_date IN XMLTYPE)
6: RETURN DATE -- bug:6507903 Changed return type from varchar2 to date
7: IS
8: BEGIN
9: IF l_xml_date IS NULL

Line 123: CURSOR c_bundles(p_bundles_xml XMLTYPE)

119: p_commit IN VARCHAR2 DEFAULT 'Y',
120: p_entity_name IN VARCHAR2 DEFAULT 'BUNDLE'
121: )
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:

Line 128: CURSOR c_bundle_items(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
131: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '//ItemBundle'))) xml_tab;
132:

Line 135: p_bundles_xml XMLTYPE;

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;
136: p_cln_bundles_clob CLOB;
137: l_source_system_id NUMBER;
138: l_source_system_ref VARCHAR2(255);
139:

Line 154: p_bundles_xml := XMLTYPE.createXML(xmlData => p_cln_bundles_clob);

150:
151:
152: x_new_bundle_col_id := l_bundle_collection_id;
153: p_cln_bundles_clob := REPLACE(p_bundles_clob, 'ns1:');
154: p_bundles_xml := XMLTYPE.createXML(xmlData => p_cln_bundles_clob);
155: IF p_entity_name = 'ITEM'
156: THEN
157: IF p_bundles_xml.extract('//ItemBundle') IS NOT NULL
158: THEN

Line 757: RETURN XMLTYPE

753:
754: FUNCTION GET_BUNDLES_FROM_COL ( p_bundle_collection_id IN NUMBER,
755: p_prior_bundle_id IN NUMBER,
756: p_max_elements IN NUMBER)
757: RETURN XMLTYPE
758: IS
759: l_xml_doc XMLTYPE;
760: BEGIN
761: l_xml_doc := NULL;

Line 759: l_xml_doc XMLTYPE;

755: p_prior_bundle_id IN NUMBER,
756: p_max_elements IN NUMBER)
757: RETURN XMLTYPE
758: IS
759: l_xml_doc XMLTYPE;
760: BEGIN
761: l_xml_doc := NULL;
762: SELECT XMLELEMENT("BundleCollections",
763: XMLELEMENT("BundleCollection",

Line 842: p_xml_data IN XMLTYPE,

838: PROCEDURE PROCESS_TL_ROWS(p_table_name IN VARCHAR2,
839: p_batch_id IN NUMBER,
840: p_unique_id IN NUMBER,
841: p_bundle_id IN NUMBER,
842: p_xml_data IN XMLTYPE,
843: p_entity_name IN VARCHAR2,
844: p_column_name IN VARCHAR2
845: )
846: IS

Line 847: CURSOR c_entries(p_collection_xml XMLTYPE)

843: p_entity_name IN VARCHAR2,
844: p_column_name IN VARCHAR2
845: )
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:

Line 886: PROCEDURE SAVE_ATTR_DATA( p_xml IN XMLTYPE,

882: END LOOP;
883: END;
884:
885:
886: PROCEDURE SAVE_ATTR_DATA( p_xml IN XMLTYPE,
887: p_entity_name IN VARCHAR2,
888: p_transaction_id IN NUMBER,
889: p_bundle_id IN NUMBER,
890: p_source_system_id IN NUMBER,

Line 905: CURSOR c_AttributeGrps(p_entity_xml XMLTYPE, p_entity_name VARCHAR2)

901: p_last_update_login IN NUMBER)
902: IS
903:
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:

Line 911: CURSOR c_Attributes(p_attrGrp_xml XMLTYPE)

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
913: SELECT Value(xml_tab) attributes
914: FROM TABLE(XMLSEQUENCE(EXTRACT(p_attrGrp_xml, '/AttributeGroup/Attribute'))) xml_tab;
915:

Line 923: l_xml_trans XMLTYPE;

919: l_attr_text_value VARCHAR2(255);
920: l_attr_numeric_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
921: l_attr_quant_unit_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
922: l_is_trans BOOLEAN;
923: l_xml_trans XMLTYPE;
924:
925: l_xml_attr_grp_int_nm XMLTYPE;
926: l_xml_attr_int_nm XMLTYPE;
927: l_xml_attr_val XMLTYPE;

Line 925: l_xml_attr_grp_int_nm XMLTYPE;

921: l_attr_quant_unit_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
922: l_is_trans BOOLEAN;
923: l_xml_trans XMLTYPE;
924:
925: l_xml_attr_grp_int_nm XMLTYPE;
926: l_xml_attr_int_nm XMLTYPE;
927: l_xml_attr_val XMLTYPE;
928: l_date_value EGO_ITM_USR_ATTR_INTRFC.attr_value_date%TYPE;
929:

Line 926: l_xml_attr_int_nm XMLTYPE;

922: l_is_trans BOOLEAN;
923: l_xml_trans XMLTYPE;
924:
925: l_xml_attr_grp_int_nm XMLTYPE;
926: l_xml_attr_int_nm XMLTYPE;
927: l_xml_attr_val XMLTYPE;
928: l_date_value EGO_ITM_USR_ATTR_INTRFC.attr_value_date%TYPE;
929:
930: BEGIN

Line 927: l_xml_attr_val XMLTYPE;

923: l_xml_trans XMLTYPE;
924:
925: l_xml_attr_grp_int_nm XMLTYPE;
926: l_xml_attr_int_nm XMLTYPE;
927: l_xml_attr_val XMLTYPE;
928: l_date_value EGO_ITM_USR_ATTR_INTRFC.attr_value_date%TYPE;
929:
930: BEGIN
931: FOR l_xml_AttrGrps IN c_AttributeGrps(p_xml, p_entity_name)

Line 1073: l_xml_data XMLTYPE;

1069: IS
1070: l_rt_trimmed_xml CLOB;
1071: l_trimmed_xml CLOB;
1072: l_bundles_xml CLOB;
1073: l_xml_data XMLTYPE;
1074:
1075: l_BundlesStartTag varchar2(25) := '';
1076: l_BundleStartTag varchar2(25) := '';
1077: l_BundlesEndTag varchar2(25) := '';

Line 1084: l_xml_trans XMLTYPE;

1080: l_BundleIdEndTag varchar2(25) := '';
1081:
1082: l_MessageTag VARCHAR2(200);
1083:
1084: l_xml_trans XMLTYPE;
1085: x_return_type VARCHAR2(80);
1086: x_return_msg VARCHAR2(80);
1087: l_return_msg VARCHAR2(80);
1088:

Line 1105: l_xml_null_chk XMLTYPE;

1101: l_supplier_site_id NUMBER;
1102: l_supplier_name VARCHAR2(255);
1103: l_row_identifier NUMBER;
1104: l_hdr_source_sys_reference VARCHAR2(255);
1105: l_xml_null_chk XMLTYPE;
1106: l_xml_batch_name XMLTYPE;
1107: l_external_bundle_id VARCHAR2(255);
1108:
1109: l_bundles_clob CLOB;

Line 1106: l_xml_batch_name XMLTYPE;

1102: l_supplier_name VARCHAR2(255);
1103: l_row_identifier NUMBER;
1104: l_hdr_source_sys_reference VARCHAR2(255);
1105: l_xml_null_chk XMLTYPE;
1106: l_xml_batch_name XMLTYPE;
1107: l_external_bundle_id VARCHAR2(255);
1108:
1109: l_bundles_clob CLOB;
1110: l_err_bundles_clob CLOB;

Line 1137: CURSOR c_bundles(p_collection_xml XMLTYPE)

1133: EGO_ORC_INVALID_GLN EXCEPTION;
1134: EGO_ORC_DELETE_LINE EXCEPTION;
1135:
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:

Line 1143: CURSOR c_items(p_bundles_xml XMLTYPE)

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
1145: SELECT Value(xml_tab) items
1146: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/Item'))) xml_tab;
1147:

Line 1149: CURSOR c_classifications(p_items_xml XMLTYPE)

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
1151: SELECT Value(xml_tab) classifications
1152: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemCatalog'))) xml_tab;
1153:

Line 1155: CURSOR c_suppliers(p_items_xml XMLTYPE)

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
1157: SELECT Value(xml_tab) suppliers
1158: FROM TABLE(XMLSEQUENCE(EXTRACT(p_items_xml, '/Item/ItemSupplier'))) xml_tab;
1159:

Line 1161: CURSOR c_supplierLocations(p_suppliers_xml XMLTYPE)

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
1163: SELECT Value(xml_tab) supplierLocations
1164: FROM TABLE(XMLSEQUENCE(EXTRACT(p_suppliers_xml, '/ItemSupplier/ItemSupplierLocation'))) xml_tab;
1165:

Line 1167: CURSOR c_structure(p_bundles_xml XMLTYPE)

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
1169: SELECT Value(xml_tab) structures
1170: FROM TABLE(XMLSEQUENCE(EXTRACT(p_bundles_xml, '/ItemPublicationLine/ItemStructure'))) xml_tab;
1171:

Line 1173: CURSOR c_component(p_structures_xml XMLTYPE)

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
1175: SELECT Value(xml_tab) components
1176: FROM TABLE(XMLSEQUENCE(EXTRACT(p_structures_xml, '/ItemStructure/ComponentItem'))) xml_tab;
1177:

Line 1211: l_xml_data := XMLTYPE(l_trimmed_xml);

1207:
1208: IF l_trimmed_xml IS NOT NULL
1209: THEN
1210: BEGIN
1211: l_xml_data := XMLTYPE(l_trimmed_xml);
1212: EXCEPTION
1213: WHEN OTHERS
1214: THEN
1215: RAISE EGO_ORC_XML_ERROR;