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.HR_APPROVAL_SS dependencies on PER_ALL_PEOPLE_F

Line 3165: select last_name,first_name from per_all_people_f where

3161: cursor get_person_info is
3162: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;
3163:
3164: /* cursor get_name_info is
3165: select last_name,first_name from per_all_people_f where
3166: person_id = l_new_fwd_person_id;*/
3167:
3168: begin
3169:

Line 4043: lv_businessGroupId per_all_people_f.business_group_id%type;

4039: -- local variables
4040: c_proc constant varchar2(30) := 'isApproverEditAllowed';
4041: lv_role_displayName wf_users.display_name%type;
4042: lv_roleName wf_users.name%type;
4043: lv_businessGroupId per_all_people_f.business_group_id%type;
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4047: begin

Line 4083: from per_all_people_f

4079:
4080: begin
4081: select business_group_id
4082: into lv_businessGroupId
4083: from per_all_people_f
4084: where person_id=p_orig_system_id
4085: and sysdate between effective_start_date and effective_end_date;
4086: return pqh_ss_utility.check_edit_privilege(p_orig_system_id,lv_businessGroupId);
4087: exception

Line 5014: (p_person_id per_all_people_f.person_id%type)

5010: -- called internally to give the person name for the given user name --
5011: -- ----------------------------------------------------------------------------
5012: --
5013: FUNCTION getPersonNameFromID
5014: (p_person_id per_all_people_f.person_id%type)
5015: return per_all_people_f.full_name%type is
5016: --
5017: cursor csr_full_name
5018: is select full_name

Line 5015: return per_all_people_f.full_name%type is

5011: -- ----------------------------------------------------------------------------
5012: --
5013: FUNCTION getPersonNameFromID
5014: (p_person_id per_all_people_f.person_id%type)
5015: return per_all_people_f.full_name%type is
5016: --
5017: cursor csr_full_name
5018: is select full_name
5019: from per_all_people_f papf

Line 5019: from per_all_people_f papf

5015: return per_all_people_f.full_name%type is
5016: --
5017: cursor csr_full_name
5018: is select full_name
5019: from per_all_people_f papf
5020: where papf.person_id = p_person_id
5021: and trunc(sysdate) between effective_start_date
5022: and effective_end_date;
5023: --

Line 5024: l_employee_name per_all_people_f.full_name%type;

5020: where papf.person_id = p_person_id
5021: and trunc(sysdate) between effective_start_date
5022: and effective_end_date;
5023: --
5024: l_employee_name per_all_people_f.full_name%type;
5025: --
5026: BEGIN
5027: --
5028: hr_utility.trace('Finding Person name for person_id :' || p_person_id || ':');

Line 5066: l_current_person_name per_all_people_f.full_name%type;

5062: l_index binary_integer;
5063: l_temp_item_attribute varchar2(2000);
5064: l_role_name wf_roles.name%type;
5065: l_role_displayname wf_roles.display_name%type;
5066: l_current_person_name per_all_people_f.full_name%type;
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin
5069: g_debug := hr_utility.debug_enabled;
5070: if g_debug then

Line 5067: l_manager_id per_all_people_f.person_id%type;

5063: l_temp_item_attribute varchar2(2000);
5064: l_role_name wf_roles.name%type;
5065: l_role_displayname wf_roles.display_name%type;
5066: l_current_person_name per_all_people_f.full_name%type;
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin
5069: g_debug := hr_utility.debug_enabled;
5070: if g_debug then
5071: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 5337: lv_loginPersonDispName per_all_people_f.full_name%type;

5333:
5334: c_proc constant varchar2(30) := 'getinitApprovalBlockId';
5335: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5336: ln_activity_id number;
5337: lv_loginPersonDispName per_all_people_f.full_name%type;
5338: lv_loginPersonUserName fnd_user.user_name%type;
5339: ln_loginPersonId fnd_user.employee_id%type;
5340: begin
5341: if(p_transaction_id is not null) then

Line 5535: lv_loginPersonDispName per_all_people_f.full_name%type;

5531: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
5532: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5533: ln_activity_id wf_item_activity_statuses.process_activity%type;
5534: ln_notification_id wf_notifications.notification_id%type;
5535: lv_loginPersonDispName per_all_people_f.full_name%type;
5536: lv_loginPersonUserName fnd_user.user_name%type;
5537: ln_loginPersonId fnd_user.employee_id%type;
5538:
5539: begin

Line 5674: lv_loginPersonDispName per_all_people_f.full_name%type;

5670: -- local variables
5671: c_proc constant varchar2(30) := 'processApprovalSubmit';
5672: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5673: ln_activity_id wf_item_activity_statuses.process_activity%type;
5674: lv_loginPersonDispName per_all_people_f.full_name%type;
5675: lv_loginPersonUserName fnd_user.user_name%type;
5676: ln_loginPersonId fnd_user.employee_id%type;
5677: lv_item_type wf_items.item_type%type;
5678: lv_item_key wf_items.item_key%type;