APPS.PER_PSS_UPD dependencies on HR_API

Line 102: When hr_api.check_integrity_violated Then

98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 10);
100: --
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_pss_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then

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

101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_pss_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 106: When hr_api.parent_integrity_violated Then

102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_pss_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then

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

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_pss_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 110: When hr_api.unique_integrity_violated Then

106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_pss_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then

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

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_pss_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: Raise;
116: End update_dml;
117: --

Line 313: when hr_api.cannot_find_prog_unit then

309: => per_pss_shd.g_old_rec.attribute20
310: );
311:
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'PER_SALARY_SURVEYS'
316: ,p_hook_type => 'AU'
317: );

Line 314: hr_api.cannot_find_prog_unit_error

310: );
311:
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'PER_SALARY_SURVEYS'
316: ,p_hook_type => 'AU'
317: );
318: end;

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

377: -- p_rec plsql record structure
378: -- to see if a system default is being used. If a system default
379: -- is being used then we must set to the 'current' argument value.
380: --
381: If (p_rec.survey_name = hr_api.g_varchar2) then
382: p_rec.survey_name :=
383: per_pss_shd.g_old_rec.survey_name;
384: End If;
385: If (p_rec.survey_company_code = hr_api.g_varchar2) then

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

381: If (p_rec.survey_name = hr_api.g_varchar2) then
382: p_rec.survey_name :=
383: per_pss_shd.g_old_rec.survey_name;
384: End If;
385: If (p_rec.survey_company_code = hr_api.g_varchar2) then
386: p_rec.survey_company_code :=
387: per_pss_shd.g_old_rec.survey_company_code;
388: End If;
389: If (p_rec.identifier = hr_api.g_varchar2) then

Line 389: If (p_rec.identifier = hr_api.g_varchar2) then

385: If (p_rec.survey_company_code = hr_api.g_varchar2) then
386: p_rec.survey_company_code :=
387: per_pss_shd.g_old_rec.survey_company_code;
388: End If;
389: If (p_rec.identifier = hr_api.g_varchar2) then
390: p_rec.identifier :=
391: per_pss_shd.g_old_rec.identifier;
392: End If;
393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then

Line 393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then

389: If (p_rec.identifier = hr_api.g_varchar2) then
390: p_rec.identifier :=
391: per_pss_shd.g_old_rec.identifier;
392: End If;
393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then
394: --ras p_rec.currency_code :=
395: --ras per_pss_shd.g_old_rec.currency_code;
396: --ras End If;
397: If (p_rec.survey_type_code = hr_api.g_varchar2) then

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

393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then
394: --ras p_rec.currency_code :=
395: --ras per_pss_shd.g_old_rec.currency_code;
396: --ras End If;
397: If (p_rec.survey_type_code = hr_api.g_varchar2) then
398: p_rec.survey_type_code :=
399: per_pss_shd.g_old_rec.survey_type_code;
400: End If;
401: If (p_rec.base_region = hr_api.g_varchar2) then

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

397: If (p_rec.survey_type_code = hr_api.g_varchar2) then
398: p_rec.survey_type_code :=
399: per_pss_shd.g_old_rec.survey_type_code;
400: End If;
401: If (p_rec.base_region = hr_api.g_varchar2) then
402: p_rec.base_region :=
403: per_pss_shd.g_old_rec.base_region;
404: End If;
405: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

401: If (p_rec.base_region = hr_api.g_varchar2) then
402: p_rec.base_region :=
403: per_pss_shd.g_old_rec.base_region;
404: End If;
405: If (p_rec.attribute_category = hr_api.g_varchar2) then
406: p_rec.attribute_category :=
407: per_pss_shd.g_old_rec.attribute_category;
408: End If;
409: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

405: If (p_rec.attribute_category = hr_api.g_varchar2) then
406: p_rec.attribute_category :=
407: per_pss_shd.g_old_rec.attribute_category;
408: End If;
409: If (p_rec.attribute1 = hr_api.g_varchar2) then
410: p_rec.attribute1 :=
411: per_pss_shd.g_old_rec.attribute1;
412: End If;
413: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

409: If (p_rec.attribute1 = hr_api.g_varchar2) then
410: p_rec.attribute1 :=
411: per_pss_shd.g_old_rec.attribute1;
412: End If;
413: If (p_rec.attribute2 = hr_api.g_varchar2) then
414: p_rec.attribute2 :=
415: per_pss_shd.g_old_rec.attribute2;
416: End If;
417: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

413: If (p_rec.attribute2 = hr_api.g_varchar2) then
414: p_rec.attribute2 :=
415: per_pss_shd.g_old_rec.attribute2;
416: End If;
417: If (p_rec.attribute3 = hr_api.g_varchar2) then
418: p_rec.attribute3 :=
419: per_pss_shd.g_old_rec.attribute3;
420: End If;
421: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

417: If (p_rec.attribute3 = hr_api.g_varchar2) then
418: p_rec.attribute3 :=
419: per_pss_shd.g_old_rec.attribute3;
420: End If;
421: If (p_rec.attribute4 = hr_api.g_varchar2) then
422: p_rec.attribute4 :=
423: per_pss_shd.g_old_rec.attribute4;
424: End If;
425: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

421: If (p_rec.attribute4 = hr_api.g_varchar2) then
422: p_rec.attribute4 :=
423: per_pss_shd.g_old_rec.attribute4;
424: End If;
425: If (p_rec.attribute5 = hr_api.g_varchar2) then
426: p_rec.attribute5 :=
427: per_pss_shd.g_old_rec.attribute5;
428: End If;
429: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

425: If (p_rec.attribute5 = hr_api.g_varchar2) then
426: p_rec.attribute5 :=
427: per_pss_shd.g_old_rec.attribute5;
428: End If;
429: If (p_rec.attribute6 = hr_api.g_varchar2) then
430: p_rec.attribute6 :=
431: per_pss_shd.g_old_rec.attribute6;
432: End If;
433: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

429: If (p_rec.attribute6 = hr_api.g_varchar2) then
430: p_rec.attribute6 :=
431: per_pss_shd.g_old_rec.attribute6;
432: End If;
433: If (p_rec.attribute7 = hr_api.g_varchar2) then
434: p_rec.attribute7 :=
435: per_pss_shd.g_old_rec.attribute7;
436: End If;
437: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

433: If (p_rec.attribute7 = hr_api.g_varchar2) then
434: p_rec.attribute7 :=
435: per_pss_shd.g_old_rec.attribute7;
436: End If;
437: If (p_rec.attribute8 = hr_api.g_varchar2) then
438: p_rec.attribute8 :=
439: per_pss_shd.g_old_rec.attribute8;
440: End If;
441: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

437: If (p_rec.attribute8 = hr_api.g_varchar2) then
438: p_rec.attribute8 :=
439: per_pss_shd.g_old_rec.attribute8;
440: End If;
441: If (p_rec.attribute9 = hr_api.g_varchar2) then
442: p_rec.attribute9 :=
443: per_pss_shd.g_old_rec.attribute9;
444: End If;
445: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

441: If (p_rec.attribute9 = hr_api.g_varchar2) then
442: p_rec.attribute9 :=
443: per_pss_shd.g_old_rec.attribute9;
444: End If;
445: If (p_rec.attribute10 = hr_api.g_varchar2) then
446: p_rec.attribute10 :=
447: per_pss_shd.g_old_rec.attribute10;
448: End If;
449: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

445: If (p_rec.attribute10 = hr_api.g_varchar2) then
446: p_rec.attribute10 :=
447: per_pss_shd.g_old_rec.attribute10;
448: End If;
449: If (p_rec.attribute11 = hr_api.g_varchar2) then
450: p_rec.attribute11 :=
451: per_pss_shd.g_old_rec.attribute11;
452: End If;
453: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

449: If (p_rec.attribute11 = hr_api.g_varchar2) then
450: p_rec.attribute11 :=
451: per_pss_shd.g_old_rec.attribute11;
452: End If;
453: If (p_rec.attribute12 = hr_api.g_varchar2) then
454: p_rec.attribute12 :=
455: per_pss_shd.g_old_rec.attribute12;
456: End If;
457: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

453: If (p_rec.attribute12 = hr_api.g_varchar2) then
454: p_rec.attribute12 :=
455: per_pss_shd.g_old_rec.attribute12;
456: End If;
457: If (p_rec.attribute13 = hr_api.g_varchar2) then
458: p_rec.attribute13 :=
459: per_pss_shd.g_old_rec.attribute13;
460: End If;
461: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

457: If (p_rec.attribute13 = hr_api.g_varchar2) then
458: p_rec.attribute13 :=
459: per_pss_shd.g_old_rec.attribute13;
460: End If;
461: If (p_rec.attribute14 = hr_api.g_varchar2) then
462: p_rec.attribute14 :=
463: per_pss_shd.g_old_rec.attribute14;
464: End If;
465: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

461: If (p_rec.attribute14 = hr_api.g_varchar2) then
462: p_rec.attribute14 :=
463: per_pss_shd.g_old_rec.attribute14;
464: End If;
465: If (p_rec.attribute15 = hr_api.g_varchar2) then
466: p_rec.attribute15 :=
467: per_pss_shd.g_old_rec.attribute15;
468: End If;
469: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

465: If (p_rec.attribute15 = hr_api.g_varchar2) then
466: p_rec.attribute15 :=
467: per_pss_shd.g_old_rec.attribute15;
468: End If;
469: If (p_rec.attribute16 = hr_api.g_varchar2) then
470: p_rec.attribute16 :=
471: per_pss_shd.g_old_rec.attribute16;
472: End If;
473: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

469: If (p_rec.attribute16 = hr_api.g_varchar2) then
470: p_rec.attribute16 :=
471: per_pss_shd.g_old_rec.attribute16;
472: End If;
473: If (p_rec.attribute17 = hr_api.g_varchar2) then
474: p_rec.attribute17 :=
475: per_pss_shd.g_old_rec.attribute17;
476: End If;
477: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

473: If (p_rec.attribute17 = hr_api.g_varchar2) then
474: p_rec.attribute17 :=
475: per_pss_shd.g_old_rec.attribute17;
476: End If;
477: If (p_rec.attribute18 = hr_api.g_varchar2) then
478: p_rec.attribute18 :=
479: per_pss_shd.g_old_rec.attribute18;
480: End If;
481: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

477: If (p_rec.attribute18 = hr_api.g_varchar2) then
478: p_rec.attribute18 :=
479: per_pss_shd.g_old_rec.attribute18;
480: End If;
481: If (p_rec.attribute19 = hr_api.g_varchar2) then
482: p_rec.attribute19 :=
483: per_pss_shd.g_old_rec.attribute19;
484: End If;
485: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

481: If (p_rec.attribute19 = hr_api.g_varchar2) then
482: p_rec.attribute19 :=
483: per_pss_shd.g_old_rec.attribute19;
484: End If;
485: If (p_rec.attribute20 = hr_api.g_varchar2) then
486: p_rec.attribute20 :=
487: per_pss_shd.g_old_rec.attribute20;
488: End If;
489: --

Line 545: p_survey_name in varchar2 default hr_api.g_varchar2,

541: Procedure upd
542: (
543: p_salary_survey_id in number,
544: p_object_version_number in out nocopy number,
545: p_survey_name in varchar2 default hr_api.g_varchar2,
546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,

542: (
543: p_salary_survey_id in number,
544: p_object_version_number in out nocopy number,
545: p_survey_name in varchar2 default hr_api.g_varchar2,
546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 547: p_survey_type_code in varchar2 default hr_api.g_varchar2,

543: p_salary_survey_id in number,
544: p_object_version_number in out nocopy number,
545: p_survey_name in varchar2 default hr_api.g_varchar2,
546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 548: p_base_region in varchar2 default hr_api.g_varchar2,

544: p_object_version_number in out nocopy number,
545: p_survey_name in varchar2 default hr_api.g_varchar2,
546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 549: p_attribute_category in varchar2 default hr_api.g_varchar2,

545: p_survey_name in varchar2 default hr_api.g_varchar2,
546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 550: p_attribute1 in varchar2 default hr_api.g_varchar2,

546: --ras p_currency_code in varchar2 default hr_api.g_varchar2,
547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 551: p_attribute2 in varchar2 default hr_api.g_varchar2,

547: p_survey_type_code in varchar2 default hr_api.g_varchar2,
548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 552: p_attribute3 in varchar2 default hr_api.g_varchar2,

548: p_base_region in varchar2 default hr_api.g_varchar2,
549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 553: p_attribute4 in varchar2 default hr_api.g_varchar2,

549: p_attribute_category in varchar2 default hr_api.g_varchar2,
550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 554: p_attribute5 in varchar2 default hr_api.g_varchar2,

550: p_attribute1 in varchar2 default hr_api.g_varchar2,
551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 555: p_attribute6 in varchar2 default hr_api.g_varchar2,

551: p_attribute2 in varchar2 default hr_api.g_varchar2,
552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 556: p_attribute7 in varchar2 default hr_api.g_varchar2,

552: p_attribute3 in varchar2 default hr_api.g_varchar2,
553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 557: p_attribute8 in varchar2 default hr_api.g_varchar2,

553: p_attribute4 in varchar2 default hr_api.g_varchar2,
554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 558: p_attribute9 in varchar2 default hr_api.g_varchar2,

554: p_attribute5 in varchar2 default hr_api.g_varchar2,
555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 559: p_attribute10 in varchar2 default hr_api.g_varchar2,

555: p_attribute6 in varchar2 default hr_api.g_varchar2,
556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 560: p_attribute11 in varchar2 default hr_api.g_varchar2,

556: p_attribute7 in varchar2 default hr_api.g_varchar2,
557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 561: p_attribute12 in varchar2 default hr_api.g_varchar2,

557: p_attribute8 in varchar2 default hr_api.g_varchar2,
558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 562: p_attribute13 in varchar2 default hr_api.g_varchar2,

558: p_attribute9 in varchar2 default hr_api.g_varchar2,
559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 563: p_attribute14 in varchar2 default hr_api.g_varchar2,

559: p_attribute10 in varchar2 default hr_api.g_varchar2,
560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 564: p_attribute15 in varchar2 default hr_api.g_varchar2,

560: p_attribute11 in varchar2 default hr_api.g_varchar2,
561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 565: p_attribute16 in varchar2 default hr_api.g_varchar2,

561: p_attribute12 in varchar2 default hr_api.g_varchar2,
562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 566: p_attribute17 in varchar2 default hr_api.g_varchar2,

562: p_attribute13 in varchar2 default hr_api.g_varchar2,
563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date

Line 567: p_attribute18 in varchar2 default hr_api.g_varchar2,

563: p_attribute14 in varchar2 default hr_api.g_varchar2,
564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date
571: ) is

Line 568: p_attribute19 in varchar2 default hr_api.g_varchar2,

564: p_attribute15 in varchar2 default hr_api.g_varchar2,
565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date
571: ) is
572: --

Line 569: p_attribute20 in varchar2 default hr_api.g_varchar2,

565: p_attribute16 in varchar2 default hr_api.g_varchar2,
566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date
571: ) is
572: --
573: l_rec per_pss_shd.g_rec_type;

Line 570: p_effective_date in date default hr_api.g_date

566: p_attribute17 in varchar2 default hr_api.g_varchar2,
567: p_attribute18 in varchar2 default hr_api.g_varchar2,
568: p_attribute19 in varchar2 default hr_api.g_varchar2,
569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date
571: ) is
572: --
573: l_rec per_pss_shd.g_rec_type;
574: l_proc varchar2(72) := g_package||'upd';

Line 588: hr_api.g_varchar2,

584: (
585: p_salary_survey_id,
586: p_object_version_number,
587: p_survey_name,
588: hr_api.g_varchar2,
589: hr_api.g_varchar2,
590: --ras p_currency_code,
591: p_survey_type_code,
592: p_base_region,

Line 589: hr_api.g_varchar2,

585: p_salary_survey_id,
586: p_object_version_number,
587: p_survey_name,
588: hr_api.g_varchar2,
589: hr_api.g_varchar2,
590: --ras p_currency_code,
591: p_survey_type_code,
592: p_base_region,
593: p_attribute_category,