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_MAIL dependencies on WF_TEMP_LOB

Line 35: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;

31:
32:
33:
34: -- Indexes for CLOB from the pool
35: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;
36:
37: g_text_messageIdx pls_integer;
38: g_html_messageIdx pls_integer;
39: g_attachmentIdx pls_integer;

Line 1872: -- bufferIdx := wf_temp_lob.getLob(g_LOBTable);

1868: --buffer CLOB;
1869: -- bufferIdx pls_integer;
1870:
1871: begin
1872: -- bufferIdx := wf_temp_lob.getLob(g_LOBTable);
1873:
1874: -- for each response variable
1875: for rec in c1 loop
1876: -- Print description

Line 1933: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

1929: buffer => str_buffer);
1930: str_buffer := '';
1931: end if;
1932: -- DBMS_LOB.Append(doc, g_LOBTable(bufferIdx).temp_lob);
1933: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
1934:
1935: exception
1936: when others then
1937: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

Line 1937: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

1933: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
1934:
1935: exception
1936: when others then
1937: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
1938: wf_core.context('WF_MAIL', 'GetMailToBody', to_char(nid));
1939: raise;
1940: end GetMailToBody;
1941:

Line 3307: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3303: if validToken then
3304: -- Only request a LOB if it is necessary and only if one
3305: -- has not already been requested.
3306: if tempIdx = -1 then
3307: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3308: end if;
3309: amount := pos - sourcePos;
3310: DBMS_LOB.Copy(dest_lob => g_LOBTable(tempIdx).temp_lob,
3311: src_lob => message,

Line 3328: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3324: else
3325: amount := msgLen - sourcePos +1;
3326: if (amount > 0)then
3327: if tempIdx = -1 then
3328: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3329: end if;
3330: DBMS_LOB.Copy(g_LOBTable(tempIdx).temp_lob, message, amount,
3331: targetPos, sourcePos);
3332: end if;

Line 3337: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3333:
3334: if (append and tokenFound = FALSE and msgLen > 0) then
3335: if (tokenValue <> '' or tokenValue is not null) then
3336: if tempIdx = -1 then
3337: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3338: end if;
3339: DBMS_LOB.WriteAppend(g_LOBTable(tempIdx).temp_lob,
3340: length(tokenValue), tokenValue);
3341: end if;

Line 3355: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3351: end if;
3352:
3353: -- << sstomar bug 6511028 >> Release allocated TEMP LOb.
3354: if tempIdx <> -1 then
3355: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3356: end if;
3357:
3358: exception
3359: when others then

Line 3360: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3356: end if;
3357:
3358: exception
3359: when others then
3360: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3361: WF_CORE.Context('WF_MAIL','LOBReplace',token,
3362: tokenValue);
3363: raise;
3364:

Line 3402: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3398: tokenFound boolean;
3399:
3400: begin
3401: -- DBMS_LOB.CreateTemporary(temp, FALSE, DBMS_LOB.CALL);
3402: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3403:
3404: offset := 1;
3405: sourcePos := 1;
3406: targetPos := 1;

Line 3467: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3463: msgLen := DBMS_LOB.GetLength(g_LOBTable(tempIdx).temp_lob);
3464: DBMS_LOB.Trim(message, 0);
3465: DBMS_LOB.Copy(message, g_LOBTable(tempIdx).temp_lob, msgLen);
3466: end if;
3467: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3468:
3469: exception
3470: when others then
3471: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

Line 3471: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3467: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3468:
3469: exception
3470: when others then
3471: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3472: WF_CORE.Context('WF_MAIL','LOBReplace',token, 'LOB');
3473: raise;
3474:
3475: end LOBReplace;

Line 3567: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3563: end if;
3564:
3565: -- DBMS_LOB.CreateTemporary(temp, TRUE, DBMS_LOB.SESSION);
3566: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
3567: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3568:
3569: pos := 1;
3570: tempPos := 1;
3571: msgLen := length(template);

Line 3830: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3826: end if;
3827:
3828: -- DBMS_LOB.Close(temp);
3829: -- DBMS_LOB.FreeTemporary(temp);
3830: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3831:
3832: exception
3833: when others then
3834: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

Line 3834: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3830: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3831:
3832: exception
3833: when others then
3834: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3835: WF_CORE.Context('WF_MAIL','LOBSubstitute',tokenName,
3836: to_char(msgLen)||':'||to_char(pos)||':'||to_char(tempPos));
3837: raise;
3838: end LOBSubstitute;

Line 3883: tempIdx := wf_temp_lob.getLob(g_LOBTable);

3879: -- DBMS_LOB.CreateTemporary(temp, TRUE, DBMS_LOB.CALL);
3880: -- DBMS_LOB.CreateTemporary(line, TRUE, DBMS_LOB.CALL);
3881: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
3882: -- DBMS_LOB.Open(line, DBMS_LOB.LOB_READWRITE);
3883: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3884: lineIdx := wf_temp_lob.getLob(g_LOBTable);
3885:
3886: while start_cnt < str_length loop
3887: -- use the existing newlines as a natural break

Line 3884: lineIdx := wf_temp_lob.getLob(g_LOBTable);

3880: -- DBMS_LOB.CreateTemporary(line, TRUE, DBMS_LOB.CALL);
3881: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
3882: -- DBMS_LOB.Open(line, DBMS_LOB.LOB_READWRITE);
3883: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3884: lineIdx := wf_temp_lob.getLob(g_LOBTable);
3885:
3886: while start_cnt < str_length loop
3887: -- use the existing newlines as a natural break
3888: crpos := DBMS_LOB.instr(message, g_newLine, start_cnt+1, 1) - start_cnt;

Line 3992: wf_temp_lob.releaseLob(g_LOBTable, lineIdx);

3988: -- if DBMS_LOB.IsOpen(line)=1 then
3989: -- DBMS_LOB.Close(line);
3990: -- DBMS_LOB.FreeTemporary(line);
3991: -- end if;
3992: wf_temp_lob.releaseLob(g_LOBTable, lineIdx);
3993: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3994:
3995: end OBSOLETELOBLineBreak;
3996:

Line 3993: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

3989: -- DBMS_LOB.Close(line);
3990: -- DBMS_LOB.FreeTemporary(line);
3991: -- end if;
3992: wf_temp_lob.releaseLob(g_LOBTable, lineIdx);
3993: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3994:
3995: end OBSOLETELOBLineBreak;
3996:
3997: -- OBSOLETE2LOBLineBreak

Line 4033: tempIdx := wf_temp_lob.getLob(g_LOBTable);

4029: if doc_length = 0 or doc_length < line_size then
4030: return;
4031: end if;
4032:
4033: tempIdx := wf_temp_lob.getLob(g_LOBTable);
4034:
4035: -- While the block start counter is less than the length of the
4036: -- document, then start scanning to make sure that the document
4037: -- conforms to the requirements of the parameters.

Line 4145: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

4141: DBMS_LOB.Copy(message, g_LOBTable(tempIdx).temp_lob,
4142: DBMS_LOB.GetLength(g_LOBTable(tempIdx).temp_lob), 1, 1);
4143:
4144: DBMS_LOB.Trim(g_LOBTable(tempIdx).temp_lob, 0);
4145: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
4146:
4147: end OBSOLETE2LOBLineBreak;
4148:
4149:

Line 4177: l_tempIdx := wf_temp_lob.getLob(g_LOBTable);

4173: l_tempIdx pls_integer;
4174:
4175: begin
4176:
4177: l_tempIdx := wf_temp_lob.getLob(g_LOBTable);
4178:
4179: l_amount := dbms_lob.getLength(message);
4180: l_offset := 1;
4181: l_bufferSize := l_lineSize;

Line 4238: wf_temp_lob.releaseLob(g_LOBTable, l_tempIdx);

4234: DBMS_LOB.Copy(message, g_LOBTable(l_tempIdx).temp_lob,
4235: DBMS_LOB.GetLength(g_LOBTable(l_tempIdx).temp_lob), 1, 1);
4236:
4237: DBMS_LOB.Trim(g_LOBTable(l_tempIdx).temp_lob, 0);
4238: wf_temp_lob.releaseLob(g_LOBTable, l_tempIdx);
4239: end if;
4240:
4241: -- exception
4242: -- when others then

Line 4296: bufferIdx := wf_temp_lob.getLob(g_LOBTable);

4292:
4293: -- Clear buffer
4294: str_buffer := '';
4295: -- DBMS_LOB.createTemporary(buffer, FALSE, dbms_lob.call);
4296: bufferIdx := wf_temp_lob.getLob(g_LOBTable);
4297:
4298: -- URL RESPONSE attributes overrides the normal RESULT attributes.
4299: -- So, my goal here is to check for this case.
4300: -- URL RESPONSE attributes is going to appear as a anchor and don't have

Line 4436: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

4432: end if;
4433:
4434: -- LOBReplace(doc, '&'||'MAILTO', buffer, FALSE);
4435: LOBReplace(doc, '&'||'MAILTO', g_LOBTable(bufferIdx).temp_lob, FALSE);
4436: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4437:
4438: exception
4439: when others then
4440: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

Line 4440: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

4436: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4437:
4438: exception
4439: when others then
4440: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4441: wf_core.context('WF_MAIL', 'GetMailTo', nid);
4442: raise;
4443:
4444: end GetMailTo;

Line 5095: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);

