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

Line 235: l_trx_id := WF_ENGINE.GetItemAttrText(

231: -- RUN mode
232: --
233: IF (funcmode = 'RUN') THEN
234:
235: l_trx_id := WF_ENGINE.GetItemAttrText(
236: itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'TRANSACTION_ID');
239:

Line 420: l_trx_id := WF_ENGINE.GetItemAttrText(

416: -- RUN mode
417: --
418: IF (funcmode = 'RUN') THEN
419:
420: l_trx_id := WF_ENGINE.GetItemAttrText(
421: itemtype => itemtype,
422: itemkey => itemkey,
423: aname => 'TRANSACTION_ID');
424:

Line 430: WF_ENGINE.SetItemAttrNumber(

426: FETCH okl_pop_pre_proceeds_csr INTO l_pre_proceeds_rec;
427: CLOSE okl_pop_pre_proceeds_csr;
428:
429: -- Set the contract details to the item attributes of WF
430: WF_ENGINE.SetItemAttrNumber(
431: itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'CONTRACT_ID',
434: avalue => l_pre_proceeds_rec.id);

Line 436: WF_ENGINE.SetItemAttrText(

432: itemkey => itemkey,
433: aname => 'CONTRACT_ID',
434: avalue => l_pre_proceeds_rec.id);
435:
436: WF_ENGINE.SetItemAttrText(
437: itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'CONTRACT_NUMBER',
440: avalue => l_pre_proceeds_rec.contract_number);

Line 443: WF_ENGINE.SetItemAttrText(

439: aname => 'CONTRACT_NUMBER',
440: avalue => l_pre_proceeds_rec.contract_number);
441:
442: -- MDOKAL, 21-MAR-2003 Bug 2862254
443: WF_ENGINE.SetItemAttrText(
444: itemtype => itemtype,
445: itemkey => itemkey,
446: aname => 'MESSAGE_DOC',
447: avalue => 'plsql:okl_am_quotes_wf.pop_oklamppt_doc/'||itemkey);

Line 459: WF_ENGINE.SetItemAttrText(

455: p_user_id => l_pre_proceeds_rec.last_updated_by,
456: x_name => l_requestor,
457: x_description => l_description);
458:
459: WF_ENGINE.SetItemAttrText(
460: itemtype => itemtype,
461: itemkey => itemkey,
462: aname => 'REQUESTER',
463: avalue => l_requestor);

Line 465: WF_ENGINE.SetItemAttrText(

461: itemkey => itemkey,
462: aname => 'REQUESTER',
463: avalue => l_requestor);
464:
465: WF_ENGINE.SetItemAttrText(
466: itemtype => itemtype,
467: itemkey => itemkey,
468: aname => 'WF_ADMINISTRATOR',
469: avalue => l_requestor);

Line 471: WF_ENGINE.SetItemAttrNumber(

467: itemkey => itemkey,
468: aname => 'WF_ADMINISTRATOR',
469: avalue => l_requestor);
470:
471: WF_ENGINE.SetItemAttrNumber(
472: itemtype => itemtype,
473: itemkey => itemkey,
474: aname => 'CREATED_BY',
475: avalue => l_pre_proceeds_rec.last_updated_by);

Line 478: WF_ENGINE.SetItemAttrText (

474: aname => 'CREATED_BY',
475: avalue => l_pre_proceeds_rec.last_updated_by);
476:
477: ---OKL AM Termination Quote Pre-Proceeds
478: WF_ENGINE.SetItemAttrText (
479: itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'TRX_TYPE_ID',
482: avalue => 'OKLAMPPT');

Line 485: WF_ENGINE.SetItemAttrNumber(

481: aname => 'TRX_TYPE_ID',
482: avalue => 'OKLAMPPT');
483:
484: -- Set the Quote ID
485: WF_ENGINE.SetItemAttrNumber(
486: itemtype => itemtype,
487: itemkey => itemkey,
488: aname => 'QUOTE_ID',
489: avalue => l_trx_id);

Line 545: WF_ENGINE.SetItemAttrText (

541: l_message := '';
542: END IF;
543:
544: -- Set the message
545: WF_ENGINE.SetItemAttrText (
546: itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'MESSAGE_DESCRIPTION',
549: avalue => l_message);

Line 633: l_quote_id := WF_ENGINE.GetItemAttrNumber(

629: --
630: IF (funcmode = 'RUN') THEN
631:
632: -- Get the Quote ID
633: l_quote_id := WF_ENGINE.GetItemAttrNumber(
634: itemtype => itemtype,
635: itemkey => itemkey,
636: aname => 'QUOTE_ID');
637:

Line 639: WF_ENGINE.SetItemAttrText(

635: itemkey => itemkey,
636: aname => 'QUOTE_ID');
637:
638: -- Set the Transaction ID
639: WF_ENGINE.SetItemAttrText(
640: itemtype => itemtype,
641: itemkey => itemkey,
642: aname => 'TRANSACTION_ID',
643: avalue => l_quote_id);

Line 646: WF_ENGINE.SetItemAttrText(

642: aname => 'TRANSACTION_ID',
643: avalue => l_quote_id);
644:
645: -- Set the EMAIL_ADDRESS to NULL
646: WF_ENGINE.SetItemAttrText(
647: itemtype => itemtype,
648: itemkey => itemkey,
649: aname => 'EMAIL_ADDRESS',
650: avalue => NULL);

Line 742: l_approved_yn := WF_ENGINE.GetItemAttrText(

738: --
739: IF (funcmode = 'RUN') THEN
740:
741: -- Get the approved_yn flag
742: l_approved_yn := WF_ENGINE.GetItemAttrText(
743: itemtype => itemtype,
744: itemkey => itemkey,
745: aname => 'APPROVED_YN');
746:

Line 908: l_qte_id := WF_ENGINE.GetItemAttrText(

904: --
905: IF (funcmode = 'RUN') THEN
906:
907: -- get the quote id
908: l_qte_id := WF_ENGINE.GetItemAttrText(
909: itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'TRANSACTION_ID');
912:

Line 973: WF_ENGINE.SetItemAttrText (

969:
970: l_message := l_message||'

';
971:
972: -- Set the message
973: WF_ENGINE.SetItemAttrText (
974: itemtype => itemtype,
975: itemkey => itemkey,
976: aname => 'MESSAGE_DESCRIPTION',
977: avalue => l_message);

Line 1091: l_trx_id := WF_ENGINE.GetItemAttrText(

1087: -- RUN mode
1088: --
1089: IF (funcmode = 'RUN') THEN
1090:
1091: l_trx_id := WF_ENGINE.GetItemAttrText(
1092: itemtype => itemtype,
1093: itemkey => itemkey,
1094: aname => 'TRANSACTION_ID');
1095:

Line 1150: WF_ENGINE.SetItemAttrText (

1146: l_message := '';
1147: END IF;
1148:
1149: -- Set the message
1150: WF_ENGINE.SetItemAttrText (
1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'MESSAGE_DESCRIPTION',
1154: avalue => l_message);

Line 1266: l_trx_id := WF_ENGINE.GetItemAttrText(

1262: -- RUN mode
1263: --
1264: IF (funcmode = 'RUN') THEN
1265:
1266: l_trx_id := WF_ENGINE.GetItemAttrText(
1267: itemtype => itemtype,
1268: itemkey => itemkey,
1269: aname => 'TRANSACTION_ID');
1270:

Line 1305: WF_ENGINE.SetItemAttrText (

1301: l_message_rec.comments||'

';
1302:
1303:
1304: -- Set the message
1305: WF_ENGINE.SetItemAttrText (
1306: itemtype => itemtype,
1307: itemkey => itemkey,
1308: aname => 'MESSAGE_DESCRIPTION',
1309: avalue => l_message);

Line 1420: l_qte_id := WF_ENGINE.GetItemAttrText(

1416: -- RUN mode
1417: --
1418: IF (funcmode = 'RUN') THEN
1419: -- Get the values for term_rec before calling the terminate contract api
1420: l_qte_id := WF_ENGINE.GetItemAttrText(
1421: itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'TRANSACTION_ID');
1424:

Line 1425: l_contract_id := WF_ENGINE.GetItemAttrNumber(

1421: itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'TRANSACTION_ID');
1424:
1425: l_contract_id := WF_ENGINE.GetItemAttrNumber(
1426: itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'CONTRACT_ID');
1429:

Line 1430: l_contract_number := WF_ENGINE.GetItemAttrText(

1426: itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'CONTRACT_ID');
1429:
1430: l_contract_number := WF_ENGINE.GetItemAttrText(
1431: itemtype => itemtype,
1432: itemkey => itemkey,
1433: aname => 'CONTRACT_NUMBER');
1434:

Line 1581: l_contract_id := WF_ENGINE.GetItemAttrNumber(

1577: -- RUN mode
1578: --
1579: IF (funcmode = 'RUN') THEN
1580: -- Get the values for term_rec before checking rule
1581: l_contract_id := WF_ENGINE.GetItemAttrNumber(
1582: itemtype => itemtype,
1583: itemkey => itemkey,
1584: aname => 'CONTRACT_ID');
1585:

Line 1690: l_contract_id := WF_ENGINE.GetItemAttrNumber(

1686: -- RUN mode
1687: --
1688: IF (funcmode = 'RUN') THEN
1689:
1690: l_contract_id := WF_ENGINE.GetItemAttrNumber(
1691: itemtype => itemtype,
1692: itemkey => itemkey,
1693: aname => 'CONTRACT_ID');
1694:

Line 1695: WF_ENGINE.SetItemAttrText(

1691: itemtype => itemtype,
1692: itemkey => itemkey,
1693: aname => 'CONTRACT_ID');
1694:
1695: WF_ENGINE.SetItemAttrText(
1696: itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'RECIPIENT_ID',
1699: avalue => '0'); -- intialize

Line 1701: WF_ENGINE.SetItemAttrNumber(

1697: itemkey => itemkey,
1698: aname => 'RECIPIENT_ID',
1699: avalue => '0'); -- intialize
1700:
1701: WF_ENGINE.SetItemAttrNumber(
1702: itemtype => itemtype,
1703: itemkey => itemkey,
1704: aname => 'CURRENT_REC_ID',
1705: avalue => 0); -- intialized to 0

Line 1708: /*WF_ENGINE.SetItemAttrText(

1704: aname => 'CURRENT_REC_ID',
1705: avalue => 0); -- intialized to 0
1706:
1707: --12/20/06 rkuttiya changed recipient type to VENDOR
1708: /*WF_ENGINE.SetItemAttrText(
1709: itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'RECIPIENT_TYPE',
1712: avalue => 'V'); -- always for Service and Maintenance */

Line 1713: WF_ENGINE.SetItemAttrText(

1709: itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'RECIPIENT_TYPE',
1712: avalue => 'V'); -- always for Service and Maintenance */
1713: WF_ENGINE.SetItemAttrText(
1714: itemtype => itemtype,
1715: itemkey => itemkey,
1716: aname => 'RECIPIENT_TYPE',
1717: avalue => 'VENDOR');

Line 1719: WF_ENGINE.SetItemAttrText(

1715: itemkey => itemkey,
1716: aname => 'RECIPIENT_TYPE',
1717: avalue => 'VENDOR');
1718:
1719: WF_ENGINE.SetItemAttrText(
1720: itemtype => itemtype,
1721: itemkey => itemkey,
1722: aname => 'PROCESS_CODE',
1723: avalue => 'AMQSM'); -- for Service and Maintenance

Line 1869: l_contract_id := WF_ENGINE.GetItemAttrNumber(

1865: IF (is_debug_procedure_on) THEN
1866: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1867: END IF;
1868:
1869: l_contract_id := WF_ENGINE.GetItemAttrNumber(
1870: itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'CONTRACT_ID');
1873:

Line 1874: l_current_rec_id := WF_ENGINE.GetItemAttrNumber(

1870: itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'CONTRACT_ID');
1873:
1874: l_current_rec_id := WF_ENGINE.GetItemAttrNumber(
1875: itemtype => itemtype,
1876: itemkey => itemkey,
1877: aname => 'CURRENT_REC_ID');
1878:

Line 1891: WF_ENGINE.SetItemAttrText(

1887: ELSE
1888: resultout := 'COMPLETE:NOTIFY_OUTSTANDING';
1889: END IF;
1890:
1891: WF_ENGINE.SetItemAttrText(
1892: itemtype => itemtype,
1893: itemkey => itemkey,
1894: aname => 'RECIPIENT_ID',
1895: avalue => l_recipient_id);

Line 1908: WF_ENGINE.SetItemAttrText(

1904: FETCH c_recipient INTO l_to_email;
1905: CLOSE c_recipient;
1906: -- ansethur 30-jul-2007 R12B XMLP start changes
1907: -- set the email address attribute
1908: WF_ENGINE.SetItemAttrText(
1909: itemtype => itemtype,
1910: itemkey => itemkey,
1911: aname => 'EMAIL_ADDRESS',
1912: avalue => l_to_email);

Line 1914: WF_ENGINE.SetItemAttrNumber(

1910: itemkey => itemkey,
1911: aname => 'EMAIL_ADDRESS',
1912: avalue => l_to_email);
1913:
1914: WF_ENGINE.SetItemAttrNumber(
1915: itemtype => itemtype,
1916: itemkey => itemkey,
1917: aname => 'CURRENT_REC_ID',
1918: avalue => l_line_id);

Line 1921: WF_ENGINE.SetItemAttrText(

1917: aname => 'CURRENT_REC_ID',
1918: avalue => l_line_id);
1919: -- Since the Fulfillment query take p_id which is transaction id
1920: -- set transaction id to line id
1921: WF_ENGINE.SetItemAttrText(
1922: itemtype => itemtype,
1923: itemkey => itemkey,
1924: aname => 'TRANSACTION_ID',
1925: avalue => l_line_id);

Line 1927: l_quote_id := WF_ENGINE.GetItemAttrNumber(

1923: itemkey => itemkey,
1924: aname => 'TRANSACTION_ID',
1925: avalue => l_line_id);
1926: -- ansethur 26-jul-2007 R12B XMLP start changes
1927: l_quote_id := WF_ENGINE.GetItemAttrNumber(
1928: itemtype => itemtype,
1929: itemkey => itemkey,
1930: aname => 'QUOTE_ID');
1931:

Line 1940: WF_ENGINE.SetItemAttrText(

1936: OPEN c_agent_csr(l_agent_id);
1937: FETCH c_agent_csr INTO l_from_email;
1938: CLOSE c_agent_csr;
1939:
1940: WF_ENGINE.SetItemAttrText(
1941: itemtype => itemtype,
1942: itemkey => itemkey,
1943: aname => 'FROM_ADDRESS',
1944: avalue => l_from_email);

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

1969:
1970:
1971: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1972: l_batch_id := lx_xmp_rec.batch_id;
1973: wf_engine.SetItemAttrText ( itemtype=> itemtype,
1974: itemkey => itemkey,
1975: aname => 'BATCH_ID',
1976: avalue => l_batch_id );
1977: -- resultout := 'COMPLETE:SUCCESS'; commented by ansethur 26-jul-2007 for XMLP

Line 2061: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2057: --
2058: IF (funcmode = 'RUN') THEN
2059:
2060: -- Get the values for term_rec before checking rule
2061: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2062: itemkey => itemkey,
2063: aname => 'TRANSACTION_ID');
2064:
2065: OPEN c_qte_csr(l_id);

Line 2215: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2211: --
2212: IF (funcmode = 'RUN') THEN
2213:
2214: -- Get the values for term_rec before checking rule
2215: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2216: itemkey => itemkey,
2217: aname => 'TRANSACTION_ID');
2218:
2219: WF_ENGINE.SetItemAttrText(

Line 2219: WF_ENGINE.SetItemAttrText(

2215: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2216: itemkey => itemkey,
2217: aname => 'TRANSACTION_ID');
2218:
2219: WF_ENGINE.SetItemAttrText(
2220: itemtype => itemtype,
2221: itemkey => itemkey,
2222: aname => 'RECIPIENT_ID',
2223: avalue => 0);

Line 2225: WF_ENGINE.SetItemAttrNumber(

2221: itemkey => itemkey,
2222: aname => 'RECIPIENT_ID',
2223: avalue => 0);
2224:
2225: WF_ENGINE.SetItemAttrNumber(
2226: itemtype => itemtype,
2227: itemkey => itemkey,
2228: aname => 'CURRENT_REC_ID',
2229: avalue => 0);

Line 2231: WF_ENGINE.SetItemAttrText(

2227: itemkey => itemkey,
2228: aname => 'CURRENT_REC_ID',
2229: avalue => 0);
2230:
2231: WF_ENGINE.SetItemAttrText(
2232: itemtype => itemtype,
2233: itemkey => itemkey,
2234: aname => 'PROCESS_CODE',
2235: avalue => 'AMQBS'); -- for Bill of Sale

Line 2364: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

2360: --
2361: IF (funcmode = 'RUN') THEN
2362:
2363: -- Get the values
2364: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2365: itemkey => itemkey,
2366: aname => 'TRANSACTION_ID');
2367:
2368: l_current_rec_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2368: l_current_rec_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2364: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
2365: itemkey => itemkey,
2366: aname => 'TRANSACTION_ID');
2367:
2368: l_current_rec_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2369: itemkey => itemkey,
2370: aname => 'CURRENT_REC_ID');
2371:
2372: -- Get recipient info

Line 2425: WF_ENGINE.SetItemAttrText(

2421: OPEN c_requestor_csr(l_requestor_id);
2422: FETCH c_requestor_csr INTO l_from_email;
2423: CLOSE c_requestor_csr;
2424:
2425: WF_ENGINE.SetItemAttrText(
2426: itemtype => itemtype,
2427: itemkey => itemkey,
2428: aname => 'RECIPIENT_ID',
2429: avalue => l_recipient_id);

Line 2431: WF_ENGINE.SetItemAttrText(

2427: itemkey => itemkey,
2428: aname => 'RECIPIENT_ID',
2429: avalue => l_recipient_id);
2430:
2431: WF_ENGINE.SetItemAttrText(
2432: itemtype => itemtype,
2433: itemkey => itemkey,
2434: aname => 'RECIPIENT_TYPE',
2435: avalue => l_recipient_type);

Line 2437: WF_ENGINE.SetItemAttrText(

2433: itemkey => itemkey,
2434: aname => 'RECIPIENT_TYPE',
2435: avalue => l_recipient_type);
2436:
2437: WF_ENGINE.SetItemAttrText(
2438: itemtype => itemtype,
2439: itemkey => itemkey,
2440: aname => 'EMAIL_ADDRESS',
2441: avalue => l_email_id);

Line 2445: WF_ENGINE.SetItemAttrText(

2441: avalue => l_email_id);
2442:
2443: --12/20/06 rkuttiya commented for XMLP project
2444: --set the from email address
2445: WF_ENGINE.SetItemAttrText(
2446: itemtype => itemtype,
2447: itemkey => itemkey,
2448: aname => 'FROM_ADDRESS',
2449: avalue => l_from_email);

Line 2452: WF_ENGINE.SetItemAttrNumber(

2448: aname => 'FROM_ADDRESS',
2449: avalue => l_from_email);
2450:
2451:
2452: WF_ENGINE.SetItemAttrNumber(
2453: itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'CURRENT_REC_ID',
2456: avalue => l_party_id);

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

2483:
2484:
2485: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
2486: l_batch_id := lx_xmp_rec.batch_id;
2487: wf_engine.SetItemAttrText ( itemtype=> itemtype,
2488: itemkey => itemkey,
2489: aname => 'BATCH_ID',
2490: avalue => l_batch_id );
2491: -- resultout := 'COMPLETE:SUCCESS'; commented by ansethur for XMLP

Line 2579: l_contract_id := WF_ENGINE.GetItemAttrNumber(

2575: --
2576: IF (funcmode = 'RUN') THEN
2577:
2578: -- Get the values for term_rec before checking rule
2579: l_contract_id := WF_ENGINE.GetItemAttrNumber(
2580: itemtype => itemtype,
2581: itemkey => itemkey,
2582: aname => 'CONTRACT_ID');
2583:

Line 2705: l_contract_id := WF_ENGINE.GetItemAttrNumber(

2701: -- RUN mode
2702: --
2703: IF (funcmode = 'RUN') THEN
2704: -- Get the values for term_rec before checking rule
2705: l_contract_id := WF_ENGINE.GetItemAttrNumber(
2706: itemtype => itemtype,
2707: itemkey => itemkey,
2708: aname => 'CONTRACT_ID');
2709:

Line 2710: WF_ENGINE.SetItemAttrText(

2706: itemtype => itemtype,
2707: itemkey => itemkey,
2708: aname => 'CONTRACT_ID');
2709:
2710: WF_ENGINE.SetItemAttrText(
2711: itemtype => itemtype,
2712: itemkey => itemkey,
2713: aname => 'RECIPIENT_ID',
2714: avalue => '0'); -- initialize

Line 2716: WF_ENGINE.SetItemAttrNumber(

2712: itemkey => itemkey,
2713: aname => 'RECIPIENT_ID',
2714: avalue => '0'); -- initialize
2715:
2716: WF_ENGINE.SetItemAttrNumber(
2717: itemtype => itemtype,
2718: itemkey => itemkey,
2719: aname => 'CURRENT_CLE_ID',
2720: avalue => 0);

Line 2722: WF_ENGINE.SetItemAttrText(

2718: itemkey => itemkey,
2719: aname => 'CURRENT_CLE_ID',
2720: avalue => 0);
2721:
2722: WF_ENGINE.SetItemAttrText(
2723: itemtype => itemtype,
2724: itemkey => itemkey,
2725: aname => 'PROCESS_CODE',
2726: avalue => 'AMQTF'); -- for Title/Filing

Line 2863: l_contract_id := WF_ENGINE.GetItemAttrNumber(

2859: -- RUN mode
2860: --
2861: IF (funcmode = 'RUN') THEN
2862: -- Get the values for term_rec before checking rule
2863: l_contract_id := WF_ENGINE.GetItemAttrNumber(
2864: itemtype => itemtype,
2865: itemkey => itemkey,
2866: aname => 'CONTRACT_ID');
2867:

Line 2868: l_current_rec_id := WF_ENGINE.GetItemAttrNumber(

2864: itemtype => itemtype,
2865: itemkey => itemkey,
2866: aname => 'CONTRACT_ID');
2867:
2868: l_current_rec_id := WF_ENGINE.GetItemAttrNumber(
2869: itemtype => itemtype,
2870: itemkey => itemkey,
2871: aname => 'CURRENT_CLE_ID');
2872:

Line 2926: WF_ENGINE.SetItemAttrNumber(

2922: --l_recipient_type := 'P';
2923: l_recipient_type := 'LESSEE';
2924: END IF;
2925:
2926: WF_ENGINE.SetItemAttrNumber(
2927: itemtype => itemtype,
2928: itemkey => itemkey,
2929: aname => 'CURRENT_CLE_ID',
2930: avalue => l_cle_id);

Line 2932: WF_ENGINE.SetItemAttrText(

2928: itemkey => itemkey,
2929: aname => 'CURRENT_CLE_ID',
2930: avalue => l_cle_id);
2931:
2932: WF_ENGINE.SetItemAttrText(
2933: itemtype => itemtype,
2934: itemkey => itemkey,
2935: aname => 'RECIPIENT_ID',
2936: avalue => l_rulv_rec.object1_id1);

Line 2938: WF_ENGINE.SetItemAttrText(

2934: itemkey => itemkey,
2935: aname => 'RECIPIENT_ID',
2936: avalue => l_rulv_rec.object1_id1);
2937:
2938: WF_ENGINE.SetItemAttrText(
2939: itemtype => itemtype,
2940: itemkey => itemkey,
2941: aname => 'RECIPIENT_TYPE',
2942: avalue => l_recipient_type);

Line 2951: WF_ENGINE.SetItemAttrText(

2947: FETCH c_recipient INTO l_to_email;
2948: CLOSE c_recipient;
2949:
2950: -- set the email address attribute
2951: WF_ENGINE.SetItemAttrText(
2952: itemtype => itemtype,
2953: itemkey => itemkey,
2954: aname => 'EMAIL_ADDRESS',
2955: avalue => l_to_email);

Line 2961: WF_ENGINE.SetItemAttrText(

2957:
2958:
2959: -- Since the Fulfillment query take p_id which is transaction id
2960: -- set transaction id to cle id
2961: WF_ENGINE.SetItemAttrText(
2962: itemtype => itemtype,
2963: itemkey => itemkey,
2964: aname => 'TRANSACTION_ID',
2965: avalue => l_cle_id);

Line 2967: l_quote_id := WF_ENGINE.GetItemAttrNumber(

2963: itemkey => itemkey,
2964: aname => 'TRANSACTION_ID',
2965: avalue => l_cle_id);
2966: -- ansethur 26-jul-2007 R12B XMLP start changes
2967: l_quote_id := WF_ENGINE.GetItemAttrNumber(
2968: itemtype => itemtype,
2969: itemkey => itemkey,
2970: aname => 'QUOTE_ID');
2971:

Line 2979: WF_ENGINE.SetItemAttrText(

2975:
2976: OPEN c_agent_csr(l_agent_id);
2977: FETCH c_agent_csr INTO l_from_email;
2978: CLOSE c_agent_csr;
2979: WF_ENGINE.SetItemAttrText(
2980: itemtype => itemtype,
2981: itemkey => itemkey,
2982: aname => 'FROM_ADDRESS',
2983: avalue => l_from_email);

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

3010:
3011:
3012: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
3013: l_batch_id := lx_xmp_rec.batch_id;
3014: wf_engine.SetItemAttrText ( itemtype=> itemtype,
3015: itemkey => itemkey,
3016: aname => 'BATCH_ID',
3017: avalue => l_batch_id );
3018: -- resultout := 'COMPLETE:SUCCESS'; commented by ansethur 26-jul-2007 for XMLP

Line 3117: l_transaction_id := WF_ENGINE.GetItemAttrText(

3113: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
3114: END IF;
3115:
3116: --get attr for transaction id
3117: l_transaction_id := WF_ENGINE.GetItemAttrText(
3118: itemtype => itemtype,
3119: itemkey => itemkey,
3120: aname => 'TRANSACTION_ID');
3121:

Line 3128: WF_ENGINE.SetItemAttrNumber(

3124: FETCH okl_pop_contract_details_csr INTO l_k_id, l_k_number, l_requester_id;
3125: CLOSE okl_pop_contract_details_csr;
3126:
3127: -- Set the contract details to the item attributes of WF
3128: WF_ENGINE.SetItemAttrNumber(
3129: itemtype => itemtype,
3130: itemkey => itemkey,
3131: aname => 'CONTRACT_ID',
3132: avalue => l_k_id);

Line 3134: WF_ENGINE.SetItemAttrText(

3130: itemkey => itemkey,
3131: aname => 'CONTRACT_ID',
3132: avalue => l_k_id);
3133:
3134: WF_ENGINE.SetItemAttrText(
3135: itemtype => itemtype,
3136: itemkey => itemkey,
3137: aname => 'CONTRACT_NUMBER',
3138: avalue => l_k_number);

Line 3150: WF_ENGINE.SetItemAttrText(

3146: p_user_id => l_requester_id,
3147: x_name => l_requester,
3148: x_description => l_description);
3149:
3150: WF_ENGINE.SetItemAttrText(
3151: itemtype => itemtype,
3152: itemkey => itemkey,
3153: aname => 'WF_ADMINISTRATOR',
3154: avalue => l_requester);

Line 3270: l_transaction_id := WF_ENGINE.GetItemAttrText(

3266: --
3267: IF (funcmode = 'RUN') THEN
3268: -- Get the values for dispose_asset before calling the dispose_asset api
3269:
3270: l_transaction_id := WF_ENGINE.GetItemAttrText(
3271: itemtype => itemtype,
3272: itemkey => itemkey,
3273: aname => 'TRANSACTION_ID');
3274:

Line 3516: l_transaction_id := WF_ENGINE.GetItemAttrText(

3512: --
3513: IF (funcmode = 'RUN') THEN
3514:
3515: --get attr for transaction id which is the quote id for quote WFs
3516: l_transaction_id := WF_ENGINE.GetItemAttrText(
3517: itemtype => itemtype,
3518: itemkey => itemkey,
3519: aname => 'TRANSACTION_ID');
3520:

Line 3720: l_transaction_id := WF_ENGINE.GetItemAttrText(

3716: --
3717: IF (funcmode = 'RUN') THEN
3718:
3719: --get attr for transaction id which is the quote id for quote WFs
3720: l_transaction_id := WF_ENGINE.GetItemAttrText(
3721: itemtype => itemtype,
3722: itemkey => itemkey,
3723: aname => 'TRANSACTION_ID');
3724:

Line 3952: l_transaction_id := WF_ENGINE.GetItemAttrText(

3948: -- RUN mode
3949: --
3950: IF (funcmode = 'RUN') THEN
3951: --get attr for transaction id which is the quote id for quote WFs
3952: l_transaction_id := WF_ENGINE.GetItemAttrText(
3953: itemtype => itemtype,
3954: itemkey => itemkey,
3955: aname => 'TRANSACTION_ID');
3956:

Line 4138: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

4134: --
4135: IF (funcmode = 'RUN') THEN
4136: -- Get the values for dispose_asset before calling the dispose_asset api
4137:
4138: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
4139: itemkey => itemkey,
4140: aname => 'TRANSACTION_ID');
4141:
4142: OPEN get_quote_csr(l_quote_id);

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

4167: -- Check that a quote id is returned for the TRANSACTION_ID given.
4168:
4169: IF l_quote_rec.last_updated_by IS NOT NULL THEN
4170:
4171: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
4172: itemkey => itemkey,
4173: aname => 'CREATED_BY',
4174: avalue => l_quote_rec.last_updated_by);
4175:

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

4172: itemkey => itemkey,
4173: aname => 'CREATED_BY',
4174: avalue => l_quote_rec.last_updated_by);
4175:
4176: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4177: itemkey => itemkey,
4178: aname => 'REQUESTER',
4179: avalue => l_user_name);
4180:

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

4177: itemkey => itemkey,
4178: aname => 'REQUESTER',
4179: avalue => l_user_name);
4180:
4181: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4182: itemkey => itemkey,
4183: aname => 'NOTIFY_AGENT',
4184: avalue => l_user_name);
4185:

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

4183: aname => 'NOTIFY_AGENT',
4184: avalue => l_user_name);
4185:
4186: -- Populate Item Attributes for Fulfillment
4187: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4188: itemkey => itemkey,
4189: aname => 'PROCESS_CODE',
4190: avalue => 'AMTER');
4191: --12/18/06 rkuttiya comented for XMLP Project

Line 4193: /* wf_engine.SetItemAttrText ( itemtype=> itemtype,

4189: aname => 'PROCESS_CODE',
4190: avalue => 'AMTER');
4191: --12/18/06 rkuttiya comented for XMLP Project
4192: --Recipient Type P changed to LESSEE
4193: /* wf_engine.SetItemAttrText ( itemtype=> itemtype,
4194: itemkey => itemkey,
4195: aname => 'RECIPIENT_TYPE',
4196: avalue => 'P'); */
4197:

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

4194: itemkey => itemkey,
4195: aname => 'RECIPIENT_TYPE',
4196: avalue => 'P'); */
4197:
4198: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4199: itemkey => itemkey,
4200: aname => 'RECIPIENT_TYPE',
4201: avalue => 'LESSEE');
4202:

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

4200: aname => 'RECIPIENT_TYPE',
4201: avalue => 'LESSEE');
4202:
4203:
4204: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4205: itemkey => itemkey,
4206: aname => 'RECIPIENT_ID',
4207: avalue => l_party_object_tbl(1).p_id1);
4208:

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

4206: aname => 'RECIPIENT_ID',
4207: avalue => l_party_object_tbl(1).p_id1);
4208:
4209:
4210: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4211: itemkey => itemkey,
4212: aname => 'RECIPIENT_DESCRIPTION',
4213: avalue => l_party_object_tbl(1).p_name);
4214:

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

4217: OPEN c_recipient(l_party_object_tbl(1).p_id1);
4218: FETCH c_recipient INTO l_to_email;
4219: CLOSE c_recipient;
4220:
4221: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4222: itemkey => itemkey,
4223: aname => 'EMAIL_ADDRESS',
4224: avalue => l_to_email);
4225:

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

4226: OPEN c_agent_csr(l_quote_rec.last_updated_by);
4227: FETCH c_agent_csr into l_from_email;
4228: CLOSE c_agent_csr;
4229:
4230: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4231: itemkey => itemkey,
4232: aname => 'FROM_EMAIL',
4233: avalue => l_from_email);
4234:

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

4260:
4261:
4262: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
4263: l_batch_id := lx_xmp_rec.batch_id;
4264: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4265: itemkey => itemkey,
4266: aname => 'BATCH_ID',
4267: avalue => l_batch_id );
4268: resultout := 'COMPLETE:VALID';

Line 4424: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4420: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
4421: END IF;
4422:
4423: IF (funcmode = 'RUN') THEN
4424: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4425: itemkey => itemkey,
4426: aname => 'TRANSACTION_ID');
4427:
4428: --build message

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

4463: l_comments||'

'||
4464: '

Please contact us before '||l_sent_date||' to confirm the quote amounts.'||
4465: '

';
4466:
4467: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4468: itemkey => itemkey,
4469: aname => 'TRX_TYPE_ID',
4470: avalue => 'OKLAMPAR');
4471:

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

4468: itemkey => itemkey,
4469: aname => 'TRX_TYPE_ID',
4470: avalue => 'OKLAMPAR');
4471:
4472: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4473: itemkey => itemkey,
4474: aname => 'MESSAGE_DESCRIPTION',
4475: avalue => l_message);
4476:

Line 4564: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4560: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
4561: END IF;
4562:
4563: IF (funcmode = 'RUN') THEN
4564: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4565: itemkey => itemkey,
4566: aname => 'TRANSACTION_ID');
4567:
4568:

Line 4569: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,

4565: itemkey => itemkey,
4566: aname => 'TRANSACTION_ID');
4567:
4568:
4569: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,
4570: itemkey => itemkey,
4571: aname => 'APPROVED_YN');
4572:
4573: l_notify_response := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 4573: l_notify_response := wf_engine.GetItemAttrText( itemtype => itemtype,

4569: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,
4570: itemkey => itemkey,
4571: aname => 'APPROVED_YN');
4572:
4573: l_notify_response := wf_engine.GetItemAttrText( itemtype => itemtype,
4574: itemkey => itemkey,
4575: aname => 'RESULT');
4576:
4577: IF nvl(l_approved, 'Y') = 'N' OR l_notify_response = 'REJECTED' THEN

Line 4727: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

4723: END IF;
4724:
4725: IF (funcmode = 'RUN') THEN
4726:
4727: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4728: itemkey => itemkey,
4729: aname => 'TRANSACTION_ID');
4730:
4731: l_projected_gl := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 4731: l_projected_gl := wf_engine.GetItemAttrNumber( itemtype => itemtype,

4727: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
4728: itemkey => itemkey,
4729: aname => 'TRANSACTION_ID');
4730:
4731: l_projected_gl := wf_engine.GetItemAttrNumber( itemtype => itemtype,
4732: itemkey => itemkey,
4733: aname => 'QUOTE_GL');
4734: --build message
4735: OPEN okl_quote_csr(l_id);

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

4745: '

Comments:
'||
4746: l_quote_rec.comments||'

'||
4747: '

The quote will be completed following your approval.

';
4748:
4749: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4750: itemkey => itemkey,
4751: aname => 'TRX_TYPE_ID',
4752: avalue => 'OKLAMGAL');
4753:

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

4750: itemkey => itemkey,
4751: aname => 'TRX_TYPE_ID',
4752: avalue => 'OKLAMGAL');
4753:
4754: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4755: itemkey => itemkey,
4756: aname => 'MESSAGE_DESCRIPTION',
4757: avalue => l_message);
4758:

Line 4909: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

4905: -- RUN mode
4906: --
4907: IF (funcmode = 'RUN') THEN
4908:
4909: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
4910: itemkey => itemkey,
4911: aname => 'TRANSACTION_ID');
4912:
4913: -- 20-Mar-06 rmunjulu 5087501 call okl_qte_pvt.update_row( ) to update the

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

4952: END IF;
4953:
4954: IF l_last_updated_by IS NOT NULL AND l_user_name IS NOT NULL THEN
4955:
4956: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4957: itemkey => itemkey,
4958: aname => 'REQUESTER',
4959: avalue => l_user_name);
4960:

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

4957: itemkey => itemkey,
4958: aname => 'REQUESTER',
4959: avalue => l_user_name);
4960:
4961: wf_engine.SetItemAttrText ( itemtype=> itemtype,
4962: itemkey => itemkey,
4963: aname => 'WF_ADMINISTRATOR',
4964: avalue => l_user_name);
4965:

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

4964: avalue => l_user_name);
4965:
4966: IF itemtype <> 'OKLAMRQT' THEN
4967:
4968: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
4969: itemkey => itemkey,
4970: aname => 'CREATED_BY',
4971: avalue => l_last_updated_by);
4972:

Line 4973: wf_engine.SetItemAttrText (

4969: itemkey => itemkey,
4970: aname => 'CREATED_BY',
4971: avalue => l_last_updated_by);
4972:
4973: wf_engine.SetItemAttrText (
4974: itemtype=> itemtype,
4975: itemkey => itemkey,
4976: aname => 'NOTIFY_AGENT',
4977: avalue => l_user_name);

Line 4979: wf_engine.SetItemAttrText (

4975: itemkey => itemkey,
4976: aname => 'NOTIFY_AGENT',
4977: avalue => l_user_name);
4978:
4979: wf_engine.SetItemAttrText (
4980: itemtype=> itemtype,
4981: itemkey => itemkey,
4982: aname => 'QUOTE_NUMBER',
4983: avalue => l_quote_number);

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

