DBA Data[Home] [Help]

APPS.PAY_JP_BEE_UTILITY_PKG dependencies on HR_GENERAL

Line 526: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||

522: --
523: if g_num_of_logs = 0 then
524: fnd_file.put_line(fnd_file.log,
525: rtrim(
526: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
527: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
528: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'LOG'), 85)
529: ));
530: fnd_file.put_line(fnd_file.log,

Line 527: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||

523: if g_num_of_logs = 0 then
524: fnd_file.put_line(fnd_file.log,
525: rtrim(
526: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
527: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
528: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'LOG'), 85)
529: ));
530: fnd_file.put_line(fnd_file.log,
531: rpad('-', 30, '-') || ' ' ||

Line 528: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'LOG'), 85)

524: fnd_file.put_line(fnd_file.log,
525: rtrim(
526: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
527: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
528: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'LOG'), 85)
529: ));
530: fnd_file.put_line(fnd_file.log,
531: rpad('-', 30, '-') || ' ' ||
532: rpad('-', 15, '-') || ' ' ||

Line 581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||

577: --
578: if g_num_of_outs = 0 then
579: fnd_file.put_line(fnd_file.output,
580: rtrim(
581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||

Line 582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||

578: if g_num_of_outs = 0 then
579: fnd_file.put_line(fnd_file.output,
580: rtrim(
581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||

Line 583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||

579: fnd_file.put_line(fnd_file.output,
580: rtrim(
581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||
587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)

Line 584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||

580: rtrim(
581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||
587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)
588: ));

Line 585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||

581: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'FULL_NAME'), 30) || ' ' ||
582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||
587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)
588: ));
589: fnd_file.put_line(fnd_file.output,

Line 586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||

582: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'ASSIGNMENT_NUMBER'), 15) || ' ' ||
583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||
587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)
588: ));
589: fnd_file.put_line(fnd_file.output,
590: rpad('-', 30, '-') || ' ' ||

Line 587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)

583: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_DATE'), 11) || ' ' ||
584: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'CHANGE_TYPE'), 4) || ' ' ||
585: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'INPUT_VALUE'), 14) || ' ' ||
586: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'BEFORE_CHANGE'), 26) || ' ' ||
587: rpad(hr_general.decode_lookup(c_prompt_lookup_type, 'AFTER_CHANGE'), 26)
588: ));
589: fnd_file.put_line(fnd_file.output,
590: rpad('-', 30, '-') || ' ' ||
591: rpad('-', 15, '-') || ' ' ||

Line 614: l_old_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_old_value);

610: --
611: if (p_write_all)
612: or (nvl(l_new_value, hr_api.g_varchar2) <> nvl(l_old_value, hr_api.g_varchar2)) then
613: if p_eev_rec.lookup_type_tbl(l_index) is not null then
614: l_old_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_old_value);
615: l_new_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_new_value);
616: end if;
617: --
618: -- Write output data.

Line 615: l_new_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_new_value);

611: if (p_write_all)
612: or (nvl(l_new_value, hr_api.g_varchar2) <> nvl(l_old_value, hr_api.g_varchar2)) then
613: if p_eev_rec.lookup_type_tbl(l_index) is not null then
614: l_old_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_old_value);
615: l_new_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(l_index), l_new_value);
616: end if;
617: --
618: -- Write output data.
619: -- The heading some items are only written in the first record

Line 630: rpad(hr_general.decode_lookup(c_prompt_lookup_type, p_change_type), 4) || ' ' ||

626: rtrim(
627: rpad(p_full_name, 30) || ' ' ||
628: rpad(p_assignment_number, 15) || ' ' ||
629: rpad(fnd_date.date_to_chardate(p_effective_date), 11) || ' ' ||
630: rpad(hr_general.decode_lookup(c_prompt_lookup_type, p_change_type), 4) || ' ' ||
631: rpad(p_eev_rec.name_tbl(l_index), 14) || ' ' ||
632: rpad(nvl(l_old_value, ' '), 26) || ' ' ||
633: rpad(nvl(l_new_value, ' '), 26)
634: ));

Line 693: l_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(p_index), p_eev_rec.entry_value_tbl(p_index));

689: if p_eev_rec.entry_value_tbl.exists(p_index) then
690: if p_eev_rec.lookup_type_tbl(p_index) is null then
691: l_value := p_eev_rec.entry_value_tbl(p_index);
692: else
693: l_value := hr_general.decode_lookup(p_eev_rec.lookup_type_tbl(p_index), p_eev_rec.entry_value_tbl(p_index));
694: end if;
695: --
696: hr_utility.trace(rpad('value_' || to_char(p_index), 8) || ' : ' || l_value);
697: end if;