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_PROCESS_CONTACT_SS dependencies on PER_ALL_PEOPLE_F

Line 81: ,per_all_people_f pap

77: CONT_INFORMATION20 ,
78: pcr.object_version_number
79: FROM
80: per_contact_relationships pcr
81: ,per_all_people_f pap
82: ,hr_comments hc
83: WHERE pcr.contact_relationship_id = p_contact_relationship_id
84: AND pcr.contact_person_id = pap.person_id
85: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date

Line 295: l_first_name PER_ALL_PEOPLE_F.FIRST_NAME%TYPE := null;

291: l_address_step_id varchar2(100) := null;
292: l_second_address_step_id varchar2(100) := null;
293: l_addr_person_id varchar2(100) := null;
294: -- 2447751 change starts
295: l_first_name PER_ALL_PEOPLE_F.FIRST_NAME%TYPE := null;
296: l_last_name PER_ALL_PEOPLE_F.LAST_NAME%TYPE := null;
297: -- 2447751 change ends
298: l_prmry_flag varchar2(100) := null;
299: -- StartRegistration

Line 296: l_last_name PER_ALL_PEOPLE_F.LAST_NAME%TYPE := null;

292: l_second_address_step_id varchar2(100) := null;
293: l_addr_person_id varchar2(100) := null;
294: -- 2447751 change starts
295: l_first_name PER_ALL_PEOPLE_F.FIRST_NAME%TYPE := null;
296: l_last_name PER_ALL_PEOPLE_F.LAST_NAME%TYPE := null;
297: -- 2447751 change ends
298: l_prmry_flag varchar2(100) := null;
299: -- StartRegistration
300: l_contact_set varchar2(5) := null;

Line 312: from per_all_people_f

308: --
309: CURSOR c_get_names
310: IS
311: SELECT last_name, first_name
312: from per_all_people_f
313: WHERE person_id = p_contact_person_id
314: AND trunc(sysdate) BETWEEN effective_start_date and effective_end_date;
315:
316: --

Line 1659: l_employee_number per_all_people_f.employee_number%type ;

1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;
1658: l_old_contact_relationship_id number;
1659: l_employee_number per_all_people_f.employee_number%type ;
1660: l_count INTEGER := 0;
1661: l_attribute_update_mode varchar2(100) default null;
1662: l_validate boolean default false;
1663: l_basic_details_changed boolean default null;

Line 1678: l_full_name per_all_people_f.full_name%type default null;

1674: --
1675: l_effective_start_date date default null;
1676: l_effective_end_date date default null;
1677: l_per_ovn number default null;
1678: l_full_name per_all_people_f.full_name%type default null;
1679: l_comment_id number default null;
1680: l_name_combination_warning boolean default null ;
1681: l_assign_payroll_warning boolean default null ;
1682: l_orig_hire_warning boolean default null ;

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

6673: l_result varchar2(100) default null;
6674: l_reg_per_ovn number default null;
6675: l_reg_employee_number number default null;
6676: l_reg_asg_ovn number default null;
6677: l_reg_full_name per_all_people_f.full_name%type default null;
6678: l_reg_assignment_id number;
6679: l_reg_per_effective_start_date date;
6680: l_reg_per_effective_end_date date;
6681: l_reg_per_comment_id number;

Line 7268: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f

7264: -- Get the Employee number from the Database;
7265: --
7266: hr_utility.set_location('Declaring the Cursor c_pap'||l_proc,50);
7267: DECLARE
7268: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f
7269: WHERE person_id = p_per_person_id
7270: AND p_start_date BETWEEN
7271: effective_start_date AND effective_end_date ;
7272: l_pap c_pap%ROWTYPE;

Line 9482: l_person_id per_all_people_f.person_id%type

9478: ,p_effective_date in varchar2 default null
9479: )
9480: IS
9481: --
9482: l_person_id per_all_people_f.person_id%type
9483: default null;
9484: l_full_name per_all_people_f.full_name%type;
9485: l_per_comment_id per_all_people_f.comment_id%type;
9486: l_con_name_combination_warning boolean;

Line 9484: l_full_name per_all_people_f.full_name%type;

9480: IS
9481: --
9482: l_person_id per_all_people_f.person_id%type
9483: default null;
9484: l_full_name per_all_people_f.full_name%type;
9485: l_per_comment_id per_all_people_f.comment_id%type;
9486: l_con_name_combination_warning boolean;
9487: l_per_name_combination_warning boolean;
9488: l_con_orig_hire_warning boolean;

Line 9485: l_per_comment_id per_all_people_f.comment_id%type;

