APPS.CCT_ROUTINGACTIVITIES_PUB dependencies on WF_ENGINE

Line 43: resultout := wf_engine.eng_null;

39: l_startTime date;
40: l_endTime date;
41: l_TimeOfCall date;
42: BEGIN
43: resultout := wf_engine.eng_null;
44:
45: -- Do nothing in cancel or timeout mode
46: if (funmode <> wf_engine.eng_run) then
47: return;

Line 46: if (funmode <> wf_engine.eng_run) then

42: BEGIN
43: resultout := wf_engine.eng_null;
44:
45: -- Do nothing in cancel or timeout mode
46: if (funmode <> wf_engine.eng_run) then
47: return;
48: end if;
49:
50: l_startTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

Line 50: l_startTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

46: if (funmode <> wf_engine.eng_run) then
47: return;
48: end if;
49:
50: l_startTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
51: 'START-TIME');
52:
53: l_endTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid ,
54: 'END-TIME');

Line 53: l_endTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid ,

49:
50: l_startTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
51: 'START-TIME');
52:
53: l_endTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid ,
54: 'END-TIME');
55:
56: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
57: 'OCCTCREATIONTIME');

Line 56: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

52:
53: l_endTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid ,
54: 'END-TIME');
55:
56: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
57: 'OCCTCREATIONTIME');
58:
59: -- Compare time of call to business open and close times
60: IF (l_startTime is null or l_endTime is null) THEN

Line 61: resultout := wf_engine.eng_completed||':' || wf_engine.eng_null;

57: 'OCCTCREATIONTIME');
58:
59: -- Compare time of call to business open and close times
60: IF (l_startTime is null or l_endTime is null) THEN
61: resultout := wf_engine.eng_completed||':' || wf_engine.eng_null;
62: ELSIF ( (l_TimeOfCall - TRUNC(l_TimeOfCall)) >=
63: (l_startTime - TRUNC(l_startTime )) AND
64: (l_TimeOfCall - TRUNC(l_TimeOfCall)) <=
65: (l_endTime - TRUNC(l_endTime))) THEN

Line 67: resultout := wf_engine.eng_completed||':Y';

63: (l_startTime - TRUNC(l_startTime )) AND
64: (l_TimeOfCall - TRUNC(l_TimeOfCall)) <=
65: (l_endTime - TRUNC(l_endTime))) THEN
66:
67: resultout := wf_engine.eng_completed||':Y';
68:
69: ELSE
70: resultout := wf_engine.eng_completed||':N';
71:

Line 70: resultout := wf_engine.eng_completed||':N';

66:
67: resultout := wf_engine.eng_completed||':Y';
68:
69: ELSE
70: resultout := wf_engine.eng_completed||':N';
71:
72: END IF;
73:
74:

Line 116: resultout := wf_engine.eng_null;

112: l_proc_name VARCHAR2(30) := 'HourOfDay';
113: l_dateval1 date;
114: l_hour varchar2(20);
115: begin
116: resultout := wf_engine.eng_null;
117:
118: -- Do nothing in cancel or timeout mode
119: if (funmode <> wf_engine.eng_run) then
120: return;

Line 119: if (funmode <> wf_engine.eng_run) then

115: begin
116: resultout := wf_engine.eng_null;
117:
118: -- Do nothing in cancel or timeout mode
119: if (funmode <> wf_engine.eng_run) then
120: return;
121: end if;
122:
123: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

Line 123: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

119: if (funmode <> wf_engine.eng_run) then
120: return;
121: end if;
122:
123: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
124: 'OCCTCREATIONTIME');
125:
126: -- Need to make a 24 hour clock
127: l_hour := to_char(l_dateval1, 'HOUR') ;

Line 128: resultout := wf_engine.eng_completed||':'||l_hour;

124: 'OCCTCREATIONTIME');
125:
126: -- Need to make a 24 hour clock
127: l_hour := to_char(l_dateval1, 'HOUR') ;
128: resultout := wf_engine.eng_completed||':'||l_hour;
129:
130: exception
131: when others then
132: -- if the customer id is not found

Line 173: if (funmode <> wf_engine.eng_run) then

169: l_TimeOfCall date;
170: l_refTime date;
171: begin
172: -- Do nothing in cancel or timeout mode
173: if (funmode <> wf_engine.eng_run) then
174: resultout := wf_engine.eng_null;
175: return;
176: end if;
177: /* **************** */

Line 174: resultout := wf_engine.eng_null;

170: l_refTime date;
171: begin
172: -- Do nothing in cancel or timeout mode
173: if (funmode <> wf_engine.eng_run) then
174: resultout := wf_engine.eng_null;
175: return;
176: end if;
177: /* **************** */
178: -- Get the two date values

Line 179: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

175: return;
176: end if;
177: /* **************** */
178: -- Get the two date values
179: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
180: 'OCCTCREATIONTIME');
181: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
182: 'REF-TIME');
183:

Line 181: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

177: /* **************** */
178: -- Get the two date values
179: l_TimeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
180: 'OCCTCREATIONTIME');
181: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
182: 'REF-TIME');
183:
184: -- Compare
185: if (l_TimeOfCall is null or l_refTime is null) then

Line 186: resultout := wf_engine.eng_completed||':NULL';

182: 'REF-TIME');
183:
184: -- Compare
185: if (l_TimeOfCall is null or l_refTime is null) then
186: resultout := wf_engine.eng_completed||':NULL';
187: elsif ( (l_TimeOfCall - TRUNC(l_TimeOfCall)) <
188: (l_refTime - TRUNC(l_refTime)) ) then
189: resultout := wf_engine.eng_completed||':Y';
190: else

Line 189: resultout := wf_engine.eng_completed||':Y';

185: if (l_TimeOfCall is null or l_refTime is null) then
186: resultout := wf_engine.eng_completed||':NULL';
187: elsif ( (l_TimeOfCall - TRUNC(l_TimeOfCall)) <
188: (l_refTime - TRUNC(l_refTime)) ) then
189: resultout := wf_engine.eng_completed||':Y';
190: else
191: resultout := wf_engine.eng_completed||':N';
192: end if;
193:

Line 191: resultout := wf_engine.eng_completed||':N';

187: elsif ( (l_TimeOfCall - TRUNC(l_TimeOfCall)) <
188: (l_refTime - TRUNC(l_refTime)) ) then
189: resultout := wf_engine.eng_completed||':Y';
190: else
191: resultout := wf_engine.eng_completed||':N';
192: end if;
193:
194: /* ************ */
195:

Line 231: if (funmode <> wf_engine.eng_run) then

227: l_timeOfCall date;
228: l_refTime date;
229: begin
230: -- Do nothing in cancel or timeout mode
231: if (funmode <> wf_engine.eng_run) then
232: resultout := wf_engine.eng_null;
233: return;
234: end if;
235: /* **************** */

Line 232: resultout := wf_engine.eng_null;

228: l_refTime date;
229: begin
230: -- Do nothing in cancel or timeout mode
231: if (funmode <> wf_engine.eng_run) then
232: resultout := wf_engine.eng_null;
233: return;
234: end if;
235: /* **************** */
236: -- Get the two date values

Line 237: l_timeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

233: return;
234: end if;
235: /* **************** */
236: -- Get the two date values
237: l_timeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
238: 'OCCTCREATIONTIME');
239: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
240: 'REF-TIME');
241:

Line 239: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

235: /* **************** */
236: -- Get the two date values
237: l_timeOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
238: 'OCCTCREATIONTIME');
239: l_refTime := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
240: 'REF-TIME');
241:
242: -- Compare
243: if (l_timeOfCall is null or l_refTime is null) then

Line 244: resultout := wf_engine.eng_completed||':NULL';

240: 'REF-TIME');
241:
242: -- Compare
243: if (l_timeOfCall is null or l_refTime is null) then
244: resultout := wf_engine.eng_completed||':NULL';
245: elsif ( (l_timeOfCall - TRUNC(l_timeOfCall)) >
246: (l_refTime - TRUNC(l_refTime)) ) then
247: resultout := wf_engine.eng_completed||':Y';
248: else

Line 247: resultout := wf_engine.eng_completed||':Y';

243: if (l_timeOfCall is null or l_refTime is null) then
244: resultout := wf_engine.eng_completed||':NULL';
245: elsif ( (l_timeOfCall - TRUNC(l_timeOfCall)) >
246: (l_refTime - TRUNC(l_refTime)) ) then
247: resultout := wf_engine.eng_completed||':Y';
248: else
249: resultout := wf_engine.eng_completed||':N';
250: end if;
251:

Line 249: resultout := wf_engine.eng_completed||':N';

245: elsif ( (l_timeOfCall - TRUNC(l_timeOfCall)) >
246: (l_refTime - TRUNC(l_refTime)) ) then
247: resultout := wf_engine.eng_completed||':Y';
248: else
249: resultout := wf_engine.eng_completed||':N';
250: end if;
251:
252: /* ************ */
253:

Line 289: resultout := wf_engine.eng_null;

285: l_proc_name VARCHAR2(30) := 'DayOfWeek';
286: l_dateval1 date;
287: l_day varchar2(20);
288: begin
289: resultout := wf_engine.eng_null;
290:
291: -- Do nothing in cancel or timeout mode
292: if (funmode <> wf_engine.eng_run) then
293: return;

Line 292: if (funmode <> wf_engine.eng_run) then

288: begin
289: resultout := wf_engine.eng_null;
290:
291: -- Do nothing in cancel or timeout mode
292: if (funmode <> wf_engine.eng_run) then
293: return;
294: end if;
295:
296: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

Line 296: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

292: if (funmode <> wf_engine.eng_run) then
293: return;
294: end if;
295:
296: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
297: 'OCCTCREATIONTIME');
298:
299: if (l_dateval1 IS NULL) then
300: return;

Line 304: resultout := wf_engine.eng_completed||':'||l_day;

300: return;
301: end if;
302:
303: l_day := RTRIM(to_char(l_dateval1, 'DAY')) ;
304: resultout := wf_engine.eng_completed||':'||l_day;
305: exception
306: when others then
307: Wf_Core.Context(G_PKG_NAME, l_proc_name, itemtype,
308: itemkey, to_char(actid), funmode);

Line 336: resultout := wf_engine.eng_null;

332: l_proc_name VARCHAR2(30) := 'DayOfMonth';
333: l_dateval1 date;
334: l_day varchar2(20);
335: begin
336: resultout := wf_engine.eng_null;
337:
338: -- Do nothing in cancel or timeout mode
339: if (funmode <> wf_engine.eng_run) then
340: return;

Line 339: if (funmode <> wf_engine.eng_run) then

335: begin
336: resultout := wf_engine.eng_null;
337:
338: -- Do nothing in cancel or timeout mode
339: if (funmode <> wf_engine.eng_run) then
340: return;
341: end if;
342:
343: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

Line 343: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

339: if (funmode <> wf_engine.eng_run) then
340: return;
341: end if;
342:
343: l_dateval1 := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
344: 'OCCTCREATIONTIME');
345:
346: l_day := to_char(l_dateval1, 'DD') ;
347: l_day := LTRIM(RTRIM(l_day));

Line 348: resultout := wf_engine.eng_completed||':'||l_day;

344: 'OCCTCREATIONTIME');
345:
346: l_day := to_char(l_dateval1, 'DD') ;
347: l_day := LTRIM(RTRIM(l_day));
348: resultout := wf_engine.eng_completed||':'||l_day;
349:
350: exception
351: when others then
352: -- if the customer id is not found

Line 393: if (funmode <> wf_engine.eng_run) then

389: l_dateOfCall date;
390: l_refDate date;
391: begin
392: -- Do nothing in cancel or timeout mode
393: if (funmode <> wf_engine.eng_run) then
394: resultout := wf_engine.eng_null;
395: return;
396: end if;
397:

Line 394: resultout := wf_engine.eng_null;

390: l_refDate date;
391: begin
392: -- Do nothing in cancel or timeout mode
393: if (funmode <> wf_engine.eng_run) then
394: resultout := wf_engine.eng_null;
395: return;
396: end if;
397:
398: -- Get the two date values

Line 399: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

395: return;
396: end if;
397:
398: -- Get the two date values
399: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
400: 'OCCTCREATIONTIME');
401:
402: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
403: 'REF-DATE');

Line 402: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

398: -- Get the two date values
399: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
400: 'OCCTCREATIONTIME');
401:
402: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
403: 'REF-DATE');
404:
405: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
406: if (l_dateOfCall is null) or (l_refDate is null) then

Line 407: resultout := wf_engine.eng_completed||':NULL';

403: 'REF-DATE');
404:
405: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
406: if (l_dateOfCall is null) or (l_refDate is null) then
407: resultout := wf_engine.eng_completed||':NULL';
408: elsif ( l_dateOfCall < l_refDate ) then
409: resultout := wf_engine.eng_completed||':Y';
410: else
411: resultout := wf_engine.eng_completed||':N';

Line 409: resultout := wf_engine.eng_completed||':Y';

405: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
406: if (l_dateOfCall is null) or (l_refDate is null) then
407: resultout := wf_engine.eng_completed||':NULL';
408: elsif ( l_dateOfCall < l_refDate ) then
409: resultout := wf_engine.eng_completed||':Y';
410: else
411: resultout := wf_engine.eng_completed||':N';
412: end if;
413:

Line 411: resultout := wf_engine.eng_completed||':N';

407: resultout := wf_engine.eng_completed||':NULL';
408: elsif ( l_dateOfCall < l_refDate ) then
409: resultout := wf_engine.eng_completed||':Y';
410: else
411: resultout := wf_engine.eng_completed||':N';
412: end if;
413:
414: Exception
415: when others then

Line 449: if (funmode <> wf_engine.eng_run) then

445: l_dateOfCall date;
446: l_refDate date;
447: begin
448: -- Do nothing in cancel or timeout mode
449: if (funmode <> wf_engine.eng_run) then
450: resultout := wf_engine.eng_null;
451: return;
452: end if;
453: -- Get the two date values

Line 450: resultout := wf_engine.eng_null;

446: l_refDate date;
447: begin
448: -- Do nothing in cancel or timeout mode
449: if (funmode <> wf_engine.eng_run) then
450: resultout := wf_engine.eng_null;
451: return;
452: end if;
453: -- Get the two date values
454: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

Line 454: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

450: resultout := wf_engine.eng_null;
451: return;
452: end if;
453: -- Get the two date values
454: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
455: 'OCCTCREATIONTIME');
456: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
457: 'REF-DATE');
458:

Line 456: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

452: end if;
453: -- Get the two date values
454: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
455: 'OCCTCREATIONTIME');
456: l_refDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
457: 'REF-DATE');
458:
459: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
460: if (l_dateOfCall is null) or (l_refDate is null) then

Line 461: resultout := wf_engine.eng_completed||':NULL';

457: 'REF-DATE');
458:
459: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
460: if (l_dateOfCall is null) or (l_refDate is null) then
461: resultout := wf_engine.eng_completed||':NULL';
462: elsif ( l_dateOfCall > l_refDate ) then
463: resultout := wf_engine.eng_completed||':Y';
464: else
465: resultout := wf_engine.eng_completed||':N';

Line 463: resultout := wf_engine.eng_completed||':Y';

459: -- Compare l_dateOfCall (date of call) with l_refDate (REF-DATE)
460: if (l_dateOfCall is null) or (l_refDate is null) then
461: resultout := wf_engine.eng_completed||':NULL';
462: elsif ( l_dateOfCall > l_refDate ) then
463: resultout := wf_engine.eng_completed||':Y';
464: else
465: resultout := wf_engine.eng_completed||':N';
466: end if;
467:

Line 465: resultout := wf_engine.eng_completed||':N';

461: resultout := wf_engine.eng_completed||':NULL';
462: elsif ( l_dateOfCall > l_refDate ) then
463: resultout := wf_engine.eng_completed||':Y';
464: else
465: resultout := wf_engine.eng_completed||':N';
466: end if;
467:
468:
469: Exception

Line 507: if (funmode <> wf_engine.eng_run) then

503: l_endDate date;
504: l_dateOfCall date;
505: begin
506: -- Do nothing in cancel or timeout mode
507: if (funmode <> wf_engine.eng_run) then
508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511: -- Get the two date values

Line 508: resultout := wf_engine.eng_null;

504: l_dateOfCall date;
505: begin
506: -- Do nothing in cancel or timeout mode
507: if (funmode <> wf_engine.eng_run) then
508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511: -- Get the two date values
512: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

Line 512: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,

508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511: -- Get the two date values
512: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
513: 'OCCTCREATIONTIME');
514: l_startDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
515: 'START-DATE');
516: l_endDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

Line 514: l_startDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

510: end if;
511: -- Get the two date values
512: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
513: 'OCCTCREATIONTIME');
514: l_startDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
515: 'START-DATE');
516: l_endDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
517: 'END-DATE');
518:

Line 516: l_endDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,

512: l_dateOfCall := Wf_Engine.GetItemAttrDate(itemtype,itemkey,
513: 'OCCTCREATIONTIME');
514: l_startDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
515: 'START-DATE');
516: l_endDate := Wf_Engine.GetActivityAttrDate(itemtype,itemkey,actid,
517: 'END-DATE');
518:
519: -- Compare l_dateOfCall with START-DATE and END-DATE
520: if (l_startDate is null) or (l_endDate is null) then

Line 521: resultout := wf_engine.eng_completed||':NULL';

517: 'END-DATE');
518:
519: -- Compare l_dateOfCall with START-DATE and END-DATE
520: if (l_startDate is null) or (l_endDate is null) then
521: resultout := wf_engine.eng_completed||':NULL';
522: elsif ( (TRUNC(l_dateOfCall) <= TRUNC(l_endDate)) AND
523: (TRUNC(l_dateOfCall) >= TRUNC(l_startDate))) then
524: resultout := wf_engine.eng_completed||':Y';
525: else

Line 524: resultout := wf_engine.eng_completed||':Y';

520: if (l_startDate is null) or (l_endDate is null) then
521: resultout := wf_engine.eng_completed||':NULL';
522: elsif ( (TRUNC(l_dateOfCall) <= TRUNC(l_endDate)) AND
523: (TRUNC(l_dateOfCall) >= TRUNC(l_startDate))) then
524: resultout := wf_engine.eng_completed||':Y';
525: else
526: resultout := wf_engine.eng_completed||':N';
527: end if;
528:

Line 526: resultout := wf_engine.eng_completed||':N';

522: elsif ( (TRUNC(l_dateOfCall) <= TRUNC(l_endDate)) AND
523: (TRUNC(l_dateOfCall) >= TRUNC(l_startDate))) then
524: resultout := wf_engine.eng_completed||':Y';
525: else
526: resultout := wf_engine.eng_completed||':N';
527: end if;
528:
529: Exception
530: when others then

Line 570: resultout := wf_engine.eng_completed ;

566: i INTEGER;
567: l_competency_type VARCHAR2(32):= 'LANG'; -- Changed Jun 27 2000
568: BEGIN
569: -- set default result
570: resultout := wf_engine.eng_completed ;
571:
572: if (funmode = 'RUN') then
573: l_competency_name := WF_ENGINE.GetItemAttrText(
574: itemtype, itemkey, 'LANGUAGECOMPETENCY');

Line 573: l_competency_name := WF_ENGINE.GetItemAttrText(

569: -- set default result
570: resultout := wf_engine.eng_completed ;
571:
572: if (funmode = 'RUN') then
573: l_competency_name := WF_ENGINE.GetItemAttrText(
574: itemtype, itemkey, 'LANGUAGECOMPETENCY');
575:
576: l_call_ID := WF_ENGINE.GetItemAttrText(
577: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 576: l_call_ID := WF_ENGINE.GetItemAttrText(

572: if (funmode = 'RUN') then
573: l_competency_name := WF_ENGINE.GetItemAttrText(
574: itemtype, itemkey, 'LANGUAGECOMPETENCY');
575:
576: l_call_ID := WF_ENGINE.GetItemAttrText(
577: itemtype, itemkey, 'OCCTMEDIAITEMID');
578:
579: IF ( (l_competency_name IS NULL) OR (l_call_ID IS NULL) ) THEN
580: return;

Line 636: resultout := wf_engine.eng_completed ;

632: l_competency_type VARCHAR2(32):= 'KNOWLEDGE';
633:
634: BEGIN
635: -- set default result
636: resultout := wf_engine.eng_completed ;
637:
638: if (funmode = 'RUN') then
639: l_competency_name := WF_ENGINE.GetItemAttrText(
640: itemtype, itemkey, 'KNOWLEDGECOMPETENCY');

Line 639: l_competency_name := WF_ENGINE.GetItemAttrText(

635: -- set default result
636: resultout := wf_engine.eng_completed ;
637:
638: if (funmode = 'RUN') then
639: l_competency_name := WF_ENGINE.GetItemAttrText(
640: itemtype, itemkey, 'KNOWLEDGECOMPETENCY');
641:
642: l_call_ID := WF_ENGINE.GetItemAttrText(
643: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 642: l_call_ID := WF_ENGINE.GetItemAttrText(

638: if (funmode = 'RUN') then
639: l_competency_name := WF_ENGINE.GetItemAttrText(
640: itemtype, itemkey, 'KNOWLEDGECOMPETENCY');
641:
642: l_call_ID := WF_ENGINE.GetItemAttrText(
643: itemtype, itemkey, 'OCCTMEDIAITEMID');
644:
645: IF ( (l_competency_name IS NULL) OR (l_call_ID IS NULL) ) THEN
646: return;

Line 702: resultout := wf_engine.eng_completed ;

698: i INTEGER;
699: l_competency_type VARCHAR2(32):= 'PRODUCT';
700: BEGIN
701: -- set default result
702: resultout := wf_engine.eng_completed ;
703:
704: if (funmode = 'RUN') then
705: l_competency_name := WF_ENGINE.GetItemAttrText(
706: itemtype, itemkey, 'PRODUCTCOMPETENCY');

Line 705: l_competency_name := WF_ENGINE.GetItemAttrText(

701: -- set default result
702: resultout := wf_engine.eng_completed ;
703:
704: if (funmode = 'RUN') then
705: l_competency_name := WF_ENGINE.GetItemAttrText(
706: itemtype, itemkey, 'PRODUCTCOMPETENCY');
707:
708: l_call_ID := WF_ENGINE.GetItemAttrText(
709: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 708: l_call_ID := WF_ENGINE.GetItemAttrText(

704: if (funmode = 'RUN') then
705: l_competency_name := WF_ENGINE.GetItemAttrText(
706: itemtype, itemkey, 'PRODUCTCOMPETENCY');
707:
708: l_call_ID := WF_ENGINE.GetItemAttrText(
709: itemtype, itemkey, 'OCCTMEDIAITEMID');
710:
711: IF ( (l_competency_name IS NULL) OR (l_call_ID IS NULL) ) THEN
712: return;

Line 767: resultout := wf_engine.eng_completed ;

763: i INTEGER;
764: l_competency_type VARCHAR2(32):= 'OCCTDNIS';
765: BEGIN
766: -- set default result
767: resultout := wf_engine.eng_completed ;
768:
769: if (funmode = 'RUN') then
770: l_competency_name := WF_ENGINE.GetItemAttrText(
771: itemtype, itemkey, 'OCCTDNIS');

Line 770: l_competency_name := WF_ENGINE.GetItemAttrText(

766: -- set default result
767: resultout := wf_engine.eng_completed ;
768:
769: if (funmode = 'RUN') then
770: l_competency_name := WF_ENGINE.GetItemAttrText(
771: itemtype, itemkey, 'OCCTDNIS');
772:
773: l_call_ID := WF_ENGINE.GetItemAttrText(
774: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 773: l_call_ID := WF_ENGINE.GetItemAttrText(

769: if (funmode = 'RUN') then
770: l_competency_name := WF_ENGINE.GetItemAttrText(
771: itemtype, itemkey, 'OCCTDNIS');
772:
773: l_call_ID := WF_ENGINE.GetItemAttrText(
774: itemtype, itemkey, 'OCCTMEDIAITEMID');
775:
776: IF ( (l_competency_name IS NULL) OR (l_call_ID IS NULL) ) THEN
777: return;

Line 827: resultout := wf_engine.eng_completed;

823: l_MCM_ID NUMBER;
824: l_resultcode VARCHAR2(30);
825: BEGIN
826: -- set default result
827: resultout := wf_engine.eng_completed;
828:
829: IF (funmode = 'RUN') THEN
830:
831: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(

Line 831: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(

827: resultout := wf_engine.eng_completed;
828:
829: IF (funmode = 'RUN') THEN
830:
831: l_MCM_ID := WF_ENGINE.GetItemAttrNumber(
832: itemtype,itemkey,'MCM_ID' );
833:
834: IF (l_MCM_ID IS NOT NULL) THEN
835: l_SrvGroup :=

Line 849: resultout := wf_engine.eng_completed || ':' || l_resultcode ;

845: if (l_resultcode IS NULL) then
846: l_resultcode := 'DEFAULT_ServerGroup';
847: end if;
848:
849: resultout := wf_engine.eng_completed || ':' || l_resultcode ;
850:
851: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SRVGROUP',
852: l_SrvGroup );
853: END IF;

Line 851: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SRVGROUP',

847: end if;
848:
849: resultout := wf_engine.eng_completed || ':' || l_resultcode ;
850:
851: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SRVGROUP',
852: l_SrvGroup );
853: END IF;
854: END IF;
855: END IF;

Line 891: resultout := wf_engine.eng_completed ;

887: l_MCM_ID VARCHAR2(32);
888: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
889: BEGIN
890: -- set default result
891: resultout := wf_engine.eng_completed ;
892:
893: IF (funmode = 'RUN') THEN
894: l_call_ID := WF_ENGINE.GetItemAttrText(
895: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 894: l_call_ID := WF_ENGINE.GetItemAttrText(

890: -- set default result
891: resultout := wf_engine.eng_completed ;
892:
893: IF (funmode = 'RUN') THEN
894: l_call_ID := WF_ENGINE.GetItemAttrText(
895: itemtype, itemkey, 'OCCTMEDIAITEMID');
896: l_MCM_ID := WF_ENGINE.GetItemAttrText(
897: itemtype, itemkey, 'MCM_ID');
898:

Line 896: l_MCM_ID := WF_ENGINE.GetItemAttrText(

892:
893: IF (funmode = 'RUN') THEN
894: l_call_ID := WF_ENGINE.GetItemAttrText(
895: itemtype, itemkey, 'OCCTMEDIAITEMID');
896: l_MCM_ID := WF_ENGINE.GetItemAttrText(
897: itemtype, itemkey, 'MCM_ID');
898:
899: IF (l_MCM_ID IS NULL) OR (l_call_ID IS NULL) THEN
900: return;

Line 944: resultout := wf_engine.eng_completed ;

940: l_group_name VARCHAR2(200);
941: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
942: BEGIN
943: -- set default result
944: resultout := wf_engine.eng_completed ;
945:
946: IF (funmode = 'RUN') THEN
947: l_call_ID := WF_ENGINE.GetItemAttrText(
948: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 947: l_call_ID := WF_ENGINE.GetItemAttrText(

943: -- set default result
944: resultout := wf_engine.eng_completed ;
945:
946: IF (funmode = 'RUN') THEN
947: l_call_ID := WF_ENGINE.GetItemAttrText(
948: itemtype, itemkey, 'OCCTMEDIAITEMID');
949: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
950: ,actid,'STATICGROUPNAME');
951:

Line 949: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey

945:
946: IF (funmode = 'RUN') THEN
947: l_call_ID := WF_ENGINE.GetItemAttrText(
948: itemtype, itemkey, 'OCCTMEDIAITEMID');
949: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
950: ,actid,'STATICGROUPNAME');
951:
952:
953:

Line 999: resultout := wf_engine.eng_completed ;

995: l_call_ID VARCHAR2(32);
996: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
997: BEGIN
998: -- set default result
999: resultout := wf_engine.eng_completed ;
1000:
1001: IF (funmode = 'RUN') THEN
1002: l_call_ID := WF_ENGINE.GetItemAttrText(
1003: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1002: l_call_ID := WF_ENGINE.GetItemAttrText(

998: -- set default result
999: resultout := wf_engine.eng_completed ;
1000:
1001: IF (funmode = 'RUN') THEN
1002: l_call_ID := WF_ENGINE.GetItemAttrText(
1003: itemtype, itemkey, 'OCCTMEDIAITEMID');
1004: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1005: ,actid,'STATICGROUPNUMBER');
1006:

Line 1004: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey

1000:
1001: IF (funmode = 'RUN') THEN
1002: l_call_ID := WF_ENGINE.GetItemAttrText(
1003: itemtype, itemkey, 'OCCTMEDIAITEMID');
1004: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1005: ,actid,'STATICGROUPNUMBER');
1006:
1007:
1008: IF ((l_group_number IS NULL) OR (l_call_ID IS NULL)) THEN

Line 1053: resultout := wf_engine.eng_completed ;

1049: l_call_ID VARCHAR2(32);
1050: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1051: BEGIN
1052: -- set default result
1053: resultout := wf_engine.eng_completed ;
1054:
1055: IF (funmode = 'RUN') THEN
1056: l_call_ID := WF_ENGINE.GetItemAttrText(
1057: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1056: l_call_ID := WF_ENGINE.GetItemAttrText(

1052: -- set default result
1053: resultout := wf_engine.eng_completed ;
1054:
1055: IF (funmode = 'RUN') THEN
1056: l_call_ID := WF_ENGINE.GetItemAttrText(
1057: itemtype, itemkey, 'OCCTMEDIAITEMID');
1058: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1059: ,actid, 'DYNAMICGROUPNAME');
1060:

Line 1058: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey

1054:
1055: IF (funmode = 'RUN') THEN
1056: l_call_ID := WF_ENGINE.GetItemAttrText(
1057: itemtype, itemkey, 'OCCTMEDIAITEMID');
1058: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1059: ,actid, 'DYNAMICGROUPNAME');
1060:
1061: IF (l_group_name IS NULL ) OR (l_call_ID IS NULL) THEN
1062: return;

Line 1105: resultout := wf_engine.eng_completed ;

1101: l_call_ID VARCHAR2(32);
1102: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1103: BEGIN
1104: -- set default result
1105: resultout := wf_engine.eng_completed ;
1106:
1107: IF (funmode = 'RUN') THEN
1108: l_call_ID := WF_ENGINE.GetItemAttrText(
1109: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1108: l_call_ID := WF_ENGINE.GetItemAttrText(

1104: -- set default result
1105: resultout := wf_engine.eng_completed ;
1106:
1107: IF (funmode = 'RUN') THEN
1108: l_call_ID := WF_ENGINE.GetItemAttrText(
1109: itemtype, itemkey, 'OCCTMEDIAITEMID');
1110: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1111: ,actid,'DYNAMICGROUPNUMBER');
1112:

Line 1110: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey

1106:
1107: IF (funmode = 'RUN') THEN
1108: l_call_ID := WF_ENGINE.GetItemAttrText(
1109: itemtype, itemkey, 'OCCTMEDIAITEMID');
1110: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1111: ,actid,'DYNAMICGROUPNUMBER');
1112:
1113: IF (l_group_number IS NULL) OR (l_call_ID IS NULL) THEN
1114: return;

Line 1158: resultout := wf_engine.eng_completed ;

1154: l_call_ID VARCHAR2(32);
1155: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1156: BEGIN
1157: -- set default result
1158: resultout := wf_engine.eng_completed ;
1159:
1160: IF (funmode = 'RUN') THEN
1161: l_call_ID := WF_ENGINE.GetItemAttrText(
1162: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1161: l_call_ID := WF_ENGINE.GetItemAttrText(

1157: -- set default result
1158: resultout := wf_engine.eng_completed ;
1159:
1160: IF (funmode = 'RUN') THEN
1161: l_call_ID := WF_ENGINE.GetItemAttrText(
1162: itemtype, itemkey, 'OCCTMEDIAITEMID');
1163:
1164: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1165: ,actid, 'STATICGROUPNAME');

Line 1164: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey

1160: IF (funmode = 'RUN') THEN
1161: l_call_ID := WF_ENGINE.GetItemAttrText(
1162: itemtype, itemkey, 'OCCTMEDIAITEMID');
1163:
1164: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1165: ,actid, 'STATICGROUPNAME');
1166:
1167: IF (l_group_name IS NULL ) OR (l_call_ID IS NULL) THEN
1168: return;

Line 1212: resultout := wf_engine.eng_completed ;

1208: l_call_ID VARCHAR2(32);
1209: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1210: BEGIN
1211: -- set default result
1212: resultout := wf_engine.eng_completed ;
1213:
1214: IF (funmode = 'RUN') THEN
1215: l_call_ID := WF_ENGINE.GetItemAttrText(
1216: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1215: l_call_ID := WF_ENGINE.GetItemAttrText(

1211: -- set default result
1212: resultout := wf_engine.eng_completed ;
1213:
1214: IF (funmode = 'RUN') THEN
1215: l_call_ID := WF_ENGINE.GetItemAttrText(
1216: itemtype, itemkey, 'OCCTMEDIAITEMID');
1217: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1218: ,actid, 'STATICGROUPNUMBER');
1219:

Line 1217: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey

1213:
1214: IF (funmode = 'RUN') THEN
1215: l_call_ID := WF_ENGINE.GetItemAttrText(
1216: itemtype, itemkey, 'OCCTMEDIAITEMID');
1217: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1218: ,actid, 'STATICGROUPNUMBER');
1219:
1220: IF (l_group_number IS NULL) OR (l_call_ID IS NULL) THEN
1221: return;

Line 1265: resultout := wf_engine.eng_completed ;

1261: l_call_ID VARCHAR2(32);
1262: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1263: BEGIN
1264: -- set default result
1265: resultout := wf_engine.eng_completed ;
1266:
1267: IF (funmode = 'RUN') THEN
1268: l_call_ID := WF_ENGINE.GetItemAttrText(
1269: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1268: l_call_ID := WF_ENGINE.GetItemAttrText(

1264: -- set default result
1265: resultout := wf_engine.eng_completed ;
1266:
1267: IF (funmode = 'RUN') THEN
1268: l_call_ID := WF_ENGINE.GetItemAttrText(
1269: itemtype, itemkey, 'OCCTMEDIAITEMID');
1270: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1271: ,actid, 'DYNAMICGROUPNAME');
1272: IF (l_group_name IS NULL) OR (l_call_ID IS NULL) THEN

Line 1270: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey

1266:
1267: IF (funmode = 'RUN') THEN
1268: l_call_ID := WF_ENGINE.GetItemAttrText(
1269: itemtype, itemkey, 'OCCTMEDIAITEMID');
1270: l_group_name := Wf_Engine.GetActivityAttrText(itemtype,itemkey
1271: ,actid, 'DYNAMICGROUPNAME');
1272: IF (l_group_name IS NULL) OR (l_call_ID IS NULL) THEN
1273: return;
1274: END IF;

Line 1316: resultout := wf_engine.eng_completed ;

1312: l_call_ID VARCHAR2(32);
1313: l_agents_tbl CCT_RoutingWorkflow_UTL.agent_tbl_type;
1314: BEGIN
1315: -- set default result
1316: resultout := wf_engine.eng_completed ;
1317:
1318: IF (funmode = 'RUN') THEN
1319: l_call_ID := WF_ENGINE.GetItemAttrText(
1320: itemtype, itemkey, 'OCCTMEDIAITEMID');

Line 1319: l_call_ID := WF_ENGINE.GetItemAttrText(

1315: -- set default result
1316: resultout := wf_engine.eng_completed ;
1317:
1318: IF (funmode = 'RUN') THEN
1319: l_call_ID := WF_ENGINE.GetItemAttrText(
1320: itemtype, itemkey, 'OCCTMEDIAITEMID');
1321: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1322: ,actid, 'DYNAMICGROUPNUMBER');
1323:

Line 1321: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey

1317:
1318: IF (funmode = 'RUN') THEN
1319: l_call_ID := WF_ENGINE.GetItemAttrText(
1320: itemtype, itemkey, 'OCCTMEDIAITEMID');
1321: l_group_number := Wf_Engine.GetActivityAttrNumber(itemtype,itemkey
1322: ,actid, 'DYNAMICGROUPNUMBER');
1323:
1324: IF (l_group_number IS NULL) OR (l_call_ID IS NULL) THEN
1325: return;

Line 1371: l_call_ID := WF_ENGINE.GetItemAttrText(

1367: l_media_type VARCHAR2(50) := 'OTHER';
1368: begin
1369:
1370: IF (funmode = 'RUN') THEN
1371: l_call_ID := WF_ENGINE.GetItemAttrText(
1372: itemtype, itemkey, 'OCCTMEDIAITEMID');
1373: l_media_type := WF_ENGINE.GetItemAttrText(
1374: itemtype, itemkey, 'OCCTMEDIATYPE');
1375: IF l_call_id IS NOT NULL THEN

Line 1373: l_media_type := WF_ENGINE.GetItemAttrText(

1369:
1370: IF (funmode = 'RUN') THEN
1371: l_call_ID := WF_ENGINE.GetItemAttrText(
1372: itemtype, itemkey, 'OCCTMEDIAITEMID');
1373: l_media_type := WF_ENGINE.GetItemAttrText(
1374: itemtype, itemkey, 'OCCTMEDIATYPE');
1375: IF l_call_id IS NOT NULL THEN
1376: -- Compare
1377: IF l_media_type = l_email THEN

Line 1378: resultout := wf_engine.eng_completed||':EMAIL';

1374: itemtype, itemkey, 'OCCTMEDIATYPE');
1375: IF l_call_id IS NOT NULL THEN
1376: -- Compare
1377: IF l_media_type = l_email THEN
1378: resultout := wf_engine.eng_completed||':EMAIL';
1379: ELSIF l_media_type = l_phone then
1380: resultout := wf_engine.eng_completed||':PHONE';
1381: ELSE
1382: resultout := wf_engine.eng_completed||':OTHER';

Line 1380: resultout := wf_engine.eng_completed||':PHONE';

1376: -- Compare
1377: IF l_media_type = l_email THEN
1378: resultout := wf_engine.eng_completed||':EMAIL';
1379: ELSIF l_media_type = l_phone then
1380: resultout := wf_engine.eng_completed||':PHONE';
1381: ELSE
1382: resultout := wf_engine.eng_completed||':OTHER';
1383: end if;
1384: END IF;

Line 1382: resultout := wf_engine.eng_completed||':OTHER';

1378: resultout := wf_engine.eng_completed||':EMAIL';
1379: ELSIF l_media_type = l_phone then
1380: resultout := wf_engine.eng_completed||':PHONE';
1381: ELSE
1382: resultout := wf_engine.eng_completed||':OTHER';
1383: end if;
1384: END IF;
1385: END IF;
1386: Exception

Line 1419: resultout := wf_engine.eng_completed||':OTHER';

1415: l_classification VARCHAR2(255);
1416: l_appID NUMBER;
1417: l_appName VARCHAR2(64);
1418: Begin
1419: resultout := wf_engine.eng_completed||':OTHER';
1420: IF (funmode = 'RUN') THEN
1421: l_mediaType :=WF_ENGINE.GetItemAttrText(
1422: itemtype, itemkey, 'OCCTMEDIATYPE');
1423: l_Classification := WF_ENGINE.GetItemAttrText(

Line 1421: l_mediaType :=WF_ENGINE.GetItemAttrText(

1417: l_appName VARCHAR2(64);
1418: Begin
1419: resultout := wf_engine.eng_completed||':OTHER';
1420: IF (funmode = 'RUN') THEN
1421: l_mediaType :=WF_ENGINE.GetItemAttrText(
1422: itemtype, itemkey, 'OCCTMEDIATYPE');
1423: l_Classification := WF_ENGINE.GetItemAttrText(
1424: itemtype, itemkey, 'OCCTCLASSIFICATION');
1425: If ((l_mediaType is not null) AND (l_classification is not null)) THEN

Line 1423: l_Classification := WF_ENGINE.GetItemAttrText(

1419: resultout := wf_engine.eng_completed||':OTHER';
1420: IF (funmode = 'RUN') THEN
1421: l_mediaType :=WF_ENGINE.GetItemAttrText(
1422: itemtype, itemkey, 'OCCTMEDIATYPE');
1423: l_Classification := WF_ENGINE.GetItemAttrText(
1424: itemtype, itemkey, 'OCCTCLASSIFICATION');
1425: If ((l_mediaType is not null) AND (l_classification is not null)) THEN
1426: CCT_SERVERGROUPROUTING_PUB.Get_AppForClassification(l_classification
1427: ,l_mediaType

Line 1431: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SCREENPOPAPP',l_appName);

1427: ,l_mediaType
1428: ,l_appID
1429: ,l_appName);
1430: If (l_appName is not Null) Then
1431: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SCREENPOPAPP',l_appName);
1432: resultout:=wf_engine.eng_completed||':'||l_appName;
1433: End If;
1434: End if;
1435: End if;

Line 1432: resultout:=wf_engine.eng_completed||':'||l_appName;

1428: ,l_appID
1429: ,l_appName);
1430: If (l_appName is not Null) Then
1431: WF_ENGINE.SetItemAttrText(itemtype,itemkey,'SCREENPOPAPP',l_appName);
1432: resultout:=wf_engine.eng_completed||':'||l_appName;
1433: End If;
1434: End if;
1435: End if;
1436: Exception