50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
155: --
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: per_ssl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
159: per_ssl_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: per_ssl_shd.constraint_error
163: per_ssl_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: per_ssl_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: Raise;
171: End update_dml;
201: -- Internal Row Handler Use Only.
202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure pre_update(p_rec in per_ssl_shd.g_rec_type) is
206: --
207: l_proc varchar2(72) := g_package||'pre_update';
208: --
209: Begin
243: -- Internal Row Handler Use Only.
244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure post_update(p_rec in per_ssl_shd.g_rec_type,
248: p_effective_date in date) is
249: --
250: l_proc varchar2(72) := g_package||'post_update';
251: --
417: p_attribute30
418: => p_rec.attribute30,
419: /*End Enhancement 4021737 */
420: p_object_version_number_o
421: => per_ssl_shd.g_old_rec.object_version_number,
422: p_salary_survey_id_o
423: => per_ssl_shd.g_old_rec.salary_survey_id,
424: p_survey_job_name_code_o
425: => per_ssl_shd.g_old_rec.survey_job_name_code,
419: /*End Enhancement 4021737 */
420: p_object_version_number_o
421: => per_ssl_shd.g_old_rec.object_version_number,
422: p_salary_survey_id_o
423: => per_ssl_shd.g_old_rec.salary_survey_id,
424: p_survey_job_name_code_o
425: => per_ssl_shd.g_old_rec.survey_job_name_code,
426: p_survey_region_code_o
427: => per_ssl_shd.g_old_rec.survey_region_code,
421: => per_ssl_shd.g_old_rec.object_version_number,
422: p_salary_survey_id_o
423: => per_ssl_shd.g_old_rec.salary_survey_id,
424: p_survey_job_name_code_o
425: => per_ssl_shd.g_old_rec.survey_job_name_code,
426: p_survey_region_code_o
427: => per_ssl_shd.g_old_rec.survey_region_code,
428: p_survey_seniority_code_o
429: => per_ssl_shd.g_old_rec.survey_seniority_code,
423: => per_ssl_shd.g_old_rec.salary_survey_id,
424: p_survey_job_name_code_o
425: => per_ssl_shd.g_old_rec.survey_job_name_code,
426: p_survey_region_code_o
427: => per_ssl_shd.g_old_rec.survey_region_code,
428: p_survey_seniority_code_o
429: => per_ssl_shd.g_old_rec.survey_seniority_code,
430: p_company_size_code_o
431: => per_ssl_shd.g_old_rec.company_size_code,
425: => per_ssl_shd.g_old_rec.survey_job_name_code,
426: p_survey_region_code_o
427: => per_ssl_shd.g_old_rec.survey_region_code,
428: p_survey_seniority_code_o
429: => per_ssl_shd.g_old_rec.survey_seniority_code,
430: p_company_size_code_o
431: => per_ssl_shd.g_old_rec.company_size_code,
432: p_industry_code_o
433: => per_ssl_shd.g_old_rec.industry_code,
427: => per_ssl_shd.g_old_rec.survey_region_code,
428: p_survey_seniority_code_o
429: => per_ssl_shd.g_old_rec.survey_seniority_code,
430: p_company_size_code_o
431: => per_ssl_shd.g_old_rec.company_size_code,
432: p_industry_code_o
433: => per_ssl_shd.g_old_rec.industry_code,
434: p_survey_age_code_o
435: => per_ssl_shd.g_old_rec.survey_age_code,
429: => per_ssl_shd.g_old_rec.survey_seniority_code,
430: p_company_size_code_o
431: => per_ssl_shd.g_old_rec.company_size_code,
432: p_industry_code_o
433: => per_ssl_shd.g_old_rec.industry_code,
434: p_survey_age_code_o
435: => per_ssl_shd.g_old_rec.survey_age_code,
436: p_start_date_o
437: => per_ssl_shd.g_old_rec.start_date,
431: => per_ssl_shd.g_old_rec.company_size_code,
432: p_industry_code_o
433: => per_ssl_shd.g_old_rec.industry_code,
434: p_survey_age_code_o
435: => per_ssl_shd.g_old_rec.survey_age_code,
436: p_start_date_o
437: => per_ssl_shd.g_old_rec.start_date,
438: p_end_date_o
439: => per_ssl_shd.g_old_rec.end_date,
433: => per_ssl_shd.g_old_rec.industry_code,
434: p_survey_age_code_o
435: => per_ssl_shd.g_old_rec.survey_age_code,
436: p_start_date_o
437: => per_ssl_shd.g_old_rec.start_date,
438: p_end_date_o
439: => per_ssl_shd.g_old_rec.end_date,
440: p_currency_code_o
441: => per_ssl_shd.g_old_rec.currency_code,
435: => per_ssl_shd.g_old_rec.survey_age_code,
436: p_start_date_o
437: => per_ssl_shd.g_old_rec.start_date,
438: p_end_date_o
439: => per_ssl_shd.g_old_rec.end_date,
440: p_currency_code_o
441: => per_ssl_shd.g_old_rec.currency_code,
442: p_differential_o
443: => per_ssl_shd.g_old_rec.differential,
437: => per_ssl_shd.g_old_rec.start_date,
438: p_end_date_o
439: => per_ssl_shd.g_old_rec.end_date,
440: p_currency_code_o
441: => per_ssl_shd.g_old_rec.currency_code,
442: p_differential_o
443: => per_ssl_shd.g_old_rec.differential,
444: p_minimum_pay_o
445: => per_ssl_shd.g_old_rec.minimum_pay,
439: => per_ssl_shd.g_old_rec.end_date,
440: p_currency_code_o
441: => per_ssl_shd.g_old_rec.currency_code,
442: p_differential_o
443: => per_ssl_shd.g_old_rec.differential,
444: p_minimum_pay_o
445: => per_ssl_shd.g_old_rec.minimum_pay,
446: p_mean_pay_o
447: => per_ssl_shd.g_old_rec.mean_pay,
441: => per_ssl_shd.g_old_rec.currency_code,
442: p_differential_o
443: => per_ssl_shd.g_old_rec.differential,
444: p_minimum_pay_o
445: => per_ssl_shd.g_old_rec.minimum_pay,
446: p_mean_pay_o
447: => per_ssl_shd.g_old_rec.mean_pay,
448: p_maximum_pay_o
449: => per_ssl_shd.g_old_rec.maximum_pay,
443: => per_ssl_shd.g_old_rec.differential,
444: p_minimum_pay_o
445: => per_ssl_shd.g_old_rec.minimum_pay,
446: p_mean_pay_o
447: => per_ssl_shd.g_old_rec.mean_pay,
448: p_maximum_pay_o
449: => per_ssl_shd.g_old_rec.maximum_pay,
450: p_graduate_pay_o
451: => per_ssl_shd.g_old_rec.graduate_pay,
445: => per_ssl_shd.g_old_rec.minimum_pay,
446: p_mean_pay_o
447: => per_ssl_shd.g_old_rec.mean_pay,
448: p_maximum_pay_o
449: => per_ssl_shd.g_old_rec.maximum_pay,
450: p_graduate_pay_o
451: => per_ssl_shd.g_old_rec.graduate_pay,
452: p_starting_pay_o
453: => per_ssl_shd.g_old_rec.starting_pay,
447: => per_ssl_shd.g_old_rec.mean_pay,
448: p_maximum_pay_o
449: => per_ssl_shd.g_old_rec.maximum_pay,
450: p_graduate_pay_o
451: => per_ssl_shd.g_old_rec.graduate_pay,
452: p_starting_pay_o
453: => per_ssl_shd.g_old_rec.starting_pay,
454: p_percentage_change_o
455: => per_ssl_shd.g_old_rec.percentage_change,
449: => per_ssl_shd.g_old_rec.maximum_pay,
450: p_graduate_pay_o
451: => per_ssl_shd.g_old_rec.graduate_pay,
452: p_starting_pay_o
453: => per_ssl_shd.g_old_rec.starting_pay,
454: p_percentage_change_o
455: => per_ssl_shd.g_old_rec.percentage_change,
456: p_job_first_quartile_o
457: => per_ssl_shd.g_old_rec.job_first_quartile,
451: => per_ssl_shd.g_old_rec.graduate_pay,
452: p_starting_pay_o
453: => per_ssl_shd.g_old_rec.starting_pay,
454: p_percentage_change_o
455: => per_ssl_shd.g_old_rec.percentage_change,
456: p_job_first_quartile_o
457: => per_ssl_shd.g_old_rec.job_first_quartile,
458: p_job_median_quartile_o
459: => per_ssl_shd.g_old_rec.job_median_quartile,
453: => per_ssl_shd.g_old_rec.starting_pay,
454: p_percentage_change_o
455: => per_ssl_shd.g_old_rec.percentage_change,
456: p_job_first_quartile_o
457: => per_ssl_shd.g_old_rec.job_first_quartile,
458: p_job_median_quartile_o
459: => per_ssl_shd.g_old_rec.job_median_quartile,
460: p_job_third_quartile_o
461: => per_ssl_shd.g_old_rec.job_third_quartile,
455: => per_ssl_shd.g_old_rec.percentage_change,
456: p_job_first_quartile_o
457: => per_ssl_shd.g_old_rec.job_first_quartile,
458: p_job_median_quartile_o
459: => per_ssl_shd.g_old_rec.job_median_quartile,
460: p_job_third_quartile_o
461: => per_ssl_shd.g_old_rec.job_third_quartile,
462: p_job_fourth_quartile_o
463: => per_ssl_shd.g_old_rec.job_fourth_quartile,
457: => per_ssl_shd.g_old_rec.job_first_quartile,
458: p_job_median_quartile_o
459: => per_ssl_shd.g_old_rec.job_median_quartile,
460: p_job_third_quartile_o
461: => per_ssl_shd.g_old_rec.job_third_quartile,
462: p_job_fourth_quartile_o
463: => per_ssl_shd.g_old_rec.job_fourth_quartile,
464: p_minimum_total_compensation_o
465: => per_ssl_shd.g_old_rec.minimum_total_compensation,
459: => per_ssl_shd.g_old_rec.job_median_quartile,
460: p_job_third_quartile_o
461: => per_ssl_shd.g_old_rec.job_third_quartile,
462: p_job_fourth_quartile_o
463: => per_ssl_shd.g_old_rec.job_fourth_quartile,
464: p_minimum_total_compensation_o
465: => per_ssl_shd.g_old_rec.minimum_total_compensation,
466: p_mean_total_compensation_o
467: => per_ssl_shd.g_old_rec.mean_total_compensation,
461: => per_ssl_shd.g_old_rec.job_third_quartile,
462: p_job_fourth_quartile_o
463: => per_ssl_shd.g_old_rec.job_fourth_quartile,
464: p_minimum_total_compensation_o
465: => per_ssl_shd.g_old_rec.minimum_total_compensation,
466: p_mean_total_compensation_o
467: => per_ssl_shd.g_old_rec.mean_total_compensation,
468: p_maximum_total_compensation_o
469: => per_ssl_shd.g_old_rec.maximum_total_compensation,
463: => per_ssl_shd.g_old_rec.job_fourth_quartile,
464: p_minimum_total_compensation_o
465: => per_ssl_shd.g_old_rec.minimum_total_compensation,
466: p_mean_total_compensation_o
467: => per_ssl_shd.g_old_rec.mean_total_compensation,
468: p_maximum_total_compensation_o
469: => per_ssl_shd.g_old_rec.maximum_total_compensation,
470: p_compnstn_first_quartile_o
471: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
465: => per_ssl_shd.g_old_rec.minimum_total_compensation,
466: p_mean_total_compensation_o
467: => per_ssl_shd.g_old_rec.mean_total_compensation,
468: p_maximum_total_compensation_o
469: => per_ssl_shd.g_old_rec.maximum_total_compensation,
470: p_compnstn_first_quartile_o
471: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
472: p_compnstn_median_quartile_o
473: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
467: => per_ssl_shd.g_old_rec.mean_total_compensation,
468: p_maximum_total_compensation_o
469: => per_ssl_shd.g_old_rec.maximum_total_compensation,
470: p_compnstn_first_quartile_o
471: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
472: p_compnstn_median_quartile_o
473: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
474: p_compnstn_third_quartile_o
475: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
469: => per_ssl_shd.g_old_rec.maximum_total_compensation,
470: p_compnstn_first_quartile_o
471: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
472: p_compnstn_median_quartile_o
473: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
474: p_compnstn_third_quartile_o
475: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
476: p_compnstn_fourth_quartile_o
477: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
471: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
472: p_compnstn_median_quartile_o
473: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
474: p_compnstn_third_quartile_o
475: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
476: p_compnstn_fourth_quartile_o
477: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
478: /*Added for Enhancement 4021737 */
479: p_tenth_percentile_o
473: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
474: p_compnstn_third_quartile_o
475: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
476: p_compnstn_fourth_quartile_o
477: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
478: /*Added for Enhancement 4021737 */
479: p_tenth_percentile_o
480: => per_ssl_shd.g_old_rec.tenth_percentile,
481: p_twenty_fifth_percentile_o
476: p_compnstn_fourth_quartile_o
477: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
478: /*Added for Enhancement 4021737 */
479: p_tenth_percentile_o
480: => per_ssl_shd.g_old_rec.tenth_percentile,
481: p_twenty_fifth_percentile_o
482: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
483: p_fiftieth_percentile_o
484: => per_ssl_shd.g_old_rec.fiftieth_percentile,
478: /*Added for Enhancement 4021737 */
479: p_tenth_percentile_o
480: => per_ssl_shd.g_old_rec.tenth_percentile,
481: p_twenty_fifth_percentile_o
482: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
483: p_fiftieth_percentile_o
484: => per_ssl_shd.g_old_rec.fiftieth_percentile,
485: p_seventy_fifth_percentile_o
486: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
480: => per_ssl_shd.g_old_rec.tenth_percentile,
481: p_twenty_fifth_percentile_o
482: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
483: p_fiftieth_percentile_o
484: => per_ssl_shd.g_old_rec.fiftieth_percentile,
485: p_seventy_fifth_percentile_o
486: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
487: p_ninetieth_percentile_o
488: => per_ssl_shd.g_old_rec.ninetieth_percentile,
482: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
483: p_fiftieth_percentile_o
484: => per_ssl_shd.g_old_rec.fiftieth_percentile,
485: p_seventy_fifth_percentile_o
486: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
487: p_ninetieth_percentile_o
488: => per_ssl_shd.g_old_rec.ninetieth_percentile,
489: p_minimum_bonus_o
490: => per_ssl_shd.g_old_rec.minimum_bonus,
484: => per_ssl_shd.g_old_rec.fiftieth_percentile,
485: p_seventy_fifth_percentile_o
486: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
487: p_ninetieth_percentile_o
488: => per_ssl_shd.g_old_rec.ninetieth_percentile,
489: p_minimum_bonus_o
490: => per_ssl_shd.g_old_rec.minimum_bonus,
491: p_mean_bonus_o
492: => per_ssl_shd.g_old_rec.mean_bonus,
486: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
487: p_ninetieth_percentile_o
488: => per_ssl_shd.g_old_rec.ninetieth_percentile,
489: p_minimum_bonus_o
490: => per_ssl_shd.g_old_rec.minimum_bonus,
491: p_mean_bonus_o
492: => per_ssl_shd.g_old_rec.mean_bonus,
493: p_maximum_bonus_o
494: => per_ssl_shd.g_old_rec.maximum_bonus,
488: => per_ssl_shd.g_old_rec.ninetieth_percentile,
489: p_minimum_bonus_o
490: => per_ssl_shd.g_old_rec.minimum_bonus,
491: p_mean_bonus_o
492: => per_ssl_shd.g_old_rec.mean_bonus,
493: p_maximum_bonus_o
494: => per_ssl_shd.g_old_rec.maximum_bonus,
495: p_minimum_salary_increase_o
496: => per_ssl_shd.g_old_rec.minimum_salary_increase,
490: => per_ssl_shd.g_old_rec.minimum_bonus,
491: p_mean_bonus_o
492: => per_ssl_shd.g_old_rec.mean_bonus,
493: p_maximum_bonus_o
494: => per_ssl_shd.g_old_rec.maximum_bonus,
495: p_minimum_salary_increase_o
496: => per_ssl_shd.g_old_rec.minimum_salary_increase,
497: p_mean_salary_increase_o
498: => per_ssl_shd.g_old_rec.mean_salary_increase,
492: => per_ssl_shd.g_old_rec.mean_bonus,
493: p_maximum_bonus_o
494: => per_ssl_shd.g_old_rec.maximum_bonus,
495: p_minimum_salary_increase_o
496: => per_ssl_shd.g_old_rec.minimum_salary_increase,
497: p_mean_salary_increase_o
498: => per_ssl_shd.g_old_rec.mean_salary_increase,
499: p_maximum_salary_increase_o
500: => per_ssl_shd.g_old_rec.maximum_salary_increase,
494: => per_ssl_shd.g_old_rec.maximum_bonus,
495: p_minimum_salary_increase_o
496: => per_ssl_shd.g_old_rec.minimum_salary_increase,
497: p_mean_salary_increase_o
498: => per_ssl_shd.g_old_rec.mean_salary_increase,
499: p_maximum_salary_increase_o
500: => per_ssl_shd.g_old_rec.maximum_salary_increase,
501: p_min_variable_compensation_o
502: => per_ssl_shd.g_old_rec.min_variable_compensation,
496: => per_ssl_shd.g_old_rec.minimum_salary_increase,
497: p_mean_salary_increase_o
498: => per_ssl_shd.g_old_rec.mean_salary_increase,
499: p_maximum_salary_increase_o
500: => per_ssl_shd.g_old_rec.maximum_salary_increase,
501: p_min_variable_compensation_o
502: => per_ssl_shd.g_old_rec.min_variable_compensation,
503: p_mean_variable_compensation_o
504: => per_ssl_shd.g_old_rec.mean_variable_compensation,
498: => per_ssl_shd.g_old_rec.mean_salary_increase,
499: p_maximum_salary_increase_o
500: => per_ssl_shd.g_old_rec.maximum_salary_increase,
501: p_min_variable_compensation_o
502: => per_ssl_shd.g_old_rec.min_variable_compensation,
503: p_mean_variable_compensation_o
504: => per_ssl_shd.g_old_rec.mean_variable_compensation,
505: p_max_variable_compensation_o
506: => per_ssl_shd.g_old_rec.max_variable_compensation,
500: => per_ssl_shd.g_old_rec.maximum_salary_increase,
501: p_min_variable_compensation_o
502: => per_ssl_shd.g_old_rec.min_variable_compensation,
503: p_mean_variable_compensation_o
504: => per_ssl_shd.g_old_rec.mean_variable_compensation,
505: p_max_variable_compensation_o
506: => per_ssl_shd.g_old_rec.max_variable_compensation,
507: p_minimum_stock_o
508: => per_ssl_shd.g_old_rec.minimum_stock,
502: => per_ssl_shd.g_old_rec.min_variable_compensation,
503: p_mean_variable_compensation_o
504: => per_ssl_shd.g_old_rec.mean_variable_compensation,
505: p_max_variable_compensation_o
506: => per_ssl_shd.g_old_rec.max_variable_compensation,
507: p_minimum_stock_o
508: => per_ssl_shd.g_old_rec.minimum_stock,
509: p_mean_stock_o
510: => per_ssl_shd.g_old_rec.mean_stock,
504: => per_ssl_shd.g_old_rec.mean_variable_compensation,
505: p_max_variable_compensation_o
506: => per_ssl_shd.g_old_rec.max_variable_compensation,
507: p_minimum_stock_o
508: => per_ssl_shd.g_old_rec.minimum_stock,
509: p_mean_stock_o
510: => per_ssl_shd.g_old_rec.mean_stock,
511: p_maximum_stock_o
512: => per_ssl_shd.g_old_rec.maximum_stock,
506: => per_ssl_shd.g_old_rec.max_variable_compensation,
507: p_minimum_stock_o
508: => per_ssl_shd.g_old_rec.minimum_stock,
509: p_mean_stock_o
510: => per_ssl_shd.g_old_rec.mean_stock,
511: p_maximum_stock_o
512: => per_ssl_shd.g_old_rec.maximum_stock,
513: p_stock_display_type_o
514: => per_ssl_shd.g_old_rec.stock_display_type,
508: => per_ssl_shd.g_old_rec.minimum_stock,
509: p_mean_stock_o
510: => per_ssl_shd.g_old_rec.mean_stock,
511: p_maximum_stock_o
512: => per_ssl_shd.g_old_rec.maximum_stock,
513: p_stock_display_type_o
514: => per_ssl_shd.g_old_rec.stock_display_type,
515: /*End Enhancement 4021737 */
516: p_attribute_category_o
510: => per_ssl_shd.g_old_rec.mean_stock,
511: p_maximum_stock_o
512: => per_ssl_shd.g_old_rec.maximum_stock,
513: p_stock_display_type_o
514: => per_ssl_shd.g_old_rec.stock_display_type,
515: /*End Enhancement 4021737 */
516: p_attribute_category_o
517: => per_ssl_shd.g_old_rec.attribute_category,
518: p_attribute1_o
513: p_stock_display_type_o
514: => per_ssl_shd.g_old_rec.stock_display_type,
515: /*End Enhancement 4021737 */
516: p_attribute_category_o
517: => per_ssl_shd.g_old_rec.attribute_category,
518: p_attribute1_o
519: => per_ssl_shd.g_old_rec.attribute1,
520: p_attribute2_o
521: => per_ssl_shd.g_old_rec.attribute2,
515: /*End Enhancement 4021737 */
516: p_attribute_category_o
517: => per_ssl_shd.g_old_rec.attribute_category,
518: p_attribute1_o
519: => per_ssl_shd.g_old_rec.attribute1,
520: p_attribute2_o
521: => per_ssl_shd.g_old_rec.attribute2,
522: p_attribute3_o
523: => per_ssl_shd.g_old_rec.attribute3,
517: => per_ssl_shd.g_old_rec.attribute_category,
518: p_attribute1_o
519: => per_ssl_shd.g_old_rec.attribute1,
520: p_attribute2_o
521: => per_ssl_shd.g_old_rec.attribute2,
522: p_attribute3_o
523: => per_ssl_shd.g_old_rec.attribute3,
524: p_attribute4_o
525: => per_ssl_shd.g_old_rec.attribute4,
519: => per_ssl_shd.g_old_rec.attribute1,
520: p_attribute2_o
521: => per_ssl_shd.g_old_rec.attribute2,
522: p_attribute3_o
523: => per_ssl_shd.g_old_rec.attribute3,
524: p_attribute4_o
525: => per_ssl_shd.g_old_rec.attribute4,
526: p_attribute5_o
527: => per_ssl_shd.g_old_rec.attribute5,
521: => per_ssl_shd.g_old_rec.attribute2,
522: p_attribute3_o
523: => per_ssl_shd.g_old_rec.attribute3,
524: p_attribute4_o
525: => per_ssl_shd.g_old_rec.attribute4,
526: p_attribute5_o
527: => per_ssl_shd.g_old_rec.attribute5,
528: p_attribute6_o
529: => per_ssl_shd.g_old_rec.attribute6,
523: => per_ssl_shd.g_old_rec.attribute3,
524: p_attribute4_o
525: => per_ssl_shd.g_old_rec.attribute4,
526: p_attribute5_o
527: => per_ssl_shd.g_old_rec.attribute5,
528: p_attribute6_o
529: => per_ssl_shd.g_old_rec.attribute6,
530: p_attribute7_o
531: => per_ssl_shd.g_old_rec.attribute7,
525: => per_ssl_shd.g_old_rec.attribute4,
526: p_attribute5_o
527: => per_ssl_shd.g_old_rec.attribute5,
528: p_attribute6_o
529: => per_ssl_shd.g_old_rec.attribute6,
530: p_attribute7_o
531: => per_ssl_shd.g_old_rec.attribute7,
532: p_attribute8_o
533: => per_ssl_shd.g_old_rec.attribute8,
527: => per_ssl_shd.g_old_rec.attribute5,
528: p_attribute6_o
529: => per_ssl_shd.g_old_rec.attribute6,
530: p_attribute7_o
531: => per_ssl_shd.g_old_rec.attribute7,
532: p_attribute8_o
533: => per_ssl_shd.g_old_rec.attribute8,
534: p_attribute9_o
535: => per_ssl_shd.g_old_rec.attribute9,
529: => per_ssl_shd.g_old_rec.attribute6,
530: p_attribute7_o
531: => per_ssl_shd.g_old_rec.attribute7,
532: p_attribute8_o
533: => per_ssl_shd.g_old_rec.attribute8,
534: p_attribute9_o
535: => per_ssl_shd.g_old_rec.attribute9,
536: p_attribute10_o
537: => per_ssl_shd.g_old_rec.attribute10,
531: => per_ssl_shd.g_old_rec.attribute7,
532: p_attribute8_o
533: => per_ssl_shd.g_old_rec.attribute8,
534: p_attribute9_o
535: => per_ssl_shd.g_old_rec.attribute9,
536: p_attribute10_o
537: => per_ssl_shd.g_old_rec.attribute10,
538: p_attribute11_o
539: => per_ssl_shd.g_old_rec.attribute11,
533: => per_ssl_shd.g_old_rec.attribute8,
534: p_attribute9_o
535: => per_ssl_shd.g_old_rec.attribute9,
536: p_attribute10_o
537: => per_ssl_shd.g_old_rec.attribute10,
538: p_attribute11_o
539: => per_ssl_shd.g_old_rec.attribute11,
540: p_attribute12_o
541: => per_ssl_shd.g_old_rec.attribute12,
535: => per_ssl_shd.g_old_rec.attribute9,
536: p_attribute10_o
537: => per_ssl_shd.g_old_rec.attribute10,
538: p_attribute11_o
539: => per_ssl_shd.g_old_rec.attribute11,
540: p_attribute12_o
541: => per_ssl_shd.g_old_rec.attribute12,
542: p_attribute13_o
543: => per_ssl_shd.g_old_rec.attribute13,
537: => per_ssl_shd.g_old_rec.attribute10,
538: p_attribute11_o
539: => per_ssl_shd.g_old_rec.attribute11,
540: p_attribute12_o
541: => per_ssl_shd.g_old_rec.attribute12,
542: p_attribute13_o
543: => per_ssl_shd.g_old_rec.attribute13,
544: p_attribute14_o
545: => per_ssl_shd.g_old_rec.attribute14,
539: => per_ssl_shd.g_old_rec.attribute11,
540: p_attribute12_o
541: => per_ssl_shd.g_old_rec.attribute12,
542: p_attribute13_o
543: => per_ssl_shd.g_old_rec.attribute13,
544: p_attribute14_o
545: => per_ssl_shd.g_old_rec.attribute14,
546: p_attribute15_o
547: => per_ssl_shd.g_old_rec.attribute15,
541: => per_ssl_shd.g_old_rec.attribute12,
542: p_attribute13_o
543: => per_ssl_shd.g_old_rec.attribute13,
544: p_attribute14_o
545: => per_ssl_shd.g_old_rec.attribute14,
546: p_attribute15_o
547: => per_ssl_shd.g_old_rec.attribute15,
548: p_attribute16_o
549: => per_ssl_shd.g_old_rec.attribute16,
543: => per_ssl_shd.g_old_rec.attribute13,
544: p_attribute14_o
545: => per_ssl_shd.g_old_rec.attribute14,
546: p_attribute15_o
547: => per_ssl_shd.g_old_rec.attribute15,
548: p_attribute16_o
549: => per_ssl_shd.g_old_rec.attribute16,
550: p_attribute17_o
551: => per_ssl_shd.g_old_rec.attribute17,
545: => per_ssl_shd.g_old_rec.attribute14,
546: p_attribute15_o
547: => per_ssl_shd.g_old_rec.attribute15,
548: p_attribute16_o
549: => per_ssl_shd.g_old_rec.attribute16,
550: p_attribute17_o
551: => per_ssl_shd.g_old_rec.attribute17,
552: p_attribute18_o
553: => per_ssl_shd.g_old_rec.attribute18,
547: => per_ssl_shd.g_old_rec.attribute15,
548: p_attribute16_o
549: => per_ssl_shd.g_old_rec.attribute16,
550: p_attribute17_o
551: => per_ssl_shd.g_old_rec.attribute17,
552: p_attribute18_o
553: => per_ssl_shd.g_old_rec.attribute18,
554: p_attribute19_o
555: => per_ssl_shd.g_old_rec.attribute19,
549: => per_ssl_shd.g_old_rec.attribute16,
550: p_attribute17_o
551: => per_ssl_shd.g_old_rec.attribute17,
552: p_attribute18_o
553: => per_ssl_shd.g_old_rec.attribute18,
554: p_attribute19_o
555: => per_ssl_shd.g_old_rec.attribute19,
556: p_attribute20_o
557: => per_ssl_shd.g_old_rec.attribute20,
551: => per_ssl_shd.g_old_rec.attribute17,
552: p_attribute18_o
553: => per_ssl_shd.g_old_rec.attribute18,
554: p_attribute19_o
555: => per_ssl_shd.g_old_rec.attribute19,
556: p_attribute20_o
557: => per_ssl_shd.g_old_rec.attribute20,
558: /*Added for Enhancement 4021737 */
559: p_attribute21_o
553: => per_ssl_shd.g_old_rec.attribute18,
554: p_attribute19_o
555: => per_ssl_shd.g_old_rec.attribute19,
556: p_attribute20_o
557: => per_ssl_shd.g_old_rec.attribute20,
558: /*Added for Enhancement 4021737 */
559: p_attribute21_o
560: => per_ssl_shd.g_old_rec.attribute21,
561: p_attribute22_o
556: p_attribute20_o
557: => per_ssl_shd.g_old_rec.attribute20,
558: /*Added for Enhancement 4021737 */
559: p_attribute21_o
560: => per_ssl_shd.g_old_rec.attribute21,
561: p_attribute22_o
562: => per_ssl_shd.g_old_rec.attribute22,
563: p_attribute23_o
564: => per_ssl_shd.g_old_rec.attribute23,
558: /*Added for Enhancement 4021737 */
559: p_attribute21_o
560: => per_ssl_shd.g_old_rec.attribute21,
561: p_attribute22_o
562: => per_ssl_shd.g_old_rec.attribute22,
563: p_attribute23_o
564: => per_ssl_shd.g_old_rec.attribute23,
565: p_attribute24_o
566: => per_ssl_shd.g_old_rec.attribute24,
560: => per_ssl_shd.g_old_rec.attribute21,
561: p_attribute22_o
562: => per_ssl_shd.g_old_rec.attribute22,
563: p_attribute23_o
564: => per_ssl_shd.g_old_rec.attribute23,
565: p_attribute24_o
566: => per_ssl_shd.g_old_rec.attribute24,
567: p_attribute25_o
568: => per_ssl_shd.g_old_rec.attribute25,
562: => per_ssl_shd.g_old_rec.attribute22,
563: p_attribute23_o
564: => per_ssl_shd.g_old_rec.attribute23,
565: p_attribute24_o
566: => per_ssl_shd.g_old_rec.attribute24,
567: p_attribute25_o
568: => per_ssl_shd.g_old_rec.attribute25,
569: p_attribute26_o
570: => per_ssl_shd.g_old_rec.attribute26,
564: => per_ssl_shd.g_old_rec.attribute23,
565: p_attribute24_o
566: => per_ssl_shd.g_old_rec.attribute24,
567: p_attribute25_o
568: => per_ssl_shd.g_old_rec.attribute25,
569: p_attribute26_o
570: => per_ssl_shd.g_old_rec.attribute26,
571: p_attribute27_o
572: => per_ssl_shd.g_old_rec.attribute27,
566: => per_ssl_shd.g_old_rec.attribute24,
567: p_attribute25_o
568: => per_ssl_shd.g_old_rec.attribute25,
569: p_attribute26_o
570: => per_ssl_shd.g_old_rec.attribute26,
571: p_attribute27_o
572: => per_ssl_shd.g_old_rec.attribute27,
573: p_attribute28_o
574: => per_ssl_shd.g_old_rec.attribute28,
568: => per_ssl_shd.g_old_rec.attribute25,
569: p_attribute26_o
570: => per_ssl_shd.g_old_rec.attribute26,
571: p_attribute27_o
572: => per_ssl_shd.g_old_rec.attribute27,
573: p_attribute28_o
574: => per_ssl_shd.g_old_rec.attribute28,
575: p_attribute29_o
576: => per_ssl_shd.g_old_rec.attribute29,
570: => per_ssl_shd.g_old_rec.attribute26,
571: p_attribute27_o
572: => per_ssl_shd.g_old_rec.attribute27,
573: p_attribute28_o
574: => per_ssl_shd.g_old_rec.attribute28,
575: p_attribute29_o
576: => per_ssl_shd.g_old_rec.attribute29,
577: p_attribute30_o
578: => per_ssl_shd.g_old_rec.attribute30
572: => per_ssl_shd.g_old_rec.attribute27,
573: p_attribute28_o
574: => per_ssl_shd.g_old_rec.attribute28,
575: p_attribute29_o
576: => per_ssl_shd.g_old_rec.attribute29,
577: p_attribute30_o
578: => per_ssl_shd.g_old_rec.attribute30
579: /*End Enhancement 4021737 */
580: );
574: => per_ssl_shd.g_old_rec.attribute28,
575: p_attribute29_o
576: => per_ssl_shd.g_old_rec.attribute29,
577: p_attribute30_o
578: => per_ssl_shd.g_old_rec.attribute30
579: /*End Enhancement 4021737 */
580: );
581:
582: exception
634: -- Internal Row Handler Use Only.
635: --
636: -- {End Of Comments}
637: -- ----------------------------------------------------------------------------
638: Procedure convert_defs(p_rec in out nocopy per_ssl_shd.g_rec_type) is
639: --
640: l_proc varchar2(72) := g_package||'convert_defs';
641: --
642: Begin
649: -- is being used Then we must set to the 'current' argument value.
650: --
651: If (p_rec.salary_survey_id = hr_api.g_number) Then
652: p_rec.salary_survey_id :=
653: per_ssl_shd.g_old_rec.salary_survey_id;
654: End If;
655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then
656: p_rec.survey_job_name_code :=
657: per_ssl_shd.g_old_rec.survey_job_name_code;
653: per_ssl_shd.g_old_rec.salary_survey_id;
654: End If;
655: If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then
656: p_rec.survey_job_name_code :=
657: per_ssl_shd.g_old_rec.survey_job_name_code;
658: End If;
659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then
660: p_rec.survey_region_code :=
661: per_ssl_shd.g_old_rec.survey_region_code;
657: per_ssl_shd.g_old_rec.survey_job_name_code;
658: End If;
659: If (p_rec.survey_region_code = hr_api.g_varchar2) Then
660: p_rec.survey_region_code :=
661: per_ssl_shd.g_old_rec.survey_region_code;
662: End If;
663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then
664: p_rec.survey_seniority_code :=
665: per_ssl_shd.g_old_rec.survey_seniority_code;
661: per_ssl_shd.g_old_rec.survey_region_code;
662: End If;
663: If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then
664: p_rec.survey_seniority_code :=
665: per_ssl_shd.g_old_rec.survey_seniority_code;
666: End If;
667: If (p_rec.company_size_code = hr_api.g_varchar2) Then
668: p_rec.company_size_code :=
669: per_ssl_shd.g_old_rec.company_size_code;
665: per_ssl_shd.g_old_rec.survey_seniority_code;
666: End If;
667: If (p_rec.company_size_code = hr_api.g_varchar2) Then
668: p_rec.company_size_code :=
669: per_ssl_shd.g_old_rec.company_size_code;
670: End If;
671: If (p_rec.industry_code = hr_api.g_varchar2) Then
672: p_rec.industry_code :=
673: per_ssl_shd.g_old_rec.industry_code;
669: per_ssl_shd.g_old_rec.company_size_code;
670: End If;
671: If (p_rec.industry_code = hr_api.g_varchar2) Then
672: p_rec.industry_code :=
673: per_ssl_shd.g_old_rec.industry_code;
674: End If;
675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then
676: p_rec.survey_age_code :=
677: per_ssl_shd.g_old_rec.survey_age_code;
673: per_ssl_shd.g_old_rec.industry_code;
674: End If;
675: If (p_rec.survey_age_code = hr_api.g_varchar2) Then
676: p_rec.survey_age_code :=
677: per_ssl_shd.g_old_rec.survey_age_code;
678: End If;
679: If (p_rec.start_date = hr_api.g_date) Then
680: p_rec.start_date :=
681: per_ssl_shd.g_old_rec.start_date;
677: per_ssl_shd.g_old_rec.survey_age_code;
678: End If;
679: If (p_rec.start_date = hr_api.g_date) Then
680: p_rec.start_date :=
681: per_ssl_shd.g_old_rec.start_date;
682: End If;
683: If (p_rec.end_date = hr_api.g_date) Then
684: p_rec.end_date :=
685: per_ssl_shd.g_old_rec.end_date;
681: per_ssl_shd.g_old_rec.start_date;
682: End If;
683: If (p_rec.end_date = hr_api.g_date) Then
684: p_rec.end_date :=
685: per_ssl_shd.g_old_rec.end_date;
686: End If;
687: If (p_rec.currency_code = hr_api.g_varchar2) then
688: p_rec.currency_code :=
689: per_ssl_shd.g_old_rec.currency_code;
685: per_ssl_shd.g_old_rec.end_date;
686: End If;
687: If (p_rec.currency_code = hr_api.g_varchar2) then
688: p_rec.currency_code :=
689: per_ssl_shd.g_old_rec.currency_code;
690: End If;
691: If (p_rec.differential = hr_api.g_number) Then
692: p_rec.differential :=
693: per_ssl_shd.g_old_rec.differential;
689: per_ssl_shd.g_old_rec.currency_code;
690: End If;
691: If (p_rec.differential = hr_api.g_number) Then
692: p_rec.differential :=
693: per_ssl_shd.g_old_rec.differential;
694: End If;
695: If (p_rec.minimum_pay = hr_api.g_number ) Then
696: p_rec.minimum_pay :=
697: per_ssl_shd.g_old_rec.minimum_pay;
693: per_ssl_shd.g_old_rec.differential;
694: End If;
695: If (p_rec.minimum_pay = hr_api.g_number ) Then
696: p_rec.minimum_pay :=
697: per_ssl_shd.g_old_rec.minimum_pay;
698: End If;
699: If (p_rec.mean_pay = hr_api.g_number ) Then
700: p_rec.mean_pay :=
701: per_ssl_shd.g_old_rec.mean_pay;
697: per_ssl_shd.g_old_rec.minimum_pay;
698: End If;
699: If (p_rec.mean_pay = hr_api.g_number ) Then
700: p_rec.mean_pay :=
701: per_ssl_shd.g_old_rec.mean_pay;
702: End If;
703: If (p_rec.maximum_pay = hr_api.g_number ) Then
704: p_rec.maximum_pay :=
705: per_ssl_shd.g_old_rec.maximum_pay;
701: per_ssl_shd.g_old_rec.mean_pay;
702: End If;
703: If (p_rec.maximum_pay = hr_api.g_number ) Then
704: p_rec.maximum_pay :=
705: per_ssl_shd.g_old_rec.maximum_pay;
706: End If;
707: If (p_rec.graduate_pay = hr_api.g_number ) Then
708: p_rec.graduate_pay :=
709: per_ssl_shd.g_old_rec.graduate_pay;
705: per_ssl_shd.g_old_rec.maximum_pay;
706: End If;
707: If (p_rec.graduate_pay = hr_api.g_number ) Then
708: p_rec.graduate_pay :=
709: per_ssl_shd.g_old_rec.graduate_pay;
710: End If;
711: If (p_rec.starting_pay = hr_api.g_number ) Then
712: p_rec.starting_pay :=
713: per_ssl_shd.g_old_rec.starting_pay;
709: per_ssl_shd.g_old_rec.graduate_pay;
710: End If;
711: If (p_rec.starting_pay = hr_api.g_number ) Then
712: p_rec.starting_pay :=
713: per_ssl_shd.g_old_rec.starting_pay;
714: End If;
715: If (p_rec.percentage_change = hr_api.g_number ) Then
716: p_rec.percentage_change :=
717: per_ssl_shd.g_old_rec.percentage_change;
713: per_ssl_shd.g_old_rec.starting_pay;
714: End If;
715: If (p_rec.percentage_change = hr_api.g_number ) Then
716: p_rec.percentage_change :=
717: per_ssl_shd.g_old_rec.percentage_change;
718: End If;
719: If (p_rec.job_first_quartile = hr_api.g_number ) Then
720: p_rec.job_first_quartile :=
721: per_ssl_shd.g_old_rec.job_first_quartile;
717: per_ssl_shd.g_old_rec.percentage_change;
718: End If;
719: If (p_rec.job_first_quartile = hr_api.g_number ) Then
720: p_rec.job_first_quartile :=
721: per_ssl_shd.g_old_rec.job_first_quartile;
722: End If;
723: If (p_rec.job_median_quartile = hr_api.g_number ) Then
724: p_rec.job_median_quartile :=
725: per_ssl_shd.g_old_rec.job_median_quartile;
721: per_ssl_shd.g_old_rec.job_first_quartile;
722: End If;
723: If (p_rec.job_median_quartile = hr_api.g_number ) Then
724: p_rec.job_median_quartile :=
725: per_ssl_shd.g_old_rec.job_median_quartile;
726: End If;
727: If (p_rec.job_third_quartile = hr_api.g_number ) Then
728: p_rec.job_third_quartile :=
729: per_ssl_shd.g_old_rec.job_third_quartile;
725: per_ssl_shd.g_old_rec.job_median_quartile;
726: End If;
727: If (p_rec.job_third_quartile = hr_api.g_number ) Then
728: p_rec.job_third_quartile :=
729: per_ssl_shd.g_old_rec.job_third_quartile;
730: End If;
731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then
732: p_rec.job_fourth_quartile :=
733: per_ssl_shd.g_old_rec.job_fourth_quartile;
729: per_ssl_shd.g_old_rec.job_third_quartile;
730: End If;
731: If (p_rec.job_fourth_quartile = hr_api.g_number ) Then
732: p_rec.job_fourth_quartile :=
733: per_ssl_shd.g_old_rec.job_fourth_quartile;
734: End If;
735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then
736: p_rec.minimum_total_compensation :=
737: per_ssl_shd.g_old_rec.minimum_total_compensation;
733: per_ssl_shd.g_old_rec.job_fourth_quartile;
734: End If;
735: If (p_rec.minimum_total_compensation = hr_api.g_number ) Then
736: p_rec.minimum_total_compensation :=
737: per_ssl_shd.g_old_rec.minimum_total_compensation;
738: End If;
739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then
740: p_rec.mean_total_compensation :=
741: per_ssl_shd.g_old_rec.mean_total_compensation;
737: per_ssl_shd.g_old_rec.minimum_total_compensation;
738: End If;
739: If (p_rec.mean_total_compensation = hr_api.g_number ) Then
740: p_rec.mean_total_compensation :=
741: per_ssl_shd.g_old_rec.mean_total_compensation;
742: End If;
743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then
744: p_rec.maximum_total_compensation :=
745: per_ssl_shd.g_old_rec.maximum_total_compensation;
741: per_ssl_shd.g_old_rec.mean_total_compensation;
742: End If;
743: If (p_rec.maximum_total_compensation = hr_api.g_number ) Then
744: p_rec.maximum_total_compensation :=
745: per_ssl_shd.g_old_rec.maximum_total_compensation;
746: End If;
747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then
748: p_rec.compnstn_first_quartile :=
749: per_ssl_shd.g_old_rec.compnstn_first_quartile;
745: per_ssl_shd.g_old_rec.maximum_total_compensation;
746: End If;
747: If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then
748: p_rec.compnstn_first_quartile :=
749: per_ssl_shd.g_old_rec.compnstn_first_quartile;
750: End If;
751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then
752: p_rec.compnstn_median_quartile :=
753: per_ssl_shd.g_old_rec.compnstn_median_quartile;
749: per_ssl_shd.g_old_rec.compnstn_first_quartile;
750: End If;
751: If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then
752: p_rec.compnstn_median_quartile :=
753: per_ssl_shd.g_old_rec.compnstn_median_quartile;
754: End If;
755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then
756: p_rec.compnstn_third_quartile :=
757: per_ssl_shd.g_old_rec.compnstn_third_quartile;
753: per_ssl_shd.g_old_rec.compnstn_median_quartile;
754: End If;
755: If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then
756: p_rec.compnstn_third_quartile :=
757: per_ssl_shd.g_old_rec.compnstn_third_quartile;
758: End If;
759: If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then
760: p_rec.compnstn_fourth_quartile :=
761: per_ssl_shd.g_old_rec.compnstn_fourth_quartile;
757: per_ssl_shd.g_old_rec.compnstn_third_quartile;
758: End If;
759: If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then
760: p_rec.compnstn_fourth_quartile :=
761: per_ssl_shd.g_old_rec.compnstn_fourth_quartile;
762: End If;
763: /*Added for Enhancement 4021737 */
764: If (p_rec.tenth_percentile = hr_api.g_number ) Then
765: p_rec.tenth_percentile :=
762: End If;
763: /*Added for Enhancement 4021737 */
764: If (p_rec.tenth_percentile = hr_api.g_number ) Then
765: p_rec.tenth_percentile :=
766: per_ssl_shd.g_old_rec.tenth_percentile;
767: End If;
768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then
769: p_rec.twenty_fifth_percentile :=
770: per_ssl_shd.g_old_rec.twenty_fifth_percentile;
766: per_ssl_shd.g_old_rec.tenth_percentile;
767: End If;
768: If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then
769: p_rec.twenty_fifth_percentile :=
770: per_ssl_shd.g_old_rec.twenty_fifth_percentile;
771: End If;
772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then
773: p_rec.fiftieth_percentile :=
774: per_ssl_shd.g_old_rec.fiftieth_percentile;
770: per_ssl_shd.g_old_rec.twenty_fifth_percentile;
771: End If;
772: If (p_rec.fiftieth_percentile = hr_api.g_number ) Then
773: p_rec.fiftieth_percentile :=
774: per_ssl_shd.g_old_rec.fiftieth_percentile;
775: End If;
776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then
777: p_rec.seventy_fifth_percentile :=
778: per_ssl_shd.g_old_rec.seventy_fifth_percentile;
774: per_ssl_shd.g_old_rec.fiftieth_percentile;
775: End If;
776: If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then
777: p_rec.seventy_fifth_percentile :=
778: per_ssl_shd.g_old_rec.seventy_fifth_percentile;
779: End If;
780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then
781: p_rec.ninetieth_percentile :=
782: per_ssl_shd.g_old_rec.ninetieth_percentile;
778: per_ssl_shd.g_old_rec.seventy_fifth_percentile;
779: End If;
780: If (p_rec.ninetieth_percentile = hr_api.g_number ) Then
781: p_rec.ninetieth_percentile :=
782: per_ssl_shd.g_old_rec.ninetieth_percentile;
783: End If;
784: If (p_rec.minimum_bonus = hr_api.g_number ) Then
785: p_rec.minimum_bonus :=
786: per_ssl_shd.g_old_rec.minimum_bonus;
782: per_ssl_shd.g_old_rec.ninetieth_percentile;
783: End If;
784: If (p_rec.minimum_bonus = hr_api.g_number ) Then
785: p_rec.minimum_bonus :=
786: per_ssl_shd.g_old_rec.minimum_bonus;
787: End If;
788: If (p_rec.mean_bonus = hr_api.g_number ) Then
789: p_rec.mean_bonus :=
790: per_ssl_shd.g_old_rec.mean_bonus;
786: per_ssl_shd.g_old_rec.minimum_bonus;
787: End If;
788: If (p_rec.mean_bonus = hr_api.g_number ) Then
789: p_rec.mean_bonus :=
790: per_ssl_shd.g_old_rec.mean_bonus;
791: End If;
792: If (p_rec.maximum_bonus = hr_api.g_number ) Then
793: p_rec.maximum_bonus :=
794: per_ssl_shd.g_old_rec.maximum_bonus;
790: per_ssl_shd.g_old_rec.mean_bonus;
791: End If;
792: If (p_rec.maximum_bonus = hr_api.g_number ) Then
793: p_rec.maximum_bonus :=
794: per_ssl_shd.g_old_rec.maximum_bonus;
795: End If;
796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then
797: p_rec.minimum_salary_increase :=
798: per_ssl_shd.g_old_rec.minimum_salary_increase;
794: per_ssl_shd.g_old_rec.maximum_bonus;
795: End If;
796: If (p_rec.minimum_salary_increase = hr_api.g_number ) Then
797: p_rec.minimum_salary_increase :=
798: per_ssl_shd.g_old_rec.minimum_salary_increase;
799: End If;
800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then
801: p_rec.mean_salary_increase :=
802: per_ssl_shd.g_old_rec.mean_salary_increase;
798: per_ssl_shd.g_old_rec.minimum_salary_increase;
799: End If;
800: If (p_rec.mean_salary_increase = hr_api.g_number ) Then
801: p_rec.mean_salary_increase :=
802: per_ssl_shd.g_old_rec.mean_salary_increase;
803: End If;
804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then
805: p_rec.maximum_salary_increase :=
806: per_ssl_shd.g_old_rec.maximum_salary_increase;
802: per_ssl_shd.g_old_rec.mean_salary_increase;
803: End If;
804: If (p_rec.maximum_salary_increase = hr_api.g_number ) Then
805: p_rec.maximum_salary_increase :=
806: per_ssl_shd.g_old_rec.maximum_salary_increase;
807: End If;
808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then
809: p_rec.min_variable_compensation :=
810: per_ssl_shd.g_old_rec.min_variable_compensation;
806: per_ssl_shd.g_old_rec.maximum_salary_increase;
807: End If;
808: If (p_rec.min_variable_compensation = hr_api.g_number ) Then
809: p_rec.min_variable_compensation :=
810: per_ssl_shd.g_old_rec.min_variable_compensation;
811: End If;
812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then
813: p_rec.mean_variable_compensation :=
814: per_ssl_shd.g_old_rec.mean_variable_compensation;
810: per_ssl_shd.g_old_rec.min_variable_compensation;
811: End If;
812: If (p_rec.mean_variable_compensation = hr_api.g_number ) Then
813: p_rec.mean_variable_compensation :=
814: per_ssl_shd.g_old_rec.mean_variable_compensation;
815: End If;
816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then
817: p_rec.max_variable_compensation :=
818: per_ssl_shd.g_old_rec.max_variable_compensation;
814: per_ssl_shd.g_old_rec.mean_variable_compensation;
815: End If;
816: If (p_rec.max_variable_compensation = hr_api.g_number ) Then
817: p_rec.max_variable_compensation :=
818: per_ssl_shd.g_old_rec.max_variable_compensation;
819: End If;
820: If (p_rec.minimum_stock = hr_api.g_number ) Then
821: p_rec.minimum_stock :=
822: per_ssl_shd.g_old_rec.minimum_stock;
818: per_ssl_shd.g_old_rec.max_variable_compensation;
819: End If;
820: If (p_rec.minimum_stock = hr_api.g_number ) Then
821: p_rec.minimum_stock :=
822: per_ssl_shd.g_old_rec.minimum_stock;
823: End If;
824: If (p_rec.mean_stock = hr_api.g_number ) Then
825: p_rec.mean_stock :=
826: per_ssl_shd.g_old_rec.mean_stock;
822: per_ssl_shd.g_old_rec.minimum_stock;
823: End If;
824: If (p_rec.mean_stock = hr_api.g_number ) Then
825: p_rec.mean_stock :=
826: per_ssl_shd.g_old_rec.mean_stock;
827: End If;
828: If (p_rec.maximum_stock = hr_api.g_number ) Then
829: p_rec.maximum_stock :=
830: per_ssl_shd.g_old_rec.maximum_stock;
826: per_ssl_shd.g_old_rec.mean_stock;
827: End If;
828: If (p_rec.maximum_stock = hr_api.g_number ) Then
829: p_rec.maximum_stock :=
830: per_ssl_shd.g_old_rec.maximum_stock;
831: End If;
832: If (p_rec.stock_display_type = hr_api.g_varchar2) Then
833: p_rec.stock_display_type :=
834: per_ssl_shd.g_old_rec.stock_display_type;
830: per_ssl_shd.g_old_rec.maximum_stock;
831: End If;
832: If (p_rec.stock_display_type = hr_api.g_varchar2) Then
833: p_rec.stock_display_type :=
834: per_ssl_shd.g_old_rec.stock_display_type;
835: End If;
836: /*End Enhancement 4021737 */
837: If (p_rec.attribute_category = hr_api.g_varchar2 ) Then
838: p_rec.attribute_category :=
835: End If;
836: /*End Enhancement 4021737 */
837: If (p_rec.attribute_category = hr_api.g_varchar2 ) Then
838: p_rec.attribute_category :=
839: per_ssl_shd.g_old_rec.attribute_category;
840: End If;
841: If (p_rec.attribute1 = hr_api.g_varchar2) Then
842: p_rec.attribute1 :=
843: per_ssl_shd.g_old_rec.attribute1;
839: per_ssl_shd.g_old_rec.attribute_category;
840: End If;
841: If (p_rec.attribute1 = hr_api.g_varchar2) Then
842: p_rec.attribute1 :=
843: per_ssl_shd.g_old_rec.attribute1;
844: End If;
845: If (p_rec.attribute2 = hr_api.g_varchar2) Then
846: p_rec.attribute2 :=
847: per_ssl_shd.g_old_rec.attribute2;
843: per_ssl_shd.g_old_rec.attribute1;
844: End If;
845: If (p_rec.attribute2 = hr_api.g_varchar2) Then
846: p_rec.attribute2 :=
847: per_ssl_shd.g_old_rec.attribute2;
848: End If;
849: If (p_rec.attribute3 = hr_api.g_varchar2) Then
850: p_rec.attribute3 :=
851: per_ssl_shd.g_old_rec.attribute3;
847: per_ssl_shd.g_old_rec.attribute2;
848: End If;
849: If (p_rec.attribute3 = hr_api.g_varchar2) Then
850: p_rec.attribute3 :=
851: per_ssl_shd.g_old_rec.attribute3;
852: End If;
853: If (p_rec.attribute4 = hr_api.g_varchar2) Then
854: p_rec.attribute4 :=
855: per_ssl_shd.g_old_rec.attribute4;
851: per_ssl_shd.g_old_rec.attribute3;
852: End If;
853: If (p_rec.attribute4 = hr_api.g_varchar2) Then
854: p_rec.attribute4 :=
855: per_ssl_shd.g_old_rec.attribute4;
856: End If;
857: If (p_rec.attribute5 = hr_api.g_varchar2) Then
858: p_rec.attribute5 :=
859: per_ssl_shd.g_old_rec.attribute5;
855: per_ssl_shd.g_old_rec.attribute4;
856: End If;
857: If (p_rec.attribute5 = hr_api.g_varchar2) Then
858: p_rec.attribute5 :=
859: per_ssl_shd.g_old_rec.attribute5;
860: End If;
861: If (p_rec.attribute6 = hr_api.g_varchar2) Then
862: p_rec.attribute6 :=
863: per_ssl_shd.g_old_rec.attribute6;
859: per_ssl_shd.g_old_rec.attribute5;
860: End If;
861: If (p_rec.attribute6 = hr_api.g_varchar2) Then
862: p_rec.attribute6 :=
863: per_ssl_shd.g_old_rec.attribute6;
864: End If;
865: If (p_rec.attribute7 = hr_api.g_varchar2) Then
866: p_rec.attribute7 :=
867: per_ssl_shd.g_old_rec.attribute7;
863: per_ssl_shd.g_old_rec.attribute6;
864: End If;
865: If (p_rec.attribute7 = hr_api.g_varchar2) Then
866: p_rec.attribute7 :=
867: per_ssl_shd.g_old_rec.attribute7;
868: End If;
869: If (p_rec.attribute8 = hr_api.g_varchar2) Then
870: p_rec.attribute8 :=
871: per_ssl_shd.g_old_rec.attribute8;
867: per_ssl_shd.g_old_rec.attribute7;
868: End If;
869: If (p_rec.attribute8 = hr_api.g_varchar2) Then
870: p_rec.attribute8 :=
871: per_ssl_shd.g_old_rec.attribute8;
872: End If;
873: If (p_rec.attribute9 = hr_api.g_varchar2) Then
874: p_rec.attribute9 :=
875: per_ssl_shd.g_old_rec.attribute9;
871: per_ssl_shd.g_old_rec.attribute8;
872: End If;
873: If (p_rec.attribute9 = hr_api.g_varchar2) Then
874: p_rec.attribute9 :=
875: per_ssl_shd.g_old_rec.attribute9;
876: End If;
877: If (p_rec.attribute10 = hr_api.g_varchar2) Then
878: p_rec.attribute10 :=
879: per_ssl_shd.g_old_rec.attribute10;
875: per_ssl_shd.g_old_rec.attribute9;
876: End If;
877: If (p_rec.attribute10 = hr_api.g_varchar2) Then
878: p_rec.attribute10 :=
879: per_ssl_shd.g_old_rec.attribute10;
880: End If;
881: If (p_rec.attribute11 = hr_api.g_varchar2) Then
882: p_rec.attribute11 :=
883: per_ssl_shd.g_old_rec.attribute11;
879: per_ssl_shd.g_old_rec.attribute10;
880: End If;
881: If (p_rec.attribute11 = hr_api.g_varchar2) Then
882: p_rec.attribute11 :=
883: per_ssl_shd.g_old_rec.attribute11;
884: End If;
885: If (p_rec.attribute12 = hr_api.g_varchar2) Then
886: p_rec.attribute12 :=
887: per_ssl_shd.g_old_rec.attribute12;
883: per_ssl_shd.g_old_rec.attribute11;
884: End If;
885: If (p_rec.attribute12 = hr_api.g_varchar2) Then
886: p_rec.attribute12 :=
887: per_ssl_shd.g_old_rec.attribute12;
888: End If;
889: If (p_rec.attribute13 = hr_api.g_varchar2) Then
890: p_rec.attribute13 :=
891: per_ssl_shd.g_old_rec.attribute13;
887: per_ssl_shd.g_old_rec.attribute12;
888: End If;
889: If (p_rec.attribute13 = hr_api.g_varchar2) Then
890: p_rec.attribute13 :=
891: per_ssl_shd.g_old_rec.attribute13;
892: End If;
893: If (p_rec.attribute14 = hr_api.g_varchar2) Then
894: p_rec.attribute14 :=
895: per_ssl_shd.g_old_rec.attribute14;
891: per_ssl_shd.g_old_rec.attribute13;
892: End If;
893: If (p_rec.attribute14 = hr_api.g_varchar2) Then
894: p_rec.attribute14 :=
895: per_ssl_shd.g_old_rec.attribute14;
896: End If;
897: If (p_rec.attribute15 = hr_api.g_varchar2) Then
898: p_rec.attribute15 :=
899: per_ssl_shd.g_old_rec.attribute15;
895: per_ssl_shd.g_old_rec.attribute14;
896: End If;
897: If (p_rec.attribute15 = hr_api.g_varchar2) Then
898: p_rec.attribute15 :=
899: per_ssl_shd.g_old_rec.attribute15;
900: End If;
901: If (p_rec.attribute16 = hr_api.g_varchar2) Then
902: p_rec.attribute16 :=
903: per_ssl_shd.g_old_rec.attribute16;
899: per_ssl_shd.g_old_rec.attribute15;
900: End If;
901: If (p_rec.attribute16 = hr_api.g_varchar2) Then
902: p_rec.attribute16 :=
903: per_ssl_shd.g_old_rec.attribute16;
904: End If;
905: If (p_rec.attribute17 = hr_api.g_varchar2) Then
906: p_rec.attribute17 :=
907: per_ssl_shd.g_old_rec.attribute17;
903: per_ssl_shd.g_old_rec.attribute16;
904: End If;
905: If (p_rec.attribute17 = hr_api.g_varchar2) Then
906: p_rec.attribute17 :=
907: per_ssl_shd.g_old_rec.attribute17;
908: End If;
909: If (p_rec.attribute18 = hr_api.g_varchar2) Then
910: p_rec.attribute18 :=
911: per_ssl_shd.g_old_rec.attribute18;
907: per_ssl_shd.g_old_rec.attribute17;
908: End If;
909: If (p_rec.attribute18 = hr_api.g_varchar2) Then
910: p_rec.attribute18 :=
911: per_ssl_shd.g_old_rec.attribute18;
912: End If;
913: If (p_rec.attribute19 = hr_api.g_varchar2) Then
914: p_rec.attribute19 :=
915: per_ssl_shd.g_old_rec.attribute19;
911: per_ssl_shd.g_old_rec.attribute18;
912: End If;
913: If (p_rec.attribute19 = hr_api.g_varchar2) Then
914: p_rec.attribute19 :=
915: per_ssl_shd.g_old_rec.attribute19;
916: End If;
917: If (p_rec.attribute20 = hr_api.g_varchar2) Then
918: p_rec.attribute20 :=
919: per_ssl_shd.g_old_rec.attribute20;
915: per_ssl_shd.g_old_rec.attribute19;
916: End If;
917: If (p_rec.attribute20 = hr_api.g_varchar2) Then
918: p_rec.attribute20 :=
919: per_ssl_shd.g_old_rec.attribute20;
920: End If;
921: /*Added for Enhancement 4021737 */
922: If (p_rec.attribute21 = hr_api.g_varchar2) Then
923: p_rec.attribute21 :=
920: End If;
921: /*Added for Enhancement 4021737 */
922: If (p_rec.attribute21 = hr_api.g_varchar2) Then
923: p_rec.attribute21 :=
924: per_ssl_shd.g_old_rec.attribute21;
925: End If;
926: If (p_rec.attribute22 = hr_api.g_varchar2) Then
927: p_rec.attribute22 :=
928: per_ssl_shd.g_old_rec.attribute22;
924: per_ssl_shd.g_old_rec.attribute21;
925: End If;
926: If (p_rec.attribute22 = hr_api.g_varchar2) Then
927: p_rec.attribute22 :=
928: per_ssl_shd.g_old_rec.attribute22;
929: End If;
930: If (p_rec.attribute23 = hr_api.g_varchar2) Then
931: p_rec.attribute23 :=
932: per_ssl_shd.g_old_rec.attribute23;
928: per_ssl_shd.g_old_rec.attribute22;
929: End If;
930: If (p_rec.attribute23 = hr_api.g_varchar2) Then
931: p_rec.attribute23 :=
932: per_ssl_shd.g_old_rec.attribute23;
933: End If;
934: If (p_rec.attribute24 = hr_api.g_varchar2) Then
935: p_rec.attribute24 :=
936: per_ssl_shd.g_old_rec.attribute24;
932: per_ssl_shd.g_old_rec.attribute23;
933: End If;
934: If (p_rec.attribute24 = hr_api.g_varchar2) Then
935: p_rec.attribute24 :=
936: per_ssl_shd.g_old_rec.attribute24;
937: End If;
938: If (p_rec.attribute25 = hr_api.g_varchar2) Then
939: p_rec.attribute25 :=
940: per_ssl_shd.g_old_rec.attribute25;
936: per_ssl_shd.g_old_rec.attribute24;
937: End If;
938: If (p_rec.attribute25 = hr_api.g_varchar2) Then
939: p_rec.attribute25 :=
940: per_ssl_shd.g_old_rec.attribute25;
941: End If;
942: If (p_rec.attribute26 = hr_api.g_varchar2) Then
943: p_rec.attribute26 :=
944: per_ssl_shd.g_old_rec.attribute26;
940: per_ssl_shd.g_old_rec.attribute25;
941: End If;
942: If (p_rec.attribute26 = hr_api.g_varchar2) Then
943: p_rec.attribute26 :=
944: per_ssl_shd.g_old_rec.attribute26;
945: End If;
946: If (p_rec.attribute27 = hr_api.g_varchar2) Then
947: p_rec.attribute27 :=
948: per_ssl_shd.g_old_rec.attribute27;
944: per_ssl_shd.g_old_rec.attribute26;
945: End If;
946: If (p_rec.attribute27 = hr_api.g_varchar2) Then
947: p_rec.attribute27 :=
948: per_ssl_shd.g_old_rec.attribute27;
949: End If;
950: If (p_rec.attribute28 = hr_api.g_varchar2) Then
951: p_rec.attribute28 :=
952: per_ssl_shd.g_old_rec.attribute28;
948: per_ssl_shd.g_old_rec.attribute27;
949: End If;
950: If (p_rec.attribute28 = hr_api.g_varchar2) Then
951: p_rec.attribute28 :=
952: per_ssl_shd.g_old_rec.attribute28;
953: End If;
954: If (p_rec.attribute29 = hr_api.g_varchar2) Then
955: p_rec.attribute29 :=
956: per_ssl_shd.g_old_rec.attribute29;
952: per_ssl_shd.g_old_rec.attribute28;
953: End If;
954: If (p_rec.attribute29 = hr_api.g_varchar2) Then
955: p_rec.attribute29 :=
956: per_ssl_shd.g_old_rec.attribute29;
957: End If;
958: If (p_rec.attribute30 = hr_api.g_varchar2) Then
959: p_rec.attribute30 :=
960: per_ssl_shd.g_old_rec.attribute30;
956: per_ssl_shd.g_old_rec.attribute29;
957: End If;
958: If (p_rec.attribute30 = hr_api.g_varchar2) Then
959: p_rec.attribute30 :=
960: per_ssl_shd.g_old_rec.attribute30;
961: End If;
962: /*End Enhancement 4021737 */
963: --
964: hr_utility.set_location(' Leaving:'||l_proc, 10);
969: -- |---------------------------------< upd >----------------------------------|
970: -- ----------------------------------------------------------------------------
971: Procedure upd
972: (
973: p_rec in out nocopy per_ssl_shd.g_rec_type,
974: p_effective_date in date
975: ) is
976: --
977: l_proc varchar2(72) := g_package||'upd';
980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
982: -- We must lock the row which we need to update.
983: --
984: per_ssl_shd.lck
985: (
986: p_rec.salary_survey_line_id,
987: p_rec.object_version_number
988: );
1098: /*End Enhancement 4021737 */
1099: p_effective_date in date
1100: ) is
1101: --
1102: l_rec per_ssl_shd.g_rec_type;
1103: l_proc varchar2(72) := g_package||'upd';
1104: --
1105: Begin
1106: hr_utility.set_location('Entering:'||l_proc, 5);
1108: -- Call conversion function to turn arguments into the
1109: -- l_rec structure.
1110: --
1111: l_rec :=
1112: per_ssl_shd.convert_args
1113: (
1114: p_salary_survey_line_id,
1115: p_object_version_number,
1116: hr_api.g_number,