eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_DOCUMENT_EXTRA_INFO_BK1

Source


1 package body HR_DOCUMENT_EXTRA_INFO_BK1 as
2 /* $Header: hrdeiapi.pkb 120.2 2005/06/08 12:45:07 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2008/11/06 01:54:33 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_DOC_EXTRA_INFO_A
6 (P_DOCUMENT_EXTRA_INFO_ID in NUMBER
7 ,P_PERSON_ID in NUMBER
8 ,P_DOCUMENT_TYPE_ID in NUMBER
9 ,P_DATE_FROM in DATE
10 ,P_DATE_TO in DATE
11 ,P_DOCUMENT_NUMBER in VARCHAR2
12 ,P_ISSUED_BY in VARCHAR2
13 ,P_ISSUED_AT in VARCHAR2
14 ,P_ISSUED_DATE in DATE
15 ,P_ISSUING_AUTHORITY in VARCHAR2
16 ,P_VERIFIED_BY in NUMBER
17 ,P_VERIFIED_DATE in DATE
18 ,P_RELATED_OBJECT_NAME in VARCHAR2
19 ,P_RELATED_OBJECT_ID_COL in VARCHAR2
20 ,P_RELATED_OBJECT_ID in NUMBER
21 ,P_DEI_ATTRIBUTE_CATEGORY in VARCHAR2
22 ,P_DEI_ATTRIBUTE1 in VARCHAR2
23 ,P_DEI_ATTRIBUTE2 in VARCHAR2
24 ,P_DEI_ATTRIBUTE3 in VARCHAR2
25 ,P_DEI_ATTRIBUTE4 in VARCHAR2
26 ,P_DEI_ATTRIBUTE5 in VARCHAR2
27 ,P_DEI_ATTRIBUTE6 in VARCHAR2
28 ,P_DEI_ATTRIBUTE7 in VARCHAR2
29 ,P_DEI_ATTRIBUTE8 in VARCHAR2
30 ,P_DEI_ATTRIBUTE9 in VARCHAR2
31 ,P_DEI_ATTRIBUTE10 in VARCHAR2
32 ,P_DEI_ATTRIBUTE11 in VARCHAR2
33 ,P_DEI_ATTRIBUTE12 in VARCHAR2
34 ,P_DEI_ATTRIBUTE13 in VARCHAR2
35 ,P_DEI_ATTRIBUTE14 in VARCHAR2
36 ,P_DEI_ATTRIBUTE15 in VARCHAR2
37 ,P_DEI_ATTRIBUTE16 in VARCHAR2
38 ,P_DEI_ATTRIBUTE17 in VARCHAR2
39 ,P_DEI_ATTRIBUTE18 in VARCHAR2
40 ,P_DEI_ATTRIBUTE19 in VARCHAR2
41 ,P_DEI_ATTRIBUTE20 in VARCHAR2
42 ,P_DEI_ATTRIBUTE21 in VARCHAR2
43 ,P_DEI_ATTRIBUTE22 in VARCHAR2
44 ,P_DEI_ATTRIBUTE23 in VARCHAR2
45 ,P_DEI_ATTRIBUTE24 in VARCHAR2
46 ,P_DEI_ATTRIBUTE25 in VARCHAR2
47 ,P_DEI_ATTRIBUTE26 in VARCHAR2
48 ,P_DEI_ATTRIBUTE27 in VARCHAR2
49 ,P_DEI_ATTRIBUTE28 in VARCHAR2
50 ,P_DEI_ATTRIBUTE29 in VARCHAR2
51 ,P_DEI_ATTRIBUTE30 in VARCHAR2
52 ,P_DEI_INFORMATION_CATEGORY in VARCHAR2
53 ,P_DEI_INFORMATION1 in VARCHAR2
54 ,P_DEI_INFORMATION2 in VARCHAR2
55 ,P_DEI_INFORMATION3 in VARCHAR2
56 ,P_DEI_INFORMATION4 in VARCHAR2
57 ,P_DEI_INFORMATION5 in VARCHAR2
58 ,P_DEI_INFORMATION6 in VARCHAR2
59 ,P_DEI_INFORMATION7 in VARCHAR2
60 ,P_DEI_INFORMATION8 in VARCHAR2
61 ,P_DEI_INFORMATION9 in VARCHAR2
62 ,P_DEI_INFORMATION10 in VARCHAR2
63 ,P_DEI_INFORMATION11 in VARCHAR2
64 ,P_DEI_INFORMATION12 in VARCHAR2
65 ,P_DEI_INFORMATION13 in VARCHAR2
66 ,P_DEI_INFORMATION14 in VARCHAR2
67 ,P_DEI_INFORMATION15 in VARCHAR2
68 ,P_DEI_INFORMATION16 in VARCHAR2
69 ,P_DEI_INFORMATION17 in VARCHAR2
70 ,P_DEI_INFORMATION18 in VARCHAR2
71 ,P_DEI_INFORMATION19 in VARCHAR2
72 ,P_DEI_INFORMATION20 in VARCHAR2
73 ,P_DEI_INFORMATION21 in VARCHAR2
74 ,P_DEI_INFORMATION22 in VARCHAR2
75 ,P_DEI_INFORMATION23 in VARCHAR2
76 ,P_DEI_INFORMATION24 in VARCHAR2
77 ,P_DEI_INFORMATION25 in VARCHAR2
78 ,P_DEI_INFORMATION26 in VARCHAR2
79 ,P_DEI_INFORMATION27 in VARCHAR2
80 ,P_DEI_INFORMATION28 in VARCHAR2
81 ,P_DEI_INFORMATION29 in VARCHAR2
82 ,P_DEI_INFORMATION30 in VARCHAR2
83 ,P_REQUEST_ID in NUMBER
84 ,P_PROGRAM_APPLICATION_ID in NUMBER
85 ,P_PROGRAM_ID in NUMBER
86 ,P_PROGRAM_UPDATE_DATE in DATE
87 ,P_OBJECT_VERSION_NUMBER in NUMBER
88 )is
89 l_commit_unit_number number;
90 l_legislation_code   varchar2(30);
91 begin
92 hr_utility.set_location('Entering: HR_DOCUMENT_EXTRA_INFO_BK1.CREATE_DOC_EXTRA_INFO_A', 10);
93 l_commit_unit_number := hr_api.return_commit_unit;
94 if hr_api.call_app_hooks then
95 hr_document_extra_info_be1.CREATE_DOC_EXTRA_INFO_A
96 (P_DOCUMENT_EXTRA_INFO_ID => P_DOCUMENT_EXTRA_INFO_ID
97 ,P_PERSON_ID => P_PERSON_ID
98 ,P_DOCUMENT_TYPE_ID => P_DOCUMENT_TYPE_ID
99 ,P_DATE_FROM => P_DATE_FROM
100 ,P_DATE_TO => P_DATE_TO
101 ,P_DOCUMENT_NUMBER => P_DOCUMENT_NUMBER
102 ,P_ISSUED_BY => P_ISSUED_BY
103 ,P_ISSUED_AT => P_ISSUED_AT
104 ,P_ISSUED_DATE => P_ISSUED_DATE
105 ,P_ISSUING_AUTHORITY => P_ISSUING_AUTHORITY
106 ,P_VERIFIED_BY => P_VERIFIED_BY
107 ,P_VERIFIED_DATE => P_VERIFIED_DATE
108 ,P_RELATED_OBJECT_NAME => P_RELATED_OBJECT_NAME
109 ,P_RELATED_OBJECT_ID_COL => P_RELATED_OBJECT_ID_COL
110 ,P_RELATED_OBJECT_ID => P_RELATED_OBJECT_ID
111 ,P_DEI_ATTRIBUTE_CATEGORY => P_DEI_ATTRIBUTE_CATEGORY
112 ,P_DEI_ATTRIBUTE1 => P_DEI_ATTRIBUTE1
113 ,P_DEI_ATTRIBUTE2 => P_DEI_ATTRIBUTE2
114 ,P_DEI_ATTRIBUTE3 => P_DEI_ATTRIBUTE3
115 ,P_DEI_ATTRIBUTE4 => P_DEI_ATTRIBUTE4
116 ,P_DEI_ATTRIBUTE5 => P_DEI_ATTRIBUTE5
117 ,P_DEI_ATTRIBUTE6 => P_DEI_ATTRIBUTE6
118 ,P_DEI_ATTRIBUTE7 => P_DEI_ATTRIBUTE7
119 ,P_DEI_ATTRIBUTE8 => P_DEI_ATTRIBUTE8
120 ,P_DEI_ATTRIBUTE9 => P_DEI_ATTRIBUTE9
121 ,P_DEI_ATTRIBUTE10 => P_DEI_ATTRIBUTE10
122 ,P_DEI_ATTRIBUTE11 => P_DEI_ATTRIBUTE11
123 ,P_DEI_ATTRIBUTE12 => P_DEI_ATTRIBUTE12
124 ,P_DEI_ATTRIBUTE13 => P_DEI_ATTRIBUTE13
125 ,P_DEI_ATTRIBUTE14 => P_DEI_ATTRIBUTE14
126 ,P_DEI_ATTRIBUTE15 => P_DEI_ATTRIBUTE15
127 ,P_DEI_ATTRIBUTE16 => P_DEI_ATTRIBUTE16
128 ,P_DEI_ATTRIBUTE17 => P_DEI_ATTRIBUTE17
129 ,P_DEI_ATTRIBUTE18 => P_DEI_ATTRIBUTE18
130 ,P_DEI_ATTRIBUTE19 => P_DEI_ATTRIBUTE19
131 ,P_DEI_ATTRIBUTE20 => P_DEI_ATTRIBUTE20
132 ,P_DEI_ATTRIBUTE21 => P_DEI_ATTRIBUTE21
133 ,P_DEI_ATTRIBUTE22 => P_DEI_ATTRIBUTE22
134 ,P_DEI_ATTRIBUTE23 => P_DEI_ATTRIBUTE23
135 ,P_DEI_ATTRIBUTE24 => P_DEI_ATTRIBUTE24
136 ,P_DEI_ATTRIBUTE25 => P_DEI_ATTRIBUTE25
137 ,P_DEI_ATTRIBUTE26 => P_DEI_ATTRIBUTE26
138 ,P_DEI_ATTRIBUTE27 => P_DEI_ATTRIBUTE27
139 ,P_DEI_ATTRIBUTE28 => P_DEI_ATTRIBUTE28
140 ,P_DEI_ATTRIBUTE29 => P_DEI_ATTRIBUTE29
141 ,P_DEI_ATTRIBUTE30 => P_DEI_ATTRIBUTE30
142 ,P_DEI_INFORMATION_CATEGORY => P_DEI_INFORMATION_CATEGORY
143 ,P_DEI_INFORMATION1 => P_DEI_INFORMATION1
144 ,P_DEI_INFORMATION2 => P_DEI_INFORMATION2
145 ,P_DEI_INFORMATION3 => P_DEI_INFORMATION3
146 ,P_DEI_INFORMATION4 => P_DEI_INFORMATION4
147 ,P_DEI_INFORMATION5 => P_DEI_INFORMATION5
148 ,P_DEI_INFORMATION6 => P_DEI_INFORMATION6
149 ,P_DEI_INFORMATION7 => P_DEI_INFORMATION7
150 ,P_DEI_INFORMATION8 => P_DEI_INFORMATION8
151 ,P_DEI_INFORMATION9 => P_DEI_INFORMATION9
152 ,P_DEI_INFORMATION10 => P_DEI_INFORMATION10
153 ,P_DEI_INFORMATION11 => P_DEI_INFORMATION11
154 ,P_DEI_INFORMATION12 => P_DEI_INFORMATION12
155 ,P_DEI_INFORMATION13 => P_DEI_INFORMATION13
156 ,P_DEI_INFORMATION14 => P_DEI_INFORMATION14
157 ,P_DEI_INFORMATION15 => P_DEI_INFORMATION15
158 ,P_DEI_INFORMATION16 => P_DEI_INFORMATION16
159 ,P_DEI_INFORMATION17 => P_DEI_INFORMATION17
160 ,P_DEI_INFORMATION18 => P_DEI_INFORMATION18
161 ,P_DEI_INFORMATION19 => P_DEI_INFORMATION19
162 ,P_DEI_INFORMATION20 => P_DEI_INFORMATION20
163 ,P_DEI_INFORMATION21 => P_DEI_INFORMATION21
164 ,P_DEI_INFORMATION22 => P_DEI_INFORMATION22
165 ,P_DEI_INFORMATION23 => P_DEI_INFORMATION23
166 ,P_DEI_INFORMATION24 => P_DEI_INFORMATION24
167 ,P_DEI_INFORMATION25 => P_DEI_INFORMATION25
168 ,P_DEI_INFORMATION26 => P_DEI_INFORMATION26
169 ,P_DEI_INFORMATION27 => P_DEI_INFORMATION27
170 ,P_DEI_INFORMATION28 => P_DEI_INFORMATION28
171 ,P_DEI_INFORMATION29 => P_DEI_INFORMATION29
172 ,P_DEI_INFORMATION30 => P_DEI_INFORMATION30
173 ,P_REQUEST_ID => P_REQUEST_ID
174 ,P_PROGRAM_APPLICATION_ID => P_PROGRAM_APPLICATION_ID
175 ,P_PROGRAM_ID => P_PROGRAM_ID
176 ,P_PROGRAM_UPDATE_DATE => P_PROGRAM_UPDATE_DATE
177 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
178 );
179 end if;
180 hr_multi_message.end_validation_set;
181 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_DOC_EXTRA_INFO', 'AP');
182 hr_utility.set_location(' Leaving: HR_DOCUMENT_EXTRA_INFO_BK1.CREATE_DOC_EXTRA_INFO_A', 20);
183 end CREATE_DOC_EXTRA_INFO_A;
184 procedure CREATE_DOC_EXTRA_INFO_B
185 (P_PERSON_ID in NUMBER
186 ,P_DOCUMENT_TYPE_ID in NUMBER
187 ,P_DATE_FROM in DATE
188 ,P_DATE_TO in DATE
189 ,P_DOCUMENT_NUMBER in VARCHAR2
190 ,P_ISSUED_BY in VARCHAR2
191 ,P_ISSUED_AT in VARCHAR2
192 ,P_ISSUED_DATE in DATE
193 ,P_ISSUING_AUTHORITY in VARCHAR2
194 ,P_VERIFIED_BY in NUMBER
195 ,P_VERIFIED_DATE in DATE
196 ,P_RELATED_OBJECT_NAME in VARCHAR2
197 ,P_RELATED_OBJECT_ID_COL in VARCHAR2
198 ,P_RELATED_OBJECT_ID in NUMBER
199 ,P_DEI_ATTRIBUTE_CATEGORY in VARCHAR2
200 ,P_DEI_ATTRIBUTE1 in VARCHAR2
201 ,P_DEI_ATTRIBUTE2 in VARCHAR2
202 ,P_DEI_ATTRIBUTE3 in VARCHAR2
203 ,P_DEI_ATTRIBUTE4 in VARCHAR2
204 ,P_DEI_ATTRIBUTE5 in VARCHAR2
205 ,P_DEI_ATTRIBUTE6 in VARCHAR2
206 ,P_DEI_ATTRIBUTE7 in VARCHAR2
207 ,P_DEI_ATTRIBUTE8 in VARCHAR2
208 ,P_DEI_ATTRIBUTE9 in VARCHAR2
209 ,P_DEI_ATTRIBUTE10 in VARCHAR2
210 ,P_DEI_ATTRIBUTE11 in VARCHAR2
211 ,P_DEI_ATTRIBUTE12 in VARCHAR2
212 ,P_DEI_ATTRIBUTE13 in VARCHAR2
213 ,P_DEI_ATTRIBUTE14 in VARCHAR2
214 ,P_DEI_ATTRIBUTE15 in VARCHAR2
215 ,P_DEI_ATTRIBUTE16 in VARCHAR2
216 ,P_DEI_ATTRIBUTE17 in VARCHAR2
217 ,P_DEI_ATTRIBUTE18 in VARCHAR2
218 ,P_DEI_ATTRIBUTE19 in VARCHAR2
219 ,P_DEI_ATTRIBUTE20 in VARCHAR2
220 ,P_DEI_ATTRIBUTE21 in VARCHAR2
221 ,P_DEI_ATTRIBUTE22 in VARCHAR2
222 ,P_DEI_ATTRIBUTE23 in VARCHAR2
223 ,P_DEI_ATTRIBUTE24 in VARCHAR2
224 ,P_DEI_ATTRIBUTE25 in VARCHAR2
225 ,P_DEI_ATTRIBUTE26 in VARCHAR2
226 ,P_DEI_ATTRIBUTE27 in VARCHAR2
227 ,P_DEI_ATTRIBUTE28 in VARCHAR2
228 ,P_DEI_ATTRIBUTE29 in VARCHAR2
229 ,P_DEI_ATTRIBUTE30 in VARCHAR2
230 ,P_DEI_INFORMATION_CATEGORY in VARCHAR2
231 ,P_DEI_INFORMATION1 in VARCHAR2
232 ,P_DEI_INFORMATION2 in VARCHAR2
233 ,P_DEI_INFORMATION3 in VARCHAR2
234 ,P_DEI_INFORMATION4 in VARCHAR2
235 ,P_DEI_INFORMATION5 in VARCHAR2
236 ,P_DEI_INFORMATION6 in VARCHAR2
237 ,P_DEI_INFORMATION7 in VARCHAR2
238 ,P_DEI_INFORMATION8 in VARCHAR2
239 ,P_DEI_INFORMATION9 in VARCHAR2
240 ,P_DEI_INFORMATION10 in VARCHAR2
241 ,P_DEI_INFORMATION11 in VARCHAR2
242 ,P_DEI_INFORMATION12 in VARCHAR2
243 ,P_DEI_INFORMATION13 in VARCHAR2
244 ,P_DEI_INFORMATION14 in VARCHAR2
245 ,P_DEI_INFORMATION15 in VARCHAR2
246 ,P_DEI_INFORMATION16 in VARCHAR2
247 ,P_DEI_INFORMATION17 in VARCHAR2
248 ,P_DEI_INFORMATION18 in VARCHAR2
249 ,P_DEI_INFORMATION19 in VARCHAR2
250 ,P_DEI_INFORMATION20 in VARCHAR2
251 ,P_DEI_INFORMATION21 in VARCHAR2
252 ,P_DEI_INFORMATION22 in VARCHAR2
253 ,P_DEI_INFORMATION23 in VARCHAR2
254 ,P_DEI_INFORMATION24 in VARCHAR2
255 ,P_DEI_INFORMATION25 in VARCHAR2
256 ,P_DEI_INFORMATION26 in VARCHAR2
257 ,P_DEI_INFORMATION27 in VARCHAR2
258 ,P_DEI_INFORMATION28 in VARCHAR2
259 ,P_DEI_INFORMATION29 in VARCHAR2
260 ,P_DEI_INFORMATION30 in VARCHAR2
261 ,P_REQUEST_ID in NUMBER
262 ,P_PROGRAM_APPLICATION_ID in NUMBER
263 ,P_PROGRAM_ID in NUMBER
264 ,P_PROGRAM_UPDATE_DATE in DATE
265 )is
266 l_commit_unit_number number;
267 l_legislation_code   varchar2(30);
268 begin
269 hr_utility.set_location('Entering: HR_DOCUMENT_EXTRA_INFO_BK1.CREATE_DOC_EXTRA_INFO_B', 10);
270 l_commit_unit_number := hr_api.return_commit_unit;
271 if hr_api.call_leg_hooks then
272 l_legislation_code := HR_DEI_BUS.RETURN_LEG_CODE_PERID(P_PERSON_ID => P_PERSON_ID
273 );
274 if l_legislation_code = 'NO' then
275 HR_NO_UTILITY.CREATE_NO_DEI_INFO
276 (P_PERSON_ID => P_PERSON_ID
277 ,P_ISSUED_DATE => P_ISSUED_DATE
278 ,P_DATE_FROM => P_DATE_FROM
279 ,P_DATE_TO => P_DATE_TO
280 ,P_DOCUMENT_NUMBER => P_DOCUMENT_NUMBER
281 ,P_DOCUMENT_TYPE_ID => P_DOCUMENT_TYPE_ID
282 );
283 elsif l_legislation_code = 'PL' then
284 PER_PL_DEI_INFO.CREATE_PL_DEI_INFO
285 (P_PERSON_ID => P_PERSON_ID
286 ,P_DOCUMENT_TYPE_ID => P_DOCUMENT_TYPE_ID
287 ,P_DOCUMENT_NUMBER => P_DOCUMENT_NUMBER
288 ,P_ISSUED_DATE => P_ISSUED_DATE
289 ,P_DATE_FROM => P_DATE_FROM
290 ,P_DATE_TO => P_DATE_TO
291 );
292 end if;
293 end if;
294 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_DOC_EXTRA_INFO', 'BP');
295 hr_utility.set_location(' Leaving: HR_DOCUMENT_EXTRA_INFO_BK1.CREATE_DOC_EXTRA_INFO_B', 20);
296 end CREATE_DOC_EXTRA_INFO_B;
297 end HR_DOCUMENT_EXTRA_INFO_BK1;