DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_EQUIPMENT_DENORM_D

Line 1204: * in the mth_equipment_denorm_d table *

1200:
1201: /* *****************************************************************************
1202: * Procedure :PUT_EQUIP_DENORM_LEVEL_NUM *
1203: * Description :This procedure is used to insert the level_num column *
1204: * in the mth_equipment_denorm_d table *
1205: * File Name :MTHUTILB.PLS *
1206: * Visibility :Private *
1207: * Modification log : *
1208: * Author Date Change *

Line 1215: UPDATE MTH_EQUIPMENT_DENORM_D SET LEVEL_NUM = (

1211:
1212: PROCEDURE PUT_EQUIP_DENORM_LEVEL_NUM
1213: IS
1214: BEGIN
1215: UPDATE MTH_EQUIPMENT_DENORM_D SET LEVEL_NUM = (
1216: CASE WHEN EQUIPMENT_FK_KEY IS NOT NULL THEN 10
1217: ELSE CASE WHEN LEVEL9_LEVEL_KEY IS NOT NULL THEN 9
1218: ELSE CASE WHEN LEVEL8_LEVEL_KEY IS NOT NULL THEN 8
1219: ELSE CASE WHEN LEVEL7_LEVEL_KEY IS NOT NULL THEN 7