14: open c1;
15: fetch c1 into p_job_requirement_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
15: fetch c1 into p_job_requirement_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;
24: --
21: end if;
22: close c1;
23: end if;
24: --
25: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.get_next_sequence', 1);
26: --
27: end get_next_sequence;
28: --
29: procedure check_unique_requirement(p_job_id in number,
50: v_not_unique := csr_requirement%FOUND;
51: close csr_requirement;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);
51: close csr_requirement;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);
59: --
54: hr_utility.set_message(801,'HR_6644_JOB_REQ_DUP');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);
59: --
60: end check_unique_requirement;
61: --
62: END PER_JOB_REQUIREMENTS_PKG;