eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_RU_ASG_HOOK dependencies on HR_GENERAL

Line 61: l_eff_end_date := hr_general.end_of_time;

57: ELSIF p_datetrack_update_mode = 'UPDATE_CHANGE_INSERT' THEN
58: l_eff_start_date := p_effective_date;
59: ELSIF p_datetrack_update_mode = 'UPDATE_OVERRIDE' THEN
60: l_eff_start_date := p_effective_date;
61: l_eff_end_date := hr_general.end_of_time;
62: ELSE
63: l_eff_start_date := l_eff_start_date;
64: l_eff_end_date := l_eff_end_date;
65: END IF;

Line 83: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','EMPLOYER'));

79: AND p_effective_date <= NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
80: EXCEPTION
81: WHEN NO_DATA_FOUND THEN
82: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
83: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','EMPLOYER'));
84: hr_utility.raise_error;
85: END;
86: END IF;
87: IF p_segment2 <> hr_api.g_varchar2 OR p_segment2 IS NULL THEN

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 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 139: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));

135: IF p_assignment_status_type_id <> hr_api.g_number THEN
136: IF (p_assignment_status_type_id = 3 OR p_assignment_status_type_id = 8) AND
137: p_segment7 IS NULL THEN
138: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
139: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));
140: hr_utility.raise_error;
141: END IF;
142: END IF;
143: IF p_segment7 <> hr_api.g_varchar2 THEN

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 156: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));

152: AND lookup_code=p_segment8 AND enabled_flag='Y';
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN
155: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
156: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));
157: hr_utility.raise_error;
158: END;
159: END IF;
160: IF p_segment12 <> hr_api.g_varchar2 THEN

Line 167: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));

163: AND lookup_code=p_segment12 AND enabled_flag='Y';
164: EXCEPTION
165: WHEN NO_DATA_FOUND THEN
166: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
167: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));
168: hr_utility.raise_error;
169: END;
170: END IF;
171: IF p_segment9 <> hr_api.g_varchar2 THEN

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 237: l_eff_end_date := hr_general.end_of_time;

233: --
234: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
235: --
236: l_eff_start_date := p_effective_date;
237: l_eff_end_date := hr_general.end_of_time;
238: OPEN c_person_details(p_person_id,p_effective_date);
239: FETCH c_person_details INTO l_business_group_id;
240: CLOSE c_person_details;
241: IF p_scl_segment1 IS NOT NULL THEN

Line 258: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','EMPLOYER'));

254: AND p_effective_date <= NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
258: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','EMPLOYER'));
259: hr_utility.raise_error;
260: END;
261: END IF;
262: IF p_scl_segment2 IS NOT NULL THEN

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 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 311: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','TERM_REASON'));

307: END IF;
308: IF (p_assignment_status_type_id = 3 OR p_assignment_status_type_id = 8) AND
309: p_scl_segment7 IS NULL THEN
310: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
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'),

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 327: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));

323: AND lookup_code=p_scl_segment8 AND enabled_flag='Y';
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
327: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','SPECIAL_WORK_CONDITIONS'));
328: hr_utility.raise_error;
329: END;
330: END IF;
331: IF p_scl_segment12 <> hr_api.g_varchar2 THEN

Line 338: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));

334: AND lookup_code=p_scl_segment12 AND enabled_flag='Y';
335: EXCEPTION
336: WHEN NO_DATA_FOUND THEN
337: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
338: hr_utility.set_message_token ('ARGUMENT', hr_general.decode_lookup('RU_FORM_LABELS','LONG_SERVICE_REASON'));
339: hr_utility.raise_error;
340: END;
341: END IF;
342: IF p_scl_segment9 <> hr_api.g_varchar2 THEN

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;