APPS.PA_WORKPLAN_WORKFLOW dependencies on DBMS_LOB

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

670: IF (get_error_info%FOUND) THEN
671: close get_error_info;
672:
673: -- parse the retrieved clob data
674: l_size := dbms_lob.getlength(l_content);
675:
676:
677: l_pos := 1;
678: l_copy_size := 0;

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

678: l_copy_size := 0;
679:
680: while (l_copy_size < l_size) loop
681:
682: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
683:
684: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
685: l_copy_size := l_copy_size + l_chunk_size;
686: l_pos := l_pos + l_chunk_size;

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

680: while (l_copy_size < l_size) loop
681:
682: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
683:
684: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
685: l_copy_size := l_copy_size + l_chunk_size;
686: l_pos := l_pos + l_chunk_size;
687: end loop;
688:

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

696: );
697:
698: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
699: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
700: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
701: end if;
702:
703:
704: --End of Changes Bug 3861540

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

710:
711: EXCEPTION
712: WHEN OTHERS THEN
713: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
714: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
715: NULL;
716: END SHOW_WORKPLAN_PUB_ERR;
717:
718: -- FP M : Project Execution Workflow