APPS.WF_EVENT_HTML dependencies on DBMS_LOB

Line 5951: dbms_lob.createtemporary(l_event_data, FALSE, DBMS_LOB.CALL);

5947:
5948: if p_event_data is null then
5949: wf_event.raise(p_event_name, p_event_key);
5950: else
5951: dbms_lob.createtemporary(l_event_data, FALSE, DBMS_LOB.CALL);
5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);
5953: wf_event.raise(p_event_name, p_event_key, l_event_data);
5954: end if;
5955:

Line 5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);

5948: if p_event_data is null then
5949: wf_event.raise(p_event_name, p_event_key);
5950: else
5951: dbms_lob.createtemporary(l_event_data, FALSE, DBMS_LOB.CALL);
5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);
5953: wf_event.raise(p_event_name, p_event_key, l_event_data);
5954: end if;
5955:
5956: owa_util.redirect_url(curl=> wfa_html.base_url||'/wf_event_html.RaiseEventConfirm?p_event_name='||p_event_name||'&p_event_key='||p_event_key);

Line 7330: l_doclength := dbms_lob.getlength(l_clob);

7326: -- Set the Mime type to be text/xml
7327: --
7328:
7329: -- bug 2640742
7330: l_doclength := dbms_lob.getlength(l_clob);
7331:
7332: IF (l_clob IS NOT NULL and l_doclength > 0) THEN
7333: --owa_util.mime_header('text/xml', TRUE);
7334: owa_util.mime_header(p_mimetype, TRUE);

Line 7342: l_char := dbms_lob.substr(l_clob, 1, l_counter);

7338: -- Check for the presence of '<' in the beginning of clob. Leading white spaces
7339: -- in the XML document are ignored.
7340: l_counter := 1;
7341: loop
7342: l_char := dbms_lob.substr(l_clob, 1, l_counter);
7343: if (l_char = wf_core.tab or l_char = ' ') then
7344: l_counter := l_counter + 1;
7345: elsif (l_char = '<') then
7346: l_begintagpos := l_counter;

Line 7358: l_char := dbms_lob.substr(l_clob, 1, l_counter);

7354: -- Check for the presence of '>' in the end of clob. Trailing white spaces in the
7355: -- the XML document are ignored
7356: l_counter := l_doclength;
7357: loop
7358: l_char := dbms_lob.substr(l_clob, 1, l_counter);
7359: if (l_char = wf_core.tab or l_char = ' ') then
7360: l_counter := l_counter - 1;
7361: elsif (l_char = '>') then
7362: l_endtagpos := l_counter;

Line 7382: l_endposition := dbms_lob.instr(l_clob,'>',1,l_counter);

7378: LOOP
7379:
7380: l_counter := l_counter + 1;
7381:
7382: l_endposition := dbms_lob.instr(l_clob,'>',1,l_counter);
7383:
7384: EXIT when l_endposition = 0;
7385:
7386: l_amounttoread := l_endposition - l_beginposition + 1;

Line 7388: l_messagedata := dbms_lob.substr(l_clob, l_amounttoread,

7384: EXIT when l_endposition = 0;
7385:
7386: l_amounttoread := l_endposition - l_beginposition + 1;
7387:
7388: l_messagedata := dbms_lob.substr(l_clob, l_amounttoread,
7389: l_beginposition);
7390:
7391: htp.p(l_messagedata);
7392:

Line 7402: dbms_lob.read(

7398: LOOP
7399: l_counter := l_counter + 1;
7400:
7401: begin
7402: dbms_lob.read(
7403: l_clob,
7404: l_amounttoread,
7405: l_beginposition,
7406: l_messagedata

Line 7466: l_doclength := dbms_lob.getlength(l_eventdata);

7462:
7463: owa_util.http_header_close;
7464:
7465: -- bug 2640742
7466: l_doclength := dbms_lob.getlength(l_eventdata);
7467:
7468: -- Check for the presence of '>' in the begin of clob.
7469: Loop
7470: l_counter := l_counter + 1;

Line 7471: l_begintagpos := dbms_lob.instr(l_eventdata,'<',1,l_counter);

7467:
7468: -- Check for the presence of '>' in the begin of clob.
7469: Loop
7470: l_counter := l_counter + 1;
7471: l_begintagpos := dbms_lob.instr(l_eventdata,'<',1,l_counter);
7472: EXIT when l_begintagpos>0 or l_counter=l_doclength;
7473: END loop;
7474: l_counter:=0;
7475:

Line 7479: l_endtagpos := dbms_lob.instr(l_eventdata,'>',1,l_doclength-l_counter);

7475:
7476: -- Check for the presence of '<' in the end of clob.
7477: Loop
7478: l_counter := l_counter + 1;
7479: l_endtagpos := dbms_lob.instr(l_eventdata,'>',1,l_doclength-l_counter);
7480: EXIT when l_endtagpos>0 or l_counter=l_doclength ;
7481: END loop;
7482: l_counter:=0;
7483:

Line 7494: l_endposition := dbms_lob.instr(l_eventdata,'>',1,l_counter);

7490: LOOP
7491:
7492: l_counter := l_counter + 1;
7493:
7494: l_endposition := dbms_lob.instr(l_eventdata,'>',1,l_counter);
7495:
7496: EXIT when l_endposition = 0;
7497:
7498: l_amounttoread := l_endposition - l_beginposition + 1;

Line 7500: l_messagedata := dbms_lob.substr(l_eventdata, l_amounttoread,

7496: EXIT when l_endposition = 0;
7497:
7498: l_amounttoread := l_endposition - l_beginposition + 1;
7499:
7500: l_messagedata := dbms_lob.substr(l_eventdata, l_amounttoread,
7501: l_beginposition);
7502:
7503: htp.p(l_messagedata);
7504:

Line 7514: dbms_lob.read(

7510: LOOP
7511: l_counter := l_counter + 1;
7512:
7513: begin
7514: dbms_lob.read(
7515: l_eventdata,
7516: l_amounttoread,
7517: l_beginposition,
7518: l_messagedata