DBA Data[Home] [Help]

APPS.OKL_AM_REMARKET_ASSET_WF dependencies on WF_ENGINE

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

118: BEGIN
119:
120: IF (funcmode = 'RUN') THEN
121:
122: l_id := wf_engine.GetItemAttrText( itemtype => itemtype,
123: itemkey => itemkey,
124: aname => 'ASSET_RETURN_ID');
125:
126: OPEN l_assetreturn_csr(to_number(l_id));

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

138: , p_user_id => l_last_updated_by
139: , x_name => l_user
140: , x_description => l_name);
141:
142: wf_engine.SetItemAttrText ( itemtype=> itemtype,
143: itemkey => itemkey,
144: aname => 'WF_ADMINISTRATOR',
145: avalue => l_user);
146:

Line 233: l_asset_return_id := wf_engine.GetItemAttrText( itemtype => itemtype,

229: BEGIN
230:
231: IF (funcmode = 'RUN') THEN
232:
233: l_asset_return_id := wf_engine.GetItemAttrText( itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'ASSET_RETURN_ID');
236:
237: l_item_number := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 237: l_item_number := wf_engine.GetItemAttrText( itemtype => itemtype,

233: l_asset_return_id := wf_engine.GetItemAttrText( itemtype => itemtype,
234: itemkey => itemkey,
235: aname => 'ASSET_RETURN_ID');
236:
237: l_item_number := wf_engine.GetItemAttrText( itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'ITEM_NUMBER');
240:
241: l_item_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 241: l_item_desc := wf_engine.GetItemAttrText( itemtype => itemtype,

237: l_item_number := wf_engine.GetItemAttrText( itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'ITEM_NUMBER');
240:
241: l_item_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'ITEM_DESC');
244:
245: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 changed to GetItemAttrNumber

Line 245: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 changed to GetItemAttrNumber

241: l_item_desc := wf_engine.GetItemAttrText( itemtype => itemtype,
242: itemkey => itemkey,
243: aname => 'ITEM_DESC');
244:
245: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 changed to GetItemAttrNumber
246: itemkey => itemkey,
247: aname => 'ITEM_PRICE');
248:
249: l_item_qty := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 249: l_item_qty := wf_engine.GetItemAttrText( itemtype => itemtype,

245: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 changed to GetItemAttrNumber
246: itemkey => itemkey,
247: aname => 'ITEM_PRICE');
248:
249: l_item_qty := wf_engine.GetItemAttrText( itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'QUANTITY');
252:
253:

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

271: x_msg_data => x_msg_data);
272:
273: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
274:
275: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
276: itemkey => itemkey,
277: aname => 'INV_ORG_ID',
278: avalue => to_char(l_inv_org_id));
279:

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

276: itemkey => itemkey,
277: aname => 'INV_ORG_ID',
278: avalue => to_char(l_inv_org_id));
279:
280: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
281: itemkey => itemkey,
282: aname => 'INV_ORG_NAME',
283: avalue => l_inv_org_name);
284:

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

281: itemkey => itemkey,
282: aname => 'INV_ORG_NAME',
283: avalue => l_inv_org_name);
284:
285: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'SUBINV_CODE',
288: avalue => l_subinv_code);
289:

Line 290: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,

286: itemkey => itemkey,
287: aname => 'SUBINV_CODE',
288: avalue => l_subinv_code);
289:
290: WF_ENGINE.SetItemAttrDate( itemtype => itemtype,
291: itemkey => itemkey,
292: aname => 'SYS_DATE',
293: avalue => l_sysdate);
294:

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

291: itemkey => itemkey,
292: aname => 'SYS_DATE',
293: avalue => l_sysdate);
294:
295: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
296: itemkey => itemkey,
297: aname => 'PRICE_LIST_ID',
298: avalue => to_char(l_price_list_id));
299:

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

296: itemkey => itemkey,
297: aname => 'PRICE_LIST_ID',
298: avalue => to_char(l_price_list_id));
299:
300: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
301: itemkey => itemkey,
302: aname => 'ITEM_TEMPLATE_ID',
303: avalue => to_char(l_item_templ_id));
304:

Line 382: l_asset_return_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

378: BEGIN
379:
380: IF (funcmode = 'RUN') THEN
381:
382: l_asset_return_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
383: itemkey => itemkey,
384: aname => 'ASSET_RETURN_ID');
385:
386: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 386: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

