APPS.PAY_PMA_UPD dependencies on HR_API

Line 116: When hr_api.check_integrity_violated Then

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

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

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

Line 121: When hr_api.parent_integrity_violated Then

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

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

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

Line 126: When hr_api.unique_integrity_violated Then

122: -- Parent integrity has been violated
123: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
124: pay_pma_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
129: pay_pma_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.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
129: pay_pma_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End update_dml;

Line 303: when hr_api.cannot_find_prog_unit then

299: );
300: --
301: exception
302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'pay_ca_pmed_accounts'
307: ,p_hook_type => 'AU');

Line 305: hr_api.cannot_find_prog_unit_error

301: exception
302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'pay_ca_pmed_accounts'
307: ,p_hook_type => 'AU');
308: --
309: end;

Line 373: If (p_rec.organization_id = hr_api.g_number) then

369: -- p_rec plsql record structure
370: -- to see if a system default is being used. If a system default
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.organization_id = hr_api.g_number) then
374: p_rec.organization_id :=
375: pay_pma_shd.g_old_rec.organization_id;
376: End If;
377: If (p_rec.account_number = hr_api.g_varchar2) then

Line 377: If (p_rec.account_number = hr_api.g_varchar2) then

373: If (p_rec.organization_id = hr_api.g_number) then
374: p_rec.organization_id :=
375: pay_pma_shd.g_old_rec.organization_id;
376: End If;
377: If (p_rec.account_number = hr_api.g_varchar2) then
378: p_rec.account_number :=
379: pay_pma_shd.g_old_rec.account_number;
380: End If;
381: If (p_rec.enabled = hr_api.g_varchar2) then

Line 381: If (p_rec.enabled = hr_api.g_varchar2) then

377: If (p_rec.account_number = hr_api.g_varchar2) then
378: p_rec.account_number :=
379: pay_pma_shd.g_old_rec.account_number;
380: End If;
381: If (p_rec.enabled = hr_api.g_varchar2) then
382: p_rec.enabled :=
383: pay_pma_shd.g_old_rec.enabled;
384: End If;
385: If (p_rec.description = hr_api.g_varchar2) then

Line 385: If (p_rec.description = hr_api.g_varchar2) then

381: If (p_rec.enabled = hr_api.g_varchar2) then
382: p_rec.enabled :=
383: pay_pma_shd.g_old_rec.enabled;
384: End If;
385: If (p_rec.description = hr_api.g_varchar2) then
386: p_rec.description :=
387: pay_pma_shd.g_old_rec.description;
388: End If;
389: If (p_rec.business_group_id = hr_api.g_number) then

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

385: If (p_rec.description = hr_api.g_varchar2) then
386: p_rec.description :=
387: pay_pma_shd.g_old_rec.description;
388: End If;
389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: pay_pma_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: pay_pma_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: pay_pma_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: pay_pma_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: pay_pma_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: pay_pma_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: pay_pma_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: pay_pma_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: pay_pma_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: pay_pma_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: pay_pma_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: pay_pma_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: pay_pma_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: pay_pma_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: pay_pma_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: pay_pma_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: pay_pma_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: pay_pma_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: pay_pma_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: pay_pma_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: pay_pma_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: pay_pma_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: pay_pma_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: pay_pma_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: pay_pma_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: pay_pma_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: pay_pma_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: pay_pma_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: pay_pma_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: pay_pma_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: pay_pma_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: pay_pma_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: pay_pma_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: pay_pma_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: pay_pma_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: pay_pma_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: pay_pma_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: pay_pma_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: pay_pma_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: pay_pma_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: pay_pma_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: pay_pma_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: pay_pma_shd.g_old_rec.attribute20;
476: End If;
477: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 477: If (p_rec.attribute21 = hr_api.g_varchar2) then

473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: pay_pma_shd.g_old_rec.attribute20;
476: End If;
477: If (p_rec.attribute21 = hr_api.g_varchar2) then
478: p_rec.attribute21 :=
479: pay_pma_shd.g_old_rec.attribute21;
480: End If;
481: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 481: If (p_rec.attribute22 = hr_api.g_varchar2) then

477: If (p_rec.attribute21 = hr_api.g_varchar2) then
478: p_rec.attribute21 :=
479: pay_pma_shd.g_old_rec.attribute21;
480: End If;
481: If (p_rec.attribute22 = hr_api.g_varchar2) then
482: p_rec.attribute22 :=
483: pay_pma_shd.g_old_rec.attribute22;
484: End If;
485: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute23 = hr_api.g_varchar2) then

481: If (p_rec.attribute22 = hr_api.g_varchar2) then
482: p_rec.attribute22 :=
483: pay_pma_shd.g_old_rec.attribute22;
484: End If;
485: If (p_rec.attribute23 = hr_api.g_varchar2) then
486: p_rec.attribute23 :=
487: pay_pma_shd.g_old_rec.attribute23;
488: End If;
489: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute24 = hr_api.g_varchar2) then

485: If (p_rec.attribute23 = hr_api.g_varchar2) then
486: p_rec.attribute23 :=
487: pay_pma_shd.g_old_rec.attribute23;
488: End If;
489: If (p_rec.attribute24 = hr_api.g_varchar2) then
490: p_rec.attribute24 :=
491: pay_pma_shd.g_old_rec.attribute24;
492: End If;
493: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute25 = hr_api.g_varchar2) then

489: If (p_rec.attribute24 = hr_api.g_varchar2) then
490: p_rec.attribute24 :=
491: pay_pma_shd.g_old_rec.attribute24;
492: End If;
493: If (p_rec.attribute25 = hr_api.g_varchar2) then
494: p_rec.attribute25 :=
495: pay_pma_shd.g_old_rec.attribute25;
496: End If;
497: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute26 = hr_api.g_varchar2) then

493: If (p_rec.attribute25 = hr_api.g_varchar2) then
494: p_rec.attribute25 :=
495: pay_pma_shd.g_old_rec.attribute25;
496: End If;
497: If (p_rec.attribute26 = hr_api.g_varchar2) then
498: p_rec.attribute26 :=
499: pay_pma_shd.g_old_rec.attribute26;
500: End If;
501: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute27 = hr_api.g_varchar2) then

497: If (p_rec.attribute26 = hr_api.g_varchar2) then
498: p_rec.attribute26 :=
499: pay_pma_shd.g_old_rec.attribute26;
500: End If;
501: If (p_rec.attribute27 = hr_api.g_varchar2) then
502: p_rec.attribute27 :=
503: pay_pma_shd.g_old_rec.attribute27;
504: End If;
505: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute28 = hr_api.g_varchar2) then

501: If (p_rec.attribute27 = hr_api.g_varchar2) then
502: p_rec.attribute27 :=
503: pay_pma_shd.g_old_rec.attribute27;
504: End If;
505: If (p_rec.attribute28 = hr_api.g_varchar2) then
506: p_rec.attribute28 :=
507: pay_pma_shd.g_old_rec.attribute28;
508: End If;
509: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute29 = hr_api.g_varchar2) then

505: If (p_rec.attribute28 = hr_api.g_varchar2) then
506: p_rec.attribute28 :=
507: pay_pma_shd.g_old_rec.attribute28;
508: End If;
509: If (p_rec.attribute29 = hr_api.g_varchar2) then
510: p_rec.attribute29 :=
511: pay_pma_shd.g_old_rec.attribute29;
512: End If;
513: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 513: If (p_rec.attribute30 = hr_api.g_varchar2) then

509: If (p_rec.attribute29 = hr_api.g_varchar2) then
510: p_rec.attribute29 :=
511: pay_pma_shd.g_old_rec.attribute29;
512: End If;
513: If (p_rec.attribute30 = hr_api.g_varchar2) then
514: p_rec.attribute30 :=
515: pay_pma_shd.g_old_rec.attribute30;
516: End If;
517:

Line 571: p_organization_id in number default hr_api.g_number,

567: -- |---------------------------------< upd >----------------------------------|
568: -- ----------------------------------------------------------------------------
569: Procedure upd
570: (
571: p_organization_id in number default hr_api.g_number,
572: p_source_id in number,
573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,

Line 573: p_account_number in varchar2 default hr_api.g_varchar2,

569: Procedure upd
570: (
571: p_organization_id in number default hr_api.g_number,
572: p_source_id in number,
573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 574: p_enabled in varchar2 default hr_api.g_varchar2,

570: (
571: p_organization_id in number default hr_api.g_number,
572: p_source_id in number,
573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 575: p_description in varchar2 default hr_api.g_varchar2,

571: p_organization_id in number default hr_api.g_number,
572: p_source_id in number,
573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 576: p_business_group_id in number default hr_api.g_number,

572: p_source_id in number,
573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 577: p_attribute_category in varchar2 default hr_api.g_varchar2,

573: p_account_number in varchar2 default hr_api.g_varchar2,
574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 578: p_attribute1 in varchar2 default hr_api.g_varchar2,

574: p_enabled in varchar2 default hr_api.g_varchar2,
575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 579: p_attribute2 in varchar2 default hr_api.g_varchar2,

575: p_description in varchar2 default hr_api.g_varchar2,
576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 580: p_attribute3 in varchar2 default hr_api.g_varchar2,

576: p_business_group_id in number default hr_api.g_number,
577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 581: p_attribute4 in varchar2 default hr_api.g_varchar2,

577: p_attribute_category in varchar2 default hr_api.g_varchar2,
578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 582: p_attribute5 in varchar2 default hr_api.g_varchar2,

578: p_attribute1 in varchar2 default hr_api.g_varchar2,
579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 583: p_attribute6 in varchar2 default hr_api.g_varchar2,

579: p_attribute2 in varchar2 default hr_api.g_varchar2,
580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 584: p_attribute7 in varchar2 default hr_api.g_varchar2,

580: p_attribute3 in varchar2 default hr_api.g_varchar2,
581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 585: p_attribute8 in varchar2 default hr_api.g_varchar2,

581: p_attribute4 in varchar2 default hr_api.g_varchar2,
582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 586: p_attribute9 in varchar2 default hr_api.g_varchar2,

582: p_attribute5 in varchar2 default hr_api.g_varchar2,
583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 587: p_attribute10 in varchar2 default hr_api.g_varchar2,

583: p_attribute6 in varchar2 default hr_api.g_varchar2,
584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 588: p_attribute11 in varchar2 default hr_api.g_varchar2,

584: p_attribute7 in varchar2 default hr_api.g_varchar2,
585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 589: p_attribute12 in varchar2 default hr_api.g_varchar2,

585: p_attribute8 in varchar2 default hr_api.g_varchar2,
586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 590: p_attribute13 in varchar2 default hr_api.g_varchar2,

586: p_attribute9 in varchar2 default hr_api.g_varchar2,
587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 591: p_attribute14 in varchar2 default hr_api.g_varchar2,

587: p_attribute10 in varchar2 default hr_api.g_varchar2,
588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 592: p_attribute15 in varchar2 default hr_api.g_varchar2,

588: p_attribute11 in varchar2 default hr_api.g_varchar2,
589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 593: p_attribute16 in varchar2 default hr_api.g_varchar2,

589: p_attribute12 in varchar2 default hr_api.g_varchar2,
590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 594: p_attribute17 in varchar2 default hr_api.g_varchar2,

590: p_attribute13 in varchar2 default hr_api.g_varchar2,
591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 595: p_attribute18 in varchar2 default hr_api.g_varchar2,

591: p_attribute14 in varchar2 default hr_api.g_varchar2,
592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 596: p_attribute19 in varchar2 default hr_api.g_varchar2,

592: p_attribute15 in varchar2 default hr_api.g_varchar2,
593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 597: p_attribute20 in varchar2 default hr_api.g_varchar2,

593: p_attribute16 in varchar2 default hr_api.g_varchar2,
594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 598: p_attribute21 in varchar2 default hr_api.g_varchar2,

594: p_attribute17 in varchar2 default hr_api.g_varchar2,
595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 599: p_attribute22 in varchar2 default hr_api.g_varchar2,

595: p_attribute18 in varchar2 default hr_api.g_varchar2,
596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 600: p_attribute23 in varchar2 default hr_api.g_varchar2,

596: p_attribute19 in varchar2 default hr_api.g_varchar2,
597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 601: p_attribute24 in varchar2 default hr_api.g_varchar2,

597: p_attribute20 in varchar2 default hr_api.g_varchar2,
598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 602: p_attribute25 in varchar2 default hr_api.g_varchar2,

598: p_attribute21 in varchar2 default hr_api.g_varchar2,
599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 603: p_attribute26 in varchar2 default hr_api.g_varchar2,

599: p_attribute22 in varchar2 default hr_api.g_varchar2,
600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,
607: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 604: p_attribute27 in varchar2 default hr_api.g_varchar2,

600: p_attribute23 in varchar2 default hr_api.g_varchar2,
601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,
607: p_attribute30 in varchar2 default hr_api.g_varchar2,
608: p_object_version_number in out nocopy number

Line 605: p_attribute28 in varchar2 default hr_api.g_varchar2,

601: p_attribute24 in varchar2 default hr_api.g_varchar2,
602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,
607: p_attribute30 in varchar2 default hr_api.g_varchar2,
608: p_object_version_number in out nocopy number
609: ) is

Line 606: p_attribute29 in varchar2 default hr_api.g_varchar2,

602: p_attribute25 in varchar2 default hr_api.g_varchar2,
603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,
607: p_attribute30 in varchar2 default hr_api.g_varchar2,
608: p_object_version_number in out nocopy number
609: ) is
610: --

Line 607: p_attribute30 in varchar2 default hr_api.g_varchar2,

603: p_attribute26 in varchar2 default hr_api.g_varchar2,
604: p_attribute27 in varchar2 default hr_api.g_varchar2,
605: p_attribute28 in varchar2 default hr_api.g_varchar2,
606: p_attribute29 in varchar2 default hr_api.g_varchar2,
607: p_attribute30 in varchar2 default hr_api.g_varchar2,
608: p_object_version_number in out nocopy number
609: ) is
610: --
611: l_rec pay_pma_shd.g_rec_type;