APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on DBMS_LOB

Line 956: l_size := dbms_lob.getlength(l_content);

952: IF (get_workplan_preview_info%FOUND) THEN
953: close get_workplan_preview_info;
954:
955: -- parse the retrieved clob data
956: l_size := dbms_lob.getlength(l_content);
957:
958:
959: l_pos := 1;
960: l_copy_size := 0;

Line 964: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);

960: l_copy_size := 0;
961:
962: while (l_copy_size < l_size) loop
963:
964: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
965:
966: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
967: l_copy_size := l_copy_size + l_chunk_size;
968: l_pos := l_pos + l_chunk_size;

Line 966: dbms_lob.write(document,l_chunk_size,l_pos,l_line);

962: while (l_copy_size < l_size) loop
963:
964: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
965:
966: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
967: l_copy_size := l_copy_size + l_chunk_size;
968: l_pos := l_pos + l_chunk_size;
969: end loop;
970:

Line 981: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));

977: );
978:
979: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
980: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
981: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
982: end if;
983:
984:
985: --End of Changes Bug 3861540

Line 995: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255)); -- changed substr to substrb for bug 3795807

991:
992: EXCEPTION
993: WHEN OTHERS THEN
994: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
995: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255)); -- changed substr to substrb for bug 3795807
996: NULL;
997: END show_workplan_preview;
998: /*=================================================================
999: