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.PER_CONTACT_RELATIONSHIPS_PKG dependencies on HR_API

Line 1259: IF X_Person_Type_Id IS NOT NULL AND X_Person_Type_Id <> hr_api.g_number THEN

1255: CLOSE C;
1256: --
1257: -- added for PTU
1258: --
1259: IF X_Person_Type_Id IS NOT NULL AND X_Person_Type_Id <> hr_api.g_number THEN
1260: BEGIN
1261: SELECT person_type_id INTO l_person_type_id
1262: FROM per_person_types
1263: WHERE person_type_id = X_Person_Type_Id

Line 1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)

1837: CURSOR Check_Mirror_Update IS
1838: SELECT 'Y'
1839: FROM per_contact_relationships
1840: WHERE ROWID = CHARTOROWID(X_Rowid)
1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)
1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)

Line 1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)

1838: SELECT 'Y'
1839: FROM per_contact_relationships
1840: WHERE ROWID = CHARTOROWID(X_Rowid)
1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)
1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)
1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));

Line 1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)

1839: FROM per_contact_relationships
1840: WHERE ROWID = CHARTOROWID(X_Rowid)
1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)
1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)
1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));
1847: --

Line 1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)

1840: WHERE ROWID = CHARTOROWID(X_Rowid)
1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)
1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)
1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));
1847: --
1848: CURSOR Check_Mirror IS

Line 1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)

1841: AND( nvl(date_start,hr_api.g_date) <> nvl(X_date_start,hr_api.g_date)
1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)
1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));
1847: --
1848: CURSOR Check_Mirror IS
1849: SELECT ROWIDTOCHAR(ROWID)

Line 1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));

1842: OR nvl(start_life_reason_id,hr_api.g_number) <> nvl(X_start_life_reason_Id,hr_api.g_number)
1843: OR nvl(date_end,hr_api.g_date) <> nvl(X_date_end,hr_api.g_date)
1844: OR nvl(end_life_reason_id,hr_api.g_number) <> nvl(X_end_life_reason_id,hr_api.g_number)
1845: OR nvl(rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2) <> nvl(X_rltd_per_rsds_w_dsgntr_flag,hr_api.g_varchar2)
1846: OR nvl(personal_flag,hr_api.g_varchar2) <> nvl(X_personal_flag,hr_api.g_varchar2));
1847: --
1848: CURSOR Check_Mirror IS
1849: SELECT ROWIDTOCHAR(ROWID)
1850: FROM per_contact_relationships

Line 1854: AND nvl(date_start,hr_api.g_date) =nvl(l_date_start,hr_api.g_date)--fix for bug 4867048.

1850: FROM per_contact_relationships
1851: WHERE contact_person_id = X_Person_Id
1852: AND person_id = X_Contact_Person_Id
1853: AND contact_type = l_old_mirror_contact_type
1854: AND nvl(date_start,hr_api.g_date) =nvl(l_date_start,hr_api.g_date)--fix for bug 4867048.
1855: FOR UPDATE OF Contact_Type;
1856: --
1857: CURSOR Check_Relationship_Changed IS
1858: SELECT 'Y'