BOM Explosions

SELECT bom_explosion_temp_s.NEXTVAL
INTO l_group_id
FROM DUAL;
--
bom_oe_exploder_pkg.be_exploder(
arg_org_id => 2,
arg_starting_rev_date => SYSDATE,
arg_item_id => l_parent_item_id,
arg_comp_code => '-',
arg_user_id => fnd_profile.value('USER_ID'),
arg_err_msg => v_expl_err_msg,
arg_error_code => v_expl_err_code
);
--
setDebug('v_expl_err_msg => '||v_expl_err_msg);
setDebug('v_expl_err_code => '||v_expl_err_code);
/*
bompxinq.exploder_userexit (verify_flag => 0,
org_id => 2,
order_by => 1,
grp_id => l_group_id,
session_id => 0,
levels_to_explode => 10,
bom_or_eng => 1,
impl_flag => 1,
plan_factor_flag => 2,
explode_option => 3,
module => 2,
cst_type_id => 0,
std_comp_flag => 2,
expl_qty => 1,
item_id => l_parent_item_id,
unit_number_from => '',
unit_number_to => '',
alt_desg => '',
comp_code => NULL,
rev_date => SYSDATE,
show_rev => 1,
material_ctrl => 1,
lead_time => 2,
err_msg => v_expl_err_msg,
ERROR_CODE => v_expl_err_code
);
*/
--
SELECT top_bill_sequence_id
INTO v_line_tbl (1).component_sequence_id
FROM bom_explosions --bom_small_expl_temp cmp
WHERE 1=1
--AND group_id = l_group_id
AND component_item_id = l_parent_item_id ;