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 4725: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,

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

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

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

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

4743: '

Comments:
'||
4744: l_quote_rec.comments||'

'||
4745: '

The quote will be completed following your approval.

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

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

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

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

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

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

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

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

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

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

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

Line 4971: wf_engine.SetItemAttrText (

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

Line 4977: wf_engine.SetItemAttrText (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5241: '

Comments:
'||
5242: l_quote_rec.comments||'

'||
5243: '

The quote will be porcessed following your approval.

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

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

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

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

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

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

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

Line 5675: wf_engine.SetItemAttrText (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6040: wf_engine.SetItemAttrText (

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6127: WF_ENGINE.SetItemAttrText(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6851: wf_engine.SetItemAttrNumber(

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

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

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

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

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

Line 7055: wf_engine.SetItemAttrText (

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

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

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

Line 7079: wf_engine.SetItemAttrText (

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

Line 7085: wf_engine.SetItemAttrText (

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

Line 7091: wf_engine.SetItemAttrText (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 7689: l_message := wf_engine.GetItemAttrText (

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

Line 7746: l_message := wf_engine.GetItemAttrText (

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

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

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

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

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

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

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

Line 8114: l_transaction_id := WF_ENGINE.GetItemAttrText(

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

Line 8351: l_id := wf_engine.GetItemAttrText(

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

Line 8386: wf_engine.SetItemAttrText (

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

Line 8393: wf_engine.SetItemAttrText (

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

Line 8410: wf_engine.SetItemAttrText (

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

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

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

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

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