1 Package ghr_pdc_bus AUTHID CURRENT_USER as
2 /* $Header: ghpdcrhi.pkh 115.4 99/10/14 12:11:06 porting ship $ */
3 --
4 PROCEDURE CHK_GRADE_LEVEL(p_pd_classification_id IN
5 ghr_pd_classifications.pd_classification_id%TYPE,
6 p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
7 p_effective_date IN date,
8 p_object_version_number IN number);
9
10 PROCEDURE CHK_PAY_PLAN(p_pd_classification_id IN
11 ghr_pd_classifications.pd_classification_id%TYPE,
12 p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
13 p_effective_date IN date,
14 p_object_version_number IN number);
15
16 PROCEDURE CHK_OCCUPATIONAL_CODE(p_pd_classification_id IN
17 ghr_pd_classifications.pd_classification_id%TYPE,
18 p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19 p_effective_date IN date,
20 p_object_version_number IN number);
21
22 PROCEDURE CHK_CLASS_GRADE_BY(p_pd_classification_id IN
23 ghr_pd_classifications.pd_classification_id%TYPE,
24 p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
25 p_effective_date IN date,
26 p_object_version_number IN number);
27
28 PROCEDURE CHK_NON_UPDATEABLE_ARGS(p_rec IN ghr_pdc_shd.g_rec_type);
29
30
31
32
33 -- ----------------------------------------------------------------------------
34 -- |---------------------------< insert_validate >----------------------------|
35 -- ----------------------------------------------------------------------------
36 -- {Start Of Comments}
37 --
38 -- Description:
39 -- This procedure controls the execution of all insert business rules
40 -- validation.
41 --
42 -- Prerequisites:
43 -- This private procedure is called from ins procedure.
44 --
45 -- In Parameters:
46 -- A Pl/Sql record structre.
47 --
48 -- Post Success:
49 -- Processing continues.
50 --
51 -- Post Failure:
52 -- If a business rules fails the error will not be handled by this procedure
53 -- unless explicity coded.
54 --
55 -- Developer Implementation Notes:
56 -- For insert, your business rules should be executed from this procedure and
57 -- should ideally (unless really necessary) just be straight procedure or
58 -- function calls. Try and avoid using conditional branching logic.
59 --
60 -- Access Status:
61 -- Internal Row Handler Use Only.
62 --
63 -- {End Of Comments}
64 -- ----------------------------------------------------------------------------
65 Procedure insert_validate(p_rec in ghr_pdc_shd.g_rec_type);
66 --
67 -- ----------------------------------------------------------------------------
68 -- |---------------------------< update_validate >----------------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start Of Comments}
71 --
72 -- Description:
73 -- This procedure controls the execution of all update business rules
74 -- validation.
75 --
76 -- Prerequisites:
77 -- This private procedure is called from upd procedure.
78 --
79 -- In Parameters:
80 -- A Pl/Sql record structre.
81 --
82 -- Post Success:
83 -- Processing continues.
84 --
85 -- Post Failure:
86 -- If a business rules fails the error will not be handled by this procedure
87 -- unless explicity coded.
88 --
89 -- Developer Implementation Notes:
90 -- For update, your business rules should be executed from this procedure and
91 -- should ideally (unless really necessary) just be straight procedure or
92 -- function calls. Try and avoid using conditional branching logic.
93 --
94 -- Access Status:
95 -- Internal Row Handler Use Only.
96 --
97 -- {End Of Comments}
98 -- ----------------------------------------------------------------------------
99 Procedure update_validate(p_rec in ghr_pdc_shd.g_rec_type);
100 --
101 -- ----------------------------------------------------------------------------
102 -- |---------------------------< delete_validate >----------------------------|
103 -- ----------------------------------------------------------------------------
104 -- {Start Of Comments}
105 --
106 -- Description:
107 -- This procedure controls the execution of all delete business rules
108 -- validation.
109 --
110 -- Prerequisites:
111 -- This private procedure is called from del procedure.
112 --
113 -- In Parameters:
114 -- A Pl/Sql record structre.
115 --
116 -- Post Success:
117 -- Processing continues.
118 --
119 -- Post Failure:
120 -- If a business rules fails the error will not be handled by this procedure
121 -- unless explicity coded.
122 --
123 -- Developer Implementation Notes:
124 -- For delete, your business rules should be executed from this procedure and
125 -- should ideally (unless really necessary) just be straight procedure or
126 -- function calls. Try and avoid using conditional branching logic.
127 --
128 -- Access Status:
129 -- Internal Row Handler Use Only.
130 --
131 -- {End Of Comments}
132 -- ----------------------------------------------------------------------------
133 Procedure delete_validate(p_rec in ghr_pdc_shd.g_rec_type);
134 --
135 end ghr_pdc_bus;