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_CONTACT_RELATIONSHIPS

Line 80: per_contact_relationships pcr

76: CONT_INFORMATION19 ,
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

Line 103: FROM per_contact_relationships pcr

99: --
100: CURSOR c_cont_primary_addr
101: IS
102: SELECT addr.address_id
103: FROM per_contact_relationships pcr
104: ,per_addresses addr
105: WHERE pcr.contact_relationship_id = p_contact_relationship_id
106: and pcr.contact_person_id = addr.person_id
107: and trunc(sysdate) between addr.date_from

Line 1645: from PER_CONTACT_RELATIONSHIPS

1641: ,p_contact_person_id number
1642: ,p_person_id number)
1643: is
1644: select primary_contact_flag --'N'
1645: from PER_CONTACT_RELATIONSHIPS
1646: where person_id = p_person_id
1647: and contact_person_id = p_contact_person_id
1648: and contact_type = 'EMRG'
1649: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))

Line 6834: get l_ear_con_Rel_start_date from per_contact_relationships

6830: 2. Set p_date_start to last of
6831:
6832: begin
6833: if contact_person_id not null them
6834: get l_ear_con_Rel_start_date from per_contact_relationships
6835: set l_ear_con_Rel_start_date to l_start_date
6836: else
6837: set relation_ship_start_date to l_start_date
6838: exception

Line 6912: from per_contact_relationships

6908: begin
6909: hr_utility.set_location('if p_contact_person_id is not null then'||l_proc,30 );
6910: select min(date_start)
6911: into l_start_date
6912: from per_contact_relationships
6913: where contact_person_id = p_contact_person_id;
6914: exception
6915: when others then
6916: null;

Line 11536: from PER_CONTACT_RELATIONSHIPS

11532: is
11533: select contact_relationship_id,
11534: object_version_number,
11535: primary_contact_flag
11536: from PER_CONTACT_RELATIONSHIPS
11537: where person_id = p_person_id
11538: and contact_person_id = p_contact_person_id
11539: and contact_type = 'EMRG'
11540: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))

Line 11548: from PER_CONTACT_RELATIONSHIPS

11544: ,p_person_id number)
11545: is
11546: select contact_relationship_id,
11547: object_version_number
11548: from PER_CONTACT_RELATIONSHIPS
11549: where person_id = p_person_id
11550: and contact_person_id = p_contact_person_id
11551: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
11552: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end));

Line 12478: from per_contact_relationships

12474:
12475: begin
12476: select nvl(date_start,trunc(sysdate))
12477: into l_start_contact_date
12478: from per_contact_relationships
12479: where contact_relationship_id = l_old_contact_relationship_id
12480: and object_version_number = l_ovn;
12481: exception
12482: when others then

Line 12491: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row is called as core HR team is use it for the same pourpose.

12487: if l_start_contact_date > l_date_sart then
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

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 12514: from per_contact_relationships

12510: ,p_name => 'P_CONTACT_RELATIONSHIP_ID');
12511:
12512: select rowid
12513: into p_rowid
12514: from per_contact_relationships
12515: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12516:
12517: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12518:

Line 12517: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);

12513: into p_rowid
12514: from per_contact_relationships
12515: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12516:
12517: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12518:
12519: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
12520: X_Rowid => p_rowid
12521: , X_Contact_Relationship_Id => l_CONTACT_RELATIONSHIP_ID_1

Line 12519: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(

12515: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12516:
12517: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12518:
12519: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
12520: X_Rowid => p_rowid
12521: , X_Contact_Relationship_Id => l_CONTACT_RELATIONSHIP_ID_1
12522: , X_Business_Group_Id => hr_transaction_api.get_NUMBER_value
12523: (p_transaction_step_id => p_transaction_step_id

Line 12672: , X_Session_Date => null --- this session_date is not used in PER_CONTACT_RELATIONSHIPS_PKG.update_row method, so null is pass here

12668: ,p_name => 'P_CONT_INFORMATION19')
12669: , X_Cont_Information20 => hr_transaction_api.get_VARCHAR2_value
12670: (p_transaction_step_id => p_transaction_step_id
12671: ,p_name => 'P_CONT_INFORMATION20')
12672: , X_Session_Date => null --- this session_date is not used in PER_CONTACT_RELATIONSHIPS_PKG.update_row method, so null is pass here
12673: , X_Date_Start => hr_transaction_api.get_DATE_value
12674: (p_transaction_step_id => p_transaction_step_id
12675: ,p_name => 'P_DATE_START')
12676: , X_Start_Life_Reason_Id => hr_transaction_api.get_NUMBER_value

Line 14758: select date_start into l_date_start from per_contact_relationships where

14754: open csr_contact_api(p_transaction_step_id);
14755: fetch csr_contact_api into l_dummy;
14756: if csr_contact_api%found then
14757: if p_contact_relationship_id is not null then
14758: select date_start into l_date_start from per_contact_relationships where
14759: contact_relationship_id = p_contact_relationship_id;
14760: end if;
14761: if (p_date_start < l_date_start or l_date_start = hr_api.g_date) then
14762: select max(date_start) into l_pds_date_start from per_periods_of_service

Line 14880: from per_contact_relationships

14876:
14877: cursor get_other_rel_ovn(p_contact_relationship_id number)
14878: is
14879: select object_version_number
14880: from per_contact_relationships
14881: where contact_relationship_id = p_contact_relationship_id
14882: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
14883: and nvl(date_end, trunc(sysdate));
14884:

Line 16636: from PER_CONTACT_RELATIONSHIPS pcr

16632: cursor no_of_non_emrg_rel(p_contact_relationship_id number
16633: ,p_contact_person_id number )
16634: is
16635: select count(pcr.contact_relationship_id)
16636: from PER_CONTACT_RELATIONSHIPS pcr
16637: where person_id = (select person_id
16638: from PER_CONTACT_RELATIONSHIPS
16639: where contact_person_id = p_contact_person_id
16640: and contact_relationship_id = P_contact_relationship_id

Line 16638: from PER_CONTACT_RELATIONSHIPS

16634: is
16635: select count(pcr.contact_relationship_id)
16636: from PER_CONTACT_RELATIONSHIPS pcr
16637: where person_id = (select person_id
16638: from PER_CONTACT_RELATIONSHIPS
16639: where contact_person_id = p_contact_person_id
16640: and contact_relationship_id = P_contact_relationship_id
16641: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16642: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))

Line 16644: from per_contact_relationships con

16640: and contact_relationship_id = P_contact_relationship_id
16641: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16642: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))
16643: and exists (select 1
16644: from per_contact_relationships con
16645: where con.contact_type = 'EMRG'
16646: and con.contact_person_id = p_contact_person_id
16647: and con.person_id = pcr.person_id
16648: and trunc(sysdate) >= decode(con.date_start,null,trunc(sysdate),trunc(con.date_start))

Line 16661: from PER_CONTACT_RELATIONSHIPS

16657: ,p_contact_person_id number )
16658: is
16659: select contact_relationship_id,
16660: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16661: from PER_CONTACT_RELATIONSHIPS
16662: where person_id = (select person_id
16663: from PER_CONTACT_RELATIONSHIPS
16664: where contact_person_id = p_contact_person_id
16665: and contact_relationship_id = P_contact_relationship_id

Line 16663: from PER_CONTACT_RELATIONSHIPS

16659: select contact_relationship_id,
16660: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16661: from PER_CONTACT_RELATIONSHIPS
16662: where person_id = (select person_id
16663: from PER_CONTACT_RELATIONSHIPS
16664: where contact_person_id = p_contact_person_id
16665: and contact_relationship_id = P_contact_relationship_id
16666: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16667: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))

Line 16677: from PER_CONTACT_RELATIONSHIPS pcr

16673: cursor other_rel_type(p_contact_relationship_id number
16674: ,p_contact_person_id number )
16675: is
16676: select HR_GENERAL.DECODE_LOOKUP('CONTACT', pcr.contact_type) relationship
16677: from PER_CONTACT_RELATIONSHIPS pcr
16678: where pcr.contact_person_id = p_contact_person_id
16679: and pcr.contact_relationship_id = p_contact_relationship_id
16680: and trunc(sysdate) >= decode(pcr.date_start,null,trunc(sysdate),trunc(pcr.date_start))
16681: and trunc(sysdate) < decode(pcr.date_end,null,trunc(sysdate)+1,trunc(pcr.date_end));

Line 16849: per_contact_relationships pcr

16845: SELECT
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