DBA Data[Home] [Help]

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 2152: fnd_user fu

2148:
2149: CURSOR get_user_id IS
2150: SELECT fu.user_id
2151: FROM pa_wf_ntf_performers pwnp,
2152: fnd_user fu
2153: WHERE pwnp.object_id1 = p_assignment_id
2154: AND pwnp.object_id2 = p_project_id
2155: AND pwnp.item_type = l_item_type
2156: AND pwnp.item_key = l_item_key

Line 2169: fnd_user fu

2165:
2166: CURSOR get_user_id_mflow IS
2167: SELECT fu.user_id
2168: FROM pa_wf_ntf_performers pwnp,
2169: fnd_user fu
2170: WHERE wf_type_code = 'MASS_ASSIGNMENT_APPROVAL'
2171: AND object_id1 = p_assignment_id
2172: AND object_id2 = -1
2173: AND fu.user_name = pwnp.user_name

Line 2933: FROM fnd_user

2929:
2930: CURSOR get_submitter_details IS
2931: SELECT employee_id,
2932: user_name
2933: FROM fnd_user
2934: WHERE user_id = p_submitter_user_id;
2935: l_submitter_rec get_submitter_details%ROWTYPE;
2936:
2937: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;

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

3402: FOR j IN 1..2 LOOP
3403: IF j = 1 AND l_approver1_id_tbl(i) IS NOT NULL THEN
3404: l_approvers_list_rec.Person_id := l_approver1_id_tbl(i);
3405:
3406: --Get the approver User name (FND_USER)
3407: wf_directory.getusername
3408: (p_orig_system => 'PER'
3409: ,p_orig_system_id => l_approver1_id_tbl(i)
3410: ,p_name => l_approver_name

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

3420:
3421: IF j = 2 AND l_approver2_id_tbl(i) IS NOT NULL THEN
3422: l_approvers_list_rec.Person_id := l_approver2_id_tbl(i);
3423:
3424: --Get the approver User name (FND_USER)
3425: wf_directory.getusername
3426: (p_orig_system => 'PER'
3427: ,p_orig_system_id => l_approver2_id_tbl(i)
3428: ,p_name => l_approver_name

Line 3707: ,p_fnd_user_name => l_submitter_user_name

3703: --This API is called to send notifications to conflicting managers
3704: ------------------------------------------------------------------
3705: PA_SCHEDULE_PVT.overcom_post_aprvl_processing
3706: ( p_conflict_group_id => p_conflict_group_id
3707: ,p_fnd_user_name => l_submitter_user_name
3708: ,x_return_status => l_return_status
3709: ,x_msg_count => l_msg_count
3710: ,x_msg_data => l_msg_data);
3711:

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

3860: l_num_attr_name_tbl Wf_Engine.NameTabTyp;
3861: l_num_attr_value_tbl Wf_Engine.NumTabTyp;
3862: l_update_info_doc VARCHAR2(32767);
3863: l_note_to_approvers VARCHAR2(2000);
3864: l_forwarded_from fnd_user.user_name%TYPE; /* Commented for bug 3261755 VARCHAR2(30); */
3865:
3866: BEGIN
3867:
3868: -- Initialize the Error Stack