[Home] [Help]
PACKAGE BODY: APPS.HR_CN_PERSONAL_PAY_METHOD_API
Source
1 PACKAGE BODY hr_cn_personal_pay_method_api AS
2 /* $Header: hrcnwrpm.pkb 120.1 2011/12/20 12:16:12 jmarupil ship $ */
3
4
5 --
6 g_package VARCHAR2(33) := 'hr_cn_personal_pay_method_api.';
7
8 --
9 -- ----------------------------------------------------------------------------
10 -- |--------------------< create_cn_personal_pay_method >---------------------|
11 -- ----------------------------------------------------------------------------
12 --
13 PROCEDURE create_cn_personal_pay_method
14 (p_validate IN BOOLEAN DEFAULT false
15 ,p_effective_date IN DATE
16 ,p_assignment_id IN NUMBER
17 ,p_org_payment_method_id IN NUMBER
18 ,p_amount IN NUMBER DEFAULT null
19 ,p_percentage IN NUMBER DEFAULT null
20 ,p_priority IN NUMBER DEFAULT null
21 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT null
22 ,p_attribute_category IN VARCHAR2 DEFAULT null
23 ,p_attribute1 IN VARCHAR2 DEFAULT null
24 ,p_attribute2 IN VARCHAR2 DEFAULT null
25 ,p_attribute3 IN VARCHAR2 DEFAULT null
26 ,p_attribute4 IN VARCHAR2 DEFAULT null
27 ,p_attribute5 IN VARCHAR2 DEFAULT null
28 ,p_attribute6 IN VARCHAR2 DEFAULT null
29 ,p_attribute7 IN VARCHAR2 DEFAULT null
30 ,p_attribute8 IN VARCHAR2 DEFAULT null
31 ,p_attribute9 IN VARCHAR2 DEFAULT null
32 ,p_attribute10 IN VARCHAR2 DEFAULT null
33 ,p_attribute11 IN VARCHAR2 DEFAULT null
34 ,p_attribute12 IN VARCHAR2 DEFAULT null
35 ,p_attribute13 IN VARCHAR2 DEFAULT null
36 ,p_attribute14 IN VARCHAR2 DEFAULT null
37 ,p_attribute15 IN VARCHAR2 DEFAULT null
38 ,p_attribute16 IN VARCHAR2 DEFAULT null
39 ,p_attribute17 IN VARCHAR2 DEFAULT null
40 ,p_attribute18 IN VARCHAR2 DEFAULT null
41 ,p_attribute19 IN VARCHAR2 DEFAULT null
42 ,p_attribute20 IN VARCHAR2 DEFAULT null
43 ,p_bank_name IN VARCHAR2
44 ,p_bank_branch IN VARCHAR2
45 ,p_bank_account_number IN VARCHAR2
46 ,p_concat_segments IN VARCHAR2 DEFAULT null
47 ,p_payee_type IN VARCHAR2 DEFAULT null
48 ,p_payee_id IN NUMBER DEFAULT null
49 ,p_personal_payment_method_id OUT NOCOPY NUMBER
50 ,p_external_account_id OUT NOCOPY NUMBER
51 ,p_object_version_number OUT NOCOPY NUMBER
52 ,p_effective_start_date OUT NOCOPY DATE
53 ,p_effective_end_date OUT NOCOPY DATE
54 ,p_comment_id out NOCOPY NUMBER
55 ) IS
56 --
57 -- Declare cursors and local variables
58 --
59 l_proc VARCHAR2(72) := g_package||'create_cn_personal_pay_method';
60
61 l_effective_date DATE;
62 --
63 BEGIN
64
65
66 hr_cn_api.set_location(g_trace, 'Entering:'|| l_proc, 10);
67
68 --
69 --
70 l_effective_date := trunc(p_effective_date);
71 --
72
73 hr_cn_api.check_assignment(p_assignment_id, 'CN',l_effective_date);
74
75 --
76 hr_cn_api.set_location(g_trace, l_proc, 20);
77 --
78 -- Call the business process to create the personal payment method
79 --
80 hr_personal_pay_method_api.create_personal_pay_method
81 (p_validate => p_validate
82 ,p_effective_date => l_effective_date
83 ,p_assignment_id => p_assignment_id
84 ,p_org_payment_method_id => p_org_payment_method_id
85 ,p_amount => p_amount
86 ,p_percentage => p_percentage
87 ,p_priority => p_priority
88 ,p_comments => p_comments
89 ,p_attribute_category => p_attribute_category
90 ,p_attribute1 => p_attribute1
91 ,p_attribute2 => p_attribute2
92 ,p_attribute3 => p_attribute3
93 ,p_attribute4 => p_attribute4
94 ,p_attribute5 => p_attribute5
95 ,p_attribute6 => p_attribute6
96 ,p_attribute7 => p_attribute7
97 ,p_attribute8 => p_attribute8
98 ,p_attribute9 => p_attribute9
99 ,p_attribute10 => p_attribute10
100 ,p_attribute11 => p_attribute11
101 ,p_attribute12 => p_attribute12
102 ,p_attribute13 => p_attribute13
103 ,p_attribute14 => p_attribute14
104 ,p_attribute15 => p_attribute15
105 ,p_attribute16 => p_attribute16
106 ,p_attribute17 => p_attribute17
107 ,p_attribute18 => p_attribute18
108 ,p_attribute19 => p_attribute19
109 ,p_attribute20 => p_attribute20
110 ,p_territory_code => 'CN'
111 ,p_segment1 => p_bank_name
112 ,p_segment2 => p_bank_branch
113 ,p_segment3 => p_bank_account_number
114 ,p_payee_type => p_payee_type
115 ,p_payee_id => p_payee_id
116 ,p_personal_payment_method_id => p_personal_payment_method_id
117 ,p_external_account_id => p_external_account_id
118 ,p_object_version_number => p_object_version_number
119 ,p_effective_start_date => p_effective_start_date
120 ,p_effective_end_date => p_effective_end_date
121 ,p_comment_id => p_comment_id
122 );
123 --
124 hr_cn_api.set_location(g_trace, 'Leaving:'|| l_proc, 30);
125
126 END create_cn_personal_pay_method;
127
128
129 -- ----------------------------------------------------------------------------
130 -- |--------------------< update_cn_personal_pay_method >---------------------|
131 -- ----------------------------------------------------------------------------
132 --
133 PROCEDURE update_cn_personal_pay_method
134 (p_validate IN BOOLEAN DEFAULT false
135 ,p_effective_date IN DATE
136 ,p_datetrack_update_mode IN VARCHAR2
137 ,p_personal_payment_method_id IN NUMBER
138 ,p_object_version_number IN OUT NOCOPY NUMBER
139 ,p_amount IN NUMBER DEFAULT hr_api.g_number
140 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
141 ,p_percentage IN NUMBER DEFAULT hr_api.g_number
142 ,p_priority IN NUMBER DEFAULT hr_api.g_number
143 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
144 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
145 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
146 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
147 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
148 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
149 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
150 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
151 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
152 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
153 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
154 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
155 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
156 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
157 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
158 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
159 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
160 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
161 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
162 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
163 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
164 ,p_bank_name IN VARCHAR2
165 ,p_bank_branch IN VARCHAR2
166 ,p_bank_account_number IN VARCHAR2
167 ,p_concat_segments IN VARCHAR2 DEFAULT null
168 ,p_payee_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
169 ,p_payee_id IN NUMBER DEFAULT hr_api.g_number
170 ,p_comment_id OUT NOCOPY NUMBER
171 ,p_external_account_id OUT NOCOPY NUMBER
172 ,p_effective_start_date OUT NOCOPY DATE
173 ,p_effective_end_date OUT NOCOPY DATE
174 ) IS
175 --
176 -- Declare cursors and local variables
177 --
178 l_proc VARCHAR2(72) := g_package||'update_cn_personal_pay_method';
179 l_effective_date DATE;
180 --
181 BEGIN
182
183 hr_cn_api.set_location(g_trace, 'Entering:'|| l_proc, 10);
184
185 --
186 --
187 l_effective_date := trunc(p_effective_date);
188 --
189
190 hr_cn_api.check_payment_method(p_personal_payment_method_id, l_effective_date,'CN');
191
192 --
193 hr_cn_api.set_location(g_trace, l_proc, 20);
194
195 --
196 -- Call the business process to update the personal payment method
197 --
198 hr_personal_pay_method_api.update_personal_pay_method
199 (p_validate => p_validate
200 ,p_effective_date => l_effective_date
201 ,p_datetrack_update_mode => p_datetrack_update_mode
202 ,p_personal_payment_method_id => p_personal_payment_method_id
203 ,p_object_version_number => p_object_version_number
204 ,p_amount => p_amount
205 ,p_comments => p_comments
206 ,p_percentage => p_percentage
207 ,p_priority => p_priority
208 ,p_attribute_category => p_attribute_category
209 ,p_attribute1 => p_attribute1
210 ,p_attribute2 => p_attribute2
211 ,p_attribute3 => p_attribute3
212 ,p_attribute4 => p_attribute4
213 ,p_attribute5 => p_attribute5
214 ,p_attribute6 => p_attribute6
215 ,p_attribute7 => p_attribute7
216 ,p_attribute8 => p_attribute8
217 ,p_attribute9 => p_attribute9
218 ,p_attribute10 => p_attribute10
219 ,p_attribute11 => p_attribute11
220 ,p_attribute12 => p_attribute12
221 ,p_attribute13 => p_attribute13
222 ,p_attribute14 => p_attribute14
223 ,p_attribute15 => p_attribute15
224 ,p_attribute16 => p_attribute16
225 ,p_attribute17 => p_attribute17
226 ,p_attribute18 => p_attribute18
227 ,p_attribute19 => p_attribute19
228 ,p_attribute20 => p_attribute20
229 ,p_territory_code => 'CN'
230 ,p_segment1 => p_bank_name
231 ,p_segment2 => p_bank_branch
232 ,p_segment3 => p_bank_account_number
233 ,p_concat_segments => p_concat_segments
234 ,p_payee_type => p_payee_type
235 ,p_payee_id => p_payee_id
236 ,p_comment_id => p_comment_id
237 ,p_external_account_id => p_external_account_id
238 ,p_effective_start_date => p_effective_start_date
239 ,p_effective_end_date => p_effective_end_date
240 );
241 --
242 hr_cn_api.set_location(g_trace, 'Leaving: '||l_proc, 30);
243
244 END update_cn_personal_pay_method;
245
246 END hr_cn_personal_pay_method_api;