APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on DBMS_LOB

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

934: IF (get_workplan_preview_info%FOUND) THEN
935: close get_workplan_preview_info;
936:
937: -- parse the retrieved clob data
938: l_size := dbms_lob.getlength(l_content);
939:
940:
941: l_pos := 1;
942: l_copy_size := 0;

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

942: l_copy_size := 0;
943:
944: while (l_copy_size < l_size) loop
945:
946: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
947:
948: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
949: l_copy_size := l_copy_size + l_chunk_size;
950: l_pos := l_pos + l_chunk_size;

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

944: while (l_copy_size < l_size) loop
945:
946: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
947:
948: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
949: l_copy_size := l_copy_size + l_chunk_size;
950: l_pos := l_pos + l_chunk_size;
951: end loop;
952:

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

959: );
960:
961: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
962: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
963: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
964: end if;
965:
966:
967: --End of Changes Bug 3861540

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

973:
974: EXCEPTION
975: WHEN OTHERS THEN
976: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
977: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255)); -- changed substr to substrb for bug 3795807
978: NULL;
979: END show_workplan_preview;
980: /*=================================================================
981: