[Home] [Help]
PACKAGE: APPS.PAY_NZ_LEAVE_LIABILITY
Source
1 package pay_nz_leave_liability AUTHID CURRENT_USER as
2 -- $Header: pynzllal.pkh 115.4 2002/12/03 05:13:48 srrajago ship $
3
4 -- Copyright (C) 1999 Oracle Corporation
5 -- All Rights Reserved
6 --
7 -- Script to create NZ HRMS leave liability package.
8 --
9 -- Change List
10 -- ===========
11 --
12 -- Date Author Reference Description
13 -- -----------+--------+---------+-------------
14 -- 29 NOV 1999 JTURNER N/A Created
15 -- 29 SEP 2000 RAYYADEv N/A 1420851
16 -- 30 JUL 2001 rbsinha 1422001 added function retrieve_variable
17 -- 29 AUG 2002 vgsriniv 2514562 Added dbdrv commands
18 -- 03 DEC 2002 srrajago 2689221 Included 'nocopy' option for the 'out'
19 -- parameters of all the procedures.
20 -----------------------------------------------------------------------------
21 -- range_code procedure
22 -----------------------------------------------------------------------------
23
24 procedure range_code
25 (p_payroll_action_id in number
26 ,p_sql out nocopy varchar2) ;
27
28 -----------------------------------------------------------------------------
29 -- assignment_action_code procedure
30 -----------------------------------------------------------------------------
31
32 procedure assignment_action_code
33 (p_payroll_action_id in number
34 ,p_start_person_id in number
35 ,p_end_person_id in number
36 ,p_chunk in number) ;
37
38 -----------------------------------------------------------------------------
39 -- initialization_code procedure
40 -----------------------------------------------------------------------------
41
42 procedure initialization_code
43 (p_payroll_action_id in number) ;
44
45 -----------------------------------------------------------------------------
46 -- archive_code procedure
47 -----------------------------------------------------------------------------
48
49 procedure archive_code
50 (p_assignment_action_id in number
51 ,p_effective_date in date) ;
52
53 -----------------------------------------------------------------------------
54 -- hourly_rate procedure
55 -----------------------------------------------------------------------------
56
57 procedure hourly_rate ;
58 procedure leave_net_accrual
59 (p_assignment_id IN NUMBER
60 ,p_payroll_id IN NUMBER
61 ,p_business_group_id IN NUMBER
62 ,p_plan_id IN NUMBER
63 ,p_calculation_date IN DATE
64 ,p_net_accrual OUT NOCOPY NUMBER
65 ,p_net_entitlement OUT NOCOPY NUMBER
66 ,p_calc_start_date OUT NOCOPY DATE
67 ,p_last_accrual OUT NOCOPY DATE
68 ,p_next_period_end OUT NOCOPY DATE) ;
69
70 -----------------------------------------------------------------------------
71 -- wrapper function to retrieve the variable values at run time
72 -----------------------------------------------------------------------------
73 function retrieve_variable(P_NAME IN VARCHAR2,
74 P_DATA_TYPE IN VARCHAR2) return varchar2 ;
75
76 end pay_nz_leave_liability ;