DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on FND_USER

Line 70: l_next_approver_user_name fnd_user.user_name%TYPE;

66: l_document_id NUMBER;
67: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
68: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
69: l_next_approver_id NUMBER;
70: l_next_approver_user_name fnd_user.user_name%TYPE;
71: l_next_approver_disp_name wf_users.display_name%TYPE;
72: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;
73: l_sequence_num NUMBER;
74: l_approver_type VARCHAR2(30);

Line 77: l_preparer_user_name fnd_user.user_name%TYPE;

73: l_sequence_num NUMBER;
74: l_approver_type VARCHAR2(30);
75:
76: l_doc_string varchar2(200);
77: l_preparer_user_name fnd_user.user_name%TYPE;
78: l_org_id number;
79:
80: l_next_approver ame_util.approverRecord;
81: l_insertion_type VARCHAR2(30);

Line 316: l_preparer_user_name fnd_user.user_name%TYPE;

312: t_req_varname Wf_Engine.NameTabTyp;
313: t_req_varval Wf_Engine.TextTabTyp;
314:
315: l_no_positionholder exception;
316: l_preparer_user_name fnd_user.user_name%TYPE;
317: l_doc_string varchar2(200);
318: l_start_block_activity varchar2(1);
319: l_has_fyi_app varchar2(1);
320: l_approver_index NUMBER;

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

583: IF (g_po_wf_debug = 'Y') THEN
584: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
585: END IF;
586:
587: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
588: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
589: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
590: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then
591:

Line 641: FROM fnd_user

637:
638: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
639: SELECT employee_id
640: into l_next_approver_id
641: FROM fnd_user
642: WHERE user_id = g_next_approvers(l_approver_index).orig_system_id
643: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
644: end if;
645:

Line 1220: l_preparer_user_name fnd_user.user_name%TYPE;

1216: l_orig_system_id NUMBER;
1217: l_first_approver_id NUMBER := null;
1218: l_first_position_id NUMBER := null;
1219:
1220: l_preparer_user_name fnd_user.user_name%TYPE;
1221: l_doc_string VARCHAR2(200);
1222: l_ame_exception ame_util.longestStringType;
1223: l_approver_response varchar2(20);
1224: l_transaction_type po_document_types.ame_transaction_type%TYPE; --

Line 1440: -- FND User Record.

1436: end;
1437:
1438: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
1439:
1440: -- FND User Record.
1441: SELECT employee_id into l_person_id
1442: FROM fnd_user
1443: WHERE user_id = l_orig_system_id
1444: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);

Line 1442: FROM fnd_user

1438: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
1439:
1440: -- FND User Record.
1441: SELECT employee_id into l_person_id
1442: FROM fnd_user
1443: WHERE user_id = l_orig_system_id
1444: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
1445:
1446: end if;