APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on DBMS_LOB

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

2645: IF (get_report_info%found) then
2646: close get_report_info;
2647: -- parse the retrieved clob data
2648:
2649: l_size := dbms_lob.getlength(l_content);
2650: --debug_msg_s1 ('get clob content size' || l_size);
2651:
2652: l_pos := 1;
2653: l_copy_size := 0;

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

2658: while l_copy_size < l_size loop
2659:
2660: --debug_msg_s1 ('before read ');
2661:
2662: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
2663:
2664: -- debug_msg_s1 (l_line);
2665: --debug_msg_s1 ('in loop size 1' || l_copy_size);
2666:

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

2663:
2664: -- debug_msg_s1 (l_line);
2665: --debug_msg_s1 ('in loop size 1' || l_copy_size);
2666:
2667: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
2668:
2669: l_copy_size := l_copy_size + l_chunk_size;
2670: l_pos := l_pos + l_chunk_size;
2671: end loop;

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

2681: ,x_msg_data => l_msg_data
2682: );
2683: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2684: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
2685: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
2686: end if;
2687:
2688: --debug_msg_s1 ('total copy size' || l_copy_size);
2689:

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

2686: end if;
2687:
2688: --debug_msg_s1 ('total copy size' || l_copy_size);
2689:
2690: --dbms_lob.writeappend(document, 5, '12345');
2691: else
2692: close get_report_info;
2693: END IF;
2694:

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

2698:
2699: --debug_msg_s1('Error '||TO_CHAR(SQLCODE)||': '||substr(Sqlerrm, 255));
2700:
2701: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
2702: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
2703:
2704: END show_report_content;
2705:
2706: END pa_progress_report_WORKFLOW;