2277: CREATED_BY,
2278: LAST_UPDATE_LOGIN
2279: ) VALUES
2280: (
2281: AHL_MR_EFFECTIVITY_EXT_DTLS_S.NEXTVAL,
2282: p_x_effty_ext_detail_tbl(i).object_version_number,
2283: p_mr_effectivity_id,
2284: p_x_effty_ext_detail_tbl(i).exclude_flag,
2285: p_x_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE,
2315:
2316: ELSIF ( p_x_effty_ext_detail_tbl(i).dml_operation = 'U' ) THEN
2317:
2318: -- Update the record
2319: UPDATE AHL_MR_EFFECTIVITY_EXT_DTLS SET
2320: object_version_number = object_version_number + 1,
2321: exclude_flag = p_x_effty_ext_detail_tbl(i).exclude_flag,
2322: EFFECT_EXT_DTL_REC_TYPE = p_x_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE,
2323: OWNER_ID = p_x_effty_ext_detail_tbl(i).OWNER_ID,