DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_CUST_WF dependencies on WF_ENGINE

Line 21: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

17:
18: ------------------------------------------------------------
19: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
20: ------------------------------------------------------------
21: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
22: p_item_key,
23: 'EXPENSE_REPORT_ID');
24:
25: ------------------------------------------

Line 36: WF_ENGINE.SetItemAttrText(p_item_type,

32: IF (l_return_error_message IS NULL) THEN
33: p_result := 'COMPLETE:AP_PASS';
34: ELSE
35:
36: WF_ENGINE.SetItemAttrText(p_item_type,
37: p_item_key,
38: 'ERROR_MESSAGE',
39: l_return_error_message);
40:

Line 252: l_employee_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

248:
249: ------------------------------------------------------
250: l_debug_info := 'Retrieve Employee_ID Item Attribute';
251: -------------------------------------------------------
252: l_employee_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
253: p_item_key,
254: 'EMPLOYEE_ID');
255:
256: ------------------------------------------------------

Line 259: l_employee_name := WF_ENGINE.GetItemAttrNumber(p_item_type,

255:
256: ------------------------------------------------------
257: l_debug_info := 'Retrieve Employee_ID Item Attribute';
258: -------------------------------------------------------
259: l_employee_name := WF_ENGINE.GetItemAttrNumber(p_item_type,
260: p_item_key,
261: 'EMPLOYEE_DISPLAY_NAME');
262:
263: ----------------------------------------------------------

Line 266: l_emp_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,

262:
263: ----------------------------------------------------------
264: l_debug_info := 'Retrieve Emp_Cost_Center Item Attribute';
265: -----------------------------------------------------------
266: l_emp_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,
267: p_item_key,
268: 'EMP_COST_CENTER');
269:
270:

Line 274: l_doc_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,

270:
271: ----------------------------------------------------------
272: l_debug_info := 'Retrieve Doc_Cost_Center Item Attribute';
273: -----------------------------------------------------------
274: l_doc_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,
275: p_item_key,
276: 'DOC_COST_CENTER');
277:
278:

Line 286: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,

282: /* Bug 3307845 : The total amount should be considered when verifying
283: the authority to approve */
284: /*
285: IF (C_WF_Version >= C_CreditLineVersion) THEN
286: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,
287: p_item_key,
288: 'POS_NEW_EXPENSE_TOTAL');
289: ELSE
290: */

Line 291: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,

287: p_item_key,
288: 'POS_NEW_EXPENSE_TOTAL');
289: ELSE
290: */
291: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,
292: p_item_key,
293: 'TOTAL');
294: /* END IF; */
295:

