APPS.GMO_DISPENSE_SETUP_PVT dependencies on DBMS_LOB

Line 379: DBMS_LOB.CREATETEMPORARY(X_OUTPUT_XML, TRUE, DBMS_LOB.SESSION);

375:
376: BEGIN
377:
378: --Create a temporary CLOB that would hold the final transaction XML.
379: DBMS_LOB.CREATETEMPORARY(X_OUTPUT_XML, TRUE, DBMS_LOB.SESSION);
380:
381: --Append the contents of the current XML.
382: DBMS_LOB.APPEND(X_OUTPUT_XML,P_CURRENT_XML);
383:

Line 382: DBMS_LOB.APPEND(X_OUTPUT_XML,P_CURRENT_XML);

378: --Create a temporary CLOB that would hold the final transaction XML.
379: DBMS_LOB.CREATETEMPORARY(X_OUTPUT_XML, TRUE, DBMS_LOB.SESSION);
380:
381: --Append the contents of the current XML.
382: DBMS_LOB.APPEND(X_OUTPUT_XML,P_CURRENT_XML);
383:
384: --Call the PL/SQL API to fetch the instruction set details in XML format for the specified
385: --process ID.
386: GMO_INSTRUCTION_GRP.GET_INSTR_XML

Line 402: DBMS_LOB.APPEND(X_OUTPUT_XML,L_INSTR_XML);

398: RAISE XML_ERROR;
399: END IF;
400:
401: --Append the XML of instruction set details to the final XML.
402: DBMS_LOB.APPEND(X_OUTPUT_XML,L_INSTR_XML);
403:
404: --Append the XML Footer to the FINAL XML.
405: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,length(EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER),EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER);
406:

Line 405: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,length(EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER),EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER);

401: --Append the XML of instruction set details to the final XML.
402: DBMS_LOB.APPEND(X_OUTPUT_XML,L_INSTR_XML);
403:
404: --Append the XML Footer to the FINAL XML.
405: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,length(EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER),EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER);
406:
407: EXCEPTION
408: WHEN XML_ERROR THEN
409: FND_MESSAGE.SET_ENCODED(L_MSG_DATA);