1 Package ghr_pdi_bus as
2 /* $Header: ghpdirhi.pkh 120.0 2005/05/29 03:28:37 appldev noship $ */
3
4 --
5 -----------------------------<chk_date_to>-----------------------------
6 --
7 Procedure chk_date_to(p_position_description_id IN
8 ghr_position_descriptions.position_description_id%TYPE,
9 p_date_from IN DATE,
10 p_date_to IN DATE);
11
12 --
13 -----------------------------<chk_flsa>----------------------------------
14 --
15 Procedure chk_flsa(p_position_description_id IN
16 ghr_position_descriptions.position_description_id%TYPE,
17 p_flsa IN ghr_position_descriptions.flsa%TYPE,
18 p_effective_date IN DATE,
19 p_object_version_number IN number);
20 --
21 -----------------------------<chk_category>----------------------------------
22 --
23 Procedure chk_category(p_position_description_id IN
24 ghr_position_descriptions.position_description_id%TYPE,
25 p_category IN ghr_position_descriptions.category%TYPE,
26 p_effective_date IN DATE,
27 p_object_version_number IN number);
28 --
29 -----------------------------<chk_financial_statement>-------------------
30 --
31
32 Procedure chk_financial_statement(p_position_description_id IN
33 ghr_position_descriptions.position_description_id%TYPE,
34 p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,
35 p_effective_date IN date,
36 p_object_version_number IN number);
37
38
39
40 --
41 -------------------------------< chk_subject_to_ia_action>---------------------
42 --
43
44 Procedure chk_subject_to_ia_action (p_position_description_id IN
45 ghr_position_descriptions.position_description_id%TYPE,
46 p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,
47 p_effective_date IN date,
48 p_object_version_number IN number);
49
50 --
51 ---------------------------------<chk_position_status>---------------------------
52 --
53
54 Procedure chk_position_status (p_position_description_id IN
55 ghr_position_descriptions.position_description_id%TYPE,
56 p_position_status IN ghr_position_descriptions.position_status%TYPE,
57 p_effective_date IN date,
58 p_object_version_number IN number);
59
60 --
61 -----------------------------------<chk_position_is>---------------------------------
62 --
63
64 Procedure chk_position_is (p_position_description_id IN
65 ghr_position_descriptions.position_description_id%TYPE,
66 p_position_is IN ghr_position_descriptions.position_is%TYPE,
67 p_effective_date IN date,
68 p_object_version_number IN number);
69
70 --
71 ----------------------------------<chk_position_sensitivity>---------------------------
72 --
73
74 Procedure chk_position_sensitivity(p_position_description_id IN
75 ghr_position_descriptions.position_description_id%TYPE,
76 p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,
77 p_effective_date IN date,
78 p_object_version_number IN number);
79
80 --
81 -----------------------------------<chk_competitive_level>----------------------------
82 --
83
84 Procedure chk_competitive_level(p_position_description_id IN
85 ghr_position_descriptions.position_description_id%TYPE,
86 p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,
87 p_effective_date IN date,
88 p_object_version_number IN number);
89
90 --
91 ------------------------------------<chk_career_ladder>--------------------------------
92 --
93
94 Procedure chk_career_ladder(p_position_description_id IN
95 ghr_position_descriptions.position_description_id%TYPE,
96 p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,
97 p_effective_date IN date,
98 p_object_version_number IN number);
99
100 --
101 ------------------------------------<chk_routing_group_id>---------------------------------
102 --
103
104 Procedure chk_routing_group_id(p_position_description_id IN
105 ghr_position_descriptions.position_description_id%TYPE,
106 p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,
107 p_effective_date IN date,
108 p_object_version_number IN number);
109
110 --
111 -------------------------------------<chk_non_updateable_args>-------------------------------
112 --
113
114
115 Procedure chk_non_updateable_args(p_rec IN ghr_pdi_shd.g_rec_type);
116
117
118 --
119 -- ----------------------------------------------------------------------------
120 -- |---------------------------< insert_validate >----------------------------|
121 -- ----------------------------------------------------------------------------
122 -- {Start Of Comments}
123 --
124 -- Description:
125 -- This procedure controls the execution of all insert business rules
126 -- validation.
127 --
128 -- Prerequisites:
129 -- This private procedure is called from ins procedure.
130 --
131 -- In Parameters:
132 -- A Pl/Sql record structre.
133 --
134 -- Post Success:
135 -- Processing continues.
136 --
137 -- Post Failure:
138 -- If a business rules fails the error will not be handled by this procedure
139 -- unless explicity coded.
140 --
141 -- Developer Implementation Notes:
142 -- For insert, your business rules should be executed from this procedure and
143 -- should ideally (unless really necessary) just be straight procedure or
144 -- function calls. Try and avoid using conditional branching logic.
145 --
146 -- Access Status:
147 -- Internal Row Handler Use Only.
148 --
149 -- {End Of Comments}
150 -- ----------------------------------------------------------------------------
151 Procedure insert_validate(p_rec in ghr_pdi_shd.g_rec_type);
152 --
153 -- ----------------------------------------------------------------------------
154 -- |---------------------------< update_validate >----------------------------|
155 -- ----------------------------------------------------------------------------
156 -- {Start Of Comments}
157 --
158 -- Description:
159 -- This procedure controls the execution of all update business rules
160 -- validation.
161 --
162 -- Prerequisites:
163 -- This private procedure is called from upd procedure.
164 --
165 -- In Parameters:
166 -- A Pl/Sql record structre.
167 --
168 -- Post Success:
169 -- Processing continues.
170 --
171 -- Post Failure:
172 -- If a business rules fails the error will not be handled by this procedure
173 -- unless explicity coded.
174 --
175 -- Developer Implementation Notes:
176 -- For update, your business rules should be executed from this procedure and
177 -- should ideally (unless really necessary) just be straight procedure or
178 -- function calls. Try and avoid using conditional branching logic.
179 --
180 -- Access Status:
181 -- Internal Row Handler Use Only.
182 --
183 -- {End Of Comments}
184 -- ----------------------------------------------------------------------------
185 Procedure update_validate(p_rec in ghr_pdi_shd.g_rec_type);
186 --
187 -- ----------------------------------------------------------------------------
188 -- |---------------------------< delete_validate >----------------------------|
189 -- ----------------------------------------------------------------------------
190 -- {Start Of Comments}
191 --
192 -- Description:
193 -- This procedure controls the execution of all delete business rules
194 -- validation.
195 --
196 -- Prerequisites:
197 -- This private procedure is called from del procedure.
198 --
199 -- In Parameters:
200 -- A Pl/Sql record structre.
201 --
202 -- Post Success:
203 -- Processing continues.
204 --
205 -- Post Failure:
206 -- If a business rules fails the error will not be handled by this procedure
207 -- unless explicity coded.
208 --
209 -- Developer Implementation Notes:
210 -- For delete, your business rules should be executed from this procedure and
211 -- should ideally (unless really necessary) just be straight procedure or
212 -- function calls. Try and avoid using conditional branching logic.
213 --
214 -- Access Status:
215 -- Internal Row Handler Use Only.
216 --
217 -- {End Of Comments}
218 -- ----------------------------------------------------------------------------
219 Procedure delete_validate(p_rec in ghr_pdi_shd.g_rec_type);
220 --
221 end ghr_pdi_bus;