145: */
146:
147: SELECT max(MAXIMUM_BOM_LEVEL)
148: INTO max_level
149: FROM BOM_PARAMETERS
150: WHERE (org_id = -1
151: or
152: (org_id <> -1 and ORGANIZATION_ID = org_id)
153: );
859: RAISE cost_type;
860: END;
861: --Get the maximum level for explosion is allowed for the Organization
862: SELECT MAXIMUM_BOM_LEVEL INTO max_level
863: FROM BOM_PARAMETERS
864: WHERE ORGANIZATION_ID = t_org_code_list(I);
865:
866: SELECT bom_explosion_temp_s.nextval
867: INTO l_group_id from dual;