APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_INTERVALS

Line 659: FROM AHL_MR_INTERVALS_APP_V

655: attribute12,
656: attribute13,
657: attribute14,
658: attribute15
659: FROM AHL_MR_INTERVALS_APP_V
660: WHERE mr_interval_id = c_mr_interval_id;
661:
662: BEGIN
663:

Line 664: -- Get the old record from AHL_MR_INTERVALS.

660: WHERE mr_interval_id = c_mr_interval_id;
661:
662: BEGIN
663:
664: -- Get the old record from AHL_MR_INTERVALS.
665: OPEN get_old_rec( p_x_interval_rec.mr_interval_id );
666:
667: FETCH get_old_rec INTO
668: l_old_interval_rec.counter_id,

Line 1201: FROM AHL_MR_INTERVALS_V

1197: CURSOR get_pm_pgm_dup_rec( c_mr_effectivity_id NUMBER )
1198: IS
1199: SELECT counter_id,
1200: counter_name
1201: FROM AHL_MR_INTERVALS_V
1202: WHERE mr_effectivity_id = c_mr_effectivity_id
1203: GROUP BY counter_id,
1204: counter_name
1205: HAVING count(*) > 1;

Line 1215: FROM AHL_MR_INTERVALS_V

1211: start_value,
1212: stop_value,
1213: start_date,
1214: stop_date
1215: FROM AHL_MR_INTERVALS_V
1216: WHERE mr_effectivity_id = c_mr_effectivity_id
1217: GROUP BY counter_id,
1218: counter_name,
1219: start_value,

Line 1231: FROM AHL_MR_INTERVALS_V

1227: SELECT counter_id,
1228: counter_name,
1229: start_date,
1230: stop_date
1231: FROM AHL_MR_INTERVALS_V
1232: WHERE mr_effectivity_id = c_mr_effectivity_id
1233: ORDER BY counter_id,
1234: start_date,
1235: stop_date;

Line 1244: FROM AHL_MR_INTERVALS_V

1240: counter_name,
1241: earliest_due_value,
1242: start_value,
1243: stop_value
1244: FROM AHL_MR_INTERVALS_V
1245: WHERE mr_effectivity_id = c_mr_effectivity_id
1246: ORDER BY counter_id,
1247: start_value,
1248: stop_value;

Line 1253: FROM AHL_MR_INTERVALS_V

1249:
1250: CURSOR check_unique_reset_value( c_mr_effectivity_id NUMBER )
1251: IS
1252: SELECT counter_name
1253: FROM AHL_MR_INTERVALS_V
1254: WHERE mr_effectivity_id = c_mr_effectivity_id
1255: AND reset_value IS NOT NULL
1256: GROUP BY counter_name
1257: HAVING count(*) > 1;

Line 1943: INSERT INTO AHL_MR_INTERVALS

1939: FOR i IN 1..p_x_interval_tbl.count LOOP
1940: IF ( p_x_interval_tbl(i).dml_operation = 'C' ) THEN
1941:
1942: -- Insert the record
1943: INSERT INTO AHL_MR_INTERVALS
1944: (
1945: MR_INTERVAL_ID,
1946: OBJECT_VERSION_NUMBER,
1947: MR_EFFECTIVITY_ID,

Line 1981: AHL_MR_INTERVALS_S.NEXTVAL,

1977: CREATED_BY,
1978: LAST_UPDATE_LOGIN
1979: ) VALUES
1980: (
1981: AHL_MR_INTERVALS_S.NEXTVAL,
1982: p_x_interval_tbl(i).object_version_number,
1983: p_x_threshold_rec.mr_effectivity_id,
1984: p_x_interval_tbl(i).counter_id,
1985: p_x_interval_tbl(i).interval_value,

Line 2023: UPDATE AHL_MR_INTERVALS SET

2019:
2020: ELSIF ( p_x_interval_tbl(i).dml_operation = 'U' ) THEN
2021:
2022: -- Update the record
2023: UPDATE AHL_MR_INTERVALS SET
2024: object_version_number = object_version_number + 1,
2025: counter_id = p_x_interval_tbl(i).counter_id,
2026: interval_value = p_x_interval_tbl(i).interval_value,
2027: earliest_due_value = p_x_interval_tbl(i).earliest_due_value,

Line 2071: DELETE AHL_MR_INTERVALS

2067:
2068: ELSIF ( p_x_interval_tbl(i).dml_operation = 'D' ) THEN
2069:
2070: -- Delete the record
2071: DELETE AHL_MR_INTERVALS
2072: WHERE mr_interval_id = p_x_interval_tbl(i).mr_interval_id
2073: AND object_version_number = p_x_interval_tbl(i).object_version_number;
2074:
2075: -- If the record does not exist, then, abort API.