APPS.PER_SSM_UPD dependencies on HR_API

Line 105: When hr_api.check_integrity_violated Then

101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error

Line 110: When hr_api.parent_integrity_violated Then

106: -- A check constraint has been violated
107: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
108: per_ssm_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- Parent integrity has been violated
112: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
113: per_ssm_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
118: per_ssm_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_ssm_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End update_dml;

Line 270: when hr_api.cannot_find_prog_unit then

266: p_effective_date => p_effective_date
267: );
268: --
269: exception
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'PER_SALARY_SURVEY_MAPPINGS'
274: ,p_hook_type => 'AU'

Line 272: hr_api.cannot_find_prog_unit_error

268: --
269: exception
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'PER_SALARY_SURVEY_MAPPINGS'
274: ,p_hook_type => 'AU'
275: );
276: end;

Line 339: If (p_rec.parent_id = hr_api.g_number) then

335: -- p_rec plsql record structure
336: -- to see if a system default is being used. If a system default
337: -- is being used then we must set to the 'current' argument value.
338: --
339: If (p_rec.parent_id = hr_api.g_number) then
340: p_rec.parent_id :=
341: per_ssm_shd.g_old_rec.parent_id;
342: End If;
343: If (p_rec.parent_table_name = hr_api.g_varchar2) then

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

339: If (p_rec.parent_id = hr_api.g_number) then
340: p_rec.parent_id :=
341: per_ssm_shd.g_old_rec.parent_id;
342: End If;
343: If (p_rec.parent_table_name = hr_api.g_varchar2) then
344: p_rec.parent_table_name :=
345: per_ssm_shd.g_old_rec.parent_table_name;
346: End If;
347: If (p_rec.salary_survey_line_id = hr_api.g_number) then

Line 347: If (p_rec.salary_survey_line_id = hr_api.g_number) then

343: If (p_rec.parent_table_name = hr_api.g_varchar2) then
344: p_rec.parent_table_name :=
345: per_ssm_shd.g_old_rec.parent_table_name;
346: End If;
347: If (p_rec.salary_survey_line_id = hr_api.g_number) then
348: p_rec.salary_survey_line_id :=
349: per_ssm_shd.g_old_rec.salary_survey_line_id;
350: End If;
351: If (p_rec.business_group_id = hr_api.g_number) then

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

347: If (p_rec.salary_survey_line_id = hr_api.g_number) then
348: p_rec.salary_survey_line_id :=
349: per_ssm_shd.g_old_rec.salary_survey_line_id;
350: End If;
351: If (p_rec.business_group_id = hr_api.g_number) then
352: p_rec.business_group_id :=
353: per_ssm_shd.g_old_rec.business_group_id;
354: End If;
355: If (p_rec.location_id = hr_api.g_number) then

Line 355: If (p_rec.location_id = hr_api.g_number) then

351: If (p_rec.business_group_id = hr_api.g_number) then
352: p_rec.business_group_id :=
353: per_ssm_shd.g_old_rec.business_group_id;
354: End If;
355: If (p_rec.location_id = hr_api.g_number) then
356: p_rec.location_id :=
357: per_ssm_shd.g_old_rec.location_id;
358: End If;
359: If (p_rec.grade_id = hr_api.g_number) then

Line 359: If (p_rec.grade_id = hr_api.g_number) then

355: If (p_rec.location_id = hr_api.g_number) then
356: p_rec.location_id :=
357: per_ssm_shd.g_old_rec.location_id;
358: End If;
359: If (p_rec.grade_id = hr_api.g_number) then
360: p_rec.grade_id :=
361: per_ssm_shd.g_old_rec.grade_id;
362: End If;
363: If (p_rec.company_organization_id = hr_api.g_number) then

Line 363: If (p_rec.company_organization_id = hr_api.g_number) then

359: If (p_rec.grade_id = hr_api.g_number) then
360: p_rec.grade_id :=
361: per_ssm_shd.g_old_rec.grade_id;
362: End If;
363: If (p_rec.company_organization_id = hr_api.g_number) then
364: p_rec.company_organization_id :=
365: per_ssm_shd.g_old_rec.company_organization_id;
366: End If;
367: If (p_rec.company_age_code = hr_api.g_varchar2) then

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

363: If (p_rec.company_organization_id = hr_api.g_number) then
364: p_rec.company_organization_id :=
365: per_ssm_shd.g_old_rec.company_organization_id;
366: End If;
367: If (p_rec.company_age_code = hr_api.g_varchar2) then
368: p_rec.company_age_code :=
369: per_ssm_shd.g_old_rec.company_age_code;
370: End If;
371: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

