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.GMO_CBR_GRP dependencies on XMLTYPE

Line 1219: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2

1215: WHEN OTHERS THEN
1216: null;
1217: END;
1218:
1219: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2
1220: IS
1221: tmp varchar2(400);
1222: BEGIN
1223: select extractValue(P_XML,P_VARIABLE) into tmp from dual;

Line 1228: PROCEDURE GET_INSTR_XML (P_EVENT_KEY IN VARCHAR2,P_MAP_CODE IN VARCHAR2,X_FINAL_XML OUT NOCOPY XMLType) IS

1224: return tmp;
1225: END getValue;
1226:
1227:
1228: PROCEDURE GET_INSTR_XML (P_EVENT_KEY IN VARCHAR2,P_MAP_CODE IN VARCHAR2,X_FINAL_XML OUT NOCOPY XMLType) IS
1229:
1230: l_xml CLOB;
1231: l_final_xml CLOB;
1232: l_result XMLType;

Line 1232: l_result XMLType;

1228: PROCEDURE GET_INSTR_XML (P_EVENT_KEY IN VARCHAR2,P_MAP_CODE IN VARCHAR2,X_FINAL_XML OUT NOCOPY XMLType) IS
1229:
1230: l_xml CLOB;
1231: l_final_xml CLOB;
1232: l_result XMLType;
1233: l_erecID NUMBER(22);
1234: --This holds the query context.
1235: qryCtx DBMS_XMLGEN.ctxHandle;
1236: l_srcDoc dbms_xmldom.DOMDocument;

Line 1250: esigHdrFinalXML XMLType;

1246: l_esigNode dbms_xmldom.DOMNode;
1247: l_ehdrNode dbms_xmldom.DOMNode;
1248: l_eleNodeList dbms_xmldom.DOMNodeList;
1249: l_eleNode dbms_xmldom.DOMNode;
1250: esigHdrFinalXML XMLType;
1251: l_debug_level number(2):=6;
1252: l_error_code pls_integer;
1253: l_log_file varchar2(2000);
1254: l_error_msg varchar2(2000);

Line 1276: l_result := xmltype(l_xml);

1272:
1273:
1274:
1275: -- construct the XML Type object
1276: l_result := xmltype(l_xml);
1277:
1278: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1279: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1280: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);

Line 1295: esigHdrFinalXML := xmltype(l_final_xml);

1291: P_GET_ACKN_DETAILS =>'F',
1292: P_GET_PRINT_DETAILS =>'F',
1293: P_GET_RELATED_EREC_DETAILS =>'F',
1294: X_FINAL_XML => l_final_xml);
1295: esigHdrFinalXML := xmltype(l_final_xml);
1296:
1297:
1298: -- construct ESIG HDR Node
1299: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);

Line 1351: p_instr_status VARCHAR2,P_BATCHPROGRESSION_STATUS VARCHAR2,P_EVENT_NAME VARCHAR2,P_FINAL_XML XMLType) IS

1347: APP_EXCEPTION.RAISE_EXCEPTION;
1348: END GET_INSTR_XML;
1349:
1350: PROCEDURE PROCESS_INSTR_XML (p_entity_name VARCHAR2,p_entity_key VARCHAR2,p_event_key varchar2,p_instr_type VARCHAR2,
1351: p_instr_status VARCHAR2,P_BATCHPROGRESSION_STATUS VARCHAR2,P_EVENT_NAME VARCHAR2,P_FINAL_XML XMLType) IS
1352: l_batch_id number := null;
1353: l_batchstep_id number := null;
1354: l_material_detail_id number := null;
1355: l_batchstep_activity_id number := null;

Line 1548: l_result XMLType;

1544: END PROCESS_INSTR_XML;
1545:
1546: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1547: l_xml_map_code varchar2(240);
1548: l_result XMLType;
1549: l_temp XMLType;
1550: l_entity_name VARCHAR2(200);
1551: l_entity_key VARCHAR2(500);
1552: l_instr_type VARCHAR2(40);

Line 1549: l_temp XMLType;

1545:
1546: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1547: l_xml_map_code varchar2(240);
1548: l_result XMLType;
1549: l_temp XMLType;
1550: l_entity_name VARCHAR2(200);
1551: l_entity_key VARCHAR2(500);
1552: l_instr_type VARCHAR2(40);
1553: l_instr_status VARCHAR2(40);