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_STRY_CALL_CO_PUB dependencies on WF_ENGINE

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

19: Begin
20:
21: select sysdate + 10/24/60 into l_wait_period from dual;
22:
23: wf_engine.SetItemAttrDate(itemtype => itemtype,
24: itemkey => itemkey,
25: aname => 'WAIT_PERIOD',
26: avalue => l_wait_period);
27:

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

102: get_username
103: ( p_resource_id =>p_resource_id,
104: x_username =>l_username);
105:
106: wf_engine.SetItemAttrText(itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'NOTIFICATION_USERNAME',
109: avalue => l_username);
110: exception

Line 311: result := wf_engine.eng_null;

307:
308: Begin
309:
310: if funcmode <> 'RUN' then
311: result := wf_engine.eng_null;
312: return;
313: end if;
314:
315: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 315: l_work_item_id := wf_engine.GetItemAttrNumber(

311: result := wf_engine.eng_null;
312: return;
313: end if;
314:
315: l_work_item_id := wf_engine.GetItemAttrNumber(
316: itemtype => itemtype,
317: itemkey => itemkey,
318: aname => 'WORK_ITEMID');
319:

Line 320: l_strategy_id := wf_engine.GetItemAttrNumber(

316: itemtype => itemtype,
317: itemkey => itemkey,
318: aname => 'WORK_ITEMID');
319:
320: l_strategy_id := wf_engine.GetItemAttrNumber(
321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'STRATEGY_ID');
324:

Line 325: l_party_id := wf_engine.GetItemAttrNumber(

321: itemtype => itemtype,
322: itemkey => itemkey,
323: aname => 'STRATEGY_ID');
324:
325: l_party_id := wf_engine.GetItemAttrNumber(
326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'PARTY_ID');
329:

Line 330: l_delinquency_id := wf_engine.GetItemAttrNumber(

326: itemtype => itemtype,
327: itemkey => itemkey,
328: aname => 'PARTY_ID');
329:
330: l_delinquency_id := wf_engine.GetItemAttrNumber(
331: itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'DELINQUENCY_ID');
334:

Line 335: l_email := wf_engine.GetItemAttrText(

331: itemtype => itemtype,
332: itemkey => itemkey,
333: aname => 'DELINQUENCY_ID');
334:
335: l_email := wf_engine.GetItemAttrText(
336: itemtype => itemtype,
337: itemkey => itemkey,
338: aname => 'PARTY_EMAIL');
339:

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

354: -- populate from to
355: l_from := fnd_profile.value('OKL_VND_APPROVAL_EMAIL_FROM');
356:
357: If l_from is null THEN
358: result := wf_engine.eng_completed ||':'||wf_no;
359: return;
360: end if;
361:
362: --populate l_subject

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

388: x_return_status => l_return_status);
389:
390: end if;
391: --set vendor_name
392: wf_engine.SetItemAttrText(itemtype => itemtype,
393: itemkey => itemkey,
394: aname => 'VENDOR_NAME',
395: avalue => l_vendor_name);
396:

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

395: avalue => l_vendor_name);
396:
397: -- for the time being set as '[email protected]
398: if l_email is NULL THEN
399: result := wf_engine.eng_completed ||':'||wf_no;
400: return;
401: end if;
402:
403: if itemtype ='OKLCOWRI' THEN

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

404: l_content_id :=to_number(fnd_profile.value('OKL_WRITE_CUST_TEMPLATE'));
405: end if;
406:
407: If l_content_id is null THEN
408: result := wf_engine.eng_completed ||':'||wf_no;
409: return;
410: end if;
411:
412:

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

434: x_msg_data => l_msg_data);
435:
436:
437: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
438: result := wf_engine.eng_completed ||':'||wf_no;
439: else
440: result := wf_engine.eng_completed ||':'||wf_yes;
441: if itemtype ='OKLCOWRI' THEN
442: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 440: result := wf_engine.eng_completed ||':'||wf_yes;

