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.CCT_CUSTOMERINIT_PUB dependencies on WF_ENGINE

Line 38: resultout := wf_engine.eng_null;

34: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
35: BEGIN
36:
37: IF (funmode <> 'RUN') THEN
38: resultout := wf_engine.eng_null;
39: return;
40: end if;
41:
42: -- set default result

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

39: return;
40: end if;
41:
42: -- set default result
43: resultout := wf_engine.eng_completed || ':N';
44:
45: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
46: --dbms_output.put_line('PartyIDExists?'||to_char(l_party_id));
47: if (l_party_id IS NOT NULL) then

Line 45: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

41:
42: -- set default result
43: resultout := wf_engine.eng_completed || ':N';
44:
45: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
46: --dbms_output.put_line('PartyIDExists?'||to_char(l_party_id));
47: if (l_party_id IS NOT NULL) then
48: resultout := wf_engine.eng_completed || ':Y';
49: end if;

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

44:
45: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
46: --dbms_output.put_line('PartyIDExists?'||to_char(l_party_id));
47: if (l_party_id IS NOT NULL) then
48: resultout := wf_engine.eng_completed || ':Y';
49: end if;
50:
51: EXCEPTION
52: WHEN OTHERS THEN

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

96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
97: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
98: BEGIN
99: -- set default result
100: resultout := wf_engine.eng_completed || ':N';
101:
102: IF (funmode = 'RUN') THEN
103: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
104:

Line 103: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

99: -- set default result
100: resultout := wf_engine.eng_completed || ':N';
101:
102: IF (funmode = 'RUN') THEN
103: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
104:
105: --dbms_output.put_line('PartyIDfromANI? ANI='||l_app_object_value);
106: if (l_app_object_Value IS NOT NULL) THEN
107: -- Call the API provided by AST

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

112: --dbms_output.put_line('PartyIDfromANI? partyid='||to_char(l_party_id));
113: -- if a customer id is returned
114: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
115: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
116: resultout := wf_engine.eng_completed || ':Y';
117:
118: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
119: l_Party_ID );
120: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 118: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

114: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
115: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
116: resultout := wf_engine.eng_completed || ':Y';
117:
118: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
119: l_Party_ID );
120: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
121: END IF;
122: End IF;

Line 120: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

116: resultout := wf_engine.eng_completed || ':Y';
117:
118: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
119: l_Party_ID );
120: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
121: END IF;
122: End IF;
123: END IF;
124:

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

166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
167: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
168: BEGIN
169: -- set default result
170: resultout := wf_engine.eng_completed || ':N';
171:
172: IF (funmode = 'RUN') THEN
173: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
174:

Line 173: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

169: -- set default result
170: resultout := wf_engine.eng_completed || ':N';
171:
172: IF (funmode = 'RUN') THEN
173: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
174:
175: if (l_app_object_Value IS NOT NULL) THEN
176: -- Call the API provided by AST
177: l_party_ID:=CSC_ROUTING_UTL.Get_Customer_From_ANI

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

180: -- if a customer id is returned
181: IF (l_Party_ID IS NOT NULL) THEN
182: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
183: ( p_party_id => l_party_ID ) ;
184: resultout := wf_engine.eng_completed || ':Y';
185: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
186: l_Party_ID );
187: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
188: END IF;

Line 185: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

181: IF (l_Party_ID IS NOT NULL) THEN
182: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
183: ( p_party_id => l_party_ID ) ;
184: resultout := wf_engine.eng_completed || ':Y';
185: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
186: l_Party_ID );
187: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
188: END IF;
189: End IF;

Line 187: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

183: ( p_party_id => l_party_ID ) ;
184: resultout := wf_engine.eng_completed || ':Y';
185: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
186: l_Party_ID );
187: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
188: END IF;
189: End IF;
190: END IF;
191:

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

229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
230: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
231: BEGIN
232: -- set default result
233: resultout := wf_engine.eng_completed || ':N';
234:
235: --dbms_output.put_line('PartyNum2PartyID?start');
236: IF (funmode = 'RUN') THEN
237: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

Line 237: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

233: resultout := wf_engine.eng_completed || ':N';
234:
235: --dbms_output.put_line('PartyNum2PartyID?start');
236: IF (funmode = 'RUN') THEN
237: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
238: --dbms_output.put_line('PartyNum2PartyID?PNum='||l_app_object_value);
239:
240: if (l_app_object_Value IS NOT NULL) THEN
241: -- Call the API provided by AST

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

245:
246: -- if a customer id is returned
247: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
248: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
249: resultout := wf_engine.eng_completed || ':Y';
250:
251: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
252: l_Party_ID );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 251: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

247: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
248: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
249: resultout := wf_engine.eng_completed || ':Y';
250:
251: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
252: l_Party_ID );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
254: END IF;
255: End IF;

Line 253: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

249: resultout := wf_engine.eng_completed || ':Y';
250:
251: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
252: l_Party_ID );
253: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
254: END IF;
255: End IF;
256: END IF;
257:

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

296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
297: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
298: BEGIN
299: -- set default result
300: resultout := wf_engine.eng_completed || ':N';
301:
302: IF (funmode = 'RUN') THEN
303: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
304:

Line 303: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

299: -- set default result
300: resultout := wf_engine.eng_completed || ':N';
301:
302: IF (funmode = 'RUN') THEN
303: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
304:
305: if (l_app_object_Value IS NOT NULL) THEN
306: -- Call the API provided by AST
307:

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

310:
311: -- if a customer id is returned
312: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
313: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
314: resultout := wf_engine.eng_completed || ':Y';
315:
316: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
317: l_Party_ID );
318: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 316: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

312: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
313: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
314: resultout := wf_engine.eng_completed || ':Y';
315:
316: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
317: l_Party_ID );
318: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
319: END IF;
320: End IF;

Line 318: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

314: resultout := wf_engine.eng_completed || ':Y';
315:
316: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
317: l_Party_ID );
318: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
319: END IF;
320: End IF;
321: END IF;
322:

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

359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
360: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
361: BEGIN
362: -- set default result
363: resultout := wf_engine.eng_completed || ':N';
364:
365: IF (funmode = 'RUN') THEN
366: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
367:

Line 366: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

362: -- set default result
363: resultout := wf_engine.eng_completed || ':N';
364:
365: IF (funmode = 'RUN') THEN
366: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
367:
368: if (l_app_object_Value IS NOT NULL) THEN
369: -- Call the API provided by AST
370:

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

373:
374: -- if a customer id is returned
375: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
376: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
377: resultout := wf_engine.eng_completed || ':Y';
378:
379: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
380: l_Party_ID );
381: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 379: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

375: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
376: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
377: resultout := wf_engine.eng_completed || ':Y';
378:
379: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
380: l_Party_ID );
381: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
382: END IF;
383: End IF;

Line 381: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

377: resultout := wf_engine.eng_completed || ':Y';
378:
379: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
380: l_Party_ID );
381: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
382: END IF;
383: End IF;
384: END IF;
385:

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

423: l_party_name VARCHAR2(255);
424: l_Party_ID NUMBER;
425: BEGIN
426: -- set default result
427: resultout := wf_engine.eng_completed || ':N';
428:
429: IF (funmode = 'RUN') THEN
430: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
431:

Line 430: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

426: -- set default result
427: resultout := wf_engine.eng_completed || ':N';
428:
429: IF (funmode = 'RUN') THEN
430: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
431:
432: if (l_app_object_Value IS NOT NULL) THEN
433: -- Call the API provided by AST
434:

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

437:
438: -- if a customer id is returned
439: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
440: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
441: resultout := wf_engine.eng_completed || ':Y';
442:
443: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
444: l_Party_ID );
445: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 443: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

439: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
440: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
441: resultout := wf_engine.eng_completed || ':Y';
442:
443: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
444: l_Party_ID );
445: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
446: END IF;
447: End IF;

Line 445: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

441: resultout := wf_engine.eng_completed || ':Y';
442:
443: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
444: l_Party_ID );
445: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
446: END IF;
447: End IF;
448: END IF;
449:

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

486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
487: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
488: BEGIN
489: -- set default result
490: resultout := wf_engine.eng_completed || ':N';
491:
492: IF (funmode = 'RUN') THEN
493: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
494:

Line 493: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

489: -- set default result
490: resultout := wf_engine.eng_completed || ':N';
491:
492: IF (funmode = 'RUN') THEN
493: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
494:
495: if (l_app_object_Value IS NOT NULL) THEN
496: -- Call the API provided by AST
497:

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

500:
501: -- if a customer id is returned
502: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
503: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
504: resultout := wf_engine.eng_completed || ':Y';
505:
506: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
507: l_Party_ID );
508: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 506: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

502: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
503: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
504: resultout := wf_engine.eng_completed || ':Y';
505:
506: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
507: l_Party_ID );
508: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
509: END IF;
510: End IF;

Line 508: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

504: resultout := wf_engine.eng_completed || ':Y';
505:
506: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
507: l_Party_ID );
508: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
509: END IF;
510: End IF;
511: END IF;
512:

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

549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
550: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
551: BEGIN
552: -- set default result
553: resultout := wf_engine.eng_completed || ':N';
554:
555: IF (funmode = 'RUN') THEN
556: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
557:

Line 556: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

552: -- set default result
553: resultout := wf_engine.eng_completed || ':N';
554:
555: IF (funmode = 'RUN') THEN
556: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
557:
558: if (l_app_object_Value IS NOT NULL) THEN
559: -- Call the API provided by AST
560:

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

563:
564: -- if a customer id is returned
565: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
566: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
567: resultout := wf_engine.eng_completed || ':Y';
568:
569: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
570: l_Party_ID );
571: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 569: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

565: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
566: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
567: resultout := wf_engine.eng_completed || ':Y';
568:
569: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
570: l_Party_ID );
571: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
572: END IF;
573: End IF;

Line 571: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

567: resultout := wf_engine.eng_completed || ':Y';
568:
569: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
570: l_Party_ID );
571: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
572: END IF;
573: End IF;
574: END IF;
575:

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

612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
613: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
614: BEGIN
615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';
617:
618: IF (funmode = 'RUN') THEN
619: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
620:

Line 619: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';
617:
618: IF (funmode = 'RUN') THEN
619: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
620:
621: if (l_app_object_Value IS NOT NULL) THEN
622: -- Call the API provided by AST
623:

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

626:
627: -- if a customer id is returned
628: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
629: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
630: resultout := wf_engine.eng_completed || ':Y';
631:
632: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
633: l_Party_ID );
634: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 632: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

628: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
629: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
630: resultout := wf_engine.eng_completed || ':Y';
631:
632: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
633: l_Party_ID );
634: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
635: END IF;
636: End IF;

Line 634: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

630: resultout := wf_engine.eng_completed || ':Y';
631:
632: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
633: l_Party_ID );
634: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
635: END IF;
636: End IF;
637: END IF;
638:

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

677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
678: l_cct_object_type2 VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER;
679: BEGIN
680: -- set default result
681: resultout := wf_engine.eng_completed || ':N';
682:
683: IF (funmode = 'RUN') THEN
684: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
685: l_app_object_Value2 := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type2));

Line 684: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

680: -- set default result
681: resultout := wf_engine.eng_completed || ':N';
682:
683: IF (funmode = 'RUN') THEN
684: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
685: l_app_object_Value2 := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type2));
686:
687: if (l_app_object_Value IS NOT NULL) THEN
688: -- Call the API provided by AST

Line 685: l_app_object_Value2 := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type2));

681: resultout := wf_engine.eng_completed || ':N';
682:
683: IF (funmode = 'RUN') THEN
684: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
685: l_app_object_Value2 := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type2));
686:
687: if (l_app_object_Value IS NOT NULL) THEN
688: -- Call the API provided by AST
689:

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

692:
693: -- if a customer id is returned
694: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
695: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
696: resultout := wf_engine.eng_completed || ':Y';
697:
698: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
699: l_Party_ID );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 698: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

694: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
695: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
696: resultout := wf_engine.eng_completed || ':Y';
697:
698: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
699: l_Party_ID );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
701: END IF;
702: End IF;

Line 700: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

696: resultout := wf_engine.eng_completed || ':Y';
697:
698: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
699: l_Party_ID );
700: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
701: END IF;
702: End IF;
703: END IF;
704:

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

740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
741: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
742: BEGIN
743: -- set default result
744: resultout := wf_engine.eng_completed || ':N';
745:
746: IF (funmode = 'RUN') THEN
747: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
748:

