DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on HR_GENERAL

Line 3755: hr_general.end_of_time,

3751: p_entry_type,
3752: p_effective_start_date,
3753: p_effective_end_date,
3754: l_effective_date,
3755: hr_general.end_of_time,
3756: null,
3757: null,
3758: 'INSERT',
3759: p_target_entry_id,

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

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

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

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

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

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

Line 5590: v_entry_rec.effective_end_date = hr_general.end_of_time then

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

Line 8150: v_entry_rec.effective_end_date = hr_general.end_of_time then

8146: end if;
8147: return (true);
8148: --
8149: elsif p_dt_delete_mode in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE') and
8150: v_entry_rec.effective_end_date = hr_general.end_of_time then
8151: --
8152: return (false);
8153: --
8154: else

Line 8537: v_validation_end_date := hr_general.end_of_time;

8533: --
8534: v_validation_start_date := v_entry_rec.effective_end_date + 1;
8535: --
8536: if v_next_effective_end_date is null then
8537: v_validation_end_date := hr_general.end_of_time;
8538: else
8539: v_validation_end_date := v_next_effective_end_date;
8540: end if;
8541: --

Line 8545: v_validation_end_date := hr_general.end_of_time;

8541: --
8542: elsif v_dt_delete_mode = 'FUTURE_CHANGE' then
8543: --
8544: v_validation_start_date := v_entry_rec.effective_end_date + 1;
8545: v_validation_end_date := hr_general.end_of_time;
8546: --
8547: elsif v_dt_delete_mode = 'DELETE' then
8548: --
8549: v_validation_start_date := p_session_date + 1;

Line 8550: v_validation_end_date := hr_general.end_of_time;

8546: --
8547: elsif v_dt_delete_mode = 'DELETE' then
8548: --
8549: v_validation_start_date := p_session_date + 1;
8550: v_validation_end_date := hr_general.end_of_time;
8551: --
8552: elsif v_dt_delete_mode = 'ZAP' then
8553: --
8554: -- It may be illegal for users to purge entries, depending on

Line 8708: hr_general.end_of_time,

8704: and ee.effective_start_date = v_validation_start_date;
8705: --
8706: update pay_element_entries_f ee
8707: set ee.effective_end_date = decode(v_validation_end_date,
8708: hr_general.end_of_time,
8709: v_entry_rec.effective_end_date,
8710: v_validation_end_date),
8711: ee.updating_action_id = decode(ee.updating_action_type, 'U', ee.updating_action_id,
8712: null),