APPS.PA_PWP_NOTIFICATION dependencies on DBMS_LOB

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

1130: IF (c_pwp_preview_info%FOUND) THEN
1131: IF c_pwp_preview_info%ISOPEN THEN
1132: CLOSE c_pwp_preview_info;
1133: END IF;
1134: l_size := dbms_lob.getlength(l_content);
1135: l_pos := 1;
1136: l_copy_size := 0;
1137: WHILE (l_copy_size < l_size) LOOP
1138: dbms_lob.READ(l_content,l_chunk_size,l_pos,l_line);

Line 1138: dbms_lob.READ(l_content,l_chunk_size,l_pos,l_line);

1134: l_size := dbms_lob.getlength(l_content);
1135: l_pos := 1;
1136: l_copy_size := 0;
1137: WHILE (l_copy_size < l_size) LOOP
1138: dbms_lob.READ(l_content,l_chunk_size,l_pos,l_line);
1139: dbms_lob.WRITE(document,l_chunk_size,l_pos,l_line);
1140: l_copy_size := l_copy_size + l_chunk_size;
1141: l_pos := l_pos + l_chunk_size;
1142: END LOOP;

Line 1139: dbms_lob.WRITE(document,l_chunk_size,l_pos,l_line);

1135: l_pos := 1;
1136: l_copy_size := 0;
1137: WHILE (l_copy_size < l_size) LOOP
1138: dbms_lob.READ(l_content,l_chunk_size,l_pos,l_line);
1139: dbms_lob.WRITE(document,l_chunk_size,l_pos,l_line);
1140: l_copy_size := l_copy_size + l_chunk_size;
1141: l_pos := l_pos + l_chunk_size;
1142: END LOOP;
1143:

Line 1151: dbms_lob.writeappend(document, 255, SUBSTR(SQLERRM, 255));

1147: ,x_msg_data => l_msg_data);
1148:
1149: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1150: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
1151: dbms_lob.writeappend(document, 255, SUBSTR(SQLERRM, 255));
1152: END IF;
1153: ELSE
1154: IF c_pwp_preview_info%ISOPEN THEN
1155: CLOSE c_pwp_preview_info;

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

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
1164: dbms_lob.writeappend(document, 255, substrb(Sqlerrm, 255));
1165: NULL;
1166: END SHOW_PWP_NOTIFY_PREVIEW;
1167:
1168:

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

1189: v_size NUMBER;
1190: v_text VARCHAR2(3000);
1191: BEGIN
1192: l_chunksize := length(p_varchar);
1193: l_length := dbms_lob.getlength(p_clob);
1194:
1195: dbms_lob.write(p_clob
1196: ,l_chunksize
1197: ,l_length+1

Line 1195: dbms_lob.write(p_clob

1191: BEGIN
1192: l_chunksize := length(p_varchar);
1193: l_length := dbms_lob.getlength(p_clob);
1194:
1195: dbms_lob.write(p_clob
1196: ,l_chunksize
1197: ,l_length+1
1198: ,p_varchar);
1199: v_size := 1000;

Line 1200: dbms_lob.read(p_clob, v_size, 1, v_text);

1196: ,l_chunksize
1197: ,l_length+1
1198: ,p_varchar);
1199: v_size := 1000;
1200: dbms_lob.read(p_clob, v_size, 1, v_text);
1201: END APPEND_VARCHAR_TO_CLOB;
1202: ------------------------------
1203:
1204: END PA_PWP_NOTIFICATION;