[Home] [Help]
PACKAGE: APPS.HR_PPVOL
Source
1 package hr_ppvol AUTHID CURRENT_USER as
2 /* $Header: pyvpymnt.pkh 120.0 2006/03/06 04:27:55 pgongada noship $ */
3 --
4 /*
5 -- Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
6 /*
7 PRODUCT
8 Oracle*Payroll
9 --
10 NAME
11 pyvpymnt.pkh
12 MODIFIED (DD-MON-YYYY)
13 mwcallag 29-SEP-1993 - Cash analysis parameter removed, following change
14 to pay_org_payment_methods_f in CASE.
15 WMcVeagh 19-mar-98 Change create or replace 'as' not 'is'
16 */
17
18 --
19 --------------------------- ins_opm -----------------------------------
20 /*
21 NAME
22 ins_opm
23 DESCRIPTION
24 Function to insert an Org_payment_method.
25 NOTES
26 Called using...
27 --
28 opm_id := ins_opm(to_date(start,'DD-MON-YYYY'),
29 to_date(end,'DD-MON-YYYY'),
30 bg_id,
31 exa_id,
32 currency,
33 payment_type,
34 name);
35 --
36 if opm_id = 0 then
37 --
38 err_msg := 'Cannot insert OPM ' || name;
39 hr_utility.raise_error(err_msg);
40 --
41 end if;
42 */
43 function ins_opm(effective_start_date in date,
44 effective_end_date in date,
45 p_business_group_id in number,
46 external_account_id in number,
47 currency_code in varchar2,
48 payment_type_id in number,
49 name in varchar2) return number;
50 --
51 --------------------------- ins_exa -----------------------------------
52 /*
53 NAME
54 ins_exa
55 DESCRIPTION
56 insert an external account
57 NOTES
58 Called as...
59 --
60 account_id := ins_exa(territory);
61 --
62 if account_id = 0 then
63 --
64 err_msg := 'Error inserting account in territory ' || territory;
65 hr_utility.raise_error(err_msg);
66 --
67 end if;
68 --
69 */
70 --
71 function ins_exa(territory_code in varchar2) return number;
72 --
73 --------------------------- ins_pmu -----------------------------------
74 /*
75 NAME
76 ins_pmu
77 DESCRIPTION
78 Insert pay_method_usages
79 NOTES
80 Called as
81 --
82 pmu := ins_pmu(to_date(start,'DD-MON-YYYY'),
83 to_date(end,'DD-MON-YYYY'),
84 payroll_id,
85 opm_id);
86 --
87 if pmu = 0 then
88 --
89 err_msg := 'Failed to insert PMU for payroll ' || payroll;
90 err_msg := err_msg || ' and method ' ||method;
91 hr_utility.raise_error(err_msg);
92 --
93 end if;
94 */
95 --
96 function ins_pmu(start_date in date,
97 end_date in date,
98 payroll in number,
99 payment_method in number) return number;
100 --
101 --------------------------- ins_ppm -----------------------------------
102 /*
103 NAME
104 ins_ppm
105 DESCRIPTION
106 insert personal payment method
107 NOTES
108 Call as...
109 --
110 ppm_id := ins_ppm(to_date(start,'DD-MON-YYYY'),
111 to_date(end,'DD-MON-YYYY'),
112 bg_id,
113 account,
114 assignment,
115 opm_id,
116 amount,
117 percentage,
118 priority);
119 --
120 if ppm_id = 0 then
121 --
122 err_msg := failed to insert PPM for OPM ' || opm_id;
123 err_msg := err_msg || ' and Assignment ' || assignment;
124 err_msg := err_msg || ' priority ' || priority;
125 hr_utility.raise_error(err_msg);
126 */
127 --
128 function ins_ppm(start_date in date,
129 end_date in date,
130 business_group_id in number,
131 external_account in number,
132 assignment_id in number,
133 opm_id in number,
134 amount in number,
135 percentage in number,
136 priority in number) return number;
137 --
138 --------------------------- ins_exr -----------------------------------
139 /*
140 NAME
141 ins_exr
142 DESCRIPTION
143 insert exchaneg rates to and from two currencies
144 NOTES
145 --
146 */
147 --
148 function ins_exr(start_date in date,
149 end_date in date,
150 base_currency in varchar2,
151 other_currency in varchar2,
152 rate_type in varchar2 default 'Payroll',
153 rate in number,
154 inverse_rate in number) return number;
155 --
156 --------------------------- ins_ppa -----------------------------------
157 /*
158 NAME
159 ins_ppa
160 DESCRIPTION
161 insert payroll action
162 NOTES
163 Fill in other params as required, but do not default!
164 */
165 function ins_ppa(action_type varchar2,
166 business_group number,
167 consolidation_set number,
168 payroll number,
169 pop_status varchar2,
170 action_status varchar2,
171 action_date date,
172 parameters varchar2) return number;
173 --
174 --------------------------- ins_paa -----------------------------------
175 /*
176 NAME
177 ins_paa
178 DESCRIPTION
179 insert assignment_actions
180 NOTES
181 --
182 */
183 --
184 function ins_paa(assignment number,
185 payroll_action number,
186 status varchar2 default 'U',
187 chunk number default null,
188 sequence number default null,
189 pre_payment number default null,
190 serial_no varchar2 default null) return number;
191 --
192 --------------------------- ins_payroll -----------------------------------
193 /*
194 NAME
195 ins_payroll
196 DESCRIPTION
197 insert a payroll
198 NOTES
199 Note that pay_db_pay_setup.create_payroll should be used. This is just a
200 temporary measure
201 */
202 FUNCTION ins_payroll(payroll_name varchar2,
203 number_of_years number,
204 period_type varchar2,
205 first_period_end_date date,
206 dflt_payment_method number,
207 pay_date_offset number default 0,
208 direct_deposit_date_offset number default 0,
209 pay_advice_date_offset number default 0,
210 cut_off_date_offset number default 0,
211 consolidation_set number,
212 negative_pay_allowed_flag varchar2 default 'N',
213 organization number default NULL,
214 midpoint_offset number default 0,
215 workload_shifting_level varchar2 default 'N',
216 effective_start_date date,
217 effective_end_date date,
218 business_group number) RETURN number;
219 --
220 --------------------------- testpay -----------------------------------
221 /*
222 NAME
223 testpay
224 DESCRIPTION
225 Set up data for payments testing.
226 NOTES
227 --
228 */
229 procedure testpay(p_business_group in varchar2);
230 --
231 end hr_ppvol;