APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on DBMS_LOB

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

946: close get_report_info;
947:
948: -- parse the retrieved clob data
949:
950: l_size := dbms_lob.getlength(l_content);
951:
952: --debug_msg_s1 ('get clob content size' || l_size);
953:
954: l_pos := 1;

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

960: while l_copy_size < l_size loop
961:
962: --debug_msg_s1 ('before read ');
963:
964: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
965:
966: -- debug_msg_s1 (l_line);
967: --debug_msg_s1 ('in loop size 1' || l_copy_size);
968:

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

965:
966: -- debug_msg_s1 (l_line);
967: --debug_msg_s1 ('in loop size 1' || l_copy_size);
968:
969: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
970:
971: l_copy_size := l_copy_size + l_chunk_size;
972: l_pos := l_pos + l_chunk_size;
973: end loop;

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

985: );
986:
987: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
988: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
989: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
990: end if;
991:
992: --debug_msg_s1 ('total copy size' || l_copy_size);
993:

Line 994: --dbms_lob.writeappend(document, 5, '12345');

990: end if;
991:
992: --debug_msg_s1 ('total copy size' || l_copy_size);
993:
994: --dbms_lob.writeappend(document, 5, '12345');
995: ELSE
996: close get_report_info;
997: END IF;
998:

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

1008: --debug_msg_s1('Error '||TO_CHAR(SQLCODE)||': '||substr(Sqlerrm, 255));
1009:
1010:
1011: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1012: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1013:
1014: END show_clob_content;
1015:
1016: