APPS.IRC_JPP_GENERATOR dependencies on DBMS_LOB

Line 507: dbms_lob.createTemporary(l_jpp_doc,false,dbms_lob.call);

503: xmlparser.parseCLOB(parser,clobdoc);
504: -- and put the parsed clob document in to an xml document
505: xmldoc:=xmlparser.getDocument(parser);
506: engine:=xslprocessor.newProcessor;
507: dbms_lob.createTemporary(l_jpp_doc,false,dbms_lob.call);
508: -- create the stylesheet
509: xmlparser.parseBuffer(parser,lv_stylesheet);
510: stylesheetdoc:=xmlparser.getDocument(parser);
511: stylesheet:=xslprocessor.newStylesheet(stylesheetdoc,null);

Line 521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);

517: xmldom.freeDocument(xmldoc);
518: xmldom.freeDocument(stylesheetdoc);
519: p_jpp_doc:=l_jpp_doc;
520: -- p_jpp_doc:=clobdoc;
521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
522: exception when others then
523: xslprocessor.freeProcessor(engine);
524: xmldom.freeDocument(xmldoc);
525: xmldom.freeDocument(stylesheetdoc);

Line 552: htp.p(dbms_lob.substr(l_result));

548: ,p_stylesheet_content clob default null) is
549: l_result CLOB;
550: begin
551: l_result:=generateJPP(p,u,s,p_stylesheet_content);
552: htp.p(dbms_lob.substr(l_result));
553: end show_posting;
554: --
555: function getXMLDataFromDB(p_recruitment_activity_id in number
556: ,p_sender_id in number) return clob is