9481: --
9482: l_person_id per_all_people_f.person_id%type
9483: default null;
9484: l_full_name per_all_people_f.full_name%type;
9485: l_per_comment_id per_all_people_f.comment_id%type;
9486: l_con_name_combination_warning boolean;
9487: l_per_name_combination_warning boolean;
9488: l_con_orig_hire_warning boolean;
9489: l_per_orig_hire_warning boolean;

Line 9494: l_per_person_id per_all_people_f.person_id%type

9490: l_con_assign_payroll_warning boolean;
9491: l_per_assign_payroll_warning boolean;
9492:
9493: l_ovn number default null;
9494: l_per_person_id per_all_people_f.person_id%type
9495: default null;
9496: l_contact_relationship_id number default null;
9497: l_ctr_object_version_number number default null;
9498: l_per_object_version_number number default null;

Line 9503: l_employee_number per_all_people_f.employee_number%type default null ;

9499: l_per_effective_start_date date default null;
9500: l_per_effective_end_date date default null;
9501: l_con_rec_changed VARCHAR2(100) default null;
9502: l_effective_date date default null ;
9503: l_employee_number per_all_people_f.employee_number%type default null ;
9504: -- Bug 1919795
9505: l_contact_type varchar2(100);
9506: l_MIRROR_TYPE varchar2(100);
9507: l_CREATE_MIRROR_FLAG varchar2(100);

Line 9517: l_full_name1 per_all_people_f.full_name%type;

9513: l_dpdnt_bnf_personal_flag varchar2(100);
9514: l_personal_flag varchar2(100);
9515: l_primary_contact_flag varchar2(100);
9516: --
9517: l_full_name1 per_all_people_f.full_name%type;
9518: l_per_comment_id1 per_all_people_f.comment_id%type;
9519: l_con_name_combination_warnin1 boolean;
9520: l_con_orig_hire_warning1 boolean;
9521: l_per_person_id1 per_all_people_f.person_id%type

Line 9518: l_per_comment_id1 per_all_people_f.comment_id%type;

9514: l_personal_flag varchar2(100);
9515: l_primary_contact_flag varchar2(100);
9516: --
9517: l_full_name1 per_all_people_f.full_name%type;
9518: l_per_comment_id1 per_all_people_f.comment_id%type;
9519: l_con_name_combination_warnin1 boolean;
9520: l_con_orig_hire_warning1 boolean;
9521: l_per_person_id1 per_all_people_f.person_id%type
9522: default null;

Line 9521: l_per_person_id1 per_all_people_f.person_id%type

9517: l_full_name1 per_all_people_f.full_name%type;
9518: l_per_comment_id1 per_all_people_f.comment_id%type;
9519: l_con_name_combination_warnin1 boolean;
9520: l_con_orig_hire_warning1 boolean;
9521: l_per_person_id1 per_all_people_f.person_id%type
9522: default null;
9523: l_contact_relationship_id1 number default null;
9524: l_ctr_object_version_number1 number default null;
9525: l_per_object_version_number1 number default null;

Line 10660: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f

10656: -- Get the Employee number from the Database;
10657: --
10658: hr_utility.set_location('Before declaring the Cursor c_pap:'||l_proc, 30);
10659: DECLARE
10660: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f
10661: WHERE person_id = L_PER_PERSON_ID
10662: AND l_effective_date BETWEEN
10663: effective_start_date AND effective_end_date ;
10664: l_pap c_pap%ROWTYPE;

Line 11559: l_employee_number per_all_people_f.employee_number%type default null;

11555: l_effective_start_date date default null;
11556: l_effective_end_date date default null;
11557: l_ovn number default null;
11558: l_per_ovn number default null;
11559: l_employee_number per_all_people_f.employee_number%type default null;
11560: l_contact_relationship_id number default null;
11561: l_per_rec_changed varchar2(100) default 'NOTCHANGED' ;
11562: l_cont_rec_changed varchar2(100) default 'NOTCHANGED' ;
11563: l_full_name per_all_people_f.full_name%type default null;

Line 11563: l_full_name per_all_people_f.full_name%type default null;

11559: l_employee_number per_all_people_f.employee_number%type default null;
11560: l_contact_relationship_id number default null;
11561: l_per_rec_changed varchar2(100) default 'NOTCHANGED' ;
11562: l_cont_rec_changed varchar2(100) default 'NOTCHANGED' ;
11563: l_full_name per_all_people_f.full_name%type default null;
11564: l_comment_id number default null;
11565: l_name_combination_warning boolean default null ;
11566: l_assign_payroll_warning boolean default null ;
11567: l_orig_hire_warning boolean default null ;

Line 11574: l_full_name1 per_all_people_f.full_name%type;

11570: --
11571: l_contact_operation varchar2(100);
11572: l_contact_type varchar2(100);
11573: l_personal_flag varchar2(100);
11574: l_full_name1 per_all_people_f.full_name%type;
11575: l_per_comment_id1 per_all_people_f.comment_id%type;
11576: l_con_name_combination_warnin1 boolean;
11577: l_con_orig_hire_warning1 boolean;
11578: l_per_person_id1 per_all_people_f.person_id%type

Line 11575: l_per_comment_id1 per_all_people_f.comment_id%type;

11571: l_contact_operation varchar2(100);
11572: l_contact_type varchar2(100);
11573: l_personal_flag varchar2(100);
11574: l_full_name1 per_all_people_f.full_name%type;
11575: l_per_comment_id1 per_all_people_f.comment_id%type;
11576: l_con_name_combination_warnin1 boolean;
11577: l_con_orig_hire_warning1 boolean;
11578: l_per_person_id1 per_all_people_f.person_id%type
11579: default null;

Line 11578: l_per_person_id1 per_all_people_f.person_id%type

11574: l_full_name1 per_all_people_f.full_name%type;
11575: l_per_comment_id1 per_all_people_f.comment_id%type;
11576: l_con_name_combination_warnin1 boolean;
11577: l_con_orig_hire_warning1 boolean;
11578: l_per_person_id1 per_all_people_f.person_id%type
11579: default null;
11580: l_contact_relationship_id1 number default null;
11581: l_ctr_object_version_number1 number default null;
11582: l_per_object_version_number1 number default null;

Line 11723: -- With the PTU model, the per_all_people_f.person_type_id stores only the

11719: --
11720:
11721: ---------------------------------------------------------------------------
11722: -- Bug 1937643 Fix Begins - 08/04/2002
11723: -- With the PTU model, the per_all_people_f.person_type_id stores only the
11724: -- default user flavor of the system_person_type. The true user flavor
11725: -- for the system_person_type is stored in per_person_type_usages_f table.
11726: -- Since the current Personal Information Contacts region
11727: -- does not allow a user to choose any user flavor, so we do not pass in

Line 11731: -- pass the per_all_people_f.person_type_id to the api,the person_type_id in

11727: -- does not allow a user to choose any user flavor, so we do not pass in
11728: -- p_person_type_id when calling the hr_person_api.update_person. That way,
11729: -- the api will understand that the person_type is not changed and will not
11730: -- update the person_type_id in per_person_type_usages_f table as is. If we
11731: -- pass the per_all_people_f.person_type_id to the api,the person_type_id in
11732: -- per_person_type_usages_f table will be updated with that value which will
11733: -- overwrite the true user flavor of the system person type with the
11734: -- default user flavor person type. This may not be desirable.
11735: -- When we allow a user to select user flavors of person type in Contacts

Line 12492: This row handler makes all necessary changes of the per_all_people_f and per_contact_relationships table

12488: /***********************************************************************************************
12489: hr_contact_rel_api.delete_contact_relationship method is commented out as this method
12490: did not support when contact is only one, i.e, it is not dual maintained. So from now
12491: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row is called as core HR team is use it for the same pourpose.
12492: This row handler makes all necessary changes of the per_all_people_f and per_contact_relationships table
12493: One new check is add here with the help of the variable of skip_contact_create_flg
12494: This is, do not create a contact if already did so with this row handler method and has not set
12495: the end date of that row
12496: ***********************************************************************************************

Line 14769: select min(effective_start_date) into l_cont_start_date from per_all_people_f

14765: l_cov_date_start := l_pds_date_start;
14766: else
14767: l_cov_date_start := p_date_start;
14768: end if;
14769: select min(effective_start_date) into l_cont_start_date from per_all_people_f
14770: where person_id=p_contact_person_id;
14771: if (l_cov_date_start < l_cont_start_date) then
14772: open csr_address(p_contact_person_id,l_cont_start_date);
14773: fetch csr_address into l_dummy;

Line 16850: ,per_all_people_f pap

16846: primary_contact_flag,
16847: pcr.object_version_number ovn
16848: FROM
16849: per_contact_relationships pcr
16850: ,per_all_people_f pap
16851: ,hr_comments hc
16852: WHERE pcr.contact_relationship_id = p_contact_relationship_id
16853: AND pcr.contact_person_id = pap.person_id
16854: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date