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 6746: l_reg_full_name per_all_people_f.full_name%type default null;

6742: l_result varchar2(100) default null;
6743: l_reg_per_ovn number default null;
6744: l_reg_employee_number number default null;
6745: l_reg_asg_ovn number default null;
6746: l_reg_full_name per_all_people_f.full_name%type default null;
6747: l_reg_assignment_id number;
6748: l_reg_per_effective_start_date date;
6749: l_reg_per_effective_end_date date;
6750: l_reg_per_comment_id number;

Line 7337: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f

7333: -- Get the Employee number from the Database;
7334: --
7335: hr_utility.set_location('Declaring the Cursor c_pap'||l_proc,50);
7336: DECLARE
7337: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f
7338: WHERE person_id = p_per_person_id
7339: AND p_start_date BETWEEN
7340: effective_start_date AND effective_end_date ;
7341: l_pap c_pap%ROWTYPE;

Line 9551: l_person_id per_all_people_f.person_id%type

9547: ,p_effective_date in varchar2 default null
9548: )
9549: IS
9550: --
9551: l_person_id per_all_people_f.person_id%type
9552: default null;
9553: l_full_name per_all_people_f.full_name%type;
9554: l_per_comment_id per_all_people_f.comment_id%type;
9555: l_con_name_combination_warning boolean;

Line 9553: l_full_name per_all_people_f.full_name%type;

9549: IS
9550: --
9551: l_person_id per_all_people_f.person_id%type
9552: default null;
9553: l_full_name per_all_people_f.full_name%type;
9554: l_per_comment_id per_all_people_f.comment_id%type;
9555: l_con_name_combination_warning boolean;
9556: l_per_name_combination_warning boolean;
9557: l_con_orig_hire_warning boolean;

Line 9554: l_per_comment_id per_all_people_f.comment_id%type;

9550: --
9551: l_person_id per_all_people_f.person_id%type
9552: default null;
9553: l_full_name per_all_people_f.full_name%type;
9554: l_per_comment_id per_all_people_f.comment_id%type;
9555: l_con_name_combination_warning boolean;
9556: l_per_name_combination_warning boolean;
9557: l_con_orig_hire_warning boolean;
9558: l_per_orig_hire_warning boolean;

Line 9563: l_per_person_id per_all_people_f.person_id%type

9559: l_con_assign_payroll_warning boolean;
9560: l_per_assign_payroll_warning boolean;
9561:
9562: l_ovn number default null;
9563: l_per_person_id per_all_people_f.person_id%type
9564: default null;
9565: l_contact_relationship_id number default null;
9566: l_ctr_object_version_number number default null;
9567: l_per_object_version_number number default null;

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

9568: l_per_effective_start_date date default null;
9569: l_per_effective_end_date date default null;
9570: l_con_rec_changed VARCHAR2(100) default null;
9571: l_effective_date date default null ;
9572: l_employee_number per_all_people_f.employee_number%type default null ;
9573: -- Bug 1919795
9574: l_contact_type varchar2(100);
9575: l_MIRROR_TYPE varchar2(100);
9576: l_CREATE_MIRROR_FLAG varchar2(100);

Line 9586: l_full_name1 per_all_people_f.full_name%type;

9582: l_dpdnt_bnf_personal_flag varchar2(100);
9583: l_personal_flag varchar2(100);
9584: l_primary_contact_flag varchar2(100);
9585: --
9586: l_full_name1 per_all_people_f.full_name%type;
9587: l_per_comment_id1 per_all_people_f.comment_id%type;
9588: l_con_name_combination_warnin1 boolean;
9589: l_con_orig_hire_warning1 boolean;
9590: l_per_person_id1 per_all_people_f.person_id%type

Line 9587: l_per_comment_id1 per_all_people_f.comment_id%type;

9583: l_personal_flag varchar2(100);
9584: l_primary_contact_flag varchar2(100);
9585: --
9586: l_full_name1 per_all_people_f.full_name%type;
9587: l_per_comment_id1 per_all_people_f.comment_id%type;
9588: l_con_name_combination_warnin1 boolean;
9589: l_con_orig_hire_warning1 boolean;
9590: l_per_person_id1 per_all_people_f.person_id%type
9591: default null;

Line 9590: l_per_person_id1 per_all_people_f.person_id%type

9586: l_full_name1 per_all_people_f.full_name%type;
9587: l_per_comment_id1 per_all_people_f.comment_id%type;
9588: l_con_name_combination_warnin1 boolean;
9589: l_con_orig_hire_warning1 boolean;
9590: l_per_person_id1 per_all_people_f.person_id%type
9591: default null;
9592: l_contact_relationship_id1 number default null;
9593: l_ctr_object_version_number1 number default null;
9594: l_per_object_version_number1 number default null;

Line 10762: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f

10758: -- Get the Employee number from the Database;
10759: --
10760: hr_utility.set_location('Before declaring the Cursor c_pap:'||l_proc, 30);
10761: DECLARE
10762: CURSOR c_pap IS SELECT employee_number FROM per_all_people_f
10763: WHERE person_id = L_PER_PERSON_ID
10764: AND l_effective_date BETWEEN
10765: effective_start_date AND effective_end_date ;
10766: l_pap c_pap%ROWTYPE;

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

11681: l_effective_start_date date default null;
11682: l_effective_end_date date default null;
11683: l_ovn number default null;
11684: l_per_ovn number default null;
11685: l_employee_number per_all_people_f.employee_number%type default null;
11686: l_contact_relationship_id number default null;
11687: l_per_rec_changed varchar2(100) default 'NOTCHANGED' ;
11688: l_cont_rec_changed varchar2(100) default 'NOTCHANGED' ;
11689: l_full_name per_all_people_f.full_name%type default null;

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

11685: l_employee_number per_all_people_f.employee_number%type default null;
11686: l_contact_relationship_id number default null;
11687: l_per_rec_changed varchar2(100) default 'NOTCHANGED' ;
11688: l_cont_rec_changed varchar2(100) default 'NOTCHANGED' ;
11689: l_full_name per_all_people_f.full_name%type default null;
11690: l_comment_id number default null;
11691: l_name_combination_warning boolean default null ;
11692: l_assign_payroll_warning boolean default null ;
11693: l_orig_hire_warning boolean default null ;

Line 11700: l_full_name1 per_all_people_f.full_name%type;

11696: --
11697: l_contact_operation varchar2(100);
11698: l_contact_type varchar2(100);
11699: l_personal_flag varchar2(100);
11700: l_full_name1 per_all_people_f.full_name%type;
11701: l_per_comment_id1 per_all_people_f.comment_id%type;
11702: l_con_name_combination_warnin1 boolean;
11703: l_con_orig_hire_warning1 boolean;
11704: l_per_person_id1 per_all_people_f.person_id%type

Line 11701: l_per_comment_id1 per_all_people_f.comment_id%type;

11697: l_contact_operation varchar2(100);
11698: l_contact_type varchar2(100);
11699: l_personal_flag varchar2(100);
11700: l_full_name1 per_all_people_f.full_name%type;
11701: l_per_comment_id1 per_all_people_f.comment_id%type;
11702: l_con_name_combination_warnin1 boolean;
11703: l_con_orig_hire_warning1 boolean;
11704: l_per_person_id1 per_all_people_f.person_id%type
11705: default null;

Line 11704: l_per_person_id1 per_all_people_f.person_id%type

11700: l_full_name1 per_all_people_f.full_name%type;
11701: l_per_comment_id1 per_all_people_f.comment_id%type;
11702: l_con_name_combination_warnin1 boolean;
11703: l_con_orig_hire_warning1 boolean;
11704: l_per_person_id1 per_all_people_f.person_id%type
11705: default null;
11706: l_contact_relationship_id1 number default null;
11707: l_ctr_object_version_number1 number default null;
11708: l_per_object_version_number1 number default null;

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

11845: --
11846:
11847: ---------------------------------------------------------------------------
11848: -- Bug 1937643 Fix Begins - 08/04/2002
11849: -- With the PTU model, the per_all_people_f.person_type_id stores only the
11850: -- default user flavor of the system_person_type. The true user flavor
11851: -- for the system_person_type is stored in per_person_type_usages_f table.
11852: -- Since the current Personal Information Contacts region
11853: -- does not allow a user to choose any user flavor, so we do not pass in

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

11853: -- does not allow a user to choose any user flavor, so we do not pass in
11854: -- p_person_type_id when calling the hr_person_api.update_person. That way,
11855: -- the api will understand that the person_type is not changed and will not
11856: -- update the person_type_id in per_person_type_usages_f table as is. If we
11857: -- pass the per_all_people_f.person_type_id to the api,the person_type_id in
11858: -- per_person_type_usages_f table will be updated with that value which will
11859: -- overwrite the true user flavor of the system person type with the
11860: -- default user flavor person type. This may not be desirable.
11861: -- When we allow a user to select user flavors of person type in Contacts

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

12614: /***********************************************************************************************
12615: hr_contact_rel_api.delete_contact_relationship method is commented out as this method
12616: did not support when contact is only one, i.e, it is not dual maintained. So from now
12617: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row is called as core HR team is use it for the same pourpose.
12618: This row handler makes all necessary changes of the per_all_people_f and per_contact_relationships table
12619: One new check is add here with the help of the variable of skip_contact_create_flg
12620: This is, do not create a contact if already did so with this row handler method and has not set
12621: the end date of that row
12622: ***********************************************************************************************

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

14933: l_cov_date_start := l_pds_date_start;
14934: else
14935: l_cov_date_start := p_date_start;
14936: end if;
14937: select min(effective_start_date) into l_cont_start_date from per_all_people_f
14938: where person_id=p_contact_person_id;
14939: if (l_cov_date_start < l_cont_start_date) then
14940: open csr_address(p_contact_person_id,l_cont_start_date);
14941: fetch csr_address into l_dummy;

Line 17044: ,per_all_people_f pap

17040: primary_contact_flag,
17041: pcr.object_version_number ovn
17042: FROM
17043: per_contact_relationships pcr
17044: ,per_all_people_f pap
17045: ,hr_comments hc
17046: WHERE pcr.contact_relationship_id = p_contact_relationship_id
17047: AND pcr.contact_person_id = pap.person_id
17048: AND p_eff_date BETWEEN pap.effective_start_date and pap.effective_end_date