5091: if (r_ntf_pref in ('MAILTEXT', 'MAILATTH')) then
5092: -- Below Allocated TEMP LOB here is released within WF_XML.getBodyPart
5093: -- ( which is called by caller of getLOBMessage3 API)
5094: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5095: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5096:
5097: if (renderbody = 'Y') then
5098: end_of_message := FALSE;
5099: step := 'Getting text/plain body';

Line 5130: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);

5126:
5127: if (r_ntf_pref in ('MAILHTML', 'MAILATTH', 'MAILHTM2')) then
5128: -- Below Allocated TEMP LOB IS released within WF_XML.getBodyPart
5129: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5130: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5131:
5132: if (renderbody = 'Y') then
5133: end_of_message := FALSE;
5134: step := 'Getting text/html body';

Line 5407: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);

5403: wf_core.context('WF_MAIL', 'GetLOBMessage3', to_char(nid), node,
5404: 'step -> '||step);
5405:
5406: if(g_html_messageIdx IS NOT NULL AND g_html_messageIdx > 0 ) then
5407: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5408: end if;
5409:
5410: if(g_text_messageIdx IS NOT NULL AND g_text_messageIdx > 0 ) then
5411: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

Line 5411: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

5407: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5408: end if;
5409:
5410: if(g_text_messageIdx IS NOT NULL AND g_text_messageIdx > 0 ) then
5411: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
5412: end if;
5413:
5414: raise;
5415: when others then

Line 5424: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);

5420: err_message := sqlerrm;
5421: end if;
5422:
5423: if(g_html_messageIdx is not null and g_html_messageIdx > 0 ) then
5424: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5425: end if;
5426:
5427: if(g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5428: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

Line 5428: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

5424: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5425: end if;
5426:
5427: if(g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5428: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
5429: end if;
5430:
5431: error_result := err_message||g_newLine||err_stack;
5432: wf_core.context('WF_MAIL', 'GetLOBMessage3', to_char(nid), node,

Line 5850: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);

5846: -- DBMS_LOB.Open(g_text_message, DBMS_LOB.LOB_READWRITE);
5847:
5848: -- This g_text_messageIdx Locator will be returned back to pool within caller
5849: -- GenerateSummaryDoc -> getBodyPart
5850: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5851: if contType = g_ntfDocText then
5852: DBMS_LOB.WriteAppend(g_LOBTable(g_text_messageIdx).temp_lob,
5853: length(t_body), t_body);
5854: else

Line 5860: temp_textIdx := wf_temp_lob.getLob(g_LOBTable);

5856: length(t_html_body), t_html_body);
5857: end if;
5858:
5859: -- DBMS_LOB.CreateTemporary(temp_text, FALSE, DBMS_LOB.CALL);
5860: temp_textIdx := wf_temp_lob.getLob(g_LOBTable);
5861: end if;
5862: DBMS_LOB.WriteAppend(g_LOBTable(temp_textIdx).temp_lob,
5863: length(n_summ), n_summ);
5864: n_summ := '';

Line 5876: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);

5872: LOBReplace(g_LOBTable(g_text_messageIdx).temp_lob, '&'||'SUMMARY',
5873: g_LOBTable(temp_textIdx).temp_lob, FALSE);
5874:
5875: -- Release temp_textIdx locator too. << bug 6511028 >>
5876: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
5877:
5878: else
5879: t_body := replace(t_body, '&'||'SUMMARY', n_summ);
5880: end if;

