DBA Data[Home] [Help]

APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on HR_CONTACT_RELATIONSHIPS

Line 2284: IF hr_contact_relationships.contact_only(X_Contact_Person_Id) = 'Y'

2280: --
2281: -- bug fix 4197342
2282: -- condition added to check whether the person is an irec candidate.
2283:
2284: IF hr_contact_relationships.contact_only(X_Contact_Person_Id) = 'Y'
2285: AND hr_contact_relationships.multiple_contacts(X_Contact_Person_Id) = 'N'
2286: AND NOT irc_candidate_test.is_person_a_candidate(X_Contact_Person_Id)
2287: THEN
2288: --

Line 2285: AND hr_contact_relationships.multiple_contacts(X_Contact_Person_Id) = 'N'

2281: -- bug fix 4197342
2282: -- condition added to check whether the person is an irec candidate.
2283:
2284: IF hr_contact_relationships.contact_only(X_Contact_Person_Id) = 'Y'
2285: AND hr_contact_relationships.multiple_contacts(X_Contact_Person_Id) = 'N'
2286: AND NOT irc_candidate_test.is_person_a_candidate(X_Contact_Person_Id)
2287: THEN
2288: --
2289: -- Check foreign key tables

Line 2364: IF hr_contact_relationships.contact_only(X_Person_Id) = 'Y'

2360: -- do foreign key checks ie. address
2361: --
2362: -- Bug 1295442 Added check for multiple contacts
2363: --
2364: IF hr_contact_relationships.contact_only(X_Person_Id) = 'Y'
2365: AND hr_contact_relationships.multiple_contacts(X_Person_Id) = 'N'
2366: THEN
2367:
2368: OPEN Personal_Analyses;

Line 2365: AND hr_contact_relationships.multiple_contacts(X_Person_Id) = 'N'

2361: --
2362: -- Bug 1295442 Added check for multiple contacts
2363: --
2364: IF hr_contact_relationships.contact_only(X_Person_Id) = 'Y'
2365: AND hr_contact_relationships.multiple_contacts(X_Person_Id) = 'N'
2366: THEN
2367:
2368: OPEN Personal_Analyses;
2369: FETCH Personal_Analyses INTO l_pa_exists;

Line 2399: hr_contact_relationships.check_ppm(p_contact_id => X_Person_Id

2395: --
2396: -- Check to see if Personal Payment Method exists
2397: -- where contact is the Payee.
2398: --
2399: hr_contact_relationships.check_ppm(p_contact_id => X_Person_Id
2400: ,p_contact_relationship_id => X_Contact_Relationship_Id
2401: ,p_mode => 'D');
2402: END IF;
2403: END;