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.PAY_WAT_UDFS dependencies on HR_UTILITY

Line 246: hr_utility.trace(lv_mod_name || ': p_element_type_id');

242: ln_garn_limit_days NUMBER(15) := 0;
243: lv_mod_name VARCHAR2(30) := 'get_garn_limit_max_duration';
244:
245: BEGIN
246: hr_utility.trace(lv_mod_name || ': p_element_type_id');
247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');

Line 247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));

243: lv_mod_name VARCHAR2(30) := 'get_garn_limit_max_duration';
244:
245: BEGIN
246: hr_utility.trace(lv_mod_name || ': p_element_type_id');
247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);

Line 248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');

244:
245: BEGIN
246: hr_utility.trace(lv_mod_name || ': p_element_type_id');
247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');

Line 249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));

245: BEGIN
246: hr_utility.trace(lv_mod_name || ': p_element_type_id');
247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');
253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);

Line 250: hr_utility.trace(lv_mod_name || ': p_effective_date');

246: hr_utility.trace(lv_mod_name || ': p_element_type_id');
247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');
253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);
254:

Line 251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);

247: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_type_id));
248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');
253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);
254:
255: OPEN c_get_dt_srvd;

Line 252: hr_utility.trace(lv_mod_name || ': p_jursd_code');

248: hr_utility.trace(lv_mod_name || ': p_element_entry_id');
249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');
253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);
254:
255: OPEN c_get_dt_srvd;
256:

Line 253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);

249: hr_utility.trace(lv_mod_name || ': ' || to_char(p_element_entry_id));
250: hr_utility.trace(lv_mod_name || ': p_effective_date');
251: hr_utility.trace(lv_mod_name || ': ' || p_effective_date);
252: hr_utility.trace(lv_mod_name || ': p_jursd_code');
253: hr_utility.trace(lv_mod_name || ': ' || p_jursd_code);
254:
255: OPEN c_get_dt_srvd;
256:
257: FETCH c_get_dt_srvd

Line 268: hr_utility.trace(lv_mod_name || ': Min. Effective Start Date');

264: SELECT MIN(effective_start_date)
265: INTO ld_garn_date
266: FROM pay_element_entries_f ee
267: WHERE ee.element_entry_id = p_element_entry_id;
268: hr_utility.trace(lv_mod_name || ': Min. Effective Start Date');
269: hr_utility.trace(lv_mod_name || ': '
270: || to_char(ld_garn_date, 'dd-mon-yyyy'));
271: END IF;
272:

Line 269: hr_utility.trace(lv_mod_name || ': '

265: INTO ld_garn_date
266: FROM pay_element_entries_f ee
267: WHERE ee.element_entry_id = p_element_entry_id;
268: hr_utility.trace(lv_mod_name || ': Min. Effective Start Date');
269: hr_utility.trace(lv_mod_name || ': '
270: || to_char(ld_garn_date, 'dd-mon-yyyy'));
271: END IF;
272:
273: SELECT target.max_withholding_duration_days

Line 290: hr_utility.trace(lv_mod_name || ': Garnishment Duration Limit');

286: AND ld_garn_date
287: BETWEEN pet.effective_start_date AND pet.effective_end_date;
288: */
289:
290: hr_utility.trace(lv_mod_name || ': Garnishment Duration Limit');
291: hr_utility.trace(lv_mod_name || ': ' || to_char(ln_garn_limit_days));
292: return ln_garn_limit_days;
293:
294: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 291: hr_utility.trace(lv_mod_name || ': ' || to_char(ln_garn_limit_days));

287: BETWEEN pet.effective_start_date AND pet.effective_end_date;
288: */
289:
290: hr_utility.trace(lv_mod_name || ': Garnishment Duration Limit');
291: hr_utility.trace(lv_mod_name || ': ' || to_char(ln_garn_limit_days));
292: return ln_garn_limit_days;
293:
294: EXCEPTION WHEN NO_DATA_FOUND THEN
295: hr_utility.oracle_error(sqlcode);

Line 295: hr_utility.oracle_error(sqlcode);

291: hr_utility.trace(lv_mod_name || ': ' || to_char(ln_garn_limit_days));
292: return ln_garn_limit_days;
293:
294: EXCEPTION WHEN NO_DATA_FOUND THEN
295: hr_utility.oracle_error(sqlcode);
296: return ln_garn_limit_days;
297:
298: WHEN OTHERS THEN
299: hr_utility.oracle_error(sqlcode);

Line 299: hr_utility.oracle_error(sqlcode);

295: hr_utility.oracle_error(sqlcode);
296: return ln_garn_limit_days;
297:
298: WHEN OTHERS THEN
299: hr_utility.oracle_error(sqlcode);
300: return ln_garn_limit_days;
301:
302: END get_garn_limit_max_duration;
303: