APPS.POR_AME_REQ_WF_PVT dependencies on FND_USER

Line 51: l_next_approver_user_name fnd_user.user_name%TYPE;

47: l_document_id NUMBER;
48: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
50: l_next_approver_id NUMBER;
51: l_next_approver_user_name fnd_user.user_name%TYPE;
52: l_next_approver_disp_name wf_users.display_name%TYPE;
53: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
54: l_sequence_num NUMBER;
55: l_approver_type VARCHAR2(30);

Line 58: l_preparer_user_name fnd_user.user_name%TYPE;

54: l_sequence_num NUMBER;
55: l_approver_type VARCHAR2(30);
56:
57: l_doc_string varchar2(200);
58: l_preparer_user_name fnd_user.user_name%TYPE;
59: l_org_id number;
60:
61: l_next_approver ame_util.approverRecord;
62: l_insertion_type VARCHAR2(30);

Line 264: l_preparer_user_name fnd_user.user_name%TYPE;

260: t_varname Wf_Engine.NameTabTyp;
261: t_varval Wf_Engine.TextTabTyp;
262:
263: l_no_positionholder exception;
264: l_preparer_user_name fnd_user.user_name%TYPE;
265: l_doc_string varchar2(200);
266: l_start_block_activity varchar2(1);
267: l_has_fyi_app varchar2(1);
268: l_approver_index NUMBER;

Line 424: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.

420: IF (g_po_wf_debug = 'Y') THEN
421: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
422: END IF;
423:
424: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
425: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
426: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
427: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then
428:

Line 473: FROM fnd_user

469:
470: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
471: SELECT employee_id
472: into l_next_approver_id
473: FROM fnd_user
474: WHERE user_id = g_next_approvers(l_approver_index).orig_system_id
475: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
476: end if;
477:

Line 818: l_preparer_user_name fnd_user.user_name%TYPE;

814: l_orig_system_id NUMBER;
815: l_first_approver_id NUMBER;
816: l_first_position_id NUMBER;
817:
818: l_preparer_user_name fnd_user.user_name%TYPE;
819: l_doc_string VARCHAR2(200);
820: l_ame_exception ame_util.longestStringType;
821: l_approver_response varchar2(20);
822: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS

Line 970: -- FND User Record.

966: end;
967:
968: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
969:
970: -- FND User Record.
971: SELECT employee_id into l_person_id
972: FROM fnd_user
973: WHERE user_id = l_orig_system_id
974: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);

Line 972: FROM fnd_user

968: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
969:
970: -- FND User Record.
971: SELECT employee_id into l_person_id
972: FROM fnd_user
973: WHERE user_id = l_orig_system_id
974: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
975:
976: end if;