DBA Data[Home] [Help]

APPS.OKL_AM_REMARKET_ASSET_WF dependencies on WF_ENGINE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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