APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on DBMS_LOB

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

1046: close get_report_info;
1047:
1048: -- parse the retrieved clob data
1049:
1050: l_size := dbms_lob.getlength(l_content);
1051:
1052: --debug_msg_s1 ('get clob content size' || l_size);
1053:
1054: l_pos := 1;

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

1060: while l_copy_size < l_size loop
1061:
1062: --debug_msg_s1 ('before read ');
1063:
1064: dbms_lob.read(l_content,l_chunk_size,l_pos,l_line);
1065:
1066: -- debug_msg_s1 (l_line);
1067: --debug_msg_s1 ('in loop size 1' || l_copy_size);
1068:

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

1065:
1066: -- debug_msg_s1 (l_line);
1067: --debug_msg_s1 ('in loop size 1' || l_copy_size);
1068:
1069: dbms_lob.write(document,l_chunk_size,l_pos,l_line);
1070:
1071: l_copy_size := l_copy_size + l_chunk_size;
1072: l_pos := l_pos + l_chunk_size;
1073: end loop;

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

1085: );
1086:
1087: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1088: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1089: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1090: end if;
1091:
1092: --debug_msg_s1 ('total copy size' || l_copy_size);
1093:

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

1090: end if;
1091:
1092: --debug_msg_s1 ('total copy size' || l_copy_size);
1093:
1094: --dbms_lob.writeappend(document, 5, '12345');
1095: ELSE
1096: close get_report_info;
1097: END IF;
1098:

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

1108: --debug_msg_s1('Error '||TO_CHAR(SQLCODE)||': '||substr(Sqlerrm, 255));
1109:
1110:
1111: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
1112: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
1113:
1114: END show_clob_content;
1115:
1116: