For c_p in c_parameter loop
--Get all of the revision that between from date and to date
v_err:='Explode Bom at date from ';
select bom_explosion_temp_s.nextval into l_group_id from dual;
bompxinq.exploder_userexit(verify_flag => 0
, org_id => p_org_id
, order_by => 1
, grp_id => l_group_id
, session_id => 0
, levels_to_explode => 59
, bom_or_eng => 1
, impl_flag => 1
, plan_factor_flag => 2
, explode_option => 2
, module => 2
, cst_type_id => ''
, std_comp_flag => 2
, expl_qty => 1
, item_id => c_p.inventory_item_id
, alt_desg => ''
, comp_code => null
, unit_number_from => ''
, unit_number_to => ''
, rev_date => to_date(p_date_from,'YYYY-MM-DD')
, show_rev => 1
, material_ctrl => 2
, lead_time => 2
, err_msg => errbuf
, error_code => retcode);

end loop;