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: --
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
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;
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;
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;