APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on PER_ALL_PEOPLE_F

Line 25: , p_parent_table in VARCHAR2 default 'PER_ALL_PEOPLE_F'

21: , p_date_from in date default trunc(sysdate)
22: , p_phone_type in varchar2
23: , p_phone_number in varchar2
24: , p_parent_id in number
25: , p_parent_table in VARCHAR2 default 'PER_ALL_PEOPLE_F'
26: , p_login_person_id in NUMBER
27: , p_per_or_contact in varchar2 default null
28: , p_contact_set in varchar2 default '1'
29: , p_effective_date in date default trunc(sysdate)

Line 489: l_reg_full_name per_all_people_f.full_name%type default null;

485: -- StartRegistration
486: l_reg_per_ovn number default null;
487: l_reg_employee_number number default null;
488: l_reg_asg_ovn number default null;
489: l_reg_full_name per_all_people_f.full_name%type default null;
490: l_reg_assignment_id number;
491: l_reg_per_effective_start_date date;
492: l_reg_per_effective_end_date date;
493: l_reg_per_comment_id number;

Line 1944: l_person_id per_all_people_f.person_id%TYPE;

1940: l_phone_type per_phones.phone_type%TYPE;
1941: l_phone_number per_phones.phone_number%TYPE;
1942: l_deleted_ovn per_phones.object_version_number%TYPE;
1943: l_effective_date date;
1944: l_person_id per_all_people_f.person_id%TYPE;
1945: l_per_or_contact varchar2(30);
1946: l_trs_object_version_number
1947: hr_api_transaction_steps.object_version_number%type;
1948: l_transaction_step_id

Line 2054: ,p_parent_table => 'PER_ALL_PEOPLE_F'

2050: ,p_object_version_number => l_phone_ovn
2051: ,p_phone_type => l_phone_type
2052: ,p_effective_date => l_effective_date
2053: ,p_parent_id => l_person_id
2054: ,p_parent_table => 'PER_ALL_PEOPLE_F'
2055: ,p_date_from => l_Effective_date
2056: ,p_attribute_category => hr_transaction_api.get_varchar2_value
2057: (p_transaction_step_id => p_transaction_step_id
2058: ,p_name => 'P_ATTRIBUTE_CATEGORY')