DBA Data[Home] [Help]

APPS.IEX_CO_WF dependencies on WF_ENGINE

Line 28: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,

24: WHERE ida.delinquency_id = cp_delinquency_id
25: AND ida.case_id = ico.cas_id;
26: BEGIN
27: if (funcmode = 'RUN') then
28: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
29: itemkey => itemkey,
30: aname => 'DELINQUENCY_ID');
31:
32: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

Line 80: --resultout := wf_engine.eng_completed ||':'||wf_no;

76: --
77: end if;
78: EXCEPTION
79: when others then
80: --resultout := wf_engine.eng_completed ||':'||wf_no;
81: wf_core.context('IEX_CO_WF','notify_customer',itemtype,
82: itemkey,to_char(actid),funcmode);
83: raise;
84: END notify_customer;

Line 108: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,

104: WHERE ida.delinquency_id = cp_delinquency_id
105: AND ida.case_id = ico.cas_id;
106: BEGIN
107: if (funcmode = 'RUN') then
108: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
109: itemkey => itemkey,
110: aname => 'DELINQUENCY_ID');
111:
112: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

Line 160: --resultout := wf_engine.eng_completed ||':'||wf_no;

156: --
157: end if;
158: EXCEPTION
159: when others then
160: --resultout := wf_engine.eng_completed ||':'||wf_no;
161: wf_core.context('IEX_CO_WF','report_customer',itemtype,
162: itemkey,to_char(actid),funcmode);
163: raise;
164: END report_customer;

Line 188: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,

184: WHERE ida.delinquency_id = cp_delinquency_id
185: AND ida.case_id = ico.cas_id;
186: BEGIN
187: if (funcmode = 'RUN') then
188: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'DELINQUENCY_ID');
191:
192: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

Line 240: --resultout := wf_engine.eng_completed ||':'||wf_no;

236: --
237: end if;
238: EXCEPTION
239: when others then
240: --resultout := wf_engine.eng_completed ||':'||wf_no;
241: wf_core.context('IEX_CO_WF','transfer_case',itemtype,
242: itemkey,to_char(actid),funcmode);
243: raise;
244: END transfer_case;

Line 291: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,

287: l_iohv_rec iex_open_interface_pub.iohv_rec_type;
288: lx_iohv_rec iex_open_interface_pub.iohv_rec_type;
289: BEGIN
290: if (funcmode = 'RUN') then
291: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
292: itemkey => itemkey,
293: aname => 'DELINQUENCY_ID');
294:
295: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

Line 349: --resultout := wf_engine.eng_completed ||':'||wf_no;

345: --
346: end if;
347: EXCEPTION
348: when others then
349: --resultout := wf_engine.eng_completed ||':'||wf_no;
350: wf_core.context('IEX_CO_WF','review_case',itemtype,
351: itemkey,to_char(actid),funcmode);
352: raise;
353: END review_case;

Line 395: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,

391: l_iohv_rec iex_open_interface_pub.iohv_rec_type;
392: lx_iohv_rec iex_open_interface_pub.iohv_rec_type;
393: BEGIN
394: if (funcmode = 'RUN') then
395: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'DELINQUENCY_ID');
398:
399: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

Line 446: --resultout := wf_engine.eng_completed ||':'||wf_no;

442: --
443: end if;
444: EXCEPTION
445: when others then
446: --resultout := wf_engine.eng_completed ||':'||wf_no;
447: wf_core.context('IEX_CO_WF','recall_case',itemtype,
448: itemkey,to_char(actid),funcmode);
449: raise;
450: END recall_case;

Line 479: result := wf_engine.eng_null;

475: i number;
476: l_error VARCHAR2(32767);
477: Begin
478: if funcmode <> 'RUN' then
479: result := wf_engine.eng_null;
480: return;
481: end if;
482:
483: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 483: l_work_item_id := wf_engine.GetItemAttrNumber(

479: result := wf_engine.eng_null;
480: return;
481: end if;
482:
483: l_work_item_id := wf_engine.GetItemAttrNumber(
484: itemtype => itemtype,
485: itemkey => itemkey,
486: aname => 'WORK_ITEMID');
487:

Line 488: l_strategy_id := wf_engine.GetItemAttrNumber(

484: itemtype => itemtype,
485: itemkey => itemkey,
486: aname => 'WORK_ITEMID');
487:
488: l_strategy_id := wf_engine.GetItemAttrNumber(
489: itemtype => itemtype,
490: itemkey => itemkey,
491: aname => 'STRATEGY_ID');
492:

Line 518: result := wf_engine.eng_completed;

514:
515: end if; -- if update is succcessful;
516: end if;
517:
518: result := wf_engine.eng_completed;
519:
520: EXCEPTION
521: when others then
522: FOR i in 1..fnd_msg_pub.count_msg() LOOP

Line 565: result := wf_engine.eng_null;

561: i number;
562: l_error VARCHAR2(32767);
563: Begin
564: if funcmode <> 'RUN' then
565: result := wf_engine.eng_null;
566: return;
567: end if;
568:
569: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 569: l_work_item_id := wf_engine.GetItemAttrNumber(

565: result := wf_engine.eng_null;
566: return;
567: end if;
568:
569: l_work_item_id := wf_engine.GetItemAttrNumber(
570: itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'WORK_ITEMID');
573:

Line 574: l_strategy_id := wf_engine.GetItemAttrNumber(

570: itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'WORK_ITEMID');
573:
574: l_strategy_id := wf_engine.GetItemAttrNumber(
575: itemtype => itemtype,
576: itemkey => itemkey,
577: aname => 'STRATEGY_ID');
578:

Line 604: result := wf_engine.eng_completed;

600:
601: end if; -- if update is succcessful;
602: end if;
603:
604: result := wf_engine.eng_completed;
605:
606: EXCEPTION
607: when others then
608: FOR i in 1..fnd_msg_pub.count_msg() LOOP

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

646: l_key := l_event_name ||l_seq ;
647:
648:
649: --Code for starting a workflow starts here
650: wf_engine.createprocess(itemtype => l_itemtype,
651: itemkey => l_key,
652: process =>'IEX:STRATEGY_CUSTOM_WORKFLOW');
653:
654:

Line 655: wf_engine.SetItemAttrText(itemtype => l_itemtype,

651: itemkey => l_key,
652: process =>'IEX:STRATEGY_CUSTOM_WORKFLOW');
653:
654:
655: wf_engine.SetItemAttrText(itemtype => l_itemtype,
656: itemkey => l_key,
657: aname => 'DELINQUENCY_ID',
658: avalue => p_delinquency_id);
659:

Line 660: wf_engine.SetItemAttrText(itemtype => l_itemtype,

656: itemkey => l_key,
657: aname => 'DELINQUENCY_ID',
658: avalue => p_delinquency_id);
659:
660: wf_engine.SetItemAttrText(itemtype => l_itemtype,
661: itemkey => l_key,
662: aname => 'PARTY_NAME',
663: avalue => 'Pradeep Gomes');
664:

Line 665: wf_engine.SetItemAttrText(itemtype => l_itemtype,

661: itemkey => l_key,
662: aname => 'PARTY_NAME',
663: avalue => 'Pradeep Gomes');
664:
665: wf_engine.SetItemAttrText(itemtype => l_itemtype,
666: itemkey => l_key,
667: aname => 'NOTIFICATION_USERNAME',
668: avalue => 'ADMIN');
669:

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

666: itemkey => l_key,
667: aname => 'NOTIFICATION_USERNAME',
668: avalue => 'ADMIN');
669:
670: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
671: itemkey => l_key,
672: aname => 'STRATEGY_ID',
673: avalue => 10128);
674:

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

671: itemkey => l_key,
672: aname => 'STRATEGY_ID',
673: avalue => 10128);
674:
675: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
676: itemkey => l_key,
677: aname => 'WORK_ITEMID',
678: avalue => 10219);
679:

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

676: itemkey => l_key,
677: aname => 'WORK_ITEMID',
678: avalue => 10219);
679:
680: wf_engine.startprocess(itemtype => l_itemtype,
681: itemkey => l_key);
682: --Code for ending a workflow starts here
683:
684: --Code for raising an event starts here