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 1718: from PER_CONTACT_RELATIONSHIPS

1714: primary_contact_flag,
1715: person_id,
1716: date_start,
1717: date_end
1718: from PER_CONTACT_RELATIONSHIPS
1719: where person_id = p_person_id
1720: and contact_person_id = p_cont_person_id
1721: and contact_type = 'EMRG'
1722: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))

Line 1728: from per_contact_relationships

1724:
1725:
1726: cursor csr_chk_primary_cnt is
1727: select 'Y'
1728: from per_contact_relationships
1729: where person_id = p_person_id
1730: and primary_contact_flag = 'Y'
1731: and (nvl(date_end,hr_general.end_of_time)
1732: > nvl(z_date_start,hr_general.start_of_time)

Line 6903: get l_ear_con_Rel_start_date from per_contact_relationships

6899: 2. Set p_date_start to last of
6900:
6901: begin
6902: if contact_person_id not null them
6903: get l_ear_con_Rel_start_date from per_contact_relationships
6904: set l_ear_con_Rel_start_date to l_start_date
6905: else
6906: set relation_ship_start_date to l_start_date
6907: exception

Line 6981: from per_contact_relationships

6977: begin
6978: hr_utility.set_location('if p_contact_person_id is not null then'||l_proc,30 );
6979: select min(date_start)
6980: into l_start_date
6981: from per_contact_relationships
6982: where contact_person_id = p_contact_person_id;
6983: exception
6984: when others then
6985: null;

Line 9604: from per_contact_relationships

9600: z_date_end date;
9601: l_exists varchar2(1) := 'N';
9602: cursor csr_chk_primary_cnt is
9603: select 'Y'
9604: from per_contact_relationships
9605: where person_id = l_person_id
9606: and primary_contact_flag = 'Y'
9607: and (nvl(date_end,hr_general.end_of_time)
9608: > nvl(z_date_start,hr_general.start_of_time)

Line 11646: from PER_CONTACT_RELATIONSHIPS

11642: primary_contact_flag,
11643: person_id,
11644: date_start,
11645: date_end
11646: from PER_CONTACT_RELATIONSHIPS
11647: where person_id = p_person_id
11648: and contact_person_id = p_contact_person_id
11649: and contact_type = 'EMRG'
11650: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))

Line 11658: from PER_CONTACT_RELATIONSHIPS

11654: ,p_person_id number)
11655: is
11656: select contact_relationship_id,
11657: object_version_number
11658: from PER_CONTACT_RELATIONSHIPS
11659: where person_id = p_person_id
11660: and contact_person_id = p_contact_person_id
11661: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
11662: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end));

Line 11672: from per_contact_relationships

11668: z_date_end date;
11669: l_exists varchar2(1) := 'N';
11670: cursor csr_chk_primary_cnt is
11671: select 'Y'
11672: from per_contact_relationships
11673: where person_id = z_person_id
11674: and primary_contact_flag = 'Y'
11675: and (nvl(date_end,hr_general.end_of_time)
11676: > nvl(z_date_start,hr_general.start_of_time)

Line 12604: from per_contact_relationships

12600:
12601: begin
12602: select nvl(date_start,trunc(sysdate))
12603: into l_start_contact_date
12604: from per_contact_relationships
12605: where contact_relationship_id = l_old_contact_relationship_id
12606: and object_version_number = l_ovn;
12607: exception
12608: when others then

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

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

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

12636: ,p_name => 'P_CONTACT_RELATIONSHIP_ID');
12637:
12638: select rowid
12639: into p_rowid
12640: from per_contact_relationships
12641: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12642:
12643: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12644:

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

12639: into p_rowid
12640: from per_contact_relationships
12641: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12642:
12643: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12644:
12645: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
12646: X_Rowid => p_rowid
12647: , X_Contact_Relationship_Id => l_CONTACT_RELATIONSHIP_ID_1

Line 12645: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(

12641: where CONTACT_RELATIONSHIP_ID = l_CONTACT_RELATIONSHIP_ID_1;
12642:
12643: hr_utility.set_location('before call PER_CONTACT_RELATIONSHIPS_PKG.Update_Row:X_Contact_Relationship_Id:' || l_CONTACT_RELATIONSHIP_ID_1 , 5);
12644:
12645: PER_CONTACT_RELATIONSHIPS_PKG.Update_Row(
12646: X_Rowid => p_rowid
12647: , X_Contact_Relationship_Id => l_CONTACT_RELATIONSHIP_ID_1
12648: , X_Business_Group_Id => hr_transaction_api.get_NUMBER_value
12649: (p_transaction_step_id => p_transaction_step_id

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

12794: ,p_name => 'P_CONT_INFORMATION19')
12795: , X_Cont_Information20 => hr_transaction_api.get_VARCHAR2_value
12796: (p_transaction_step_id => p_transaction_step_id
12797: ,p_name => 'P_CONT_INFORMATION20')
12798: , X_Session_Date => null --- this session_date is not used in PER_CONTACT_RELATIONSHIPS_PKG.update_row method, so null is pass here
12799: , X_Date_Start => hr_transaction_api.get_DATE_value
12800: (p_transaction_step_id => p_transaction_step_id
12801: ,p_name => 'P_DATE_START')
12802: , X_Start_Life_Reason_Id => hr_transaction_api.get_NUMBER_value

Line 14926: select date_start into l_date_start from per_contact_relationships where

14922: open csr_contact_api(p_transaction_step_id);
14923: fetch csr_contact_api into l_dummy;
14924: if csr_contact_api%found then
14925: if p_contact_relationship_id is not null then
14926: select date_start into l_date_start from per_contact_relationships where
14927: contact_relationship_id = p_contact_relationship_id;
14928: end if;
14929: if (p_date_start < l_date_start or l_date_start = hr_api.g_date) then
14930: select max(date_start) into l_pds_date_start from per_periods_of_service

Line 15048: from per_contact_relationships

15044:
15045: cursor get_other_rel_ovn(p_contact_relationship_id number)
15046: is
15047: select object_version_number
15048: from per_contact_relationships
15049: where contact_relationship_id = p_contact_relationship_id
15050: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
15051: and nvl(date_end, trunc(sysdate));
15052:

Line 16381: from per_contact_relationships

16377: z_date_start date;
16378: l_exists varchar2(1) := 'N';
16379: cursor csr_chk_primary_cnt is
16380: select 'Y'
16381: from per_contact_relationships
16382: where person_id = p_person_id
16383: and primary_contact_flag = 'Y'
16384: and (nvl(date_end,hr_general.end_of_time)
16385: > nvl(p_date_start,hr_general.start_of_time)

Line 16830: from PER_CONTACT_RELATIONSHIPS pcr

16826: cursor no_of_non_emrg_rel(p_contact_relationship_id number
16827: ,p_contact_person_id number )
16828: is
16829: select count(pcr.contact_relationship_id)
16830: from PER_CONTACT_RELATIONSHIPS pcr
16831: where person_id = (select person_id
16832: from PER_CONTACT_RELATIONSHIPS
16833: where contact_person_id = p_contact_person_id
16834: and contact_relationship_id = P_contact_relationship_id

Line 16832: from PER_CONTACT_RELATIONSHIPS

16828: is
16829: select count(pcr.contact_relationship_id)
16830: from PER_CONTACT_RELATIONSHIPS pcr
16831: where person_id = (select person_id
16832: from PER_CONTACT_RELATIONSHIPS
16833: where contact_person_id = p_contact_person_id
16834: and contact_relationship_id = P_contact_relationship_id
16835: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16836: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))

Line 16838: from per_contact_relationships con

16834: and contact_relationship_id = P_contact_relationship_id
16835: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16836: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))
16837: and exists (select 1
16838: from per_contact_relationships con
16839: where con.contact_type = 'EMRG'
16840: and con.contact_person_id = p_contact_person_id
16841: and con.person_id = pcr.person_id
16842: and trunc(sysdate) >= decode(con.date_start,null,trunc(sysdate),trunc(con.date_start))

Line 16855: from PER_CONTACT_RELATIONSHIPS

16851: ,p_contact_person_id number )
16852: is
16853: select contact_relationship_id,
16854: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16855: from PER_CONTACT_RELATIONSHIPS
16856: where person_id = (select person_id
16857: from PER_CONTACT_RELATIONSHIPS
16858: where contact_person_id = p_contact_person_id
16859: and contact_relationship_id = P_contact_relationship_id

Line 16857: from PER_CONTACT_RELATIONSHIPS

16853: select contact_relationship_id,
16854: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16855: from PER_CONTACT_RELATIONSHIPS
16856: where person_id = (select person_id
16857: from PER_CONTACT_RELATIONSHIPS
16858: where contact_person_id = p_contact_person_id
16859: and contact_relationship_id = P_contact_relationship_id
16860: and trunc(sysdate) >= decode(date_start,null,trunc(sysdate),trunc(date_start))
16861: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)))

Line 16871: from PER_CONTACT_RELATIONSHIPS pcr

16867: cursor other_rel_type(p_contact_relationship_id number
16868: ,p_contact_person_id number )
16869: is
16870: select HR_GENERAL.DECODE_LOOKUP('CONTACT', pcr.contact_type) relationship
16871: from PER_CONTACT_RELATIONSHIPS pcr
16872: where pcr.contact_person_id = p_contact_person_id
16873: and pcr.contact_relationship_id = p_contact_relationship_id
16874: and trunc(sysdate) >= decode(pcr.date_start,null,trunc(sysdate),trunc(pcr.date_start))
16875: and trunc(sysdate) < decode(pcr.date_end,null,trunc(sysdate)+1,trunc(pcr.date_end));

Line 17043: per_contact_relationships pcr

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