DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PER_US_EXTRA_ASSIGNMENT_RULES

Line 3482: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user

3478: -- is UPDATE_OVERRIDE and the location_id was passed as default value
3479: -- ie:hr_api.g_number. Reason for this is we should take the value of
3480: -- the location_id as of the effective date of the change and we must
3481: -- maintain the tax records. The value of
3482: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3483: -- hook (before) procedure to used for stored data.
3484: --
3485: if p_datetrack_mode = 'UPDATE_OVERRIDE' THEN
3486: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;

Line 3486: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;

3482: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3483: -- hook (before) procedure to used for stored data.
3484: --
3485: if p_datetrack_mode = 'UPDATE_OVERRIDE' THEN
3486: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;
3487: else
3488: l_location_id := p_location_id;
3489: end if;
3490: --

Line 4236: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location

4232: -- when we change the location on the assignment record and the location
4233: -- address resided in a different state.
4234: --
4235: -- bug 1168727 comparing the p_location_id to global
4236: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location
4237: -- id is same as the parameter location id then there is no need to update
4238: -- the tax records. PLEASE NOTE THAT THE GLOBAL IS DEFINE IN PACKAGE
4239: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.
4240: --

Line 4239: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.

4235: -- bug 1168727 comparing the p_location_id to global
4236: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location
4237: -- id is same as the parameter location id then there is no need to update
4238: -- the tax records. PLEASE NOTE THAT THE GLOBAL IS DEFINE IN PACKAGE
4239: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.
4240: --
4241: -- We will always attempt to process the location change is the date track
4242: -- mode is UPDATE_OVERRIDE.
4243: --

Line 4246: p_location_id = per_us_extra_assignment_rules.g_old_assgt_location then

4242: -- mode is UPDATE_OVERRIDE.
4243: --
4244: if p_datetrack_mode in ('CORRECTION', 'UPDATE',
4245: 'UPDATE_CHANGE_INSERT' ) and
4246: p_location_id = per_us_extra_assignment_rules.g_old_assgt_location then
4247: RAISE l_exit_quietly;
4248: end if;
4249: --
4250: if p_datetrack_mode in('CORRECTION', 'UPDATE',