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 25: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;

21:
22: TYPE parserStack_t IS TABLE OF
23: varchar2(2000) INDEX BY BINARY_INTEGER;
24:
25: g_LOBTable wf_temp_lob.wf_temp_lob_table_type;
26:
27: TYPE wf_resourceList_rec_t IS RECORD
28: (
29: contentId VARCHAR2(1000),

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

369:
370: exception
371: when others then
372: -- just in case, check and free it any way.
373: wf_temp_lob.ReleaseLob(g_LOBTable, l_msgLobIdx);
374: wf_core.context('WF_XML','EnqueueMessage',p_queue, to_char(p_priority),
375: p_correlation);
376: raise;
377: end EnqueueMessage;

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

448: amount => l_amount,
449: offset => p_pos + 1,
450: buffer => l_tempStr);
451: else
452: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);
453: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,
454: src_lob => p_doc,
455: amount => l_amount,
456: dest_offset => 1,

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

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

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

491: return l_pos;
492:
493: exception
494: when others then
495: wf_temp_lob.ReleaseLob(g_LOBTable, l_tempIdx);
496: wf_core.context('WF_XML','NewLOBTag', p_tag);
497: raise;
498: end NewLOBTag;
499:

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

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

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

577: amount => l_amount,
578: offset => p_pos + 1,
579: buffer => l_tempStr);
580: else
581: l_tempIdx := wf_temp_lob.GetLob(g_LOBTable);
582: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,
583: src_lob => p_doc,
584: amount => l_amount,
585: dest_offset => 1,

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

606: amount => l_amount,
607: dest_offset => p_pos + l_nodesize + 1);
608: end if;
609: -- Free up the use of the temporary LOBs
610: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
611: end if;
612:
613:
614: l_pos := (p_pos + l_nodesize) - length(l_end);

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

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

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

625: return l_pos;
626:
627: exception
628: when others then
629: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
630: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
631: wf_core.context('WF_XML','NewLOBTag', p_tag);
632: raise;
633: end NewLOBTag;

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

626:
627: exception
628: when others then
629: wf_temp_lob.releaseLOB(g_LOBTable, l_tempIdx);
630: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
631: wf_core.context('WF_XML','NewLOBTag', p_tag);
632: raise;
633: end NewLOBTag;
634:

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

1050: begin
1051:
1052: -- dbms_lob.createTemporary(l_content, TRUE, dbms_lob.CALL);
1053:
1054: -- Allocate LOB from WF_TEMP LOB pool.
1055: l_contentIdx := wf_temp_lob.getLOB(g_LOBTable);
1056: dbms_lob.createTemporary(l_blob, TRUE, dbms_lob.CALL);
1057:
1058: l_pos := p_pos;

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

1051:
1052: -- dbms_lob.createTemporary(l_content, TRUE, dbms_lob.CALL);
1053:
1054: -- Allocate LOB from WF_TEMP LOB pool.
1055: l_contentIdx := wf_temp_lob.getLOB(g_LOBTable);
1056: dbms_lob.createTemporary(l_blob, TRUE, dbms_lob.CALL);
1057:
1058: l_pos := p_pos;
1059: for l_crec in c_attr(p_nid) loop

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

1329:
1330: end if;
1331:
1332: -- relase TEMP allocated LOB
1333: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1334:
1335: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1336: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1337: 'wf.plsql.WF_XML.GetAttachment',

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

1341: return l_pos;
1342: exception
1343: when others then
1344: WF_MAIL.CloseLob(l_display_type);
1345: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1346: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,
1347: to_char(p_pos));
1348: l_err_message := sqlerrm;
1349: raise;

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

1518:
1519:
1520: -- Instantiate a handle to the new document.
1521: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);
1522: l_docIdx := wf_temp_lob.getLob(g_LOBTable);
1523:
1524: -- Initialise the XML Document and then progressively walk
1525: -- through the elements. Populating them as we go.
1526: -- l_pos is crucial as it determines where the next nodes

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

1644: p_priority := l_priority;
1645: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,
1646: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);
1647: -- dbms_lob.freetemporary(l_doc).temp_lob);
1648: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1649:
1650: exception
1651: when others then
1652: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

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

1648: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1649:
1650: exception
1651: when others then
1652: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1653: wf_core.context('WF_XML', 'GetXMLMessage', to_char(p_nid), p_protocol,
1654: p_node, p_nlang, p_nterr);
1655: raise;
1656: end getXMLMessage;

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

1699: -- previous interface of WF_MAIL.GetMessage.
1700:
1701: -- Instantiate a handle to the new document.
1702: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);
1703: l_docIdx := wf_temp_lob.getLOB(g_LOBTable);
1704:
1705: -- Initialise the XML Document and then progressively walk
1706: -- through the elements. Populating them as we go.
1707: -- l_pos is crucial as it determines where the next nodes

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

