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.GHR_HISTORY_CASCADE dependencies on HR_API

Line 1757: l_datetrack_mode varchar2(30):=hr_api.g_correction;

1753: and effective_start_date = cp_eff_st_dt;
1754:
1755: -- and effective_end_date = cp_eff_end_dt;
1756:
1757: l_datetrack_mode varchar2(30):=hr_api.g_correction;
1758: l_dob_null_warning boolean;
1759: l_name_combination_warning boolean;
1760: l_orig_hire_warning boolean;
1761: l_people_data per_all_people_f%rowtype;

Line 1980: l_datetrack_mode varchar2(30):=hr_api.g_correction;

1976: l_validation_start_date date;
1977: l_validation_end_date date;
1978: l_object_version_number number;
1979: l_effective_date date:= p_asgn_data.effective_Start_date;
1980: l_datetrack_mode varchar2(30):=hr_api.g_correction;
1981: l_validate boolean;
1982:
1983: l_proc varchar2(30):='correct_asgn_row';
1984:

Line 2538: l_datetrack_mode varchar2(30):=hr_api.g_correction;

2534:
2535: l_posn_data hr_all_positions_f%rowtype;
2536: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
2537: l_proc varchar2(30):='Correct_posn_Row';
2538: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2539: l_date2 hr_all_positions_f.effective_start_date%type;
2540:
2541: Begin
2542: hr_utility.set_location( 'Entering : ' || l_proc, 10);

Line 3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or

3034: if (p_post_record.table_name = ghr_history_api.g_addres_table) then
3035: if (p_true_false(9) = FALSE) then
3036: null;
3037: else
3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or

Line 3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or

3035: if (p_true_false(9) = FALSE) then
3036: null;
3037: else
3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or

Line 3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or

3036: null;
3037: else
3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or

Line 3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or

3037: else
3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or

Line 3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or

3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and

Line 3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or

3039: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and

Line 3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or

3040: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and

Line 3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or

3041: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and

Line 3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and

3042: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and

Line 3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and

3043: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and

Line 3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and

3044: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and

Line 3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and

3045: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and

Line 3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and

3046: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and

Line 3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and

3047: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))

Line 3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and

3048: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3056: then

Line 3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and

3049: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3056: then
3057: hr_utility.set_location(l_proc,20);

Line 3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and

3050: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3056: then
3057: hr_utility.set_location(l_proc,20);
3058: p_apply_record.information9 := p_post_record.information9;

Line 3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))

3051: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3052: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3056: then
3057: hr_utility.set_location(l_proc,20);
3058: p_apply_record.information9 := p_post_record.information9;
3059: p_apply_record.information10 := p_post_record.information10;

Line 3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and

3952: hr_utility.set_location(l_proc,10);
3953: -- removed following line in order to allow cascading of null values.
3954: -- If p_post_field is not null then
3955: hr_utility.set_location(l_proc,15);
3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3957: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3958: hr_utility.set_location(l_proc,20);
3959: p_apply_field := p_post_field;
3960: Else

Line 3957: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then

3953: -- removed following line in order to allow cascading of null values.
3954: -- If p_post_field is not null then
3955: hr_utility.set_location(l_proc,15);
3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3957: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3958: hr_utility.set_location(l_proc,20);
3959: p_apply_field := p_post_field;
3960: Else
3961: p_result := FALSE;

Line 4261: If (p_refresh_field <> nvl(p_sf52_field,hr_api.g_varchar2)) then

4257: l_sf52_field := p_sf52_field;
4258: l_changed_boo := p_changed;
4259: --
4260: if (p_refresh_field is not null) then
4261: If (p_refresh_field <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4262: if (nvl(p_shadow_field,hr_api.g_varchar2) = nvl(p_sf52_field,hr_api.g_varchar2)) then
4263: p_shadow_field := p_refresh_field;
4264: p_sf52_field := p_refresh_field;
4265: l_changed := TRUE;

Line 4262: if (nvl(p_shadow_field,hr_api.g_varchar2) = nvl(p_sf52_field,hr_api.g_varchar2)) then

4258: l_changed_boo := p_changed;
4259: --
4260: if (p_refresh_field is not null) then
4261: If (p_refresh_field <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4262: if (nvl(p_shadow_field,hr_api.g_varchar2) = nvl(p_sf52_field,hr_api.g_varchar2)) then
4263: p_shadow_field := p_refresh_field;
4264: p_sf52_field := p_refresh_field;
4265: l_changed := TRUE;
4266: p_changed := TRUE;

Line 4275: if (nvl(p_shadow_field,hr_api.g_varchar2) <> nvl(p_sf52_field,hr_api.g_varchar2)) then

4271: -- Currently functionality is limited to copying UE and APUE which have been changed by the
4272: -- user to refresh rg.
4273: -- It is not refreshing the shadoe and sf52 RGs
4274: --
4275: if (nvl(p_shadow_field,hr_api.g_varchar2) <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4276: p_refresh_field := p_sf52_field;
4277: l_changed := TRUE;
4278: else
4279: -- ie. either field is AP or APUE and user did not change it.

Line 4703: if (nvl(p_shadow_rec.part_time_hours,hr_api.g_number) = nvl(p_sf52_rec.part_time_hours,hr_api.g_number)) then

4699: -- so, if part_time_hours was not changed by cascade_pa_req_field and the refresh value for
4700: -- PTH is null, then we need to handle the cascade here.
4701: if (not l_changed and p_rfrsh_rec.part_time_hours is null) then
4702: If (p_sf52_rec.part_time_hours is not null) then
4703: if (nvl(p_shadow_rec.part_time_hours,hr_api.g_number) = nvl(p_sf52_rec.part_time_hours,hr_api.g_number)) then
4704: p_changed := TRUE;
4705: p_shadow_rec.part_time_hours := p_rfrsh_rec.part_time_hours;
4706: p_sf52_rec.part_time_hours := p_rfrsh_rec.part_time_hours;
4707: end if;