[Home] [Help]
1: package body pay_us_pto_accrual as
2: /* $Header: pyusptoa.pkb 120.1 2005/10/04 03:38:12 schauhan noship $
3: ******************************************************************
4: * *
5: * Copyright (C) 1993 Oracle Corporation. *
14: * the express written permission of Oracle Corporation, *
15: * 500 Oracle Parkway, Redwood City, CA, 94065. *
16: * *
17: ******************************************************************
18: Name : pay_us_pto_accrual
19: Description : This package holds building blocks used in PTO accrual
20: calculation.
21: Uses : hr_utility
22: Change List
86: -- Private PL/SQL table to cache a list of accrual plans.
87: --
88: TYPE per_plans IS TABLE OF BOOLEAN INDEX BY binary_integer;
89: g_plan_list per_plans;
90: g_package VARCHAR2(30) := 'pay_us_pto_accrual.';
91:
92: --
93: ------------------------- delete_plan_from_cache ----------------------------
94: --
200: --
201: BEGIN
202: --
203:
204: pay_us_pto_accrual.accrual_calc_detail(
205: P_assignment_id => P_assignment_id,
206: P_calculation_date => c_date,
207: P_plan_id => P_plan_id,
208: P_plan_category => P_plan_category,
790: l_plan_accrual := 0;
791: ELSE
792: --
793: hr_utility.set_location('get_accrual_for_plan',90);
794: pay_us_pto_accrual.get_accrual_for_plan
795: ( p_plan_id => l_acc_plan_type_id,
796: p_first_p_start_date => p_param_first_pstdt,
797: p_first_p_end_date => p_param_first_pendt,
798: p_first_calc_P_number => p_param_first_pnum,
1363: -- is significantly faster than executing Fast Formula.
1364: --
1365: hr_utility.set_location(l_proc, 20);
1366:
1367: pay_us_pto_accrual.net_accruals(
1368: P_assignment_id => P_assignment_id,
1369: P_calculation_date => c_date,
1370: P_plan_id => P_plan_id,
1371: P_plan_category => P_plan_category,
1480: --
1481: -- Get vaction accrued
1482: --
1483: hr_utility.set_location('get_net_accrual',5);
1484: pay_us_pto_accrual.accrual_calc_detail(
1485: P_assignment_id => P_assignment_id,
1486: P_calculation_date => P_calculation_date,
1487: P_plan_id => P_plan_id,
1488: P_plan_category => P_plan_category,
1538: --
1539: --
1540: END net_accruals;
1541: --
1542: END pay_us_pto_accrual;