Line 172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual;
168: Procedure pre_insert
169: (p_rec in out nocopy irc_jbi_shd.g_rec_type
170: ) is
171: -- 172: cursor c1 is select irc_job_basket_items_s.nextval from sys.dual; 173: cursor c2 is
174: select null from irc_job_basket_items
175: where job_basket_item_id=irc_jbi_ins.g_job_basket_item_id_i;
176: l_proc varchar2(72) := g_package||'pre_insert';