APPS.WF_NOTIFICATION dependencies on DBMS_LOB

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

5597: pos integer;
5598: amt number;
5599: begin
5600:
5601: pos := dbms_lob.getlength(clob_loc) +1;
5602: amt := length(msg_string);
5603: dbms_lob.write(clob_loc,amt,pos,msg_string);
5604:
5605: exception

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

5599: begin
5600:
5601: pos := dbms_lob.getlength(clob_loc) +1;
5602: amt := length(msg_string);
5603: dbms_lob.write(clob_loc,amt,pos,msg_string);
5604:
5605: exception
5606: when others then
5607: wf_core.context('WF_NOTIFICATION','WriteToClob');

Line 6006: dbms_lob.freeTemporary(clobloc);

6002: -- is pointing to a locator and whether being freed .
6003: -- bug 6511028
6004: begin
6005: if(clobloc is not null) then
6006: dbms_lob.freeTemporary(clobloc);
6007: end if;
6008: exception
6009: WHEN OTHERS THEN
6010: null; -- ignore ORA-22275 and other exceptions

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

6012:
6013: -- make clob temporary. this may impact the speed of the UI
6014: -- such that user has to wait to see the notification.
6015: -- To improve performance make sure buffer cache is well tuned.
6016: dbms_lob.createtemporary(clobloc, TRUE, DBMS_LOB.session);
6017:
6018: if msg_string is not null then
6019: pos := 1;
6020: amt := length(msg_string);

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

6017:
6018: if msg_string is not null then
6019: pos := 1;
6020: amt := length(msg_string);
6021: dbms_lob.write(clobloc,amt,pos,msg_string);
6022: end if;
6023:
6024: exception
6025: when others then

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

6040: --linenbr is always one before the line to print.
6041: --it is incremented afterwards.
6042: pos:=(buff_length * nvl(wf_notification.clob_chunk,0) ) +1;
6043:
6044: dbms_lob.read(wf_notification.temp_clob,buff_length,pos,line);
6045:
6046: if pos+buff_length > dbms_lob.getlength(wf_notification.temp_clob) then
6047: end_of_clob := TRUE;
6048: wf_notification.clob_chunk := 0;

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

6042: pos:=(buff_length * nvl(wf_notification.clob_chunk,0) ) +1;
6043:
6044: dbms_lob.read(wf_notification.temp_clob,buff_length,pos,line);
6045:
6046: if pos+buff_length > dbms_lob.getlength(wf_notification.temp_clob) then
6047: end_of_clob := TRUE;
6048: wf_notification.clob_chunk := 0;
6049: else
6050: wf_notification.clob_chunk := wf_notification.clob_chunk +1;