eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AME_WF_PVT dependencies on FND_USER

Line 232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;

228: l_document_id NUMBER;
229: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
231: l_next_approver_id NUMBER;
232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;
233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;
234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;
235: l_sequence_num NUMBER;
236: l_approver_type VARCHAR2(30);

Line 238: l_preparer_user_name FND_USER.USER_NAME%TYPE;

234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;
235: l_sequence_num NUMBER;
236: l_approver_type VARCHAR2(30);
237: l_doc_string VARCHAR2(200);
238: l_preparer_user_name FND_USER.USER_NAME%TYPE;
239: l_org_id NUMBER;
240: l_insertion_type VARCHAR2(30);
241: l_authority_type VARCHAR2(30);
242: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

Line 720: l_preparer_user_name fnd_user.user_name%TYPE;

716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;
719: l_no_positionholder EXCEPTION;
720: l_preparer_user_name fnd_user.user_name%TYPE;
721: l_doc_string VARCHAR2(200);
722: l_start_block_activity VARCHAR2(1);
723: l_has_fyi_app VARCHAR2(1);
724: l_approver_index NUMBER;

Line 732: l_owner_user_name fnd_user.user_name%TYPE;

728: l_document_type po_document_types.document_type_code%TYPE;
729: l_esigner_exists VARCHAR2(1);
730: l_api_name VARCHAR2(500) := 'launch_parallel_approval';
731: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
732: l_owner_user_name fnd_user.user_name%TYPE;
733: l_userkey PO_HEADERS_ALL.SEGMENT1%TYPE;
734:
735: BEGIN
736:

Line 843: -- If it is an FND USER pick the employee_id corresponding to that FND USER

839:
840: --Fetch next approver_id from the global list.
841: -- If the approver is a PER role then use the same person id.
842: -- If the approver is POS role, then find out the first user corresponding to that person.
843: -- If it is an FND USER pick the employee_id corresponding to that FND USER
844: IF (g_next_approvers (l_approver_index).orig_system = ame_util.perorigsystem) THEN
845:
846: l_next_approver_id := g_next_approvers (l_approver_index).orig_system_id;
847:

Line 888: FROM fnd_user

884: ELSIF (g_next_approvers (l_approver_index).orig_system = ame_util.fnduserorigsystem) THEN
885:
886: SELECT employee_id
887: INTO l_next_approver_id
888: FROM fnd_user
889: WHERE user_id = g_next_approvers (l_approver_index).orig_system_id
890: AND TRUNC (sysdate) BETWEEN start_date AND NVL (end_date ,sysdate + 1);
891:
892: END IF;

Line 1235: FROM fnd_user

1231: BEGIN
1232:
1233: SELECT employee_id
1234: INTO l_forwardee.orig_system_id
1235: FROM fnd_user
1236: WHERE user_name = l_forwardee.name;
1237:
1238: EXCEPTION
1239:

Line 2686: l_responder_id fnd_user.user_id%TYPE;

2682: actid IN NUMBER,
2683: funcmode IN VARCHAR2,
2684: resultout OUT NOCOPY VARCHAR2)
2685: IS
2686: l_responder_id fnd_user.user_id%TYPE;
2687: l_session_user_id NUMBER;
2688: l_session_resp_id NUMBER;
2689: l_session_appl_id NUMBER;
2690: l_preparer_resp_id NUMBER;

Line 2857: FROM fnd_user fu,

2853: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2854:
2855: SELECT fu.user_id
2856: INTO l_responder_id
2857: FROM fnd_user fu,
2858: wf_notifications wfn
2859: WHERE wfn.notification_id = l_nid
2860: AND wfn.original_recipient = fu.user_name;
2861:

Line 3714: l_preparer_user_name fnd_user.user_name%TYPE;

3710: l_note VARCHAR2(4000);
3711: l_person_id NUMBER;
3712: l_orig_system VARCHAR2(3);
3713: l_orig_system_id NUMBER;
3714: l_preparer_user_name fnd_user.user_name%TYPE;
3715: l_doc_string VARCHAR2(200);
3716: l_ame_exception ame_util.longestStringType;
3717: l_approver_response VARCHAR2(20);
3718: l_transaction_type po_document_types.ame_transaction_type%TYPE;

Line 3885: --FND User Record.

