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 2259: l_wf_startedby_uname fnd_user.user_name%type;

2255: l_approver_user_name pa_wf_ntf_performers.user_name%TYPE; ----VARCHAR2(240); Commented for bug 3267790
2256: l_prev_approver_user_name wf_users.name%TYPE; ----VARCHAR2(240); Commented for bug 3267790 as this takes the value from wf_users
2257: l_approver_type VARCHAR2(30);
2258: l_assignment_id NUMBER;
2259: l_wf_startedby_uname fnd_user.user_name%type;
2260:
2261: BEGIN
2262: /*
2263: Get item attr approvals loop counter and number of approvers

Line 3514: ,p_fnd_user_name => l_submitter_uname

3510:
3511: -- complete post overcommitment processing
3512: PA_SCHEDULE_PVT.OVERCOM_POST_APRVL_PROCESSING
3513: (p_conflict_group_id => l_conflict_group_id
3514: ,p_fnd_user_name => l_submitter_uname
3515: ,x_return_status => l_return_status
3516: ,x_msg_count => l_msg_count
3517: ,x_msg_data => l_msg_data);
3518: /*IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4463: 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

4459: l_err_code NUMBER := 0;
4460: l_err_stage VARCHAR2(2000);
4461: l_err_stack VARCHAR2(2000);
4462:
4463: 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
4464: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4465: l_number_of_assignments NUMBER;
4466: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4467: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171

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

4460: l_err_stage VARCHAR2(2000);
4461: l_err_stack VARCHAR2(2000);
4462:
4463: 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
4464: l_prev_user fnd_user.user_name%TYPE; --used to set FORWARDED_FROM attribute
4465: l_number_of_assignments NUMBER;
4466: l_mass_approve_url VARCHAR2(2000); --Mass Approve page URL
4467: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
4468:

Line 4968: --Getting recepients fnd user name

4964: AND rownum = 1;
4965:
4966: log_message('After getting person_id:' || l_ntfy_apprvl_rect_person_id);
4967:
4968: --Getting recepients fnd user name
4969: wf_directory.getusername
4970: (p_orig_system => 'PER'
4971: ,p_orig_system_id => l_ntfy_apprvl_rect_person_id
4972: ,p_name => l_ntfy_apprvl_recipient_name

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

5414: ,p_err_stage => l_err_stage
5415: ,p_err_stack => l_err_stack );
5416:
5417: END IF ; -- GSI Bug 7430471
5418: END IF;--end recipient name is null (no fnd_user for this resource)
5419:
5420:
5421: --Setting the original value
5422: wf_engine.threshold := l_save_threshold;

Line 5929: fnd_user fnd

5925: SELECT distinct res.manager_id
5926: FROM pa_resources_denorm res,
5927: pa_project_assignments asgn,
5928: pa_wf_ntf_performers ntf,
5929: fnd_user fnd
5930: WHERE ntf.group_id = p_group_id
5931: AND asgn.assignment_id = l_assignment_id
5932: AND asgn.assignment_id = ntf.object_id1
5933: AND res.resource_id = asgn.resource_id

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

5933: AND res.resource_id = asgn.resource_id
5934: AND asgn.start_date BETWEEN res.resource_effective_start_date
5935: AND res.resource_effective_end_date
5936: AND res.manager_id = fnd.employee_id
5937: AND fnd.user_name <> ntf.user_name;
5938:
5939: CURSOR Staffing_Manager IS
5940: SELECT distinct per.person_id as staffing_mgr_id
5941: FROM fnd_grants fg,

Line 5943: fnd_user fnd,

5939: CURSOR Staffing_Manager IS
5940: SELECT distinct per.person_id as staffing_mgr_id
5941: FROM fnd_grants fg,
5942: fnd_objects fob,
5943: fnd_user fnd,
5944: pa_resources_denorm res,
5945: /* Commenting this for performance tuning Bug#2499051
5946: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
5947: from dual) temp, */

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

5960: AND per.party_id = wf.orig_system_id
5961: AND sysdate between per.effective_start_date and per.effective_end_date
5962: AND wf.orig_system = 'HZ_PARTY'
5963: AND fg.grantee_key = wf.name
5964: AND fnd.user_name <> ntf.user_name
5965: AND fg.instance_pk1_value = TO_CHAR(res.resource_organization_id)
5966: AND fg.instance_type = 'INSTANCE'
5967: AND fg.object_id = fob.object_id
5968: AND fob.obj_name = 'ORGANIZATION'

Line 6096: --Getting recepients fnd user name

