eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_EQUIPMENT_PKG dependencies on MTH_EQUIPMENT_DENORM_D

Line 53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);

49:
50: IF (v_error_code_1 IS NULL AND v_error_code_2 IS NULL ) THEN
51:
52: -- Call mth_run_log_pre_load
53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);
54: -- Moved to call to inside MTH_POPULATE_EQUIP_DENORM
55:
56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();

Line 60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);

56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();
58:
59: -- Call mth_run_log_post_load
60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);
61:
62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);
64: END IF;

Line 256: mth_equipment_denorm_d d,

252:
253: CURSOR c_equip_hierarchy IS
254: SELECT Count(*) record_count
255: FROM mth_equip_hierarchy h,
256: mth_equipment_denorm_d d,
257: (SELECT Min(from_date) from_date
258: FROM mth_run_log
259: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
260: WHERE h.creation_date > r.from_date

Line 259: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r

255: FROM mth_equip_hierarchy h,
256: mth_equipment_denorm_d d,
257: (SELECT Min(from_date) from_date
258: FROM mth_run_log
259: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
260: WHERE h.creation_date > r.from_date
261: AND h.level_num <= 10
262: AND d.level_num >= h.level_num
263: AND h.level_fk_key = Decode(h.level_num,2,d.level2_level_key,

Line 332: mth_equipment_denorm_d d,

328: 8,d.level8_effective_date,
329: 9,d.level9_effective_date,
330: 10,d.equipment_effective_date) child_effective_date
331: FROM mth_equip_hierarchy h,
332: mth_equipment_denorm_d d,
333: (SELECT Min(from_date) from_date
334: FROM mth_run_log
335: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
336: WHERE h.creation_date > r.from_date

Line 335: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r

331: FROM mth_equip_hierarchy h,
332: mth_equipment_denorm_d d,
333: (SELECT Min(from_date) from_date
334: FROM mth_run_log
335: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
336: WHERE h.creation_date > r.from_date
337: AND h.level_num <= 10
338: AND d.level_num >= h.level_num
339: AND h.level_fk_key = Decode(h.level_num,2,d.level2_level_key,

Line 461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */

457: MTH_RUN_LOG.TO_DATE
458: FROM
459: MTH_RUN_LOG
460: WHERE
461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */
462: WHERE equip_hierarchy.creation_date > p_from_date
463: AND equip_hierarchy.creation_date <= p_to_date
464: --ORDER BY HIERARCHY_ID, GROUP_ID, LEVEL_NUM ;
465: ORDER BY HIERARCHY_ID, EFFECTIVE_DATE, LEVEL_NUM, GROUP_ID ;

Line 477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

473: -- Initialize default parameters
474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:
480:
481: open c_equip_hierarchy(v_log_from_date,v_log_to_date);

Line 478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:
480:
481: open c_equip_hierarchy(v_log_from_date,v_log_to_date);
482: loop

Line 553: FROM MTH_EQUIPMENT_DENORM_D

549: if the current row's effective date is between "effective date - non null expiration date" range of one of the parent rows*/
550:
551: CURSOR c_equip_denorm IS
552: SELECT *
553: FROM MTH_EQUIPMENT_DENORM_D
554: WHERE level_num = p_level_num - 1
555: and level1_hierarchy_key = p_hierarchy_id
556: and ((p_level_num =2 and level1_level_key = p_parent_fk_key and level1_hierarchy_key = p_hierarchy_id)
557:

Line 591: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE ;

587:
588: );
589:
590: r_equip_denorm c_equip_denorm%ROWTYPE ;
591: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE ;
592:
593:
594: BEGIN
595:

Line 881: INSERT INTO mth_equipment_denorm_d(dimension_key,

877: v_row.CREATED_BY := v_unassigned_val;
878: v_row.LAST_UPDATE_LOGIN := v_unassigned_val;
879: v_row.LAST_UPDATED_BY := v_unassigned_val;
880:
881: INSERT INTO mth_equipment_denorm_d(dimension_key,
882: level1_hierarchy_key,
883: level1_id,
884: level1_level_key,
885: level1_level_name,

Line 1084: r_move_equip_denorm MTH_EQUIPMENT_DENORM_D%ROWTYPE;

1080:
1081: v_log_date DATE;
1082: v_unassigned_val VARCHAR2(30);
1083: c_move_equip_denorm SYS_REFCURSOR;
1084: r_move_equip_denorm MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1085: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1086:
1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);

Line 1085: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE;

1081: v_log_date DATE;
1082: v_unassigned_val VARCHAR2(30);
1083: c_move_equip_denorm SYS_REFCURSOR;
1084: r_move_equip_denorm MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1085: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1086:
1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);

Line 1106: FROM MTH_EQUIPMENT_DENORM_D

1102:
1103: IF(p_level_num =2)THEN
1104: OPEN c_move_equip_denorm FOR
1105: SELECT *
1106: FROM MTH_EQUIPMENT_DENORM_D
1107: WHERE
1108: LEVEL_NUM >= p_level_num AND
1109: LEVEL2_HIERARCHY_KEY = p_hierarchy_id AND
1110: LEVEL2_LEVEL_KEY = p_level_fk_key AND

Line 1117: FROM MTH_EQUIPMENT_DENORM_D

1113:
1114: ELSIF(p_level_num =3)THEN
1115: OPEN c_move_equip_denorm FOR
1116: SELECT *
1117: FROM MTH_EQUIPMENT_DENORM_D
1118: WHERE
1119: LEVEL_NUM >= p_level_num AND
1120: LEVEL3_HIERARCHY_KEY = p_hierarchy_id AND
1121: LEVEL3_LEVEL_KEY = p_level_fk_key AND

Line 1128: FROM MTH_EQUIPMENT_DENORM_D

1124:
1125: ELSIF(p_level_num =4)THEN
1126: OPEN c_move_equip_denorm FOR
1127: SELECT *
1128: FROM MTH_EQUIPMENT_DENORM_D
1129: WHERE
1130: LEVEL_NUM >= p_level_num AND
1131: LEVEL4_HIERARCHY_KEY = p_hierarchy_id AND
1132: LEVEL4_LEVEL_KEY = p_level_fk_key AND

Line 1139: FROM MTH_EQUIPMENT_DENORM_D

1135:
1136: ELSIF(p_level_num =5)THEN
1137: OPEN c_move_equip_denorm FOR
1138: SELECT *
1139: FROM MTH_EQUIPMENT_DENORM_D
1140: WHERE
1141: LEVEL_NUM >= p_level_num AND
1142: LEVEL5_HIERARCHY_KEY = p_hierarchy_id AND
1143: LEVEL5_LEVEL_KEY = p_level_fk_key AND

Line 1150: FROM MTH_EQUIPMENT_DENORM_D

1146:
1147: ELSIF(p_level_num =6)THEN
1148: OPEN c_move_equip_denorm FOR
1149: SELECT *
1150: FROM MTH_EQUIPMENT_DENORM_D
1151: WHERE
1152: LEVEL_NUM >= p_level_num AND
1153: LEVEL6_HIERARCHY_KEY = p_hierarchy_id AND
1154: LEVEL6_LEVEL_KEY = p_level_fk_key AND

Line 1161: FROM MTH_EQUIPMENT_DENORM_D

1157:
1158: ELSIF(p_level_num =7)THEN
1159: OPEN c_move_equip_denorm FOR
1160: SELECT *
1161: FROM MTH_EQUIPMENT_DENORM_D
1162: WHERE
1163: LEVEL_NUM >= p_level_num AND
1164: LEVEL7_HIERARCHY_KEY = p_hierarchy_id AND
1165: LEVEL7_LEVEL_KEY = p_level_fk_key AND

Line 1172: FROM MTH_EQUIPMENT_DENORM_D

1168:
1169: ELSIF(p_level_num =8)THEN
1170: OPEN c_move_equip_denorm FOR
1171: SELECT *
1172: FROM MTH_EQUIPMENT_DENORM_D
1173: WHERE
1174: LEVEL_NUM >= p_level_num AND
1175: LEVEL8_HIERARCHY_KEY = p_hierarchy_id AND
1176: LEVEL8_LEVEL_KEY = p_level_fk_key AND

Line 1184: FROM MTH_EQUIPMENT_DENORM_D

1180:
1181: ELSIF(p_level_num =9)THEN
1182: OPEN c_move_equip_denorm FOR
1183: SELECT *
1184: FROM MTH_EQUIPMENT_DENORM_D
1185: WHERE
1186: LEVEL_NUM >= p_level_num AND
1187: LEVEL9_HIERARCHY_KEY = p_hierarchy_id AND
1188: LEVEL9_LEVEL_KEY = p_level_fk_key AND

Line 1195: FROM MTH_EQUIPMENT_DENORM_D

1191:
1192: ELSIF(p_level_num =10)THEN
1193: OPEN c_move_equip_denorm FOR
1194: SELECT *
1195: FROM MTH_EQUIPMENT_DENORM_D
1196: WHERE
1197: LEVEL_NUM >= p_level_num AND
1198: EQUIPMENT_HIERARCHY_KEY = p_hierarchy_id AND
1199: EQUIPMENT_FK_KEY = p_level_fk_key AND

Line 1309: r_expire_denorm mth_equipment_denorm_d%ROWTYPE;

1305: ) IS
1306:
1307: v_log_date DATE;
1308: v_unassigned_val VARCHAR2(30);
1309: r_expire_denorm mth_equipment_denorm_d%ROWTYPE;
1310: v_expiration_date DATE;
1311:
1312: BEGIN
1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);

Line 1327: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1323: /*For the levels 2-10, set the expiration date based on the dimension key.Also pick the parent row information for filling in the
1324: expiration dates for the rest of the parent levels */
1325:
1326: IF(p_level_num = 2)THEN
1327: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1328: (SELECT level1_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1329:
1330: UPDATE mth_equipment_denorm_d
1331: SET level2_expiration_date = v_expiration_date,

Line 1328: (SELECT level1_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1324: expiration dates for the rest of the parent levels */
1325:
1326: IF(p_level_num = 2)THEN
1327: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1328: (SELECT level1_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1329:
1330: UPDATE mth_equipment_denorm_d
1331: SET level2_expiration_date = v_expiration_date,
1332: last_update_date = v_log_date

Line 1330: UPDATE mth_equipment_denorm_d

1326: IF(p_level_num = 2)THEN
1327: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1328: (SELECT level1_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1329:
1330: UPDATE mth_equipment_denorm_d
1331: SET level2_expiration_date = v_expiration_date,
1332: last_update_date = v_log_date
1333: WHERE dimension_key = p_dimension_key
1334: AND level_num = 2;

Line 1338: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1334: AND level_num = 2;
1335:
1336:
1337: ELSIF(p_level_num = 3)THEN
1338: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1339: (SELECT level2_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1340:
1341: UPDATE mth_equipment_denorm_d
1342: SET level3_expiration_date = v_expiration_date,

Line 1339: (SELECT level2_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1335:
1336:
1337: ELSIF(p_level_num = 3)THEN
1338: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1339: (SELECT level2_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1340:
1341: UPDATE mth_equipment_denorm_d
1342: SET level3_expiration_date = v_expiration_date,
1343: level2_expiration_date = r_expire_denorm.level2_expiration_date,

Line 1341: UPDATE mth_equipment_denorm_d

1337: ELSIF(p_level_num = 3)THEN
1338: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1339: (SELECT level2_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1340:
1341: UPDATE mth_equipment_denorm_d
1342: SET level3_expiration_date = v_expiration_date,
1343: level2_expiration_date = r_expire_denorm.level2_expiration_date,
1344: last_update_date = v_log_date
1345: WHERE dimension_key = p_dimension_key

Line 1351: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1347:
1348:
1349:
1350: ELSIF(p_level_num = 4)THEN
1351: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1352: (SELECT level3_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1353:
1354: UPDATE mth_equipment_denorm_d
1355: SET level4_expiration_date = v_expiration_date,

Line 1352: (SELECT level3_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1348:
1349:
1350: ELSIF(p_level_num = 4)THEN
1351: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1352: (SELECT level3_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1353:
1354: UPDATE mth_equipment_denorm_d
1355: SET level4_expiration_date = v_expiration_date,
1356: level3_expiration_date = r_expire_denorm.level3_expiration_date,

Line 1354: UPDATE mth_equipment_denorm_d

1350: ELSIF(p_level_num = 4)THEN
1351: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1352: (SELECT level3_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1353:
1354: UPDATE mth_equipment_denorm_d
1355: SET level4_expiration_date = v_expiration_date,
1356: level3_expiration_date = r_expire_denorm.level3_expiration_date,
1357: level2_expiration_date = r_expire_denorm.level2_expiration_date,
1358: last_update_date = v_log_date

Line 1364: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1360: AND level_num = 4;
1361:
1362:
1363: ELSIF(p_level_num = 5)THEN
1364: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1365: (SELECT level4_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1366:
1367: UPDATE mth_equipment_denorm_d
1368: SET level5_expiration_date = v_expiration_date,

Line 1365: (SELECT level4_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1361:
1362:
1363: ELSIF(p_level_num = 5)THEN
1364: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1365: (SELECT level4_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1366:
1367: UPDATE mth_equipment_denorm_d
1368: SET level5_expiration_date = v_expiration_date,
1369: level4_expiration_date = r_expire_denorm.level4_expiration_date,

Line 1367: UPDATE mth_equipment_denorm_d

1363: ELSIF(p_level_num = 5)THEN
1364: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1365: (SELECT level4_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1366:
1367: UPDATE mth_equipment_denorm_d
1368: SET level5_expiration_date = v_expiration_date,
1369: level4_expiration_date = r_expire_denorm.level4_expiration_date,
1370: level3_expiration_date = r_expire_denorm.level3_expiration_date,
1371: level2_expiration_date = r_expire_denorm.level2_expiration_date,

Line 1378: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1374: AND level_num = 5;
1375:
1376:
1377: ELSIF(p_level_num = 6)THEN
1378: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1379: (SELECT level5_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1380:
1381: UPDATE mth_equipment_denorm_d
1382: SET level6_expiration_date = v_expiration_date,

Line 1379: (SELECT level5_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1375:
1376:
1377: ELSIF(p_level_num = 6)THEN
1378: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1379: (SELECT level5_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1380:
1381: UPDATE mth_equipment_denorm_d
1382: SET level6_expiration_date = v_expiration_date,
1383: level5_expiration_date = r_expire_denorm.level5_expiration_date,

Line 1381: UPDATE mth_equipment_denorm_d

1377: ELSIF(p_level_num = 6)THEN
1378: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1379: (SELECT level5_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1380:
1381: UPDATE mth_equipment_denorm_d
1382: SET level6_expiration_date = v_expiration_date,
1383: level5_expiration_date = r_expire_denorm.level5_expiration_date,
1384: level4_expiration_date = r_expire_denorm.level4_expiration_date,
1385: level3_expiration_date = r_expire_denorm.level3_expiration_date,

Line 1393: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1389: AND level_num = 6;
1390:
1391:
1392: ELSIF(p_level_num = 7)THEN
1393: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1394: (SELECT level6_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1395:
1396: UPDATE mth_equipment_denorm_d
1397: SET level7_expiration_date = v_expiration_date,

Line 1394: (SELECT level6_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1390:
1391:
1392: ELSIF(p_level_num = 7)THEN
1393: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1394: (SELECT level6_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1395:
1396: UPDATE mth_equipment_denorm_d
1397: SET level7_expiration_date = v_expiration_date,
1398: level6_expiration_date = r_expire_denorm.level6_expiration_date,

Line 1396: UPDATE mth_equipment_denorm_d

1392: ELSIF(p_level_num = 7)THEN
1393: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1394: (SELECT level6_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1395:
1396: UPDATE mth_equipment_denorm_d
1397: SET level7_expiration_date = v_expiration_date,
1398: level6_expiration_date = r_expire_denorm.level6_expiration_date,
1399: level5_expiration_date = r_expire_denorm.level5_expiration_date,
1400: level4_expiration_date = r_expire_denorm.level4_expiration_date,

Line 1409: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1405: AND level_num = 7;
1406:
1407:
1408: ELSIF(p_level_num = 8)THEN
1409: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1410: (SELECT level7_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1411:
1412: UPDATE mth_equipment_denorm_d
1413: SET level8_expiration_date = v_expiration_date,

Line 1410: (SELECT level7_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1406:
1407:
1408: ELSIF(p_level_num = 8)THEN
1409: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1410: (SELECT level7_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1411:
1412: UPDATE mth_equipment_denorm_d
1413: SET level8_expiration_date = v_expiration_date,
1414: level7_expiration_date = r_expire_denorm.level7_expiration_date,

Line 1412: UPDATE mth_equipment_denorm_d

1408: ELSIF(p_level_num = 8)THEN
1409: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1410: (SELECT level7_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1411:
1412: UPDATE mth_equipment_denorm_d
1413: SET level8_expiration_date = v_expiration_date,
1414: level7_expiration_date = r_expire_denorm.level7_expiration_date,
1415: level6_expiration_date = r_expire_denorm.level6_expiration_date,
1416: level5_expiration_date = r_expire_denorm.level5_expiration_date,

Line 1425: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1421: WHERE dimension_key = p_dimension_key
1422: AND level_num = 8;
1423:
1424: ELSIF(p_level_num = 9)THEN
1425: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1426: (SELECT level8_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1427:
1428: UPDATE mth_equipment_denorm_d
1429: SET level9_expiration_date = v_expiration_date,

Line 1426: (SELECT level8_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1422: AND level_num = 8;
1423:
1424: ELSIF(p_level_num = 9)THEN
1425: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1426: (SELECT level8_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1427:
1428: UPDATE mth_equipment_denorm_d
1429: SET level9_expiration_date = v_expiration_date,
1430: level8_expiration_date = r_expire_denorm.level8_expiration_date,

Line 1428: UPDATE mth_equipment_denorm_d

1424: ELSIF(p_level_num = 9)THEN
1425: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1426: (SELECT level8_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1427:
1428: UPDATE mth_equipment_denorm_d
1429: SET level9_expiration_date = v_expiration_date,
1430: level8_expiration_date = r_expire_denorm.level8_expiration_date,
1431: level7_expiration_date = r_expire_denorm.level7_expiration_date,
1432: level6_expiration_date = r_expire_denorm.level6_expiration_date,

Line 1442: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN

1438: WHERE dimension_key = p_dimension_key
1439: AND level_num = 9;
1440:
1441: ELSIF(p_level_num = 10)THEN
1442: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1443: (SELECT level9_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1444:
1445: UPDATE mth_equipment_denorm_d
1446: SET equipment_expiration_date = v_expiration_date,

Line 1443: (SELECT level9_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);

1439: AND level_num = 9;
1440:
1441: ELSIF(p_level_num = 10)THEN
1442: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1443: (SELECT level9_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1444:
1445: UPDATE mth_equipment_denorm_d
1446: SET equipment_expiration_date = v_expiration_date,
1447: level9_expiration_date = r_expire_denorm.level9_expiration_date,

Line 1445: UPDATE mth_equipment_denorm_d

1441: ELSIF(p_level_num = 10)THEN
1442: SELECT * INTO r_expire_denorm FROM mth_equipment_denorm_d WHERE dimension_key IN
1443: (SELECT level9_id FROM mth_equipment_denorm_d WHERE dimension_key = p_dimension_key AND level_num = p_level_num);
1444:
1445: UPDATE mth_equipment_denorm_d
1446: SET equipment_expiration_date = v_expiration_date,
1447: level9_expiration_date = r_expire_denorm.level9_expiration_date,
1448: level8_expiration_date = r_expire_denorm.level8_expiration_date,
1449: level7_expiration_date = r_expire_denorm.level7_expiration_date,