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_EVENT_SYNCHRONIZE_PKG dependencies on DBMS_LOB

Line 36: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

32: l_clob clob;
33: l_result varchar2(100);
34: begin
35:
36: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
37: wf_event_synchronize_pkg.CreateSyncClob(p_eventdata => l_clob);
38:
39: p_event.SetEventData(l_clob);
40:

Line 117: dbms_lob.createtemporary(p_eventdata, FALSE, DBMS_LOB.CALL);

113: IF p_ObjectKey IS NOT NULL THEN
114: l_ObjectKey := '%'||p_ObjectKey||'%';
115: END IF;
116:
117: dbms_lob.createtemporary(p_eventdata, FALSE, DBMS_LOB.CALL);
118:
119: dbms_lob.writeappend(p_eventdata, length(g_begin_clob), g_begin_clob);
120:
121: --

Line 119: dbms_lob.writeappend(p_eventdata, length(g_begin_clob), g_begin_clob);

115: END IF;
116:
117: dbms_lob.createtemporary(p_eventdata, FALSE, DBMS_LOB.CALL);
118:
119: dbms_lob.writeappend(p_eventdata, length(g_begin_clob), g_begin_clob);
120:
121: --
122: -- Might have to change these to constants for MLS
123: --

Line 128: dbms_lob.append(p_eventdata,

124: -- Bug 2558446: Events, Subscriptions and Agents/Systems downloaded in separate
125: -- Files.
126: IF g_objecttype in ('SYSTEMS', 'AGENTS', 'AGENTGROUPS') THEN
127: -- Systems, Agents, Agent Groups in one file
128: dbms_lob.append(p_eventdata,
129: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
130: dbms_lob.append(p_eventdata,
131: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
132: dbms_lob.append(p_eventdata,

Line 130: dbms_lob.append(p_eventdata,

126: IF g_objecttype in ('SYSTEMS', 'AGENTS', 'AGENTGROUPS') THEN
127: -- Systems, Agents, Agent Groups in one file
128: dbms_lob.append(p_eventdata,
129: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
130: dbms_lob.append(p_eventdata,
131: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
132: dbms_lob.append(p_eventdata,
133: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
134: ELSIF g_objecttype = 'EVENTS' THEN

Line 132: dbms_lob.append(p_eventdata,

128: dbms_lob.append(p_eventdata,
129: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
130: dbms_lob.append(p_eventdata,
131: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
132: dbms_lob.append(p_eventdata,
133: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
134: ELSIF g_objecttype = 'EVENTS' THEN
135: -- Download event and event groups
136: dbms_lob.append(p_eventdata,

Line 136: dbms_lob.append(p_eventdata,

132: dbms_lob.append(p_eventdata,
133: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
134: ELSIF g_objecttype = 'EVENTS' THEN
135: -- Download event and event groups
136: dbms_lob.append(p_eventdata,
137: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
138:
139: dbms_lob.append(p_eventdata,
140: wf_event_synchronize_pkg.GetEventGroups(

Line 139: dbms_lob.append(p_eventdata,

135: -- Download event and event groups
136: dbms_lob.append(p_eventdata,
137: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
138:
139: dbms_lob.append(p_eventdata,
140: wf_event_synchronize_pkg.GetEventGroups(
141: l_ObjectKey,p_ownertag));
142: ELSIF g_objecttype = 'EVENT_GROUPS' THEN
143: -- Download event groups

Line 144: dbms_lob.append(p_eventdata,

140: wf_event_synchronize_pkg.GetEventGroups(
141: l_ObjectKey,p_ownertag));
142: ELSIF g_objecttype = 'EVENT_GROUPS' THEN
143: -- Download event groups
144: dbms_lob.append(p_eventdata,
145: wf_event_synchronize_pkg.GetGroups(l_ObjectKey, p_ownertag));
146:
147: -- EVENT_GROUPS option now downloads only GROUP type objects. Not members
148: -- dbms_lob.append(p_eventdata,

Line 148: -- dbms_lob.append(p_eventdata,

144: dbms_lob.append(p_eventdata,
145: wf_event_synchronize_pkg.GetGroups(l_ObjectKey, p_ownertag));
146:
147: -- EVENT_GROUPS option now downloads only GROUP type objects. Not members
148: -- dbms_lob.append(p_eventdata,
149: -- wf_event_synchronize_pkg.GetEventGroupByGroup(l_ObjectKey,p_ownertag));
150: ELSIF g_objecttype = 'SUBSCRIPTIONS' THEN
151: -- Download subscriptions in one file
152: dbms_lob.append(p_eventdata,

Line 152: dbms_lob.append(p_eventdata,

148: -- dbms_lob.append(p_eventdata,
149: -- wf_event_synchronize_pkg.GetEventGroupByGroup(l_ObjectKey,p_ownertag));
150: ELSIF g_objecttype = 'SUBSCRIPTIONS' THEN
151: -- Download subscriptions in one file
152: dbms_lob.append(p_eventdata,
153: wf_event_synchronize_pkg.GetSubscriptions(l_ObjectKey,
154: p_isexact, p_ownertag));
155:
156: ELSE -- including ALL

Line 158: dbms_lob.append(p_eventdata,

154: p_isexact, p_ownertag));
155:
156: ELSE -- including ALL
157:
158: dbms_lob.append(p_eventdata,
159: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
160: dbms_lob.append(p_eventdata,
161: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
162: dbms_lob.append(p_eventdata,

Line 160: dbms_lob.append(p_eventdata,

156: ELSE -- including ALL
157:
158: dbms_lob.append(p_eventdata,
159: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
160: dbms_lob.append(p_eventdata,
161: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
162: dbms_lob.append(p_eventdata,
163: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
164: dbms_lob.append(p_eventdata,

Line 162: dbms_lob.append(p_eventdata,

158: dbms_lob.append(p_eventdata,
159: wf_event_synchronize_pkg.GetSystems(l_ObjectKey));
160: dbms_lob.append(p_eventdata,
161: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
162: dbms_lob.append(p_eventdata,
163: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
164: dbms_lob.append(p_eventdata,
165: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
166: dbms_lob.append(p_eventdata,

Line 164: dbms_lob.append(p_eventdata,

160: dbms_lob.append(p_eventdata,
161: wf_event_synchronize_pkg.GetAgents(l_ObjectKey,p_isexact));
162: dbms_lob.append(p_eventdata,
163: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
164: dbms_lob.append(p_eventdata,
165: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
166: dbms_lob.append(p_eventdata,
167: wf_event_synchronize_pkg.GetSubscriptions(l_ObjectKey,p_isexact, p_ownertag));
168: dbms_lob.append(p_eventdata,

Line 166: dbms_lob.append(p_eventdata,

162: dbms_lob.append(p_eventdata,
163: wf_event_synchronize_pkg.GetAgentGroups(l_ObjectKey));
164: dbms_lob.append(p_eventdata,
165: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
166: dbms_lob.append(p_eventdata,
167: wf_event_synchronize_pkg.GetSubscriptions(l_ObjectKey,p_isexact, p_ownertag));
168: dbms_lob.append(p_eventdata,
169: wf_event_synchronize_pkg.GetEventGroups(l_ObjectKey, p_ownertag));
170:

Line 168: dbms_lob.append(p_eventdata,

164: dbms_lob.append(p_eventdata,
165: wf_event_synchronize_pkg.GetEvents(l_ObjectKey, p_ownertag));
166: dbms_lob.append(p_eventdata,
167: wf_event_synchronize_pkg.GetSubscriptions(l_ObjectKey,p_isexact, p_ownertag));
168: dbms_lob.append(p_eventdata,
169: wf_event_synchronize_pkg.GetEventGroups(l_ObjectKey, p_ownertag));
170:
171: END IF;
172:

Line 173: dbms_lob.writeappend(p_eventdata, length(g_end_clob), g_end_clob);

169: wf_event_synchronize_pkg.GetEventGroups(l_ObjectKey, p_ownertag));
170:
171: END IF;
172:
173: dbms_lob.writeappend(p_eventdata, length(g_end_clob), g_end_clob);
174:
175: --return (syncclob);
176:
177: exception

Line 217: dbms_lob.createtemporary( l_clob, FALSE, DBMS_LOB.CALL);

213: else
214: l_isExactNum := 0;
215: end if;
216:
217: dbms_lob.createtemporary( l_clob, FALSE, DBMS_LOB.CALL);
218:
219: wf_event_synchronize_pkg.CreateSyncClob(p_ObjectType, p_ObjectKey, l_isExactNum, null, l_clob);
220:
221: if (dbms_lob.getlength(l_clob) = 0) then

Line 221: if (dbms_lob.getlength(l_clob) = 0) then

217: dbms_lob.createtemporary( l_clob, FALSE, DBMS_LOB.CALL);
218:
219: wf_event_synchronize_pkg.CreateSyncClob(p_ObjectType, p_ObjectKey, l_isExactNum, null, l_clob);
220:
221: if (dbms_lob.getlength(l_clob) = 0) then
222: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
223: wf_log_pkg.string(wf_log_pkg.level_statement,
224: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEFILE.Clob_Size',
225: 'l_clob null');

Line 296: l_begin_position := dbms_lob.instr(p_clob, g_begin_string,

292: -- are none
293: --
294: l_counter := l_counter + 1;
295:
296: l_begin_position := dbms_lob.instr(p_clob, g_begin_string,
297: 1, l_counter);
298:
299: EXIT when l_begin_position = 0; -- No More Event Objects left
300:

Line 301: l_end_position := dbms_lob.instr(p_clob , g_end_string,

297: 1, l_counter);
298:
299: EXIT when l_begin_position = 0; -- No More Event Objects left
300:
301: l_end_position := dbms_lob.instr(p_clob , g_end_string,
302: 1, l_counter);
303:
304: --
305: -- Figure out the amount to read out of the CLOB, and subst

Line 311: l_messagedata := dbms_lob.substr(p_clob, l_amount_to_read,

307: l_end_position := l_end_position + l_length_end_string;
308:
309: l_amount_to_read := l_end_position - l_begin_position;
310:
311: l_messagedata := dbms_lob.substr(p_clob, l_amount_to_read,
312: l_begin_position);
313:
314: utl_file.putf(l_filehandle, l_messagedata);
315:

Line 323: l_messagedata := dbms_lob.substr(p_clob, l_splice_size,

319:
320: /**
321: LOOP
322:
323: l_messagedata := dbms_lob.substr(p_clob, l_splice_size,
324: l_current_position);
325:
326: utl_file.putf(l_filehandle, l_messagedata);
327:

Line 382: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

378: end if;
379:
380: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'r');
381:
382: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
383:
384: LOOP
385: begin
386: dbms_lob.createtemporary( l_workingclob, FALSE, DBMS_LOB.CALL);

Line 386: dbms_lob.createtemporary( l_workingclob, FALSE, DBMS_LOB.CALL);

382: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
383:
384: LOOP
385: begin
386: dbms_lob.createtemporary( l_workingclob, FALSE, DBMS_LOB.CALL);
387:
388: utl_file.get_line(l_filehandle, l_buffer);
389:
390: if length(l_buffer) > 0 then

Line 391: dbms_lob.write(l_workingclob, length(l_buffer), 1, l_buffer);

387:
388: utl_file.get_line(l_filehandle, l_buffer);
389:
390: if length(l_buffer) > 0 then
391: dbms_lob.write(l_workingclob, length(l_buffer), 1, l_buffer);
392: dbms_lob.append(l_clob,l_workingclob);
393: end if;
394:
395: l_workingclob := null;

Line 392: dbms_lob.append(l_clob,l_workingclob);

388: utl_file.get_line(l_filehandle, l_buffer);
389:
390: if length(l_buffer) > 0 then
391: dbms_lob.write(l_workingclob, length(l_buffer), 1, l_buffer);
392: dbms_lob.append(l_clob,l_workingclob);
393: end if;
394:
395: l_workingclob := null;
396: l_buffer := '';

Line 480: l_begin_position := dbms_lob.instr(p_eventdata, g_begin_string,

476: -- are none
477: --
478: l_counter := l_counter + 1;
479:
480: l_begin_position := dbms_lob.instr(p_eventdata, g_begin_string,
481: 1, l_counter);
482:
483: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
484: -- This is for logging only

Line 493: l_end_position := dbms_lob.instr(p_eventdata, g_end_string,

489: end if;
490:
491: EXIT when l_begin_position = 0; -- No More Event Objects left
492:
493: l_end_position := dbms_lob.instr(p_eventdata, g_end_string,
494: 1, l_counter);
495:
496: --
497: -- Figure out the amount to read out of the CLOB, and subst

Line 503: l_messagedata := dbms_lob.substr(p_eventdata, l_amount_to_read,

499: l_end_position := l_end_position + l_length_end_string;
500:
501: l_amount_to_read := l_end_position - l_begin_position;
502:
503: l_messagedata := dbms_lob.substr(p_eventdata, l_amount_to_read,
504: l_begin_position);
505:
506: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
507: wf_log_pkg.string(wf_log_pkg.level_statement,

Line 552: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

548: where name like nvl(p_key,'%');
549:
550: begin
551:
552: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
553:
554: FOR g IN systems LOOP
555:
556: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

Line 556: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

552: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
553:
554: FOR g IN systems LOOP
555:
556: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
557:
558: -- Get our XML document
559: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.system.update', g.guid);
560:

Line 562: dbms_lob.append(returnclob, l_clob);

558: -- Get our XML document
559: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.system.update', g.guid);
560:
561: -- Add this to our return CLOB
562: dbms_lob.append(returnclob, l_clob);
563:
564: -- Kill the Loop CLOB
565: l_clob := null;
566:

Line 619: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

615: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETAGENTS.Begin',
616: 'Entered GetAgents');
617: end if;
618:
619: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
620:
621: FOR g IN agents(l_guid) LOOP
622:
623: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

Line 623: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

619: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
620:
621: FOR g IN agents(l_guid) LOOP
622:
623: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
624:
625: -- Get our XML document
626: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agent.update', g.guid);
627:

Line 635: l_clob_len := dbms_lob.getlength(l_clob);

631: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETAGENTS.set_pound',
632: 'Substitute with pounds.');
633: end if;
634:
635: l_clob_len := dbms_lob.getlength(l_clob);
636: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);
637:
638: -- # replacement in , , and

field
639: l_tmpStr := SetPound(1,l_tmpStr,'','','NEW',null);

Line 636: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);

632: 'Substitute with pounds.');
633: end if;
634:
635: l_clob_len := dbms_lob.getlength(l_clob);
636: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);
637:
638: -- # replacement in , , and

field
639: l_tmpStr := SetPound(1,l_tmpStr,'','','NEW',null);
640: l_tmpStr := SetPound(1,l_tmpStr,'','','LOCAL',null);

Line 647: dbms_lob.erase(l_clob, l_clob_len, 1);

643: l_tmpStr := SetPound(l_searchPos,l_tmpStr,'@','

','SID',null);
644: l_tmpStr := SetPound(1,l_tmpStr,'','.','OWNER',null);
645: l_tmpStrLen := length(l_tmpStr);
646:
647: dbms_lob.erase(l_clob, l_clob_len, 1);
648: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
649: end if;
650:
651: -- Add this to our return CLOB

Line 648: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);

644: l_tmpStr := SetPound(1,l_tmpStr,'','.','OWNER',null);
645: l_tmpStrLen := length(l_tmpStr);
646:
647: dbms_lob.erase(l_clob, l_clob_len, 1);
648: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
649: end if;
650:
651: -- Add this to our return CLOB
652: dbms_lob.append(returnclob, l_clob);

Line 652: dbms_lob.append(returnclob, l_clob);

648: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
649: end if;
650:
651: -- Add this to our return CLOB
652: dbms_lob.append(returnclob, l_clob);
653:
654: -- Kill the Loop CLOB
655: l_clob := null;
656:

Line 696: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

692: );*/
693:
694: begin
695:
696: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
697:
698: FOR g IN agent_groups LOOP
699:
700: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

Line 700: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

696: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
697:
698: FOR g IN agent_groups LOOP
699:
700: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
701:
702: -- Get our XML document
703: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agentgroup.update', g.guid);
704:

Line 706: dbms_lob.append(returnclob, l_clob);

702: -- Get our XML document
703: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.agentgroup.update', g.guid);
704:
705: -- Add this to our return CLOB
706: dbms_lob.append(returnclob, l_clob);
707:
708: -- Kill the Loop CLOB
709: l_clob := null;
710:

Line 751: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

747: and owner_tag like nvl(p_ownertag, '%');
748:
749: begin
750:
751: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
752: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
753:
754: if (p_key is not null OR p_key <> '') then
755:

Line 752: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

748:
749: begin
750:
751: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
752: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
753:
754: if (p_key is not null OR p_key <> '') then
755:
756: FOR g IN events LOOP

Line 760: dbms_lob.append(returnclob, l_clob);

756: FOR g IN events LOOP
757: -- Get our XML document
758: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
759: -- Add this to our return CLOB
760: dbms_lob.append(returnclob, l_clob);
761: -- Kill the Loop CLOB
762: dbms_lob.trim(l_clob, 0);
763: END LOOP;
764:

Line 762: dbms_lob.trim(l_clob, 0);

758: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
759: -- Add this to our return CLOB
760: dbms_lob.append(returnclob, l_clob);
761: -- Kill the Loop CLOB
762: dbms_lob.trim(l_clob, 0);
763: END LOOP;
764:
765: else
766:

Line 771: dbms_lob.append(returnclob, l_clob);

767: FOR g IN events_all LOOP
768: -- Get our XML document
769: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
770: -- Add this to our return CLOB
771: dbms_lob.append(returnclob, l_clob);
772: -- Kill the Loop CLOB
773: dbms_lob.trim(l_clob, 0);
774: END LOOP;
775:

Line 773: dbms_lob.trim(l_clob, 0);

769: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
770: -- Add this to our return CLOB
771: dbms_lob.append(returnclob, l_clob);
772: -- Kill the Loop CLOB
773: dbms_lob.trim(l_clob, 0);
774: END LOOP;
775:
776: end if;
777:

Line 820: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

816: order by e.name;
817:
818: begin
819:
820: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
821: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
822:
823: if (p_key is not null OR p_key <> '') then
824:

Line 821: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

817:
818: begin
819:
820: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
821: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
822:
823: if (p_key is not null OR p_key <> '') then
824:
825: FOR g IN event_groups LOOP

Line 829: dbms_lob.append(returnclob, l_clob);

825: FOR g IN event_groups LOOP
826: -- Get our XML document
827: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
828: -- Add this to our return CLOB
829: dbms_lob.append(returnclob, l_clob);
830: -- Kill the Loop CLOB
831: dbms_lob.trim(l_clob, 0);
832: END LOOP;
833:

Line 831: dbms_lob.trim(l_clob, 0);

827: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
828: -- Add this to our return CLOB
829: dbms_lob.append(returnclob, l_clob);
830: -- Kill the Loop CLOB
831: dbms_lob.trim(l_clob, 0);
832: END LOOP;
833:
834: else
835:

Line 840: dbms_lob.append(returnclob, l_clob);

836: FOR g IN event_groups_all LOOP
837: -- Get our XML document
838: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
839: -- Add this to our return CLOB
840: dbms_lob.append(returnclob, l_clob);
841: -- Kill the Loop CLOB
842: dbms_lob.trim(l_clob, 0);
843: END LOOP;
844:

Line 842: dbms_lob.trim(l_clob, 0);

838: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
839: -- Add this to our return CLOB
840: dbms_lob.append(returnclob, l_clob);
841: -- Kill the Loop CLOB
842: dbms_lob.trim(l_clob, 0);
843: END LOOP;
844:
845: end if;
846:

Line 883: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

879: and owner_tag like nvl(p_ownertag, '%');
880:
881: begin
882:
883: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
884: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
885:
886: if (p_key is not null OR p_key <> '') then
887:

Line 884: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

880:
881: begin
882:
883: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
884: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
885:
886: if (p_key is not null OR p_key <> '') then
887:
888: FOR g IN events LOOP

Line 892: dbms_lob.append(returnclob, l_clob);

888: FOR g IN events LOOP
889: -- Get our XML document
890: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
891: -- Add this to our return CLOB
892: dbms_lob.append(returnclob, l_clob);
893: -- Kill the Loop CLOB
894: dbms_lob.trim(l_clob, 0);
895: END LOOP;
896:

Line 894: dbms_lob.trim(l_clob, 0);

890: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
891: -- Add this to our return CLOB
892: dbms_lob.append(returnclob, l_clob);
893: -- Kill the Loop CLOB
894: dbms_lob.trim(l_clob, 0);
895: END LOOP;
896:
897: else
898:

Line 903: dbms_lob.append(returnclob, l_clob);

899: FOR g IN events_all LOOP
900: -- Get our XML document
901: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
902: -- Add this to our return CLOB
903: dbms_lob.append(returnclob, l_clob);
904: -- Kill the Loop CLOB
905: dbms_lob.trim(l_clob, 0);
906: END LOOP;
907:

Line 905: dbms_lob.trim(l_clob, 0);

901: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.event.update', g.guid);
902: -- Add this to our return CLOB
903: dbms_lob.append(returnclob, l_clob);
904: -- Kill the Loop CLOB
905: dbms_lob.trim(l_clob, 0);
906: END LOOP;
907:
908: end if;
909:

Line 938: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

934: order by g.name;
935:
936: begin
937:
938: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
939:
940: FOR g IN event_groups LOOP
941:
942: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

Line 942: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

938: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
939:
940: FOR g IN event_groups LOOP
941:
942: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
943:
944: -- Get our XML document
945: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
946:

Line 948: dbms_lob.append(returnclob, l_clob);

944: -- Get our XML document
945: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.group.update', g.names);
946:
947: -- Add this to our return CLOB
948: dbms_lob.append(returnclob, l_clob);
949:
950: -- Kill the Loop CLOB
951: l_clob := null;
952:

Line 1016: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);

1012: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETSUBSCRIPTIONS.Begin',
1013: 'Entered GetSubscriptions');
1014: end if;
1015:
1016: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
1017:
1018: FOR g IN event_subscriptions(l_guid) LOOP
1019:
1020: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

Line 1020: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

1016: dbms_lob.createtemporary(returnclob, FALSE, DBMS_LOB.CALL);
1017:
1018: FOR g IN event_subscriptions(l_guid) LOOP
1019:
1020: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
1021:
1022: -- Get our XML document
1023: l_clob := wf_event_functions_pkg.generate('oracle.apps.wf.event.subscription.update', g.guid);
1024:

Line 1032: l_clob_len := dbms_lob.getlength(l_clob);

1028: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.GETSUBSCRIPTIONS.set_pound',
1029: 'Substitute with pounds.');
1030: end if;
1031:
1032: l_clob_len := dbms_lob.getlength(l_clob);
1033: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);
1034:
1035: -- # replacement in and field
1036: l_tmpStr := SetPound(1,l_tmpStr,'','','NEW',null);

Line 1033: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);

1029: 'Substitute with pounds.');
1030: end if;
1031:
1032: l_clob_len := dbms_lob.getlength(l_clob);
1033: dbms_lob.read(l_clob, l_clob_len, 1, l_tmpStr);
1034:
1035: -- # replacement in and field
1036: l_tmpStr := SetPound(1,l_tmpStr,'','','NEW',null);
1037: l_tmpStr := SetPound(1,l_tmpStr,'','','LOCAL',null);

Line 1117: dbms_lob.erase(l_clob, l_clob_len, 1);

1113: END LOOP;
1114: **/
1115: l_tmpStrLen := length(l_tmpStr);
1116:
1117: dbms_lob.erase(l_clob, l_clob_len, 1);
1118: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
1119: end if;
1120:
1121: -- Add this to our return CLOB

Line 1118: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);

1114: **/
1115: l_tmpStrLen := length(l_tmpStr);
1116:
1117: dbms_lob.erase(l_clob, l_clob_len, 1);
1118: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
1119: end if;
1120:
1121: -- Add this to our return CLOB
1122: dbms_lob.append(returnclob, l_clob);

Line 1122: dbms_lob.append(returnclob, l_clob);

1118: dbms_lob.write(l_clob, l_tmpStrLen, 1, l_tmpStr);
1119: end if;
1120:
1121: -- Add this to our return CLOB
1122: dbms_lob.append(returnclob, l_clob);
1123:
1124: -- Kill the Loop CLOB
1125: l_clob := null;
1126:

Line 1696: dbms_lob.createtemporary(p_outclob, FALSE, DBMS_LOB.CALL);

1692: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATEEMPTYCLOB.Begin',
1693: 'Entered Create Empty Clob');
1694: end if;
1695:
1696: dbms_lob.createtemporary(p_outclob, FALSE, DBMS_LOB.CALL);
1697: exception
1698: when others then
1699: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATEEMPTYCLOB');
1700: raise;