Line 747: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

743: -- set default result
744: resultout := wf_engine.eng_completed || ':N';
745:
746: IF (funmode = 'RUN') THEN
747: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
748:
749: if (l_app_object_Value IS NOT NULL) THEN
750: -- Call the API provided by AST
751:

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

754:
755: -- if a customer id is returned
756: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
757: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
758: resultout := wf_engine.eng_completed || ':Y';
759:
760: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
761: l_Party_ID );
762: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 760: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

756: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
757: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
758: resultout := wf_engine.eng_completed || ':Y';
759:
760: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
761: l_Party_ID );
762: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
763: END IF;
764: End IF;

Line 762: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

758: resultout := wf_engine.eng_completed || ':Y';
759:
760: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
761: l_Party_ID );
762: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
763: END IF;
764: End IF;
765: END IF;
766:

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

803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
804: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
805: BEGIN
806: -- set default result
807: resultout := wf_engine.eng_completed || ':N';
808:
809: IF (funmode = 'RUN') THEN
810: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
811:

Line 810: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

806: -- set default result
807: resultout := wf_engine.eng_completed || ':N';
808:
809: IF (funmode = 'RUN') THEN
810: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
811:
812: if (l_app_object_Value IS NOT NULL) THEN
813: -- Call the API provided by AST
814:

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

817:
818: -- if a customer id is returned
819: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
820: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
821: resultout := wf_engine.eng_completed || ':Y';
822:
823: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
824: l_Party_ID );
825: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

Line 823: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

819: IF ((l_Party_ID <> AST_ROUTING_PUB.G_NO_PARTY) AND
820: (l_party_id <> AST_ROUTING_PUB.G_MULTIPLE_PARTY)) THEN
821: resultout := wf_engine.eng_completed || ':Y';
822:
823: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
824: l_Party_ID );
825: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
826: END IF;
827: End IF;

Line 825: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

821: resultout := wf_engine.eng_completed || ':Y';
822:
823: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
824: l_Party_ID );
825: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
826: END IF;
827: End IF;
828: END IF;
829:

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

867: l_app_object_type VARCHAR2(64):='INVOICE_NUMBER';
868: l_cct_object_type VARCHAR2(64):='INVOICENUM';
869: BEGIN
870: -- set default result
871: resultout := wf_engine.eng_completed || ':N';
872:
873: IF (funmode = 'RUN') THEN
874: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
875:

Line 874: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

870: -- set default result
871: resultout := wf_engine.eng_completed || ':N';
872:
873: IF (funmode = 'RUN') THEN
874: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
875:
876: if (l_app_object_Value IS NOT NULL) THEN
877: -- Call the API provided by CSC
878: l_party_ID:=CSC_ROUTING_UTL.Get_Customer_From_InvoiceNum

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

881: -- if a customer id is returned
882: IF (l_Party_ID is not null) THEN
883: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
884: ( p_party_id => l_party_ID ) ;
885: resultout := wf_engine.eng_completed || ':Y';
886: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
887: l_Party_ID );
888: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
889: END IF;

Line 886: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

882: IF (l_Party_ID is not null) THEN
883: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
884: ( p_party_id => l_party_ID ) ;
885: resultout := wf_engine.eng_completed || ':Y';
886: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
887: l_Party_ID );
888: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
889: END IF;
890: End IF;

Line 888: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

884: ( p_party_id => l_party_ID ) ;
885: resultout := wf_engine.eng_completed || ':Y';
886: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
887: l_Party_ID );
888: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
889: END IF;
890: End IF;
891: END IF;
892:

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

930: l_app_object_type VARCHAR2(64):='SERIAL_NUMBER';
931: l_cct_object_type VARCHAR2(64):='SERIALNUM';
932: BEGIN
933: -- set default result
934: resultout := wf_engine.eng_completed || ':N';
935:
936: IF (funmode = 'RUN') THEN
937: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
938:

Line 937: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

933: -- set default result
934: resultout := wf_engine.eng_completed || ':N';
935:
936: IF (funmode = 'RUN') THEN
937: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
938:
939: if (l_app_object_Value IS NOT NULL) THEN
940: -- Call the API provided by CSC
941: l_party_ID:=CS_ROUTING_UTL.Get_Customer_From_SerialNum

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

944: -- if a customer id is returned
945: IF (l_Party_ID is not null) THEN
946: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
947: ( p_party_id => l_party_ID ) ;
948: resultout := wf_engine.eng_completed || ':Y';
949: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
950: l_Party_ID );
951: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
952: END IF;

Line 949: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

945: IF (l_Party_ID is not null) THEN
946: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
947: ( p_party_id => l_party_ID ) ;
948: resultout := wf_engine.eng_completed || ':Y';
949: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
950: l_Party_ID );
951: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
952: END IF;
953: End IF;

Line 951: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

947: ( p_party_id => l_party_ID ) ;
948: resultout := wf_engine.eng_completed || ':Y';
949: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
950: l_Party_ID );
951: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
952: END IF;
953: End IF;
954: END IF;
955:

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

993: l_app_object_type VARCHAR2(64):='SYSTEM_NAME';
994: l_cct_object_type VARCHAR2(64):='SYSTEMNAME';
995: BEGIN
996: -- set default result
997: resultout := wf_engine.eng_completed || ':N';
998:
999: IF (funmode = 'RUN') THEN
1000: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
1001:

Line 1000: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

996: -- set default result
997: resultout := wf_engine.eng_completed || ':N';
998:
999: IF (funmode = 'RUN') THEN
1000: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
1001:
1002: if (l_app_object_Value IS NOT NULL) THEN
1003: -- Call the API provided by CSC
1004: l_party_ID:=CS_ROUTING_UTL.Get_Customer_From_System_Name

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

1007: -- if a customer id is returned
1008: IF (l_Party_ID is not null) THEN
1009: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
1010: ( p_party_id => l_party_ID ) ;
1011: resultout := wf_engine.eng_completed || ':Y';
1012: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1013: l_Party_ID );
1014: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1015: END IF;

Line 1012: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

1008: IF (l_Party_ID is not null) THEN
1009: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
1010: ( p_party_id => l_party_ID ) ;
1011: resultout := wf_engine.eng_completed || ':Y';
1012: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1013: l_Party_ID );
1014: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1015: END IF;
1016: End IF;

Line 1014: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

1010: ( p_party_id => l_party_ID ) ;
1011: resultout := wf_engine.eng_completed || ':Y';
1012: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1013: l_Party_ID );
1014: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1015: END IF;
1016: End IF;
1017: END IF;
1018:

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

1055: l_app_object_type VARCHAR2(64):='PARTY_ID';
1056: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
1057: BEGIN
1058: -- set default result
1059: resultout := wf_engine.eng_completed || ':N';
1060:
1061: IF (funmode = 'RUN') THEN
1062: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
1063:

Line 1062: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));

1058: -- set default result
1059: resultout := wf_engine.eng_completed || ':N';
1060:
1061: IF (funmode = 'RUN') THEN
1062: l_app_object_Value := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_object_Type));
1063:
1064: if (l_app_object_Value IS NOT NULL) THEN
1065: l_party_id:=l_app_object_value;
1066:

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

1067: -- if a customer id is returned
1068: IF (l_Party_ID is not null) THEN
1069: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
1070: ( p_party_id => l_party_ID ) ;
1071: resultout := wf_engine.eng_completed || ':Y';
1072: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1073: l_Party_ID );
1074: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1075: END IF;

Line 1072: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),

1068: IF (l_Party_ID is not null) THEN
1069: l_party_name:=CSC_ROUTING_UTL.Get_Name_Of_Customer
1070: ( p_party_id => l_party_ID ) ;
1071: resultout := wf_engine.eng_completed || ':Y';
1072: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1073: l_Party_ID );
1074: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1075: END IF;
1076: End IF;

Line 1074: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);

1070: ( p_party_id => l_party_ID ) ;
1071: resultout := wf_engine.eng_completed || ':Y';
1072: WF_ENGINE.SetItemAttrNumber( itemtype,itemkey,upper(l_cct_party_id_key),
1073: l_Party_ID );
1074: WF_ENGINE.SETITEMATTRTEXT(itemtype,itemkey,upper(l_cct_party_name_key),l_party_name);
1075: END IF;
1076: End IF;
1077: END IF;
1078: