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.PA_ASGMT_WFSTD dependencies on FND_USER

Line 208: l_wf_started_by_username fnd_user.user_name%TYPE;

204: l_wf_started_date DATE;
205: l_wf_started_by_id NUMBER;
206: l_wf_started_by_full_name per_people_f.full_name%TYPE;
207: l_wf_started_by_email_address per_people_f.email_address%TYPE;
208: l_wf_started_by_username fnd_user.user_name%TYPE;
209: l_display_name wf_users.display_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
210: l_project_manager_person_id NUMBER ;
211: l_project_manager_name per_all_people_f.full_name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790
212: l_project_manager_uname wf_users.name%TYPE; ---- VARCHAR2(200); Changed for bug 3267790

Line 296: l_workflow_started_by_uname fnd_user.user_name%TYPE; ----VARCHAR2(100); Changed for bug 3267790 /* Increased length from 30 to 100 for bug 3148857 */

292: l_customer_name hz_parties.party_name%TYPE;
293:
294: -- 4363092 end
295:
296: l_workflow_started_by_uname fnd_user.user_name%TYPE; ----VARCHAR2(100); Changed for bug 3267790 /* Increased length from 30 to 100 for bug 3148857 */
297: l_waiting_time NUMBER := 0;
298: l_number_of_reminders NUMBER := 0;
299: l_save_threshold NUMBER;
300: l_override_basis_name VARCHAR2(80) := NULL;

Line 302: l_last_approver_uname fnd_user.USER_NAME%TYPE; --- VARCHAR2(240); -- Added for the bug 3817940

298: l_number_of_reminders NUMBER := 0;
299: l_save_threshold NUMBER;
300: l_override_basis_name VARCHAR2(80) := NULL;
301:
302: l_last_approver_uname fnd_user.USER_NAME%TYPE; --- VARCHAR2(240); -- Added for the bug 3817940
303: l_res_manager_id PER_PEOPLE_F.PERSON_ID%TYPE; -- Added for bug 4334741
304: BEGIN
305: -- dbms_output.put_line ('inside start workflow');
306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2269: l_wf_startedby_uname fnd_user.user_name%type;

2265: l_approver_user_name pa_wf_ntf_performers.user_name%TYPE; ----VARCHAR2(240); Commented for bug 3267790
2266: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users
2267: l_approver_type VARCHAR2(30);
2268: l_assignment_id NUMBER;
2269: l_wf_startedby_uname fnd_user.user_name%type;
2270:
2271: BEGIN
2272: /*
2273: Get item attr approvals loop counter and number of approvers

Line 3529: ,p_fnd_user_name => l_submitter_uname

3525:
3526: -- complete post overcommitment processing
3527: PA_SCHEDULE_PVT.OVERCOM_POST_APRVL_PROCESSING
3528: (p_conflict_group_id => l_conflict_group_id
3529: ,p_fnd_user_name => l_submitter_uname
3530: ,x_return_status => l_return_status
3531: ,x_msg_count => l_msg_count
3532: ,x_msg_data => l_msg_data);
3533: /*IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4478: l_ntfy_apprvl_recipient_name pa_wf_ntf_performers.user_name%TYPE; --- Commented for 3267790 fnd_user.user_name%TYPE; --used to set NTFY_APPRVL_RECIPIENT_NAME attribute

4474: l_err_code NUMBER := 0;
4475: l_err_stage VARCHAR2(2000);
4476: l_err_stack VARCHAR2(2000);
4477:
4478: l_ntfy_apprvl_recipient_name pa_wf_ntf_performers.user_name%TYPE; --- Commented for 3267790 fnd_user.user_name%TYPE; --used to set NTFY_APPRVL_RECIPIENT_NAME attribute
4479: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4480: l_number_of_assignments NUMBER;
4481: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4482: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

Line 4479: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute

4475: l_err_stage VARCHAR2(2000);
4476: l_err_stack VARCHAR2(2000);
4477:
4478: l_ntfy_apprvl_recipient_name pa_wf_ntf_performers.user_name%TYPE; --- Commented for 3267790 fnd_user.user_name%TYPE; --used to set NTFY_APPRVL_RECIPIENT_NAME attribute
4479: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4480: l_number_of_assignments NUMBER;
4481: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4482: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4483:

Line 4984: --Getting recepients fnd user name

4980: AND rownum = 1;
4981:
4982: log_message('After getting person_id:' || l_ntfy_apprvl_rect_person_id);
4983:
4984: --Getting recepients fnd user name
4985: wf_directory.getusername
4986: (p_orig_system => 'PER'
4987: ,p_orig_system_id => l_ntfy_apprvl_rect_person_id
4988: ,p_name => l_ntfy_apprvl_recipient_name

Line 5434: END IF;--end recipient name is null (no fnd_user for this resource)

5430: ,p_err_stage => l_err_stage
5431: ,p_err_stack => l_err_stack );
5432:
5433: END IF ; -- GSI Bug 7430471
5434: END IF;--end recipient name is null (no fnd_user for this resource)
5435:
5436:
5437: --Setting the original value
5438: wf_engine.threshold := l_save_threshold;

Line 5945: fnd_user fnd

5941: SELECT distinct res.manager_id
5942: FROM pa_resources_denorm res,
5943: pa_project_assignments asgn,
5944: pa_wf_ntf_performers ntf,
5945: fnd_user fnd
5946: WHERE ntf.group_id = p_group_id
5947: AND asgn.assignment_id = l_assignment_id
5948: AND asgn.assignment_id = ntf.object_id1
5949: AND res.resource_id = asgn.resource_id

Line 5953: AND fnd.user_name <> ntf.user_name;

5949: AND res.resource_id = asgn.resource_id
5950: AND asgn.start_date BETWEEN res.resource_effective_start_date
5951: AND res.resource_effective_end_date
5952: AND res.manager_id = fnd.employee_id
5953: AND fnd.user_name <> ntf.user_name;
5954:
5955: CURSOR Staffing_Manager IS
5956: SELECT distinct per.person_id as staffing_mgr_id
5957: FROM fnd_grants fg,

Line 5959: fnd_user fnd,

5955: CURSOR Staffing_Manager IS
5956: SELECT distinct per.person_id as staffing_mgr_id
5957: FROM fnd_grants fg,
5958: fnd_objects fob,
5959: fnd_user fnd,
5960: pa_resources_denorm res,
5961: /* Commenting this for performance tuning Bug#2499051
5962: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5963: from dual) temp, */

Line 5980: AND fnd.user_name <> ntf.user_name

5976: AND per.party_id = wf.orig_system_id
5977: AND sysdate between per.effective_start_date and per.effective_end_date
5978: AND wf.orig_system = 'HZ_PARTY'
5979: AND fg.grantee_key = wf.name
5980: AND fnd.user_name <> ntf.user_name
5981: AND fg.instance_pk1_value = TO_CHAR(res.resource_organization_id)
5982: AND fg.instance_type = 'INSTANCE'
5983: AND fg.object_id = fob.object_id
5984: AND fob.obj_name = 'ORGANIZATION'

Line 6112: --Getting recepients fnd user name

6108: --Populating Resource manager in recipient table
6109: ------------------------------------------------
6110: IF l_res_mgr_person_id IS NOT NULL THEN
6111:
6112: --Getting recepients fnd user name
6113: wf_directory.getusername
6114: (p_orig_system => 'PER'
6115: ,p_orig_system_id => l_res_mgr_person_id
6116: ,p_name => l_ntfy_apprvl_recipient_name

Line 6140: --Getting recepients fnd user name

6136: --Populating Staffing manager in recipient table
6137: ------------------------------------------------
6138: IF l_staff_mgr_person_id IS NOT NULL THEN
6139:
6140: --Getting recepients fnd user name
6141: wf_directory.getusername
6142: (p_orig_system => 'PER'
6143: ,p_orig_system_id => l_staff_mgr_person_id
6144: ,p_name => l_ntfy_apprvl_recipient_name

Line 6167: --Getting recepients fnd user name

6163: --Populating Project manager in recipient table
6164: -----------------------------------------------
6165: IF l_project_manager_person_id IS NOT NULL THEN
6166:
6167: --Getting recepients fnd user name
6168: wf_directory.getusername
6169: (p_orig_system => 'PER'
6170: ,p_orig_system_id => l_project_manager_person_id
6171: ,p_name => l_ntfy_apprvl_recipient_name

Line 6339: FROM fnd_user

6335:
6336: IF l_recipients_type_tbl(k) <> 'PROJECT_MANAGER' THEN
6337: SELECT employee_id
6338: INTO l_notified_id
6339: FROM fnd_user
6340: WHERE user_name = l_recipients_tbl(k)
6341: AND rownum = 1;
6342:
6343: -- bug 2475300 : added following two select stmt to set # of approved/rejected

Line 6478: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */

6474: l_routing_order NUMBER;
6475: l_num_assignments NUMBER;
6476: l_conflict_group_id NUMBER;
6477: l_update_info_doc VARCHAR2(2000);
6478: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6479: l_note_to_approvers VARCHAR2(2000);
6480: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6481: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6482:

Line 6480: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */

6476: l_conflict_group_id NUMBER;
6477: l_update_info_doc VARCHAR2(2000);
6478: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6479: l_note_to_approvers VARCHAR2(2000);
6480: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6481: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6482:
6483: BEGIN
6484: log_message('Inside mass_process_approval_result_wf');

Line 6824: FROM fnd_user

6820: ROLLBACK TO UPDATE_APPROVAL_STATUS;
6821:
6822: SELECT user_id
6823: INTO l_submitter_user_id
6824: FROM fnd_user
6825: WHERE user_name = p_submitter_user_name;
6826:
6827: SELECT resource_id
6828: INTO l_resource_id

Line 7212: ,p_fnd_user_name => p_submitter_user_name

7208: --This API is called to send notifications to conflicting managers
7209: ------------------------------------------------------------------
7210: PA_SCHEDULE_PVT.overcom_post_aprvl_processing
7211: ( p_conflict_group_id => p_conflict_group_id
7212: ,p_fnd_user_name => p_submitter_user_name
7213: ,x_return_status => l_return_status
7214: ,x_msg_count => l_msg_count
7215: ,x_msg_data => l_msg_data);
7216:

Line 7220: FROM fnd_user

7216:
7217: BEGIN
7218: SELECT user_id
7219: INTO l_submitter_user_id
7220: FROM fnd_user
7221: WHERE user_name = p_submitter_user_name;
7222: EXCEPTION
7223: WHEN NO_DATA_FOUND THEN
7224: null;

Line 7861: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790

7857: l_routing_order NUMBER;
7858: l_num_assignments NUMBER;
7859: l_conflict_group_id NUMBER;
7860: l_update_info_doc VARCHAR2(2000);
7861: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7862: l_note_to_approvers VARCHAR2(2000);
7863: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7864: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7865:

Line 7863: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171

7859: l_conflict_group_id NUMBER;
7860: l_update_info_doc VARCHAR2(2000);
7861: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7862: l_note_to_approvers VARCHAR2(2000);
7863: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7864: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7865:
7866: CURSOR pending_txn_approvals IS
7867: SELECT 'Y'

Line 7864: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496

7860: l_update_info_doc VARCHAR2(2000);
7861: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7862: l_note_to_approvers VARCHAR2(2000);
7863: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7864: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7865:
7866: CURSOR pending_txn_approvals IS
7867: SELECT 'Y'
7868: FROM pa_wf_ntf_performers ntf,

Line 8070: l_submitter_uname fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790

8066:
8067: IS
8068:
8069: l_error_item_type VARCHAR2(30);
8070: l_submitter_uname fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
8071: l_error_item_key NUMBER;
8072: l_submitter_user_id NUMBER;
8073: l_resource_id pa_resources_denorm.resource_id%TYPE;
8074: l_return_status VARCHAR2(1);

Line 8132: FROM fnd_user

8128: ,p_msg_name => 'PA_PROCESS_ABORTED_SYSADMIN');
8129:
8130: SELECT user_id
8131: INTO l_submitter_user_id
8132: FROM fnd_user
8133: WHERE user_name = l_submitter_uname;
8134:
8135: SELECT resource_id
8136: INTO l_resource_id