APPS.BEN_BNG_UPD dependencies on HR_API

Line 114: When hr_api.check_integrity_violated Then

110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
117: ben_bng_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
117: ben_bng_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
122: ben_bng_shd.constraint_error

Line 119: When hr_api.parent_integrity_violated Then

115: -- A check constraint has been violated
116: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
117: ben_bng_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
122: ben_bng_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
122: ben_bng_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
127: ben_bng_shd.constraint_error

Line 124: When hr_api.unique_integrity_violated Then

120: -- Parent integrity has been violated
121: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
122: ben_bng_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
127: ben_bng_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
127: ben_bng_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_bng_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
132: End update_dml;

Line 297: when hr_api.cannot_find_prog_unit then

293: );
294: --
295: exception
296: --
297: when hr_api.cannot_find_prog_unit then
298: --
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'ben_benfts_grp'
301: ,p_hook_type => 'AU');

Line 299: hr_api.cannot_find_prog_unit_error

295: exception
296: --
297: when hr_api.cannot_find_prog_unit then
298: --
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'ben_benfts_grp'
301: ,p_hook_type => 'AU');
302: --
303: end;

Line 367: If (p_rec.business_group_id = hr_api.g_number) then

363: -- p_rec plsql record structure
364: -- to see if a system default is being used. If a system default
365: -- is being used then we must set to the 'current' argument value.
366: --
367: If (p_rec.business_group_id = hr_api.g_number) then
368: p_rec.business_group_id :=
369: ben_bng_shd.g_old_rec.business_group_id;
370: End If;
371: If (p_rec.name = hr_api.g_varchar2) then

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

367: If (p_rec.business_group_id = hr_api.g_number) then
368: p_rec.business_group_id :=
369: ben_bng_shd.g_old_rec.business_group_id;
370: End If;
371: If (p_rec.name = hr_api.g_varchar2) then
372: p_rec.name :=
373: ben_bng_shd.g_old_rec.name;
374: End If;
375: If (p_rec.bng_desc = hr_api.g_varchar2) then

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

371: If (p_rec.name = hr_api.g_varchar2) then
372: p_rec.name :=
373: ben_bng_shd.g_old_rec.name;
374: End If;
375: If (p_rec.bng_desc = hr_api.g_varchar2) then
376: p_rec.bng_desc :=
377: ben_bng_shd.g_old_rec.bng_desc;
378: End If;
379: If (p_rec.bng_attribute_category = hr_api.g_varchar2) then

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

375: If (p_rec.bng_desc = hr_api.g_varchar2) then
376: p_rec.bng_desc :=
377: ben_bng_shd.g_old_rec.bng_desc;
378: End If;
379: If (p_rec.bng_attribute_category = hr_api.g_varchar2) then
380: p_rec.bng_attribute_category :=
381: ben_bng_shd.g_old_rec.bng_attribute_category;
382: End If;
383: If (p_rec.bng_attribute1 = hr_api.g_varchar2) then

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

379: If (p_rec.bng_attribute_category = hr_api.g_varchar2) then
380: p_rec.bng_attribute_category :=
381: ben_bng_shd.g_old_rec.bng_attribute_category;
382: End If;
383: If (p_rec.bng_attribute1 = hr_api.g_varchar2) then
384: p_rec.bng_attribute1 :=
385: ben_bng_shd.g_old_rec.bng_attribute1;
386: End If;
387: If (p_rec.bng_attribute2 = hr_api.g_varchar2) then

Line 387: If (p_rec.bng_attribute2 = hr_api.g_varchar2) then

383: If (p_rec.bng_attribute1 = hr_api.g_varchar2) then
384: p_rec.bng_attribute1 :=
385: ben_bng_shd.g_old_rec.bng_attribute1;
386: End If;
387: If (p_rec.bng_attribute2 = hr_api.g_varchar2) then
388: p_rec.bng_attribute2 :=
389: ben_bng_shd.g_old_rec.bng_attribute2;
390: End If;
391: If (p_rec.bng_attribute3 = hr_api.g_varchar2) then

Line 391: If (p_rec.bng_attribute3 = hr_api.g_varchar2) then

387: If (p_rec.bng_attribute2 = hr_api.g_varchar2) then
388: p_rec.bng_attribute2 :=
389: ben_bng_shd.g_old_rec.bng_attribute2;
390: End If;
391: If (p_rec.bng_attribute3 = hr_api.g_varchar2) then
392: p_rec.bng_attribute3 :=
393: ben_bng_shd.g_old_rec.bng_attribute3;
394: End If;
395: If (p_rec.bng_attribute4 = hr_api.g_varchar2) then

Line 395: If (p_rec.bng_attribute4 = hr_api.g_varchar2) then

391: If (p_rec.bng_attribute3 = hr_api.g_varchar2) then
392: p_rec.bng_attribute3 :=
393: ben_bng_shd.g_old_rec.bng_attribute3;
394: End If;
395: If (p_rec.bng_attribute4 = hr_api.g_varchar2) then
396: p_rec.bng_attribute4 :=
397: ben_bng_shd.g_old_rec.bng_attribute4;
398: End If;
399: If (p_rec.bng_attribute5 = hr_api.g_varchar2) then

Line 399: If (p_rec.bng_attribute5 = hr_api.g_varchar2) then

395: If (p_rec.bng_attribute4 = hr_api.g_varchar2) then
396: p_rec.bng_attribute4 :=
397: ben_bng_shd.g_old_rec.bng_attribute4;
398: End If;
399: If (p_rec.bng_attribute5 = hr_api.g_varchar2) then
400: p_rec.bng_attribute5 :=
401: ben_bng_shd.g_old_rec.bng_attribute5;
402: End If;
403: If (p_rec.bng_attribute6 = hr_api.g_varchar2) then

Line 403: If (p_rec.bng_attribute6 = hr_api.g_varchar2) then

399: If (p_rec.bng_attribute5 = hr_api.g_varchar2) then
400: p_rec.bng_attribute5 :=
401: ben_bng_shd.g_old_rec.bng_attribute5;
402: End If;
403: If (p_rec.bng_attribute6 = hr_api.g_varchar2) then
404: p_rec.bng_attribute6 :=
405: ben_bng_shd.g_old_rec.bng_attribute6;
406: End If;
407: If (p_rec.bng_attribute7 = hr_api.g_varchar2) then

Line 407: If (p_rec.bng_attribute7 = hr_api.g_varchar2) then

403: If (p_rec.bng_attribute6 = hr_api.g_varchar2) then
404: p_rec.bng_attribute6 :=
405: ben_bng_shd.g_old_rec.bng_attribute6;
406: End If;
407: If (p_rec.bng_attribute7 = hr_api.g_varchar2) then
408: p_rec.bng_attribute7 :=
409: ben_bng_shd.g_old_rec.bng_attribute7;
410: End If;
411: If (p_rec.bng_attribute8 = hr_api.g_varchar2) then

Line 411: If (p_rec.bng_attribute8 = hr_api.g_varchar2) then

407: If (p_rec.bng_attribute7 = hr_api.g_varchar2) then
408: p_rec.bng_attribute7 :=
409: ben_bng_shd.g_old_rec.bng_attribute7;
410: End If;
411: If (p_rec.bng_attribute8 = hr_api.g_varchar2) then
412: p_rec.bng_attribute8 :=
413: ben_bng_shd.g_old_rec.bng_attribute8;
414: End If;
415: If (p_rec.bng_attribute9 = hr_api.g_varchar2) then

Line 415: If (p_rec.bng_attribute9 = hr_api.g_varchar2) then

411: If (p_rec.bng_attribute8 = hr_api.g_varchar2) then
412: p_rec.bng_attribute8 :=
413: ben_bng_shd.g_old_rec.bng_attribute8;
414: End If;
415: If (p_rec.bng_attribute9 = hr_api.g_varchar2) then
416: p_rec.bng_attribute9 :=
417: ben_bng_shd.g_old_rec.bng_attribute9;
418: End If;
419: If (p_rec.bng_attribute10 = hr_api.g_varchar2) then

Line 419: If (p_rec.bng_attribute10 = hr_api.g_varchar2) then

415: If (p_rec.bng_attribute9 = hr_api.g_varchar2) then
416: p_rec.bng_attribute9 :=
417: ben_bng_shd.g_old_rec.bng_attribute9;
418: End If;
419: If (p_rec.bng_attribute10 = hr_api.g_varchar2) then
420: p_rec.bng_attribute10 :=
421: ben_bng_shd.g_old_rec.bng_attribute10;
422: End If;
423: If (p_rec.bng_attribute11 = hr_api.g_varchar2) then

Line 423: If (p_rec.bng_attribute11 = hr_api.g_varchar2) then

419: If (p_rec.bng_attribute10 = hr_api.g_varchar2) then
420: p_rec.bng_attribute10 :=
421: ben_bng_shd.g_old_rec.bng_attribute10;
422: End If;
423: If (p_rec.bng_attribute11 = hr_api.g_varchar2) then
424: p_rec.bng_attribute11 :=
425: ben_bng_shd.g_old_rec.bng_attribute11;
426: End If;
427: If (p_rec.bng_attribute12 = hr_api.g_varchar2) then

Line 427: If (p_rec.bng_attribute12 = hr_api.g_varchar2) then

423: If (p_rec.bng_attribute11 = hr_api.g_varchar2) then
424: p_rec.bng_attribute11 :=
425: ben_bng_shd.g_old_rec.bng_attribute11;
426: End If;
427: If (p_rec.bng_attribute12 = hr_api.g_varchar2) then
428: p_rec.bng_attribute12 :=
429: ben_bng_shd.g_old_rec.bng_attribute12;
430: End If;
431: If (p_rec.bng_attribute13 = hr_api.g_varchar2) then

Line 431: If (p_rec.bng_attribute13 = hr_api.g_varchar2) then

427: If (p_rec.bng_attribute12 = hr_api.g_varchar2) then
428: p_rec.bng_attribute12 :=
429: ben_bng_shd.g_old_rec.bng_attribute12;
430: End If;
431: If (p_rec.bng_attribute13 = hr_api.g_varchar2) then
432: p_rec.bng_attribute13 :=
433: ben_bng_shd.g_old_rec.bng_attribute13;
434: End If;
435: If (p_rec.bng_attribute14 = hr_api.g_varchar2) then

Line 435: If (p_rec.bng_attribute14 = hr_api.g_varchar2) then

431: If (p_rec.bng_attribute13 = hr_api.g_varchar2) then
432: p_rec.bng_attribute13 :=
433: ben_bng_shd.g_old_rec.bng_attribute13;
434: End If;
435: If (p_rec.bng_attribute14 = hr_api.g_varchar2) then
436: p_rec.bng_attribute14 :=
437: ben_bng_shd.g_old_rec.bng_attribute14;
438: End If;
439: If (p_rec.bng_attribute15 = hr_api.g_varchar2) then

Line 439: If (p_rec.bng_attribute15 = hr_api.g_varchar2) then

435: If (p_rec.bng_attribute14 = hr_api.g_varchar2) then
436: p_rec.bng_attribute14 :=
437: ben_bng_shd.g_old_rec.bng_attribute14;
438: End If;
439: If (p_rec.bng_attribute15 = hr_api.g_varchar2) then
440: p_rec.bng_attribute15 :=
441: ben_bng_shd.g_old_rec.bng_attribute15;
442: End If;
443: If (p_rec.bng_attribute16 = hr_api.g_varchar2) then

Line 443: If (p_rec.bng_attribute16 = hr_api.g_varchar2) then

439: If (p_rec.bng_attribute15 = hr_api.g_varchar2) then
440: p_rec.bng_attribute15 :=
441: ben_bng_shd.g_old_rec.bng_attribute15;
442: End If;
443: If (p_rec.bng_attribute16 = hr_api.g_varchar2) then
444: p_rec.bng_attribute16 :=
445: ben_bng_shd.g_old_rec.bng_attribute16;
446: End If;
447: If (p_rec.bng_attribute17 = hr_api.g_varchar2) then

Line 447: If (p_rec.bng_attribute17 = hr_api.g_varchar2) then

443: If (p_rec.bng_attribute16 = hr_api.g_varchar2) then
444: p_rec.bng_attribute16 :=
445: ben_bng_shd.g_old_rec.bng_attribute16;
446: End If;
447: If (p_rec.bng_attribute17 = hr_api.g_varchar2) then
448: p_rec.bng_attribute17 :=
449: ben_bng_shd.g_old_rec.bng_attribute17;
450: End If;
451: If (p_rec.bng_attribute18 = hr_api.g_varchar2) then

Line 451: If (p_rec.bng_attribute18 = hr_api.g_varchar2) then

447: If (p_rec.bng_attribute17 = hr_api.g_varchar2) then
448: p_rec.bng_attribute17 :=
449: ben_bng_shd.g_old_rec.bng_attribute17;
450: End If;
451: If (p_rec.bng_attribute18 = hr_api.g_varchar2) then
452: p_rec.bng_attribute18 :=
453: ben_bng_shd.g_old_rec.bng_attribute18;
454: End If;
455: If (p_rec.bng_attribute19 = hr_api.g_varchar2) then

Line 455: If (p_rec.bng_attribute19 = hr_api.g_varchar2) then

451: If (p_rec.bng_attribute18 = hr_api.g_varchar2) then
452: p_rec.bng_attribute18 :=
453: ben_bng_shd.g_old_rec.bng_attribute18;
454: End If;
455: If (p_rec.bng_attribute19 = hr_api.g_varchar2) then
456: p_rec.bng_attribute19 :=
457: ben_bng_shd.g_old_rec.bng_attribute19;
458: End If;
459: If (p_rec.bng_attribute20 = hr_api.g_varchar2) then

Line 459: If (p_rec.bng_attribute20 = hr_api.g_varchar2) then

455: If (p_rec.bng_attribute19 = hr_api.g_varchar2) then
456: p_rec.bng_attribute19 :=
457: ben_bng_shd.g_old_rec.bng_attribute19;
458: End If;
459: If (p_rec.bng_attribute20 = hr_api.g_varchar2) then
460: p_rec.bng_attribute20 :=
461: ben_bng_shd.g_old_rec.bng_attribute20;
462: End If;
463: If (p_rec.bng_attribute21 = hr_api.g_varchar2) then

Line 463: If (p_rec.bng_attribute21 = hr_api.g_varchar2) then

459: If (p_rec.bng_attribute20 = hr_api.g_varchar2) then
460: p_rec.bng_attribute20 :=
461: ben_bng_shd.g_old_rec.bng_attribute20;
462: End If;
463: If (p_rec.bng_attribute21 = hr_api.g_varchar2) then
464: p_rec.bng_attribute21 :=
465: ben_bng_shd.g_old_rec.bng_attribute21;
466: End If;
467: If (p_rec.bng_attribute22 = hr_api.g_varchar2) then

Line 467: If (p_rec.bng_attribute22 = hr_api.g_varchar2) then

463: If (p_rec.bng_attribute21 = hr_api.g_varchar2) then
464: p_rec.bng_attribute21 :=
465: ben_bng_shd.g_old_rec.bng_attribute21;
466: End If;
467: If (p_rec.bng_attribute22 = hr_api.g_varchar2) then
468: p_rec.bng_attribute22 :=
469: ben_bng_shd.g_old_rec.bng_attribute22;
470: End If;
471: If (p_rec.bng_attribute23 = hr_api.g_varchar2) then

Line 471: If (p_rec.bng_attribute23 = hr_api.g_varchar2) then

467: If (p_rec.bng_attribute22 = hr_api.g_varchar2) then
468: p_rec.bng_attribute22 :=
469: ben_bng_shd.g_old_rec.bng_attribute22;
470: End If;
471: If (p_rec.bng_attribute23 = hr_api.g_varchar2) then
472: p_rec.bng_attribute23 :=
473: ben_bng_shd.g_old_rec.bng_attribute23;
474: End If;
475: If (p_rec.bng_attribute24 = hr_api.g_varchar2) then

Line 475: If (p_rec.bng_attribute24 = hr_api.g_varchar2) then

471: If (p_rec.bng_attribute23 = hr_api.g_varchar2) then
472: p_rec.bng_attribute23 :=
473: ben_bng_shd.g_old_rec.bng_attribute23;
474: End If;
475: If (p_rec.bng_attribute24 = hr_api.g_varchar2) then
476: p_rec.bng_attribute24 :=
477: ben_bng_shd.g_old_rec.bng_attribute24;
478: End If;
479: If (p_rec.bng_attribute25 = hr_api.g_varchar2) then

Line 479: If (p_rec.bng_attribute25 = hr_api.g_varchar2) then

475: If (p_rec.bng_attribute24 = hr_api.g_varchar2) then
476: p_rec.bng_attribute24 :=
477: ben_bng_shd.g_old_rec.bng_attribute24;
478: End If;
479: If (p_rec.bng_attribute25 = hr_api.g_varchar2) then
480: p_rec.bng_attribute25 :=
481: ben_bng_shd.g_old_rec.bng_attribute25;
482: End If;
483: If (p_rec.bng_attribute26 = hr_api.g_varchar2) then

Line 483: If (p_rec.bng_attribute26 = hr_api.g_varchar2) then

479: If (p_rec.bng_attribute25 = hr_api.g_varchar2) then
480: p_rec.bng_attribute25 :=
481: ben_bng_shd.g_old_rec.bng_attribute25;
482: End If;
483: If (p_rec.bng_attribute26 = hr_api.g_varchar2) then
484: p_rec.bng_attribute26 :=
485: ben_bng_shd.g_old_rec.bng_attribute26;
486: End If;
487: If (p_rec.bng_attribute27 = hr_api.g_varchar2) then

Line 487: If (p_rec.bng_attribute27 = hr_api.g_varchar2) then

483: If (p_rec.bng_attribute26 = hr_api.g_varchar2) then
484: p_rec.bng_attribute26 :=
485: ben_bng_shd.g_old_rec.bng_attribute26;
486: End If;
487: If (p_rec.bng_attribute27 = hr_api.g_varchar2) then
488: p_rec.bng_attribute27 :=
489: ben_bng_shd.g_old_rec.bng_attribute27;
490: End If;
491: If (p_rec.bng_attribute28 = hr_api.g_varchar2) then

Line 491: If (p_rec.bng_attribute28 = hr_api.g_varchar2) then

487: If (p_rec.bng_attribute27 = hr_api.g_varchar2) then
488: p_rec.bng_attribute27 :=
489: ben_bng_shd.g_old_rec.bng_attribute27;
490: End If;
491: If (p_rec.bng_attribute28 = hr_api.g_varchar2) then
492: p_rec.bng_attribute28 :=
493: ben_bng_shd.g_old_rec.bng_attribute28;
494: End If;
495: If (p_rec.bng_attribute29 = hr_api.g_varchar2) then

Line 495: If (p_rec.bng_attribute29 = hr_api.g_varchar2) then

491: If (p_rec.bng_attribute28 = hr_api.g_varchar2) then
492: p_rec.bng_attribute28 :=
493: ben_bng_shd.g_old_rec.bng_attribute28;
494: End If;
495: If (p_rec.bng_attribute29 = hr_api.g_varchar2) then
496: p_rec.bng_attribute29 :=
497: ben_bng_shd.g_old_rec.bng_attribute29;
498: End If;
499: If (p_rec.bng_attribute30 = hr_api.g_varchar2) then

Line 499: If (p_rec.bng_attribute30 = hr_api.g_varchar2) then

495: If (p_rec.bng_attribute29 = hr_api.g_varchar2) then
496: p_rec.bng_attribute29 :=
497: ben_bng_shd.g_old_rec.bng_attribute29;
498: End If;
499: If (p_rec.bng_attribute30 = hr_api.g_varchar2) then
500: p_rec.bng_attribute30 :=
501: ben_bng_shd.g_old_rec.bng_attribute30;
502: End If;
503:

Line 558: p_business_group_id in number default hr_api.g_number,

554: -- ----------------------------------------------------------------------------
555: Procedure upd
556: (
557: p_benfts_grp_id in number,
558: p_business_group_id in number default hr_api.g_number,
559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,

Line 559: p_name in varchar2 default hr_api.g_varchar2,

555: Procedure upd
556: (
557: p_benfts_grp_id in number,
558: p_business_group_id in number default hr_api.g_number,
559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,

Line 560: p_bng_desc in varchar2 default hr_api.g_varchar2,

556: (
557: p_benfts_grp_id in number,
558: p_business_group_id in number default hr_api.g_number,
559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,

Line 561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,

557: p_benfts_grp_id in number,
558: p_business_group_id in number default hr_api.g_number,
559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,

Line 562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,

558: p_business_group_id in number default hr_api.g_number,
559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,

Line 563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,

559: p_name in varchar2 default hr_api.g_varchar2,
560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,

Line 564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,

560: p_bng_desc in varchar2 default hr_api.g_varchar2,
561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,

Line 565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,

561: p_bng_attribute_category in varchar2 default hr_api.g_varchar2,
562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,

Line 566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,

562: p_bng_attribute1 in varchar2 default hr_api.g_varchar2,
563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,

Line 567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,

563: p_bng_attribute2 in varchar2 default hr_api.g_varchar2,
564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,

Line 568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,

564: p_bng_attribute3 in varchar2 default hr_api.g_varchar2,
565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,

Line 569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,

565: p_bng_attribute4 in varchar2 default hr_api.g_varchar2,
566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,

Line 570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,

566: p_bng_attribute5 in varchar2 default hr_api.g_varchar2,
567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,

Line 571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,

567: p_bng_attribute6 in varchar2 default hr_api.g_varchar2,
568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,

Line 572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,

568: p_bng_attribute7 in varchar2 default hr_api.g_varchar2,
569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,

Line 573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,

569: p_bng_attribute8 in varchar2 default hr_api.g_varchar2,
570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,

Line 574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,

570: p_bng_attribute9 in varchar2 default hr_api.g_varchar2,
571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,

Line 575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,

571: p_bng_attribute10 in varchar2 default hr_api.g_varchar2,
572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,

Line 576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,

572: p_bng_attribute11 in varchar2 default hr_api.g_varchar2,
573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,

Line 577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,

573: p_bng_attribute12 in varchar2 default hr_api.g_varchar2,
574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,

Line 578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,

574: p_bng_attribute13 in varchar2 default hr_api.g_varchar2,
575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,

Line 579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,

575: p_bng_attribute14 in varchar2 default hr_api.g_varchar2,
576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,

Line 580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,

576: p_bng_attribute15 in varchar2 default hr_api.g_varchar2,
577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,

Line 581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,

577: p_bng_attribute16 in varchar2 default hr_api.g_varchar2,
578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,

Line 582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,

578: p_bng_attribute17 in varchar2 default hr_api.g_varchar2,
579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,

Line 583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,

579: p_bng_attribute18 in varchar2 default hr_api.g_varchar2,
580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,

Line 584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,

580: p_bng_attribute19 in varchar2 default hr_api.g_varchar2,
581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,

Line 585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,

581: p_bng_attribute20 in varchar2 default hr_api.g_varchar2,
582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,

Line 586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,

582: p_bng_attribute21 in varchar2 default hr_api.g_varchar2,
583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,

Line 587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,

583: p_bng_attribute22 in varchar2 default hr_api.g_varchar2,
584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,
591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,

Line 588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,

584: p_bng_attribute23 in varchar2 default hr_api.g_varchar2,
585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,
591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,
592: p_object_version_number in out nocopy number

Line 589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,

585: p_bng_attribute24 in varchar2 default hr_api.g_varchar2,
586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,
591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,
592: p_object_version_number in out nocopy number
593: ) is

Line 590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,

586: p_bng_attribute25 in varchar2 default hr_api.g_varchar2,
587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,
591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,
592: p_object_version_number in out nocopy number
593: ) is
594: --

Line 591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,

587: p_bng_attribute26 in varchar2 default hr_api.g_varchar2,
588: p_bng_attribute27 in varchar2 default hr_api.g_varchar2,
589: p_bng_attribute28 in varchar2 default hr_api.g_varchar2,
590: p_bng_attribute29 in varchar2 default hr_api.g_varchar2,
591: p_bng_attribute30 in varchar2 default hr_api.g_varchar2,
592: p_object_version_number in out nocopy number
593: ) is
594: --
595: l_rec ben_bng_shd.g_rec_type;