DBA Data[Home] [Help]

APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on HR_CONTACT_RELATIONSHIPS

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

2292: --
2293: -- bug fix 4197342
2294: -- condition added to check whether the person is an irec candidate.
2295:
2296: IF hr_contact_relationships.contact_only(X_Contact_Person_Id) = 'Y'
2297: AND hr_contact_relationships.multiple_contacts(X_Contact_Person_Id) = 'N'
2298: AND NOT irc_candidate_test.is_person_a_candidate(X_Contact_Person_Id)
2299: THEN
2300: --

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

2293: -- bug fix 4197342
2294: -- condition added to check whether the person is an irec candidate.
2295:
2296: IF hr_contact_relationships.contact_only(X_Contact_Person_Id) = 'Y'
2297: AND hr_contact_relationships.multiple_contacts(X_Contact_Person_Id) = 'N'
2298: AND NOT irc_candidate_test.is_person_a_candidate(X_Contact_Person_Id)
2299: THEN
2300: --
2301: -- Check foreign key tables

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

2372: -- do foreign key checks ie. address
2373: --
2374: -- Bug 1295442 Added check for multiple contacts
2375: --
2376: IF hr_contact_relationships.contact_only(X_Person_Id) = 'Y'
2377: AND hr_contact_relationships.multiple_contacts(X_Person_Id) = 'N'
2378: THEN
2379:
2380: OPEN Personal_Analyses;

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

2373: --
2374: -- Bug 1295442 Added check for multiple contacts
2375: --
2376: IF hr_contact_relationships.contact_only(X_Person_Id) = 'Y'
2377: AND hr_contact_relationships.multiple_contacts(X_Person_Id) = 'N'
2378: THEN
2379:
2380: OPEN Personal_Analyses;
2381: FETCH Personal_Analyses INTO l_pa_exists;

Line 2411: hr_contact_relationships.check_ppm(p_contact_id => X_Person_Id

2407: --
2408: -- Check to see if Personal Payment Method exists
2409: -- where contact is the Payee.
2410: --
2411: hr_contact_relationships.check_ppm(p_contact_id => X_Person_Id
2412: ,p_contact_relationship_id => X_Contact_Relationship_Id
2413: ,p_mode => 'D');
2414: END IF;
2415: END;