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

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

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

Line 56: wf_engine.SetItemAttrDate (itemtype=> itemtype,

52: --l_report_after_days := 0.003;
53:
54: l_report_date := SYSDATE + l_report_after_days;
55:
56: wf_engine.SetItemAttrDate (itemtype=> itemtype,
57: itemkey => itemkey,
58: aname => 'REPORT_DATE',
59: avalue => l_report_date);
60: END IF;

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

58: aname => 'REPORT_DATE',
59: avalue => l_report_date);
60: END IF;
61:
62: wf_engine.SetItemAttrText (itemtype=> itemtype,
63: itemkey => itemkey,
64: aname => 'CASE_NUMBER',
65: avalue => l_case_number);
66:

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

64: aname => 'CASE_NUMBER',
65: avalue => l_case_number);
66:
67: /*
68: wf_engine.SetItemAttrText (itemtype=> itemtype,
69: itemkey => itemkey,
70: aname => 'NOTIFICATION_USERNAME',
71: avalue => l_notification_role);
72: */

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

92: end if;
93:
94: EXCEPTION
95: when others then
96: --resultout := wf_engine.eng_completed ||':'||wf_no;
97: wf_core.context('OKL_CO_WF','get_syndicate_flag',itemtype,
98: itemkey,to_char(actid),funcmode);
99: raise;
100: END get_syndicate_flag;

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

143: AND lease.contract_number = cp_contract_number;
144:
145: BEGIN
146: if (funcmode = 'RUN') then
147: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
148: itemkey => itemkey,
149: aname => 'DELINQUENCY_ID');
150:
151: --get sendto_third_party flag

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

198: end if;
199:
200: EXCEPTION
201: when others then
202: --resultout := wf_engine.eng_completed ||':'||wf_no;
203: wf_core.context('OKL_CO_WF','get_sendtothirdparty_flag',itemtype,
204: itemkey,to_char(actid),funcmode);
205: raise;
206: END get_sendtothirdparty_flag;

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

249: AND lease.contract_number = cp_contract_number;
250:
251: BEGIN
252: if (funcmode = 'RUN') then
253: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
254: itemkey => itemkey,
255: aname => 'DELINQUENCY_ID');
256:
257: --get vendorapproval flag

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

304: end if;
305:
306: EXCEPTION
307: when others then
308: --resultout := wf_engine.eng_completed ||':'||wf_no;
309: wf_core.context('OKL_CO_WF','get_vendorapproval_flag',itemtype,
310: itemkey,to_char(actid),funcmode);
311: raise;
312: END get_vendorapproval_flag;

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

355: AND lease.contract_number = cp_contract_number;
356:
357: BEGIN
358: if (funcmode = 'RUN') then
359: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
360: itemkey => itemkey,
361: aname => 'DELINQUENCY_ID');
362:
363: --get vendornotify flag

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

410: end if;
411:
412: EXCEPTION
413: when others then
414: --resultout := wf_engine.eng_completed ||':'||wf_no;
415: wf_core.context('OKL_CO_WF','get_vendorapproval_flag',itemtype,
416: itemkey,to_char(actid),funcmode);
417: raise;
418: END get_vendornotify_flag;

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

535: WHERE ida.delinquency_id = cp_delinquency_id
536: AND ida.case_id = ico.cas_id;
537: BEGIN
538: if (funcmode = 'RUN') then
539: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
540: itemkey => itemkey,
541: aname => 'DELINQUENCY_ID');
542:
543: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

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

587: --
588: end if;
589: EXCEPTION
590: when others then
591: --resultout := wf_engine.eng_completed ||':'||wf_no;
592: wf_core.context('OKL_CO_WF','notify_customer',itemtype,
593: itemkey,to_char(actid),funcmode);
594: raise;
595: END notify_customer;

Line 610: if funcmode <> wf_engine.eng_run then

606: l_result VARCHAR2(1);
607: l_value VARCHAR2(300);
608:
609: BEGIN
610: if funcmode <> wf_engine.eng_run then
611: resultout := wf_engine.eng_null;
612: return;
613: end if;
614:

Line 611: resultout := wf_engine.eng_null;

607: l_value VARCHAR2(300);
608:
609: BEGIN
610: if funcmode <> wf_engine.eng_run then
611: resultout := wf_engine.eng_null;
612: return;
613: end if;
614:
615: l_value :=wf_engine.GetActivityLabel(actid);

Line 615: l_value :=wf_engine.GetActivityLabel(actid);

611: resultout := wf_engine.eng_null;
612: return;
613: end if;
614:
615: l_value :=wf_engine.GetActivityLabel(actid);
616: wf_engine.SetItemAttrText(itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'ACTIVITY_NAME',
619: avalue => l_value);

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

612: return;
613: end if;
614:
615: l_value :=wf_engine.GetActivityLabel(actid);
616: wf_engine.SetItemAttrText(itemtype => itemtype,
617: itemkey => itemkey,
618: aname => 'ACTIVITY_NAME',
619: avalue => l_value);
620:

Line 621: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||

617: itemkey => itemkey,
618: aname => 'ACTIVITY_NAME',
619: avalue => l_value);
620:
621: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
622: ':'||wf_engine.eng_null;
623: exception
624: when others then
625: --resultout := wf_engine.eng_completed ||':'||wf_no;

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

618: aname => 'ACTIVITY_NAME',
619: avalue => l_value);
620:
621: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
622: ':'||wf_engine.eng_null;
623: exception
624: when others then
625: --resultout := wf_engine.eng_completed ||':'||wf_no;
626: wf_core.context('OKL_CO_WF','wait_before_report',itemtype,

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

621: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
622: ':'||wf_engine.eng_null;
623: exception
624: when others then
625: --resultout := wf_engine.eng_completed ||':'||wf_no;
626: wf_core.context('OKL_CO_WF','wait_before_report',itemtype,
627: itemkey,to_char(actid),funcmode);
628: raise;
629: END wait_before_report;

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

649: WHERE ida.delinquency_id = cp_delinquency_id
650: AND ida.case_id = ico.cas_id;
651: BEGIN
652: if (funcmode = 'RUN') then
653: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
654: itemkey => itemkey,
655: aname => 'DELINQUENCY_ID');
656:
657: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

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

701: --
702: end if;
703: EXCEPTION
704: when others then
705: --resultout := wf_engine.eng_completed ||':'||wf_no;
706: wf_core.context('OKL_CO_WF','report_customer',itemtype,
707: itemkey,to_char(actid),funcmode);
708: raise;
709: END report_customer;

Line 749: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,

745:
746: --get approval_email_from
747: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');
748:
749: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,
750: itemkey => itemkey,
751: aname => 'CASE_NUMBER');
752:
753: l_bind_var(1) := 'p_case_number';

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

759: x_vendor_name => l_vendor_name,
760: x_vendor_email => l_email,
761: x_return_status => l_return_status);
762:
763: wf_engine.SetItemAttrText (itemtype=> itemtype,
764: itemkey => itemkey,
765: aname => 'VENDOR_NAME',
766: avalue => l_vendor_name);
767:

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

814: --
815: end if;
816: EXCEPTION
817: when others then
818: --resultout := wf_engine.eng_completed ||':'||wf_no;
819: wf_core.context('OKL_CO_WF','send_vendor_approval',itemtype,
820: itemkey,to_char(actid),funcmode);
821: raise;
822: END send_vendor_approval;

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

842: WHERE ida.delinquency_id = cp_delinquency_id
843: AND ida.case_id = ico.cas_id;
844: BEGIN
845: if (funcmode = 'RUN') then
846: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
847: itemkey => itemkey,
848: aname => 'DELINQUENCY_ID');
849:
850: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

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

894: --
895: end if;
896: EXCEPTION
897: when others then
898: --resultout := wf_engine.eng_completed ||':'||wf_no;
899: wf_core.context('OKL_CO_WF','transfer_case',itemtype,
900: itemkey,to_char(actid),funcmode);
901: raise;
902: END transfer_case;

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

945: l_iohv_rec iex_open_interface_pub.iohv_rec_type;
946: lx_iohv_rec iex_open_interface_pub.iohv_rec_type;
947: BEGIN
948: if (funcmode = 'RUN') then
949: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
950: itemkey => itemkey,
951: aname => 'DELINQUENCY_ID');
952:
953: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

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

1003: --
1004: end if;
1005: EXCEPTION
1006: when others then
1007: --resultout := wf_engine.eng_completed ||':'||wf_no;
1008: wf_core.context('OKL_CO_WF','review_case',itemtype,
1009: itemkey,to_char(actid),funcmode);
1010: raise;
1011: END review_case;

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

1049: l_iohv_rec iex_open_interface_pub.iohv_rec_type;
1050: lx_iohv_rec iex_open_interface_pub.iohv_rec_type;
1051: BEGIN
1052: if (funcmode = 'RUN') then
1053: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1054: itemkey => itemkey,
1055: aname => 'DELINQUENCY_ID');
1056:
1057: FOR cur IN l_khr_csr(l_delinquency_id) LOOP

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

1100: --
1101: end if;
1102: EXCEPTION
1103: when others then
1104: --resultout := wf_engine.eng_completed ||':'||wf_no;
1105: wf_core.context('OKL_CO_WF','recall_case',itemtype,
1106: itemkey,to_char(actid),funcmode);
1107: raise;
1108: END recall_case;

Line 1151: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,

1147:
1148: --get subject
1149: l_from := fnd_profile.value('OKL_VND_NOTIFY_EMAIL_FROM');
1150:
1151: l_case_number := wf_engine.GetItemAttrText(itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'CASE_NUMBER');
1154:
1155: l_bind_var(1) := 'p_case_number';

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

