APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS_S

Line 1143: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

1139: CREATED_BY,
1140: LAST_UPDATE_LOGIN
1141: ) VALUES
1142: (
1143: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
1144: p_x_effectivity_detail_tbl(i).object_version_number,
1145: p_mr_effectivity_id,
1146: p_x_effectivity_detail_tbl(i).exclude_flag,
1147: p_x_effectivity_detail_tbl(i).serial_number_from,

Line 1182: UPDATE AHL_MR_EFFECTIVITY_DTLS SET

1178:
1179: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'U' ) THEN
1180:
1181: -- Update the record
1182: UPDATE AHL_MR_EFFECTIVITY_DTLS SET
1183: object_version_number = object_version_number + 1,
1184: exclude_flag = p_x_effectivity_detail_tbl(i).exclude_flag,
1185: serial_number_from = p_x_effectivity_detail_tbl(i).serial_number_from,
1186: serial_number_to = p_x_effectivity_detail_tbl(i).serial_number_to,