APPS.IRC_JPS_GENERATOR dependencies on DBMS_LOB

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

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

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

443: l_result CLOB;
444: begin
445: hr_utility.set_location('Entering show_resume',10);
446: l_result:=generateJPS(p,s);
447: htp.p(dbms_lob.substr(l_result));
448: exception
449: when others then
450: hr_utility.set_location('Exception occured',20);
451: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);

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

519: generateJPSint(p_person_id=>p_person_id
520: ,p_stylesheet=>l_stylesheet
521: ,p_raw_doc =>l_parsed_xml
522: ,p_formatted_doc=>l_character_doc);
523: dbms_lob.createTemporary(l_binary_doc,false,dbms_lob.call);
524: l_position:=1;
525: loop
526: l_amount:=l_block_size;
527: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);

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

523: dbms_lob.createTemporary(l_binary_doc,false,dbms_lob.call);
524: l_position:=1;
525: loop
526: l_amount:=l_block_size;
527: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);
528: dbms_lob.write(l_binary_doc,l_amount,l_position,utl_raw.cast_to_raw(text_data));
529: if(l_amount 530: exit;
531: end if;

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

524: l_position:=1;
525: loop
526: l_amount:=l_block_size;
527: dbms_lob.read(l_character_doc,l_amount,l_position,text_data);
528: dbms_lob.write(l_binary_doc,l_amount,l_position,utl_raw.cast_to_raw(text_data));
529: if(l_amount 530: exit;
531: end if;
532: l_position:=l_position+l_amount;