1 PACKAGE HXT_TIMECARD_API AUTHID CURRENT_USER AS
2 /* $Header: hxttapi.pkh 115.6 2002/11/28 01:38:46 fassadi ship $ */
3
4 PROCEDURE obtain_accrual_balance(--HXT11i1 i_employee_number IN VARCHAR2,
5 i_employee_id IN NUMBER, --HXT11i1
6 i_calculation_date IN DATE,
7 i_accrual_plan_name IN VARCHAR2,
8 o_net_accrual OUT NOCOPY NUMBER,
9 o_otm_error OUT NOCOPY VARCHAR2,
10 o_oracle_error OUT NOCOPY VARCHAR2);
11
12 PROCEDURE accrual_plan_name (p_element_type_id IN NUMBER,
13 p_date_worked IN DATE,
14 p_assignment_id IN NUMBER,
15 o_accrual_plan_name OUT NOCOPY VARCHAR2,
16 o_return_code OUT NOCOPY NUMBER,
17 o_otm_error OUT NOCOPY VARCHAR2,
18 o_oracle_error OUT NOCOPY VARCHAR2);
19
20 PROCEDURE total_accrual_for_week(p_tim_id IN NUMBER
21 ,p_edit_date IN DATE
22 -- ,HXT11i1 p_empl_number IN VARCHAR2
23 ,p_empl_id IN NUMBER --HXT11i1
24 ,o_tot_hours OUT NOCOPY NUMBER
25 ,o_accrual_plan_name OUT NOCOPY VARCHAR2
26 ,o_return_code OUT NOCOPY NUMBER
27 ,o_otm_error OUT NOCOPY VARCHAR2
28 ,o_oracle_error OUT NOCOPY VARCHAR2
29 ,o_lookup_code OUT NOCOPY VARCHAR2);
30
31 END HXT_TIMECARD_API;