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 2007: -- bufferIdx := wf_temp_lob.getLob(g_LOBTable);

2003: --buffer CLOB;
2004: -- bufferIdx pls_integer;
2005:
2006: begin
2007: -- bufferIdx := wf_temp_lob.getLob(g_LOBTable);
2008:
2009: -- for each response variable
2010: for rec in c1 loop
2011: -- Print description

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

2076: buffer => str_buffer);
2077: str_buffer := '';
2078: end if;
2079: -- DBMS_LOB.Append(doc, g_LOBTable(bufferIdx).temp_lob);
2080: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
2081:
2082: exception
2083: when others then
2084: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

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

2080: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
2081:
2082: exception
2083: when others then
2084: -- wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
2085: wf_core.context('WF_MAIL', 'GetMailToBody', to_char(nid));
2086: raise;
2087: end GetMailToBody;
2088:

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

3457: if validToken then
3458: -- Only request a LOB if it is necessary and only if one
3459: -- has not already been requested.
3460: if tempIdx = -1 then
3461: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3462: end if;
3463: amount := pos - sourcePos;
3464: DBMS_LOB.Copy(dest_lob => g_LOBTable(tempIdx).temp_lob,
3465: src_lob => message,

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

3478: else
3479: amount := msgLen - sourcePos +1;
3480: if (amount > 0)then
3481: if tempIdx = -1 then
3482: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3483: end if;
3484: DBMS_LOB.Copy(g_LOBTable(tempIdx).temp_lob, message, amount,
3485: targetPos, sourcePos);
3486: end if;

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

3487:
3488: if (append and tokenFound = FALSE and msgLen > 0) then
3489: if (tokenValue <> '' or tokenValue is not null) then
3490: if tempIdx = -1 then
3491: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3492: end if;
3493: DBMS_LOB.WriteAppend(g_LOBTable(tempIdx).temp_lob,
3494: length(tokenValue), tokenValue);
3495: end if;

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

3505: end if;
3506:
3507: -- << sstomar bug 6511028 >> Release allocated TEMP LOb.
3508: if tempIdx <> -1 then
3509: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3510: end if;
3511:
3512: exception
3513: when others then

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

3510: end if;
3511:
3512: exception
3513: when others then
3514: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3515: WF_CORE.Context('WF_MAIL','LOBReplace',token,
3516: tokenValue);
3517: raise;
3518:

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

3552: tokenFound boolean;
3553:
3554: begin
3555: -- DBMS_LOB.CreateTemporary(temp, FALSE, DBMS_LOB.CALL);
3556: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3557:
3558: offset := 1;
3559: sourcePos := 1;
3560: targetPos := 1;

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

3617: msgLen := DBMS_LOB.GetLength(g_LOBTable(tempIdx).temp_lob);
3618: DBMS_LOB.Trim(message, 0);
3619: DBMS_LOB.Copy(message, g_LOBTable(tempIdx).temp_lob, msgLen);
3620: end if;
3621: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3622:
3623: exception
3624: when others then
3625: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

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

3621: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3622:
3623: exception
3624: when others then
3625: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3626: WF_CORE.Context('WF_MAIL','LOBReplace',token, 'LOB');
3627: raise;
3628:
3629: end LOBReplace;

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

3717: end if;
3718:
3719: -- DBMS_LOB.CreateTemporary(temp, TRUE, DBMS_LOB.SESSION);
3720: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
3721: tempIdx := wf_temp_lob.getLob(g_LOBTable);
3722:
3723: pos := 1;
3724: tempPos := 1;
3725: msgLen := length(template);

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

3982: end if;
3983:
3984: -- DBMS_LOB.Close(temp);
3985: -- DBMS_LOB.FreeTemporary(temp);
3986: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3987:
3988: exception
3989: when others then
3990: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);

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

3986: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3987:
3988: exception
3989: when others then
3990: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
3991: WF_CORE.Context('WF_MAIL','LOBSubstitute',tokenName,
3992: to_char(msgLen)||':'||to_char(pos)||':'||to_char(tempPos));
3993: raise;
3994: end LOBSubstitute;

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

