DBA Data[Home] [Help]

APPS.PER_NO_SICKLEAVEMONITORING dependencies on DBMS_LOB

Line 452: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);

448:
449: l_string := l_string || ''||EOL;
450:
451: -- Writing XML File
452: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
453: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
454: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
455: p_xml := l_xml;
456: dbms_lob.freeTemporary(l_xml);

Line 453: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);

449: l_string := l_string || ''||EOL;
450:
451: -- Writing XML File
452: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
453: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
454: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
455: p_xml := l_xml;
456: dbms_lob.freeTemporary(l_xml);
457:

Line 454: dbms_lob.writeAppend( l_xml, length(l_string), l_string);

450:
451: -- Writing XML File
452: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
453: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
454: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
455: p_xml := l_xml;
456: dbms_lob.freeTemporary(l_xml);
457:
458: IF g_debug THEN

Line 456: dbms_lob.freeTemporary(l_xml);

452: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
453: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
454: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
455: p_xml := l_xml;
456: dbms_lob.freeTemporary(l_xml);
457:
458: IF g_debug THEN
459: hr_utility.set_location(' Leaving Procedure GENERATE',2);
460: END IF;