367: If (p_rec.company_age_code = hr_api.g_varchar2) then
368: p_rec.company_age_code :=
369: per_ssm_shd.g_old_rec.company_age_code;
370: End If;
371: If (p_rec.attribute_category = hr_api.g_varchar2) then
372: p_rec.attribute_category :=
373: per_ssm_shd.g_old_rec.attribute_category;
374: End If;
375: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

371: If (p_rec.attribute_category = hr_api.g_varchar2) then
372: p_rec.attribute_category :=
373: per_ssm_shd.g_old_rec.attribute_category;
374: End If;
375: If (p_rec.attribute1 = hr_api.g_varchar2) then
376: p_rec.attribute1 :=
377: per_ssm_shd.g_old_rec.attribute1;
378: End If;
379: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

375: If (p_rec.attribute1 = hr_api.g_varchar2) then
376: p_rec.attribute1 :=
377: per_ssm_shd.g_old_rec.attribute1;
378: End If;
379: If (p_rec.attribute2 = hr_api.g_varchar2) then
380: p_rec.attribute2 :=
381: per_ssm_shd.g_old_rec.attribute2;
382: End If;
383: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

379: If (p_rec.attribute2 = hr_api.g_varchar2) then
380: p_rec.attribute2 :=
381: per_ssm_shd.g_old_rec.attribute2;
382: End If;
383: If (p_rec.attribute3 = hr_api.g_varchar2) then
384: p_rec.attribute3 :=
385: per_ssm_shd.g_old_rec.attribute3;
386: End If;
387: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

383: If (p_rec.attribute3 = hr_api.g_varchar2) then
384: p_rec.attribute3 :=
385: per_ssm_shd.g_old_rec.attribute3;
386: End If;
387: If (p_rec.attribute4 = hr_api.g_varchar2) then
388: p_rec.attribute4 :=
389: per_ssm_shd.g_old_rec.attribute4;
390: End If;
391: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

387: If (p_rec.attribute4 = hr_api.g_varchar2) then
388: p_rec.attribute4 :=
389: per_ssm_shd.g_old_rec.attribute4;
390: End If;
391: If (p_rec.attribute5 = hr_api.g_varchar2) then
392: p_rec.attribute5 :=
393: per_ssm_shd.g_old_rec.attribute5;
394: End If;
395: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

391: If (p_rec.attribute5 = hr_api.g_varchar2) then
392: p_rec.attribute5 :=
393: per_ssm_shd.g_old_rec.attribute5;
394: End If;
395: If (p_rec.attribute6 = hr_api.g_varchar2) then
396: p_rec.attribute6 :=
397: per_ssm_shd.g_old_rec.attribute6;
398: End If;
399: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

395: If (p_rec.attribute6 = hr_api.g_varchar2) then
396: p_rec.attribute6 :=
397: per_ssm_shd.g_old_rec.attribute6;
398: End If;
399: If (p_rec.attribute7 = hr_api.g_varchar2) then
400: p_rec.attribute7 :=
401: per_ssm_shd.g_old_rec.attribute7;
402: End If;
403: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

399: If (p_rec.attribute7 = hr_api.g_varchar2) then
400: p_rec.attribute7 :=
401: per_ssm_shd.g_old_rec.attribute7;
402: End If;
403: If (p_rec.attribute8 = hr_api.g_varchar2) then
404: p_rec.attribute8 :=
405: per_ssm_shd.g_old_rec.attribute8;
406: End If;
407: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

403: If (p_rec.attribute8 = hr_api.g_varchar2) then
404: p_rec.attribute8 :=
405: per_ssm_shd.g_old_rec.attribute8;
406: End If;
407: If (p_rec.attribute9 = hr_api.g_varchar2) then
408: p_rec.attribute9 :=
409: per_ssm_shd.g_old_rec.attribute9;
410: End If;
411: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

407: If (p_rec.attribute9 = hr_api.g_varchar2) then
408: p_rec.attribute9 :=
409: per_ssm_shd.g_old_rec.attribute9;
410: End If;
411: If (p_rec.attribute10 = hr_api.g_varchar2) then
412: p_rec.attribute10 :=
413: per_ssm_shd.g_old_rec.attribute10;
414: End If;
415: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

411: If (p_rec.attribute10 = hr_api.g_varchar2) then
412: p_rec.attribute10 :=
413: per_ssm_shd.g_old_rec.attribute10;
414: End If;
415: If (p_rec.attribute11 = hr_api.g_varchar2) then
416: p_rec.attribute11 :=
417: per_ssm_shd.g_old_rec.attribute11;
418: End If;
419: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

415: If (p_rec.attribute11 = hr_api.g_varchar2) then
416: p_rec.attribute11 :=
417: per_ssm_shd.g_old_rec.attribute11;
418: End If;
419: If (p_rec.attribute12 = hr_api.g_varchar2) then
420: p_rec.attribute12 :=
421: per_ssm_shd.g_old_rec.attribute12;
422: End If;
423: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

419: If (p_rec.attribute12 = hr_api.g_varchar2) then
420: p_rec.attribute12 :=
421: per_ssm_shd.g_old_rec.attribute12;
422: End If;
423: If (p_rec.attribute13 = hr_api.g_varchar2) then
424: p_rec.attribute13 :=
425: per_ssm_shd.g_old_rec.attribute13;
426: End If;
427: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

423: If (p_rec.attribute13 = hr_api.g_varchar2) then
424: p_rec.attribute13 :=
425: per_ssm_shd.g_old_rec.attribute13;
426: End If;
427: If (p_rec.attribute14 = hr_api.g_varchar2) then
428: p_rec.attribute14 :=
429: per_ssm_shd.g_old_rec.attribute14;
430: End If;
431: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

427: If (p_rec.attribute14 = hr_api.g_varchar2) then
428: p_rec.attribute14 :=
429: per_ssm_shd.g_old_rec.attribute14;
430: End If;
431: If (p_rec.attribute15 = hr_api.g_varchar2) then
432: p_rec.attribute15 :=
433: per_ssm_shd.g_old_rec.attribute15;
434: End If;
435: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

431: If (p_rec.attribute15 = hr_api.g_varchar2) then
432: p_rec.attribute15 :=
433: per_ssm_shd.g_old_rec.attribute15;
434: End If;
435: If (p_rec.attribute16 = hr_api.g_varchar2) then
436: p_rec.attribute16 :=
437: per_ssm_shd.g_old_rec.attribute16;
438: End If;
439: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

435: If (p_rec.attribute16 = hr_api.g_varchar2) then
436: p_rec.attribute16 :=
437: per_ssm_shd.g_old_rec.attribute16;
438: End If;
439: If (p_rec.attribute17 = hr_api.g_varchar2) then
440: p_rec.attribute17 :=
441: per_ssm_shd.g_old_rec.attribute17;
442: End If;
443: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

439: If (p_rec.attribute17 = hr_api.g_varchar2) then
440: p_rec.attribute17 :=
441: per_ssm_shd.g_old_rec.attribute17;
442: End If;
443: If (p_rec.attribute18 = hr_api.g_varchar2) then
444: p_rec.attribute18 :=
445: per_ssm_shd.g_old_rec.attribute18;
446: End If;
447: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

443: If (p_rec.attribute18 = hr_api.g_varchar2) then
444: p_rec.attribute18 :=
445: per_ssm_shd.g_old_rec.attribute18;
446: End If;
447: If (p_rec.attribute19 = hr_api.g_varchar2) then
448: p_rec.attribute19 :=
449: per_ssm_shd.g_old_rec.attribute19;
450: End If;
451: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

447: If (p_rec.attribute19 = hr_api.g_varchar2) then
448: p_rec.attribute19 :=
449: per_ssm_shd.g_old_rec.attribute19;
450: End If;
451: If (p_rec.attribute20 = hr_api.g_varchar2) then
452: p_rec.attribute20 :=
453: per_ssm_shd.g_old_rec.attribute20;
454: End If;
455: --

Line 511: p_location_id in number default hr_api.g_number,