436:
437: if l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
438: result := wf_engine.eng_completed ||':'||wf_no;
439: else
440: result := wf_engine.eng_completed ||':'||wf_yes;
441: if itemtype ='OKLCOWRI' THEN
442: wf_engine.SetItemAttrText(itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'WK_STATUS',

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

438: result := wf_engine.eng_completed ||':'||wf_no;
439: else
440: result := wf_engine.eng_completed ||':'||wf_yes;
441: if itemtype ='OKLCOWRI' THEN
442: wf_engine.SetItemAttrText(itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'WK_STATUS',
445: avalue => 'COMPLETE');
446: end if;

Line 487: result := wf_engine.eng_null;

483: l_resp_appl_id NUMBER;
484: l_wk_status varchar2(20);
485: Begin
486: if funcmode <> 'RUN' then
487: result := wf_engine.eng_null;
488: return;
489: end if;
490:
491: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 491: l_work_item_id := wf_engine.GetItemAttrNumber(

487: result := wf_engine.eng_null;
488: return;
489: end if;
490:
491: l_work_item_id := wf_engine.GetItemAttrNumber(
492: itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'WORK_ITEMID');
495:

Line 496: l_strategy_id := wf_engine.GetItemAttrNumber(

492: itemtype => itemtype,
493: itemkey => itemkey,
494: aname => 'WORK_ITEMID');
495:
496: l_strategy_id := wf_engine.GetItemAttrNumber(
497: itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'STRATEGY_ID');
500:

Line 502: l_user_id := wf_engine.GetItemAttrNumber(

498: itemkey => itemkey,
499: aname => 'STRATEGY_ID');
500:
501:
502: l_user_id := wf_engine.GetItemAttrNumber(
503: itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'USER_ID');
506:

Line 507: l_resp_id := wf_engine.GetItemAttrNumber(

503: itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'USER_ID');
506:
507: l_resp_id := wf_engine.GetItemAttrNumber(
508: itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'RESP_ID');
511:

Line 512: l_resp_appl_id := wf_engine.GetItemAttrNumber(

508: itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'RESP_ID');
511:
512: l_resp_appl_id := wf_engine.GetItemAttrNumber(
513: itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'RESP_APPL_ID');
516:

Line 520: l_wk_status := wf_engine.GetItemAttrText(

516:
517: --set the session
518: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
519:
520: l_wk_status := wf_engine.GetItemAttrText(
521: itemtype => itemtype,
522: itemkey => itemkey,
523: aname => 'WK_STATUS');
524:

Line 551: result := wf_engine.eng_completed;

547:
548: end if; -- if update is succcessful;
549: end if;
550:
551: result := wf_engine.eng_completed;
552:
553: exception
554: WHEN EXC THEN
555: --pass the error message

Line 626: result := wf_engine.eng_null;

622:
623: BEGIN
624:
625: if funcmode <> 'RUN' then
626: result := wf_engine.eng_null;
627: return;
628: end if;
629:
630: --call api get vendor approval

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

641: itemtype => itemtype,
642: itemkey => itemkey);
643:
644:
645: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'DELINQUENCY_ID');
648: --get vendorapproval flag
649: FOR cur_khr IN l_khr_csr(l_delinquency_id) LOOP

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

677:
678:
679: EXCEPTION
680: when others then
681: result := wf_engine.eng_completed ||':'||wf_no;
682: wf_core.context('OKL_STRY_CALL_CO_PUB','get_vendorapproval_flag',itemtype,
683: itemkey,to_char(actid),funcmode);
684: raise;
685: END get_vendorapproval_flag;

Line 736: result := wf_engine.eng_null;

732:
733: BEGIN
734:
735: if funcmode <> 'RUN' then
736: result := wf_engine.eng_null;
737: return;
738: end if;
739: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
740: itemkey => itemkey,

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

735: if funcmode <> 'RUN' then
736: result := wf_engine.eng_null;
737: return;
738: end if;
739: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
740: itemkey => itemkey,
741: aname => 'DELINQUENCY_ID');
742:
743: set_wait_period(itemtype,itemkey);

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

774:
775:
776: EXCEPTION
777: when others then
778: result := wf_engine.eng_completed ||':'||wf_no;
779: wf_core.context('OKL_STRY_CALL_CO_PUB','get_notification_flag',itemtype,
780: itemkey,to_char(actid),funcmode);
781: raise;
782: END get_notification_flag;

Line 847: result := wf_engine.eng_null;

843:
844: BEGIN
845:
846: if funcmode <> 'RUN' then
847: result := wf_engine.eng_null;
848: return;
849: end if;
850: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
851: itemkey => itemkey,

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

846: if funcmode <> 'RUN' then
847: result := wf_engine.eng_null;
848: return;
849: end if;
850: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
851: itemkey => itemkey,
852: aname => 'DELINQUENCY_ID');
853:
854: OPEN c_get_case_id(l_delinquency_id);

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

903:
904: IF(l_days_after_ven_approval IS NOT NULL) THEN
905: --set the workflow attribute
906: --set workitem_template_id attribute
907: wf_engine.SetItemAttrNumber(itemtype => itemtype,
908: itemkey => itemkey,
909: aname => 'CALL_VENDOR_DAYS',
910: avalue => l_days_after_ven_approval);
911:

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

917:
918:
919: EXCEPTION
920: when others then
921: result := wf_engine.eng_completed ||':'||wf_no;
922: wf_core.context('OKL_STRY_CALL_CO_PUB','check_days_past_due',itemtype,
923: itemkey,to_char(actid),funcmode);
924: raise;
925: END check_days_past_due;

Line 974: result := wf_engine.eng_null;

970:
971: BEGIN
972:
973: if funcmode <> 'RUN' then
974: result := wf_engine.eng_null;
975: return;
976: end if;
977: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
978: itemkey => itemkey,

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

973: if funcmode <> 'RUN' then
974: result := wf_engine.eng_null;
975: return;
976: end if;
977: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'DELINQUENCY_ID');
980:
981: set_wait_period(itemtype,itemkey);

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

1013:
1014:
1015: EXCEPTION
1016: when others then
1017: result := wf_engine.eng_completed ||':'||wf_no;
1018: wf_core.context('OKL_STRY_CALL_CO_PUB','get_lessor_flag',itemtype,
1019: itemkey,to_char(actid),funcmode);
1020: raise;
1021: END get_lessor_flag;

Line 1071: result := wf_engine.eng_null;

1067:
1068: BEGIN
1069:
1070: if funcmode <> 'RUN' then
1071: result := wf_engine.eng_null;
1072: return;
1073: end if;
1074: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1075: itemkey => itemkey,

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

1070: if funcmode <> 'RUN' then
1071: result := wf_engine.eng_null;
1072: return;
1073: end if;
1074: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1075: itemkey => itemkey,
1076: aname => 'DELINQUENCY_ID');
1077:
1078: --get Customer_flag

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

1108:
1109:
1110: EXCEPTION
1111: when others then
1112: result := wf_engine.eng_completed ||':'||wf_no;
1113: wf_core.context('OKL_STRY_CALL_CO_PUB','get_Customer_flag',itemtype,
1114: itemkey,to_char(actid),funcmode);
1115: raise;
1116: END get_Customer_flag;

Line 1164: result := wf_engine.eng_null;

1160:
1161: BEGIN
1162:
1163: if funcmode <> 'RUN' then
1164: result := wf_engine.eng_null;
1165: return;
1166: end if;
1167: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1168: itemkey => itemkey,

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

1163: if funcmode <> 'RUN' then
1164: result := wf_engine.eng_null;
1165: return;
1166: end if;
1167: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'DELINQUENCY_ID');
1170:
1171: --get Vendor_Customer_flag

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

1203:
1204:
1205: EXCEPTION
1206: when others then
1207: result := wf_engine.eng_completed ||':'||wf_no;
1208: wf_core.context('OKL_STRY_CALL_CO_PUB','get_Vendor_approval_flag',itemtype,
1209: itemkey,to_char(actid),funcmode);
1210: raise;
1211: END get_Vendor_approval_flag;

Line 1259: result := wf_engine.eng_null;

1255:
1256: BEGIN
1257:
1258: if funcmode <> 'RUN' then
1259: result := wf_engine.eng_null;
1260: return;
1261: end if;
1262: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1263: itemkey => itemkey,

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

1258: if funcmode <> 'RUN' then
1259: result := wf_engine.eng_null;
1260: return;
1261: end if;
1262: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1263: itemkey => itemkey,
1264: aname => 'DELINQUENCY_ID');
1265:
1266: --get Vend_cust_notify_flag

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

1296:
1297:
1298: EXCEPTION
1299: when others then
1300: result := wf_engine.eng_completed ||':'||wf_no;
1301: wf_core.context('OKL_STRY_CALL_CO_PUB','get_Vend_cust_notify_flag',itemtype,
1302: itemkey,to_char(actid),funcmode);
1303: raise;
1304: END get_Vend_cust_notify_flag;

Line 1376: result := wf_engine.eng_null;

1372:
1373: BEGIN
1374:
1375: if funcmode <> 'RUN' then
1376: result := wf_engine.eng_null;
1377: return;
1378: end if;
1379:
1380:

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

1378: end if;
1379:
1380:
1381:
1382: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'DELINQUENCY_ID');
1385:
1386: l_party_id := wf_engine.GetItemAttrNumber(

Line 1386: l_party_id := wf_engine.GetItemAttrNumber(

1382: l_delinquency_id := wf_engine.GetItemAttrText( itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'DELINQUENCY_ID');
1385:
1386: l_party_id := wf_engine.GetItemAttrNumber(
1387: itemtype => itemtype,
1388: itemkey => itemkey,
1389: aname => 'PARTY_ID');
1390:

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

1416:
1417: IF(l_noofdays IS NOT NULL) THEN
1418: --set the workflow attribute
1419: --set workitem_template_id attribute
1420: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1421: itemkey => itemkey,
1422: aname => 'SYNDICATED_DAYS',
1423: avalue => l_days_after_ven_approval);
1424:

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

1437: If l_email is null THEN
1438: result := 'COMPLETE:' || 'N';
1439: return;
1440: else
1441: wf_engine.SetItemAttrText(itemtype => itemtype,
1442: itemkey => itemkey,
1443: aname => 'PARTY_EMAIL',
1444: avalue => l_email);
1445: result := 'COMPLETE:' || 'Y';

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

1448:
1449:
1450: EXCEPTION
1451: when others then
1452: result := wf_engine.eng_completed ||':'||wf_no;
1453: wf_core.context('OKL_STRY_CALL_CO_PUB','check_days_for_syn_acct',itemtype,
1454: itemkey,to_char(actid),funcmode);
1455: raise;
1456: END check_days_for_syn_acct;