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.

[Home] [Help]

APPS.OKL_SO_CREDIT_APP_WF dependencies on WF_ENGINE

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

106: j := NVL(FND_MSG_PUB.Count_Msg,0);
107: if (j=0) then return; end if;
108: if (j>9) then j:=9; end if;
109: FOR I IN 1..J LOOP
110: wf_engine.SetItemAttrText (itemtype => itemtype,
111: itemkey => itemkey,
112: aname => 'MESSAGE'||i,
113: avalue => FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
114: END LOOP;

Line 160: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (

156: if (funcmode = 'RUN') then
157: --
158: -- Initiator/Initial
159: --
160: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (
161: itemtype => itemtype,
162: itemkey => itemkey,
163: aname => 'CREDIT_REQUEST_ID'));
164:

Line 168: wf_engine.SetItemAttrText (

164:
165: open c_submitted_by(l_request_id);
166: fetch c_submitted_by INTO l_user_id;
167: close c_submitted_by;
168: wf_engine.SetItemAttrText (
169: itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'USER_ID',
172: avalue => L_USER_ID);

Line 177: wf_engine.SetItemAttrText (

173:
174: open C_REQUESTOR_DISPLAY_NAME(l_user_id);
175: fetch C_REQUESTOR_DISPLAY_NAME into L_REQUESTOR, L_REQUESTOR_DNAME;
176: close C_REQUESTOR_DISPLAY_NAME;
177: wf_engine.SetItemAttrText (
178: itemtype=> itemtype,
179: itemkey => itemkey,
180: aname => 'REQUESTOR',
181: avalue => L_REQUESTOR);

Line 182: wf_engine.SetItemAttrText (

178: itemtype=> itemtype,
179: itemkey => itemkey,
180: aname => 'REQUESTOR',
181: avalue => L_REQUESTOR);
182: wf_engine.SetItemAttrText (
183: itemtype=> itemtype,
184: itemkey => itemkey,
185: aname => 'REQUESTOR_DNAME',
186: avalue => L_REQUESTOR_DNAME);

Line 253: wf_engine.SetItemAttrText (

249: if (funcmode = 'RUN') then
250: open C_APPROVER_DISPLAY_NAME;
251: fetch C_APPROVER_DISPLAY_NAME into L_APPROVER,L_APPROVER_DNAME;
252: close C_APPROVER_DISPLAY_NAME;
253: wf_engine.SetItemAttrText (
254: itemtype=> itemtype,
255: itemkey => itemkey,
256: aname => 'APPROVER',
257: avalue => L_APPROVER);

Line 258: wf_engine.SetItemAttrText (

254: itemtype=> itemtype,
255: itemkey => itemkey,
256: aname => 'APPROVER',
257: avalue => L_APPROVER);
258: wf_engine.SetItemAttrText (
259: itemtype=> itemtype,
260: itemkey => itemkey,
261: aname => 'APPROVER_DNAME',
262: avalue => L_APPROVER_DNAME);

Line 354: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (

350: if (funcmode = 'RUN') then
351: --
352: -- Initiator/Initial
353: --
354: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (
355: itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'CREDIT_REQUEST_ID'));
358:

Line 402: wf_engine.SetItemAttrText (

398: END IF;
399:
400: END LOOP; -- r_recomendation
401:
402: wf_engine.SetItemAttrText (
403: itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'QUOTE_NUM',
406: avalue => l_quote_number);

Line 407: wf_engine.SetItemAttrText (

403: itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'QUOTE_NUM',
406: avalue => l_quote_number);
407: wf_engine.SetItemAttrText (
408: itemtype => itemtype,
409: itemkey => itemkey,
410: aname => 'CREDIT_REQ_NUM',
411: avalue => l_credit_req_number);

Line 412: wf_engine.SetItemAttrText (

408: itemtype => itemtype,
409: itemkey => itemkey,
410: aname => 'CREDIT_REQ_NUM',
411: avalue => l_credit_req_number);
412: wf_engine.SetItemAttrText (
413: itemtype=> itemtype,
414: itemkey => itemkey,
415: aname => 'CREDIT_AMOUNT',
416: avalue => l_credit_amount);

Line 417: wf_engine.SetItemAttrText (

413: itemtype=> itemtype,
414: itemkey => itemkey,
415: aname => 'CREDIT_AMOUNT',
416: avalue => l_credit_amount);
417: wf_engine.SetItemAttrText (
418: itemtype => itemtype,
419: itemkey => itemkey,
420: aname => 'CREDIT_REQ_DATE',
421: avalue => l_requested_date);

Line 422: wf_engine.SetItemAttrText (

418: itemtype => itemtype,
419: itemkey => itemkey,
420: aname => 'CREDIT_REQ_DATE',
421: avalue => l_requested_date);
422: wf_engine.SetItemAttrText (
423: itemtype=> itemtype,
424: itemkey => itemkey,
425: aname => 'CUST_ACCT_NUM',
426: avalue => l_account_number);

Line 427: wf_engine.SetItemAttrText (

423: itemtype=> itemtype,
424: itemkey => itemkey,
425: aname => 'CUST_ACCT_NUM',
426: avalue => l_account_number);
427: wf_engine.SetItemAttrText (
428: itemtype=> itemtype,
429: itemkey => itemkey,
430: aname => 'PARTY_NAME',
431: avalue => l_party_name);

Line 432: wf_engine.SetItemAttrText (

428: itemtype=> itemtype,
429: itemkey => itemkey,
430: aname => 'PARTY_NAME',
431: avalue => l_party_name);
432: wf_engine.SetItemAttrText (
433: itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'CREDIT_RECOMENDATION',
436: avalue => l_recomendation);

Line 437: wf_engine.SetItemAttrText (

433: itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'CREDIT_RECOMENDATION',
436: avalue => l_recomendation);
437: wf_engine.SetItemAttrText (
438: itemtype=> itemtype,
439: itemkey => itemkey,
440: aname => 'RECOMEND_VALUE1',
441: avalue => l_recomend_value1);

Line 442: wf_engine.SetItemAttrText (

438: itemtype=> itemtype,
439: itemkey => itemkey,
440: aname => 'RECOMEND_VALUE1',
441: avalue => l_recomend_value1);
442: wf_engine.SetItemAttrText (
443: itemtype=> itemtype,
444: itemkey => itemkey,
445: aname => 'RECOMEND_VALUE2',
446: avalue => l_recomend_value2);

Line 447: wf_engine.SetItemAttrText (

443: itemtype=> itemtype,
444: itemkey => itemkey,
445: aname => 'RECOMEND_VALUE2',
446: avalue => l_recomend_value2);
447: wf_engine.SetItemAttrText (
448: itemtype => itemtype,
449: itemkey => itemkey,
450: aname => 'ID',
451: avalue => l_okl_request_id);

Line 452: wf_engine.SetItemAttrText (

448: itemtype => itemtype,
449: itemkey => itemkey,
450: aname => 'ID',
451: avalue => l_okl_request_id);
452: wf_engine.SetItemAttrText (
453: itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'QUOTE_ID',
456: avalue => l_quote_id);

Line 457: wf_engine.SetItemAttrText (

453: itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'QUOTE_ID',
456: avalue => l_quote_id);
457: wf_engine.SetItemAttrText (
458: itemtype => itemtype,
459: itemkey => itemkey,
460: aname => 'REQUEST_STATUS',
461: avalue => l_request_status);

Line 462: wf_engine.SetItemAttrText (

458: itemtype => itemtype,
459: itemkey => itemkey,
460: aname => 'REQUEST_STATUS',
461: avalue => l_request_status);
462: wf_engine.SetItemAttrText (
463: itemtype => itemtype,
464: itemkey => itemkey,
465: aname => 'CURRENCY',
466: avalue => l_currency);

Line 671: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (

667: -- RUN mode - normal process execution
668: --
669: if (funcmode = 'RUN') then
670:
671: l_request_id := TO_NUMBER( wf_engine.GetItemAttrText (
672: itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'CREDIT_REQUEST_ID'));
675:

Line 676: IF (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then

672: itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'CREDIT_REQUEST_ID'));
675:
676: IF (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then
677: resultout := 'ERROR: Must enter an End Date for Term Line of Credit ';
678: --resultout := 'COMPLETE:F';
679: ELSE
680: l_effective_to := wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE');

Line 680: l_effective_to := wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE');

676: IF (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then
677: resultout := 'ERROR: Must enter an End Date for Term Line of Credit ';
678: --resultout := 'COMPLETE:F';
679: ELSE
680: l_effective_to := wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE');
681: -- assign a val just in case. should not go here
682: IF l_effective_to IS NULL THEN
683: l_effective_to := sysdate + 30;
684: END IF;

Line 880: l_okl_credit_req := wf_engine.GetItemAttrNumber (

876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: -- 7. Change Status of the credit request
880: l_okl_credit_req := wf_engine.GetItemAttrNumber (
881: itemtype => itemtype,
882: itemkey => itemkey,
883: aname => 'ID');
884:

Line 896: wf_engine.SetItemAttrText (

892: l_crqv_rec_type.CREDIT_KHR_ID := x_chr_id ;
893: l_crqv_rec_type.approved_by := l_approved_by;
894: l_crqv_rec_type.approved_date := SYSDATE;
895:
896: wf_engine.SetItemAttrText (
897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'REQUEST_STATUS',
900: avalue => l_crqv_rec_type.STATUS);

Line 1154: l_credit_req_id := wf_engine.GetItemAttrNumber (

1150: -- RUN mode - normal process execution
1151: --
1152: IF (funcmode = 'RUN')
1153: THEN
1154: l_credit_req_id := wf_engine.GetItemAttrNumber (
1155: itemtype => itemtype
1156: ,itemkey => itemkey
1157: ,aname => 'CREDIT_REQUEST_ID');
1158:

Line 1385: l_quote_id := TO_NUMBER( wf_engine.GetItemAttrText (

1381: if (funcmode = 'RUN') then
1382:
1383:
1384: -- 1. Get values (quote_id , requestor_id) from workflow
1385: l_quote_id := TO_NUMBER( wf_engine.GetItemAttrText (
1386: itemtype => itemtype,
1387: itemkey => itemkey,
1388: aname => 'QUOTE_ID'));
1389:

Line 1390: l_requestor_id := TO_NUMBER( wf_engine.GetItemAttrText (

1386: itemtype => itemtype,
1387: itemkey => itemkey,
1388: aname => 'QUOTE_ID'));
1389:
1390: l_requestor_id := TO_NUMBER( wf_engine.GetItemAttrText (
1391: itemtype => itemtype,
1392: itemkey => itemkey,
1393: aname => 'REQUESTED_ID'));
1394:

Line 1446: wf_engine.SetItemAttrText (

1442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1443: END IF;
1444:
1445: -- 5. set approver role, REQUEST STATUS , CREDIT_AMOUNT , rEQUEST NUMBER
1446: wf_engine.SetItemAttrText (
1447: itemtype => itemtype,
1448: itemkey => itemkey,
1449: aname => 'APPROVER_ID',
1450: avalue => 'ADMIN');

Line 1452: wf_engine.SetItemAttrText (

1448: itemkey => itemkey,
1449: aname => 'APPROVER_ID',
1450: avalue => 'ADMIN');
1451:
1452: wf_engine.SetItemAttrText (
1453: itemtype => itemtype,
1454: itemkey => itemkey,
1455: aname => 'CREDIT_REQ_NUM',
1456: avalue => ls_request_num);

Line 1458: wf_engine.SetItemAttrText (

1454: itemkey => itemkey,
1455: aname => 'CREDIT_REQ_NUM',
1456: avalue => ls_request_num);
1457:
1458: wf_engine.SetItemAttrText (
1459: itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'REQUEST_STATUS',
1462: avalue => 'ENTERED');

Line 1464: wf_engine.SetItemAttrNumber (

1460: itemkey => itemkey,
1461: aname => 'REQUEST_STATUS',
1462: avalue => 'ENTERED');
1463:
1464: wf_engine.SetItemAttrNumber (
1465: itemtype => itemtype,
1466: itemkey => itemkey,
1467: aname => 'CREDIT_AMOUNT',
1468: avalue => l_capital_amount);

Line 1470: wf_engine.SetItemAttrNumber (

1466: itemkey => itemkey,
1467: aname => 'CREDIT_AMOUNT',
1468: avalue => l_capital_amount);
1469:
1470: wf_engine.SetItemAttrNumber (
1471: itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'ID',
1474: avalue => x_crqv_rec_type.ID);

Line 1525: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then

1521: --
1522: -- RUN mode - normal process execution
1523: --
1524: if (funcmode = 'RUN') then
1525: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then
1526: resultout := 'COMPLETE:F';
1527: else
1528: -- check that the date is greater than the request date
1529: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') < sysdate) then

Line 1529: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') < sysdate) then

1525: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') is NULL) then
1526: resultout := 'COMPLETE:F';
1527: else
1528: -- check that the date is greater than the request date
1529: if (wf_engine.GetItemAttrText(itemtype,itemkey,'TLOC_END_DATE') < sysdate) then
1530: resultout := 'COMPLETE:F';
1531: else
1532: resultout := 'COMPLETE:T';
1533: end if;