APPS.PER_ZA_EQT_UPD dependencies on HR_API

Line 126: When hr_api.check_integrity_violated Then

122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
129: per_za_eqt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
129: per_za_eqt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error

Line 131: When hr_api.parent_integrity_violated Then

127: -- A check constraint has been violated
128: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
129: per_za_eqt_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error

Line 136: When hr_api.unique_integrity_violated Then

132: -- Parent integrity has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;

Line 287: If (p_rec.name = hr_api.g_varchar2) then

283: -- p_rec plsql record structure
284: -- to see if a system default is being used. If a system default
285: -- is being used then we must set to the 'current' argument value.
286: --
287: If (p_rec.name = hr_api.g_varchar2) then
288: p_rec.name :=
289: per_za_eqt_shd.g_old_rec.name;
290: End If;
291: If (p_rec.nqf_qualification_type = hr_api.g_varchar2) then

Line 291: If (p_rec.nqf_qualification_type = hr_api.g_varchar2) then

287: If (p_rec.name = hr_api.g_varchar2) then
288: p_rec.name :=
289: per_za_eqt_shd.g_old_rec.name;
290: End If;
291: If (p_rec.nqf_qualification_type = hr_api.g_varchar2) then
292: p_rec.nqf_qualification_type :=
293: per_za_eqt_shd.g_old_rec.nqf_qualification_type;
294: End If;
295: If (p_rec.category = hr_api.g_varchar2) then

Line 295: If (p_rec.category = hr_api.g_varchar2) then

291: If (p_rec.nqf_qualification_type = hr_api.g_varchar2) then
292: p_rec.nqf_qualification_type :=
293: per_za_eqt_shd.g_old_rec.nqf_qualification_type;
294: End If;
295: If (p_rec.category = hr_api.g_varchar2) then
296: p_rec.category :=
297: per_za_eqt_shd.g_old_rec.category;
298: End If;
299: If (p_rec.rank = hr_api.g_number) then

Line 299: If (p_rec.rank = hr_api.g_number) then

295: If (p_rec.category = hr_api.g_varchar2) then
296: p_rec.category :=
297: per_za_eqt_shd.g_old_rec.category;
298: End If;
299: If (p_rec.rank = hr_api.g_number) then
300: p_rec.rank :=
301: per_za_eqt_shd.g_old_rec.rank;
302: End If;
303: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 303: If (p_rec.attribute_category = hr_api.g_varchar2) then

299: If (p_rec.rank = hr_api.g_number) then
300: p_rec.rank :=
301: per_za_eqt_shd.g_old_rec.rank;
302: End If;
303: If (p_rec.attribute_category = hr_api.g_varchar2) then
304: p_rec.attribute_category :=
305: per_za_eqt_shd.g_old_rec.attribute_category;
306: End If;
307: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 307: If (p_rec.attribute1 = hr_api.g_varchar2) then

303: If (p_rec.attribute_category = hr_api.g_varchar2) then
304: p_rec.attribute_category :=
305: per_za_eqt_shd.g_old_rec.attribute_category;
306: End If;
307: If (p_rec.attribute1 = hr_api.g_varchar2) then
308: p_rec.attribute1 :=
309: per_za_eqt_shd.g_old_rec.attribute1;
310: End If;
311: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 311: If (p_rec.attribute2 = hr_api.g_varchar2) then

307: If (p_rec.attribute1 = hr_api.g_varchar2) then
308: p_rec.attribute1 :=
309: per_za_eqt_shd.g_old_rec.attribute1;
310: End If;
311: If (p_rec.attribute2 = hr_api.g_varchar2) then
312: p_rec.attribute2 :=
313: per_za_eqt_shd.g_old_rec.attribute2;
314: End If;
315: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 315: If (p_rec.attribute3 = hr_api.g_varchar2) then

311: If (p_rec.attribute2 = hr_api.g_varchar2) then
312: p_rec.attribute2 :=
313: per_za_eqt_shd.g_old_rec.attribute2;
314: End If;
315: If (p_rec.attribute3 = hr_api.g_varchar2) then
316: p_rec.attribute3 :=
317: per_za_eqt_shd.g_old_rec.attribute3;
318: End If;
319: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 319: If (p_rec.attribute4 = hr_api.g_varchar2) then