382: l_asset_return_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
383: itemkey => itemkey,
384: aname => 'ASSET_RETURN_ID');
385:
386: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
387: itemkey => itemkey,
388: aname => 'INV_ORG_ID');
389:
390: l_inv_org_name := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 390: l_inv_org_name := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

386: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
387: itemkey => itemkey,
388: aname => 'INV_ORG_ID');
389:
390: l_inv_org_name := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'INV_ORG_NAME');
393:
394: l_item_desc := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 394: l_item_desc := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

390: l_inv_org_name := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'INV_ORG_NAME');
393:
394: l_item_desc := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
395: itemkey => itemkey,
396: aname => 'ITEM_DESC');
397:
398: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 398: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

394: l_item_desc := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
395: itemkey => itemkey,
396: aname => 'ITEM_DESC');
397:
398: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
399: itemkey => itemkey,
400: aname => 'SUBINV_CODE');
401:
402: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,

Line 402: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,

398: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
399: itemkey => itemkey,
400: aname => 'SUBINV_CODE');
401:
402: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,
403: itemkey => itemkey,
404: aname => 'SYS_DATE');
405:
406: l_item_number := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 406: l_item_number := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

402: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,
403: itemkey => itemkey,
404: aname => 'SYS_DATE');
405:
406: l_item_number := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
407: itemkey => itemkey,
408: aname => 'ITEM_NUMBER');
409:
410: l_item_templ_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 410: l_item_templ_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

406: l_item_number := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
407: itemkey => itemkey,
408: aname => 'ITEM_NUMBER');
409:
410: l_item_templ_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'ITEM_TEMPLATE_ID');
413:
414: OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item

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

430:
431:
432: IF x_return_status = OKC_API.G_RET_STS_SUCCESS THEN
433:
434: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
435: itemkey => itemkey,
436: aname => 'NEW_ITEM_NUMBER',
437: avalue => l_New_Item_Number);
438:

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

435: itemkey => itemkey,
436: aname => 'NEW_ITEM_NUMBER',
437: avalue => l_New_Item_Number);
438:
439: WF_ENGINE.SetItemAttrText( itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'NEW_ITEM_ID',
442: avalue => to_char(l_New_Item_Id));
443:

Line 516: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

512: BEGIN
513:
514: IF (funcmode = 'RUN') THEN
515:
516: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'NEW_ITEM_ID');
519:
520: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 520: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

516: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'NEW_ITEM_ID');
519:
520: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'SUBINV_CODE');
523:
524: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 524: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

520: l_subinv_code := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'SUBINV_CODE');
523:
524: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
525: itemkey => itemkey,
526: aname => 'INV_ORG_ID');
527:
528: l_item_qty := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 528: l_item_qty := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

524: l_inv_org_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
525: itemkey => itemkey,
526: aname => 'INV_ORG_ID');
527:
528: l_item_qty := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'QUANTITY');
531:
532: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,

Line 532: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,

528: l_item_qty := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'QUANTITY');
531:
532: l_sysdate := WF_ENGINE.GetItemAttrDate( itemtype => itemtype,
533: itemkey => itemkey,
534: aname => 'SYS_DATE');
535:
536: OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Inv_Misc_Receipt

Line 622: l_price_list_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

618: BEGIN
619:
620: IF (funcmode = 'RUN') THEN
621:
622: l_price_list_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
623: itemkey => itemkey,
624: aname => 'PRICE_LIST_ID');
625:
626: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

Line 626: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,

622: l_price_list_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
623: itemkey => itemkey,
624: aname => 'PRICE_LIST_ID');
625:
626: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
627: itemkey => itemkey,
628: aname => 'NEW_ITEM_ID');
629:
630: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 : changed to GetItemAttrNumber

Line 630: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 : changed to GetItemAttrNumber

626: l_New_Item_Id := WF_ENGINE.GetItemAttrText( itemtype => itemtype,
627: itemkey => itemkey,
628: aname => 'NEW_ITEM_ID');
629:
630: l_item_price := wf_engine.GetItemAttrNumber( itemtype => itemtype, -- sechawla 29-OCT-04 3924244 : changed to GetItemAttrNumber
631: itemkey => itemkey,
632: aname => 'ITEM_PRICE');
633:
634: OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List