5025: RAISE API_ERROR;
5026: END IF;
5027:
5028: -- Populate Item Attributes for Fulfillment
5029: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5030: itemkey => itemkey,
5031: aname => 'PROCESS_CODE',
5032: avalue => 'AMTER');
5033:

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

5030: itemkey => itemkey,
5031: aname => 'PROCESS_CODE',
5032: avalue => 'AMTER');
5033:
5034: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5035: itemkey => itemkey,
5036: aname => 'RECIPIENT_ID',
5037: avalue => l_party_object_tbl(1).p_id1);
5038:

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

5036: aname => 'RECIPIENT_ID',
5037: avalue => l_party_object_tbl(1).p_id1);
5038:
5039:
5040: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5041: itemkey => itemkey,
5042: aname => 'RECIPIENT_DESCRIPTION',
5043: avalue => l_party_object_tbl(1).p_name);
5044:

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

5045: OPEN c_recipient(l_party_object_tbl(1).p_id1);
5046: FETCH c_recipient INTO l_to_email;
5047: CLOSE c_recipient;
5048:
5049: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5050: itemkey => itemkey,
5051: aname => 'EMAIL_ADDRESS',
5052: avalue => l_to_email);
5053:

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

5054: OPEN c_agent_csr(l_quote_rec.last_updated_by);
5055: FETCH c_agent_csr into l_from_email;
5056: CLOSE c_agent_csr;
5057:
5058: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5059: itemkey => itemkey,
5060: aname => 'FROM_ADDRESS',
5061: avalue => l_from_email);
5062: --18-Dec-06 rkuttiya added for XMLP Project

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

5087:
5088:
5089: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
5090: l_batch_id := lx_xmp_rec.batch_id;
5091: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5092: itemkey => itemkey,
5093: aname => 'BATCH_ID',
5094: avalue => l_batch_id );
5095:

Line 5229: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

5225: END IF;
5226:
5227: IF (funcmode = 'RUN') THEN
5228:
5229: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
5230: itemkey => itemkey,
5231: aname => 'TRANSACTION_ID');
5232:
5233: --build message

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

5243: '

Comments:
'||
5244: l_quote_rec.comments||'

'||
5245: '

The quote will be porcessed following your approval.

';
5246:
5247: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5248: itemkey => itemkey,
5249: aname => 'TRX_TYPE_ID',
5250: avalue => 'OKLAMRQT');
5251:

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

5248: itemkey => itemkey,
5249: aname => 'TRX_TYPE_ID',
5250: avalue => 'OKLAMRQT');
5251:
5252: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5253: itemkey => itemkey,
5254: aname => 'MESSAGE_DESCRIPTION',
5255: avalue => l_message);
5256:

Line 5346: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

5342: END IF;
5343:
5344: IF (funcmode = 'RUN') THEN
5345:
5346: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
5347: itemkey => itemkey,
5348: aname => 'TRANSACTION_ID');
5349:
5350: OPEN c_qte_csr(l_id);

Line 5630: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

5626: END IF;
5627:
5628: IF (funcmode = 'RUN') THEN
5629:
5630: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
5631: itemkey => itemkey,
5632: aname => 'TRANSACTION_ID');
5633:
5634:

Line 5677: wf_engine.SetItemAttrText (

5673:
5674: --rkuttiya 18-SEP-2003 added for bug 2794685
5675: IF l_result = 'COMPLETE:STOP' THEN
5676: --Set notification body
5677: wf_engine.SetItemAttrText (
5678: itemtype=> itemtype,
5679: itemkey => itemkey,
5680: aname => 'MESSAGE_DOC',
5681: avalue => 'plsql:okl_am_quotes_wf.pop_stop_notification/'||l_id||':'||G_STOP);

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

5692: , x_description => l_name);
5693:
5694: --set the value for item attribute 'REQUESTER'
5695:
5696: wf_engine.SetItemAttrText ( itemtype => itemtype,
5697: itemkey => itemkey,
5698: aname => 'REQUESTER',
5699: avalue => l_user_name);
5700: END IF;

Line 5789: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

5785: END IF;
5786:
5787: IF (funcmode = 'RUN') THEN
5788:
5789: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
5790: itemkey => itemkey,
5791: aname => 'TRANSACTION_ID');
5792:
5793: l_q_party_uv_rec.quote_id := l_quote_id;

Line 5819: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

5815:
5816:
5817: IF l_party_count > 0 THEN
5818:
5819: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
5820: itemkey => itemkey,
5821: aname => 'PARTY_COUNT',
5822: avalue => l_party_count);
5823:

Line 5825: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

5821: aname => 'PARTY_COUNT',
5822: avalue => l_party_count);
5823:
5824:
5825: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
5826: itemkey => itemkey,
5827: aname => 'PARTY_TYPE',
5828: avalue => 'APPROVER');
5829:

Line 5831: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

5827: aname => 'PARTY_TYPE',
5828: avalue => 'APPROVER');
5829:
5830:
5831: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
5832: itemkey => itemkey,
5833: aname => 'PROCESS_CODE',
5834: avalue => 'AMTER');
5835:

Line 5922: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

5918:
5919: IF (funcmode = 'RUN') THEN
5920: -- Get the values for dispose_asset before calling the dispose_asset api
5921:
5922: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
5923: itemkey => itemkey,
5924: aname => 'TRANSACTION_ID');
5925:
5926: l_party_count := WF_ENGINE.GetItemAttrNumber( itemtype => itemtype,

Line 5926: l_party_count := WF_ENGINE.GetItemAttrNumber( itemtype => itemtype,

5922: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
5923: itemkey => itemkey,
5924: aname => 'TRANSACTION_ID');
5925:
5926: l_party_count := WF_ENGINE.GetItemAttrNumber( itemtype => itemtype,
5927: itemkey => itemkey,
5928: aname => 'PARTY_COUNT');
5929:
5930: l_party_type := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 5930: l_party_type := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

5926: l_party_count := WF_ENGINE.GetItemAttrNumber( itemtype => itemtype,
5927: itemkey => itemkey,
5928: aname => 'PARTY_COUNT');
5929:
5930: l_party_type := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
5931: itemkey => itemkey,
5932: aname => 'PARTY_TYPE');
5933:
5934: l_q_party_uv_rec.quote_id := l_quote_id;

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

5952: END IF;
5953:
5954: IF l_q_party_uv_tbl(l_party_count).co_email IS NOT NULL THEN
5955:
5956: wf_engine.SetItemAttrText ( itemtype=> itemtype,
5957: itemkey => itemkey,
5958: aname => 'EMAIL_ADDRESS',
5959: avalue => l_q_party_uv_tbl(l_party_count).co_email);
5960:

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

6023: IF l_q_party_uv_tbl(l_party_count).co_email IS NULL THEN
6024: -- Populate remaining Item Attributes for Fulfillment
6025:
6026: IF l_recipient_type IS NOT NULL THEN
6027: wf_engine.SetItemAttrText ( itemtype=> itemtype,
6028: itemkey => itemkey,
6029: aname => 'RECIPIENT_TYPE',
6030: avalue => l_recipient_type);
6031: ELSE

Line 6042: wf_engine.SetItemAttrText (

6038: RAISE MISSING_DETAILS_ERROR;
6039: END IF;
6040:
6041: IF l_recipient_id IS NOT NULL THEN
6042: wf_engine.SetItemAttrText (
6043: itemtype=> itemtype,
6044: itemkey => itemkey,
6045: aname => 'RECIPIENT_ID',
6046: avalue => l_recipient_id);

Line 6060: l_external_approver := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

6056: END IF;
6057:
6058: IF l_party_type = 'APPROVER' AND l_recipient_desc IS NOT NULL THEN
6059:
6060: l_external_approver := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
6061: itemkey => itemkey,
6062: aname => 'EXTERNAL_APPROVER');
6063:
6064: IF l_external_approver IS NOT NULL THEN

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

6066: ELSE
6067: l_external_approver := ''||l_recipient_desc||'';
6068: END IF;
6069:
6070: wf_engine.SetItemAttrText ( itemtype=> itemtype,
6071: itemkey => itemkey,
6072: aname => 'EXTERNAL_APPROVER',
6073: avalue => l_external_approver);
6074:

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

6074:
6075: END IF;
6076: --19-jul-2007 ansethur R12B XML Publisher Starts
6077: IF l_recipient_type IS NOT NULL THEN
6078: wf_engine.SetItemAttrText ( itemtype=> itemtype,
6079: itemkey => itemkey,
6080: aname => 'RECIPIENT_TYPE',
6081: avalue => l_recipient_type);
6082: ELSE

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

6089: RAISE MISSING_DETAILS_ERROR;
6090: END IF;
6091:
6092: IF l_recipient_id IS NOT NULL THEN
6093: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
6094: itemkey => itemkey,
6095: aname => 'RECIPIENT_ID',
6096: avalue => l_recipient_id);
6097: ELSE

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

6103:
6104: RAISE MISSING_DETAILS_ERROR;
6105: END IF;
6106: --19-jul-2007 ansethur R12B XML Publisher Ends
6107: wf_engine.SetItemAttrText ( itemtype=> itemtype,
6108: itemkey => itemkey,
6109: aname => 'RECIPIENT_DESCRIPTION',
6110: avalue => l_recipient_desc);
6111:

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

6109: aname => 'RECIPIENT_DESCRIPTION',
6110: avalue => l_recipient_desc);
6111:
6112: -- Decrement party counter
6113: wf_engine.SetItemAttrNumber ( itemtype=> itemtype,
6114: itemkey => itemkey,
6115: aname => 'PARTY_COUNT',
6116: avalue => l_party_count-1);
6117:

Line 6129: WF_ENGINE.SetItemAttrText(

6125: resultout := 'COMPLETE:NO_EMAIL';
6126: END IF;
6127: ELSE
6128: -- MDOKAL, 15-APR-2003 Bug 2862254, Fix for HTML Notification Issue
6129: WF_ENGINE.SetItemAttrText(
6130: itemtype => itemtype,
6131: itemkey => itemkey,
6132: aname => 'EXTERNAL_APPROVER_DOC',
6133: avalue => 'plsql:okl_am_quotes_wf.pop_external_approver_doc/'||itemkey);

Line 6205: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

6201: END IF;
6202:
6203: IF (funcmode = 'RUN') THEN
6204:
6205: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
6206: itemkey => itemkey,
6207: aname => 'TRANSACTION_ID');
6208:
6209: l_q_party_uv_rec.quote_id := l_quote_id;

Line 6237: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype,

6233: OPEN c_delay_days_csr(l_quote_id);
6234: FETCH c_delay_days_csr INTO l_delay_days;
6235: CLOSE c_delay_days_csr;
6236:
6237: WF_ENGINE.SetItemAttrNumber( itemtype => itemtype,
6238: itemkey => itemkey,
6239: aname => 'NOTICE_DELAY',
6240: avalue => l_delay_days);
6241:

Line 6242: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6238: itemkey => itemkey,
6239: aname => 'NOTICE_DELAY',
6240: avalue => l_delay_days);
6241:
6242: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6243: itemkey => itemkey,
6244: aname => 'PARTY_COUNT',
6245: avalue => l_party_count);
6246:

Line 6248: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6244: aname => 'PARTY_COUNT',
6245: avalue => l_party_count);
6246:
6247:
6248: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6249: itemkey => itemkey,
6250: aname => 'PARTY_TYPE',
6251: avalue => 'ADVANCE_NOTICE');
6252:

Line 6254: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6250: aname => 'PARTY_TYPE',
6251: avalue => 'ADVANCE_NOTICE');
6252:
6253:
6254: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6255: itemkey => itemkey,
6256: aname => 'PROCESS_CODE',
6257: avalue => 'AMTER');
6258:

Line 6339: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

6335: END IF;
6336:
6337: IF (funcmode = 'RUN') THEN
6338:
6339: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
6340: itemkey => itemkey,
6341: aname => 'TRANSACTION_ID');
6342:
6343: l_q_party_uv_rec.quote_id := l_quote_id;

Line 6367: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6363: END IF;
6364:
6365: IF l_party_count > 0 THEN
6366:
6367: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6368: itemkey => itemkey,
6369: aname => 'PARTY_COUNT',
6370: avalue => l_party_count);
6371:

Line 6373: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6369: aname => 'PARTY_COUNT',
6370: avalue => l_party_count);
6371:
6372:
6373: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6374: itemkey => itemkey,
6375: aname => 'PARTY_TYPE',
6376: avalue => 'RECIPIENT');
6377:

Line 6379: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6375: aname => 'PARTY_TYPE',
6376: avalue => 'RECIPIENT');
6377:
6378:
6379: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6380: itemkey => itemkey,
6381: aname => 'PROCESS_CODE',
6382: avalue => 'AMTER');
6383:

Line 6459: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

6455: END IF;
6456:
6457: IF (funcmode = 'RUN') THEN
6458:
6459: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
6460: itemkey => itemkey,
6461: aname => 'TRANSACTION_ID');
6462:
6463: l_q_party_uv_rec.quote_id := l_quote_id;

Line 6488: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6484: END IF;
6485:
6486: IF l_party_count > 0 THEN
6487:
6488: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6489: itemkey => itemkey,
6490: aname => 'PARTY_COUNT',
6491: avalue => l_party_count);
6492:

Line 6494: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6490: aname => 'PARTY_COUNT',
6491: avalue => l_party_count);
6492:
6493:
6494: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6495: itemkey => itemkey,
6496: aname => 'PARTY_TYPE',
6497: avalue => 'FYI');
6498:

Line 6500: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6496: aname => 'PARTY_TYPE',
6497: avalue => 'FYI');
6498:
6499:
6500: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6501: itemkey => itemkey,
6502: aname => 'PROCESS_CODE',
6503: avalue => 'AMTER');
6504:

Line 6581: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

6577: END IF;
6578:
6579: IF (funcmode = 'RUN') THEN
6580:
6581: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
6582: itemkey => itemkey,
6583: aname => 'TRANSACTION_ID');
6584:
6585: l_q_party_uv_rec.quote_id := l_quote_id;

Line 6613: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6609: END IF;
6610:
6611: IF l_party_count > 0 THEN
6612:
6613: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6614: itemkey => itemkey,
6615: aname => 'PARTY_COUNT',
6616: avalue => l_party_count);
6617:

Line 6619: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6615: aname => 'PARTY_COUNT',
6616: avalue => l_party_count);
6617:
6618:
6619: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6620: itemkey => itemkey,
6621: aname => 'PARTY_TYPE',
6622: avalue => 'RECIPIENT_ADDITIONAL');
6623:

Line 6625: WF_ENGINE.SetItemAttrText( itemtype => itemtype,

6621: aname => 'PARTY_TYPE',
6622: avalue => 'RECIPIENT_ADDITIONAL');
6623:
6624:
6625: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
6626: itemkey => itemkey,
6627: aname => 'PROCESS_CODE',
6628: avalue => 'AMTER');
6629:

Line 6853: wf_engine.SetItemAttrNumber(

6849: IF l_net_gain_loss < l_tolerance_amount THEN -- RMUNJULU Changed
6850:
6851: l_gain_loss_approval := 'COMPLETE:YES'; -- Gain Loss Approval is needed
6852:
6853: wf_engine.SetItemAttrNumber(
6854: itemtype => itemtype,
6855: itemkey => itemkey,
6856: aname => 'QUOTE_GL',
6857: avalue => (l_net_gain_loss));

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

6947: -- *********************************
6948:
6949: IF (l_quote_total - l_quote_net < l_tolerance) OR (l_always_approve_yn) THEN
6950:
6951: wf_engine.SetItemAttrNumber( itemtype => itemtype,
6952: itemkey => itemkey,
6953: aname => 'QUOTE_GL',
6954: avalue => (l_quote_total - l_quote_net));
6955: l_result := 'COMPLETE:Y';

Line 7053: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

7049: -- RUN mode
7050: --
7051: IF (funcmode = 'RUN') THEN
7052:
7053: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
7054: itemkey => itemkey,
7055: aname => 'TRANSACTION_ID');
7056:
7057: wf_engine.SetItemAttrText (

Line 7057: wf_engine.SetItemAttrText (

7053: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
7054: itemkey => itemkey,
7055: aname => 'TRANSACTION_ID');
7056:
7057: wf_engine.SetItemAttrText (
7058: itemtype=> itemtype,
7059: itemkey => itemkey,
7060: aname => 'MESSAGE_DOC',
7061: avalue => 'plsql:okl_am_quotes_wf.pop_oklamnmq_doc/'||l_quote_id);

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

7072: , p_user_id => r_qte_details.last_updated_by
7073: , x_name => l_user_name
7074: , x_description => l_name);
7075:
7076: wf_engine.SetItemAttrText ( itemtype=> itemtype,
7077: itemkey => itemkey,
7078: aname => 'REQUESTER',
7079: avalue => l_user_name);
7080:

Line 7081: wf_engine.SetItemAttrText (

7077: itemkey => itemkey,
7078: aname => 'REQUESTER',
7079: avalue => l_user_name);
7080:
7081: wf_engine.SetItemAttrText (
7082: itemtype=> itemtype,
7083: itemkey => itemkey,
7084: aname => 'QUOTE_NUMBER',
7085: avalue => r_qte_details.quote_number);

