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 DBMS_LOB

Line 419: -- dbms_lob.createTemporary(l_temp, TRUE, dbms_lob.CALL);

415: begin
416:
417: -- Create an instance of the node
418: -- A Node is deemed to be Data
419: -- dbms_lob.createTemporary(l_temp, TRUE, dbms_lob.CALL);
420: l_tempIdx := -1;
421:
422: l_start := '<' || upper(p_tag);
423:

Line 441: l_size := dbms_lob.getlength(p_doc);

437: -- Create the end TAG.
438: l_end := ''||g_newLine;
439:
440:
441: l_size := dbms_lob.getlength(p_doc);
442:
443: -- Create the full node to be inserted.
444: l_node := l_start || p_data || l_end;
445: l_nodesize := length(l_node);

Line 452: dbms_lob.read(lob_loc => p_doc,

448: if l_size > 1 and l_size <> p_pos then
449: -- Copy the tail end of the LOB to a holder.
450: l_amount := l_size - p_pos;
451: if l_amount < 32000 then
452: dbms_lob.read(lob_loc => p_doc,
453: amount => l_amount,
454: offset => p_pos + 1,
455: buffer => l_tempStr);
456: else

Line 458: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,

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,
462: src_offset => p_pos +1);

Line 467: dbms_lob.Write(p_doc, l_nodesize, p_pos + 1 , l_node);

463: end if;
464: end if;
465:
466: -- Now insert the new node into the p_pos location
467: dbms_lob.Write(p_doc, l_nodesize, p_pos + 1 , l_node);
468:
469: -- Append the saved portion of the LOB
470: -- If l_tempIdx is still -1, then no LOB was used or initialised
471: -- but for the lob, makesure that there is something in it to be

Line 474: dbms_lob.write(lob_loc => p_doc,

470: -- If l_tempIdx is still -1, then no LOB was used or initialised
471: -- but for the lob, makesure that there is something in it to be
472: -- used (l_amount > 0).
473: if l_tempIdx = -1 and l_amount > 0 then
474: dbms_lob.write(lob_loc => p_doc,
475: amount => l_amount,
476: offset => p_pos + l_nodesize + 1,
477: buffer => l_tempStr);
478: elsif l_amount > 0 then

Line 479: dbms_lob.copy(dest_lob => p_doc,

475: amount => l_amount,
476: offset => p_pos + l_nodesize + 1,
477: buffer => l_tempStr);
478: elsif l_amount > 0 then
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);

Line 488: -- dbms_lob.FreeTemporary(l_temp);

484: end if;
485:
486: l_pos := (p_pos + l_nodesize) - length(l_end);
487: -- Free up the use of the temporary LOB
488: -- dbms_lob.FreeTemporary(l_temp);
489:
490: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
491: wf_log_pkg.string(WF_LOG_PKG.level_statement,
492: 'wf.plsql.WF_XML.newLOBTag',

Line 560: l_size := dbms_lob.getlength(p_doc);

556:
557: -- Create the end TAG.
558: l_end := ''||g_newLine;
559:
560: l_size := dbms_lob.getlength(p_doc);
561: l_dataSize := dbms_lob.getlength(p_data);
562:
563: -- Create the full node to be inserted.
564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),

Line 561: l_dataSize := dbms_lob.getlength(p_data);

557: -- Create the end TAG.
558: l_end := ''||g_newLine;
559:
560: l_size := dbms_lob.getlength(p_doc);
561: l_dataSize := dbms_lob.getlength(p_data);
562:
563: -- Create the full node to be inserted.
564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),
565: l_start);

Line 564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),

560: l_size := dbms_lob.getlength(p_doc);
561: l_dataSize := dbms_lob.getlength(p_data);
562:
563: -- Create the full node to be inserted.
564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),
565: l_start);
566: l_nodesize := length(l_start); -- dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);
567: dbms_lob.copy(dest_lob => g_LOBTable(l_nodeIdx).temp_lob,
568: src_lob => p_data,

Line 566: l_nodesize := length(l_start); -- dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);

562:
563: -- Create the full node to be inserted.
564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),
565: l_start);
566: l_nodesize := length(l_start); -- dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);
567: dbms_lob.copy(dest_lob => g_LOBTable(l_nodeIdx).temp_lob,
568: src_lob => p_data,
569: amount => l_dataSize,
570: dest_offset => l_nodesize+1,

Line 567: dbms_lob.copy(dest_lob => g_LOBTable(l_nodeIdx).temp_lob,

563: -- Create the full node to be inserted.
564: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_start),
565: l_start);
566: l_nodesize := length(l_start); -- dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);
567: dbms_lob.copy(dest_lob => g_LOBTable(l_nodeIdx).temp_lob,
568: src_lob => p_data,
569: amount => l_dataSize,
570: dest_offset => l_nodesize+1,
571: src_offset => 1);

Line 572: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_end),

568: src_lob => p_data,
569: amount => l_dataSize,
570: dest_offset => l_nodesize+1,
571: src_offset => 1);
572: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_end),
573: l_end);
574: l_nodesize := dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);
575:
576: l_amount := 0;

Line 574: l_nodesize := dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);

570: dest_offset => l_nodesize+1,
571: src_offset => 1);
572: dbms_lob.writeAppend(g_LOBTable(l_nodeIdx).temp_lob, length(l_end),
573: l_end);
574: l_nodesize := dbms_lob.getLength(g_LOBTable(l_nodeIdx).temp_lob);
575:
576: l_amount := 0;
577: if l_size > 1 and l_size <> p_pos then
578: l_amount := l_size - p_pos;

Line 581: dbms_lob.read(lob_loc => p_doc,

577: if l_size > 1 and l_size <> p_pos then
578: l_amount := l_size - p_pos;
579: -- Copy the tail end of the LOB to a holder.
580: if l_amount < 32000 then
581: dbms_lob.read(lob_loc => p_doc,
582: amount => l_amount,
583: offset => p_pos + 1,
584: buffer => l_tempStr);
585: else

Line 587: dbms_lob.copy(dest_lob => g_LOBTable(l_tempIdx).temp_lob,

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,
591: src_offset => p_pos +1);

Line 596: dbms_lob.copy(dest_lob => p_doc,

592: end if;
593: end if;
594:
595: -- Now insert the new node into the p_pos location
596: dbms_lob.copy(dest_lob => p_doc,
597: src_lob => g_LOBTable(l_nodeIdx).temp_lob,
598: amount => l_nodesize,
599: dest_offset => p_pos + 1);
600:

Line 603: dbms_lob.write(lob_loc => p_doc,

599: dest_offset => p_pos + 1);
600:
601: -- Append the saved portion of the LOB
602: if l_tempIdx = -1 and l_amount > 0 then
603: dbms_lob.write(lob_loc => p_doc,
604: amount => l_amount,
605: offset => p_pos + l_nodesize + 1,
606: buffer => l_tempStr);
607: elsif l_tempIdx > 0 then

Line 609: dbms_lob.copy(dest_lob => p_doc,

605: offset => p_pos + l_nodesize + 1,
606: buffer => l_tempStr);
607: elsif l_tempIdx > 0 then
608: if l_amount > 0 then
609: dbms_lob.copy(dest_lob => p_doc,
610: src_lob => g_LOBTable(l_tempIdx).temp_lob,
611: amount => l_amount,
612: dest_offset => p_pos + l_nodesize + 1);
613: end if;

Line 750: l_pos := dbms_lob.instr(p_doc, l_tag, p_offset, p_occurance);

746:
747: begin
748:
749: l_tag := '';
750: l_pos := dbms_lob.instr(p_doc, l_tag, p_offset, p_occurance);
751:
752: return l_pos + length(l_tag);
753:
754: exception

Line 829: l_startPos := dbms_lob.instr(p_doc, l_startTag, l_pos, l_occurance);

825: -- attributes set on the TAG.
826: l_startTag := '<'||upper(p_tag);
827: l_endTag := '';
828:
829: l_startPos := dbms_lob.instr(p_doc, l_startTag, l_pos, l_occurance);
830: l_startPos := dbms_lob.instr(p_doc, '>', l_startPos, l_occurance) + 1;
831:
832:
833: l_endPos := dbms_lob.instr(p_doc, l_endTag, l_startpos, l_occurance) - 1;

Line 830: l_startPos := dbms_lob.instr(p_doc, '>', l_startPos, l_occurance) + 1;

826: l_startTag := '<'||upper(p_tag);
827: l_endTag := '';
828:
829: l_startPos := dbms_lob.instr(p_doc, l_startTag, l_pos, l_occurance);
830: l_startPos := dbms_lob.instr(p_doc, '>', l_startPos, l_occurance) + 1;
831:
832:
833: l_endPos := dbms_lob.instr(p_doc, l_endTag, l_startpos, l_occurance) - 1;
834: l_length := l_endPos - l_startPos + 1;

Line 833: l_endPos := dbms_lob.instr(p_doc, l_endTag, l_startpos, l_occurance) - 1;

829: l_startPos := dbms_lob.instr(p_doc, l_startTag, l_pos, l_occurance);
830: l_startPos := dbms_lob.instr(p_doc, '>', l_startPos, l_occurance) + 1;
831:
832:
833: l_endPos := dbms_lob.instr(p_doc, l_endTag, l_startpos, l_occurance) - 1;
834: l_length := l_endPos - l_startPos + 1;
835:
836: dbms_lob.read(p_doc, l_length, l_startPos, l_value);
837:

Line 836: dbms_lob.read(p_doc, l_length, l_startPos, l_value);

832:
833: l_endPos := dbms_lob.instr(p_doc, l_endTag, l_startpos, l_occurance) - 1;
834: l_length := l_endPos - l_startPos + 1;
835:
836: dbms_lob.read(p_doc, l_length, l_startPos, l_value);
837:
838: -- Reposition the position pointer to after the end
839: -- of the current TAG set.
840: p_pos := l_endPos + length(l_endTag) + 1;

Line 936: -- dbms_lob.createTemporary(l_content, TRUE, dbms_lob.CALL);

932: l_attr_url varchar2(32000);
933:
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);

Line 940: dbms_lob.createTemporary(l_blob, TRUE, dbms_lob.CALL);

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
944: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);

