DBA Data[Home] [Help]

APPS.IEX_STRY_CUWF_PUB dependencies on WF_ENGINE

Line 125: wf_engine.SetItemAttrText(itemtype => itemtype,

121: get_username
122: ( p_resource_id =>p_resource_id,
123: x_username =>l_username);
124:
125: wf_engine.SetItemAttrText(itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'NOTIFICATION_USERNAME',
128: avalue => l_username);
129:

Line 181: wf_engine.SetItemAttrNumber(itemtype => itemtype,

177: -- has been already populated
178: FOR d_rec in c_get_delinquency(p_strategy_id)
179: LOOP
180:
181: wf_engine.SetItemAttrNumber(itemtype => itemtype,
182: itemkey => itemkey,
183: aname => 'DELINQUENCY_ID',
184: avalue => d_rec.delinquency_id);
185:

Line 186: wf_engine.SetItemAttrNumber(itemtype => itemtype,

182: itemkey => itemkey,
183: aname => 'DELINQUENCY_ID',
184: avalue => d_rec.delinquency_id);
185:
186: wf_engine.SetItemAttrNumber(itemtype => itemtype,
187: itemkey => itemkey,
188: aname => 'PARTY_ID',
189: avalue => d_rec.party_id);
190: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 190: wf_engine.SetItemAttrText(itemtype => itemtype,

186: wf_engine.SetItemAttrNumber(itemtype => itemtype,
187: itemkey => itemkey,
188: aname => 'PARTY_ID',
189: avalue => d_rec.party_id);
190: wf_engine.SetItemAttrText(itemtype => itemtype,
191: itemkey => itemkey,
192: aname => 'PARTY_TYPE',
193: avalue => d_rec.party_type);
194:

Line 195: wf_engine.SetItemAttrText(itemtype => itemtype,

191: itemkey => itemkey,
192: aname => 'PARTY_TYPE',
193: avalue => d_rec.party_type);
194:
195: wf_engine.SetItemAttrText(itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'PARTY_NAME',
198: avalue => d_rec.party_name);
199:

Line 200: wf_engine.SetItemAttrNumber(itemtype => itemtype,

196: itemkey => itemkey,
197: aname => 'PARTY_NAME',
198: avalue => d_rec.party_name);
199:
200: wf_engine.SetItemAttrNumber(itemtype => itemtype,
201: itemkey => itemkey,
202: aname => 'CUST_ACCOUNT_ID',
203: avalue => d_rec.cust_account_id);
204:

Line 205: wf_engine.SetItemAttrText(itemtype => itemtype,

201: itemkey => itemkey,
202: aname => 'CUST_ACCOUNT_ID',
203: avalue => d_rec.cust_account_id);
204:
205: wf_engine.SetItemAttrText(itemtype => itemtype,
206: itemkey => itemkey,
207: aname => 'DELINQUENCY_STATUS',
208: avalue => d_rec.status);
209:

Line 210: wf_engine.SetItemAttrNumber(itemtype => itemtype,

206: itemkey => itemkey,
207: aname => 'DELINQUENCY_STATUS',
208: avalue => d_rec.status);
209:
210: wf_engine.SetItemAttrNumber(itemtype => itemtype,
211: itemkey => itemkey,
212: aname => 'AGING_BUCKET_LINE_ID',
213: avalue => d_rec.aging_bucket_LINE_id);
214:

Line 215: wf_engine.SetItemAttrNumber(itemtype => itemtype,

211: itemkey => itemkey,
212: aname => 'AGING_BUCKET_LINE_ID',
213: avalue => d_rec.aging_bucket_LINE_id);
214:
215: wf_engine.SetItemAttrNumber(itemtype => itemtype,
216: itemkey => itemkey,
217: aname => 'PAYMENT_SCHEDULE_ID',
218: avalue => d_rec.payment_schedule_id);
219:

Line 222: wf_engine.SetItemAttrNumber(itemtype => itemtype,

218: avalue => d_rec.payment_schedule_id);
219:
220: FOR p_rec in c_get_payment(d_rec.delinquency_id)
221: LOOP
222: wf_engine.SetItemAttrNumber(itemtype => itemtype,
223: itemkey => itemkey,
224: aname => 'OVERDUE_AMOUNT',
225: avalue => p_rec.amount_due_remaining);
226: END LOOP;

Line 392: wf_engine.createprocess(itemtype => l_itemtype,

388: -- but inthe selector function we have to pass the process name if it is 'RUN' mode
389: -- so we are passing the process name.
390:
391:
392: wf_engine.createprocess(itemtype => l_itemtype,
393: itemkey => l_itemkey,
394: process =>'IEX_STRATEGY_CUSTOM_WORKFLOW');
395:
396: -- IF PG_DEBUG < 10 THEN

Line 401: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

397: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
398: iex_debug_pub.logmessage ('populate_attributes: ' || ' after create workflow process');
399: END IF;
400:
401: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
402: itemkey => l_itemkey,
403: aname => 'STRATEGY_ID',
404: avalue => p_Custom_WF_rec.strategy_id);
405:

Line 406: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

402: itemkey => l_itemkey,
403: aname => 'STRATEGY_ID',
404: avalue => p_Custom_WF_rec.strategy_id);
405:
406: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
407: itemkey => l_itemkey,
408: aname => 'WORK_ITEMID',
409: avalue => p_Custom_WF_rec.workitem_id);
410:

Line 413: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

409: avalue => p_Custom_WF_rec.workitem_id);
410:
411:
412:
413: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
414: itemkey => l_itemkey,
415: aname => 'USER_ID',
416: avalue => p_Custom_WF_rec.user_id);
417:

Line 419: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

415: aname => 'USER_ID',
416: avalue => p_Custom_WF_rec.user_id);
417:
418:
419: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
420: itemkey => l_itemkey,
421: aname => 'RESP_ID',
422: avalue => p_Custom_WF_rec.resp_id);
423:

Line 425: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

421: aname => 'RESP_ID',
422: avalue => p_Custom_WF_rec.resp_id);
423:
424:
425: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
426: itemkey => l_itemkey,
427: aname => 'RESP_APPL_ID',
428: avalue => p_Custom_WF_rec.resp_appl_id);
429:

Line 439: wf_engine.SetItemAttrDate(itemtype => l_itemtype,

435: (p_date =>SYSDATE,
436: l_UOM =>'MIN', -- changed for bug 7631756 PNAVEENK
437: l_UNIT =>10);
438:
439: wf_engine.SetItemAttrDate(itemtype => l_itemtype,
440: itemkey => l_itemkey,
441: aname => 'WAIT_PERIOD',
442: avalue => p_wait_date);
443:

Line 476: wf_engine.startprocess(itemtype => l_itemtype,

472: iex_debug_pub.logmessage (' before start workflow process');
473: END IF;
474:
475:
476: wf_engine.startprocess(itemtype => l_itemtype,
477: itemkey => l_itemkey);
478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: iex_debug_pub.logmessage (' after start workflow process');
480: END IF;

Line 482: wf_engine.ItemStatus(

478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: iex_debug_pub.logmessage (' after start workflow process');
480: END IF;
481:
482: wf_engine.ItemStatus(
483: itemtype => l_itemType,
484: itemkey => l_itemKey,
485: status => l_ret_status,
486: result => l_result);

Line 488: if (l_ret_status in (wf_engine.eng_completed, wf_engine.eng_active )) THEN

484: itemkey => l_itemKey,
485: status => l_ret_status,
486: result => l_result);
487:
488: if (l_ret_status in (wf_engine.eng_completed, wf_engine.eng_active )) THEN
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490: else
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: end if;

Line 557: result := wf_engine.eng_null;

553: l_resp_appl_id NUMBER;
554:
555: Begin
556: if funcmode <> 'RUN' then
557: result := wf_engine.eng_null;
558: return;
559: end if;
560:
561: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 561: l_work_item_id := wf_engine.GetItemAttrNumber(

557: result := wf_engine.eng_null;
558: return;
559: end if;
560:
561: l_work_item_id := wf_engine.GetItemAttrNumber(
562: itemtype => itemtype,
563: itemkey => itemkey,
564: aname => 'WORK_ITEMID');
565:

Line 566: l_strategy_id := wf_engine.GetItemAttrNumber(

562: itemtype => itemtype,
563: itemkey => itemkey,
564: aname => 'WORK_ITEMID');
565:
566: l_strategy_id := wf_engine.GetItemAttrNumber(
567: itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'STRATEGY_ID');
570:

Line 571: l_user_id := wf_engine.GetItemAttrNumber(

567: itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'STRATEGY_ID');
570:
571: l_user_id := wf_engine.GetItemAttrNumber(
572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'USER_ID');
575:

Line 576: l_resp_id := wf_engine.GetItemAttrNumber(

572: itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'USER_ID');
575:
576: l_resp_id := wf_engine.GetItemAttrNumber(
577: itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'RESP_ID');
580:

Line 581: l_resp_appl_id := wf_engine.GetItemAttrNumber(

577: itemtype => itemtype,
578: itemkey => itemkey,
579: aname => 'RESP_ID');
580:
581: l_resp_appl_id := wf_engine.GetItemAttrNumber(
582: itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'RESP_APPL_ID');
585:

Line 622: result := wf_engine.eng_completed;

618:
619: end if; -- if update is succcessful;
620: end if;
621:
622: result := wf_engine.eng_completed;
623:
624: exception
625: WHEN EXC THEN
626: --pass the error message

Line 662: if funcmode <> wf_engine.eng_run then

658: BEGIN
659: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
660: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
661: END IF;
662: if funcmode <> wf_engine.eng_run then
663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
664: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
665: END IF;
666: result := wf_engine.eng_null;

Line 666: result := wf_engine.eng_null;

662: if funcmode <> wf_engine.eng_run then
663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
664: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
665: END IF;
666: result := wf_engine.eng_null;
667: return;
668: end if;
669:
670:

Line 675: /* l_value :=wf_engine.GetActivityLabel(actid);

671:
672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
674: END IF;
675: /* l_value :=wf_engine.GetActivityLabel(actid);
676: wf_engine.SetItemAttrText(itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'ACTIVITY_NAME',
679: avalue => l_value);

Line 676: wf_engine.SetItemAttrText(itemtype => itemtype,

672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
674: END IF;
675: /* l_value :=wf_engine.GetActivityLabel(actid);
676: wf_engine.SetItemAttrText(itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'ACTIVITY_NAME',
679: avalue => l_value);
680: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 685: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

681: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
682: END IF;*/
683:
684:
685: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
686: ':'||wf_engine.eng_null;
687: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
688: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
689: END IF;

Line 686: ':'||wf_engine.eng_null;

682: END IF;*/
683:
684:
685: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
686: ':'||wf_engine.eng_null;
687: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
688: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
689: END IF;
690: exception

Line 692: result := wf_engine.eng_completed ||':'||wf_no;

688: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
689: END IF;
690: exception
691: when others then
692: result := wf_engine.eng_completed ||':'||wf_no;
693: wf_core.context('IEX_STRY_CUWF_PUB','wait_on_hold_signal',itemtype,
694: itemkey,to_char(actid),funcmode);
695: raise;
696: