DBA Data[Home] [Help]

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITY_DTLS_S

Line 2074: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,

2070: CREATED_BY,
2071: LAST_UPDATE_LOGIN
2072: ) VALUES
2073: (
2074: AHL_MR_EFFECTIVITY_DTLS_S.NEXTVAL,
2075: p_x_effectivity_detail_tbl(i).object_version_number,
2076: p_mr_effectivity_id,
2077: p_x_effectivity_detail_tbl(i).exclude_flag,
2078: p_x_effectivity_detail_tbl(i).serial_number_from,

Line 2113: UPDATE AHL_MR_EFFECTIVITY_DTLS SET

2109:
2110: ELSIF ( p_x_effectivity_detail_tbl(i).dml_operation = 'U' ) THEN
2111:
2112: -- Update the record
2113: UPDATE AHL_MR_EFFECTIVITY_DTLS SET
2114: object_version_number = object_version_number + 1,
2115: exclude_flag = p_x_effectivity_detail_tbl(i).exclude_flag,
2116: serial_number_from = p_x_effectivity_detail_tbl(i).serial_number_from,
2117: serial_number_to = p_x_effectivity_detail_tbl(i).serial_number_to,