DBA Data[Home] [Help]

APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_MR_INTERVALS_S

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,