[Home] [Help]
PACKAGE: APPS.PAY_ZA_CALENDARS_PKG
Source
1 package pay_za_calendars_pkg AUTHID CURRENT_USER as
2 /* $Header: pyzapcal.pkh 120.2 2005/06/28 00:08:40 kapalani noship $ */
3 -- +======================================================================+
4 -- | Copyright (c) 1998 Oracle Corporation South Africa Ltd |
5 -- | Cape Town, Western Cape, South Africa |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 -- SQL Script File Name : pyzapcal.pkh
9 -- Description : This sql script seeds the za_pay_calendars
10 -- package for the ZA localisation. This package
11 -- creates the payroll calendars needed for ZA.
12 --
13 -- Change List:
14 -- ------------
15 --
16 -- Name Date Version Bug Text
17 -- -------------- ---------- ------- ------- ------------------------------
18 -- F. Loubser 4-SEP-98 110.0 Initial Version
19 -- A.Mills 20-APR-99 110.1 Changed package name and
20 -- main interface procedure
21 -- (create_calendar) so that
22 -- dynamic call from core code
23 -- (hr_payrolls) will work.
24 --
25 -- J.N. Louw 24-Aug-2000 115.0 Updated for ZAPatch11i.01
26 -- L.J. Kloppers 22-Nov-2000 115.1 Move History Section into Package
27 -- Ghanshyam 07-Jul-2002 115.0 Moved the contents from
28 -- $PER_TOP/patch/115/sql/hrzapcal.pkh
29 -- ========================================================================
30
31 procedure do
32 (
33 p_payroll_name varchar2,
34 p_effective_date date
35 );
36
37 procedure create_calendar
38 (
39 p_payroll_id in number,
40 p_first_end_date in date,
41 p_last_end_date in date,
42 p_proc_period_type in varchar2,
43 -- Parameters needed to call the core function add_multiple_of_base
44 p_base_period_type in varchar2,
45 p_multiple in number,
46 p_fpe_date in date
47 );
48
49 function retrieve_tax_year_start return varchar2;
50
51 function retrieve_fiscal_year_start
52 (
53 p_business_group_id in number
54 )
55 return date;
56
57 procedure create_za_payroll_month_ends
58 (
59 p_payroll_id in number,
60 p_first_end_date in date,
61 p_last_end_date in date,
62 p_fiscal_start_day in number,
63 -- Parameters needed to call the core function add_multiple_of_base
64 p_base_period_type in varchar2,
65 p_multiple in number,
66 p_fpe_date in date
67 );
68
69 function generate_fiscal_month_start
70 (
71 p_end_date in date,
72 p_fiscal_start_day in number
73 )
74 return date;
75
76 function next_lower_day
77 (
78 p_fiscal_start_day in number,
79 p_date in date
80 )
81 return date;
82
83 function add_multiple_of_base
84 (
85 p_target_date in date,
86 p_base_period_type in varchar2,
87 p_multiple in number,
88 p_fpe_date in date,
89 p_regular_pay_mode boolean default false,
90 p_pay_date_offset number default null
91 )
92 return date;
93
94 function next_semi_month
95 (
96 p_semi_month_date in date,
97 p_fpe_date in date
98 )
99 return date;
100
101 function prev_semi_month
102 (
103 p_semi_month_date in date,
104 p_fpe_date in date
105 )
106 return date;
107
108 procedure create_za_employee_tax_years
109 (
110 p_payroll_id in number,
111 p_first_end_date in date,
112 p_last_end_date in date,
113 p_tax_year_start in varchar2,
114 p_proc_period_type in varchar2
115 );
116
117 procedure create_za_employee_cal_years
118 (
119 p_payroll_id in number,
120 p_first_end_date in date,
121 p_last_end_date in date,
122 p_proc_period_type in varchar2
123 );
124
125 procedure create_za_tax_quarters
126 (
127 p_payroll_id in number,
128 p_first_end_date in date,
129 p_last_end_date in date
130 );
131
132 procedure create_za_period_numbers
133 (
134 p_payroll_id in number,
135 p_first_end_date in date,
136 p_last_end_date in date,
137 p_proc_period_type in varchar2
138 );
139
140 end pay_za_calendars_pkg;