293: Call_WF_API_to_set_no_Att (l_itemtype, l_itemkey, 'VENDOR_EMPLOYEE_ID', l_vendor_employee_id);
294: Call_WF_API_to_set_Att (l_itemtype, l_itemkey, 'VENDOR_EMPLOYEE_NUMBER', l_vendor_employee_number);
295: Call_WF_API_to_set_Att (l_itemtype, l_itemkey, 'VENDOR_TYPE', l_vendor_type);
296:
297: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
298: itemkey => l_itemkey,
299: aname => 'PROJECT_ID',
300: avalue => p_project_id);
301:
298: itemkey => l_itemkey,
299: aname => 'PROJECT_ID',
300: avalue => p_project_id);
301:
302: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
303: itemkey => l_itemkey,
304: aname => 'TASK_ID',
305: avalue => p_task_id);
306:
303: itemkey => l_itemkey,
304: aname => 'TASK_ID',
305: avalue => p_task_id);
306:
307: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
308: itemkey => l_itemkey,
309: aname => 'EXPENDITURE_TYPE',
310: avalue => p_expenditure_type);
311:
308: itemkey => l_itemkey,
309: aname => 'EXPENDITURE_TYPE',
310: avalue => p_expenditure_type);
311:
312: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
313: itemkey => l_itemkey,
314: aname => 'EXPENDITURE_ORG_ID',
315: avalue => p_expenditure_organization_id);
316:
313: itemkey => l_itemkey,
314: aname => 'EXPENDITURE_ORG_ID',
315: avalue => p_expenditure_organization_id);
316:
317: wf_engine.SetItemAttrDate ( itemtype => l_itemtype,
318: itemkey => l_itemkey,
319: aname => 'EXPENDITURE_ITEM_DATE',
320: avalue => p_expenditure_item_date );
321:
318: itemkey => l_itemkey,
319: aname => 'EXPENDITURE_ITEM_DATE',
320: avalue => p_expenditure_item_date );
321:
322: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
323: itemkey => l_itemkey,
324: aname => 'CHART_OF_ACCOUNTS_ID',
325: avalue => p_chart_of_accounts_id);
326:
323: itemkey => l_itemkey,
324: aname => 'CHART_OF_ACCOUNTS_ID',
325: avalue => p_chart_of_accounts_id);
326:
327: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
328: itemkey => l_itemkey,
329: aname => 'CC_ACCT_LINE_ID',
330: avalue => p_cc_acct_line_id);
331:
328: itemkey => l_itemkey,
329: aname => 'CC_ACCT_LINE_ID',
330: avalue => p_cc_acct_line_id);
331:
332: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
333: itemkey => l_itemkey,
334: aname => 'CC_HEADER_ID',
335: avalue => p_cc_header_id);
336:
333: itemkey => l_itemkey,
334: aname => 'CC_HEADER_ID',
335: avalue => p_cc_header_id);
336:
337: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
338: itemkey => l_itemkey,
339: aname => 'CC_BUDGET_CCID',
340: avalue => p_cc_budget_ccid);
341:
338: itemkey => l_itemkey,
339: aname => 'CC_BUDGET_CCID',
340: avalue => p_cc_budget_ccid);
341:
342: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
343: itemkey => l_itemkey,
344: aname => 'CC_CHARGE_CCID',
345: avalue => NVL(l_return_ccid,p_cc_charge_ccid));
346:
343: itemkey => l_itemkey,
344: aname => 'CC_CHARGE_CCID',
345: avalue => NVL(l_return_ccid,p_cc_charge_ccid));
346:
347: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
348: itemkey => l_itemkey,
349: aname => 'CC_ACCT_DESC',
350: avalue => p_cc_acct_desc);
351:
348: itemkey => l_itemkey,
349: aname => 'CC_ACCT_DESC',
350: avalue => p_cc_acct_desc);
351:
352: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
353: itemkey => l_itemkey,
354: aname => 'CC_ACCT_TAXABLE_FLAG',
355: avalue => p_cc_acct_taxable_flag);
356:
353: itemkey => l_itemkey,
354: aname => 'CC_ACCT_TAXABLE_FLAG',
355: avalue => p_cc_acct_taxable_flag);
356:
357: wf_engine.SetItemAttrText( itemtype => l_itemtype,
358: itemkey => l_itemkey,
359: aname => 'TAX_NAME',
360: avalue => p_tax_name);
361: /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
359: aname => 'TAX_NAME',
360: avalue => p_tax_name);
361: /* bug -6472296 Modified tax_id to tax_name for Ebtax uptake*/
362:
363: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
364: itemkey => l_itemkey,
365: aname => 'CONTEXT',
366: avalue => p_context);
367:
364: itemkey => l_itemkey,
365: aname => 'CONTEXT',
366: avalue => p_context);
367:
368: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
369: itemkey => l_itemkey,
370: aname => 'ATTRIBUTE1',
371: avalue => p_attribute1);
372:
369: itemkey => l_itemkey,
370: aname => 'ATTRIBUTE1',
371: avalue => p_attribute1);
372:
373: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
374: itemkey => l_itemkey,
375: aname => 'ATTRIBUTE2',
376: avalue => p_attribute2);
377:
374: itemkey => l_itemkey,
375: aname => 'ATTRIBUTE2',
376: avalue => p_attribute2);
377:
378: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
379: itemkey => l_itemkey,
380: aname => 'ATTRIBUTE3',
381: avalue => p_attribute3);
382:
379: itemkey => l_itemkey,
380: aname => 'ATTRIBUTE3',
381: avalue => p_attribute3);
382:
383: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
384: itemkey => l_itemkey,
385: aname => 'ATTRIBUTE4',
386: avalue => p_attribute4);
387:
384: itemkey => l_itemkey,
385: aname => 'ATTRIBUTE4',
386: avalue => p_attribute4);
387:
388: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
389: itemkey => l_itemkey,
390: aname => 'ATTRIBUTE5',
391: avalue => p_attribute5);
392:
389: itemkey => l_itemkey,
390: aname => 'ATTRIBUTE5',
391: avalue => p_attribute5);
392:
393: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
394: itemkey => l_itemkey,
395: aname => 'ATTRIBUTE6',
396: avalue => p_attribute6);
397:
394: itemkey => l_itemkey,
395: aname => 'ATTRIBUTE6',
396: avalue => p_attribute6);
397:
398: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
399: itemkey => l_itemkey,
400: aname => 'ATTRIBUTE7',
401: avalue => p_attribute7);
402:
399: itemkey => l_itemkey,
400: aname => 'ATTRIBUTE7',
401: avalue => p_attribute7);
402:
403: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
404: itemkey => l_itemkey,
405: aname => 'ATTRIBUTE8',
406: avalue => p_attribute8);
407:
404: itemkey => l_itemkey,
405: aname => 'ATTRIBUTE8',
406: avalue => p_attribute8);
407:
408: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
409: itemkey => l_itemkey,
410: aname => 'ATTRIBUTE9',
411: avalue => p_attribute9);
412:
409: itemkey => l_itemkey,
410: aname => 'ATTRIBUTE9',
411: avalue => p_attribute9);
412:
413: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
414: itemkey => l_itemkey,
415: aname => 'ATTRIBUTE10',
416: avalue => p_attribute10);
417:
414: itemkey => l_itemkey,
415: aname => 'ATTRIBUTE10',
416: avalue => p_attribute10);
417:
418: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
419: itemkey => l_itemkey,
420: aname => 'ATTRIBUTE11',
421: avalue => p_attribute11);
422:
419: itemkey => l_itemkey,
420: aname => 'ATTRIBUTE11',
421: avalue => p_attribute11);
422:
423: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
424: itemkey => l_itemkey,
425: aname => 'ATTRIBUTE12',
426: avalue => p_attribute12);
427:
424: itemkey => l_itemkey,
425: aname => 'ATTRIBUTE12',
426: avalue => p_attribute12);
427:
428: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
429: itemkey => l_itemkey,
430: aname => 'ATTRIBUTE13',
431: avalue => p_attribute13);
432:
429: itemkey => l_itemkey,
430: aname => 'ATTRIBUTE13',
431: avalue => p_attribute13);
432:
433: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
434: itemkey => l_itemkey,
435: aname => 'ATTRIBUTE14',
436: avalue => p_attribute14);
437:
434: itemkey => l_itemkey,
435: aname => 'ATTRIBUTE14',
436: avalue => p_attribute14);
437:
438: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
439: itemkey => l_itemkey,
440: aname => 'ATTRIBUTE15',
441: avalue => p_attribute15);
442:
569: IS
570: BEGIN
571:
572: If avalue IS NOT NULL then
573: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
574: itemkey => l_itemkey,
575: aname => aname,
576: avalue => avalue );
577: end if;
583: IS
584: BEGIN
585:
586: If avalue IS NOT NULL then
587: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
588: itemkey => l_itemkey,
589: aname => aname,
590: avalue => avalue );
591: end if;
596: avalue date)
597: IS
598: BEGIN
599: If avalue IS NOT NULL then
600: wf_engine.SetItemAttrDate ( itemtype => l_itemtype,
601: itemkey => l_itemkey,
602: aname => aname,
603: avalue => avalue );
604: end if;