1755: p_priority := l_priority;
1756: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,
1757: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);
1758: -- dbms_lob.freetemporary(g_LOBTable(l_docIdx).temp_lob);
1759: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1760:
1761: exception
1762: when others then
1763: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);

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

1759: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1760:
1761: exception
1762: when others then
1763: wf_temp_lob.releaseLob(g_LOBTable, l_docIdx);
1764: wf_core.context('WF_XML', 'GetShortLOBXMLMessage', to_char(p_nid));
1765: raise;
1766: end getShortLOBXMLMessage;
1767:

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

1921: -- A valid role has been found for a notification
1922: -- that is required to go out.
1923: -- Prepare a LOB to contain the payload message.
1924: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.SESSION);
1925: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);
1926:
1927: wf_queue.set_queue_names;
1928: wf_queue.get_hash_queue_name (p_protocol => 'SMTP',
1929: p_inbound_outbound => 'OUTBOUND',

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

1980: end if;
1981: end loop;
1982: end loop;
1983: -- dbms_lob.freetemporary(l_message);
1984: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1985: end if;
1986:
1987: exception
1988: when others then

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

1985: end if;
1986:
1987: exception
1988: when others then
1989: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
1990: wf_core.context('WF_XML', 'EnqueueFullNotification', to_char(p_nid));
1991: raise;
1992: end EnqueueFullNotification;
1993:

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

2030: -- A valid role has been found for a notification
2031: -- that is required to go out.
2032:
2033: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.CALL);
2034: l_messageIdx := wf_temp_lob.getLob(g_LOBTable);
2035: -- Get an encoded payload.
2036: getShortLOBXMLMessage(p_nid, l_priority,
2037: g_LOBTable(l_messageIdx).temp_lob);
2038:

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

2047: p_correlation => wf_queue.account_name ||':'||
2048: to_char(p_nid),
2049: p_message => g_LOBTable(l_messageIdx).temp_lob);
2050: end if;
2051: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
2052:
2053: exception
2054: when others then
2055: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);

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

2051: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
2052:
2053: exception
2054: when others then
2055: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
2056: wf_core.context('WF_XML', 'EnqueueLOBNotification', to_char(p_nid));
2057: raise;
2058: end EnqueueLOBNotification;
2059:

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

2730: resourceList.DELETE;
2731:
2732: imagesFound := false;
2733:
2734: tmpIdx := wf_temp_lob.getLob(g_LOBTable);
2735: for url in g_urls(nid) loop
2736: value := url.text_value;
2737: value := wf_notification.SetFrameworkAgent(value);
2738:

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

2796: end if; -- Image TAG is in the messages body
2797: end if; -- The URL is an image reference
2798: end loop;
2799:
2800: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2801:
2802: return imagesFound;
2803: exception
2804: when others then

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

2802: return imagesFound;
2803: exception
2804: when others then
2805: -- Release temp LOB if any error , bug 6511028
2806: wf_temp_lob.releaseLob(g_LOBTable, tmpIdx);
2807:
2808: wf_core.context('WF_XML','ParseForInlineImages',to_char(nid));
2809: raise;
2810: end ParseForInlineImages;

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

3393: end if;
3394:
3395: -- If we are here, we are going to generate notification xml payload
3396: -- So allocate TEMP LOB now. << bug 6511028 >>
3397: messageIdx := wf_temp_lob.getLob(g_LOBTable);
3398:
3399: WF_MAIL.setContext(nid);
3400:
3401: -- Set the preferred document type based on the

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

4019: pos := SkipLOBTag(p_doc, 'CONTENT', pos, occurance);
4020: pos := SkipLOBTag(p_doc, 'NOTIFICATION', pos, occurance);
4021:
4022: p_pos := pos;
4023: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4024:
4025:
4026: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4027: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

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

4029: end if;
4030: exception
4031: when others then
4032:
4033: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4034:
4035: -- Since within wf_mail.getLOBMessage3 we are releasing
4036: -- TEMP LOBs incase of any exception, so there is no need to
4037: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)

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

4751: AddElementAttribute('content-type', docType, attrlist);
4752: if (l_lob = 'Y') then
4753:
4754: -- dbms_lob.createTemporary(message, TRUE, dbms_lob.CALL);
4755: messageIdx := wf_temp_lob.getLob(g_LOBTable);
4756: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
4757:
4758: -- << bug 6511028 >>
4759: -- This getBodyPart API also releases temp lob allocated within

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

4764:
4765: pos := NewLOBTag(p_doc, pos, 'MESSAGE',
4766: g_LOBTable(messageIdx).temp_lob, attrlist);
4767: -- release Temp lob to pool.
4768: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4769:
4770: else
4771:
4772: msgbody := '';

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

4810:
4811: exception
4812: when others then
4813: if (messageIdx > 0) then
4814: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4815: end if;
4816:
4817: -- Reset base NLS Context in case of any EXCEPTION
4818: WF_NOTIFICATION_UTIL.SetNLSContext(