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

Line 22: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;

18: -- g_fist_message
19: -- Flag to control the dequeuing of the SMTP queue
20: g_first_message boolean := TRUE;
21:
22: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;
23:
24: TYPE wf_resourceList_rec_t IS RECORD
25: (
26: contentId VARCHAR2(1000),

Line 378: wf_temp_lob.ReleaseLob(g_LOBTable, l_msgLobIdx);

374:
375: exception
376: when others then
377: -- just in case, check and free it any way.
378: wf_temp_lob.ReleaseLob(g_LOBTable, l_msgLobIdx);
379: wf_core.context('WF_XML','EnqueueMessage',p_queue, to_char(p_priority),
380: p_correlation);
381: raise;
382: end EnqueueMessage;

Line 457: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);

453: amount => l_amount,
454: offset => p_pos + 1,
455: buffer => l_tempStr);
456: else
457: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);
458: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,
459: src_lob => p_doc,
460: amount => l_amount,
461: dest_offset => 1,

Line 483: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);

479: dbms_lob.copy(dest_lob => p_doc,
480: src_lob => g_LOBTable(l_tempIdx).temp_lob,
481: amount => l_amount ,
482: dest_offset => p_pos + l_nodesize + 1);
483: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);
484: end if;
485:
486: l_pos := (p_pos + l_nodesize) - length(l_end);
487: -- Free up the use of the temporary LOB

Line 500: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);

496: return l_pos;
497:
498: exception
499: when others then
500: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);
501: wf_core.context('WF_XML','NewLOBTag', p_tag);
502: raise;
503: end NewLOBTag;
504:

Line 540: l_nodeIdx := wf_temp_lob.getLob(g_LOBTable);

536:
537: -- Create an instance of the node
538: -- A Node is deemed to be Data
539: l_tempIdx := -1;
540: l_nodeIdx := wf_temp_lob.getLob(g_LOBTable);
541:
542: l_start := '<' || upper(p_tag);
543:
544: -- If there are any attributes to add to the tag, then

Line 586: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);

582: amount => l_amount,
583: offset => p_pos + 1,
584: buffer => l_tempStr);
585: else
586: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);
587: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,
588: src_lob => p_doc,
589: amount => l_amount,
590: dest_offset => 1,

Line 615: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);

611: amount => l_amount,
612: dest_offset => p_pos + l_nodesize + 1);
613: end if;
614: -- Free up the use of the temporary LOBs
615: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
616: end if;
617:
618:
619: l_pos := (p_pos + l_nodesize) - length(l_end);

Line 622: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);

618:
619: l_pos := (p_pos + l_nodesize) - length(l_end);
620:
621: -- Free up the use of the temporary LOBs
622: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
623:
624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
625: wf_log_pkg.string(WF_LOG_PKG.level_statement,
626: 'wf.plsql.WF_XML.newLOBTag',

Line 634: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);

630: return l_pos;
631:
632: exception
633: when others then
634: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
635: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
636: wf_core.context('WF_XML','NewLOBTag', p_tag);
637: raise;
638: end NewLOBTag;

Line 635: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);

631:
632: exception
633: when others then
634: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
635: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
636: wf_core.context('WF_XML','NewLOBTag', p_tag);
637: raise;
638: end NewLOBTag;
639:

Line 938: -- Allocate LOB from WF_TEMP LOB pool.

934: begin
935:
936: -- dbms_lob.createTemporary(l_content, TRUE, dbms_lob.CALL);
937:
938: -- Allocate LOB from WF_TEMP LOB pool.
939: l_contentIdx := wf_temp_lob.getLOB(g_LOBTable);
940: dbms_lob.createTemporary(l_blob, TRUE, dbms_lob.CALL);
941:
942: l_pos := p_pos;

Line 939: l_contentIdx := wf_temp_lob.getLOB(g_LOBTable);

935:
936: -- dbms_lob.createTemporary(l_content, TRUE, dbms_lob.CALL);
937:
938: -- Allocate LOB from WF_TEMP LOB pool.
939: l_contentIdx := wf_temp_lob.getLOB(g_LOBTable);
940: dbms_lob.createTemporary(l_blob, TRUE, dbms_lob.CALL);
941:
942: l_pos := p_pos;
943: for l_crec in c_attr(p_nid) loop

Line 1262: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);

1258:
1259: end if;
1260:
1261: -- relase TEMP allocated LOB
1262: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1263:
1264: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1265: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1266: 'wf.plsql.WF_XML.GetAttachment',

Line 1274: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);

1270: return l_pos;
1271: exception
1272: when others then
1273: WF_MAIL.CloseLob(l_display_type);
1274: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1275: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,
1276: to_char(p_pos));
1277: l_err_message := sqlerrm;
1278: raise;

Line 1451: l_docIdx := wf_temp_lob.getLob(g_LOBTable);

1447:
1448:
1449: -- Instantiate a handle to the new document.
1450: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);
1451: l_docIdx := wf_temp_lob.getLob(g_LOBTable);
1452:
1453: -- Initialise the XML Document and then progressively walk
1454: -- through the elements. Populating them as we go.
1455: -- l_pos is crucial as it determines where the next nodes

Line 1577: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

1573: p_priority := l_priority;
1574: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,
1575: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);
1576: -- dbms_lob.freetemporary(l_doc).temp_lob);
1577: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1578:
1579: exception
1580: when others then
1581: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

Line 1581: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

1577: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1578:
1579: exception
1580: when others then
1581: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1582: wf_core.context('WF_XML', 'GetXMLMessage', to_char(p_nid), p_protocol,
1583: p_node, p_nlang, p_nterr);
1584: raise;
1585: end getXMLMessage;

Line 1632: l_docIdx := wf_temp_lob.getLOB(g_LOBTable);

1628: -- previous interface of WF_MAIL.GetMessage.
1629:
1630: -- Instantiate a handle to the new document.
1631: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);
1632: l_docIdx := wf_temp_lob.getLOB(g_LOBTable);
1633:
1634: -- Initialise the XML Document and then progressively walk
1635: -- through the elements. Populating them as we go.
1636: -- l_pos is crucial as it determines where the next nodes

Line 1688: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

1684: p_priority := l_priority;
1685: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,
1686: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);
1687: -- dbms_lob.freetemporary(g_LOBTable(l_docIdx).temp_lob);
1688: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1689:
1690: exception
1691: when others then
1692: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

Line 1692: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

1688: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1689:
1690: exception
1691: when others then
1692: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1693: wf_core.context('WF_XML', 'GetShortLOBXMLMessage', to_char(p_nid));
1694: raise;
1695: end getShortLOBXMLMessage;
1696:

Line 1854: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);

1850: -- A valid role has been found for a notification
1851: -- that is required to go out.
1852: -- Prepare a LOB to contain the payload message.
1853: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.SESSION);
1854: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);
1855:
1856: wf_queue.set_queue_names;
1857: wf_queue.get_hash_queue_name (p_protocol => 'SMTP',
1858: p_inbound_outbound => 'OUTBOUND',

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

1909: end if;
1910: end loop;
1911: end loop;
1912: -- dbms_lob.freetemporary(l_message);
1913: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1914: end if;
1915:
1916: exception
1917: when others then

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

1914: end if;
1915:
1916: exception
1917: when others then
1918: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1919: wf_core.context('WF_XML', 'EnqueueFullNotification', to_char(p_nid));
1920: raise;
1921: end EnqueueFullNotification;
1922:

Line 1963: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);

1959: -- A valid role has been found for a notification
1960: -- that is required to go out.
1961:
1962: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.CALL);
1963: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);
1964: -- Get an encoded payload.
1965: getShortLOBXMLMessage(p_nid, l_priority,
1966: g_LOBTable(l_messageIdx).temp_lob);
1967:

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

1976: p_correlation => wf_queue.account_name ||':'||
1977: to_char(p_nid),
1978: p_message => g_LOBTable(l_messageIdx).temp_lob);
1979: end if;
1980: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1981:
1982: exception
1983: when others then
1984: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);

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

1980: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1981:
1982: exception
1983: when others then
1984: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1985: wf_core.context('WF_XML', 'EnqueueLOBNotification', to_char(p_nid));
1986: raise;
1987: end EnqueueLOBNotification;
1988:

Line 2678: tmpIdx := wf_temp_lob.getLob(g_LOBTable);

2674: resourceList.DELETE;
2675:
2676: imagesFound := false;
2677:
2678: tmpIdx := wf_temp_lob.getLob(g_LOBTable);
2679: for url in g_urls(nid) loop
2680: value := url.text_value;
2681: value := wf_notification.SetFrameworkAgent(value);
2682:

Line 2744: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);

2740: end if; -- Image TAG is in the messages body
2741: end if; -- The URL is an image reference
2742: end loop;
2743:
2744: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2745:
2746: return imagesFound;
2747: exception
2748: when others then

Line 2750: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);

2746: return imagesFound;
2747: exception
2748: when others then
2749: -- Release temp LOB if any error , bug 6511028
2750: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2751:
2752: wf_core.context('WF_XML','ParseForInlineImages',to_char(nid));
2753: raise;
2754: end ParseForInlineImages;

Line 3360: messageIdx := wf_temp_lob.getLob(g_LOBTable);

3356: end if;
3357:
3358: -- If we are here, we are going to generate notification xml payload
3359: -- So allocate TEMP LOB now. << bug 6511028 >>
3360: messageIdx := wf_temp_lob.getLob(g_LOBTable);
3361:
3362: WF_MAIL.setContext(nid);
3363:
3364: -- bug-8515763 : Temporary workaround for HOTMAIL and Yahoo web clients user.

Line 4039: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);

4035: pos := SkipLOBTag(p_doc, 'CONTENT', pos, occurance);
4036: pos := SkipLOBTag(p_doc, 'NOTIFICATION', pos, occurance);
4037:
4038: p_pos := pos;
4039: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4040:
4041:
4042: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4043: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

Line 4049: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);

4045: end if;
4046: exception
4047: when others then
4048:
4049: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4050:
4051: -- Since within wf_mail.getLOBMessage4 we are releasing
4052: -- TEMP LOBs incase of any exception, so there is no need to
4053: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)

Line 4665: messageIdx := wf_temp_lob.getLob(g_LOBTable);

4661: AddElementAttribute('content-type', docType, attrlist);
4662: if (l_lob = 'Y') then
4663:
4664: -- dbms_lob.createTemporary(message, TRUE, dbms_lob.CALL);
4665: messageIdx := wf_temp_lob.getLob(g_LOBTable);
4666: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
4667:
4668: -- << bug 6511028 >>
4669: -- This getBodyPart API also releases temp lob allocated within

Line 4678: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);

4674:
4675: pos := NewLOBTag(p_doc, pos, 'MESSAGE',
4676: g_LOBTable(messageIdx).temp_lob, attrlist);
4677: -- release Temp lob to pool.
4678: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4679:
4680: else
4681:
4682: msgbody := '';

Line 4724: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);

4720:
4721: exception
4722: when others then
4723: if (messageIdx > 0) then
4724: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4725: end if;
4726:
4727: -- Reset base NLS Context in case of any EXCEPTION
4728: WF_NOTIFICATION_UTIL.SetNLSContext(