1508: end update_parts_loop;
1509:
1510: procedure update_planning_nodes is
1511: begin
1512: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_PNS';
1513: insert into csp_sup_dem_pns(
1514: inventory_item_id,
1515: organization_id,
1516: planning_parameters_id,
1509:
1510: procedure update_planning_nodes is
1511: begin
1512: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_PNS';
1513: insert into csp_sup_dem_pns(
1514: inventory_item_id,
1515: organization_id,
1516: planning_parameters_id,
1517: level_id,