Line 7087: wf_engine.SetItemAttrText (

7083: itemkey => itemkey,
7084: aname => 'QUOTE_NUMBER',
7085: avalue => r_qte_details.quote_number);
7086:
7087: wf_engine.SetItemAttrText (
7088: itemtype=> itemtype,
7089: itemkey => itemkey,
7090: aname => 'CONTRACT_NUMBER',
7091: avalue => r_qte_details.contract_number);

Line 7093: wf_engine.SetItemAttrText (

7089: itemkey => itemkey,
7090: aname => 'CONTRACT_NUMBER',
7091: avalue => r_qte_details.contract_number);
7092:
7093: wf_engine.SetItemAttrText (
7094: itemtype=> itemtype,
7095: itemkey => itemkey,
7096: aname => 'CONTRACT_NAME',
7097: avalue => r_qte_details.contract_name);

Line 7199: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

7195: -- RUN mode
7196: --
7197: IF (funcmode = 'RUN') THEN
7198:
7199: l_quote_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
7200: itemkey => itemkey,
7201: aname => 'TRANSACTION_ID');
7202:
7203: OPEN get_quote_csr(l_quote_id);

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

7215: -- Check that a quote id is returned for the TRANSACTION_ID given.
7216:
7217: IF l_last_updated_by IS NOT NULL AND l_user_name IS NOT NULL THEN
7218:
7219: wf_engine.SetItemAttrText ( itemtype=> itemtype,
7220: itemkey => itemkey,
7221: aname => 'REQUESTER',
7222: avalue => l_user_name);
7223:

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

7220: itemkey => itemkey,
7221: aname => 'REQUESTER',
7222: avalue => l_user_name);
7223:
7224: wf_engine.SetItemAttrText ( itemtype=> itemtype,
7225: itemkey => itemkey,
7226: aname => 'WF_ADMINISTRATOR',
7227: avalue => l_user_name);
7228:

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

7225: itemkey => itemkey,
7226: aname => 'WF_ADMINISTRATOR',
7227: avalue => l_user_name);
7228:
7229: wf_engine.SetItemAttrText ( itemtype=> itemtype,
7230: itemkey => itemkey,
7231: aname => 'QUOTE_NUMBER',
7232: avalue => l_quote_number);
7233:

Line 7328: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

7324: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
7325: END IF;
7326:
7327: IF (funcmode = 'RUN') THEN
7328: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
7329: itemkey => itemkey,
7330: aname => 'TRANSACTION_ID');
7331:
7332:

Line 7333: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,

7329: itemkey => itemkey,
7330: aname => 'TRANSACTION_ID');
7331:
7332:
7333: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,
7334: itemkey => itemkey,
7335: aname => 'APPROVED_YN');
7336:
7337: -- Set the quote status to REJECTED if the approval is declined

Line 7462: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

7458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
7459: END IF;
7460:
7461: IF (funcmode = 'RUN') THEN
7462: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
7463: itemkey => itemkey,
7464: aname => 'TRANSACTION_ID');
7465:
7466: l_performer := rtrim(ltrim(fnd_profile.value('OKL_MANUAL_TERMINATION_QUOTE_REP')));

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

7464: aname => 'TRANSACTION_ID');
7465:
7466: l_performer := rtrim(ltrim(fnd_profile.value('OKL_MANUAL_TERMINATION_QUOTE_REP')));
7467:
7468: wf_engine.SetItemAttrText( itemtype => itemtype,
7469: itemkey => itemkey,
7470: aname => 'PERFORMING_AGENT',
7471: avalue => l_performer);
7472:

Line 7691: l_message := wf_engine.GetItemAttrText (

7687: IF (is_debug_procedure_on) THEN
7688: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
7689: END IF;
7690:
7691: l_message := wf_engine.GetItemAttrText (
7692: itemtype => 'OKLAMPPT',
7693: itemkey => document_id,
7694: aname => 'MESSAGE_DESCRIPTION');
7695:

Line 7748: l_message := wf_engine.GetItemAttrText (

7744: IF (is_debug_procedure_on) THEN
7745: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
7746: END IF;
7747:
7748: l_message := wf_engine.GetItemAttrText (
7749: itemtype => 'OKLAMNQT',
7750: itemkey => document_id,
7751: aname => 'EXTERNAL_APPROVER');
7752:

Line 7804: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,

7800: END IF;
7801:
7802: IF (funcmode = 'RUN') THEN
7803:
7804: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,
7805: itemkey => itemkey,
7806: aname => 'APPROVED_YN');
7807:
7808: IF nvl(l_approved, 'Y') = 'Y' THEN

Line 7885: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,

7881: END IF;
7882:
7883: IF (funcmode = 'RUN') THEN
7884:
7885: l_approved := wf_engine.GetItemAttrText( itemtype => itemtype,
7886: itemkey => itemkey,
7887: aname => 'APPROVED_YN');
7888:
7889: IF nvl(l_approved, 'Y') = 'Y' THEN

Line 7987: l_quote_id := wf_engine.GetItemAttrText( itemtype => itemtype,

7983: END IF;
7984:
7985: IF (funcmode = 'RUN') THEN
7986:
7987: l_quote_id := wf_engine.GetItemAttrText( itemtype => itemtype,
7988: itemkey => itemkey,
7989: aname => 'TRANSACTION_ID');
7990:
7991: -- rmunjulu EDAT Added to get quote dates which are now passed to securitization API

Line 8116: l_transaction_id := WF_ENGINE.GetItemAttrText(

8112: -- RUN mode
8113: --
8114: IF (funcmode = 'RUN') THEN
8115: --get attr for transaction id which is the quote id for quote WFs
8116: l_transaction_id := WF_ENGINE.GetItemAttrText(
8117: itemtype => itemtype,
8118: itemkey => itemkey,
8119: aname => 'TRANSACTION_ID');
8120:

Line 8353: l_id := wf_engine.GetItemAttrText(

8349: END IF;
8350:
8351: IF (funcmode = 'RUN') THEN
8352:
8353: l_id := wf_engine.GetItemAttrText(
8354: itemtype => itemtype,
8355: itemkey => itemkey,
8356: aname => 'TRANSACTION_ID');
8357:

Line 8388: wf_engine.SetItemAttrText (

8384: p_msg_name => 'OKL_AM_ROLL_HDR_MSG');
8385:
8386: l_roll_message_header := FND_MESSAGE.get;
8387:
8388: wf_engine.SetItemAttrText (
8389: itemtype=> itemtype,
8390: itemkey => itemkey,
8391: aname => 'MESSAGE_HEADER',
8392: avalue => l_roll_message_header);

Line 8395: wf_engine.SetItemAttrText (

8391: aname => 'MESSAGE_HEADER',
8392: avalue => l_roll_message_header);
8393:
8394: --Set notification body
8395: wf_engine.SetItemAttrText (
8396: itemtype=> itemtype,
8397: itemkey => itemkey,
8398: aname => 'MESSAGE_DOC',
8399: avalue => 'plsql:okl_am_quotes_wf.pop_roll_notification/'||l_id);

Line 8412: wf_engine.SetItemAttrText (

8408: , x_name => l_user_name
8409: , x_description => l_name);
8410:
8411: --set the value for item attribute 'REQUESTER'
8412: wf_engine.SetItemAttrText (
8413: itemtype => itemtype,
8414: itemkey => itemkey,
8415: aname => 'REQUESTER',
8416: avalue => l_user_name);

Line 8591: l_id := wf_engine.GetItemAttrText(itemtype => itemtype,

8587: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
8588: END IF;
8589:
8590: IF (funcmode = 'RUN') THEN
8591: l_id := wf_engine.GetItemAttrText(itemtype => itemtype,
8592: itemkey => itemkey,
8593: aname => 'TRANSACTION_ID');
8594:
8595:

Line 8703: l_id := wf_engine.GetItemAttrText(itemtype => itemtype,

8699:
8700: l_func_curr_code := okl_am_util_pvt.get_functional_currency;
8701:
8702: IF funcmode = 'RUN' THEN
8703: l_id := wf_engine.GetItemAttrText(itemtype => itemtype,
8704: itemkey => itemkey,
8705: aname => 'TRANSACTION_ID');
8706:
8707: OPEN c_khr_csr(l_id);