507: Procedure upd
508: (
509: p_object_version_number in out nocopy number,
510: p_salary_survey_mapping_id in number,
511: p_location_id in number default hr_api.g_number,
512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 512: p_grade_id in number default hr_api.g_number,

508: (
509: p_object_version_number in out nocopy number,
510: p_salary_survey_mapping_id in number,
511: p_location_id in number default hr_api.g_number,
512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 513: p_company_organization_id in number default hr_api.g_number,

509: p_object_version_number in out nocopy number,
510: p_salary_survey_mapping_id in number,
511: p_location_id in number default hr_api.g_number,
512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 514: p_company_age_code in varchar2 default hr_api.g_varchar2,

510: p_salary_survey_mapping_id in number,
511: p_location_id in number default hr_api.g_number,
512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 515: p_attribute_category in varchar2 default hr_api.g_varchar2,

511: p_location_id in number default hr_api.g_number,
512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 516: p_attribute1 in varchar2 default hr_api.g_varchar2,

512: p_grade_id in number default hr_api.g_number,
513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 517: p_attribute2 in varchar2 default hr_api.g_varchar2,

513: p_company_organization_id in number default hr_api.g_number,
514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 518: p_attribute3 in varchar2 default hr_api.g_varchar2,

514: p_company_age_code in varchar2 default hr_api.g_varchar2,
515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 519: p_attribute4 in varchar2 default hr_api.g_varchar2,

515: p_attribute_category in varchar2 default hr_api.g_varchar2,
516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 520: p_attribute5 in varchar2 default hr_api.g_varchar2,

516: p_attribute1 in varchar2 default hr_api.g_varchar2,
517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 521: p_attribute6 in varchar2 default hr_api.g_varchar2,

517: p_attribute2 in varchar2 default hr_api.g_varchar2,
518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 522: p_attribute7 in varchar2 default hr_api.g_varchar2,

518: p_attribute3 in varchar2 default hr_api.g_varchar2,
519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 523: p_attribute8 in varchar2 default hr_api.g_varchar2,

519: p_attribute4 in varchar2 default hr_api.g_varchar2,
520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 524: p_attribute9 in varchar2 default hr_api.g_varchar2,

520: p_attribute5 in varchar2 default hr_api.g_varchar2,
521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 525: p_attribute10 in varchar2 default hr_api.g_varchar2,

521: p_attribute6 in varchar2 default hr_api.g_varchar2,
522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 526: p_attribute11 in varchar2 default hr_api.g_varchar2,

522: p_attribute7 in varchar2 default hr_api.g_varchar2,
523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 527: p_attribute12 in varchar2 default hr_api.g_varchar2,

523: p_attribute8 in varchar2 default hr_api.g_varchar2,
524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 528: p_attribute13 in varchar2 default hr_api.g_varchar2,

524: p_attribute9 in varchar2 default hr_api.g_varchar2,
525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 529: p_attribute14 in varchar2 default hr_api.g_varchar2,

525: p_attribute10 in varchar2 default hr_api.g_varchar2,
526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 530: p_attribute15 in varchar2 default hr_api.g_varchar2,

526: p_attribute11 in varchar2 default hr_api.g_varchar2,
527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 531: p_attribute16 in varchar2 default hr_api.g_varchar2,

527: p_attribute12 in varchar2 default hr_api.g_varchar2,
528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,
535: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 532: p_attribute17 in varchar2 default hr_api.g_varchar2,

528: p_attribute13 in varchar2 default hr_api.g_varchar2,
529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,
535: p_attribute20 in varchar2 default hr_api.g_varchar2,
536: p_effective_date in date

Line 533: p_attribute18 in varchar2 default hr_api.g_varchar2,

529: p_attribute14 in varchar2 default hr_api.g_varchar2,
530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,
535: p_attribute20 in varchar2 default hr_api.g_varchar2,
536: p_effective_date in date
537: ) is

Line 534: p_attribute19 in varchar2 default hr_api.g_varchar2,

530: p_attribute15 in varchar2 default hr_api.g_varchar2,
531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,
535: p_attribute20 in varchar2 default hr_api.g_varchar2,
536: p_effective_date in date
537: ) is
538: --

Line 535: p_attribute20 in varchar2 default hr_api.g_varchar2,

531: p_attribute16 in varchar2 default hr_api.g_varchar2,
532: p_attribute17 in varchar2 default hr_api.g_varchar2,
533: p_attribute18 in varchar2 default hr_api.g_varchar2,
534: p_attribute19 in varchar2 default hr_api.g_varchar2,
535: p_attribute20 in varchar2 default hr_api.g_varchar2,
536: p_effective_date in date
537: ) is
538: --
539: l_rec per_ssm_shd.g_rec_type;

Line 553: hr_api.g_number,

549: per_ssm_shd.convert_args
550: (
551: p_object_version_number,
552: p_salary_survey_mapping_id,
553: hr_api.g_number,
554: hr_api.g_varchar2,
555: hr_api.g_number,
556: hr_api.g_number,
557: p_location_id,

Line 554: hr_api.g_varchar2,

550: (
551: p_object_version_number,
552: p_salary_survey_mapping_id,
553: hr_api.g_number,
554: hr_api.g_varchar2,
555: hr_api.g_number,
556: hr_api.g_number,
557: p_location_id,
558: p_grade_id,

Line 555: hr_api.g_number,

551: p_object_version_number,
552: p_salary_survey_mapping_id,
553: hr_api.g_number,
554: hr_api.g_varchar2,
555: hr_api.g_number,
556: hr_api.g_number,
557: p_location_id,
558: p_grade_id,
559: p_company_organization_id,

Line 556: hr_api.g_number,

552: p_salary_survey_mapping_id,
553: hr_api.g_number,
554: hr_api.g_varchar2,
555: hr_api.g_number,
556: hr_api.g_number,
557: p_location_id,
558: p_grade_id,
559: p_company_organization_id,
560: p_company_age_code,