APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_INTERVALS

Line 695: FROM AHL_MR_INTERVALS_APP_V

691: attribute13,
692: attribute14,
693: attribute15,
694: calc_duedate_rule_code --pdoki added for ADAT ER
695: FROM AHL_MR_INTERVALS_APP_V
696: WHERE mr_interval_id = c_mr_interval_id;
697:
698: BEGIN
699:

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

696: WHERE mr_interval_id = c_mr_interval_id;
697:
698: BEGIN
699:
700: -- Get the old record from AHL_MR_INTERVALS.
701: OPEN get_old_rec( p_x_interval_rec.mr_interval_id );
702:
703: FETCH get_old_rec INTO
704: l_old_interval_rec.counter_id,

Line 1245: FROM AHL_MR_INTERVALS_V

1241: CURSOR get_pm_pgm_dup_rec( c_mr_effectivity_id NUMBER )
1242: IS
1243: SELECT counter_id,
1244: counter_name
1245: FROM AHL_MR_INTERVALS_V
1246: WHERE mr_effectivity_id = c_mr_effectivity_id
1247: GROUP BY counter_id,
1248: counter_name
1249: HAVING count(*) > 1;

Line 1259: FROM AHL_MR_INTERVALS_V

1255: start_value,
1256: stop_value,
1257: start_date,
1258: stop_date
1259: FROM AHL_MR_INTERVALS_V
1260: WHERE mr_effectivity_id = c_mr_effectivity_id
1261: GROUP BY counter_id,
1262: counter_name,
1263: start_value,

Line 1275: FROM AHL_MR_INTERVALS_V

1271: SELECT counter_id,
1272: counter_name,
1273: start_date,
1274: stop_date
1275: FROM AHL_MR_INTERVALS_V
1276: WHERE mr_effectivity_id = c_mr_effectivity_id
1277: ORDER BY counter_id,
1278: start_date,
1279: stop_date;

Line 1288: FROM AHL_MR_INTERVALS_V

1284: counter_name,
1285: earliest_due_value,
1286: start_value,
1287: stop_value
1288: FROM AHL_MR_INTERVALS_V
1289: WHERE mr_effectivity_id = c_mr_effectivity_id
1290: ORDER BY counter_id,
1291: start_value,
1292: stop_value;

Line 1297: FROM AHL_MR_INTERVALS_V

1293:
1294: CURSOR check_unique_reset_value( c_mr_effectivity_id NUMBER )
1295: IS
1296: SELECT counter_name
1297: FROM AHL_MR_INTERVALS_V
1298: WHERE mr_effectivity_id = c_mr_effectivity_id
1299: AND reset_value IS NOT NULL
1300: GROUP BY counter_name
1301: HAVING count(*) > 1;

Line 2010: INSERT INTO AHL_MR_INTERVALS

2006: FOR i IN 1..p_x_interval_tbl.count LOOP
2007: IF ( p_x_interval_tbl(i).dml_operation = 'C' ) THEN
2008:
2009: -- Insert the record
2010: INSERT INTO AHL_MR_INTERVALS
2011: (
2012: MR_INTERVAL_ID,
2013: OBJECT_VERSION_NUMBER,
2014: MR_EFFECTIVITY_ID,

Line 2049: AHL_MR_INTERVALS_S.NEXTVAL,

2045: LAST_UPDATE_LOGIN,
2046: CALC_DUEDATE_RULE_CODE --pdoki added for ADAT ER
2047: ) VALUES
2048: (
2049: AHL_MR_INTERVALS_S.NEXTVAL,
2050: p_x_interval_tbl(i).object_version_number,
2051: p_x_threshold_rec.mr_effectivity_id,
2052: p_x_interval_tbl(i).counter_id,
2053: p_x_interval_tbl(i).interval_value,

Line 2092: UPDATE AHL_MR_INTERVALS SET

2088:
2089: ELSIF ( p_x_interval_tbl(i).dml_operation = 'U' ) THEN
2090:
2091: -- Update the record
2092: UPDATE AHL_MR_INTERVALS SET
2093: object_version_number = object_version_number + 1,
2094: counter_id = p_x_interval_tbl(i).counter_id,
2095: interval_value = p_x_interval_tbl(i).interval_value,
2096: earliest_due_value = p_x_interval_tbl(i).earliest_due_value,

Line 2141: DELETE AHL_MR_INTERVALS

2137:
2138: ELSIF ( p_x_interval_tbl(i).dml_operation = 'D' ) THEN
2139:
2140: -- Delete the record
2141: DELETE AHL_MR_INTERVALS
2142: WHERE mr_interval_id = p_x_interval_tbl(i).mr_interval_id
2143: AND object_version_number = p_x_interval_tbl(i).object_version_number;
2144:
2145: -- If the record does not exist, then, abort API.