Line 299: l_find_approver_count := WF_ENGINE.GetItemAttrNumber(p_item_type,

295:
296: -------------------------------------------------------------------
297: l_debug_info := 'Retrieve Find_Approver_Count Activity Attribute';
298: -------------------------------------------------------------------
299: l_find_approver_count := WF_ENGINE.GetItemAttrNumber(p_item_type,
300: p_item_key,
301: 'FIND_APPROVER_COUNT');
302:
303: ----------------------------------------------------

Line 306: l_AMEEnabled := WF_ENGINE.GetItemAttrText(p_item_type,

302:
303: ----------------------------------------------------
304: l_debug_info := 'Retrieve profile option AME Enabled?';
305: ----------------------------------------------------
306: l_AMEEnabled := WF_ENGINE.GetItemAttrText(p_item_type,
307: p_item_key,
308: 'AME_ENABLED');
309:
310:

Line 341: l_curr_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

337:
338:
339: IF(l_curr_approver_id is NULL AND l_find_approver_count >0)
340: THEN
341: l_curr_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
342: p_item_key,
343: 'APPROVER_ID');
344:
345: END IF;

Line 350: l_find_approver_method := WF_ENGINE.GetActivityAttrText(p_item_type,

346:
347: -------------------------------------------------------------------
348: l_debug_info := 'Retrieve Find_Approver_Method Activity Attribute';
349: -------------------------------------------------------------------
350: l_find_approver_method := WF_ENGINE.GetActivityAttrText(p_item_type,
351: p_item_key,
352: p_actid,
353: 'FIND_APPROVER_METHOD');
354:

Line 536: WF_ENGINE.SetItemAttrText(p_item_type,

532:
533: IF ((l_next_approver_id IS NULL) OR (l_error_message IS NOT NULL)) THEN
534:
535: -- bug 3257576
536: WF_ENGINE.SetItemAttrText(p_item_type,
537: p_item_key,
538: 'NO_APPROVER_PROBLEM',
539: l_error_message);
540: WF_ENGINE.SetItemAttrText(p_item_type,

Line 540: WF_ENGINE.SetItemAttrText(p_item_type,

536: WF_ENGINE.SetItemAttrText(p_item_type,
537: p_item_key,
538: 'NO_APPROVER_PROBLEM',
539: l_error_message);
540: WF_ENGINE.SetItemAttrText(p_item_type,
541: p_item_key,
542: 'NO_APPROVER_INSTRUCTIONS',
543: l_instructions);
544: WF_ENGINE.SetItemAttrText(p_item_type,

Line 544: WF_ENGINE.SetItemAttrText(p_item_type,

540: WF_ENGINE.SetItemAttrText(p_item_type,
541: p_item_key,
542: 'NO_APPROVER_INSTRUCTIONS',
543: l_instructions);
544: WF_ENGINE.SetItemAttrText(p_item_type,
545: p_item_key,
546: 'NO_APPROVER_SPECIAL_INSTR',
547: l_special_instr);
548:

Line 558: WF_ENGINE.SetItemAttrNumber(p_item_type,

554: p_item_type,
555: p_item_key,
556: 'APPROVER');
557:
558: WF_ENGINE.SetItemAttrNumber(p_item_type,
559: p_item_key,
560: 'FIND_APPROVER_COUNT',
561: l_find_approver_count+1);
562:

Line 574: WF_ENGINE.SetItemAttrText(p_item_type,

570:
571: EXCEPTION
572: WHEN fixable_exception THEN
573: -- bug 3257576
574: WF_ENGINE.SetItemAttrText(p_item_type,
575: p_item_key,
576: 'NO_APPROVER_PROBLEM',
577: l_error_message);
578: WF_ENGINE.SetItemAttrText(p_item_type,

Line 578: WF_ENGINE.SetItemAttrText(p_item_type,

574: WF_ENGINE.SetItemAttrText(p_item_type,
575: p_item_key,
576: 'NO_APPROVER_PROBLEM',
577: l_error_message);
578: WF_ENGINE.SetItemAttrText(p_item_type,
579: p_item_key,
580: 'NO_APPROVER_INSTRUCTIONS',
581: l_instructions);
582: WF_ENGINE.SetItemAttrText(p_item_type,

Line 582: WF_ENGINE.SetItemAttrText(p_item_type,

578: WF_ENGINE.SetItemAttrText(p_item_type,
579: p_item_key,
580: 'NO_APPROVER_INSTRUCTIONS',
581: l_instructions);
582: WF_ENGINE.SetItemAttrText(p_item_type,
583: p_item_key,
584: 'NO_APPROVER_SPECIAL_INSTR',
585: l_special_instr);
586:

Line 617: l_report_id := WF_ENGINE.GetItemAttrText(p_item_type,

613:
614: -----------------------------------------------------
615: l_debug_info := 'Retrieve Expense Report Number';
616: -----------------------------------------------------
617: l_report_id := WF_ENGINE.GetItemAttrText(p_item_type,
618: p_item_key,
619: 'EXPENSE_REPORT_ID');
620:
621: -----------------------------------------------------

Line 694: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

690:
691: ------------------------------------------------------
692: l_debug_info := 'Retrieve Approver_ID Item Attribute';
693: -------------------------------------------------------
694: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
695: p_item_key,
696: 'APPROVER_ID');
697:
698:

Line 702: l_preparer_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

698:
699: ------------------------------------------------------
700: l_debug_info := 'Retrieve Preparer_ID Item Attribute';
701: -------------------------------------------------------
702: l_preparer_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
703: p_item_key,
704: 'PREPARER_ID');
705:
706: ----------------------------------------------------------

Line 709: l_doc_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,

705:
706: ----------------------------------------------------------
707: l_debug_info := 'Retrieve Doc_Cost_Center Item Attribute';
708: -----------------------------------------------------------
709: l_doc_cost_center := WF_ENGINE.GetItemAttrText(p_item_type,
710: p_item_key,
711: 'DOC_COST_CENTER');
712:
713:

Line 721: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,

717: /* Bug 3307845 : The total amount should be considered when verifying
718: the authority to approve */
719: /*
720: IF (C_WF_Version >= C_CreditLineVersion) THEN
721: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,
722: p_item_key,
723: 'POS_NEW_EXPENSE_TOTAL');
724: ELSE
725: */

Line 726: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,

722: p_item_key,
723: 'POS_NEW_EXPENSE_TOTAL');
724: ELSE
725: */
726: l_approval_amount := WF_ENGINE.GetItemAttrNumber(p_item_type,
727: p_item_key,
728: 'TOTAL');
729: /* END IF; */
730:

Line 735: l_AMEEnabled := WF_ENGINE.GetItemAttrText(p_item_type,

731:
732: ----------------------------------------------------
733: l_debug_info := 'Retrieve profile option AME Enabled?';
734: ----------------------------------------------------
735: l_AMEEnabled := WF_ENGINE.GetItemAttrText(p_item_type,
736: p_item_key,
737: 'AME_ENABLED');
738:
739: IF (l_AMEEnabled = 'Y') THEN

Line 897: l_employee_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

893:
894: ------------------------------------------------------------
895: l_debug_info := 'Retrieve employee name and report ID Item Attribute';
896: ------------------------------------------------------------
897: l_employee_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
898: p_item_key,
899: 'EMPLOYEE_ID');
900:
901: l_employee_name := WF_ENGINE.GetItemAttrText(p_item_type,

Line 901: l_employee_name := WF_ENGINE.GetItemAttrText(p_item_type,

897: l_employee_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
898: p_item_key,
899: 'EMPLOYEE_ID');
900:
901: l_employee_name := WF_ENGINE.GetItemAttrText(p_item_type,
902: p_item_key,
903: 'EMPLOYEE_NAME');
904:
905: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 905: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

901: l_employee_name := WF_ENGINE.GetItemAttrText(p_item_type,
902: p_item_key,
903: 'EMPLOYEE_NAME');
904:
905: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
906: p_item_key,
907: 'EXPENSE_REPORT_ID');
908:
909: IF (C_WF_Version >= AP_WEB_EXPENSE_WF.C_ProjectIntegrationVersion) THEN

Line 910: l_week_end_date := WF_ENGINE.GetItemAttrDate(p_item_type,

906: p_item_key,
907: 'EXPENSE_REPORT_ID');
908:
909: IF (C_WF_Version >= AP_WEB_EXPENSE_WF.C_ProjectIntegrationVersion) THEN
910: l_week_end_date := WF_ENGINE.GetItemAttrDate(p_item_type,
911: p_item_key,
912: 'WEEK_END_DATE');
913: END IF;
914:

Line 919: l_session_project_enabled := WF_ENGINE.GetItemAttrText(p_item_type,

915: ------------------------------------------------------------
916: l_debug_info := 'Determine whether session is project enabled';
917: ------------------------------------------------------------
918: IF (C_WF_Version >= AP_WEB_EXPENSE_WF.C_11_0_3Version) THEN
919: l_session_project_enabled := WF_ENGINE.GetItemAttrText(p_item_type,
920: p_item_key,
921: 'EMPLOYEE_PROJECT_ENABLED');
922:
923: ELSE

Line 973: l_new_expense_total := WF_ENGINE.GetItemAttrNumber(p_item_type,

969:
970: -------------------------------------------------------------
971: l_debug_info := 'Retrieve New Expense Total.';
972: -------------------------------------------------------------
973: l_new_expense_total := WF_ENGINE.GetItemAttrNumber(p_item_type,
974: p_item_key,
975: 'POS_NEW_EXPENSE_TOTAL');
976:
977: IF (l_new_expense_total <= 0) THEN

Line 1033: WF_ENGINE.SetItemAttrText(p_item_type,

1029:
1030: IF (l_payment = 'BOTH' and l_num_personal_lines > 0 ) THEN
1031: p_result := 'COMPLETE:' || l_no_auto_approve_notif;
1032:
1033: WF_ENGINE.SetItemAttrText(p_item_type,
1034: p_item_key,
1035: '#FROM_ROLE',
1036: WF_ENGINE.GetItemAttrText(p_item_type,
1037: p_item_key,

Line 1036: WF_ENGINE.GetItemAttrText(p_item_type,

1032:
1033: WF_ENGINE.SetItemAttrText(p_item_type,
1034: p_item_key,
1035: '#FROM_ROLE',
1036: WF_ENGINE.GetItemAttrText(p_item_type,
1037: p_item_key,
1038: 'EMPLOYEE_NAME'));
1039:
1040: END IF;