APPS.PA_DCTN_APRV_NOTIFICATION dependencies on DBMS_LOB

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

775: IF (c_pwp_preview_info%FOUND) THEN
776: IF c_pwp_preview_info%ISOPEN THEN
777: CLOSE c_pwp_preview_info;
778: END IF;
779: l_size := dbms_lob.getlength(l_content);
780: l_pos := 1;
781: l_copy_size := 0;
782: WHILE (l_copy_size < l_size) LOOP
783: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);

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

779: l_size := dbms_lob.getlength(l_content);
780: l_pos := 1;
781: l_copy_size := 0;
782: WHILE (l_copy_size < l_size) LOOP
783: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);
784: DBMS_LOB.WRITE(document,l_chunk_size,l_pos,l_line);
785: l_copy_size := l_copy_size + l_chunk_size;
786: l_pos := l_pos + l_chunk_size;
787: END LOOP;

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

780: l_pos := 1;
781: l_copy_size := 0;
782: WHILE (l_copy_size < l_size) LOOP
783: DBMS_LOB.READ(l_content,l_chunk_size,l_pos,l_line);
784: DBMS_LOB.WRITE(document,l_chunk_size,l_pos,l_line);
785: l_copy_size := l_copy_size + l_chunk_size;
786: l_pos := l_pos + l_chunk_size;
787: END LOOP;
788:

Line 796: DBMS_LOB.writeappend(document, 255, SUBSTR(SQLERRM, 255));

792: ,x_msg_data => l_msg_data);
793:
794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
795: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
796: DBMS_LOB.writeappend(document, 255, SUBSTR(SQLERRM, 255));
797: END IF;
798: ELSE
799: IF c_pwp_preview_info%ISOPEN THEN
800: CLOSE c_pwp_preview_info;

Line 809: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255));

805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
809: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255));
810: NULL;
811: END SHOW_PWP_NOTIFY_PREVIEW;
812:
813:

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

824:
825: BEGIN
826:
827: l_chunksize := length(p_varchar);
828: l_length := dbms_lob.getlength(p_clob);
829:
830: DBMS_LOB.write(p_clob
831: ,l_chunksize
832: ,l_length+1

Line 830: DBMS_LOB.write(p_clob

826:
827: l_chunksize := length(p_varchar);
828: l_length := dbms_lob.getlength(p_clob);
829:
830: DBMS_LOB.write(p_clob
831: ,l_chunksize
832: ,l_length+1
833: ,p_varchar);
834: v_size := 1000;

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

831: ,l_chunksize
832: ,l_length+1
833: ,p_varchar);
834: v_size := 1000;
835: DBMS_LOB.read(p_clob, v_size, 1, v_text);
836:
837: END APPEND_VARCHAR_TO_CLOB;
838:
839: PROCEDURE Submit (itemtype IN VARCHAR2