1211: --
1212: end if;
1213: EXCEPTION
1214: when others then
1215: --resultout := wf_engine.eng_completed ||':'||wf_no;
1216: wf_core.context('OKL_CO_WF','send_vendor_notify',itemtype,
1217: itemkey,to_char(actid),funcmode);
1218: raise;
1219: END send_vendor_notify;

Line 1248: result := wf_engine.eng_null;

1244: i number;
1245: l_error VARCHAR2(32767);
1246: Begin
1247: if funcmode <> 'RUN' then
1248: result := wf_engine.eng_null;
1249: return;
1250: end if;
1251:
1252: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1252: l_work_item_id := wf_engine.GetItemAttrNumber(

1248: result := wf_engine.eng_null;
1249: return;
1250: end if;
1251:
1252: l_work_item_id := wf_engine.GetItemAttrNumber(
1253: itemtype => itemtype,
1254: itemkey => itemkey,
1255: aname => 'WORK_ITEMID');
1256:

Line 1257: l_strategy_id := wf_engine.GetItemAttrNumber(

1253: itemtype => itemtype,
1254: itemkey => itemkey,
1255: aname => 'WORK_ITEMID');
1256:
1257: l_strategy_id := wf_engine.GetItemAttrNumber(
1258: itemtype => itemtype,
1259: itemkey => itemkey,
1260: aname => 'STRATEGY_ID');
1261:

Line 1287: result := wf_engine.eng_completed;

1283:
1284: end if; -- if update is succcessful;
1285: end if;
1286:
1287: result := wf_engine.eng_completed;
1288:
1289: EXCEPTION
1290: when others then
1291: FOR i in 1..fnd_msg_pub.count_msg() LOOP

Line 1330: result := wf_engine.eng_null;

1326: i number;
1327: l_error VARCHAR2(32767);
1328: Begin
1329: if funcmode <> 'RUN' then
1330: result := wf_engine.eng_null;
1331: return;
1332: end if;
1333:
1334: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1334: l_work_item_id := wf_engine.GetItemAttrNumber(

1330: result := wf_engine.eng_null;
1331: return;
1332: end if;
1333:
1334: l_work_item_id := wf_engine.GetItemAttrNumber(
1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'WORK_ITEMID');
1338:

Line 1339: l_strategy_id := wf_engine.GetItemAttrNumber(

1335: itemtype => itemtype,
1336: itemkey => itemkey,
1337: aname => 'WORK_ITEMID');
1338:
1339: l_strategy_id := wf_engine.GetItemAttrNumber(
1340: itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'STRATEGY_ID');
1343:

Line 1369: result := wf_engine.eng_completed;

1365:
1366: end if; -- if update is succcessful;
1367: end if;
1368:
1369: result := wf_engine.eng_completed;
1370:
1371: EXCEPTION
1372: when others then
1373: FOR i in 1..fnd_msg_pub.count_msg() LOOP

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

1526: l_key := l_event_name ||l_seq ;
1527:
1528:
1529: --Code for starting a workflow starts here
1530: wf_engine.createprocess(itemtype => l_itemtype,
1531: itemkey => l_key,
1532: process =>'IEX:STRATEGY_CUSTOM_WORKFLOW');
1533:
1534:

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

1531: itemkey => l_key,
1532: process =>'IEX:STRATEGY_CUSTOM_WORKFLOW');
1533:
1534:
1535: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1536: itemkey => l_key,
1537: aname => 'DELINQUENCY_ID',
1538: avalue => p_delinquency_id);
1539:

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

1536: itemkey => l_key,
1537: aname => 'DELINQUENCY_ID',
1538: avalue => p_delinquency_id);
1539:
1540: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1541: itemkey => l_key,
1542: aname => 'PARTY_NAME',
1543: avalue => 'Pradeep Gomes');
1544:

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

1541: itemkey => l_key,
1542: aname => 'PARTY_NAME',
1543: avalue => 'Pradeep Gomes');
1544:
1545: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1546: itemkey => l_key,
1547: aname => 'NOTIFICATION_USERNAME',
1548: avalue => 'ADMIN');
1549:

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

1546: itemkey => l_key,
1547: aname => 'NOTIFICATION_USERNAME',
1548: avalue => 'ADMIN');
1549:
1550: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1551: itemkey => l_key,
1552: aname => 'WORK_ITEMID',
1553: avalue => 123456789012345678901234567890);
1554:

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

1551: itemkey => l_key,
1552: aname => 'WORK_ITEMID',
1553: avalue => 123456789012345678901234567890);
1554:
1555: wf_engine.startprocess(itemtype => l_itemtype,
1556: itemkey => l_key);
1557: --Code for ending a workflow starts here
1558:
1559: --Code for raising an event starts here