APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on FND_USER

Line 114: FROM fnd_user

110: WHERE assignment_id = p_assignment_id;
111:
112: CURSOR l_submitter_person_id_csr(l_submitter_user_id NUMBER) IS
113: SELECT employee_id
114: FROM fnd_user
115: WHERE user_id = l_submitter_user_id;
116:
117: TYPE status_codes IS TABLE OF pa_project_assignments.status_code%TYPE;
118: l_status_codes status_codes;

Line 448: ,p_fnd_user_name => FND_GLOBAL.USER_NAME

444:
445: -- complete post overcommitment processing
446: PA_SCHEDULE_PVT.OVERCOM_POST_APRVL_PROCESSING
447: (p_conflict_group_id => l_conflict_group_id
448: ,p_fnd_user_name => FND_GLOBAL.USER_NAME
449: ,x_return_status => l_return_status
450: ,x_msg_count => l_msg_count
451: ,x_msg_data => l_msg_data);
452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2141: fnd_user fu

2137:
2138: CURSOR get_user_id IS
2139: SELECT fu.user_id
2140: FROM pa_wf_ntf_performers pwnp,
2141: fnd_user fu
2142: WHERE pwnp.object_id1 = p_assignment_id
2143: AND pwnp.object_id2 = p_project_id
2144: AND pwnp.item_type = l_item_type
2145: AND pwnp.item_key = l_item_key

Line 2872: FROM fnd_user

2868:
2869: CURSOR get_submitter_details IS
2870: SELECT employee_id,
2871: user_name
2872: FROM fnd_user
2873: WHERE user_id = p_submitter_user_id;
2874: l_submitter_rec get_submitter_details%ROWTYPE;
2875:
2876: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;

Line 3341: --Get the approver User name (FND_USER)

3337: FOR j IN 1..2 LOOP
3338: IF j = 1 AND l_approver1_id_tbl(i) IS NOT NULL THEN
3339: l_approvers_list_rec.Person_id := l_approver1_id_tbl(i);
3340:
3341: --Get the approver User name (FND_USER)
3342: wf_directory.getusername
3343: (p_orig_system => 'PER'
3344: ,p_orig_system_id => l_approver1_id_tbl(i)
3345: ,p_name => l_approver_name

Line 3359: --Get the approver User name (FND_USER)

3355:
3356: IF j = 2 AND l_approver2_id_tbl(i) IS NOT NULL THEN
3357: l_approvers_list_rec.Person_id := l_approver2_id_tbl(i);
3358:
3359: --Get the approver User name (FND_USER)
3360: wf_directory.getusername
3361: (p_orig_system => 'PER'
3362: ,p_orig_system_id => l_approver2_id_tbl(i)
3363: ,p_name => l_approver_name

Line 3642: ,p_fnd_user_name => l_submitter_user_name

3638: --This API is called to send notifications to conflicting managers
3639: ------------------------------------------------------------------
3640: PA_SCHEDULE_PVT.overcom_post_aprvl_processing
3641: ( p_conflict_group_id => p_conflict_group_id
3642: ,p_fnd_user_name => l_submitter_user_name
3643: ,x_return_status => l_return_status
3644: ,x_msg_count => l_msg_count
3645: ,x_msg_data => l_msg_data);
3646:

Line 3799: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */

3795: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3796: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3797: l_update_info_doc VARCHAR2(32767);
3798: l_note_to_approvers VARCHAR2(2000);
3799: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */
3800:
3801: BEGIN
3802:
3803: -- Initialize the Error Stack