DBA Data[Home] [Help]

APPS.HR_RU_ASG_HOOK dependencies on HR_RU_UTILITY

Line 89: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','EMP_TYPE'),

85: END;
86: END IF;
87: IF p_segment2 <> hr_api.g_varchar2 OR p_segment2 IS NULL THEN
88: IF p_segment2 IS NOT NULL THEN
89: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','EMP_TYPE'),
90: p_segment2,
91: 'YES_NO',
92: p_effective_date);
93: END IF;

Line 95: l_asg_status := hr_ru_utility.check_assign_category(l_eff_start_date

91: 'YES_NO',
92: p_effective_date);
93: END IF;
94: IF nvl(p_segment2,'N') = 'N' THEN
95: l_asg_status := hr_ru_utility.check_assign_category(l_eff_start_date
96: ,l_eff_end_date
97: ,p_assignment_id
98: ,l_person_id
99: ,l_business_group_id

Line 108: l_cont_status := hr_ru_utility.check_contract_number_unique(p_segment3

104: END IF;
105: END IF;
106: END IF;
107: IF p_segment3 <> hr_api.g_varchar2 THEN
108: l_cont_status := hr_ru_utility.check_contract_number_unique(p_segment3
109: ,p_assignment_id
110: ,l_business_group_id
111: );
112: IF l_cont_status = 'Y' THEN

Line 130: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','CONT_LIMIT_REASON'),

126: hr_utility.raise_error;
127: END IF;
128: END IF;
129: IF p_segment6 <> hr_api.g_varchar2 THEN
130: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','CONT_LIMIT_REASON'),
131: p_segment6,
132: 'RU_LIMITED_CONTRACT_REASON',
133: p_effective_date);
134: END IF;

Line 144: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','END_REASON'),

140: hr_utility.raise_error;
141: END IF;
142: END IF;
143: IF p_segment7 <> hr_api.g_varchar2 THEN
144: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','END_REASON'),
145: p_segment7,
146: 'LEAV_REAS',
147: p_effective_date);
148: END IF;

Line 172: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),

168: hr_utility.raise_error;
169: END;
170: END IF;
171: IF p_segment9 <> hr_api.g_varchar2 THEN
172: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),
173: p_segment9,
174: 'RU_TERRITORY_CONDITIONS',
175: p_effective_date);
176: END IF;

Line 178: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),

174: 'RU_TERRITORY_CONDITIONS',
175: p_effective_date);
176: END IF;
177: IF p_segment10 <> hr_api.g_varchar2 THEN
178: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),
179: p_segment10,
180: 'RU_CALC_RECORD_SERVICE',
181: p_effective_date);
182: END IF;

Line 184: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),

180: 'RU_CALC_RECORD_SERVICE',
181: p_effective_date);
182: END IF;
183: IF p_segment14 <> hr_api.g_varchar2 THEN
184: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),
185: p_segment14,
186: 'YES_NO',
187: p_effective_date);
188: END IF;

Line 190: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),

186: 'YES_NO',
187: p_effective_date);
188: END IF;
189: IF p_segment15 <> hr_api.g_varchar2 THEN
190: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),
191: p_segment15,
192: 'YES_NO',
193: p_effective_date);
194: END IF;

Line 263: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','EMP_TYPE'),

259: hr_utility.raise_error;
260: END;
261: END IF;
262: IF p_scl_segment2 IS NOT NULL THEN
263: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','EMP_TYPE'),
264: p_scl_segment2,
265: 'YES_NO',
266: p_effective_date);
267: END IF;

Line 269: l_asg_status := hr_ru_utility.check_assign_category(l_eff_start_date

265: 'YES_NO',
266: p_effective_date);
267: END IF;
268: IF nvl(p_scl_segment2,'N') = 'N' THEN
269: l_asg_status := hr_ru_utility.check_assign_category(l_eff_start_date
270: ,l_eff_end_date
271: ,NULL
272: ,p_person_id
273: ,l_business_group_id

Line 281: l_cont_status := hr_ru_utility.check_contract_number_unique(p_scl_segment3

277: hr_utility.raise_error;
278: END IF;
279: END IF;
280: IF p_scl_segment3 IS NOT NULL THEN
281: l_cont_status := hr_ru_utility.check_contract_number_unique(p_scl_segment3
282: ,NULL
283: ,l_business_group_id
284: );
285: IF l_cont_status = 'Y' THEN

Line 303: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','CONT_LIMIT_REASON'),

299: hr_utility.raise_error;
300: END IF;
301: END IF;
302: IF p_scl_segment6 IS NOT NULL THEN
303: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','CONT_LIMIT_REASON'),
304: p_scl_segment6,
305: 'RU_LIMITED_CONTRACT_REASON',
306: p_effective_date);
307: END IF;

Line 315: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','END_REASON'),

311: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));
312: hr_utility.raise_error;
313: END IF;
314: IF p_scl_segment7 IS NOT NULL THEN
315: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','END_REASON'),
316: p_scl_segment7,
317: 'LEAV_REAS',
318: p_effective_date);
319: END IF;

Line 343: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),

339: hr_utility.raise_error;
340: END;
341: END IF;
342: IF p_scl_segment9 <> hr_api.g_varchar2 THEN
343: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TERRITORY_CONDITIONS'),
344: p_scl_segment9,
345: 'RU_TERRITORY_CONDITIONS',
346: p_effective_date);
347: END IF;

Line 349: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),

345: 'RU_TERRITORY_CONDITIONS',
346: p_effective_date);
347: END IF;
348: IF p_scl_segment10 <> hr_api.g_varchar2 THEN
349: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','RECORD_SERVICE_REASON'),
350: p_scl_segment10,
351: 'RU_CALC_RECORD_SERVICE',
352: p_effective_date);
353: END IF;

Line 355: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),

351: 'RU_CALC_RECORD_SERVICE',
352: p_effective_date);
353: END IF;
354: IF p_scl_segment14 <> hr_api.g_varchar2 THEN
355: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','UNINTERRUPTED_SERVICE_RECORD'),
356: p_scl_segment14,
357: 'YES_NO',
358: p_effective_date);
359: END IF;

Line 361: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),

357: 'YES_NO',
358: p_effective_date);
359: END IF;
360: IF p_scl_segment15 <> hr_api.g_varchar2 THEN
361: hr_ru_utility.check_lookup_value(hr_general.decode_lookup('RU_FORM_LABELS','TOTAL_SERVICE_RECORD'),
362: p_scl_segment15,
363: 'YES_NO',
364: p_effective_date);
365: END IF;