APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DELETED_LEVEL_VALUES

Line 843: INSERT INTO msd_deleted_level_values(instance, level_id,

839: RETURNING level_pk, created_by_refresh_num
840: BULK COLLECT INTO a_level_pk, a_crn;
841:
842: FORALL j IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
843: INSERT INTO msd_deleted_level_values(instance, level_id,
844: sr_level_pk, level_pk,
845: created_by_refresh_num, last_refresh_num,
846: creation_date, created_by, last_update_date,
847: last_updated_by, last_update_login)

Line 1430: This procedure will clean up the MSD_DELETED_LEVEL_VALUES table,

1426:
1427:
1428:
1429: /*----------------------------------------------------------------
1430: This procedure will clean up the MSD_DELETED_LEVEL_VALUES table,
1431: MSD_DELETED_LEVEL_ASSOCIATIONS, MSD_DELETED_ITEM_LIST_PRICE table
1432:
1433: -----------------------------------------------------------------*/
1434:

Line 1447: DELETE FROM msd_deleted_level_values

1443: SELECT nvl(min(dp_build_refresh_num), 0) INTO l_least_refresh_num
1444: FROM msd_demand_plans;
1445:
1446: if l_least_refresh_num <> 0 then
1447: DELETE FROM msd_deleted_level_values
1448: WHERE LAST_REFRESH_NUM <= l_least_refresh_num;
1449: end if;
1450:
1451: /* DELETE FROM msd_deleted_level_associations