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_PREVIOUS_EMPLOYMENT_BKA

Source


1 package body HR_PREVIOUS_EMPLOYMENT_BKA as
2 /* $Header: pepemapi.pkb 120.0.12010000.2 2008/08/06 09:21:29 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:46:52 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PREV_JOB_EXTRA_INFO_A
6 (P_PREVIOUS_JOB_EXTRA_INFO_ID in NUMBER
7 ,P_PREVIOUS_JOB_ID in NUMBER
8 ,P_INFORMATION_TYPE in VARCHAR2
9 ,P_PJI_ATTRIBUTE_CATEGORY in VARCHAR2
10 ,P_PJI_ATTRIBUTE1 in VARCHAR2
11 ,P_PJI_ATTRIBUTE2 in VARCHAR2
12 ,P_PJI_ATTRIBUTE3 in VARCHAR2
13 ,P_PJI_ATTRIBUTE4 in VARCHAR2
14 ,P_PJI_ATTRIBUTE5 in VARCHAR2
15 ,P_PJI_ATTRIBUTE6 in VARCHAR2
16 ,P_PJI_ATTRIBUTE7 in VARCHAR2
17 ,P_PJI_ATTRIBUTE8 in VARCHAR2
18 ,P_PJI_ATTRIBUTE9 in VARCHAR2
19 ,P_PJI_ATTRIBUTE10 in VARCHAR2
20 ,P_PJI_ATTRIBUTE11 in VARCHAR2
21 ,P_PJI_ATTRIBUTE12 in VARCHAR2
22 ,P_PJI_ATTRIBUTE13 in VARCHAR2
23 ,P_PJI_ATTRIBUTE14 in VARCHAR2
24 ,P_PJI_ATTRIBUTE15 in VARCHAR2
25 ,P_PJI_ATTRIBUTE16 in VARCHAR2
26 ,P_PJI_ATTRIBUTE17 in VARCHAR2
27 ,P_PJI_ATTRIBUTE18 in VARCHAR2
28 ,P_PJI_ATTRIBUTE19 in VARCHAR2
29 ,P_PJI_ATTRIBUTE20 in VARCHAR2
30 ,P_PJI_ATTRIBUTE21 in VARCHAR2
31 ,P_PJI_ATTRIBUTE22 in VARCHAR2
32 ,P_PJI_ATTRIBUTE23 in VARCHAR2
33 ,P_PJI_ATTRIBUTE24 in VARCHAR2
34 ,P_PJI_ATTRIBUTE25 in VARCHAR2
35 ,P_PJI_ATTRIBUTE26 in VARCHAR2
36 ,P_PJI_ATTRIBUTE27 in VARCHAR2
37 ,P_PJI_ATTRIBUTE28 in VARCHAR2
38 ,P_PJI_ATTRIBUTE29 in VARCHAR2
39 ,P_PJI_ATTRIBUTE30 in VARCHAR2
40 ,P_PJI_INFORMATION_CATEGORY in VARCHAR2
41 ,P_PJI_INFORMATION1 in VARCHAR2
42 ,P_PJI_INFORMATION2 in VARCHAR2
43 ,P_PJI_INFORMATION3 in VARCHAR2
44 ,P_PJI_INFORMATION4 in VARCHAR2
45 ,P_PJI_INFORMATION5 in VARCHAR2
46 ,P_PJI_INFORMATION6 in VARCHAR2
47 ,P_PJI_INFORMATION7 in VARCHAR2
48 ,P_PJI_INFORMATION8 in VARCHAR2
49 ,P_PJI_INFORMATION9 in VARCHAR2
50 ,P_PJI_INFORMATION10 in VARCHAR2
51 ,P_PJI_INFORMATION11 in VARCHAR2
52 ,P_PJI_INFORMATION12 in VARCHAR2
53 ,P_PJI_INFORMATION13 in VARCHAR2
54 ,P_PJI_INFORMATION14 in VARCHAR2
55 ,P_PJI_INFORMATION15 in VARCHAR2
56 ,P_PJI_INFORMATION16 in VARCHAR2
57 ,P_PJI_INFORMATION17 in VARCHAR2
58 ,P_PJI_INFORMATION18 in VARCHAR2
59 ,P_PJI_INFORMATION19 in VARCHAR2
60 ,P_PJI_INFORMATION20 in VARCHAR2
61 ,P_PJI_INFORMATION21 in VARCHAR2
62 ,P_PJI_INFORMATION22 in VARCHAR2
63 ,P_PJI_INFORMATION23 in VARCHAR2
64 ,P_PJI_INFORMATION24 in VARCHAR2
65 ,P_PJI_INFORMATION25 in VARCHAR2
66 ,P_PJI_INFORMATION26 in VARCHAR2
67 ,P_PJI_INFORMATION27 in VARCHAR2
68 ,P_PJI_INFORMATION28 in VARCHAR2
69 ,P_PJI_INFORMATION29 in VARCHAR2
70 ,P_PJI_INFORMATION30 in VARCHAR2
71 ,P_OBJECT_VERSION_NUMBER in NUMBER
72 )is
73 l_commit_unit_number number;
74 l_legislation_code   varchar2(30);
75 begin
76 hr_utility.set_location('Entering: HR_PREVIOUS_EMPLOYMENT_BKA.CREATE_PREV_JOB_EXTRA_INFO_A', 10);
77 l_commit_unit_number := hr_api.return_commit_unit;
78 if hr_api.call_app_hooks then
79 hr_previous_employment_beA.CREATE_PREV_JOB_EXTRA_INFO_A
80 (P_PREVIOUS_JOB_EXTRA_INFO_ID => P_PREVIOUS_JOB_EXTRA_INFO_ID
81 ,P_PREVIOUS_JOB_ID => P_PREVIOUS_JOB_ID
82 ,P_INFORMATION_TYPE => P_INFORMATION_TYPE
83 ,P_PJI_ATTRIBUTE_CATEGORY => P_PJI_ATTRIBUTE_CATEGORY
84 ,P_PJI_ATTRIBUTE1 => P_PJI_ATTRIBUTE1
85 ,P_PJI_ATTRIBUTE2 => P_PJI_ATTRIBUTE2
86 ,P_PJI_ATTRIBUTE3 => P_PJI_ATTRIBUTE3
87 ,P_PJI_ATTRIBUTE4 => P_PJI_ATTRIBUTE4
88 ,P_PJI_ATTRIBUTE5 => P_PJI_ATTRIBUTE5
89 ,P_PJI_ATTRIBUTE6 => P_PJI_ATTRIBUTE6
90 ,P_PJI_ATTRIBUTE7 => P_PJI_ATTRIBUTE7
91 ,P_PJI_ATTRIBUTE8 => P_PJI_ATTRIBUTE8
92 ,P_PJI_ATTRIBUTE9 => P_PJI_ATTRIBUTE9
93 ,P_PJI_ATTRIBUTE10 => P_PJI_ATTRIBUTE10
94 ,P_PJI_ATTRIBUTE11 => P_PJI_ATTRIBUTE11
95 ,P_PJI_ATTRIBUTE12 => P_PJI_ATTRIBUTE12
96 ,P_PJI_ATTRIBUTE13 => P_PJI_ATTRIBUTE13
97 ,P_PJI_ATTRIBUTE14 => P_PJI_ATTRIBUTE14
98 ,P_PJI_ATTRIBUTE15 => P_PJI_ATTRIBUTE15
99 ,P_PJI_ATTRIBUTE16 => P_PJI_ATTRIBUTE16
100 ,P_PJI_ATTRIBUTE17 => P_PJI_ATTRIBUTE17
101 ,P_PJI_ATTRIBUTE18 => P_PJI_ATTRIBUTE18
102 ,P_PJI_ATTRIBUTE19 => P_PJI_ATTRIBUTE19
103 ,P_PJI_ATTRIBUTE20 => P_PJI_ATTRIBUTE20
104 ,P_PJI_ATTRIBUTE21 => P_PJI_ATTRIBUTE21
105 ,P_PJI_ATTRIBUTE22 => P_PJI_ATTRIBUTE22
106 ,P_PJI_ATTRIBUTE23 => P_PJI_ATTRIBUTE23
107 ,P_PJI_ATTRIBUTE24 => P_PJI_ATTRIBUTE24
108 ,P_PJI_ATTRIBUTE25 => P_PJI_ATTRIBUTE25
109 ,P_PJI_ATTRIBUTE26 => P_PJI_ATTRIBUTE26
110 ,P_PJI_ATTRIBUTE27 => P_PJI_ATTRIBUTE27
111 ,P_PJI_ATTRIBUTE28 => P_PJI_ATTRIBUTE28
112 ,P_PJI_ATTRIBUTE29 => P_PJI_ATTRIBUTE29
113 ,P_PJI_ATTRIBUTE30 => P_PJI_ATTRIBUTE30
114 ,P_PJI_INFORMATION_CATEGORY => P_PJI_INFORMATION_CATEGORY
115 ,P_PJI_INFORMATION1 => P_PJI_INFORMATION1
116 ,P_PJI_INFORMATION2 => P_PJI_INFORMATION2
117 ,P_PJI_INFORMATION3 => P_PJI_INFORMATION3
118 ,P_PJI_INFORMATION4 => P_PJI_INFORMATION4
119 ,P_PJI_INFORMATION5 => P_PJI_INFORMATION5
120 ,P_PJI_INFORMATION6 => P_PJI_INFORMATION6
121 ,P_PJI_INFORMATION7 => P_PJI_INFORMATION7
122 ,P_PJI_INFORMATION8 => P_PJI_INFORMATION8
123 ,P_PJI_INFORMATION9 => P_PJI_INFORMATION9
124 ,P_PJI_INFORMATION10 => P_PJI_INFORMATION10
125 ,P_PJI_INFORMATION11 => P_PJI_INFORMATION11
126 ,P_PJI_INFORMATION12 => P_PJI_INFORMATION12
127 ,P_PJI_INFORMATION13 => P_PJI_INFORMATION13
128 ,P_PJI_INFORMATION14 => P_PJI_INFORMATION14
129 ,P_PJI_INFORMATION15 => P_PJI_INFORMATION15
130 ,P_PJI_INFORMATION16 => P_PJI_INFORMATION16
131 ,P_PJI_INFORMATION17 => P_PJI_INFORMATION17
132 ,P_PJI_INFORMATION18 => P_PJI_INFORMATION18
133 ,P_PJI_INFORMATION19 => P_PJI_INFORMATION19
134 ,P_PJI_INFORMATION20 => P_PJI_INFORMATION20
135 ,P_PJI_INFORMATION21 => P_PJI_INFORMATION21
136 ,P_PJI_INFORMATION22 => P_PJI_INFORMATION22
137 ,P_PJI_INFORMATION23 => P_PJI_INFORMATION23
138 ,P_PJI_INFORMATION24 => P_PJI_INFORMATION24
139 ,P_PJI_INFORMATION25 => P_PJI_INFORMATION25
140 ,P_PJI_INFORMATION26 => P_PJI_INFORMATION26
141 ,P_PJI_INFORMATION27 => P_PJI_INFORMATION27
142 ,P_PJI_INFORMATION28 => P_PJI_INFORMATION28
143 ,P_PJI_INFORMATION29 => P_PJI_INFORMATION29
144 ,P_PJI_INFORMATION30 => P_PJI_INFORMATION30
145 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
146 );
147 end if;
148 hr_multi_message.end_validation_set;
149 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_PREV_JOB_EXTRA_INFO', 'AP');
150 hr_utility.set_location(' Leaving: HR_PREVIOUS_EMPLOYMENT_BKA.CREATE_PREV_JOB_EXTRA_INFO_A', 20);
151 end CREATE_PREV_JOB_EXTRA_INFO_A;
152 procedure CREATE_PREV_JOB_EXTRA_INFO_B
153 (P_PREVIOUS_JOB_ID in NUMBER
154 ,P_INFORMATION_TYPE in VARCHAR2
155 ,P_PJI_ATTRIBUTE_CATEGORY in VARCHAR2
156 ,P_PJI_ATTRIBUTE1 in VARCHAR2
157 ,P_PJI_ATTRIBUTE2 in VARCHAR2
158 ,P_PJI_ATTRIBUTE3 in VARCHAR2
159 ,P_PJI_ATTRIBUTE4 in VARCHAR2
160 ,P_PJI_ATTRIBUTE5 in VARCHAR2
161 ,P_PJI_ATTRIBUTE6 in VARCHAR2
162 ,P_PJI_ATTRIBUTE7 in VARCHAR2
163 ,P_PJI_ATTRIBUTE8 in VARCHAR2
164 ,P_PJI_ATTRIBUTE9 in VARCHAR2
165 ,P_PJI_ATTRIBUTE10 in VARCHAR2
166 ,P_PJI_ATTRIBUTE11 in VARCHAR2
167 ,P_PJI_ATTRIBUTE12 in VARCHAR2
168 ,P_PJI_ATTRIBUTE13 in VARCHAR2
169 ,P_PJI_ATTRIBUTE14 in VARCHAR2
170 ,P_PJI_ATTRIBUTE15 in VARCHAR2
171 ,P_PJI_ATTRIBUTE16 in VARCHAR2
172 ,P_PJI_ATTRIBUTE17 in VARCHAR2
173 ,P_PJI_ATTRIBUTE18 in VARCHAR2
174 ,P_PJI_ATTRIBUTE19 in VARCHAR2
175 ,P_PJI_ATTRIBUTE20 in VARCHAR2
176 ,P_PJI_ATTRIBUTE21 in VARCHAR2
177 ,P_PJI_ATTRIBUTE22 in VARCHAR2
178 ,P_PJI_ATTRIBUTE23 in VARCHAR2
179 ,P_PJI_ATTRIBUTE24 in VARCHAR2
180 ,P_PJI_ATTRIBUTE25 in VARCHAR2
181 ,P_PJI_ATTRIBUTE26 in VARCHAR2
182 ,P_PJI_ATTRIBUTE27 in VARCHAR2
183 ,P_PJI_ATTRIBUTE28 in VARCHAR2
184 ,P_PJI_ATTRIBUTE29 in VARCHAR2
185 ,P_PJI_ATTRIBUTE30 in VARCHAR2
186 ,P_PJI_INFORMATION_CATEGORY in VARCHAR2
187 ,P_PJI_INFORMATION1 in VARCHAR2
188 ,P_PJI_INFORMATION2 in VARCHAR2
189 ,P_PJI_INFORMATION3 in VARCHAR2
190 ,P_PJI_INFORMATION4 in VARCHAR2
191 ,P_PJI_INFORMATION5 in VARCHAR2
192 ,P_PJI_INFORMATION6 in VARCHAR2
193 ,P_PJI_INFORMATION7 in VARCHAR2
194 ,P_PJI_INFORMATION8 in VARCHAR2
195 ,P_PJI_INFORMATION9 in VARCHAR2
196 ,P_PJI_INFORMATION10 in VARCHAR2
197 ,P_PJI_INFORMATION11 in VARCHAR2
198 ,P_PJI_INFORMATION12 in VARCHAR2
199 ,P_PJI_INFORMATION13 in VARCHAR2
200 ,P_PJI_INFORMATION14 in VARCHAR2
201 ,P_PJI_INFORMATION15 in VARCHAR2
202 ,P_PJI_INFORMATION16 in VARCHAR2
203 ,P_PJI_INFORMATION17 in VARCHAR2
204 ,P_PJI_INFORMATION18 in VARCHAR2
205 ,P_PJI_INFORMATION19 in VARCHAR2
206 ,P_PJI_INFORMATION20 in VARCHAR2
207 ,P_PJI_INFORMATION21 in VARCHAR2
208 ,P_PJI_INFORMATION22 in VARCHAR2
209 ,P_PJI_INFORMATION23 in VARCHAR2
210 ,P_PJI_INFORMATION24 in VARCHAR2
211 ,P_PJI_INFORMATION25 in VARCHAR2
212 ,P_PJI_INFORMATION26 in VARCHAR2
213 ,P_PJI_INFORMATION27 in VARCHAR2
214 ,P_PJI_INFORMATION28 in VARCHAR2
215 ,P_PJI_INFORMATION29 in VARCHAR2
216 ,P_PJI_INFORMATION30 in VARCHAR2
217 ,P_OBJECT_VERSION_NUMBER in NUMBER
218 )is
219 begin
220 hr_utility.set_location('Entering: HR_PREVIOUS_EMPLOYMENT_BKA.CREATE_PREV_JOB_EXTRA_INFO_B', 10);
221 hr_utility.set_location(' Leaving: HR_PREVIOUS_EMPLOYMENT_BKA.CREATE_PREV_JOB_EXTRA_INFO_B', 20);
222 end CREATE_PREV_JOB_EXTRA_INFO_B;
223 end HR_PREVIOUS_EMPLOYMENT_BKA;