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 1780: l_datetrack_mode varchar2(30):=hr_api.g_correction;

1776: and effective_start_date = cp_eff_st_dt;
1777:
1778: -- and effective_end_date = cp_eff_end_dt;
1779:
1780: l_datetrack_mode varchar2(30):=hr_api.g_correction;
1781: l_dob_null_warning boolean;
1782: l_name_combination_warning boolean;
1783: l_orig_hire_warning boolean;
1784: l_people_data per_all_people_f%rowtype;

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

1999: l_validation_start_date date;
2000: l_validation_end_date date;
2001: l_object_version_number number;
2002: l_effective_date date:= p_asgn_data.effective_Start_date;
2003: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2004: l_validate boolean;
2005:
2006: l_proc varchar2(30):='correct_asgn_row';
2007:

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

2560:
2561: l_posn_data hr_all_positions_f%rowtype;
2562: l_position_data_rec ghr_sf52_pos_update.position_data_rec_type;
2563: l_proc varchar2(30):='Correct_posn_Row';
2564: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2565: l_date2 hr_all_positions_f.effective_start_date%type;
2566:
2567: Begin
2568: hr_utility.set_location( 'Entering : ' || l_proc, 10);

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

3067: if (p_post_record.table_name = ghr_history_api.g_addres_table) then
3068: if (p_true_false(9) = FALSE) then
3069: null;
3070: else
3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or

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

3068: if (p_true_false(9) = FALSE) then
3069: null;
3070: else
3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or

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

3069: null;
3070: else
3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or

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

3070: else
3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or

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

3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or
3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and

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

3072: nvl(p_pre_record.information10,hr_api.g_varchar2) <> nvl(p_post_record.information10,hr_api.g_varchar2) or
3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and

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

3073: nvl(p_pre_record.information11,hr_api.g_varchar2) <> nvl(p_post_record.information11,hr_api.g_varchar2) or
3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and

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

3074: nvl(p_pre_record.information14,hr_api.g_varchar2) <> nvl(p_post_record.information14,hr_api.g_varchar2) or
3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and

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

3075: nvl(p_pre_record.information16,hr_api.g_varchar2) <> nvl(p_post_record.information16,hr_api.g_varchar2) or
3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and

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

3076: nvl(p_pre_record.information17,hr_api.g_varchar2) <> nvl(p_post_record.information17,hr_api.g_varchar2) or
3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and

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

3077: nvl(p_pre_record.information18,hr_api.g_varchar2) <> nvl(p_post_record.information18,hr_api.g_varchar2) or
3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and

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

3078: nvl(p_pre_record.information19,hr_api.g_varchar2) <> nvl(p_post_record.information19,hr_api.g_varchar2) or
3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and

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

3079: nvl(p_pre_record.information23,hr_api.g_varchar2) <> nvl(p_post_record.information23,hr_api.g_varchar2)) and
3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and

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

3080: (nvl(p_pre_record.information9,hr_api.g_varchar2) = nvl(p_apply_record.information9,hr_api.g_varchar2) and
3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))

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

3081: nvl(p_pre_record.information10,hr_api.g_varchar2) = nvl(p_apply_record.information10,hr_api.g_varchar2) and
3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3089: then

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

3082: nvl(p_pre_record.information11,hr_api.g_varchar2) = nvl(p_apply_record.information11,hr_api.g_varchar2) and
3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3089: then
3090: hr_utility.set_location(l_proc,20);

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

3083: nvl(p_pre_record.information14,hr_api.g_varchar2) = nvl(p_apply_record.information14,hr_api.g_varchar2) and
3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3089: then
3090: hr_utility.set_location(l_proc,20);
3091: p_apply_record.information9 := p_post_record.information9;

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

3084: nvl(p_pre_record.information16,hr_api.g_varchar2) = nvl(p_apply_record.information16,hr_api.g_varchar2) and
3085: nvl(p_pre_record.information17,hr_api.g_varchar2) = nvl(p_apply_record.information17,hr_api.g_varchar2) and
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3089: then
3090: hr_utility.set_location(l_proc,20);
3091: p_apply_record.information9 := p_post_record.information9;
3092: p_apply_record.information10 := p_post_record.information10;

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

3985: hr_utility.set_location(l_proc,10);
3986: -- removed following line in order to allow cascading of null values.
3987: -- If p_post_field is not null then
3988: hr_utility.set_location(l_proc,15);
3989: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3990: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3991: hr_utility.set_location(l_proc,20);
3992: p_apply_field := p_post_field;
3993: Else

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

3986: -- removed following line in order to allow cascading of null values.
3987: -- If p_post_field is not null then
3988: hr_utility.set_location(l_proc,15);
3989: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3990: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3991: hr_utility.set_location(l_proc,20);
3992: p_apply_field := p_post_field;
3993: Else
3994: p_result := FALSE;

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

4290: l_sf52_field := p_sf52_field;
4291: l_changed_boo := p_changed;
4292: --
4293: if (p_refresh_field is not null) then
4294: If (p_refresh_field <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4295: if (nvl(p_shadow_field,hr_api.g_varchar2) = nvl(p_sf52_field,hr_api.g_varchar2)) then
4296: p_shadow_field := p_refresh_field;
4297: p_sf52_field := p_refresh_field;
4298: l_changed := TRUE;

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

4291: l_changed_boo := p_changed;
4292: --
4293: if (p_refresh_field is not null) then
4294: If (p_refresh_field <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4295: if (nvl(p_shadow_field,hr_api.g_varchar2) = nvl(p_sf52_field,hr_api.g_varchar2)) then
4296: p_shadow_field := p_refresh_field;
4297: p_sf52_field := p_refresh_field;
4298: l_changed := TRUE;
4299: p_changed := TRUE;

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

4304: -- Currently functionality is limited to copying UE and APUE which have been changed by the
4305: -- user to refresh rg.
4306: -- It is not refreshing the shadoe and sf52 RGs
4307: --
4308: if (nvl(p_shadow_field,hr_api.g_varchar2) <> nvl(p_sf52_field,hr_api.g_varchar2)) then
4309: p_refresh_field := p_sf52_field;
4310: l_changed := TRUE;
4311: else
4312: -- ie. either field is AP or APUE and user did not change it.

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

4732: -- so, if part_time_hours was not changed by cascade_pa_req_field and the refresh value for
4733: -- PTH is null, then we need to handle the cascade here.
4734: if (not l_changed and p_rfrsh_rec.part_time_hours is null) then
4735: If (p_sf52_rec.part_time_hours is not null) then
4736: if (nvl(p_shadow_rec.part_time_hours,hr_api.g_number) = nvl(p_sf52_rec.part_time_hours,hr_api.g_number)) then
4737: p_changed := TRUE;
4738: p_shadow_rec.part_time_hours := p_rfrsh_rec.part_time_hours;
4739: p_sf52_rec.part_time_hours := p_rfrsh_rec.part_time_hours;
4740: end if;