Line 167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual;
163: Procedure pre_insert
164: (p_rec in out nocopy irc_ivc_shd.g_rec_type
165: ) is
166: -- 167: cursor c1 is select irc_vacancy_considerations_s.nextval from sys.dual; 168: cursor c2 is
169: select null from irc_vacancy_considerations
170: where vacancy_consideration_id=irc_ivc_ins.g_vacancy_consideration_id_i;
171: l_proc varchar2(72) := g_package||'pre_insert';