1 package hr_us_accrual_plans AUTHID CURRENT_USER as
2 /* $Header: pyusaccr.pkh 120.2 2006/07/31 07:34:24 risgupta noship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1994 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Name : hr_us_accrual_plans
11 Filename : pyusaccr.pkh
12 Change List
13 -----------
14 Date Name Vers Bug No Description
15 ---- ---- ---- ------ -----------
16 26-JAN-95 hparicha 40.0 G1565 Vacation/Sick correlation
17 to Regular Pay - changes to
18 Calc Period Earns.
19 Also need separate fn to calc
20 Vac/Sick Pay as well as a fn
21 to check for entry of Vac/Sick
22 Hours against an accrual plan.
23 09-JUL-95 hparicha 40.1 282299 Determine when an asg is not
24 yet eligible to take time
25 against an accrual.
26 26-Feb-02 Rmonge 115.2 Added dbdrv commands, and
27 made the file gscc compliant.
28 03-Sep-03 Rmonge 115.5 Remove NOCOPY from IN arguments
29 Description: Functions and Procedures required for US implementation
30 of Accruals.
31 20-Sep-05 ghshanka 115.6 bug 4123194 deleted the functions calc_accrual_pay and
32 accrual_time_taken .
33 31-AUG-06 risgupta 115.7 5405255 obsoleted functions being re-added on request of US payroll
34 */
35
36
37
38 PROCEDURE get_accrual_ineligibility( p_iv_id IN NUMBER,
39 p_bg_id IN NUMBER,
40 p_asg_id IN NUMBER,
41 p_sess_date IN DATE,
42 p_eligible OUT NOCOPY VARCHAR2);
43 FUNCTION calc_accrual_pay ( p_bg_id IN NUMBER,
44 p_asg_id IN NUMBER,
45 p_eff_date IN DATE,
46 p_hours_taken IN NUMBER,
47 p_curr_rate IN NUMBER,
48 p_mode IN VARCHAR2) RETURN NUMBER;
49
50
51 FUNCTION accrual_time_taken ( p_bg_id IN NUMBER,
52 p_asg_id IN NUMBER,
53 p_eff_date IN DATE,
54 p_mode IN VARCHAR2) RETURN NUMBER;
55
56
57 END hr_us_accrual_plans;