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 5838: --This variable would hold the XML details in XMLType format.

5834:
5835: PROCEDURE GET_INSTR_XML(P_INSTRUCTION_PROCESS_ID IN NUMBER,
5836: X_OUTPUT_XML OUT NOCOPY CLOB)
5837: IS
5838: --This variable would hold the XML details in XMLType format.
5839: L_INSTR_XML XMLTYPE;
5840:
5841: BEGIN
5842: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.

Line 5839: L_INSTR_XML XMLTYPE;

5835: PROCEDURE GET_INSTR_XML(P_INSTRUCTION_PROCESS_ID IN NUMBER,
5836: X_OUTPUT_XML OUT NOCOPY CLOB)
5837: IS
5838: --This variable would hold the XML details in XMLType format.
5839: L_INSTR_XML XMLTYPE;
5840:
5841: BEGIN
5842: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.
5843: SELECT XMLELEMENT("INSTRUCTIONS",XMLAGG(XMLELEMENT("INSTRUCTION_SET_DETAILS",

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

5838: --This variable would hold the XML details in XMLType format.
5839: L_INSTR_XML XMLTYPE;
5840:
5841: BEGIN
5842: --This SQL Query would provide all the instruction details for the specified process ID in XMLType.
5843: SELECT XMLELEMENT("INSTRUCTIONS",XMLAGG(XMLELEMENT("INSTRUCTION_SET_DETAILS",
5844: XMLFOREST(INSTR_SET.INSTRUCTION_PROCESS_ID AS INSTRUCTION_PROCESS_ID,
5845: INSTR_SET.INSTR_SET_NAME AS INSTRUCTION_SET_NAME,
5846: INSTR_SET.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,

Line 5897: --Convert XMLType to CLOB.

5893: INTO L_INSTR_XML
5894: FROM GMO_INSTR_SET_DEFN_T INSTR_SET
5895: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
5896:
5897: --Convert XMLType to CLOB.
5898: X_OUTPUT_XML := L_INSTR_XML.GETCLOBVAL();
5899:
5900: END GET_INSTR_XML;
5901:

Line 6262: L_INSTR_XML XMLTYPE;

6258:
6259: IS
6260:
6261: --This variable would hold the required instruction details in XML format.
6262: L_INSTR_XML XMLTYPE;
6263:
6264: BEGIN
6265:
6266: --This SQLX query will fetch us the required XML.