DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on PER_ALL_PEOPLE_F

Line 2350: select last_name,first_name from per_all_people_f where

2346: cursor get_person_info is
2347: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;
2348:
2349: /* cursor get_name_info is
2350: select last_name,first_name from per_all_people_f where
2351: person_id = l_new_fwd_person_id;*/
2352:
2353: begin
2354:

Line 3032: lv_businessGroupId per_all_people_f.business_group_id%type;

3028: -- local variables
3029: c_proc constant varchar2(30) := 'isApproverEditAllowed';
3030: lv_role_displayName wf_users.display_name%type;
3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;
3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;
3036: begin

Line 3072: from per_all_people_f

3068:
3069: begin
3070: select business_group_id
3071: into lv_businessGroupId
3072: from per_all_people_f
3073: where person_id=p_orig_system_id
3074: and sysdate between effective_start_date and effective_end_date;
3075: return pqh_ss_utility.check_edit_privilege(p_orig_system_id,lv_businessGroupId);
3076: exception

Line 3973: (p_person_id per_all_people_f.person_id%type)

3969: -- called internally to give the person name for the given user name --
3970: -- ----------------------------------------------------------------------------
3971: --
3972: FUNCTION getPersonNameFromID
3973: (p_person_id per_all_people_f.person_id%type)
3974: return per_all_people_f.full_name%type is
3975: --
3976: cursor csr_full_name
3977: is select full_name

Line 3974: return per_all_people_f.full_name%type is

3970: -- ----------------------------------------------------------------------------
3971: --
3972: FUNCTION getPersonNameFromID
3973: (p_person_id per_all_people_f.person_id%type)
3974: return per_all_people_f.full_name%type is
3975: --
3976: cursor csr_full_name
3977: is select full_name
3978: from per_all_people_f papf

Line 3978: from per_all_people_f papf

3974: return per_all_people_f.full_name%type is
3975: --
3976: cursor csr_full_name
3977: is select full_name
3978: from per_all_people_f papf
3979: where papf.person_id = p_person_id
3980: and trunc(sysdate) between effective_start_date
3981: and effective_end_date;
3982: --

Line 3983: l_employee_name per_all_people_f.full_name%type;

3979: where papf.person_id = p_person_id
3980: and trunc(sysdate) between effective_start_date
3981: and effective_end_date;
3982: --
3983: l_employee_name per_all_people_f.full_name%type;
3984: --
3985: BEGIN
3986: --
3987: hr_utility.trace('Finding Person name for person_id :' || p_person_id || ':');

Line 4025: l_current_person_name per_all_people_f.full_name%type;

4021: l_index binary_integer;
4022: l_temp_item_attribute varchar2(2000);
4023: l_role_name wf_roles.name%type;
4024: l_role_displayname wf_roles.display_name%type;
4025: l_current_person_name per_all_people_f.full_name%type;
4026: l_manager_id per_all_people_f.person_id%type;
4027: begin
4028: g_debug := hr_utility.debug_enabled;
4029: if g_debug then

Line 4026: l_manager_id per_all_people_f.person_id%type;

4022: l_temp_item_attribute varchar2(2000);
4023: l_role_name wf_roles.name%type;
4024: l_role_displayname wf_roles.display_name%type;
4025: l_current_person_name per_all_people_f.full_name%type;
4026: l_manager_id per_all_people_f.person_id%type;
4027: begin
4028: g_debug := hr_utility.debug_enabled;
4029: if g_debug then
4030: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4296: lv_loginPersonDispName per_all_people_f.full_name%type;

4292:
4293: c_proc constant varchar2(30) := 'getinitApprovalBlockId';
4294: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4295: ln_activity_id number;
4296: lv_loginPersonDispName per_all_people_f.full_name%type;
4297: lv_loginPersonUserName fnd_user.user_name%type;
4298: ln_loginPersonId fnd_user.employee_id%type;
4299: begin
4300: if(p_transaction_id is not null) then

Line 4494: lv_loginPersonDispName per_all_people_f.full_name%type;

4490: c_proc constant varchar2(30) := 'processNonPageNavWFSubmit';
4491: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4492: ln_activity_id wf_item_activity_statuses.process_activity%type;
4493: ln_notification_id wf_notifications.notification_id%type;
4494: lv_loginPersonDispName per_all_people_f.full_name%type;
4495: lv_loginPersonUserName fnd_user.user_name%type;
4496: ln_loginPersonId fnd_user.employee_id%type;
4497:
4498: begin

Line 4626: lv_loginPersonDispName per_all_people_f.full_name%type;

4622: -- local variables
4623: c_proc constant varchar2(30) := 'processApprovalSubmit';
4624: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4625: ln_activity_id wf_item_activity_statuses.process_activity%type;
4626: lv_loginPersonDispName per_all_people_f.full_name%type;
4627: lv_loginPersonUserName fnd_user.user_name%type;
4628: ln_loginPersonId fnd_user.employee_id%type;
4629: lv_item_type wf_items.item_type%type;
4630: lv_item_key wf_items.item_key%type;