282: ln_value NUMBER;
283:
284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
283:
284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
284: BEGIN
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
285:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
286: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type ID');
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id
287: hr_utility.trace('p_balance_type_id: '||p_balance_type_id);
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id
295: ,p_dimension_name
288: hr_utility.trace('p_dimension_name: '||p_dimension_name);
289: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
290: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
291: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
292: hr_utility.trace('p_date_paid: '||p_date_paid);
293:
294: ln_defined_balance_id := get_defined_balance_id (p_balance_type_id
295: ,p_dimension_name
296: ,p_bus_grp_id
295: ,p_dimension_name
296: ,p_bus_grp_id
297: ,p_legislation_cd);
298:
299: hr_utility.trace('ln_defined_balance_id: '||ln_defined_balance_id);
300:
301: if ln_defined_balance_id <> 0 then
302: ln_value := pay_balance_pkg.get_value
303: (p_defined_balance_id => ln_defined_balance_id
310: else
311: ln_value := NULL;
312: end if;
313:
314: hr_utility.trace('ln_value: '||ln_value);
315: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type ID');
316:
317: return ln_value;
318:
311: ln_value := NULL;
312: end if;
313:
314: hr_utility.trace('ln_value: '||ln_value);
315: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type ID');
316:
317: return ln_value;
318:
319: END get_value;
330: ln_balance_type_id NUMBER;
331: ln_value NUMBER;
332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
331: ln_value NUMBER;
332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
332: BEGIN
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
333:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
334: hr_utility.trace('Entering pay_ac_utility.get_value with Bal Type Name');
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
335: hr_utility.trace('p_balance_name: '||p_balance_name);
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id
336: hr_utility.trace('p_dimension_name: '||p_dimension_name);
337: hr_utility.trace('p_bus_grp_id: '||p_bus_grp_id);
338: hr_utility.trace('p_legislation_cd: '||p_legislation_cd);
339: hr_utility.trace('p_tax_unit_id: '||p_tax_unit_id);
340: hr_utility.trace('p_date_paid: '||p_date_paid);
341:
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id
344: , p_legislation_cd);
342: ln_balance_type_id := get_balance_type_id ( p_balance_name
343: , p_bus_grp_id
344: , p_legislation_cd);
345:
346: hr_utility.trace('ln_balance_type_id: '||ln_balance_type_id);
347:
348: ln_value := get_value(p_balance_type_id => ln_balance_type_id
349: ,p_dimension_name => p_dimension_name
350: ,p_bus_grp_id => p_bus_grp_id
352: ,p_asg_act_id => p_asg_act_id
353: ,p_tax_unit_id => p_tax_unit_id
354: ,p_date_paid => p_date_paid);
355:
356: hr_utility.trace('ln_value: '||ln_value);
357: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type Name');
358:
359: return ln_value;
360:
353: ,p_tax_unit_id => p_tax_unit_id
354: ,p_date_paid => p_date_paid);
355:
356: hr_utility.trace('ln_value: '||ln_value);
357: hr_utility.trace('Leaving pay_ac_utility.get_value with Bal Type Name');
358:
359: return ln_value;
360:
361: END get_value;
395: lv_action_param_val varchar2(30);
396: lv_report_param_val varchar2(30);
397:
398: BEGIN
399: hr_utility.set_location('range_person_on',10);
400:
401: open csr_action_parameter;
402: fetch csr_action_parameter into lv_action_param_val;
403: close csr_action_parameter;
401: open csr_action_parameter;
402: fetch csr_action_parameter into lv_action_param_val;
403: close csr_action_parameter;
404:
405: hr_utility.set_location('range_person_on',20);
406: open csr_range_format_param;
407: fetch csr_range_format_param into lv_report_param_val;
408: close csr_range_format_param;
409:
406: open csr_range_format_param;
407: fetch csr_range_format_param into lv_report_param_val;
408: close csr_range_format_param;
409:
410: hr_utility.set_location('range_person_on',30);
411:
412: IF nvl(lv_action_param_val,'N') = 'Y' AND
413: nvl(lv_report_param_val,'N') = 'Y' THEN
414: lb_return := TRUE;
411:
412: IF nvl(lv_action_param_val,'N') = 'Y' AND
413: nvl(lv_report_param_val,'N') = 'Y' THEN
414: lb_return := TRUE;
415: hr_utility.trace('Range Person = True');
416: ELSE
417: lb_return := FALSE;
418: END IF;
419:
499: lr_buf RAW(2000);
500: BEGIN
501: ln_offset := 1;
502: ln_amount := 2000;
503: hr_utility.trace('BLOB contents: -');
504: LOOP
505: dbms_lob.read(
506: p_blob,
507: ln_amount,
508: ln_offset,
509: lr_buf);
510: ln_amount := 2000;
511: ln_offset := ln_offset + ln_amount;
512: hr_utility.trace(utl_raw.cast_to_varchar2(lr_buf));
513: END LOOP;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: hr_utility.trace('BLOB contents end.');
512: hr_utility.trace(utl_raw.cast_to_varchar2(lr_buf));
513: END LOOP;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: hr_utility.trace('BLOB contents end.');
517: END print_lob;
518:
519: end pay_ac_utility;