DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on HR_GENERAL

Line 3758: hr_general.end_of_time,

3754: p_entry_type,
3755: p_effective_start_date,
3756: p_effective_end_date,
3757: l_effective_date,
3758: hr_general.end_of_time,
3759: null,
3760: null,
3761: 'INSERT',
3762: p_target_entry_id,

Line 5260: or nvl (old_entry.date_earned, hr_general.end_of_time)

5256: -- or reason was updated
5257: or nvl (old_entry.reason,'x') <> nvl (p_new_entry.reason,'x')
5258: --
5259: -- or date_earned was updated
5260: or nvl (old_entry.date_earned, hr_general.end_of_time)
5261: <> nvl (p_new_entry.date_earned, hr_general.end_of_time)
5262: --
5263: -- or third party payee details were updated
5264: or nvl (old_entry.personal_payment_method_id, 0)

Line 5261: <> nvl (p_new_entry.date_earned, hr_general.end_of_time)

5257: or nvl (old_entry.reason,'x') <> nvl (p_new_entry.reason,'x')
5258: --
5259: -- or date_earned was updated
5260: or nvl (old_entry.date_earned, hr_general.end_of_time)
5261: <> nvl (p_new_entry.date_earned, hr_general.end_of_time)
5262: --
5263: -- or third party payee details were updated
5264: or nvl (old_entry.personal_payment_method_id, 0)
5265: <> nvl (p_new_entry.personal_payment_method_id, 0)

Line 5585: v_entry_rec.effective_end_date <> hr_general.end_of_time then

5581: -- UPDATE mode has been selected but there are future changes. Do a
5582: -- UPDATE_CHANGE_INSERT instead NB. this is the least destructive option.
5583: --
5584: elsif p_dt_update_mode = 'UPDATE' and
5585: v_entry_rec.effective_end_date <> hr_general.end_of_time then
5586: --
5587: p_dt_update_mode := 'UPDATE_CHANGE_INSERT';
5588: --
5589: -- UPDATE_CHANGE_INSERT or UPDATE_OVERRIDE mode has been selected but

Line 5593: v_entry_rec.effective_end_date = hr_general.end_of_time then

5589: -- UPDATE_CHANGE_INSERT or UPDATE_OVERRIDE mode has been selected but
5590: -- there are no changes in the future. Do an UPDATE instead.
5591: --
5592: elsif p_dt_update_mode in ('UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE') and
5593: v_entry_rec.effective_end_date = hr_general.end_of_time then
5594: --
5595: p_dt_update_mode := 'UPDATE';
5596: --
5597: end if;

Line 8166: v_entry_rec.effective_end_date = hr_general.end_of_time then

8162: end if;
8163: return (true);
8164: --
8165: elsif p_dt_delete_mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE') and
8166: v_entry_rec.effective_end_date = hr_general.end_of_time then
8167: --
8168: return (false);
8169: --
8170: else

Line 8567: v_validation_end_date := hr_general.end_of_time;

8563: --
8564: v_validation_start_date := v_entry_rec.effective_end_date + 1;
8565: --
8566: if v_next_effective_end_date is null then
8567: v_validation_end_date := hr_general.end_of_time;
8568: else
8569: v_validation_end_date := v_next_effective_end_date;
8570: end if;
8571: --

Line 8575: v_validation_end_date := hr_general.end_of_time;

8571: --
8572: elsif v_dt_delete_mode = 'FUTURE_CHANGE' then
8573: --
8574: v_validation_start_date := v_entry_rec.effective_end_date + 1;
8575: v_validation_end_date := hr_general.end_of_time;
8576: --
8577: elsif v_dt_delete_mode = 'DELETE' then
8578: --
8579: v_validation_start_date := p_session_date + 1;

Line 8580: v_validation_end_date := hr_general.end_of_time;

8576: --
8577: elsif v_dt_delete_mode = 'DELETE' then
8578: --
8579: v_validation_start_date := p_session_date + 1;
8580: v_validation_end_date := hr_general.end_of_time;
8581: --
8582: elsif v_dt_delete_mode = 'ZAP' then
8583: --
8584: -- It may be illegal for users to purge entries, depending on

Line 8764: hr_general.end_of_time,

8760: and ee.effective_start_date = v_validation_start_date;
8761: --
8762: update pay_element_entries_f ee
8763: set ee.effective_end_date = decode(v_validation_end_date,
8764: hr_general.end_of_time,
8765: v_entry_rec.effective_end_date,
8766: v_validation_end_date),
8767: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
8768: null),