APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_DELETED_LEVEL_VALUES

Line 811: INSERT INTO msd_deleted_level_values(instance, level_id,

807: RETURNING level_pk, created_by_refresh_num
808: BULK COLLECT INTO a_level_pk, a_crn;
809:
810: FORALL j IN a_sr_level_pk.FIRST..a_sr_level_pk.LAST
811: INSERT INTO msd_deleted_level_values(instance, level_id,
812: sr_level_pk, level_pk,
813: created_by_refresh_num, last_refresh_num,
814: creation_date, created_by, last_update_date,
815: last_updated_by, last_update_login)

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

1394:
1395:
1396:
1397: /*----------------------------------------------------------------
1398: This procedure will clean up the MSD_DELETED_LEVEL_VALUES table,
1399: MSD_DELETED_LEVEL_ASSOCIATIONS, MSD_DELETED_ITEM_LIST_PRICE table
1400:
1401: -----------------------------------------------------------------*/
1402:

Line 1415: DELETE FROM msd_deleted_level_values

1411: SELECT nvl(min(dp_build_refresh_num), 0) INTO l_least_refresh_num
1412: FROM msd_demand_plans;
1413:
1414: if l_least_refresh_num <> 0 then
1415: DELETE FROM msd_deleted_level_values
1416: WHERE LAST_REFRESH_NUM <= l_least_refresh_num;
1417: end if;
1418:
1419: /* DELETE FROM msd_deleted_level_associations