315: If (p_rec.attribute3 = hr_api.g_varchar2) then
316: p_rec.attribute3 :=
317: per_za_eqt_shd.g_old_rec.attribute3;
318: End If;
319: If (p_rec.attribute4 = hr_api.g_varchar2) then
320: p_rec.attribute4 :=
321: per_za_eqt_shd.g_old_rec.attribute4;
322: End If;
323: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 323: If (p_rec.attribute5 = hr_api.g_varchar2) then

319: If (p_rec.attribute4 = hr_api.g_varchar2) then
320: p_rec.attribute4 :=
321: per_za_eqt_shd.g_old_rec.attribute4;
322: End If;
323: If (p_rec.attribute5 = hr_api.g_varchar2) then
324: p_rec.attribute5 :=
325: per_za_eqt_shd.g_old_rec.attribute5;
326: End If;
327: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 327: If (p_rec.attribute6 = hr_api.g_varchar2) then

323: If (p_rec.attribute5 = hr_api.g_varchar2) then
324: p_rec.attribute5 :=
325: per_za_eqt_shd.g_old_rec.attribute5;
326: End If;
327: If (p_rec.attribute6 = hr_api.g_varchar2) then
328: p_rec.attribute6 :=
329: per_za_eqt_shd.g_old_rec.attribute6;
330: End If;
331: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 331: If (p_rec.attribute7 = hr_api.g_varchar2) then

327: If (p_rec.attribute6 = hr_api.g_varchar2) then
328: p_rec.attribute6 :=
329: per_za_eqt_shd.g_old_rec.attribute6;
330: End If;
331: If (p_rec.attribute7 = hr_api.g_varchar2) then
332: p_rec.attribute7 :=
333: per_za_eqt_shd.g_old_rec.attribute7;
334: End If;
335: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 335: If (p_rec.attribute8 = hr_api.g_varchar2) then

331: If (p_rec.attribute7 = hr_api.g_varchar2) then
332: p_rec.attribute7 :=
333: per_za_eqt_shd.g_old_rec.attribute7;
334: End If;
335: If (p_rec.attribute8 = hr_api.g_varchar2) then
336: p_rec.attribute8 :=
337: per_za_eqt_shd.g_old_rec.attribute8;
338: End If;
339: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 339: If (p_rec.attribute9 = hr_api.g_varchar2) then

335: If (p_rec.attribute8 = hr_api.g_varchar2) then
336: p_rec.attribute8 :=
337: per_za_eqt_shd.g_old_rec.attribute8;
338: End If;
339: If (p_rec.attribute9 = hr_api.g_varchar2) then
340: p_rec.attribute9 :=
341: per_za_eqt_shd.g_old_rec.attribute9;
342: End If;
343: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 343: If (p_rec.attribute10 = hr_api.g_varchar2) then

339: If (p_rec.attribute9 = hr_api.g_varchar2) then
340: p_rec.attribute9 :=
341: per_za_eqt_shd.g_old_rec.attribute9;
342: End If;
343: If (p_rec.attribute10 = hr_api.g_varchar2) then
344: p_rec.attribute10 :=
345: per_za_eqt_shd.g_old_rec.attribute10;
346: End If;
347: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 347: If (p_rec.attribute11 = hr_api.g_varchar2) then

343: If (p_rec.attribute10 = hr_api.g_varchar2) then
344: p_rec.attribute10 :=
345: per_za_eqt_shd.g_old_rec.attribute10;
346: End If;
347: If (p_rec.attribute11 = hr_api.g_varchar2) then
348: p_rec.attribute11 :=
349: per_za_eqt_shd.g_old_rec.attribute11;
350: End If;
351: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 351: If (p_rec.attribute12 = hr_api.g_varchar2) then

347: If (p_rec.attribute11 = hr_api.g_varchar2) then
348: p_rec.attribute11 :=
349: per_za_eqt_shd.g_old_rec.attribute11;
350: End If;
351: If (p_rec.attribute12 = hr_api.g_varchar2) then
352: p_rec.attribute12 :=
353: per_za_eqt_shd.g_old_rec.attribute12;
354: End If;
355: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 355: If (p_rec.attribute13 = hr_api.g_varchar2) then

