10: | Parameters: org_id organization_id
11: | order_by 1 - Op seq, item seq
12: | 2 - Item seq, op seq
13: | grp_id unique value to identify current explosion
14: | use value FROM sequence BOM_EXPLOSIONS_ALL_s
15: | session_id unique value to identify current session
16: | use value FROM BOM_EXPLOSIONS_ALL_session_s
17: | levels_to_explode
18: | bom_or_eng 1 - BOM
12: | 2 - Item seq, op seq
13: | grp_id unique value to identify current explosion
14: | use value FROM sequence BOM_EXPLOSIONS_ALL_s
15: | session_id unique value to identify current session
16: | use value FROM BOM_EXPLOSIONS_ALL_session_s
17: | levels_to_explode
18: | bom_or_eng 1 - BOM
19: | 2 - ENG
20: | impl_flag 1 - implemented only
3336: EXCEPTION WHEN NO_DATA_FOUND
3337: THEN
3338: -- Insert for plan level 0
3339:
3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3341:
3342: insert INTO BOM_EXPLOSIONS_ALL
3343: (
3344: group_id,