APPS.PER_JOB_REQUIREMENTS_PKG dependencies on PER_JOB_REQUIREMENTS

Line 1: PACKAGE BODY PER_JOB_REQUIREMENTS_PKG as

1: PACKAGE BODY PER_JOB_REQUIREMENTS_PKG as
2: /* $Header: pejbr01t.pkb 115.1 99/07/18 13:55:06 porting ship $ */
3: --
4: procedure get_next_sequence(p_job_requirement_id in out number) is
5: --

Line 6: cursor c1 is select per_job_requirements_s.nextval

2: /* $Header: pejbr01t.pkb 115.1 99/07/18 13:55:06 porting ship $ */
3: --
4: procedure get_next_sequence(p_job_requirement_id in out number) is
5: --
6: cursor c1 is select per_job_requirements_s.nextval
7: from sys.dual;
8: --
9: begin
10: --

Line 25: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.get_next_sequence', 1);

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,

Line 34: from per_job_requirements pjr

30: p_analysis_criteria_id in number,
31: p_rowid in varchar2) is
32: --
33: cursor csr_requirement is select null
34: from per_job_requirements pjr
35: where ((p_rowid is not null and
36: rowidtochar(rowid) <> p_rowid )
37: or p_rowid is null)
38: and pjr.job_id = p_job_id

Line 58: hr_utility.set_location('PER_JOB_REQUIREMENTS_PKG.check_unique_requirement', 1);

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;

Line 62: END PER_JOB_REQUIREMENTS_PKG;

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;