6092: --Populating Resource manager in recipient table
6093: ------------------------------------------------
6094: IF l_res_mgr_person_id IS NOT NULL THEN
6095:
6096: --Getting recepients fnd user name
6097: wf_directory.getusername
6098: (p_orig_system => 'PER'
6099: ,p_orig_system_id => l_res_mgr_person_id
6100: ,p_name => l_ntfy_apprvl_recipient_name

Line 6124: --Getting recepients fnd user name

6120: --Populating Staffing manager in recipient table
6121: ------------------------------------------------
6122: IF l_staff_mgr_person_id IS NOT NULL THEN
6123:
6124: --Getting recepients fnd user name
6125: wf_directory.getusername
6126: (p_orig_system => 'PER'
6127: ,p_orig_system_id => l_staff_mgr_person_id
6128: ,p_name => l_ntfy_apprvl_recipient_name

Line 6151: --Getting recepients fnd user name

6147: --Populating Project manager in recipient table
6148: -----------------------------------------------
6149: IF l_project_manager_person_id IS NOT NULL THEN
6150:
6151: --Getting recepients fnd user name
6152: wf_directory.getusername
6153: (p_orig_system => 'PER'
6154: ,p_orig_system_id => l_project_manager_person_id
6155: ,p_name => l_ntfy_apprvl_recipient_name

Line 6323: FROM fnd_user

6319:
6320: IF l_recipients_type_tbl(k) <> 'PROJECT_MANAGER' THEN
6321: SELECT employee_id
6322: INTO l_notified_id
6323: FROM fnd_user
6324: WHERE user_name = l_recipients_tbl(k)
6325: AND rownum = 1;
6326:
6327: -- bug 2475300 : added following two select stmt to set # of approved/rejected

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

6458: l_routing_order NUMBER;
6459: l_num_assignments NUMBER;
6460: l_conflict_group_id NUMBER;
6461: l_update_info_doc VARCHAR2(2000);
6462: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6463: l_note_to_approvers VARCHAR2(2000);
6464: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6465: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6466:

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

6460: l_conflict_group_id NUMBER;
6461: l_update_info_doc VARCHAR2(2000);
6462: l_submitter_user_name fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6463: l_note_to_approvers VARCHAR2(2000);
6464: l_forwarded_from fnd_user.user_name%type; /* Commeted for bug 3261755 VARCHAR2(30); */
6465: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); -- 5345171
6466:
6467: BEGIN
6468: log_message('Inside mass_process_approval_result_wf');

Line 6808: FROM fnd_user

6804: ROLLBACK TO UPDATE_APPROVAL_STATUS;
6805:
6806: SELECT user_id
6807: INTO l_submitter_user_id
6808: FROM fnd_user
6809: WHERE user_name = p_submitter_user_name;
6810:
6811: SELECT resource_id
6812: INTO l_resource_id

Line 7196: ,p_fnd_user_name => p_submitter_user_name

7192: --This API is called to send notifications to conflicting managers
7193: ------------------------------------------------------------------
7194: PA_SCHEDULE_PVT.overcom_post_aprvl_processing
7195: ( p_conflict_group_id => p_conflict_group_id
7196: ,p_fnd_user_name => p_submitter_user_name
7197: ,x_return_status => l_return_status
7198: ,x_msg_count => l_msg_count
7199: ,x_msg_data => l_msg_data);
7200:

Line 7204: FROM fnd_user

7200:
7201: BEGIN
7202: SELECT user_id
7203: INTO l_submitter_user_id
7204: FROM fnd_user
7205: WHERE user_name = p_submitter_user_name;
7206: EXCEPTION
7207: WHEN NO_DATA_FOUND THEN
7208: null;

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

7841: l_routing_order NUMBER;
7842: l_num_assignments NUMBER;
7843: l_conflict_group_id NUMBER;
7844: l_update_info_doc VARCHAR2(2000);
7845: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7846: l_note_to_approvers VARCHAR2(2000);
7847: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7848: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7849:

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

7843: l_conflict_group_id NUMBER;
7844: l_update_info_doc VARCHAR2(2000);
7845: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7846: l_note_to_approvers VARCHAR2(2000);
7847: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7848: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7849:
7850: CURSOR pending_txn_approvals IS
7851: SELECT 'Y'

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

7844: l_update_info_doc VARCHAR2(2000);
7845: l_submitter_user_name fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
7846: l_note_to_approvers VARCHAR2(2000);
7847: l_forwarded_from fnd_user.user_name%type;--VARCHAR2(30); 5345171
7848: l_ntfy_apprvl_recip_name fnd_user.user_name%TYPE; --skkoppul commented for bug 6744129 VARCHAR2(30); -- added for bug 5488496
7849:
7850: CURSOR pending_txn_approvals IS
7851: SELECT 'Y'
7852: FROM pa_wf_ntf_performers ntf,

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

8050:
8051: IS
8052:
8053: l_error_item_type VARCHAR2(30);
8054: l_submitter_uname fnd_user.user_name%type; ----- VARCHAR2(30); Commented for bug 3267790
8055: l_error_item_key NUMBER;
8056: l_submitter_user_id NUMBER;
8057: l_resource_id pa_resources_denorm.resource_id%TYPE;
8058: l_return_status VARCHAR2(1);

Line 8116: FROM fnd_user

8112: ,p_msg_name => 'PA_PROCESS_ABORTED_SYSADMIN');
8113:
8114: SELECT user_id
8115: INTO l_submitter_user_id
8116: FROM fnd_user
8117: WHERE user_name = l_submitter_uname;
8118:
8119: SELECT resource_id
8120: INTO l_resource_id