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_INSTRUCTION_PVT dependencies on XMLTYPE

Line 5816: --This variable would hold the XML details in XMLType format.

5812:
5813: PROCEDURE GET_INSTR_XML(P_INSTRUCTION_PROCESS_ID IN NUMBER,
5814: X_OUTPUT_XML OUT NOCOPY CLOB)
5815: IS
5816: --This variable would hold the XML details in XMLType format.
5817: L_INSTR_XML XMLTYPE;
5818:
5819: BEGIN
5820: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.

Line 5817: L_INSTR_XML XMLTYPE;

5813: PROCEDURE GET_INSTR_XML(P_INSTRUCTION_PROCESS_ID IN NUMBER,
5814: X_OUTPUT_XML OUT NOCOPY CLOB)
5815: IS
5816: --This variable would hold the XML details in XMLType format.
5817: L_INSTR_XML XMLTYPE;
5818:
5819: BEGIN
5820: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.
5821: SELECT XMLELEMENT("INSTRUCTIONS",XMLAGG(XMLELEMENT("INSTRUCTION_SET_DETAILS",

Line 5820: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.

5816: --This variable would hold the XML details in XMLType format.
5817: L_INSTR_XML XMLTYPE;
5818:
5819: BEGIN
5820: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.
5821: SELECT XMLELEMENT("INSTRUCTIONS",XMLAGG(XMLELEMENT("INSTRUCTION_SET_DETAILS",
5822: XMLFOREST(INSTR_SET.INSTRUCTION_PROCESS_ID AS INSTRUCTION_PROCESS_ID,
5823: INSTR_SET.INSTR_SET_NAME AS INSTRUCTION_SET_NAME,
5824: INSTR_SET.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,

Line 5875: --Convert XMLType to CLOB.

5871: INTO L_INSTR_XML
5872: FROM GMO_INSTR_SET_DEFN_T INSTR_SET
5873: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
5874:
5875: --Convert XMLType to CLOB.
5876: X_OUTPUT_XML := L_INSTR_XML.GETCLOBVAL();
5877:
5878: END GET_INSTR_XML;
5879:

Line 6239: L_INSTR_XML XMLTYPE;

6235:
6236: IS
6237:
6238: --This variable would hold the required instruction details in XML format.
6239: L_INSTR_XML XMLTYPE;
6240:
6241: BEGIN
6242:
6243: --This SQLX query will fetch us the required XML.