Line 944: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);

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
944: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);
945: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
946:
947: wf_log_pkg.string(WF_LOG_PKG.level_statement,
948: 'wf.plsql.WF_XML.GetAttachment',

Line 1010: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);

1006: AddElementAttribute('content-disposition',p_disposition,
1007: l_attrlist);
1008: AddElementAttribute('filename', l_filename, l_attrlist);
1009: AddElementAttribute('encoding', l_encoding, l_attrlist);
1010: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1011: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1012: length(l_start), l_start);
1013: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1014: length(l_tmpContent),

Line 1011: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1007: l_attrlist);
1008: AddElementAttribute('filename', l_filename, l_attrlist);
1009: AddElementAttribute('encoding', l_encoding, l_attrlist);
1010: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1011: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1012: length(l_start), l_start);
1013: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1014: length(l_tmpContent),
1015: l_tmpContent);

Line 1013: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1009: AddElementAttribute('encoding', l_encoding, l_attrlist);
1010: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1011: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1012: length(l_start), l_start);
1013: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1014: length(l_tmpContent),
1015: l_tmpContent);
1016: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1017: length(l_end), l_end);

Line 1016: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1012: length(l_start), l_start);
1013: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1014: length(l_tmpContent),
1015: l_tmpContent);
1016: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1017: length(l_end), l_end);
1018:
1019: l_pos := NewLOBTag(p_doc, l_pos, 'MESSAGE',
1020: g_LOBTable(l_contentIdx).temp_lob,

Line 1028: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);

1024: elsif upper(substr(l_crec.url,1, 10)) = 'PLSQLCLOB:' then
1025: /*
1026: ** For PLSQLCLOB documents.
1027: */
1028: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1029: l_content_type := '';
1030:
1031: --
1032: -- Getting Content

Line 1103: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1099:
1100: -- Fetch the content
1101: WF_MAIL.InitFetchLOB(l_display_type, l_doc_length);
1102: l_doc_end := 0;
1103: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1104: length(l_start), l_start);
1105: while l_doc_end = 0 loop
1106: WF_MAIL.FetchLobContent(l_tmpContent, l_display_type,
1107: l_doc_end);

Line 1109: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1105: while l_doc_end = 0 loop
1106: WF_MAIL.FetchLobContent(l_tmpContent, l_display_type,
1107: l_doc_end);
1108: l_tmpContent := replace(l_tmpContent, g_fndapi_misschr);
1109: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1110: length(l_tmpContent), l_tmpContent);
1111: end loop;
1112:
1113:

Line 1114: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1110: length(l_tmpContent), l_tmpContent);
1111: end loop;
1112:
1113:
1114: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1115: length(l_end), l_end);
1116: --
1117: -- Build the attribute list for the attachment
1118: -- including the content-type, file name etc.

Line 1147: dbms_lob.trim(l_blob,0);

1143: elsif upper(substr(l_crec.url,1, 10)) = 'PLSQLBLOB:' then
1144: /*
1145: ** For PLSQLBLOB documents.
1146: */
1147: dbms_lob.trim(l_blob,0);
1148:
1149: --
1150: -- Getting Content
1151: -- First we call the existing APIs to render the

Line 1222: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);

1218: l_isURLAttrs := FALSE;
1219: end if;
1220:
1221: if l_isURLAttrs then
1222: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1223:
1224: wf_mail.GetURLAttachment(p_nid, l_tmpContent, l_error_result);
1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1226: length(l_start), l_start);

Line 1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1221: if l_isURLAttrs then
1222: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1223:
1224: wf_mail.GetURLAttachment(p_nid, l_tmpContent, l_error_result);
1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1226: length(l_start), l_start);
1227: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1228: length(l_tmpContent), l_tmpContent);
1229: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

Line 1227: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1223:
1224: wf_mail.GetURLAttachment(p_nid, l_tmpContent, l_error_result);
1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1226: length(l_start), l_start);
1227: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1228: length(l_tmpContent), l_tmpContent);
1229: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1230: length(l_end), l_end);
1231:

Line 1229: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,

1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1226: length(l_start), l_start);
1227: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1228: length(l_tmpContent), l_tmpContent);
1229: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1230: length(l_end), l_end);
1231:
1232:
1233: if l_error_result is not null or l_error_result <> '' then

Line 1450: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);

1446: end if;
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.

Line 1460: dbms_lob.write(g_LOBTable(l_docIdx).temp_lob, l_pos, 1, l_str);

1456: -- will be placed.
1457: l_str := '';
1458: l_pos := length(l_str);
1459:
1460: dbms_lob.write(g_LOBTable(l_docIdx).temp_lob, l_pos, 1, l_str);
1461:
1462: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos,
1463: 'NOTIFICATION','',l_attrlist);
1464:

Line 1574: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,

1570: null;
1571: end;
1572:
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:

Line 1575: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);

1571: end;
1572:
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

Line 1576: -- dbms_lob.freetemporary(l_doc).temp_lob);

1572:
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

Line 1631: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);

1627: -- Grab the details of the message to be enqueued using the
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.

Line 1641: dbms_lob.write(g_LOBTable(l_docIdx).temp_lob, l_pos, 1, l_str);

1637: -- will be placed.
1638: l_str := '';
1639: l_pos := length(l_str);
1640:
1641: dbms_lob.write(g_LOBTable(l_docIdx).temp_lob, l_pos, 1, l_str);
1642:
1643: l_pos := NewLOBTag(g_LOBTable(l_docIdx).temp_lob, l_pos,
1644: 'NOTIFICATION','',l_attrlist);
1645:

Line 1685: dbms_lob.copy(p_message, g_LOBTable(l_docIdx).temp_lob,

1681: l_pos := SkipLOBTag(g_LOBTable(l_docIdx).temp_lob,
1682: 'STATUS', l_pos, l_occurance);
1683:
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:

Line 1686: dbms_lob.getLength(g_LOBTable(l_docIdx).temp_lob), 1, 1);

1682: 'STATUS', l_pos, l_occurance);
1683:
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

Line 1687: -- dbms_lob.freetemporary(g_LOBTable(l_docIdx).temp_lob);

1683:
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

Line 1853: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.SESSION);

1849: if l_recipient_list.COUNT > 0 then
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',

Line 1912: -- dbms_lob.freetemporary(l_message);

1908: l_ntf_pref := l_recipient_list(i).notification_preference;
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

Line 1962: -- dbms_lob.createTemporary(l_message, TRUE, dbms_lob.CALL);

1958: if l_recipient_role is not null then
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);

Line 2534: dbms_lob.writeAppend(p_doc, length(l_start), l_start);

2530: begin
2531:
2532: WF_MAIL.InitFetchLOB(p_doctype, l_doc_length);
2533: l_doc_end := 0;
2534: dbms_lob.writeAppend(p_doc, length(l_start), l_start);
2535: while l_doc_end = 0 loop
2536: WF_MAIL.FetchLobContent(l_message, p_doctype, l_doc_end);
2537: l_message := replace(l_message, g_fndapi_misschr);
2538: dbms_lob.writeAppend(p_doc, length(l_message), l_message);

Line 2538: dbms_lob.writeAppend(p_doc, length(l_message), l_message);

2534: dbms_lob.writeAppend(p_doc, length(l_start), l_start);
2535: while l_doc_end = 0 loop
2536: WF_MAIL.FetchLobContent(l_message, p_doctype, l_doc_end);
2537: l_message := replace(l_message, g_fndapi_misschr);
2538: dbms_lob.writeAppend(p_doc, length(l_message), l_message);
2539: end loop;
2540:
2541: -- bug 8515763:
2542: -- Adding PostScript message for Hotmail and Yahoo users here

Line 2547: dbms_lob.writeAppend(p_doc,length(g_newLine), g_newLine);

2543: -- because if we want to add within WF_MAIL.GetMessageLob3 then new global
2544: -- variable or API have to introduce to communicate from one pkg to another pkg.
2545: if( g_WebMail_PostScript_Msg is not null ) then
2546:
2547: dbms_lob.writeAppend(p_doc,length(g_newLine), g_newLine);
2548: dbms_lob.writeAppend(p_doc, length(g_WebMail_PostScript_Msg),
2549: g_WebMail_PostScript_Msg);
2550:
2551: -- Nullify so that for MAILATTH users, this message should NOT apear in html BODY.

Line 2548: dbms_lob.writeAppend(p_doc, length(g_WebMail_PostScript_Msg),

2544: -- variable or API have to introduce to communicate from one pkg to another pkg.
2545: if( g_WebMail_PostScript_Msg is not null ) then
2546:
2547: dbms_lob.writeAppend(p_doc,length(g_newLine), g_newLine);
2548: dbms_lob.writeAppend(p_doc, length(g_WebMail_PostScript_Msg),
2549: g_WebMail_PostScript_Msg);
2550:
2551: -- Nullify so that for MAILATTH users, this message should NOT apear in html BODY.
2552: g_WebMail_PostScript_Msg := null;

Line 2555: dbms_lob.writeAppend(p_doc, length(l_end), l_end);

2551: -- Nullify so that for MAILATTH users, this message should NOT apear in html BODY.
2552: g_WebMail_PostScript_Msg := null;
2553: end if;
2554:
2555: dbms_lob.writeAppend(p_doc, length(l_end), l_end);
2556: WF_MAIL.CloseLob(p_doctype);
2557:
2558: exception
2559: when others then

Line 2696: imgStrPos := dbms_lob.instr(msgBody, value, 1, 1);

2692: if isImageReference(value, renderType) then
2693: origValue := value;
2694: value := ' '|| url.display_name||' ';
2696: imgStrPos := dbms_lob.instr(msgBody, value, 1, 1);
2697: if imgStrPos > 0 then
2698: dbms_lob.trim(g_LOBTable(tmpIdx).temp_lob, 0);
2699: dbms_lob.copy(g_LOBTable(tmpIdx).temp_lob , msgBody,
2700: imgStrPos-1, 1, 1);

Line 2698: dbms_lob.trim(g_LOBTable(tmpIdx).temp_lob, 0);

2694: value := ' '|| url.display_name||' ';
2696: imgStrPos := dbms_lob.instr(msgBody, value, 1, 1);
2697: if imgStrPos > 0 then
2698: dbms_lob.trim(g_LOBTable(tmpIdx).temp_lob, 0);
2699: dbms_lob.copy(g_LOBTable(tmpIdx).temp_lob , msgBody,
2700: imgStrPos-1, 1, 1);
2701:
2702: nameStart := instrb(origValue, '/', -1, 1);

Line 2699: dbms_lob.copy(g_LOBTable(tmpIdx).temp_lob , msgBody,

2695: '" alt="'|| url.display_name||'">';
2696: imgStrPos := dbms_lob.instr(msgBody, value, 1, 1);
2697: if imgStrPos > 0 then
2698: dbms_lob.trim(g_LOBTable(tmpIdx).temp_lob, 0);
2699: dbms_lob.copy(g_LOBTable(tmpIdx).temp_lob , msgBody,
2700: imgStrPos-1, 1, 1);
2701:
2702: nameStart := instrb(origValue, '/', -1, 1);
2703: if nameStart = 0 then

Line 2725: dbms_lob.writeAppend(g_LOBTable(tmpIdx).temp_lob,

2721: newValue := ' '|| url.display_name||<br>
2723: ' ';
2724:
2725: dbms_lob.writeAppend(g_LOBTable(tmpIdx).temp_lob,
2726: length(newValue), newValue);
2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);
2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,

Line 2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);

2723: '">';
2724:
2725: dbms_lob.writeAppend(g_LOBTable(tmpIdx).temp_lob,
2726: length(newValue), newValue);
2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);
2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,
2730: tmpLength+1, imgStrPos+length(value));
2731: dbms_lob.trim(msgBody, 0);

Line 2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);

2724:
2725: dbms_lob.writeAppend(g_LOBTable(tmpIdx).temp_lob,
2726: length(newValue), newValue);
2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);
2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,
2730: tmpLength+1, imgStrPos+length(value));
2731: dbms_lob.trim(msgBody, 0);
2732: dbms_lob.append(msgBody, g_LOBTable(tmpIdx).temp_lob);

Line 2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,

2725: dbms_lob.writeAppend(g_LOBTable(tmpIdx).temp_lob,
2726: length(newValue), newValue);
2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);
2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,
2730: tmpLength+1, imgStrPos+length(value));
2731: dbms_lob.trim(msgBody, 0);
2732: dbms_lob.append(msgBody, g_LOBTable(tmpIdx).temp_lob);
2733:

Line 2731: dbms_lob.trim(msgBody, 0);

2727: amount := dbms_lob.getlength(msgBody)-imgStrPos+length(value);
2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,
2730: tmpLength+1, imgStrPos+length(value));
2731: dbms_lob.trim(msgBody, 0);
2732: dbms_lob.append(msgBody, g_LOBTable(tmpIdx).temp_lob);
2733:
2734: imagesFound := TRUE;
2735: resourceList(resourceIdx).value := origValue;

Line 2732: dbms_lob.append(msgBody, g_LOBTable(tmpIdx).temp_lob);

2728: tmpLength := dbms_lob.getlength(g_LOBTable(tmpIdx).temp_lob);
2729: dbms_lob.Copy(g_LOBTable(tmpIdx).temp_lob, msgBody, amount,
2730: tmpLength+1, imgStrPos+length(value));
2731: dbms_lob.trim(msgBody, 0);
2732: dbms_lob.append(msgBody, g_LOBTable(tmpIdx).temp_lob);
2733:
2734: imagesFound := TRUE;
2735: resourceList(resourceIdx).value := origValue;
2736: resourceList(resourceIdx).contentId := contentId;

