APPS.PA_TASK_WORKFLOW_PKG dependencies on DBMS_LOB

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

820: IF (c_pwp_preview_info%FOUND) THEN
821: IF c_pwp_preview_info%ISOPEN THEN
822: CLOSE c_pwp_preview_info;
823: END IF;
824: l_size := dbms_lob.getlength(l_content);
825: l_pos := 1;
826: l_copy_size := 0;
827: WHILE (l_copy_size < l_size) LOOP
828: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);

Line 828: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);

824: l_size := dbms_lob.getlength(l_content);
825: l_pos := 1;
826: l_copy_size := 0;
827: WHILE (l_copy_size < l_size) LOOP
828: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);
829: DBMS_LOB.WRITE(document,l_chunk_size,l_pos,l_line);
830: l_copy_size := l_copy_size + l_chunk_size;
831: l_pos := l_pos + l_chunk_size;
832: END LOOP;

Line 829: DBMS_LOB.WRITE(document,l_chunk_size,l_pos,l_line);

825: l_pos := 1;
826: l_copy_size := 0;
827: WHILE (l_copy_size < l_size) LOOP
828: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);
829: DBMS_LOB.WRITE(document,l_chunk_size,l_pos,l_line);
830: l_copy_size := l_copy_size + l_chunk_size;
831: l_pos := l_pos + l_chunk_size;
832: END LOOP;
833:

Line 843: DBMS_LOB.writeappend(document, 255, SUBSTR(l_msg_data, 255));

839: ,x_msg_data => l_msg_data);
840:
841: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
842: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
843: DBMS_LOB.writeappend(document, 255, SUBSTR(l_msg_data, 255));
844: END IF;
845: ELSE
846: IF c_pwp_preview_info%ISOPEN THEN
847: CLOSE c_pwp_preview_info;

Line 856: dbms_lob.writeappend(document, 255, substrb('Testing', 255));

852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
856: dbms_lob.writeappend(document, 255, substrb('Testing', 255));
857: NULL;
858: END SHOW_TASK_NOTIFY_PREVIEW;
859:
860: -- Procedure to add content to the CLOB column

Line 875: l_length := dbms_lob.getlength(p_clob);

871:
872: BEGIN
873:
874: l_chunksize := length(p_varchar);
875: l_length := dbms_lob.getlength(p_clob);
876:
877: DBMS_LOB.write(p_clob
878: ,l_chunksize
879: ,l_length+1

Line 877: DBMS_LOB.write(p_clob

873:
874: l_chunksize := length(p_varchar);
875: l_length := dbms_lob.getlength(p_clob);
876:
877: DBMS_LOB.write(p_clob
878: ,l_chunksize
879: ,l_length+1
880: ,p_varchar);
881: v_size := 1000;

Line 882: DBMS_LOB.read(p_clob, v_size, 1, v_text);

878: ,l_chunksize
879: ,l_length+1
880: ,p_varchar);
881: v_size := 1000;
882: DBMS_LOB.read(p_clob, v_size, 1, v_text);
883:
884: END APPEND_VARCHAR_TO_CLOB;
885:
886: FUNCTION show_error(p_error_stack IN VARCHAR2,