APPS.IRC_JPS_GENERATOR dependencies on DBMS_LOB

Line 376: dbms_lob.createTemporary(l_formatted_doc,false,dbms_lob.call);

372: dbms_xmlquery.setRowsetTag(ctx,'jobpositionseeker');
373: clobdoc:=dbms_xmlquery.getXML(ctx);
374: hr_utility.set_location('Retrieved the XML data',22);
375: dbms_xmlquery.closeContext(ctx);
376: dbms_lob.createTemporary(l_formatted_doc,false,dbms_lob.call);
377: hr_utility.set_location('Entering Parsing section',23);
378: parser:=xmlparser.newparser;
379:
380: hr_utility.set_location('Setting encoding',231);

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

450: l_result CLOB;
451: begin
452: hr_utility.set_location('Entering show_resume',10);
453: l_result:=generateJPS(p,s);
454: htp.p(dbms_lob.substr(l_result));
455: exception
456: when others then
457: hr_utility.set_location('Exception occured',20);
458: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);

Line 532: dbms_lob.createTemporary(l_binary_doc,false,dbms_lob.call);

528: ,p_stylesheet=>l_stylesheet
529: ,p_raw_doc =>l_parsed_xml
530: ,p_formatted_doc=>l_character_doc
531: ,p_stylesheet_content=>p_stylesheet_content);
532: dbms_lob.createTemporary(l_binary_doc,false,dbms_lob.call);
533: l_position:=1;
534: loop
535: l_amount:=l_block_size;
536: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);

Line 536: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);

532: dbms_lob.createTemporary(l_binary_doc,false,dbms_lob.call);
533: l_position:=1;
534: loop
535: l_amount:=l_block_size;
536: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);
537: dbms_lob.write(l_binary_doc,l_amount,l_position,utl_raw.cast_to_raw(text_data));
538: if(l_amount 539: exit;
540: end if;

Line 537: dbms_lob.write(l_binary_doc,l_amount,l_position,utl_raw.cast_to_raw(text_data));

533: l_position:=1;
534: loop
535: l_amount:=l_block_size;
536: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);
537: dbms_lob.write(l_binary_doc,l_amount,l_position,utl_raw.cast_to_raw(text_data));
538: if(l_amount 539: exit;
540: end if;
541: l_position:=l_position+l_amount;