DBA Data[Home] [Help]

APPS.HR_CONTACT_REL_API dependencies on PER_CONTACT_RELATIONSHIPS_PKG

Line 1379: l_mirror_contact_type := per_contact_relationships_pkg.get_mirror_contact_type

1375: and (p_contact_type = hr_api.g_varchar2
1376: or p_contact_type = l_contact_type)
1377: then
1378: --
1379: l_mirror_contact_type := per_contact_relationships_pkg.get_mirror_contact_type
1380: (l_contact_type);
1381: --
1382: open check_mirror;
1383: fetch check_mirror into l_mirror_rec;

Line 1648: l_mirror_contact_type := per_contact_relationships_pkg.get_mirror_contact_type

1644: --
1645: -- If Relationship has a mirror row then then we have to delete the mirror rel.
1646: -- Have to do this first otherwise the cursor will always fail.
1647: -- start of code for bug 2742210
1648: l_mirror_contact_type := per_contact_relationships_pkg.get_mirror_contact_type
1649: (l_contact_type);
1650: -- end of code for bug 2742210
1651: open check_mirror;
1652: fetch check_mirror into l_mirror_rec;

Line 1685: per_contact_relationships_pkg.delete_validation

1681: and hr_contact_relationships.multiple_contacts(l_contact_person_id) = 'N') then
1682: --
1683: hr_utility.set_location(l_proc, 31);
1684: --
1685: per_contact_relationships_pkg.delete_validation
1686: (l_contact_person_id
1687: ,p_contact_relationship_id
1688: );
1689: -- delete the person