APPS.MSD_DEM_SOP dependencies on MSD_DEM_COLLECT_LEVEL_TYPES

Line 1530: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 2, p_plan_id);

1526: fetch get_instance_id into l_instance_id;
1527: close get_instance_id;
1528:
1529:
1530: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 2, p_plan_id);
1531:
1532: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 1, p_plan_id);
1533:
1534:

Line 1532: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 1, p_plan_id);

1528:
1529:
1530: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 2, p_plan_id);
1531:
1532: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 1, p_plan_id);
1533:
1534:
1535: end load_item_locs;
1536:

Line 2324: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 1, p_plan_id);

2320: execute immediate l_stmt;
2321:
2322: -- load location staging table
2323: log_debug('Info: msd_dem_sop.load_plan_data_wo - load location staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
2324: msd_dem_collect_level_types.collect_levels(errbuf, retcode, l_instance_id, 1, p_plan_id);
2325: IF (retcode = -1) THEN
2326: errbuf := 'Error in collect_level_types (location) - ' || errbuf;
2327: log_message ('Error(14): msd_dem_sop.load_plan_data_wo - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS') || ' - ' || errbuf);
2328: RETURN;