APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_FORMULA_FUNCTIONS

Line 374: l_present_val := per_formula_functions.get_number(p_varable_name);

370: l_new_val NUMBER;
371: l_dummy NUMBER;
372: begin
373: hr_utility.TRACE(' p_variable_value '|| p_variable_value);
374: l_present_val := per_formula_functions.get_number(p_varable_name);
375: hr_utility.TRACE(' l_present_val '|| l_present_val);
376: if l_present_val is null
377: then
378: if p_variable_value is null

Line 397: l_dummy := per_formula_functions.set_number(p_varable_name, l_new_val);

393: end if;
394: --
395: hr_utility.TRACE(' l_new_val '|| l_new_val);
396: end if;
397: l_dummy := per_formula_functions.set_number(p_varable_name, l_new_val);
398: hr_utility.TRACE(' l_dummy '|| l_dummy);
399: return l_new_val;
400: end;
401:

Line 417: if nvl(per_formula_functions.get_number(p_variable_name),0) < nvl(to_number(p_variable_value),0) then

413: -- rates remain same for a vehicle type
414: -- !! the above statm is not true as second assignment (multi)
415: -- might not have this benefit type hence it will be zero,
416: -- so we don't want to store zero.
417: if nvl(per_formula_functions.get_number(p_variable_name),0) < nvl(to_number(p_variable_value),0) then
418: l_dummy := per_formula_functions.set_number(p_variable_name, p_variable_value);
419: end if;
420: end if;
421: if p_variable_datatype = 'T' then

Line 418: l_dummy := per_formula_functions.set_number(p_variable_name, p_variable_value);

414: -- !! the above statm is not true as second assignment (multi)
415: -- might not have this benefit type hence it will be zero,
416: -- so we don't want to store zero.
417: if nvl(per_formula_functions.get_number(p_variable_name),0) < nvl(to_number(p_variable_value),0) then
418: l_dummy := per_formula_functions.set_number(p_variable_name, p_variable_value);
419: end if;
420: end if;
421: if p_variable_datatype = 'T' then
422: -- we need to store the Y value

Line 424: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);

420: end if;
421: if p_variable_datatype = 'T' then
422: -- we need to store the Y value
423: -- as this will be called only when the value is Y
424: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
425: end if;
426: if p_variable_datatype = 'D' then
427: -- this is for date, we need to store the max date
428: -- this is used for date free fuel withdrawn

Line 430: l_present_val := per_formula_functions.get_text(p_variable_name);

426: if p_variable_datatype = 'D' then
427: -- this is for date, we need to store the max date
428: -- this is used for date free fuel withdrawn
429: -- if p_variable_value is null or zero this won't be called
430: l_present_val := per_formula_functions.get_text(p_variable_name);
431: hr_utility.TRACE(' l_present_val '|| l_present_val);
432: if l_present_val is null
433: then
434: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);

Line 434: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);

430: l_present_val := per_formula_functions.get_text(p_variable_name);
431: hr_utility.TRACE(' l_present_val '|| l_present_val);
432: if l_present_val is null
433: then
434: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
435: else
436: if fnd_date.canonical_to_date(l_present_val) <>
437: fnd_date.canonical_to_date(p_variable_value)
438: then

Line 443: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);

439: l_warnmsg := '1';
440: if fnd_date.canonical_to_date(l_present_val) <
441: fnd_date.canonical_to_date(p_variable_value)
442: then
443: l_dummy := per_formula_functions.set_text(p_variable_name, p_variable_value);
444: end if;
445: end if;
446: end if;
447: end if;

Line 485: l_present_val := per_formula_functions.get_text(p_varable_name);

481: l_dummy NUMBER;
482: begin
483: hr_utility.TRACE('.. p_varable_name ...'|| p_varable_name);
484: hr_utility.TRACE('.. p_variable_value ...'|| p_variable_value);
485: l_present_val := per_formula_functions.get_text(p_varable_name);
486: hr_utility.TRACE('..l_present_val.. '|| l_present_val);
487: if p_lookup_type is null
488: then
489: if l_present_val is null

Line 492: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);

488: then
489: if l_present_val is null
490: then
491: l_new_val := p_variable_value;
492: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);
493: else
494: hr_utility.TRACE('..Checking present Value with variable value '|| l_present_val);
495: if l_present_val <> nvl(p_variable_value, l_present_val)
496: then

Line 498: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);

494: hr_utility.TRACE('..Checking present Value with variable value '|| l_present_val);
495: if l_present_val <> nvl(p_variable_value, l_present_val)
496: then
497: l_new_val := 'Multiple';
498: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);
499: end if;
500: end if;
501: else
502: l_new_val := get_lookup_desc (p_lookup_type,

Line 508: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);

504: p_effective_date || ' 00:00:00'); -- since it accepts date in canonical format
505: if l_present_val is null
506: then
507: hr_utility.trace('New vale ' || l_new_val);
508: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);
509: else
510: hr_utility.TRACE('..Checking present Value with variable value '|| l_present_val);
511: if l_present_val <> nvl(l_new_val, l_present_val)
512: then

Line 514: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);

510: hr_utility.TRACE('..Checking present Value with variable value '|| l_present_val);
511: if l_present_val <> nvl(l_new_val, l_present_val)
512: then
513: l_new_val := 'Multiple';
514: l_dummy := per_formula_functions.set_text(p_varable_name, l_new_val);
515: end if;
516: end if;
517: end if;
518: return l_dummy;