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

Line 305: l_org_id := wf_engine.GetItemAttrNumber

301: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
302: l_item_key := substr(document_id, instr(document_id, ':') + 1,
303: length(document_id) - 2);
304:
305: l_org_id := wf_engine.GetItemAttrNumber
306: (itemtype => l_item_type,
307: itemkey => l_item_key,
308: aname => 'ORG_ID');
309:

Line 312: l_document_id := wf_engine.GetItemAttrNumber

308: aname => 'ORG_ID');
309:
310: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
311:
312: l_document_id := wf_engine.GetItemAttrNumber
313: (itemtype => l_item_type,
314: itemkey => l_item_key,
315: aname => 'DOCUMENT_ID');
316: l_change_request_group_id := wf_engine.GetItemAttrNumber

Line 316: l_change_request_group_id := wf_engine.GetItemAttrNumber

312: l_document_id := wf_engine.GetItemAttrNumber
313: (itemtype => l_item_type,
314: itemkey => l_item_key,
315: aname => 'DOCUMENT_ID');
316: l_change_request_group_id := wf_engine.GetItemAttrNumber
317: (itemtype => l_item_type,
318: itemkey => l_item_key,
319: aname => 'CHANGE_REQUEST_GROUP_ID');
320:

Line 322: l_currency_code := wf_engine.GetItemAttrText

318: itemkey => l_item_key,
319: aname => 'CHANGE_REQUEST_GROUP_ID');
320:
321: /*
322: l_currency_code := wf_engine.GetItemAttrText
323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'FUNCTIONAL_CURRENCY');
326:

Line 327: l_old_req_amount := wf_engine.GetItemAttrText

323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'FUNCTIONAL_CURRENCY');
326:
327: l_old_req_amount := wf_engine.GetItemAttrText
328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_AMOUNT_CURRENCY_DSP');
331:

Line 332: l_old_tax_amount := wf_engine.GetItemAttrText

328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_AMOUNT_CURRENCY_DSP');
331:
332: l_old_tax_amount := wf_engine.GetItemAttrText
333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'TAX_AMOUNT_CURRENCY_DSP');
336:

Line 337: l_new_req_amount := wf_engine.GetItemAttrText

333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'TAX_AMOUNT_CURRENCY_DSP');
336:
337: l_new_req_amount := wf_engine.GetItemAttrText
338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
341:

Line 342: l_new_tax_amount := wf_engine.GetItemAttrText

338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
341:
342: l_new_tax_amount := wf_engine.GetItemAttrText
343: (itemtype => l_item_type,
344: itemkey => l_item_key,
345: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
346:

Line 354: l_note := wf_engine.GetItemAttrText

350: aname => 'JUSTIFICATION');
351:
352: if l_note is null then
353:
354: l_note := wf_engine.GetItemAttrText
355: (itemtype => l_item_type,
356: itemkey => l_item_key,
357: aname => 'NOTE');
358:

Line 486: l_org_id := wf_engine.GetItemAttrNumber

482: open l_get_wf_keys_csr;
483: fetch l_get_wf_keys_csr into l_item_type, l_item_key;
484: close l_get_wf_keys_csr;
485:
486: l_org_id := wf_engine.GetItemAttrNumber
487: (itemtype => l_item_type,
488: itemkey => l_item_key,
489: aname => 'ORG_ID');
490:

Line 493: l_document_id := wf_engine.GetItemAttrNumber

489: aname => 'ORG_ID');
490:
491: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
492:
493: l_document_id := wf_engine.GetItemAttrNumber
494: (itemtype => l_item_type,
495: itemkey => l_item_key,
496: aname => 'DOCUMENT_ID');
497: /*

Line 498: l_currency_code := wf_engine.GetItemAttrText

494: (itemtype => l_item_type,
495: itemkey => l_item_key,
496: aname => 'DOCUMENT_ID');
497: /*
498: l_currency_code := wf_engine.GetItemAttrText
499: (itemtype => l_item_type,
500: itemkey => l_item_key,
501: aname => 'FUNCTIONAL_CURRENCY');
502:

Line 503: l_old_req_amount := wf_engine.GetItemAttrText

499: (itemtype => l_item_type,
500: itemkey => l_item_key,
501: aname => 'FUNCTIONAL_CURRENCY');
502:
503: l_old_req_amount := wf_engine.GetItemAttrText
504: (itemtype => l_item_type,
505: itemkey => l_item_key,
506: aname => 'REQ_AMOUNT_DSP');
507:

Line 508: l_old_tax_amount := wf_engine.GetItemAttrText

504: (itemtype => l_item_type,
505: itemkey => l_item_key,
506: aname => 'REQ_AMOUNT_DSP');
507:
508: l_old_tax_amount := wf_engine.GetItemAttrText
509: (itemtype => l_item_type,
510: itemkey => l_item_key,
511: aname => 'TAX_AMOUNT_DSP');
512:

Line 520: l_note := wf_engine.GetItemAttrText

516: aname => 'JUSTIFICATION');
517:
518: if l_note is null then
519:
520: l_note := wf_engine.GetItemAttrText
521: (itemtype => l_item_type,
522: itemkey => l_item_key,
523: aname => 'NOTE');
524:

Line 718: l_group_id := wf_engine.GetItemAttrNumber

714: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
715: l_item_key := substr(document_id, instr(document_id, ':') + 1,
716: length(document_id) - 2);
717:
718: l_group_id := wf_engine.GetItemAttrNumber
719: (itemtype => l_item_type,
720: itemkey => l_item_key,
721: aname => 'CHANGE_REQUEST_GROUP_ID');
722:

Line 723: l_document_id := wf_engine.GetItemAttrNumber

719: (itemtype => l_item_type,
720: itemkey => l_item_key,
721: aname => 'CHANGE_REQUEST_GROUP_ID');
722:
723: l_document_id := wf_engine.GetItemAttrNumber
724: (itemtype => l_item_type,
725: itemkey => l_item_key,
726: aname => 'DOCUMENT_ID');
727:

Line 728: l_org_id := wf_engine.GetItemAttrNumber

724: (itemtype => l_item_type,
725: itemkey => l_item_key,
726: aname => 'DOCUMENT_ID');
727:
728: l_org_id := wf_engine.GetItemAttrNumber
729: (itemtype => l_item_type,
730: itemkey => l_item_key,
731: aname => 'ORG_ID');
732:

Line 1235: l_document_id := wf_engine.GetItemAttrNumber

1231: open l_get_wf_keys_csr;
1232: fetch l_get_wf_keys_csr into l_item_type, l_item_key;
1233: close l_get_wf_keys_csr;
1234:
1235: l_document_id := wf_engine.GetItemAttrNumber
1236: (itemtype => l_item_type,
1237: itemkey => l_item_key,
1238: aname => 'DOCUMENT_ID');
1239:

Line 1240: l_org_id := wf_engine.GetItemAttrNumber

1236: (itemtype => l_item_type,
1237: itemkey => l_item_key,
1238: aname => 'DOCUMENT_ID');
1239:
1240: l_org_id := wf_engine.GetItemAttrNumber
1241: (itemtype => l_item_type,
1242: itemkey => l_item_key,
1243: aname => 'ORG_ID');
1244:

Line 1688: l_document_id := wf_engine.GetItemAttrNumber

1684: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1685: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1686: length(document_id) - 2);
1687:
1688: l_document_id := wf_engine.GetItemAttrNumber
1689: (itemtype => l_item_type,
1690: itemkey => l_item_key,
1691: aname => 'DOCUMENT_ID');
1692:

Line 1693: l_org_id := wf_engine.GetItemAttrNumber

1689: (itemtype => l_item_type,
1690: itemkey => l_item_key,
1691: aname => 'DOCUMENT_ID');
1692:
1693: l_org_id := wf_engine.GetItemAttrNumber
1694: (itemtype => l_item_type,
1695: itemkey => l_item_key,
1696: aname => 'ORG_ID');
1697:

Line 1856: l_document_id := wf_engine.GetItemAttrNumber

1852: ORDER BY 1 asc;
1853:
1854: BEGIN
1855:
1856: l_document_id := wf_engine.GetItemAttrNumber
1857: (itemtype => p_item_type,
1858: itemkey => p_item_key,
1859: aname => 'DOCUMENT_ID');
1860:

Line 1861: l_org_id := wf_engine.GetItemAttrNumber

1857: (itemtype => p_item_type,
1858: itemkey => p_item_key,
1859: aname => 'DOCUMENT_ID');
1860:
1861: l_org_id := wf_engine.GetItemAttrNumber
1862: (itemtype => p_item_type,
1863: itemkey => p_item_key,
1864: aname => 'ORG_ID');
1865:

Line 1949: l_currency_code := wf_engine.GetItemAttrText

1945: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
1946:
1947: BEGIN
1948: begin
1949: l_currency_code := wf_engine.GetItemAttrText
1950: (itemtype => l_item_type,
1951: itemkey => l_item_key,
1952: aname => 'FUNCTIONAL_CURRENCY');
1953: l_old_req_amount := wf_engine.GetItemAttrText

Line 1953: l_old_req_amount := wf_engine.GetItemAttrText

1949: l_currency_code := wf_engine.GetItemAttrText
1950: (itemtype => l_item_type,
1951: itemkey => l_item_key,
1952: aname => 'FUNCTIONAL_CURRENCY');
1953: l_old_req_amount := wf_engine.GetItemAttrText
1954: (itemtype => l_item_type,
1955: itemkey => l_item_key,
1956: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1957: l_old_tax_amount := wf_engine.GetItemAttrText

Line 1957: l_old_tax_amount := wf_engine.GetItemAttrText

1953: l_old_req_amount := wf_engine.GetItemAttrText
1954: (itemtype => l_item_type,
1955: itemkey => l_item_key,
1956: aname => 'REQ_AMOUNT_CURRENCY_DSP');
1957: l_old_tax_amount := wf_engine.GetItemAttrText
1958: (itemtype => l_item_type,
1959: itemkey => l_item_key,
1960: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1961: exception

Line 1964: l_old_req_amount := wf_engine.GetItemAttrText

1960: aname => 'TAX_AMOUNT_CURRENCY_DSP');
1961: exception
1962: when others then
1963:
1964: l_old_req_amount := wf_engine.GetItemAttrText
1965: (itemtype => l_item_type,
1966: itemkey => l_item_key,
1967: aname => 'REQ_AMOUNT_DSP')
1968: ||' '||l_currency_code;

Line 1970: l_old_tax_amount := wf_engine.GetItemAttrText

1966: itemkey => l_item_key,
1967: aname => 'REQ_AMOUNT_DSP')
1968: ||' '||l_currency_code;
1969:
1970: l_old_tax_amount := wf_engine.GetItemAttrText
1971: (itemtype => l_item_type,
1972: itemkey => l_item_key,
1973: aname => 'TAX_AMOUNT_DSP')
1974: ||' '||l_currency_code;

Line 1980: l_new_req_amount := wf_engine.GetItemAttrText

1976: end;
1977:
1978: if(l_call_from = 'A') then
1979: begin
1980: l_new_req_amount := wf_engine.GetItemAttrText
1981: (itemtype => l_item_type,
1982: itemkey => l_item_key,
1983: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
1984: l_new_tax_amount := wf_engine.GetItemAttrText

Line 1984: l_new_tax_amount := wf_engine.GetItemAttrText

1980: l_new_req_amount := wf_engine.GetItemAttrText
1981: (itemtype => l_item_type,
1982: itemkey => l_item_key,
1983: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
1984: l_new_tax_amount := wf_engine.GetItemAttrText
1985: (itemtype => l_item_type,
1986: itemkey => l_item_key,
1987: aname => 'NEW_TAX_AMOUNT_CURRENCY_DSP');
1988: exception

Line 2057: l_note := wf_engine.GetItemAttrText

2053: aname => 'JUSTIFICATION');
2054:
2055: if l_note is null then
2056:
2057: l_note := wf_engine.GetItemAttrText
2058: (itemtype => l_item_type,
2059: itemkey => l_item_key,
2060: aname => 'NOTE');
2061:

Line 2418: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2414: l_progress varchar2(200);
2415:
2416: BEGIN
2417:
2418: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2419: itemkey => itemkey,
2420: aname => 'USER_ID');
2421: --
2422: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2422: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2418: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2419: itemkey => itemkey,
2420: aname => 'USER_ID');
2421: --
2422: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2423: itemkey => itemkey,
2424: aname => 'APPLICATION_ID');
2425: --
2426: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2426: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2422: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2423: itemkey => itemkey,
2424: aname => 'APPLICATION_ID');
2425: --
2426: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2427: itemkey => itemkey,
2428: aname => 'RESPONSIBILITY_ID');
2429:
2430: /* Set the context for the doc manager */

Line 3856: document:=wf_engine.GetItemAttrText

3852: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
3853: l_item_key := substr(document_id, instr(document_id, ':') + 1,
3854: length(document_id) - 2);
3855:
3856: document:=wf_engine.GetItemAttrText
3857: (itemtype => l_item_type,
3858: itemkey => l_item_key,
3859: aname => 'NEW_REQ_AMOUNT_CURRENCY_DSP');
3860: