DBA Data[Home] [Help]

APPS.AR_AME_CM_ATTRIBUTES_API dependencies on WF_ENGINE

Line 186: l_person_id := wf_engine.GetItemAttrNumber(

182:
183: BEGIN
184:
185:
186: l_person_id := wf_engine.GetItemAttrNumber(
187: itemtype => c_item_type,
188: itemkey => p_transaction_id,
189: aname => 'NON_DEFAULT_START_PERSON_ID');
190:

Line 204: l_person_id := wf_engine.GetItemAttrNumber(

200: l_person_id wf_item_attribute_values.number_value%TYPE;
201:
202: BEGIN
203:
204: l_person_id := wf_engine.GetItemAttrNumber(
205: itemtype => c_item_type,
206: itemkey => p_transaction_id,
207: aname => 'REQUESTOR_ID');
208:

Line 222: l_approval_path := wf_engine.GetItemAttrText(

218: l_approval_path wf_item_attribute_values.text_value%TYPE;
219:
220: BEGIN
221:
222: l_approval_path := wf_engine.GetItemAttrText(
223: itemtype => c_item_type,
224: itemkey => p_transaction_id,
225: aname => 'APPROVAL_PATH');
226:

Line 240: l_reason_code := wf_engine.GetItemAttrText(

236: l_reason_code wf_item_attribute_values.text_value%TYPE;
237:
238: BEGIN
239:
240: l_reason_code := wf_engine.GetItemAttrText(
241: itemtype => c_item_type,
242: itemkey => p_transaction_id,
243: aname => 'REASON');
244:

Line 258: l_txn_amount := wf_engine.GetItemAttrNumber(

254: l_txn_amount wf_item_attribute_values.number_value%TYPE;
255:
256: BEGIN
257:
258: l_txn_amount := wf_engine.GetItemAttrNumber(
259: itemtype => c_item_type,
260: itemkey => p_transaction_id,
261: aname => 'TOTAL_CREDIT_TO_INVOICE');
262:

Line 275: l_approver_id := wf_engine.GetItemAttrNumber(

271: l_approver_id wf_item_attribute_values.number_value%TYPE;
272:
273: BEGIN
274:
275: l_approver_id := wf_engine.GetItemAttrNumber(
276: itemtype => c_item_type,
277: itemkey => p_transaction_id,
278: aname => 'APPROVER_ID');
279:

Line 293: l_approver_user_name := wf_engine.GetItemAttrText(

289: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
290:
291: BEGIN
292:
293: l_approver_user_name := wf_engine.GetItemAttrText(
294: itemtype => c_item_type,
295: itemkey => p_transaction_id,
296: aname => 'APPROVER_USER_NAME');
297:

Line 311: l_batch_source_name := wf_engine.GetItemAttrText(

307: l_batch_source_name wf_item_attribute_values.text_value%TYPE;
308:
309: BEGIN
310:
311: l_batch_source_name := wf_engine.GetItemAttrText(
312: itemtype => c_item_type,
313: itemkey => p_transaction_id,
314: aname => 'BATCH_SOURCE_NAME');
315:

Line 329: l_bill_to_customer_name := wf_engine.GetItemAttrText(

325: l_bill_to_customer_name wf_item_attribute_values.text_value%TYPE;
326:
327: BEGIN
328:
329: l_bill_to_customer_name := wf_engine.GetItemAttrText(
330: itemtype => c_item_type,
331: itemkey => p_transaction_id,
332: aname => 'BILL_TO_CUSTOMER_NAME');
333:

Line 347: l_bill_to_customer_number := wf_engine.GetItemAttrText(

343: l_bill_to_customer_number wf_item_attribute_values.text_value%TYPE;
344:
345: BEGIN
346:
347: l_bill_to_customer_number := wf_engine.GetItemAttrText(
348: itemtype => c_item_type,
349: itemkey => p_transaction_id,
350: aname => 'BILL_TO_CUSTOMER_NUMBER');
351:

Line 365: l_collector_employee_id := wf_engine.GetItemAttrNumber(

361: l_collector_employee_id wf_item_attribute_values.number_value%TYPE;
362:
363: BEGIN
364:
365: l_collector_employee_id := wf_engine.GetItemAttrNumber(
366: itemtype => c_item_type,
367: itemkey => p_transaction_id,
368: aname => 'COLLECTOR_EMPLOYEE_ID');
369:

Line 383: l_collector_name := wf_engine.GetItemAttrText(

379: l_collector_name wf_item_attribute_values.text_value%TYPE;
380:
381: BEGIN
382:
383: l_collector_name := wf_engine.GetItemAttrText(
384: itemtype => c_item_type,
385: itemkey => p_transaction_id,
386: aname => 'COLLECTOR_NAME');
387:

Line 401: l_collector_user_name := wf_engine.GetItemAttrText(

397: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
398:
399: BEGIN
400:
401: l_collector_user_name := wf_engine.GetItemAttrText(
402: itemtype => c_item_type,
403: itemkey => p_transaction_id,
404: aname => 'COLLECTOR_USER_NAME');
405:

Line 419: l_currency_code := wf_engine.GetItemAttrText(

415: l_currency_code wf_item_attribute_values.text_value%TYPE;
416:
417: BEGIN
418:
419: l_currency_code := wf_engine.GetItemAttrText(
420: itemtype => c_item_type,
421: itemkey => p_transaction_id,
422: aname => 'CURRENCY_CODE');
423:

Line 437: l_customer_name := wf_engine.GetItemAttrText(

433: l_customer_name wf_item_attribute_values.text_value%TYPE;
434:
435: BEGIN
436:
437: l_customer_name := wf_engine.GetItemAttrText(
438: itemtype => c_item_type,
439: itemkey => p_transaction_id,
440: aname => 'CUSTOMER_NAME');
441:

Line 455: l_orig_trx_number := wf_engine.GetItemAttrText(

451: l_orig_trx_number wf_item_attribute_values.text_value%TYPE;
452:
453: BEGIN
454:
455: l_orig_trx_number := wf_engine.GetItemAttrText(
456: itemtype => c_item_type,
457: itemkey => p_transaction_id,
458: aname => 'ORIG_TRX_NUMBER');
459:

Line 473: l_requestor_id := wf_engine.GetItemAttrNumber(

469: l_requestor_id wf_item_attribute_values.number_value%TYPE;
470:
471: BEGIN
472:
473: l_requestor_id := wf_engine.GetItemAttrNumber(
474: itemtype => c_item_type,
475: itemkey => p_transaction_id,
476: aname => 'REQUESTOR_ID');
477:

Line 491: l_requestor_user_name := wf_engine.GetItemAttrText(

487: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
488:
489: BEGIN
490:
491: l_requestor_user_name := wf_engine.GetItemAttrText(
492: itemtype => c_item_type,
493: itemkey => p_transaction_id,
494: aname => 'REQUESTOR_USER_NAME');
495:

Line 509: l_ship_to_customer_name := wf_engine.GetItemAttrText(

505: l_ship_to_customer_name wf_item_attribute_values.text_value%TYPE;
506:
507: BEGIN
508:
509: l_ship_to_customer_name := wf_engine.GetItemAttrText(
510: itemtype => c_item_type,
511: itemkey => p_transaction_id,
512: aname => 'SHIP_TO_CUSTOMER_NAME');
513:

Line 527: l_ship_to_customer_number := wf_engine.GetItemAttrText(

523: l_ship_to_customer_number wf_item_attribute_values.text_value%TYPE;
524:
525: BEGIN
526:
527: l_ship_to_customer_number := wf_engine.GetItemAttrText(
528: itemtype => c_item_type,
529: itemkey => p_transaction_id,
530: aname => 'SHIP_TO_CUSTOMER_NUMBER');
531:

Line 545: l_tax_ex_cert_num := wf_engine.GetItemAttrText(

541: l_tax_ex_cert_num wf_item_attribute_values.text_value%TYPE;
542:
543: BEGIN
544:
545: l_tax_ex_cert_num := wf_engine.GetItemAttrText(
546: itemtype => c_item_type,
547: itemkey => p_transaction_id,
548: aname => 'TAX_EX_CERT_NUM');
549:

Line 563: l_salesrep_user_name := wf_engine.GetItemAttrText(

559: l_salesrep_user_name wf_item_attribute_values.text_value%TYPE;
560:
561: BEGIN
562:
563: l_salesrep_user_name := wf_engine.GetItemAttrText(
564: itemtype => c_item_type,
565: itemkey => p_transaction_id,
566: aname => 'SALESREP_USER_NAME');
567: