548: set effective_end_date = p_effective_start_date -1
549: where rowid = l_rowid;
550: --
551: if sql%rowcount <> 1 then
552: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
553: fnd_message.set_token('PROCEDURE','update_old_person');
554: fnd_message.set_token('STEP','2');
555: app_exception.raise_exception;
556: end if;
549: where rowid = l_rowid;
550: --
551: if sql%rowcount <> 1 then
552: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
553: fnd_message.set_token('PROCEDURE','update_old_person');
554: fnd_message.set_token('STEP','2');
555: app_exception.raise_exception;
556: end if;
557: end;
550: --
551: if sql%rowcount <> 1 then
552: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
553: fnd_message.set_token('PROCEDURE','update_old_person');
554: fnd_message.set_token('STEP','2');
555: app_exception.raise_exception;
556: end if;
557: end;
558: end update_old_person_row;