eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_NOTIFICATION dependencies on DBMS_LOB

Line 5438: pos := dbms_lob.getlength(clob_loc) +1;

5434: pos integer;
5435: amt number;
5436: begin
5437:
5438: pos := dbms_lob.getlength(clob_loc) +1;
5439: amt := length(msg_string);
5440: dbms_lob.write(clob_loc,amt,pos,msg_string);
5441:
5442: exception

Line 5440: dbms_lob.write(clob_loc,amt,pos,msg_string);

5436: begin
5437:
5438: pos := dbms_lob.getlength(clob_loc) +1;
5439: amt := length(msg_string);
5440: dbms_lob.write(clob_loc,amt,pos,msg_string);
5441:
5442: exception
5443: when others then
5444: wf_core.context('WF_NOTIFICATION','WriteToClob');

Line 5836: dbms_lob.freeTemporary(clobloc);

5832: -- is pointing to a locator and whether being freed .
5833: -- bug 6511028
5834: begin
5835: if(clobloc is not null) then
5836: dbms_lob.freeTemporary(clobloc);
5837: end if;
5838: exception
5839: WHEN OTHERS THEN
5840: null; -- ignore ORA-22275 and other exceptions

Line 5846: dbms_lob.createtemporary(clobloc, TRUE, DBMS_LOB.session);

5842:
5843: -- make clob temporary. this may impact the speed of the UI
5844: -- such that user has to wait to see the notification.
5845: -- To improve performance make sure buffer cache is well tuned.
5846: dbms_lob.createtemporary(clobloc, TRUE, DBMS_LOB.session);
5847:
5848: if msg_string is not null then
5849: pos := 1;
5850: amt := length(msg_string);

Line 5851: dbms_lob.write(clobloc,amt,pos,msg_string);

5847:
5848: if msg_string is not null then
5849: pos := 1;
5850: amt := length(msg_string);
5851: dbms_lob.write(clobloc,amt,pos,msg_string);
5852: end if;
5853:
5854: exception
5855: when others then

Line 5874: dbms_lob.read(wf_notification.temp_clob,buff_length,pos,line);

5870: --linenbr is always one before the line to print.
5871: --it is incremented afterwards.
5872: pos:=(buff_length * nvl(wf_notification.clob_chunk,0) ) +1;
5873:
5874: dbms_lob.read(wf_notification.temp_clob,buff_length,pos,line);
5875:
5876: if pos+buff_length > dbms_lob.getlength(wf_notification.temp_clob) then
5877: end_of_clob := TRUE;
5878: wf_notification.clob_chunk := 0;

Line 5876: if pos+buff_length > dbms_lob.getlength(wf_notification.temp_clob) then

5872: pos:=(buff_length * nvl(wf_notification.clob_chunk,0) ) +1;
5873:
5874: dbms_lob.read(wf_notification.temp_clob,buff_length,pos,line);
5875:
5876: if pos+buff_length > dbms_lob.getlength(wf_notification.temp_clob) then
5877: end_of_clob := TRUE;
5878: wf_notification.clob_chunk := 0;
5879: else
5880: wf_notification.clob_chunk := wf_notification.clob_chunk +1;