DBA Data[Home] [Help]

APPS.PER_ZA_USER_HOOK_PKG dependencies on HR_UTILITY

Line 100: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

96: l_proc varchar2(40) := g_package||'validate_applicant';
97: l_person_type_id per_all_people_f.person_type_id%type;
98:
99: BEGIN
100: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
101: hr_utility.set_location(l_proc,1);
102:
103: -- Check/Find person type id
104: --

Line 101: hr_utility.set_location(l_proc,1);

97: l_person_type_id per_all_people_f.person_type_id%type;
98:
99: BEGIN
100: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
101: hr_utility.set_location(l_proc,1);
102:
103: -- Check/Find person type id
104: --
105: per_per_bus.chk_person_type

Line 111: hr_utility.set_location(l_proc,2);

107: , p_business_group_id => p_business_group_id
108: , p_expected_sys_type => 'APL'
109: );
110:
111: hr_utility.set_location(l_proc,2);
112:
113: -- Validate the person's race
114: --
115: validate_race

Line 121: hr_utility.set_location(l_proc,3);

117: , p_person_type_id => l_person_type_id
118: , p_race_code => p_per_information4
119: );
120:
121: hr_utility.set_location(l_proc,3);
122: END IF;
123: END validate_applicant;
124: -------------------------------------------------------------------------------
125: -- validate_employee

Line 147: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

143: l_proc varchar2(40) := g_package||'validate_employee';
144: l_person_type_id per_all_people_f.person_type_id%type;
145:
146: BEGIN
147: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
148: hr_utility.set_location(l_proc,1);
149:
150: -- Check/Find person type id
151: --

Line 148: hr_utility.set_location(l_proc,1);

144: l_person_type_id per_all_people_f.person_type_id%type;
145:
146: BEGIN
147: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
148: hr_utility.set_location(l_proc,1);
149:
150: -- Check/Find person type id
151: --
152: per_per_bus.chk_person_type

Line 158: hr_utility.set_location(l_proc,2);

154: , p_business_group_id => p_business_group_id
155: , p_expected_sys_type => 'EMP'
156: );
157:
158: hr_utility.set_location(l_proc,2);
159:
160: -- Validate the person's race
161: --
162: validate_race

Line 168: hr_utility.set_location(l_proc,3);

164: , p_person_type_id => l_person_type_id
165: , p_race_code => p_per_information4
166: );
167:
168: hr_utility.set_location(l_proc,3);
169: END IF;
170: END validate_employee;
171: -------------------------------------------------------------------------------
172: -- validate_cwk

Line 194: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

190: l_proc varchar2(40) := g_package||'validate_cwk';
191: l_person_type_id per_all_people_f.person_type_id%type;
192:
193: BEGIN
194: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
195: hr_utility.set_location(l_proc,1);
196:
197: -- Check/Find person type id
198: --

Line 195: hr_utility.set_location(l_proc,1);

191: l_person_type_id per_all_people_f.person_type_id%type;
192:
193: BEGIN
194: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
195: hr_utility.set_location(l_proc,1);
196:
197: -- Check/Find person type id
198: --
199: per_per_bus.chk_person_type

Line 205: hr_utility.set_location(l_proc,2);

201: , p_business_group_id => p_business_group_id
202: , p_expected_sys_type => 'CWK'
203: );
204:
205: hr_utility.set_location(l_proc,2);
206:
207: -- Validate the person's race
208: --
209: validate_race

Line 215: hr_utility.set_location(l_proc,3);

211: , p_person_type_id => l_person_type_id
212: , p_race_code => p_per_information4
213: );
214:
215: hr_utility.set_location(l_proc,3);
216: END IF;
217: END validate_cwk;
218: -------------------------------------------------------------------------------
219: -- validate_person

Line 259: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN

255: l_person_type_id per_all_people_f.person_type_id%type;
256: l_person_race per_all_people_f.per_information4%type;
257:
258: BEGIN
259: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
260: hr_utility.set_location(l_proc,1);
261:
262: -- If the person type id was not passed
263: --

Line 260: hr_utility.set_location(l_proc,1);

256: l_person_race per_all_people_f.per_information4%type;
257:
258: BEGIN
259: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
260: hr_utility.set_location(l_proc,1);
261:
262: -- If the person type id was not passed
263: --
264: IF p_person_type_id = hr_api.g_number THEN

Line 265: hr_utility.set_location(l_proc,2);

261:
262: -- If the person type id was not passed
263: --
264: IF p_person_type_id = hr_api.g_number THEN
265: hr_utility.set_location(l_proc,2);
266: -- Find the person's person type
267: --
268: OPEN c_person_person_type;
269: FETCH c_person_person_type INTO l_person_type_id;

Line 272: hr_utility.set_location(l_proc,3);

268: OPEN c_person_person_type;
269: FETCH c_person_person_type INTO l_person_type_id;
270: CLOSE c_person_person_type;
271: ELSE
272: hr_utility.set_location(l_proc,3);
273: l_person_type_id := p_person_type_id;
274: END IF;
275:
276: -- if the race field was not updated

Line 279: hr_utility.set_location(l_proc,4);

275:
276: -- if the race field was not updated
277: --
278: IF p_per_information4 = hr_api.g_varchar2 THEN
279: hr_utility.set_location(l_proc,4);
280: -- find the person's race
281: --
282: OPEN c_person_race;
283: FETCH c_person_race INTO l_person_race;

Line 286: hr_utility.set_location(l_proc,5);

282: OPEN c_person_race;
283: FETCH c_person_race INTO l_person_race;
284: CLOSE c_person_race;
285: ELSE
286: hr_utility.set_location(l_proc,5);
287: l_person_race := p_per_information4;
288: END IF;
289:
290: -- Validate the person's race

Line 298: hr_utility.set_location(l_proc,6);

294: , p_person_type_id => l_person_type_id
295: , p_race_code => l_person_race
296: );
297:
298: hr_utility.set_location(l_proc,6);
299: END IF;
300:
301: END validate_person;
302: