APPS.TASK_MGR dependencies on DBMS_LOB

Line 229: DBMS_LOB.CREATETEMPORARY(query_clob, TRUE, DBMS_LOB.SESSION);

225: --DBMS_OUTPUT.PUT_LINE('X_MSG_COUNT = '||l_msg_count);
226: --DBMS_OUTPUT.PUT_LINE('MSG_DATA = ' ||l_msg_data);
227: --DBMS_OUTPUT.PUT_LINE('TASK_ID = ' ||l_version_num);
228:
229: DBMS_LOB.CREATETEMPORARY(query_clob, TRUE, DBMS_LOB.SESSION);
230:
231: IF (l_task_table.count > 0) THEN
232: v_first := l_task_table.first;
233: v_index := v_first;

Line 273: DBMS_LOB.WRITEAPPEND(query_clob, row_length, result);

269: -- ||'^'||NVL(l_task_table(v_index).cust_account_number, 'EMPTY')
270: ||'^';
271:
272: row_length := NVL(length(rtrim(result)), 0);
273: DBMS_LOB.WRITEAPPEND(query_clob, row_length, result);
274: result := '';
275:
276: EXIT WHEN v_index = l_task_table.last;
277: v_index := l_task_table.next(v_index);