[Home] [Help]
435: -- |---------------------------< chk_attempt_id >-----------------------------|
436: -- ----------------------------------------------------------------------------
437: --
438: -- Description:
439: -- Verifies that the attempt id exists in OTA_ATTEMPTS and is being provided
440: -- for applicant assignment type only.
441: --
442: -- Prerequisites:
443: -- Must be called as the first step in insert_validate.
445: -- In Arguments:
446: -- p_attempt_id
447: --
448: -- Post Success:
449: -- If attempt_id exists in OTA_ATTEMPTS and the assignment is of type
450: -- application assignment, then continue.
451: --
452: -- Post Failure:
453: -- If the attempt_id does not exists in OTA_ATTEMPTS or if the assignment
449: -- If attempt_id exists in OTA_ATTEMPTS and the assignment is of type
450: -- application assignment, then continue.
451: --
452: -- Post Failure:
453: -- If the attempt_id does not exists in OTA_ATTEMPTS or if the assignment
454: -- type is not application assignment, then throw an error indicating
455: -- the same.
456: --
457: -- Access Status:
481: p_effective_date between effective_start_date and effective_end_date;
482: --
483: cursor attempt_exists(p_attempt_id number) is
484: select null
485: from ota_attempts
486: where attempt_id = p_attempt_id;
487: --
488: Begin
489: --
504: -- Check if attempt_id is not null
505: --
506: if p_attempt_id IS NOT NULL then
507: --
508: -- attempt_id must exist in ota_attempts
509: --
510: open attempt_exists(p_attempt_id);
511: fetch attempt_exists into l_dummy;
512: --