DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on HR_AU_HOLIDAYS

Line 185: l_accrual_init_pre78 := (hr_au_holidays.get_leave_initialise

181: -- Bug #1942971 -- Start
182:
183: l_initialise_type := 'Leave Accrual Initialise' ;
184:
185: l_accrual_init_pre78 := (hr_au_holidays.get_leave_initialise
186: (p_assignment_id => p_assignment_id
187: ,p_accrual_plan_id => l_plan_id
188: ,p_calc_end_date => l_pre_16_aug_1978 - 1
189: ,p_initialise_type => l_initialise_type

Line 196: l_entitlement_init_pre78 := (hr_au_holidays.get_leave_initialise

192: ));
193:
194: l_initialise_type := 'Leave Entitlement Initialise' ;
195:
196: l_entitlement_init_pre78 := (hr_au_holidays.get_leave_initialise
197: (p_assignment_id => p_assignment_id
198: ,p_accrual_plan_id => l_plan_id
199: ,p_calc_end_date => l_pre_16_aug_1978 - 1
200: ,p_initialise_type => l_initialise_type

Line 275: l_accrual_init_post78 := (hr_au_holidays.get_leave_initialise

271:
272: -- Bug #1942971 -- Start
273: l_initialise_type := 'Leave Accrual Initialise' ;
274:
275: l_accrual_init_post78 := (hr_au_holidays.get_leave_initialise
276: (p_assignment_id => p_assignment_id
277: ,p_accrual_plan_id => l_plan_id
278: ,p_calc_end_date => l_post_17_aug_1993
279: ,p_initialise_type => l_initialise_type

Line 286: l_entitlement_init_post78 := (hr_au_holidays.get_leave_initialise

282: ));
283:
284: l_initialise_type := 'Leave Entitlement Initialise' ;
285:
286: l_entitlement_init_post78 := (hr_au_holidays.get_leave_initialise
287: (p_assignment_id => p_assignment_id
288: ,p_accrual_plan_id => l_plan_id
289: ,p_calc_end_date => l_post_17_aug_1993
290: ,p_initialise_type => l_initialise_type

Line 350: l_accrual_init_post93 := (hr_au_holidays.get_leave_initialise

346:
347: -- Bug #1942971 -- Start
348: l_initialise_type := 'Leave Accrual Initialise' ;
349:
350: l_accrual_init_post93 := (hr_au_holidays.get_leave_initialise
351: (p_assignment_id => p_assignment_id
352: ,p_accrual_plan_id => l_plan_id
353: ,p_calc_end_date => p_effective_date
354: ,p_initialise_type => l_initialise_type

Line 361: l_entitlement_init_post93 := (hr_au_holidays.get_leave_initialise

357: ));
358:
359: l_initialise_type := 'Leave Entitlement Initialise' ;
360:
361: l_entitlement_init_post93 := (hr_au_holidays.get_leave_initialise
362: (p_assignment_id => p_assignment_id
363: ,p_accrual_plan_id => l_plan_id
364: ,p_calc_end_date => p_effective_date
365: ,p_initialise_type => l_initialise_type

Line 583: -- of hr_au_holidays equivalent except that when no accrual

579: --
580: -- RETURNS: accrual_plan_id if successful, 0 otherwise
581: --
582: -- PURPOSE: To retrieve accrual plan id for designated category, copy
583: -- of hr_au_holidays equivalent except that when no accrual
584: -- plan is found return 0, this is to allow for casual employees
585: -- who do not have accrual plans and are not supposed to be paid
586: -- for such on termination.
587: --

Line 595: -- hr_au_holidays

591: -- OUT:
592: --
593: --
594: -- USES: hr_utility
595: -- hr_au_holidays
596: --
597: function get_accrual_plan_by_category
598: (p_assignment_id in number
599: ,p_effective_date in date

Line 675: -- hr_au_holidays

671: -- OUT:
672: --
673: --
674: -- USES: hr_utility
675: -- hr_au_holidays
676: --
677: function calculate_marginal_tax
678: ( p_date_earned in date
679: , p_tax_variation_type in varchar2

Line 913: -- hr_au_holidays

909: -- p_post30jun1983_ratio - ratio to use when calculating the post 30 June 1983 portion of ETP
910: --
911: -- USES: hr_utility
912: -- fffunc
913: -- hr_au_holidays
914: --
915: function etp_prepost_ratios
916: (p_assignment_id in number
917: ,p_hire_date in date

Line 1087: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);

1083: p_pre01jul1983_days := 0;
1084: p_pre01jul1983_ratio := 0;
1085: p_post30jun1983_ratio := 1;
1086: l_days_worked_post := fffunc.days_between(p_termination_date, l_calculation_date);
1087: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1088: p_post30jun1983_days := l_days_worked_post - l_days_suspended_post;
1089: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1090: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/
1091: if l_calc_date_entered = 'Y' then

Line 1107: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);

1103: p_post30jun1983_days := 0;
1104: p_post30jun1983_ratio := 0;
1105: p_pre01jul1983_ratio := 1;
1106: l_days_worked_pre := fffunc.days_between(p_termination_date, l_calculation_date);
1107: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1108: p_pre01jul1983_days := l_days_worked_pre - l_days_suspended_pre;
1109: p_etp_service_date := l_calculation_date; /* Bug# 2984390 */
1110: /* Bug 4177679 Only if the calculation date is entered then the p_le_etp_service_date will be passed*/
1111: if l_calc_date_entered = 'Y' then

Line 1128: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);

1124: l_days_worked_total := fffunc.days_between(p_termination_date, l_calculation_date) + 1;
1125: --
1126: -- How many of these days were suspended without pay for pre, post and total
1127: --
1128: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);
1129: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_post_date, p_termination_date);
1130: l_days_suspended_total := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1131: --
1132: l_actual_pre := l_days_worked_pre - l_days_suspended_pre;

Line 1129: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_post_date, p_termination_date);

1125: --
1126: -- How many of these days were suspended without pay for pre, post and total
1127: --
1128: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);
1129: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_post_date, p_termination_date);
1130: l_days_suspended_total := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1131: --
1132: l_actual_pre := l_days_worked_pre - l_days_suspended_pre;
1133: l_actual_post := l_days_worked_post - l_days_suspended_post;

Line 1130: l_days_suspended_total := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);

1126: -- How many of these days were suspended without pay for pre, post and total
1127: --
1128: l_days_suspended_pre := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, l_pre_date);
1129: l_days_suspended_post := hr_au_holidays.days_suspended(p_assignment_id, l_post_date, p_termination_date);
1130: l_days_suspended_total := hr_au_holidays.days_suspended(p_assignment_id, l_calculation_date, p_termination_date);
1131: --
1132: l_actual_pre := l_days_worked_pre - l_days_suspended_pre;
1133: l_actual_post := l_days_worked_post - l_days_suspended_post;
1134: l_actual_total := l_days_worked_total - l_days_suspended_total;

Line 1744: l_hours := l_hours + hr_au_holidays.get_net_accrual(p_assignment_id,p_payroll_id,

1740: if csr1.accrual_units_of_measure = 'D' and l_days_flag='N' then
1741: l_days_flag := 'Y';
1742: end if;
1743:
1744: l_hours := l_hours + hr_au_holidays.get_net_accrual(p_assignment_id,p_payroll_id,
1745: p_business_group_id, csr1.accrual_plan_id,p_effective_date);
1746: end loop;
1747:
1748: IF l_error = 'Y'