85: is
86: begin
87: IF ( p_pos_grp1_type.flsa_category IS NULL)
88: THEN
89: hr_utility.set_message(8301, 'GHR_38420_POSN_RULES');
90: hr_utility.raise_error;
91: END IF;
92: end psn_flsa_cat;
93: --
86: begin
87: IF ( p_pos_grp1_type.flsa_category IS NULL)
88: THEN
89: hr_utility.set_message(8301, 'GHR_38420_POSN_RULES');
90: hr_utility.raise_error;
91: END IF;
92: end psn_flsa_cat;
93: --
94: procedure psn_flsa_cat_3
100: begin
101: IF ( p_pay_plan IN ('AL', 'CA', 'ES', 'EX', 'SL', 'ST')
102: AND p_pos_grp1_type.flsa_category <> 'E')
103: THEN
104: hr_utility.set_message(8301, 'GHR_38421_POSN_RULES');
105: hr_utility.raise_error;
106: END IF;
107: end psn_flsa_cat_3;
108: --
101: IF ( p_pay_plan IN ('AL', 'CA', 'ES', 'EX', 'SL', 'ST')
102: AND p_pos_grp1_type.flsa_category <> 'E')
103: THEN
104: hr_utility.set_message(8301, 'GHR_38421_POSN_RULES');
105: hr_utility.raise_error;
106: END IF;
107: end psn_flsa_cat_3;
108: --
109: procedure psn_funct_class_id_3
115: begin
116: IF ( p_pos_grp2_type.training_program_id = '53'
117: AND p_pos_grp1_type.functional_class IS NULL)
118: THEN
119: hr_utility.set_message(8301, 'GHR_38424_POSN_RULES');
120: hr_utility.raise_error;
121: END IF;
122: end psn_funct_class_id_3;
123: --
116: IF ( p_pos_grp2_type.training_program_id = '53'
117: AND p_pos_grp1_type.functional_class IS NULL)
118: THEN
119: hr_utility.set_message(8301, 'GHR_38424_POSN_RULES');
120: hr_utility.raise_error;
121: END IF;
122: end psn_funct_class_id_3;
123: --
124: procedure psn_pos_scty_acs_1
130: IF ( p_pos_grp1_type.position_sensitivity <> '1'
131: AND p_pos_grp1_type.position_sensitivity IS NOT NULL
132: AND p_pos_grp1_type.security_access IS NULL)
133: THEN
134: hr_utility.set_message(8301, 'GHR_38425_POSN_RULES');
135: hr_utility.raise_error;
136: END IF;
137: end psn_pos_scty_acs_1;
138: --
131: AND p_pos_grp1_type.position_sensitivity IS NOT NULL
132: AND p_pos_grp1_type.security_access IS NULL)
133: THEN
134: hr_utility.set_message(8301, 'GHR_38425_POSN_RULES');
135: hr_utility.raise_error;
136: END IF;
137: end psn_pos_scty_acs_1;
138: --
139: /* Removed as per Aug 2001 10.7 Patch and patched in April 2002 Patch for 11i
146: begin
147: IF ( p_pos_grp1_type.supervisory_status = '5'
148: AND p_pay_plan NOT IN ('AL','CA','GM','GS','SL','GG','GH','FT','FM','FG') )
149: THEN
150: hr_utility.set_message(8301, 'GHR_38429_POSN_RULES');
151: hr_utility.raise_error;
152: END IF;
153: end psn_supv_status_11;
154: */
147: IF ( p_pos_grp1_type.supervisory_status = '5'
148: AND p_pay_plan NOT IN ('AL','CA','GM','GS','SL','GG','GH','FT','FM','FG') )
149: THEN
150: hr_utility.set_message(8301, 'GHR_38429_POSN_RULES');
151: hr_utility.raise_error;
152: END IF;
153: end psn_supv_status_11;
154: */
155: --
162: begin
163: IF ( p_pay_plan IN ('ES', 'EX', 'FE')
164: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2', '3', '8'))
165: THEN
166: hr_utility.set_message(8301, 'GHR_38433_POSN_RULES');
167: hr_utility.raise_error;
168: END IF;
169: end psn_supv_status_19;
170: --
163: IF ( p_pay_plan IN ('ES', 'EX', 'FE')
164: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2', '3', '8'))
165: THEN
166: hr_utility.set_message(8301, 'GHR_38433_POSN_RULES');
167: hr_utility.raise_error;
168: END IF;
169: end psn_supv_status_19;
170: --
171: procedure psn_supv_status_2
177: begin
178: IF ( p_pay_plan IN ('WN', 'WS')
179: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3'))
180: THEN
181: hr_utility.set_message(8301, 'GHR_38434_POSN_RULES');
182: hr_utility.raise_error;
183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
178: IF ( p_pay_plan IN ('WN', 'WS')
179: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3'))
180: THEN
181: hr_utility.set_message(8301, 'GHR_38434_POSN_RULES');
182: hr_utility.raise_error;
183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN
183: END IF;
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN
187: hr_utility.set_message(8301, 'GHR_38435_POSN_RULES');
188: hr_utility.raise_error;
189: END IF;
190: end psn_supv_status_2;
191: --
184: IF ( p_pay_plan = 'WG'
185: AND p_pos_grp1_type.supervisory_status NOT IN ('4','7','8'))
186: THEN
187: hr_utility.set_message(8301, 'GHR_38435_POSN_RULES');
188: hr_utility.raise_error;
189: END IF;
190: end psn_supv_status_2;
191: --
192: procedure psn_supv_status_3
200: IF ( p_pay_plan = 'GS'
201: AND p_grade IN ('01', '02', '03', '04')
202: AND p_pos_grp1_type.supervisory_status NOT IN ('4','6','8'))
203: THEN
204: hr_utility.set_message(8301, 'GHR_38436_POSN_RULES');
205: hr_utility.raise_error;
206: END IF;
207: end psn_supv_status_3;
208: --
201: AND p_grade IN ('01', '02', '03', '04')
202: AND p_pos_grp1_type.supervisory_status NOT IN ('4','6','8'))
203: THEN
204: hr_utility.set_message(8301, 'GHR_38436_POSN_RULES');
205: hr_utility.raise_error;
206: END IF;
207: end psn_supv_status_3;
208: --
209: procedure psn_supv_status_4
217: IF ( p_pay_plan <> 'GS'
218: AND p_pay_plan = 'GM'
219: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3','4','5','7'))
220: THEN
221: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');
222: hr_utility.raise_error;
223: END IF;
224: end psn_supv_status_4;
225: --
218: AND p_pay_plan = 'GM'
219: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','3','4','5','7'))
220: THEN
221: hr_utility.set_message(8301, 'GHR_38437_POSN_RULES');
222: hr_utility.raise_error;
223: END IF;
224: end psn_supv_status_4;
225: --
226: procedure psn_supv_status_5
232: begin
233: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')
234: AND p_pos_grp1_type.supervisory_status <> '8')
235: THEN
236: hr_utility.set_message(8301, 'GHR_38438_POSN_RULES');
237: hr_utility.raise_error;
238: END IF;
239: end psn_supv_status_5;
240: --
233: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')
234: AND p_pos_grp1_type.supervisory_status <> '8')
235: THEN
236: hr_utility.set_message(8301, 'GHR_38438_POSN_RULES');
237: hr_utility.raise_error;
238: END IF;
239: end psn_supv_status_5;
240: --
241: procedure psn_supv_status_6
247: begin
248: IF ( p_pos_grp1_type.supervisory_status NOT IN ('1','2')
249: AND p_pay_plan IN ('WA','WN', 'WS', 'WQ', 'XN', 'XS'))
250: THEN
251: hr_utility.set_message(8301, 'GHR_38439_POSN_RULES');
252: hr_utility.raise_error;
253: END IF;
254: end psn_supv_status_6;
255: --
248: IF ( p_pos_grp1_type.supervisory_status NOT IN ('1','2')
249: AND p_pay_plan IN ('WA','WN', 'WS', 'WQ', 'XN', 'XS'))
250: THEN
251: hr_utility.set_message(8301, 'GHR_38439_POSN_RULES');
252: hr_utility.raise_error;
253: END IF;
254: end psn_supv_status_6;
255: --
256: procedure psn_supv_status_8
262: begin
263: IF ( p_pay_plan = 'WB'
264: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','6','8'))
265: THEN
266: hr_utility.set_message(8301, 'GHR_38440_POSN_RULES');
267: hr_utility.raise_error;
268: END IF;
269: end psn_supv_status_8;
270: --
263: IF ( p_pay_plan = 'WB'
264: AND p_pos_grp1_type.supervisory_status NOT IN ('1','2','6','8'))
265: THEN
266: hr_utility.set_message(8301, 'GHR_38440_POSN_RULES');
267: hr_utility.raise_error;
268: END IF;
269: end psn_supv_status_8;
270: --
271: procedure psn_supv_status_9
277: begin
278: IF ( p_pos_grp1_type.supervisory_status <> '6'
279: AND p_pay_plan IN ( 'LL', 'LX', 'ML', 'RL', 'WL', 'XL' ))
280: THEN
281: hr_utility.set_message(8301, 'GHR_38441_POSN_RULES');
282: hr_utility.raise_error;
283: END IF;
284: end psn_supv_status_9;
285: --
278: IF ( p_pos_grp1_type.supervisory_status <> '6'
279: AND p_pay_plan IN ( 'LL', 'LX', 'ML', 'RL', 'WL', 'XL' ))
280: THEN
281: hr_utility.set_message(8301, 'GHR_38441_POSN_RULES');
282: hr_utility.raise_error;
283: END IF;
284: end psn_supv_status_9;
285: --
286: end ghr_psn_pos_grp1_pk;