1 PACKAGE PER_JOBS_PKG as
2 /* $Header: pejbd01t.pkh 120.0 2005/05/31 10:33:04 appldev noship $ */
3 --
4 PROCEDURE get_next_sequence(p_job_id IN OUT NOCOPY NUMBER);
5 --
6 PROCEDURE check_unique_name(p_job_id in number,
7 p_business_group_id in number,
8 p_name in varchar2);
9 --
10 PROCEDURE check_date_from(p_job_id in number,
11 p_date_from in date);
12 --
13 PROCEDURE get_job_flex_structure(p_structure_defining_column in out nocopy varchar2,
14 p_job_group_id in number);
15 --
16 PROCEDURE check_altered_end_date(p_business_group_id number,
17 p_job_id number,
18 p_end_of_time date,
19 p_date_to date,
20 p_early_date_to in out nocopy boolean,
21 p_early_date_from in out nocopy boolean);
22 --
23 PROCEDURE update_valid_grades(p_business_group_id number,
24 p_job_id number,
25 p_date_to date,
26 p_end_of_time date);
27 --
28 PROCEDURE delete_valid_grades(p_business_group_id number,
29 p_job_id number,
30 p_date_to date);
31 --
32 PROCEDURE check_delete_record(p_job_id number,
33 p_business_group_id number);
34 --
35
36 -- ----------------------------------------------------------------------------
37 -- |---------------------------< check_evaluation_dates >---------------------|
38 -- ----------------------------------------------------------------------------
39 -- {Start Of Comments}
40 --
41 -- Description:
42 -- This procedure will check for the valid evaluations exists outside
43 -- the effective period, when the user is end dating a job for a given
44 -- job id.
45 -- Prerequisites:
46 -- A valid job must be existing
47 --
48 -- In Parameters:
49 -- Name Reqd Type Description
50 -- p_jobid yes number Job id for the job to be
51 -- end dated
52 -- p_job_date_from yes date From date of the job
53 -- p_job_date_to date End date of the job
54 --
55 -- Post Success:
56 -- User will be stopped from end dating the job, if any evaluation is
57 -- existing outside the effective end date of the job,for the given job id.
58 -- and a suitable message will be shown to the user.
59 --
60 -- Post Failure:
61 -- None.
62 --
63 -- Access Status:
64 -- Internal Development Use Only.
65 --
66 -- {End Of Comments}
67 --
68 -- ----------------------------------------------------------------------------
69 procedure check_evaluation_dates(p_jobid in number,
70 p_job_date_from in date,
71 p_job_date_to in date);
72
73 --
74
75 END PER_JOBS_PKG;
[Home] [Help]