Line 5902: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);

5898: when others then
5899: -- Release temp_textIdx and g_text_messageIdx locators in case of any exception .
5900: if(lob = 'Y' ) then
5901: if (temp_textIdx is not null and temp_textIdx > 0 ) then
5902: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
5903: end if;
5904:
5905: if ( g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5906: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

Line 5906: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

5902: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
5903: end if;
5904:
5905: if ( g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5906: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
5907: end if;
5908:
5909: end if;
5910:

Line 6026: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);

6022: begin
6023: if doc_type = g_ntfDocHtml then
6024: -- DBMS_LOB.close(g_html_message);
6025: -- DBMS_LOB.FreeTemporary(g_html_message);
6026: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
6027: else
6028: -- DBMS_LOB.close(g_text_message);
6029: -- DBMS_LOB.FreeTemporary(g_text_message);
6030: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

Line 6030: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

6026: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
6027: else
6028: -- DBMS_LOB.close(g_text_message);
6029: -- DBMS_LOB.FreeTemporary(g_text_message);
6030: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
6031: end if;
6032: exception
6033: when others then
6034: WF_CORE.Context('WF_MAIL','CloseLOB', doc_type);

Line 6250: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);

6246: doc := WF_NOTIFICATION.GetAttrDoc(nid, docattrname, disptype);
6247: if disptype = g_ntfDocHtml then
6248: -- DBMS_LOB.CreateTemporary(g_html_message, true, dbms_lob.SESSION);
6249: -- DBMS_LOB.Open(g_html_message, DBMS_LOB.LOB_READWRITE);
6250: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6251: if doc = '&'||docattrname then
6252: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6253: g_LOBTable(g_html_messageIdx).temp_lob, doctype, aname);
6254: else

Line 6260: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);

6256: end if;
6257: else
6258: -- DBMS_LOB.CreateTemporary(g_text_message, true, dbms_lob.SESSION);
6259: -- DBMS_LOB.Open(g_text_message, DBMS_LOB.LOB_READWRITE);
6260: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6261: if doc = '&'||docattrname then
6262: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6263: g_LOBTable(g_text_messageIdx).temp_lob, doctype, aname);
6264: else

Line 7800: l_messageIdx := wf_temp_lob.getLOB(g_LOBTable);

7796: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'BODYPART', '', l_attrlist);
7797:
7798: --
7799:
7800: l_messageIdx := wf_temp_lob.getLOB(g_LOBTable);
7801:
7802: dbms_lob.trim(g_LOBTable(l_messageIdx).temp_lob,0);
7803:
7804: dbms_lob.writeAppend(g_LOBTable(l_messageIdx).temp_lob,

Line 7872: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);

7868:
7869: wf_event.send(l_event);
7870:
7871: -- Release allocated temp LOBs back to pool
7872: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
7873:
7874: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7875: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7876: 'wf.plsql.WF_MAIL.send',

Line 7884: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);

7880: exception
7881: when others then
7882: -- Release allocated temp LOBs back to pool
7883: if(l_messageIdx > 0 ) then
7884: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
7885: END if;
7886:
7887:
7888: wf_core.context('Wf_Mail', 'Send', p_idstring, p_subject);

Line 8220: l_messageidx := wf_temp_lob.getlob(g_lobtable);

8216: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);
8217: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8218:
8219:
8220: l_messageidx := wf_temp_lob.getlob(g_lobtable);
8221:
8222: dbms_lob.TRIM(g_lobtable(l_messageidx).temp_lob,0);
8223:
8224: dbms_lob.writeappend(g_lobtable(l_messageidx).temp_lob,

Line 8310: wf_temp_lob.releaselob(g_lobtable, l_messageidx);

8306:
8307: wf_event.send(l_event);
8308:
8309: -- Release allocated temp LOBs back to pool
8310: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8311:
8312: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8313: wf_log_pkg.string(wf_log_pkg.level_procedure,
8314: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'END');

Line 8325: wf_temp_lob.releaselob(g_lobtable, l_messageidx);

8321: WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr);
8322: end IF;
8323:
8324: if(l_messageidx > 0) then
8325: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8326: end if;
8327:
8328: raise;
8329: end SendMoreInfoResponseWarning;