Line 3052: dbms_lob.write(p_doc, l_pos, 1, str);

3048: -- <>: Not changing default Lang. territory settings:
3049: if p_group then
3050: str := '';
3051: l_pos := length(str);
3052: dbms_lob.write(p_doc, l_pos, 1, str);
3053: AddElementAttribute('maxcount','1', l_attrlist);
3054: l_pos := NewLOBTag(p_doc, l_pos, 'NOTIFICATIONGROUP', '', l_attrlist);
3055: l_attrlist.DELETE;
3056: end if;

Line 3682: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);

3678: ** MAILTEXT and MAILATTH will have the text/plain as the
3679: ** primary messasge content. The others will be in the
3680: ** from of an attachment.
3681: */
3682: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
3683:
3684: -- This getBodyPart API releases temp lob allocated within
3685: -- WF_MAIL.GetLobMessage4 for doctype (text/plain )
3686: -- i.e. g_text_messageIdx locator

Line 3763: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);

3759: -- MAILHTML2 is a text/html message without the additional
3760: -- two framed "Notification Detail.html" attachment, but other attachement
3761: -- may be available.
3762: --
3763: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
3764:
3765: -- This getBodyPart API releases temp lob allocated within
3766: -- WF_MAIL.GetLobMessage4 for doctype (text/html )
3767: -- i.e. g_html_messageIdx locator

Line 4281: dbms_lob.write(p_doc, pos, 1, str);

4277: if notification_pref not in ('QUERY','SUMMARY','SUMHTML',
4278: 'DISABLED') then
4279: str := '';
4280: pos := length(str);
4281: dbms_lob.write(p_doc, pos, 1, str);
4282:
4283: -- 4628088 Send the RESET_NLS flag if one is defined
4284: -- at the message level.
4285: resetNls := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,

Line 4320: dbms_lob.write(p_doc, pos, 1, str);

4316: -- being generated to go to the system admin and the
4317: -- error process to be called.
4318: str := '';
4319: pos := length(str);
4320: dbms_lob.write(p_doc, pos, 1, str);
4321: generateGroupDoc(p_doc, pos, recipient_role, notification_pref,
4322: orig_system, orig_system_id,
4323: p_event_name, p_event_key, p_parameter_list);
4324: end if;

Line 4664: -- dbms_lob.createTemporary(message, TRUE, dbms_lob.CALL);

4660: -- preferred output.
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 >>

Line 4666: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);

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
4670: -- WF_MAIL.GetSummary2 for doctype (text/plain )

Line 4871: dbms_lob.write(p_doc, pos, 1, str);

4867: -- l_pos is crucial as it determines where the next nodes
4868: -- will be placed.
4869: str := '';
4870: pos := length(str);
4871: dbms_lob.write(p_doc, pos, 1, str);
4872:
4873: -- Obtain recipient information
4874: WF_DIRECTORY.GetRoleInfoMail(recipient_role, display_name, email,
4875: notification_pref,

Line 4938: dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.call);

4934: 'wf.plsql.WF_XML.generate', 'BEGIN');
4935: end if;
4936: -- We do not use the LOB pooling for the generate as the LOB
4937: -- is to be returned and not reused.
4938: dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.call);
4939:
4940: BEGIN
4941:
4942: -- <>:

Line 6261: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="Y"', 1, 1);

6257: -- we should enqueue the notification to WF_NOTIFICATION_OUT queue
6258: -- so that email notification will be sent to the users having the
6259: -- full-document="Y" value
6260:
6261: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="Y"', 1, 1);
6262:
6263: -- If string not found checking for the lower case letter
6264: if( l_fulldocloc <= 0) then
6265: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="y"', 1, 1);

Line 6265: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="y"', 1, 1);

6261: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="Y"', 1, 1);
6262:
6263: -- If string not found checking for the lower case letter
6264: if( l_fulldocloc <= 0) then
6265: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="y"', 1, 1);
6266: end if;
6267:
6268: if (l_fulldocloc > 0) then
6269: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then