4: procedure handle_purge(x_return_status OUT NOCOPY VARCHAR2)
5: IS
6: BEGIN
7: -- delete pending suppliser user registration of vendors no longer in ap_suppliers table
8: DELETE FROM fnd_registrations
9: WHERE registration_id IN
10: (SELECT registration_id
11: FROM fnd_registration_details frd
12: WHERE field_name = 'Supplier Number'
17: -- Remove all the registrations details that dont have a parent
18: DELETE FROM fnd_registration_details
19: WHERE registration_id not IN
20: (SELECT registration_id
21: FROM fnd_registrations
22: );
23:
24: x_return_status := fnd_api.g_ret_sts_success ;
25: