[Home] [Help]
370: -- |---------------------------< chk_election_id >----------------------------|
371: -- ---------------------------------------------------------------------------
372: --
373: -- Description:
374: -- - Validates that a election id exists in table PER_ELECTIONS
375: --
376: -- Pre-conditions:
377: -- None.
378: --
379: -- In Arguments:
380: -- p_election_id
381: --
382: -- Post Success:
383: -- If a row does exist in PER_ELECTIONS for the given election id then
384: -- processing continues.
385: --
386: -- Post Failure:
387: -- If a row does not exist in PER_ELECTIONS for the given election id then
383: -- If a row does exist in PER_ELECTIONS for the given election id then
384: -- processing continues.
385: --
386: -- Post Failure:
387: -- If a row does not exist in PER_ELECTIONS for the given election id then
388: -- an application error will be raised and processing is terminated.
389: --
390: -- Access Status:
391: -- Internal Table Handler Use Only.
402: l_election_id number;
403: --
404: cursor csr_valid_eid is
405: select election_id
406: from per_elections
407: where election_id = p_election_id;
408: --
409: begin
410: hr_utility.set_location('Entering:'|| l_proc, 10);
417: ,p_argument_value => p_election_id
418: );
419: hr_utility.set_location(l_proc, 20);
420: --
421: -- Check that the Election ID is exists in PER_ELECTIONS
422: --
423: open csr_valid_eid;
424: fetch csr_valid_eid into l_election_id;
425: if csr_valid_eid%notfound then