3881: l_person_id := -1;
3882: END;
3883:
3884: ELSIF (l_orig_system = ame_util.fndUserOrigSystem) THEN
3885: --FND User Record.
3886: SELECT employee_id
3887: INTO l_person_id
3888: FROM fnd_user
3889: WHERE user_id = l_orig_system_id

Line 3888: FROM fnd_user

3884: ELSIF (l_orig_system = ame_util.fndUserOrigSystem) THEN
3885: --FND User Record.
3886: SELECT employee_id
3887: INTO l_person_id
3888: FROM fnd_user
3889: WHERE user_id = l_orig_system_id
3890: AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE + 1);
3891:
3892: END IF; --l_orig_system =

Line 4244: l_preparer_user_name fnd_user.user_name%TYPE;

4240: l_approval_group_id NUMBER;
4241: l_org_id NUMBER;
4242: l_draft_id NUMBER;
4243: l_doc_string VARCHAR2(200);
4244: l_preparer_user_name fnd_user.user_name%TYPE;
4245: l_api_name VARCHAR2(500) := 'update_action_history_reminder';
4246: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4247:
4248: BEGIN

Line 4375: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR

4371:
4372: BEGIN
4373: SELECT HR.PERSON_ID
4374: INTO x_user_id
4375: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR
4376: WHERE FND.USER_NAME = l_forward_to_username_response
4377: AND FND.EMPLOYEE_ID = HR.PERSON_ID
4378: AND ROWNUM = 1;
4379:

Line 4376: WHERE FND.USER_NAME = l_forward_to_username_response

4372: BEGIN
4373: SELECT HR.PERSON_ID
4374: INTO x_user_id
4375: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR
4376: WHERE FND.USER_NAME = l_forward_to_username_response
4377: AND FND.EMPLOYEE_ID = HR.PERSON_ID
4378: AND ROWNUM = 1;
4379:
4380: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');

Line 5281: -- Get the person name based on orig_system -> PER/POS/FND USER

5277:
5278: -- Logic - Loop through all the approvers returned by AME API - getAllApprovers3
5279: -- If the approval_status of a particualr approver is NULL then it is a future approver.
5280: -- If the approval_status is NOTIFIED then it is a current approver.
5281: -- Get the person name based on orig_system -> PER/POS/FND USER
5282: -- Get the approver category by checking production indexes - Reviewer,
5283: -- Post approval group - Signer else Approver.
5284: -- Populate the plsql table po_ame_approver_tab.
5285:

Line 5361: FROM fnd_user

5357:
5358: ELSIF (ApproverList(l_approver_index).orig_system = ame_util.fnduserorigsystem) THEN
5359: SELECT employee_id
5360: INTO l_next_approver_id
5361: FROM fnd_user
5362: WHERE user_id = ApproverList(l_approver_index).orig_system_id
5363: AND TRUNC (sysdate) BETWEEN start_date AND NVL (end_date ,sysdate + 1);
5364: END IF;
5365:

Line 5613: l_user_name FND_USER.user_name%TYPE;

5609: l_erecord_id NUMBER;
5610: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
5611: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
5612: l_document_id PO_HEADERS.po_header_id%TYPE;
5613: l_user_name FND_USER.user_name%TYPE;
5614: l_requester FND_USER.user_name%TYPE;
5615: l_esigner_response VARCHAR2(20);
5616: l_response VARCHAR2(20);
5617: l_event_name VARCHAR2(50);

Line 5614: l_requester FND_USER.user_name%TYPE;

5610: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
5611: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
5612: l_document_id PO_HEADERS.po_header_id%TYPE;
5613: l_user_name FND_USER.user_name%TYPE;
5614: l_requester FND_USER.user_name%TYPE;
5615: l_esigner_response VARCHAR2(20);
5616: l_response VARCHAR2(20);
5617: l_event_name VARCHAR2(50);
5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

Line 6030: l_preparer_user_name FND_USER.USER_NAME%TYPE;

6026: l_document_id NUMBER;
6027: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
6028: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
6029: l_doc_string VARCHAR2(200);
6030: l_preparer_user_name FND_USER.USER_NAME%TYPE;
6031: l_revision_num NUMBER;
6032: l_api_name VARCHAR2(500) := 'update_pending_signature';
6033: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
6034: l_return_status VARCHAR2(1);