66: 10-Oct-01 adhunter 115.19 1766066 added call points to maintain_coverage
67: and DDF cols to all procedures.
68: Re-did delete routine.
69: 19-Oct-01 wstallar 115.21 add support for TCA-mapped columns
70: 24-Oct-01 adhunter 115.23 1931258 added ben_person_delete calls in delete_row
71: 15-Nov-01 adhunter 115.24 2073795 added validation for X_Contact_Person_Id.
72: 16-Nov-01 adhunter 115.25 added dbdrv line
73: 14-Feb-02 hnarayan 115.27 1772037 added code to pass dff attributes of per_contact_relationships
74: table to ben_con_ler.ler_chk procedure
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);
2311:
2312: DELETE FROM hr_comments h
2313: WHERE h.comment_id IN
2314: (SELECT comment_id
2315: FROM PER_ALL_PEOPLE_F paf
2316: WHERE paf.person_id = X_Contact_Person_Id);
2317:
2318: -- added for 1931258
2319: ben_person_delete.delete_ben_rows(X_Contact_Person_Id);
2320:
2321: DELETE per_all_people_f
2322: WHERE person_id = X_Contact_Person_Id;
2323: