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 1283: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2

1279: WHEN OTHERS THEN
1280: null;
1281: END;
1282:
1283: function getValue(P_XML XMLType,P_VARIABLE VARCHAR2) return VARCHAR2
1284: IS
1285: tmp varchar2(400);
1286: BEGIN
1287: select extractValue(P_XML,P_VARIABLE) into tmp from dual;

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

1288: return tmp;
1289: END getValue;
1290:
1291:
1292: PROCEDURE GET_INSTR_XML (P_EVENT_KEY IN VARCHAR2,P_MAP_CODE IN VARCHAR2,X_FINAL_XML OUT NOCOPY XMLType) IS
1293:
1294: l_xml CLOB;
1295: l_final_xml CLOB;
1296: l_result XMLType;

Line 1296: l_result XMLType;

1292: PROCEDURE GET_INSTR_XML (P_EVENT_KEY IN VARCHAR2,P_MAP_CODE IN VARCHAR2,X_FINAL_XML OUT NOCOPY XMLType) IS
1293:
1294: l_xml CLOB;
1295: l_final_xml CLOB;
1296: l_result XMLType;
1297: l_erecID NUMBER(22);
1298: --This holds the query context.
1299: qryCtx DBMS_XMLGEN.ctxHandle;
1300: l_srcDoc dbms_xmldom.DOMDocument;

Line 1314: esigHdrFinalXML XMLType;

1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;
1314: esigHdrFinalXML XMLType;
1315: l_debug_level number(2):=6;
1316: l_error_code pls_integer;
1317: l_log_file varchar2(2000);
1318: l_error_msg varchar2(2000);

Line 1340: l_result := xmltype(l_xml);

1336:
1337:
1338:
1339: -- construct the XML Type object
1340: l_result := xmltype(l_xml);
1341:
1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);

Line 1359: esigHdrFinalXML := xmltype(l_final_xml);

1355: P_GET_ACKN_DETAILS =>'F',
1356: P_GET_PRINT_DETAILS =>'F',
1357: P_GET_RELATED_EREC_DETAILS =>'F',
1358: X_FINAL_XML => l_final_xml);
1359: esigHdrFinalXML := xmltype(l_final_xml);
1360:
1361:
1362: -- construct ESIG HDR Node
1363: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);

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

1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: END GET_INSTR_XML;
1413:
1414: PROCEDURE PROCESS_INSTR_XML (p_entity_name VARCHAR2,p_entity_key VARCHAR2,p_event_key varchar2,p_instr_type VARCHAR2,
1415: p_instr_status VARCHAR2,P_BATCHPROGRESSION_STATUS VARCHAR2,P_EVENT_NAME VARCHAR2,P_FINAL_XML XMLType) IS
1416: l_batch_id number := null;
1417: l_batchstep_id number := null;
1418: l_material_detail_id number := null;
1419: l_batchstep_activity_id number := null;

Line 1612: l_result XMLType;

1608: END PROCESS_INSTR_XML;
1609:
1610: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1611: l_xml_map_code varchar2(240);
1612: l_result XMLType;
1613: l_temp XMLType;
1614: l_entity_name VARCHAR2(200);
1615: l_entity_key VARCHAR2(500);
1616: l_instr_type VARCHAR2(40);

Line 1613: l_temp XMLType;

1609:
1610: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1611: l_xml_map_code varchar2(240);
1612: l_result XMLType;
1613: l_temp XMLType;
1614: l_entity_name VARCHAR2(200);
1615: l_entity_key VARCHAR2(500);
1616: l_instr_type VARCHAR2(40);
1617: l_instr_status VARCHAR2(40);