58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: irc_inp_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the irc_notification_preferences row.
63: --
64: delete from irc_notification_preferences
65: where notification_preference_id = p_rec.notification_preference_id;
66: --
60: irc_inp_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the irc_notification_preferences row.
63: --
64: delete from irc_notification_preferences
65: where notification_preference_id = p_rec.notification_preference_id;
66: --
67: irc_inp_shd.g_api_dml := false; -- Unset the api dml status
68: --
252: --
253: when hr_api.cannot_find_prog_unit then
254: --
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'IRC_NOTIFICATION_PREFERENCES'
257: ,p_hook_type => 'AD');
258: --
259: end;
260: --