APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 85: child records in per_contact_extra_info_f.

81: update.
82: Modified procedure update_contact to handle
83: date_of_death.
84: Modified procedure delete_row to delete
85: child records in per_contact_extra_info_f.
86: 26-Jul-02 irgonzal 115.29 2483186 added hr_security_internal.populate_new_person
87: call to ensure security list maintenance
88: gets properly updated.
89: 06-Sep-02 vramanai 115.30 2533935 modified the cursor defination of check_person_changed

Line 232: -- the given date_end in per_contact_extra_info_f.

228: -- Description:
229: -- Accepts contact_relationship_id, date_start, and date_end, and check if
230: -- neither child record with effective_start_date earlier than the given
231: -- date_start exists nor child records with effective_end_date later than
232: -- the given date_end in per_contact_extra_info_f.
233: --
234: -- Prerequisites:
235: -- None.
236: --

Line 269: FROM per_contact_extra_info_f

265: x_date_end IN per_contact_relationships.date_end%TYPE) IS
266: --
267: CURSOR cel_earlier_child_exists IS
268: SELECT 1
269: FROM per_contact_extra_info_f
270: WHERE contact_relationship_id = x_contact_relationship_id
271: AND effective_start_date < x_date_start;
272: --
273: CURSOR cel_later_child_exists IS

Line 275: FROM per_contact_extra_info_f

271: AND effective_start_date < x_date_start;
272: --
273: CURSOR cel_later_child_exists IS
274: SELECT 1
275: FROM per_contact_extra_info_f
276: WHERE contact_relationship_id = x_contact_relationship_id
277: AND effective_end_date > x_date_end;
278: --
279: l_dummy VARCHAR2(1);

Line 1948: -- This validation guarantees all PER_CONTACT_EXTRA_INFO_F records

1944: END IF;
1945: --
1946: /*
1947: -- Bug.3207660
1948: -- This validation guarantees all PER_CONTACT_EXTRA_INFO_F records
1949: -- are within CTR.DATE_START and CTR.DATE_END date range.
1950: -- Now the validation is relaxed(removed).
1951: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.
1952: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be

Line 1951: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.

1947: -- Bug.3207660
1948: -- This validation guarantees all PER_CONTACT_EXTRA_INFO_F records
1949: -- are within CTR.DATE_START and CTR.DATE_END date range.
1950: -- Now the validation is relaxed(removed).
1951: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.
1952: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be
1953: -- within the date range of PER_ALL_PEOPLE_F is still alive.
1954: chk_dates(
1955: x_contact_relationship_id => x_contact_relationship_id,

Line 1952: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be

1948: -- This validation guarantees all PER_CONTACT_EXTRA_INFO_F records
1949: -- are within CTR.DATE_START and CTR.DATE_END date range.
1950: -- Now the validation is relaxed(removed).
1951: -- PER_CONTACT_EXTRA_INFO_F records can stay outside the range of CTR.
1952: -- Note the validation that PER_CONTACT_EXTRA_INFO_F records must be
1953: -- within the date range of PER_ALL_PEOPLE_F is still alive.
1954: chk_dates(
1955: x_contact_relationship_id => x_contact_relationship_id,
1956: x_date_start => x_date_start,

Line 2306: DELETE FROM per_contact_extra_info_f

2302: --
2303: Delete_Validation(X_Contact_Person_Id
2304: ,X_Contact_Relationship_Id);
2305: --
2306: DELETE FROM per_contact_extra_info_f
2307: WHERE contact_relationship_id = x_contact_relationship_id;
2308: --
2309: -- added for 1931258
2310: ben_person_delete.perform_ri_check(X_Contact_Person_Id);