Line 247: cursor c1 is select irc_notification_prefs_s.nextval from sys.dual;
243: Procedure pre_insert
244: (p_rec in out nocopy irc_inp_shd.g_rec_type
245: ) is
246: -- 247: cursor c1 is select irc_notification_prefs_s.nextval from sys.dual; 248: --
249: cursor c2 is
250: select null from irc_notification_preferences
251: where notification_preference_id = irc_inp_ins.g_notification_preference_id_i;