[Home] [Help]
177: --- Get the non default person id
178: FUNCTION get_non_default_person_id (p_transaction_id IN NUMBER)
179: RETURN NUMBER IS
180:
181: l_person_id wf_item_attribute_values.number_value%TYPE;
182:
183: BEGIN
184:
185:
196: --- Get requestor person id
197: FUNCTION get_requestor_person_id (p_transaction_id IN NUMBER)
198: RETURN NUMBER IS
199:
200: l_person_id wf_item_attribute_values.number_value%TYPE;
201:
202: BEGIN
203:
204: l_person_id := wf_engine.GetItemAttrNumber(
214: --- Get the approval path
215: FUNCTION get_approval_path (p_transaction_id IN NUMBER)
216: RETURN VARCHAR2 IS
217:
218: l_approval_path wf_item_attribute_values.text_value%TYPE;
219:
220: BEGIN
221:
222: l_approval_path := wf_engine.GetItemAttrText(
232: --- Get the reason code
233: FUNCTION get_reason_code (p_transaction_id IN NUMBER)
234: RETURN VARCHAR2 IS
235:
236: l_reason_code wf_item_attribute_values.text_value%TYPE;
237:
238: BEGIN
239:
240: l_reason_code := wf_engine.GetItemAttrText(
250: --- Get the transaction amount
251: FUNCTION get_transaction_amount (p_transaction_id IN NUMBER)
252: RETURN NUMBER IS
253:
254: l_txn_amount wf_item_attribute_values.number_value%TYPE;
255:
256: BEGIN
257:
258: l_txn_amount := wf_engine.GetItemAttrNumber(
267: -- Get Approver ID
268: FUNCTION get_approver_id (p_transaction_id IN NUMBER)
269: RETURN NUMBER IS
270:
271: l_approver_id wf_item_attribute_values.number_value%TYPE;
272:
273: BEGIN
274:
275: l_approver_id := wf_engine.GetItemAttrNumber(
285: -- Get Approver User Name
286: FUNCTION get_approver_user_name (p_transaction_id IN NUMBER)
287: RETURN VARCHAR2 IS
288:
289: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
290:
291: BEGIN
292:
293: l_approver_user_name := wf_engine.GetItemAttrText(
303: -- Get Batch Source Name
304: FUNCTION get_batch_source_name (p_transaction_id IN NUMBER)
305: RETURN VARCHAR2 IS
306:
307: l_batch_source_name wf_item_attribute_values.text_value%TYPE;
308:
309: BEGIN
310:
311: l_batch_source_name := wf_engine.GetItemAttrText(
321: -- Get Bill to Customer Name
322: FUNCTION get_bill_to_customer_name (p_transaction_id IN NUMBER)
323: RETURN VARCHAR2 IS
324:
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(
339: -- Get Bill to Customer Number
340: FUNCTION get_bill_to_customer_number (p_transaction_id IN NUMBER)
341: RETURN VARCHAR2 IS
342:
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(
357: -- Get Collector Employee Id
358: FUNCTION get_collector_employee_id (p_transaction_id IN NUMBER)
359: RETURN NUMBER IS
360:
361: l_collector_employee_id wf_item_attribute_values.number_value%TYPE;
362:
363: BEGIN
364:
365: l_collector_employee_id := wf_engine.GetItemAttrNumber(
375: -- Get Collector Name
376: FUNCTION get_collector_name (p_transaction_id IN NUMBER)
377: RETURN VARCHAR2 IS
378:
379: l_collector_name wf_item_attribute_values.text_value%TYPE;
380:
381: BEGIN
382:
383: l_collector_name := wf_engine.GetItemAttrText(
393: -- Get Collector User Name
394: FUNCTION get_collector_user_name (p_transaction_id IN NUMBER)
395: RETURN VARCHAR2 IS
396:
397: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
398:
399: BEGIN
400:
401: l_collector_user_name := wf_engine.GetItemAttrText(
411: -- Get Currency Code
412: FUNCTION get_currency_code (p_transaction_id IN NUMBER)
413: RETURN VARCHAR2 IS
414:
415: l_currency_code wf_item_attribute_values.text_value%TYPE;
416:
417: BEGIN
418:
419: l_currency_code := wf_engine.GetItemAttrText(
429: -- Get Customer Name
430: FUNCTION get_customer_name (p_transaction_id IN NUMBER)
431: RETURN VARCHAR2 IS
432:
433: l_customer_name wf_item_attribute_values.text_value%TYPE;
434:
435: BEGIN
436:
437: l_customer_name := wf_engine.GetItemAttrText(
447: -- Get Original Transaction Number
448: FUNCTION get_orig_trx_number (p_transaction_id IN NUMBER)
449: RETURN VARCHAR2 IS
450:
451: l_orig_trx_number wf_item_attribute_values.text_value%TYPE;
452:
453: BEGIN
454:
455: l_orig_trx_number := wf_engine.GetItemAttrText(
465: -- Get Requestor Id
466: FUNCTION get_requestor_id (p_transaction_id IN NUMBER)
467: RETURN NUMBER IS
468:
469: l_requestor_id wf_item_attribute_values.number_value%TYPE;
470:
471: BEGIN
472:
473: l_requestor_id := wf_engine.GetItemAttrNumber(
483: -- Get Requestor User Name
484: FUNCTION get_requestor_user_name (p_transaction_id IN NUMBER)
485: RETURN VARCHAR2 IS
486:
487: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
488:
489: BEGIN
490:
491: l_requestor_user_name := wf_engine.GetItemAttrText(
501: -- Get Ship to Customer Name
502: FUNCTION get_ship_to_customer_name (p_transaction_id IN NUMBER)
503: RETURN VARCHAR2 IS
504:
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(
519: -- Get Ship to Customer Number
520: FUNCTION get_ship_to_customer_number (p_transaction_id IN NUMBER)
521: RETURN VARCHAR2 IS
522:
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(
537: -- Tax Ex Certification Number
538: FUNCTION get_tax_ex_cert_num (p_transaction_id IN NUMBER)
539: RETURN VARCHAR2 IS
540:
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(
555: -- primary salesperson user name
556: FUNCTION get_salesrep_user_name (p_transaction_id IN NUMBER)
557: RETURN VARCHAR2 IS
558:
559: l_salesrep_user_name wf_item_attribute_values.text_value%TYPE;
560:
561: BEGIN
562:
563: l_salesrep_user_name := wf_engine.GetItemAttrText(
585: AND l.lookup_type = 'CREDIT_MEMO_REASON'
586: AND t.customer_trx_id = r.customer_trx_id
587: AND t.cust_trx_type_id = tt.cust_trx_type_id;
588:
589: l_trx_type_name wf_item_attribute_values.text_value%TYPE;
590:
591: BEGIN
592:
593: OPEN trx_types;
613: AND tl.customer_trx_id = r.customer_trx_id
614: AND tl.interface_line_context IS NOT NULL
615: AND rownum = 1;
616:
617: l_trx_type_name wf_item_attribute_values.text_value%TYPE;
618:
619: BEGIN
620:
621: OPEN trx_types;