4035: -- DBMS_LOB.CreateTemporary(temp, TRUE, DBMS_LOB.CALL);
4036: -- DBMS_LOB.CreateTemporary(line, TRUE, DBMS_LOB.CALL);
4037: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
4038: -- DBMS_LOB.Open(line, DBMS_LOB.LOB_READWRITE);
4039: tempIdx := wf_temp_lob.getLob(g_LOBTable);
4040: lineIdx := wf_temp_lob.getLob(g_LOBTable);
4041:
4042: while start_cnt < str_length loop
4043: -- use the existing newlines as a natural break

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

4036: -- DBMS_LOB.CreateTemporary(line, TRUE, DBMS_LOB.CALL);
4037: -- DBMS_LOB.Open(temp, DBMS_LOB.LOB_READWRITE);
4038: -- DBMS_LOB.Open(line, DBMS_LOB.LOB_READWRITE);
4039: tempIdx := wf_temp_lob.getLob(g_LOBTable);
4040: lineIdx := wf_temp_lob.getLob(g_LOBTable);
4041:
4042: while start_cnt < str_length loop
4043: -- use the existing newlines as a natural break
4044: crpos := DBMS_LOB.instr(message, g_newLine, start_cnt+1, 1) - start_cnt;

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

4144: -- if DBMS_LOB.IsOpen(line)=1 then
4145: -- DBMS_LOB.Close(line);
4146: -- DBMS_LOB.FreeTemporary(line);
4147: -- end if;
4148: wf_temp_lob.releaseLob(g_LOBTable, lineIdx);
4149: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
4150:
4151: end OBSOLETELOBLineBreak;
4152:

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

4145: -- DBMS_LOB.Close(line);
4146: -- DBMS_LOB.FreeTemporary(line);
4147: -- end if;
4148: wf_temp_lob.releaseLob(g_LOBTable, lineIdx);
4149: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
4150:
4151: end OBSOLETELOBLineBreak;
4152:
4153: -- OBSOLETE2LOBLineBreak

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

4185: if doc_length = 0 or doc_length < line_size then
4186: return;
4187: end if;
4188:
4189: tempIdx := wf_temp_lob.getLob(g_LOBTable);
4190:
4191: -- While the block start counter is less than the length of the
4192: -- document, then start scanning to make sure that the document
4193: -- conforms to the requirements of the parameters.

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

4297: DBMS_LOB.Copy(message, g_LOBTable(tempIdx).temp_lob,
4298: DBMS_LOB.GetLength(g_LOBTable(tempIdx).temp_lob), 1, 1);
4299:
4300: DBMS_LOB.Trim(g_LOBTable(tempIdx).temp_lob, 0);
4301: wf_temp_lob.releaseLob(g_LOBTable, tempIdx);
4302:
4303: end OBSOLETE2LOBLineBreak;
4304:
4305:

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

4329: l_tempIdx pls_integer;
4330:
4331: begin
4332:
4333: l_tempIdx := wf_temp_lob.getLob(g_LOBTable);
4334:
4335: l_amount := dbms_lob.getLength(message);
4336: l_offset := 1;
4337: l_bufferSize := l_lineSize;

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

4390: DBMS_LOB.Copy(message, g_LOBTable(l_tempIdx).temp_lob,
4391: DBMS_LOB.GetLength(g_LOBTable(l_tempIdx).temp_lob), 1, 1);
4392:
4393: DBMS_LOB.Trim(g_LOBTable(l_tempIdx).temp_lob, 0);
4394: wf_temp_lob.releaseLob(g_LOBTable, l_tempIdx);
4395: end if;
4396:
4397: -- exception
4398: -- when others then

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

4450:
4451: -- Clear buffer
4452: str_buffer := '';
4453: -- DBMS_LOB.createTemporary(buffer, FALSE, dbms_lob.call);
4454: bufferIdx := wf_temp_lob.getLob(g_LOBTable);
4455:
4456: -- URL RESPONSE attributes overrides the normal RESULT attributes.
4457: -- So, my goal here is to check for this case.
4458: -- URL RESPONSE attributes is going to appear as a anchor and don't have

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

4609: end if;
4610:
4611: -- LOBReplace(doc, '&'||'MAILTO', buffer, FALSE);
4612: LOBReplace(doc, '&'||'MAILTO', g_LOBTable(bufferIdx).temp_lob, FALSE);
4613: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4614:
4615: exception
4616: when others then
4617: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);

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

4613: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4614:
4615: exception
4616: when others then
4617: wf_temp_lob.releaseLob(g_LOBTable, bufferIdx);
4618: wf_core.context('WF_MAIL', 'GetMailTo', nid);
4619: raise;
4620:
4621: end GetMailTo;

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

5268: if (r_ntf_pref in ('MAILTEXT', 'MAILATTH')) then
5269: -- Below Allocated TEMP LOB here is released within WF_XML.getBodyPart
5270: -- ( which is called by caller of GetLOBMessage4 API)
5271: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5272: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5273:
5274: if (renderbody = 'Y') then
5275: end_of_message := FALSE;
5276: step := 'Getting text/plain body';

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

5303:
5304: if (r_ntf_pref in ('MAILHTML', 'MAILATTH', 'MAILHTM2')) then
5305: -- Below Allocated TEMP LOB IS released within WF_XML.getBodyPart
5306: -- based on the Ntf type (text/plain or text/html) by calling wf_mail.CloseLOB
5307: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
5308:
5309: if (renderbody = 'Y') then
5310: end_of_message := FALSE;
5311: step := 'Getting text/html body';

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

5581: wf_core.context('WF_MAIL', 'GetLOBMessage4', to_char(nid), node,
5582: 'step -> '||step);
5583:
5584: if(g_html_messageIdx IS NOT NULL AND g_html_messageIdx > 0 ) then
5585: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5586: end if;
5587:
5588: if(g_text_messageIdx IS NOT NULL AND g_text_messageIdx > 0 ) then
5589: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

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

5585: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5586: end if;
5587:
5588: if(g_text_messageIdx IS NOT NULL AND g_text_messageIdx > 0 ) then
5589: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
5590: end if;
5591:
5592: raise;
5593: when others then

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

5598: err_message := sqlerrm;
5599: end if;
5600:
5601: if(g_html_messageIdx is not null and g_html_messageIdx > 0 ) then
5602: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5603: end if;
5604:
5605: if(g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5606: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

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

5602: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
5603: end if;
5604:
5605: if(g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
5606: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
5607: end if;
5608:
5609: error_result := err_message||g_newLine||err_stack;
5610: wf_core.context('WF_MAIL', 'GetLOBMessage4', to_char(nid), node,

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

6110: -- DBMS_LOB.Open(g_text_message, DBMS_LOB.LOB_READWRITE);
6111:
6112: -- This g_text_messageIdx Locator will be returned back to pool within caller
6113: -- GenerateSummaryDoc -> getBodyPart
6114: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6115: if contType = g_ntfDocText then
6116: DBMS_LOB.WriteAppend(g_LOBTable(g_text_messageIdx).temp_lob,
6117: length(t_body), t_body);
6118: else

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

6120: length(t_html_body), t_html_body);
6121: end if;
6122:
6123: -- DBMS_LOB.CreateTemporary(temp_text, FALSE, DBMS_LOB.CALL);
6124: temp_textIdx := wf_temp_lob.getLob(g_LOBTable);
6125: end if;
6126: DBMS_LOB.WriteAppend(g_LOBTable(temp_textIdx).temp_lob,
6127: length(n_summ), n_summ);
6128: n_summ := '';

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

6136: LOBReplace(g_LOBTable(g_text_messageIdx).temp_lob, '&'||'SUMMARY',
6137: g_LOBTable(temp_textIdx).temp_lob, FALSE);
6138:
6139: -- Release temp_textIdx locator too. << bug 6511028 >>
6140: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
6141:
6142: else
6143: t_body := replace(t_body, '&'||'SUMMARY', n_summ);
6144: end if;

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

6162: when others then
6163: -- Release temp_textIdx and g_text_messageIdx locators in case of any exception .
6164: if(lob = 'Y' ) then
6165: if (temp_textIdx is not null and temp_textIdx > 0 ) then
6166: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
6167: end if;
6168:
6169: if ( g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
6170: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

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

6166: wf_temp_lob.releaseLob(g_LOBTable, temp_textIdx);
6167: end if;
6168:
6169: if ( g_text_messageIdx is not null and g_text_messageIdx > 0 ) then
6170: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
6171: end if;
6172:
6173: end if;
6174:

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

6286: begin
6287: if doc_type = g_ntfDocHtml then
6288: -- DBMS_LOB.close(g_html_message);
6289: -- DBMS_LOB.FreeTemporary(g_html_message);
6290: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
6291: else
6292: -- DBMS_LOB.close(g_text_message);
6293: -- DBMS_LOB.FreeTemporary(g_text_message);
6294: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);

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

6290: wf_temp_lob.releaseLob(g_LOBTable, g_html_messageIdx);
6291: else
6292: -- DBMS_LOB.close(g_text_message);
6293: -- DBMS_LOB.FreeTemporary(g_text_message);
6294: wf_temp_lob.releaseLob(g_LOBTable, g_text_messageIdx);
6295: end if;
6296: exception
6297: when others then
6298: WF_CORE.Context('WF_MAIL','CloseLOB', doc_type);

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

6510: doc := WF_NOTIFICATION.GetAttrDoc(nid, docattrname, disptype);
6511: if disptype = g_ntfDocHtml then
6512: -- DBMS_LOB.CreateTemporary(g_html_message, true, dbms_lob.SESSION);
6513: -- DBMS_LOB.Open(g_html_message, DBMS_LOB.LOB_READWRITE);
6514: g_html_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6515: if doc = '&'||docattrname then
6516: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6517: g_LOBTable(g_html_messageIdx).temp_lob, doctype, aname);
6518: else

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

6520: end if;
6521: else
6522: -- DBMS_LOB.CreateTemporary(g_text_message, true, dbms_lob.SESSION);
6523: -- DBMS_LOB.Open(g_text_message, DBMS_LOB.LOB_READWRITE);
6524: g_text_messageIdx := wf_temp_lob.getLob(g_LOBTable);
6525: if doc = '&'||docattrname then
6526: Wf_Notification.GetAttrCLOB(nid, docattrname, disptype,
6527: g_LOBTable(g_text_messageIdx).temp_lob, doctype, aname);
6528: else

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

8115: l_pos := wf_xml.NewLOBTag(l_msg_doc, l_pos, 'BODYPART', '', l_attrlist);
8116:
8117: --
8118:
8119: l_messageIdx := wf_temp_lob.getLOB(g_LOBTable);
8120:
8121: dbms_lob.trim(g_LOBTable(l_messageIdx).temp_lob,0);
8122:
8123: dbms_lob.writeAppend(g_LOBTable(l_messageIdx).temp_lob,

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

8187:
8188: wf_event.send(l_event);
8189:
8190: -- Release allocated temp LOBs back to pool
8191: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
8192:
8193: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8194: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
8195: 'wf.plsql.WF_MAIL.send',

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

8199: exception
8200: when others then
8201: -- Release allocated temp LOBs back to pool
8202: if(l_messageIdx > 0 ) then
8203: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
8204: END if;
8205:
8206:
8207: wf_core.context('Wf_Mail', 'Send', p_idstring, p_subject);

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

8535: wf_xml.AddElementAttribute('content-type','text/plain', l_attrlist);
8536: l_pos := wf_xml.NewLOBTag(l_msg_doc,l_pos,'BODYPART', '', l_attrlist);
8537:
8538:
8539: l_messageidx := wf_temp_lob.getlob(g_lobtable);
8540:
8541: dbms_lob.TRIM(g_lobtable(l_messageidx).temp_lob,0);
8542:
8543: dbms_lob.writeappend(g_lobtable(l_messageidx).temp_lob,

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

8625:
8626: wf_event.send(l_event);
8627:
8628: -- Release allocated temp LOBs back to pool
8629: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8630:
8631: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8632: wf_log_pkg.string(wf_log_pkg.level_procedure,
8633: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'END');

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

8640: WF_Notification.SetNLSLanguage(l_orig_lang,l_orig_terr);
8641: end IF;
8642:
8643: if(l_messageidx > 0) then
8644: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8645: end if;
8646:
8647: raise;
8648: end SendMoreInfoResponseWarning;