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_BK7

Source


1 package body HR_PREVIOUS_EMPLOYMENT_BK7 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:45 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PREVIOUS_JOB_USAGE_A
6 (P_ASSIGNMENT_ID in NUMBER
7 ,P_PREVIOUS_EMPLOYER_ID in NUMBER
8 ,P_PREVIOUS_JOB_ID in NUMBER
9 ,P_START_DATE in DATE
10 ,P_END_DATE in DATE
11 ,P_PERIOD_YEARS in NUMBER
12 ,P_PERIOD_MONTHS in NUMBER
13 ,P_PERIOD_DAYS in NUMBER
14 ,P_PJU_ATTRIBUTE_CATEGORY in VARCHAR2
15 ,P_PJU_ATTRIBUTE1 in VARCHAR2
16 ,P_PJU_ATTRIBUTE2 in VARCHAR2
17 ,P_PJU_ATTRIBUTE3 in VARCHAR2
18 ,P_PJU_ATTRIBUTE4 in VARCHAR2
19 ,P_PJU_ATTRIBUTE5 in VARCHAR2
20 ,P_PJU_ATTRIBUTE6 in VARCHAR2
21 ,P_PJU_ATTRIBUTE7 in VARCHAR2
22 ,P_PJU_ATTRIBUTE8 in VARCHAR2
23 ,P_PJU_ATTRIBUTE9 in VARCHAR2
24 ,P_PJU_ATTRIBUTE10 in VARCHAR2
25 ,P_PJU_ATTRIBUTE11 in VARCHAR2
26 ,P_PJU_ATTRIBUTE12 in VARCHAR2
27 ,P_PJU_ATTRIBUTE13 in VARCHAR2
28 ,P_PJU_ATTRIBUTE14 in VARCHAR2
29 ,P_PJU_ATTRIBUTE15 in VARCHAR2
30 ,P_PJU_ATTRIBUTE16 in VARCHAR2
31 ,P_PJU_ATTRIBUTE17 in VARCHAR2
32 ,P_PJU_ATTRIBUTE18 in VARCHAR2
33 ,P_PJU_ATTRIBUTE19 in VARCHAR2
34 ,P_PJU_ATTRIBUTE20 in VARCHAR2
35 ,P_PJU_INFORMATION_CATEGORY in VARCHAR2
36 ,P_PJU_INFORMATION1 in VARCHAR2
37 ,P_PJU_INFORMATION2 in VARCHAR2
38 ,P_PJU_INFORMATION3 in VARCHAR2
39 ,P_PJU_INFORMATION4 in VARCHAR2
40 ,P_PJU_INFORMATION5 in VARCHAR2
41 ,P_PJU_INFORMATION6 in VARCHAR2
42 ,P_PJU_INFORMATION7 in VARCHAR2
43 ,P_PJU_INFORMATION8 in VARCHAR2
44 ,P_PJU_INFORMATION9 in VARCHAR2
45 ,P_PJU_INFORMATION10 in VARCHAR2
46 ,P_PJU_INFORMATION11 in VARCHAR2
47 ,P_PJU_INFORMATION12 in VARCHAR2
48 ,P_PJU_INFORMATION13 in VARCHAR2
49 ,P_PJU_INFORMATION14 in VARCHAR2
50 ,P_PJU_INFORMATION15 in VARCHAR2
51 ,P_PJU_INFORMATION16 in VARCHAR2
52 ,P_PJU_INFORMATION17 in VARCHAR2
53 ,P_PJU_INFORMATION18 in VARCHAR2
54 ,P_PJU_INFORMATION19 in VARCHAR2
55 ,P_PJU_INFORMATION20 in VARCHAR2
56 ,P_PREVIOUS_JOB_USAGE_ID in NUMBER
57 ,P_OBJECT_VERSION_NUMBER in NUMBER
58 )is
59 l_commit_unit_number number;
60 l_legislation_code   varchar2(30);
61 begin
62 hr_utility.set_location('Entering: HR_PREVIOUS_EMPLOYMENT_BK7.CREATE_PREVIOUS_JOB_USAGE_A', 10);
63 l_commit_unit_number := hr_api.return_commit_unit;
64 if hr_api.call_app_hooks then
65 hr_previous_employment_be7.CREATE_PREVIOUS_JOB_USAGE_A
66 (P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
67 ,P_PREVIOUS_EMPLOYER_ID => P_PREVIOUS_EMPLOYER_ID
68 ,P_PREVIOUS_JOB_ID => P_PREVIOUS_JOB_ID
69 ,P_START_DATE => P_START_DATE
70 ,P_END_DATE => P_END_DATE
71 ,P_PERIOD_YEARS => P_PERIOD_YEARS
72 ,P_PERIOD_MONTHS => P_PERIOD_MONTHS
73 ,P_PERIOD_DAYS => P_PERIOD_DAYS
74 ,P_PJU_ATTRIBUTE_CATEGORY => P_PJU_ATTRIBUTE_CATEGORY
75 ,P_PJU_ATTRIBUTE1 => P_PJU_ATTRIBUTE1
76 ,P_PJU_ATTRIBUTE2 => P_PJU_ATTRIBUTE2
77 ,P_PJU_ATTRIBUTE3 => P_PJU_ATTRIBUTE3
78 ,P_PJU_ATTRIBUTE4 => P_PJU_ATTRIBUTE4
79 ,P_PJU_ATTRIBUTE5 => P_PJU_ATTRIBUTE5
80 ,P_PJU_ATTRIBUTE6 => P_PJU_ATTRIBUTE6
81 ,P_PJU_ATTRIBUTE7 => P_PJU_ATTRIBUTE7
82 ,P_PJU_ATTRIBUTE8 => P_PJU_ATTRIBUTE8
83 ,P_PJU_ATTRIBUTE9 => P_PJU_ATTRIBUTE9
84 ,P_PJU_ATTRIBUTE10 => P_PJU_ATTRIBUTE10
85 ,P_PJU_ATTRIBUTE11 => P_PJU_ATTRIBUTE11
86 ,P_PJU_ATTRIBUTE12 => P_PJU_ATTRIBUTE12
87 ,P_PJU_ATTRIBUTE13 => P_PJU_ATTRIBUTE13
88 ,P_PJU_ATTRIBUTE14 => P_PJU_ATTRIBUTE14
89 ,P_PJU_ATTRIBUTE15 => P_PJU_ATTRIBUTE15
90 ,P_PJU_ATTRIBUTE16 => P_PJU_ATTRIBUTE16
91 ,P_PJU_ATTRIBUTE17 => P_PJU_ATTRIBUTE17
92 ,P_PJU_ATTRIBUTE18 => P_PJU_ATTRIBUTE18
93 ,P_PJU_ATTRIBUTE19 => P_PJU_ATTRIBUTE19
94 ,P_PJU_ATTRIBUTE20 => P_PJU_ATTRIBUTE20
95 ,P_PJU_INFORMATION_CATEGORY => P_PJU_INFORMATION_CATEGORY
96 ,P_PJU_INFORMATION1 => P_PJU_INFORMATION1
97 ,P_PJU_INFORMATION2 => P_PJU_INFORMATION2
98 ,P_PJU_INFORMATION3 => P_PJU_INFORMATION3
99 ,P_PJU_INFORMATION4 => P_PJU_INFORMATION4
100 ,P_PJU_INFORMATION5 => P_PJU_INFORMATION5
101 ,P_PJU_INFORMATION6 => P_PJU_INFORMATION6
102 ,P_PJU_INFORMATION7 => P_PJU_INFORMATION7
103 ,P_PJU_INFORMATION8 => P_PJU_INFORMATION8
104 ,P_PJU_INFORMATION9 => P_PJU_INFORMATION9
105 ,P_PJU_INFORMATION10 => P_PJU_INFORMATION10
106 ,P_PJU_INFORMATION11 => P_PJU_INFORMATION11
107 ,P_PJU_INFORMATION12 => P_PJU_INFORMATION12
108 ,P_PJU_INFORMATION13 => P_PJU_INFORMATION13
109 ,P_PJU_INFORMATION14 => P_PJU_INFORMATION14
110 ,P_PJU_INFORMATION15 => P_PJU_INFORMATION15
111 ,P_PJU_INFORMATION16 => P_PJU_INFORMATION16
112 ,P_PJU_INFORMATION17 => P_PJU_INFORMATION17
113 ,P_PJU_INFORMATION18 => P_PJU_INFORMATION18
114 ,P_PJU_INFORMATION19 => P_PJU_INFORMATION19
115 ,P_PJU_INFORMATION20 => P_PJU_INFORMATION20
116 ,P_PREVIOUS_JOB_USAGE_ID => P_PREVIOUS_JOB_USAGE_ID
117 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
118 );
119 end if;
120 hr_multi_message.end_validation_set;
121 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_PREVIOUS_JOB_USAGE', 'AP');
122 hr_utility.set_location(' Leaving: HR_PREVIOUS_EMPLOYMENT_BK7.CREATE_PREVIOUS_JOB_USAGE_A', 20);
123 end CREATE_PREVIOUS_JOB_USAGE_A;
124 procedure CREATE_PREVIOUS_JOB_USAGE_B
125 (P_ASSIGNMENT_ID in NUMBER
126 ,P_PREVIOUS_EMPLOYER_ID in NUMBER
127 ,P_PREVIOUS_JOB_ID in NUMBER
128 ,P_START_DATE in DATE
129 ,P_END_DATE in DATE
130 ,P_PERIOD_YEARS in NUMBER
131 ,P_PERIOD_MONTHS in NUMBER
132 ,P_PERIOD_DAYS in NUMBER
133 ,P_PJU_ATTRIBUTE_CATEGORY in VARCHAR2
134 ,P_PJU_ATTRIBUTE1 in VARCHAR2
135 ,P_PJU_ATTRIBUTE2 in VARCHAR2
136 ,P_PJU_ATTRIBUTE3 in VARCHAR2
137 ,P_PJU_ATTRIBUTE4 in VARCHAR2
138 ,P_PJU_ATTRIBUTE5 in VARCHAR2
139 ,P_PJU_ATTRIBUTE6 in VARCHAR2
140 ,P_PJU_ATTRIBUTE7 in VARCHAR2
141 ,P_PJU_ATTRIBUTE8 in VARCHAR2
142 ,P_PJU_ATTRIBUTE9 in VARCHAR2
143 ,P_PJU_ATTRIBUTE10 in VARCHAR2
144 ,P_PJU_ATTRIBUTE11 in VARCHAR2
145 ,P_PJU_ATTRIBUTE12 in VARCHAR2
146 ,P_PJU_ATTRIBUTE13 in VARCHAR2
147 ,P_PJU_ATTRIBUTE14 in VARCHAR2
148 ,P_PJU_ATTRIBUTE15 in VARCHAR2
149 ,P_PJU_ATTRIBUTE16 in VARCHAR2
150 ,P_PJU_ATTRIBUTE17 in VARCHAR2
151 ,P_PJU_ATTRIBUTE18 in VARCHAR2
152 ,P_PJU_ATTRIBUTE19 in VARCHAR2
153 ,P_PJU_ATTRIBUTE20 in VARCHAR2
154 ,P_PJU_INFORMATION_CATEGORY in VARCHAR2
155 ,P_PJU_INFORMATION1 in VARCHAR2
156 ,P_PJU_INFORMATION2 in VARCHAR2
157 ,P_PJU_INFORMATION3 in VARCHAR2
158 ,P_PJU_INFORMATION4 in VARCHAR2
159 ,P_PJU_INFORMATION5 in VARCHAR2
160 ,P_PJU_INFORMATION6 in VARCHAR2
161 ,P_PJU_INFORMATION7 in VARCHAR2
162 ,P_PJU_INFORMATION8 in VARCHAR2
163 ,P_PJU_INFORMATION9 in VARCHAR2
164 ,P_PJU_INFORMATION10 in VARCHAR2
165 ,P_PJU_INFORMATION11 in VARCHAR2
166 ,P_PJU_INFORMATION12 in VARCHAR2
167 ,P_PJU_INFORMATION13 in VARCHAR2
168 ,P_PJU_INFORMATION14 in VARCHAR2
169 ,P_PJU_INFORMATION15 in VARCHAR2
170 ,P_PJU_INFORMATION16 in VARCHAR2
171 ,P_PJU_INFORMATION17 in VARCHAR2
172 ,P_PJU_INFORMATION18 in VARCHAR2
173 ,P_PJU_INFORMATION19 in VARCHAR2
174 ,P_PJU_INFORMATION20 in VARCHAR2
175 ,P_OBJECT_VERSION_NUMBER in NUMBER
176 )is
177 begin
178 hr_utility.set_location('Entering: HR_PREVIOUS_EMPLOYMENT_BK7.CREATE_PREVIOUS_JOB_USAGE_B', 10);
179 hr_utility.set_location(' Leaving: HR_PREVIOUS_EMPLOYMENT_BK7.CREATE_PREVIOUS_JOB_USAGE_B', 20);
180 end CREATE_PREVIOUS_JOB_USAGE_B;
181 end HR_PREVIOUS_EMPLOYMENT_BK7;