DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_ORGANIZATION_BK4

Source


1 package body HR_ORGANIZATION_BK4 as
2 /* $Header: hrorgapi.pkb 120.10.12010000.7 2008/09/30 06:39:43 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:53:43 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_ORGANIZATION_A
6 (P_EFFECTIVE_DATE in DATE
7 ,P_LANGUAGE_CODE in VARCHAR2
8 ,P_NAME in VARCHAR2
9 ,P_ORGANIZATION_ID in NUMBER
10 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
11 ,P_LOCATION_ID in NUMBER
12 ,P_DATE_FROM in DATE
13 ,P_DATE_TO in DATE
14 ,P_INTERNAL_EXTERNAL_FLAG in VARCHAR2
15 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
16 ,P_TYPE in VARCHAR2
17 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
18 ,P_ATTRIBUTE1 in VARCHAR2
19 ,P_ATTRIBUTE2 in VARCHAR2
20 ,P_ATTRIBUTE3 in VARCHAR2
21 ,P_ATTRIBUTE4 in VARCHAR2
22 ,P_ATTRIBUTE5 in VARCHAR2
23 ,P_ATTRIBUTE6 in VARCHAR2
24 ,P_ATTRIBUTE7 in VARCHAR2
25 ,P_ATTRIBUTE8 in VARCHAR2
26 ,P_ATTRIBUTE9 in VARCHAR2
27 ,P_ATTRIBUTE10 in VARCHAR2
28 ,P_ATTRIBUTE11 in VARCHAR2
29 ,P_ATTRIBUTE12 in VARCHAR2
30 ,P_ATTRIBUTE13 in VARCHAR2
31 ,P_ATTRIBUTE14 in VARCHAR2
32 ,P_ATTRIBUTE15 in VARCHAR2
33 ,P_ATTRIBUTE16 in VARCHAR2
34 ,P_ATTRIBUTE17 in VARCHAR2
35 ,P_ATTRIBUTE18 in VARCHAR2
36 ,P_ATTRIBUTE19 in VARCHAR2
37 ,P_ATTRIBUTE20 in VARCHAR2
38 ,P_ATTRIBUTE21 in VARCHAR2
39 ,P_ATTRIBUTE22 in VARCHAR2
40 ,P_ATTRIBUTE23 in VARCHAR2
41 ,P_ATTRIBUTE24 in VARCHAR2
42 ,P_ATTRIBUTE25 in VARCHAR2
43 ,P_ATTRIBUTE26 in VARCHAR2
44 ,P_ATTRIBUTE27 in VARCHAR2
45 ,P_ATTRIBUTE28 in VARCHAR2
46 ,P_ATTRIBUTE29 in VARCHAR2
47 ,P_ATTRIBUTE30 in VARCHAR2
48 ,P_SEGMENT1 in VARCHAR2
49 ,P_SEGMENT2 in VARCHAR2
50 ,P_SEGMENT3 in VARCHAR2
51 ,P_SEGMENT4 in VARCHAR2
52 ,P_SEGMENT5 in VARCHAR2
53 ,P_SEGMENT6 in VARCHAR2
54 ,P_SEGMENT7 in VARCHAR2
55 ,P_SEGMENT8 in VARCHAR2
56 ,P_SEGMENT9 in VARCHAR2
57 ,P_SEGMENT10 in VARCHAR2
58 ,P_SEGMENT11 in VARCHAR2
59 ,P_SEGMENT12 in VARCHAR2
60 ,P_SEGMENT13 in VARCHAR2
61 ,P_SEGMENT14 in VARCHAR2
62 ,P_SEGMENT15 in VARCHAR2
63 ,P_SEGMENT16 in VARCHAR2
64 ,P_SEGMENT17 in VARCHAR2
65 ,P_SEGMENT18 in VARCHAR2
66 ,P_SEGMENT19 in VARCHAR2
67 ,P_SEGMENT20 in VARCHAR2
68 ,P_SEGMENT21 in VARCHAR2
69 ,P_SEGMENT22 in VARCHAR2
70 ,P_SEGMENT23 in VARCHAR2
71 ,P_SEGMENT24 in VARCHAR2
72 ,P_SEGMENT25 in VARCHAR2
73 ,P_SEGMENT26 in VARCHAR2
74 ,P_SEGMENT27 in VARCHAR2
75 ,P_SEGMENT28 in VARCHAR2
76 ,P_SEGMENT29 in VARCHAR2
77 ,P_SEGMENT30 in VARCHAR2
78 ,P_CONCAT_SEGMENTS in VARCHAR2
79 ,P_COST_NAME in VARCHAR2
80 ,P_OBJECT_VERSION_NUMBER in NUMBER
81 ,P_DUPLICATE_ORG_WARNING in BOOLEAN
82 )is
83 l_commit_unit_number number;
84 l_legislation_code   varchar2(30);
85 begin
86 hr_utility.set_location('Entering: HR_ORGANIZATION_BK4.UPDATE_ORGANIZATION_A', 10);
87 l_commit_unit_number := hr_api.return_commit_unit;
88 if hr_api.call_app_hooks then
89 BEN_CHECK_ORGANIZATION.CHK_ORG_ROLE_BNF_UPD
90 (P_ORGANIZATION_ID => P_ORGANIZATION_ID
91 ,P_DATE_FROM => P_DATE_FROM
92 ,P_DATE_TO => P_DATE_TO
93 );
94 hr_organization_be4.UPDATE_ORGANIZATION_A
95 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
96 ,P_LANGUAGE_CODE => P_LANGUAGE_CODE
97 ,P_NAME => P_NAME
98 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
99 ,P_COST_ALLOCATION_KEYFLEX_ID => P_COST_ALLOCATION_KEYFLEX_ID
100 ,P_LOCATION_ID => P_LOCATION_ID
101 ,P_DATE_FROM => P_DATE_FROM
102 ,P_DATE_TO => P_DATE_TO
103 ,P_INTERNAL_EXTERNAL_FLAG => P_INTERNAL_EXTERNAL_FLAG
104 ,P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE
105 ,P_TYPE => P_TYPE
106 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
107 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
108 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
109 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
110 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
111 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
112 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
113 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
114 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
115 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
116 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
117 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
118 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
119 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
120 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
121 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
122 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
123 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
124 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
125 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
126 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
127 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
128 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
129 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
130 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
131 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
132 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
133 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
134 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
135 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
136 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
137 ,P_SEGMENT1 => P_SEGMENT1
138 ,P_SEGMENT2 => P_SEGMENT2
139 ,P_SEGMENT3 => P_SEGMENT3
140 ,P_SEGMENT4 => P_SEGMENT4
141 ,P_SEGMENT5 => P_SEGMENT5
142 ,P_SEGMENT6 => P_SEGMENT6
143 ,P_SEGMENT7 => P_SEGMENT7
144 ,P_SEGMENT8 => P_SEGMENT8
145 ,P_SEGMENT9 => P_SEGMENT9
146 ,P_SEGMENT10 => P_SEGMENT10
147 ,P_SEGMENT11 => P_SEGMENT11
148 ,P_SEGMENT12 => P_SEGMENT12
149 ,P_SEGMENT13 => P_SEGMENT13
150 ,P_SEGMENT14 => P_SEGMENT14
151 ,P_SEGMENT15 => P_SEGMENT15
152 ,P_SEGMENT16 => P_SEGMENT16
153 ,P_SEGMENT17 => P_SEGMENT17
154 ,P_SEGMENT18 => P_SEGMENT18
155 ,P_SEGMENT19 => P_SEGMENT19
156 ,P_SEGMENT20 => P_SEGMENT20
157 ,P_SEGMENT21 => P_SEGMENT21
158 ,P_SEGMENT22 => P_SEGMENT22
159 ,P_SEGMENT23 => P_SEGMENT23
160 ,P_SEGMENT24 => P_SEGMENT24
161 ,P_SEGMENT25 => P_SEGMENT25
162 ,P_SEGMENT26 => P_SEGMENT26
163 ,P_SEGMENT27 => P_SEGMENT27
164 ,P_SEGMENT28 => P_SEGMENT28
165 ,P_SEGMENT29 => P_SEGMENT29
166 ,P_SEGMENT30 => P_SEGMENT30
167 ,P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS
168 ,P_COST_NAME => P_COST_NAME
169 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
170 ,P_DUPLICATE_ORG_WARNING => P_DUPLICATE_ORG_WARNING
171 );
172 end if;
173 hr_multi_message.end_validation_set;
174 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_ORGANIZATION', 'AP');
175 hr_utility.set_location(' Leaving: HR_ORGANIZATION_BK4.UPDATE_ORGANIZATION_A', 20);
176 end UPDATE_ORGANIZATION_A;
177 procedure UPDATE_ORGANIZATION_B
178 (P_EFFECTIVE_DATE in DATE
179 ,P_LANGUAGE_CODE in VARCHAR2
180 ,P_NAME in VARCHAR2
181 ,P_ORGANIZATION_ID in NUMBER
182 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
183 ,P_LOCATION_ID in NUMBER
184 ,P_DATE_FROM in DATE
185 ,P_DATE_TO in DATE
186 ,P_INTERNAL_EXTERNAL_FLAG in VARCHAR2
187 ,P_INTERNAL_ADDRESS_LINE in VARCHAR2
188 ,P_TYPE in VARCHAR2
189 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
190 ,P_ATTRIBUTE1 in VARCHAR2
191 ,P_ATTRIBUTE2 in VARCHAR2
192 ,P_ATTRIBUTE3 in VARCHAR2
193 ,P_ATTRIBUTE4 in VARCHAR2
194 ,P_ATTRIBUTE5 in VARCHAR2
195 ,P_ATTRIBUTE6 in VARCHAR2
196 ,P_ATTRIBUTE7 in VARCHAR2
197 ,P_ATTRIBUTE8 in VARCHAR2
198 ,P_ATTRIBUTE9 in VARCHAR2
199 ,P_ATTRIBUTE10 in VARCHAR2
200 ,P_ATTRIBUTE11 in VARCHAR2
201 ,P_ATTRIBUTE12 in VARCHAR2
202 ,P_ATTRIBUTE13 in VARCHAR2
203 ,P_ATTRIBUTE14 in VARCHAR2
204 ,P_ATTRIBUTE15 in VARCHAR2
205 ,P_ATTRIBUTE16 in VARCHAR2
206 ,P_ATTRIBUTE17 in VARCHAR2
207 ,P_ATTRIBUTE18 in VARCHAR2
208 ,P_ATTRIBUTE19 in VARCHAR2
209 ,P_ATTRIBUTE20 in VARCHAR2
210 ,P_ATTRIBUTE21 in VARCHAR2
211 ,P_ATTRIBUTE22 in VARCHAR2
212 ,P_ATTRIBUTE23 in VARCHAR2
213 ,P_ATTRIBUTE24 in VARCHAR2
214 ,P_ATTRIBUTE25 in VARCHAR2
215 ,P_ATTRIBUTE26 in VARCHAR2
216 ,P_ATTRIBUTE27 in VARCHAR2
217 ,P_ATTRIBUTE28 in VARCHAR2
218 ,P_ATTRIBUTE29 in VARCHAR2
219 ,P_ATTRIBUTE30 in VARCHAR2
220 ,P_SEGMENT1 in VARCHAR2
221 ,P_SEGMENT2 in VARCHAR2
222 ,P_SEGMENT3 in VARCHAR2
223 ,P_SEGMENT4 in VARCHAR2
224 ,P_SEGMENT5 in VARCHAR2
225 ,P_SEGMENT6 in VARCHAR2
226 ,P_SEGMENT7 in VARCHAR2
227 ,P_SEGMENT8 in VARCHAR2
228 ,P_SEGMENT9 in VARCHAR2
229 ,P_SEGMENT10 in VARCHAR2
230 ,P_SEGMENT11 in VARCHAR2
231 ,P_SEGMENT12 in VARCHAR2
232 ,P_SEGMENT13 in VARCHAR2
233 ,P_SEGMENT14 in VARCHAR2
234 ,P_SEGMENT15 in VARCHAR2
235 ,P_SEGMENT16 in VARCHAR2
236 ,P_SEGMENT17 in VARCHAR2
237 ,P_SEGMENT18 in VARCHAR2
238 ,P_SEGMENT19 in VARCHAR2
239 ,P_SEGMENT20 in VARCHAR2
240 ,P_SEGMENT21 in VARCHAR2
241 ,P_SEGMENT22 in VARCHAR2
242 ,P_SEGMENT23 in VARCHAR2
243 ,P_SEGMENT24 in VARCHAR2
244 ,P_SEGMENT25 in VARCHAR2
245 ,P_SEGMENT26 in VARCHAR2
246 ,P_SEGMENT27 in VARCHAR2
247 ,P_SEGMENT28 in VARCHAR2
248 ,P_SEGMENT29 in VARCHAR2
249 ,P_SEGMENT30 in VARCHAR2
250 ,P_CONCAT_SEGMENTS in VARCHAR2
251 ,P_OBJECT_VERSION_NUMBER in NUMBER
252 )is
253 l_commit_unit_number number;
254 l_legislation_code   varchar2(30);
255 begin
256 hr_utility.set_location('Entering: HR_ORGANIZATION_BK4.UPDATE_ORGANIZATION_B', 10);
257 l_commit_unit_number := hr_api.return_commit_unit;
258 if hr_api.call_leg_hooks then
259 l_legislation_code := HR_ORU_BUS.RETURN_LEGISLATION_CODE(P_ORGANIZATION_ID => P_ORGANIZATION_ID
260 );
261 if l_legislation_code = 'IN' then
262 PER_IN_ORG_INFO_LEG_HOOK.CHECK_ORGANIZATION_UPDATE
263 (P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
264 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
265 ,P_NAME => P_NAME
266 ,P_DATE_FROM => P_DATE_FROM
267 ,P_DATE_TO => P_DATE_TO
268 ,P_LOCATION_ID => P_LOCATION_ID
269 );
270 end if;
271 end if;
272 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_ORGANIZATION', 'BP');
273 hr_utility.set_location(' Leaving: HR_ORGANIZATION_BK4.UPDATE_ORGANIZATION_B', 20);
274 end UPDATE_ORGANIZATION_B;
275 end HR_ORGANIZATION_BK4;