351: If (p_rec.attribute12 = hr_api.g_varchar2) then
352: p_rec.attribute12 :=
353: per_za_eqt_shd.g_old_rec.attribute12;
354: End If;
355: If (p_rec.attribute13 = hr_api.g_varchar2) then
356: p_rec.attribute13 :=
357: per_za_eqt_shd.g_old_rec.attribute13;
358: End If;
359: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 359: If (p_rec.attribute14 = hr_api.g_varchar2) then

355: If (p_rec.attribute13 = hr_api.g_varchar2) then
356: p_rec.attribute13 :=
357: per_za_eqt_shd.g_old_rec.attribute13;
358: End If;
359: If (p_rec.attribute14 = hr_api.g_varchar2) then
360: p_rec.attribute14 :=
361: per_za_eqt_shd.g_old_rec.attribute14;
362: End If;
363: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 363: If (p_rec.attribute15 = hr_api.g_varchar2) then

359: If (p_rec.attribute14 = hr_api.g_varchar2) then
360: p_rec.attribute14 :=
361: per_za_eqt_shd.g_old_rec.attribute14;
362: End If;
363: If (p_rec.attribute15 = hr_api.g_varchar2) then
364: p_rec.attribute15 :=
365: per_za_eqt_shd.g_old_rec.attribute15;
366: End If;
367: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 367: If (p_rec.attribute16 = hr_api.g_varchar2) then

363: If (p_rec.attribute15 = hr_api.g_varchar2) then
364: p_rec.attribute15 :=
365: per_za_eqt_shd.g_old_rec.attribute15;
366: End If;
367: If (p_rec.attribute16 = hr_api.g_varchar2) then
368: p_rec.attribute16 :=
369: per_za_eqt_shd.g_old_rec.attribute16;
370: End If;
371: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 371: If (p_rec.attribute17 = hr_api.g_varchar2) then

367: If (p_rec.attribute16 = hr_api.g_varchar2) then
368: p_rec.attribute16 :=
369: per_za_eqt_shd.g_old_rec.attribute16;
370: End If;
371: If (p_rec.attribute17 = hr_api.g_varchar2) then
372: p_rec.attribute17 :=
373: per_za_eqt_shd.g_old_rec.attribute17;
374: End If;
375: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 375: If (p_rec.attribute18 = hr_api.g_varchar2) then

371: If (p_rec.attribute17 = hr_api.g_varchar2) then
372: p_rec.attribute17 :=
373: per_za_eqt_shd.g_old_rec.attribute17;
374: End If;
375: If (p_rec.attribute18 = hr_api.g_varchar2) then
376: p_rec.attribute18 :=
377: per_za_eqt_shd.g_old_rec.attribute18;
378: End If;
379: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 379: If (p_rec.attribute19 = hr_api.g_varchar2) then

375: If (p_rec.attribute18 = hr_api.g_varchar2) then
376: p_rec.attribute18 :=
377: per_za_eqt_shd.g_old_rec.attribute18;
378: End If;
379: If (p_rec.attribute19 = hr_api.g_varchar2) then
380: p_rec.attribute19 :=
381: per_za_eqt_shd.g_old_rec.attribute19;
382: End If;
383: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 383: If (p_rec.attribute20 = hr_api.g_varchar2) then

379: If (p_rec.attribute19 = hr_api.g_varchar2) then
380: p_rec.attribute19 :=
381: per_za_eqt_shd.g_old_rec.attribute19;
382: End If;
383: If (p_rec.attribute20 = hr_api.g_varchar2) then
384: p_rec.attribute20 :=
385: per_za_eqt_shd.g_old_rec.attribute20;
386: End If;
387:

Line 449: Raise HR_Api.Validate_Enabled;

445: --
446: -- If we are validating then raise the Validate_Enabled exception
447: --
448: If p_validate then
449: Raise HR_Api.Validate_Enabled;
450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception

Line 454: When HR_Api.Validate_Enabled Then

450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: Exception
454: When HR_Api.Validate_Enabled Then
455: --
456: -- As the Validate_Enabled exception has been raised
457: -- we must rollback to the savepoint
458: --

Line 468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,

464: -- ----------------------------------------------------------------------------
465: Procedure upd
466: (
467: p_qualification_type_id in number,
468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,
469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 469: p_name in varchar2 default hr_api.g_varchar2,

465: Procedure upd
466: (
467: p_qualification_type_id in number,
468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,
469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 470: p_category in varchar2 default hr_api.g_varchar2,

466: (
467: p_qualification_type_id in number,
468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,
469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 471: p_rank in number default hr_api.g_number,

467: p_qualification_type_id in number,
468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,
469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 472: p_attribute_category in varchar2 default hr_api.g_varchar2,

468: p_nqf_qualification_type in varchar2 default hr_api.g_varchar2,
469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 473: p_attribute1 in varchar2 default hr_api.g_varchar2,

469: p_name in varchar2 default hr_api.g_varchar2,
470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 474: p_attribute2 in varchar2 default hr_api.g_varchar2,

470: p_category in varchar2 default hr_api.g_varchar2,
471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 475: p_attribute3 in varchar2 default hr_api.g_varchar2,

471: p_rank in number default hr_api.g_number,
472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 476: p_attribute4 in varchar2 default hr_api.g_varchar2,

472: p_attribute_category in varchar2 default hr_api.g_varchar2,
473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 477: p_attribute5 in varchar2 default hr_api.g_varchar2,

473: p_attribute1 in varchar2 default hr_api.g_varchar2,
474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 478: p_attribute6 in varchar2 default hr_api.g_varchar2,

474: p_attribute2 in varchar2 default hr_api.g_varchar2,
475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 479: p_attribute7 in varchar2 default hr_api.g_varchar2,

475: p_attribute3 in varchar2 default hr_api.g_varchar2,
476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 480: p_attribute8 in varchar2 default hr_api.g_varchar2,

476: p_attribute4 in varchar2 default hr_api.g_varchar2,
477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 481: p_attribute9 in varchar2 default hr_api.g_varchar2,

477: p_attribute5 in varchar2 default hr_api.g_varchar2,
478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 482: p_attribute10 in varchar2 default hr_api.g_varchar2,

478: p_attribute6 in varchar2 default hr_api.g_varchar2,
479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 483: p_attribute11 in varchar2 default hr_api.g_varchar2,

479: p_attribute7 in varchar2 default hr_api.g_varchar2,
480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 484: p_attribute12 in varchar2 default hr_api.g_varchar2,

480: p_attribute8 in varchar2 default hr_api.g_varchar2,
481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 485: p_attribute13 in varchar2 default hr_api.g_varchar2,

481: p_attribute9 in varchar2 default hr_api.g_varchar2,
482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 486: p_attribute14 in varchar2 default hr_api.g_varchar2,

482: p_attribute10 in varchar2 default hr_api.g_varchar2,
483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 487: p_attribute15 in varchar2 default hr_api.g_varchar2,

483: p_attribute11 in varchar2 default hr_api.g_varchar2,
484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 488: p_attribute16 in varchar2 default hr_api.g_varchar2,

484: p_attribute12 in varchar2 default hr_api.g_varchar2,
485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,
492: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 489: p_attribute17 in varchar2 default hr_api.g_varchar2,

485: p_attribute13 in varchar2 default hr_api.g_varchar2,
486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,
492: p_attribute20 in varchar2 default hr_api.g_varchar2,
493: p_object_version_number in out nocopy number,

Line 490: p_attribute18 in varchar2 default hr_api.g_varchar2,

486: p_attribute14 in varchar2 default hr_api.g_varchar2,
487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,
492: p_attribute20 in varchar2 default hr_api.g_varchar2,
493: p_object_version_number in out nocopy number,
494: p_effective_date in date,

Line 491: p_attribute19 in varchar2 default hr_api.g_varchar2,

487: p_attribute15 in varchar2 default hr_api.g_varchar2,
488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,
492: p_attribute20 in varchar2 default hr_api.g_varchar2,
493: p_object_version_number in out nocopy number,
494: p_effective_date in date,
495: p_validate in boolean default false

Line 492: p_attribute20 in varchar2 default hr_api.g_varchar2,

488: p_attribute16 in varchar2 default hr_api.g_varchar2,
489: p_attribute17 in varchar2 default hr_api.g_varchar2,
490: p_attribute18 in varchar2 default hr_api.g_varchar2,
491: p_attribute19 in varchar2 default hr_api.g_varchar2,
492: p_attribute20 in varchar2 default hr_api.g_varchar2,
493: p_object_version_number in out nocopy number,
494: p_effective_date in date,
495: p_validate in boolean default false
496: ) is