APPS.PER_ECO_BUS dependencies on PER_ELECTIONS

Line 21: -- - Validates that a election id exists in table per_elections.

17: -- |--------------------------< chk_election_id >---------------------------|
18: -- ---------------------------------------------------------------------------
19: --
20: -- Description:
21: -- - Validates that a election id exists in table per_elections.
22: -- - Checks that the election_id is not null
23: --
24: -- Pre-conditions:
25: -- None.

Line 32: -- If a row does exist in per_elections for the given election id then

28: -- p_election_id
29: --
30: --
31: -- Post Success:
32: -- If a row does exist in per_elections for the given election id then
33: -- processing continues.
34: --
35: -- Post Failure:
36: -- If a row does not exist in per_elections for the given election id

Line 36: -- If a row does not exist in per_elections for the given election id

32: -- If a row does exist in per_elections for the given election id then
33: -- processing continues.
34: --
35: -- Post Failure:
36: -- If a row does not exist in per_elections for the given election id
37: -- then an application error will be raised and processing is terminated.
38: --
39: -- Access Status:
40: -- Internal Table Handler Use Only.

Line 58: from per_elections pe

54: l_election_id number;
55: --
56: cursor csr_valid_election_id is
57: select election_id
58: from per_elections pe
59: where pe.election_id = p_election_id;
60:
61: begin
62: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 88: -- valid election_id on per_elections

84: then
85: hr_utility.set_location(l_proc, 30);
86: --
87: -- Check that the Election ID is linked to a
88: -- valid election_id on per_elections
89: --
90: open csr_valid_election_id;
91: fetch csr_valid_election_id into l_election_id;
92: if csr_valid_election_id%notfound then