44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
210: --
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: pqh_ptx_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
214: pqh_ptx_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When hr_api.parent_integrity_violated Then
217: -- Parent integrity has been violated
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: pqh_ptx_shd.constraint_error
218: pqh_ptx_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: pqh_ptx_shd.constraint_error
223: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
224: When Others Then
225: Raise;
226: End update_dml;
256: -- Internal Row Handler Use Only.
257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure pre_update(p_rec in pqh_ptx_shd.g_rec_type) is
261: --
262: l_proc varchar2(72) := g_package||'pre_update';
263: --
264: Begin
299: --
300: -- {End Of Comments}
301: -- ----------------------------------------------------------------------------
302: Procedure post_update(
303: p_effective_date in date,p_rec in pqh_ptx_shd.g_rec_type) is
304: --
305: l_proc varchar2(72) := g_package||'post_update';
306: --
307: l_effective_start_date date;
334: fetch c_review_flag into l_review_flag;
335: close c_review_flag;
336: --
337: if (nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'Y'
338: and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then
339: hr_utility.set_message(1802, 'PQH_POSITION_UNDER_REVIEW');
340: hr_utility.raise_error;
341: /* Bug 6524175 changes
342: elsif ((nvl(p_rec.review_flag,'N') = 'Y' and nvl(l_review_flag,'N') = 'N')
509: ,p_attribute30 =>p_rec.attribute30
510: ,p_attribute_category =>p_rec.attribute_category
511: ,p_object_version_number =>p_rec.object_version_number
512: ,p_effective_date =>p_effective_date
513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
510: ,p_attribute_category =>p_rec.attribute_category
511: ,p_object_version_number =>p_rec.object_version_number
512: ,p_effective_date =>p_effective_date
513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
511: ,p_object_version_number =>p_rec.object_version_number
512: ,p_effective_date =>p_effective_date
513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
512: ,p_effective_date =>p_effective_date
513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_id
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_id
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_id
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_position_id
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_position_id
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_id
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_id
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_id
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_date
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_date
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_date
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_cd
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_cd
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
654: );
647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
654: );
655: --
648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
654: );
655: --
656: exception
649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category
650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number
651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id
652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id
653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id
654: );
655: --
656: exception
657: --
711: -- Internal Row Handler Use Only.
712: --
713: -- {End Of Comments}
714: -- ----------------------------------------------------------------------------
715: Procedure convert_defs(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is
716: --
717: l_proc varchar2(72) := g_package||'convert_defs';
718: --
719: Begin
726: -- is being used then we must set to the 'current' argument value.
727: --
728: If (p_rec.action_date = hr_api.g_date) then
729: p_rec.action_date :=
730: pqh_ptx_shd.g_old_rec.action_date;
731: End If;
732: If (p_rec.position_id = hr_api.g_number) then
733: p_rec.position_id :=
734: pqh_ptx_shd.g_old_rec.position_id;
730: pqh_ptx_shd.g_old_rec.action_date;
731: End If;
732: If (p_rec.position_id = hr_api.g_number) then
733: p_rec.position_id :=
734: pqh_ptx_shd.g_old_rec.position_id;
735: End If;
736: If (p_rec.availability_status_id = hr_api.g_number) then
737: p_rec.availability_status_id :=
738: pqh_ptx_shd.g_old_rec.availability_status_id;
734: pqh_ptx_shd.g_old_rec.position_id;
735: End If;
736: If (p_rec.availability_status_id = hr_api.g_number) then
737: p_rec.availability_status_id :=
738: pqh_ptx_shd.g_old_rec.availability_status_id;
739: End If;
740: If (p_rec.business_group_id = hr_api.g_number) then
741: p_rec.business_group_id :=
742: pqh_ptx_shd.g_old_rec.business_group_id;
738: pqh_ptx_shd.g_old_rec.availability_status_id;
739: End If;
740: If (p_rec.business_group_id = hr_api.g_number) then
741: p_rec.business_group_id :=
742: pqh_ptx_shd.g_old_rec.business_group_id;
743: End If;
744: If (p_rec.entry_step_id = hr_api.g_number) then
745: p_rec.entry_step_id :=
746: pqh_ptx_shd.g_old_rec.entry_step_id;
742: pqh_ptx_shd.g_old_rec.business_group_id;
743: End If;
744: If (p_rec.entry_step_id = hr_api.g_number) then
745: p_rec.entry_step_id :=
746: pqh_ptx_shd.g_old_rec.entry_step_id;
747: End If;
748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
749: p_rec.entry_grade_rule_id :=
750: pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
746: pqh_ptx_shd.g_old_rec.entry_step_id;
747: End If;
748: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
749: p_rec.entry_grade_rule_id :=
750: pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
751: End If;
752: If (p_rec.job_id = hr_api.g_number) then
753: p_rec.job_id :=
754: pqh_ptx_shd.g_old_rec.job_id;
750: pqh_ptx_shd.g_old_rec.entry_grade_rule_id;
751: End If;
752: If (p_rec.job_id = hr_api.g_number) then
753: p_rec.job_id :=
754: pqh_ptx_shd.g_old_rec.job_id;
755: End If;
756: If (p_rec.location_id = hr_api.g_number) then
757: p_rec.location_id :=
758: pqh_ptx_shd.g_old_rec.location_id;
754: pqh_ptx_shd.g_old_rec.job_id;
755: End If;
756: If (p_rec.location_id = hr_api.g_number) then
757: p_rec.location_id :=
758: pqh_ptx_shd.g_old_rec.location_id;
759: End If;
760: If (p_rec.organization_id = hr_api.g_number) then
761: p_rec.organization_id :=
762: pqh_ptx_shd.g_old_rec.organization_id;
758: pqh_ptx_shd.g_old_rec.location_id;
759: End If;
760: If (p_rec.organization_id = hr_api.g_number) then
761: p_rec.organization_id :=
762: pqh_ptx_shd.g_old_rec.organization_id;
763: End If;
764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
765: p_rec.pay_freq_payroll_id :=
766: pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
762: pqh_ptx_shd.g_old_rec.organization_id;
763: End If;
764: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
765: p_rec.pay_freq_payroll_id :=
766: pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
767: End If;
768: If (p_rec.position_definition_id = hr_api.g_number) then
769: p_rec.position_definition_id :=
770: pqh_ptx_shd.g_old_rec.position_definition_id;
766: pqh_ptx_shd.g_old_rec.pay_freq_payroll_id;
767: End If;
768: If (p_rec.position_definition_id = hr_api.g_number) then
769: p_rec.position_definition_id :=
770: pqh_ptx_shd.g_old_rec.position_definition_id;
771: End If;
772: If (p_rec.prior_position_id = hr_api.g_number) then
773: p_rec.prior_position_id :=
774: pqh_ptx_shd.g_old_rec.prior_position_id;
770: pqh_ptx_shd.g_old_rec.position_definition_id;
771: End If;
772: If (p_rec.prior_position_id = hr_api.g_number) then
773: p_rec.prior_position_id :=
774: pqh_ptx_shd.g_old_rec.prior_position_id;
775: End If;
776: If (p_rec.relief_position_id = hr_api.g_number) then
777: p_rec.relief_position_id :=
778: pqh_ptx_shd.g_old_rec.relief_position_id;
774: pqh_ptx_shd.g_old_rec.prior_position_id;
775: End If;
776: If (p_rec.relief_position_id = hr_api.g_number) then
777: p_rec.relief_position_id :=
778: pqh_ptx_shd.g_old_rec.relief_position_id;
779: End If;
780: If (p_rec.entry_grade_id = hr_api.g_number) then
781: p_rec.entry_grade_id :=
782: pqh_ptx_shd.g_old_rec.entry_grade_id;
778: pqh_ptx_shd.g_old_rec.relief_position_id;
779: End If;
780: If (p_rec.entry_grade_id = hr_api.g_number) then
781: p_rec.entry_grade_id :=
782: pqh_ptx_shd.g_old_rec.entry_grade_id;
783: End If;
784: If (p_rec.successor_position_id = hr_api.g_number) then
785: p_rec.successor_position_id :=
786: pqh_ptx_shd.g_old_rec.successor_position_id;
782: pqh_ptx_shd.g_old_rec.entry_grade_id;
783: End If;
784: If (p_rec.successor_position_id = hr_api.g_number) then
785: p_rec.successor_position_id :=
786: pqh_ptx_shd.g_old_rec.successor_position_id;
787: End If;
788: If (p_rec.supervisor_position_id = hr_api.g_number) then
789: p_rec.supervisor_position_id :=
790: pqh_ptx_shd.g_old_rec.supervisor_position_id;
786: pqh_ptx_shd.g_old_rec.successor_position_id;
787: End If;
788: If (p_rec.supervisor_position_id = hr_api.g_number) then
789: p_rec.supervisor_position_id :=
790: pqh_ptx_shd.g_old_rec.supervisor_position_id;
791: End If;
792: If (p_rec.amendment_date = hr_api.g_date) then
793: p_rec.amendment_date :=
794: pqh_ptx_shd.g_old_rec.amendment_date;
790: pqh_ptx_shd.g_old_rec.supervisor_position_id;
791: End If;
792: If (p_rec.amendment_date = hr_api.g_date) then
793: p_rec.amendment_date :=
794: pqh_ptx_shd.g_old_rec.amendment_date;
795: End If;
796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
797: p_rec.amendment_recommendation :=
798: pqh_ptx_shd.g_old_rec.amendment_recommendation;
794: pqh_ptx_shd.g_old_rec.amendment_date;
795: End If;
796: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
797: p_rec.amendment_recommendation :=
798: pqh_ptx_shd.g_old_rec.amendment_recommendation;
799: End If;
800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
801: p_rec.amendment_ref_number :=
802: pqh_ptx_shd.g_old_rec.amendment_ref_number;
798: pqh_ptx_shd.g_old_rec.amendment_recommendation;
799: End If;
800: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
801: p_rec.amendment_ref_number :=
802: pqh_ptx_shd.g_old_rec.amendment_ref_number;
803: End If;
804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
805: p_rec.avail_status_prop_end_date :=
806: pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
802: pqh_ptx_shd.g_old_rec.amendment_ref_number;
803: End If;
804: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
805: p_rec.avail_status_prop_end_date :=
806: pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
807: End If;
808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
809: p_rec.bargaining_unit_cd :=
810: pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
806: pqh_ptx_shd.g_old_rec.avail_status_prop_end_date;
807: End If;
808: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
809: p_rec.bargaining_unit_cd :=
810: pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
811: End If;
812: If (p_rec.comments = hr_api.g_varchar2) then
813: p_rec.comments :=
814: pqh_ptx_shd.g_old_rec.comments;
810: pqh_ptx_shd.g_old_rec.bargaining_unit_cd;
811: End If;
812: If (p_rec.comments = hr_api.g_varchar2) then
813: p_rec.comments :=
814: pqh_ptx_shd.g_old_rec.comments;
815: End If;
816: If (p_rec.country1 = hr_api.g_varchar2) then
817: p_rec.country1 :=
818: pqh_ptx_shd.g_old_rec.country1;
814: pqh_ptx_shd.g_old_rec.comments;
815: End If;
816: If (p_rec.country1 = hr_api.g_varchar2) then
817: p_rec.country1 :=
818: pqh_ptx_shd.g_old_rec.country1;
819: End If;
820: If (p_rec.country2 = hr_api.g_varchar2) then
821: p_rec.country2 :=
822: pqh_ptx_shd.g_old_rec.country2;
818: pqh_ptx_shd.g_old_rec.country1;
819: End If;
820: If (p_rec.country2 = hr_api.g_varchar2) then
821: p_rec.country2 :=
822: pqh_ptx_shd.g_old_rec.country2;
823: End If;
824: If (p_rec.country3 = hr_api.g_varchar2) then
825: p_rec.country3 :=
826: pqh_ptx_shd.g_old_rec.country3;
822: pqh_ptx_shd.g_old_rec.country2;
823: End If;
824: If (p_rec.country3 = hr_api.g_varchar2) then
825: p_rec.country3 :=
826: pqh_ptx_shd.g_old_rec.country3;
827: End If;
828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
829: p_rec.current_job_prop_end_date :=
830: pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
826: pqh_ptx_shd.g_old_rec.country3;
827: End If;
828: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
829: p_rec.current_job_prop_end_date :=
830: pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
831: End If;
832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
833: p_rec.current_org_prop_end_date :=
834: pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
830: pqh_ptx_shd.g_old_rec.current_job_prop_end_date;
831: End If;
832: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
833: p_rec.current_org_prop_end_date :=
834: pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
835: End If;
836: If (p_rec.date_effective = hr_api.g_date) then
837: p_rec.date_effective :=
838: pqh_ptx_shd.g_old_rec.date_effective;
834: pqh_ptx_shd.g_old_rec.current_org_prop_end_date;
835: End If;
836: If (p_rec.date_effective = hr_api.g_date) then
837: p_rec.date_effective :=
838: pqh_ptx_shd.g_old_rec.date_effective;
839: End If;
840: If (p_rec.date_end = hr_api.g_date) then
841: p_rec.date_end :=
842: pqh_ptx_shd.g_old_rec.date_end;
838: pqh_ptx_shd.g_old_rec.date_effective;
839: End If;
840: If (p_rec.date_end = hr_api.g_date) then
841: p_rec.date_end :=
842: pqh_ptx_shd.g_old_rec.date_end;
843: End If;
844: If (p_rec.earliest_hire_date = hr_api.g_date) then
845: p_rec.earliest_hire_date :=
846: pqh_ptx_shd.g_old_rec.earliest_hire_date;
842: pqh_ptx_shd.g_old_rec.date_end;
843: End If;
844: If (p_rec.earliest_hire_date = hr_api.g_date) then
845: p_rec.earliest_hire_date :=
846: pqh_ptx_shd.g_old_rec.earliest_hire_date;
847: End If;
848: If (p_rec.fill_by_date = hr_api.g_date) then
849: p_rec.fill_by_date :=
850: pqh_ptx_shd.g_old_rec.fill_by_date;
846: pqh_ptx_shd.g_old_rec.earliest_hire_date;
847: End If;
848: If (p_rec.fill_by_date = hr_api.g_date) then
849: p_rec.fill_by_date :=
850: pqh_ptx_shd.g_old_rec.fill_by_date;
851: End If;
852: If (p_rec.frequency = hr_api.g_varchar2) then
853: p_rec.frequency :=
854: pqh_ptx_shd.g_old_rec.frequency;
850: pqh_ptx_shd.g_old_rec.fill_by_date;
851: End If;
852: If (p_rec.frequency = hr_api.g_varchar2) then
853: p_rec.frequency :=
854: pqh_ptx_shd.g_old_rec.frequency;
855: End If;
856: If (p_rec.fte = hr_api.g_number) then
857: p_rec.fte :=
858: pqh_ptx_shd.g_old_rec.fte;
854: pqh_ptx_shd.g_old_rec.frequency;
855: End If;
856: If (p_rec.fte = hr_api.g_number) then
857: p_rec.fte :=
858: pqh_ptx_shd.g_old_rec.fte;
859: End If;
860: If (p_rec.fte_capacity = hr_api.g_varchar2) then
861: p_rec.fte_capacity :=
862: pqh_ptx_shd.g_old_rec.fte_capacity;
858: pqh_ptx_shd.g_old_rec.fte;
859: End If;
860: If (p_rec.fte_capacity = hr_api.g_varchar2) then
861: p_rec.fte_capacity :=
862: pqh_ptx_shd.g_old_rec.fte_capacity;
863: End If;
864: If (p_rec.location1 = hr_api.g_varchar2) then
865: p_rec.location1 :=
866: pqh_ptx_shd.g_old_rec.location1;
862: pqh_ptx_shd.g_old_rec.fte_capacity;
863: End If;
864: If (p_rec.location1 = hr_api.g_varchar2) then
865: p_rec.location1 :=
866: pqh_ptx_shd.g_old_rec.location1;
867: End If;
868: If (p_rec.location2 = hr_api.g_varchar2) then
869: p_rec.location2 :=
870: pqh_ptx_shd.g_old_rec.location2;
866: pqh_ptx_shd.g_old_rec.location1;
867: End If;
868: If (p_rec.location2 = hr_api.g_varchar2) then
869: p_rec.location2 :=
870: pqh_ptx_shd.g_old_rec.location2;
871: End If;
872: If (p_rec.location3 = hr_api.g_varchar2) then
873: p_rec.location3 :=
874: pqh_ptx_shd.g_old_rec.location3;
870: pqh_ptx_shd.g_old_rec.location2;
871: End If;
872: If (p_rec.location3 = hr_api.g_varchar2) then
873: p_rec.location3 :=
874: pqh_ptx_shd.g_old_rec.location3;
875: End If;
876: If (p_rec.max_persons = hr_api.g_number) then
877: p_rec.max_persons :=
878: pqh_ptx_shd.g_old_rec.max_persons;
874: pqh_ptx_shd.g_old_rec.location3;
875: End If;
876: If (p_rec.max_persons = hr_api.g_number) then
877: p_rec.max_persons :=
878: pqh_ptx_shd.g_old_rec.max_persons;
879: End If;
880: If (p_rec.name = hr_api.g_varchar2) then
881: p_rec.name :=
882: pqh_ptx_shd.g_old_rec.name;
878: pqh_ptx_shd.g_old_rec.max_persons;
879: End If;
880: If (p_rec.name = hr_api.g_varchar2) then
881: p_rec.name :=
882: pqh_ptx_shd.g_old_rec.name;
883: End If;
884: If (p_rec.other_requirements = hr_api.g_varchar2) then
885: p_rec.other_requirements :=
886: pqh_ptx_shd.g_old_rec.other_requirements;
882: pqh_ptx_shd.g_old_rec.name;
883: End If;
884: If (p_rec.other_requirements = hr_api.g_varchar2) then
885: p_rec.other_requirements :=
886: pqh_ptx_shd.g_old_rec.other_requirements;
887: End If;
888: If (p_rec.overlap_period = hr_api.g_number) then
889: p_rec.overlap_period :=
890: pqh_ptx_shd.g_old_rec.overlap_period;
886: pqh_ptx_shd.g_old_rec.other_requirements;
887: End If;
888: If (p_rec.overlap_period = hr_api.g_number) then
889: p_rec.overlap_period :=
890: pqh_ptx_shd.g_old_rec.overlap_period;
891: End If;
892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
893: p_rec.overlap_unit_cd :=
894: pqh_ptx_shd.g_old_rec.overlap_unit_cd;
890: pqh_ptx_shd.g_old_rec.overlap_period;
891: End If;
892: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
893: p_rec.overlap_unit_cd :=
894: pqh_ptx_shd.g_old_rec.overlap_unit_cd;
895: End If;
896: If (p_rec.passport_required = hr_api.g_varchar2) then
897: p_rec.passport_required :=
898: pqh_ptx_shd.g_old_rec.passport_required;
894: pqh_ptx_shd.g_old_rec.overlap_unit_cd;
895: End If;
896: If (p_rec.passport_required = hr_api.g_varchar2) then
897: p_rec.passport_required :=
898: pqh_ptx_shd.g_old_rec.passport_required;
899: End If;
900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
901: p_rec.pay_term_end_day_cd :=
902: pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
898: pqh_ptx_shd.g_old_rec.passport_required;
899: End If;
900: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
901: p_rec.pay_term_end_day_cd :=
902: pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
903: End If;
904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
905: p_rec.pay_term_end_month_cd :=
906: pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
902: pqh_ptx_shd.g_old_rec.pay_term_end_day_cd;
903: End If;
904: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
905: p_rec.pay_term_end_month_cd :=
906: pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
907: End If;
908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
909: p_rec.permanent_temporary_flag :=
910: pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
906: pqh_ptx_shd.g_old_rec.pay_term_end_month_cd;
907: End If;
908: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
909: p_rec.permanent_temporary_flag :=
910: pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
911: End If;
912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
913: p_rec.permit_recruitment_flag :=
914: pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
910: pqh_ptx_shd.g_old_rec.permanent_temporary_flag;
911: End If;
912: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
913: p_rec.permit_recruitment_flag :=
914: pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
915: End If;
916: If (p_rec.position_type = hr_api.g_varchar2) then
917: p_rec.position_type :=
918: pqh_ptx_shd.g_old_rec.position_type;
914: pqh_ptx_shd.g_old_rec.permit_recruitment_flag;
915: End If;
916: If (p_rec.position_type = hr_api.g_varchar2) then
917: p_rec.position_type :=
918: pqh_ptx_shd.g_old_rec.position_type;
919: End If;
920: If (p_rec.posting_description = hr_api.g_varchar2) then
921: p_rec.posting_description :=
922: pqh_ptx_shd.g_old_rec.posting_description;
918: pqh_ptx_shd.g_old_rec.position_type;
919: End If;
920: If (p_rec.posting_description = hr_api.g_varchar2) then
921: p_rec.posting_description :=
922: pqh_ptx_shd.g_old_rec.posting_description;
923: End If;
924: If (p_rec.probation_period = hr_api.g_number) then
925: p_rec.probation_period :=
926: pqh_ptx_shd.g_old_rec.probation_period;
922: pqh_ptx_shd.g_old_rec.posting_description;
923: End If;
924: If (p_rec.probation_period = hr_api.g_number) then
925: p_rec.probation_period :=
926: pqh_ptx_shd.g_old_rec.probation_period;
927: End If;
928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
929: p_rec.probation_period_unit_cd :=
930: pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
926: pqh_ptx_shd.g_old_rec.probation_period;
927: End If;
928: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
929: p_rec.probation_period_unit_cd :=
930: pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
931: End If;
932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
933: p_rec.relocate_domestically :=
934: pqh_ptx_shd.g_old_rec.relocate_domestically;
930: pqh_ptx_shd.g_old_rec.probation_period_unit_cd;
931: End If;
932: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
933: p_rec.relocate_domestically :=
934: pqh_ptx_shd.g_old_rec.relocate_domestically;
935: End If;
936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
937: p_rec.relocate_internationally :=
938: pqh_ptx_shd.g_old_rec.relocate_internationally;
934: pqh_ptx_shd.g_old_rec.relocate_domestically;
935: End If;
936: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
937: p_rec.relocate_internationally :=
938: pqh_ptx_shd.g_old_rec.relocate_internationally;
939: End If;
940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
941: p_rec.replacement_required_flag :=
942: pqh_ptx_shd.g_old_rec.replacement_required_flag;
938: pqh_ptx_shd.g_old_rec.relocate_internationally;
939: End If;
940: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
941: p_rec.replacement_required_flag :=
942: pqh_ptx_shd.g_old_rec.replacement_required_flag;
943: End If;
944: If (p_rec.review_flag = hr_api.g_varchar2) then
945: p_rec.review_flag :=
946: pqh_ptx_shd.g_old_rec.review_flag;
942: pqh_ptx_shd.g_old_rec.replacement_required_flag;
943: End If;
944: If (p_rec.review_flag = hr_api.g_varchar2) then
945: p_rec.review_flag :=
946: pqh_ptx_shd.g_old_rec.review_flag;
947: End If;
948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
949: p_rec.seasonal_flag :=
950: pqh_ptx_shd.g_old_rec.seasonal_flag;
946: pqh_ptx_shd.g_old_rec.review_flag;
947: End If;
948: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
949: p_rec.seasonal_flag :=
950: pqh_ptx_shd.g_old_rec.seasonal_flag;
951: End If;
952: If (p_rec.security_requirements = hr_api.g_varchar2) then
953: p_rec.security_requirements :=
954: pqh_ptx_shd.g_old_rec.security_requirements;
950: pqh_ptx_shd.g_old_rec.seasonal_flag;
951: End If;
952: If (p_rec.security_requirements = hr_api.g_varchar2) then
953: p_rec.security_requirements :=
954: pqh_ptx_shd.g_old_rec.security_requirements;
955: End If;
956: If (p_rec.service_minimum = hr_api.g_varchar2) then
957: p_rec.service_minimum :=
958: pqh_ptx_shd.g_old_rec.service_minimum;
954: pqh_ptx_shd.g_old_rec.security_requirements;
955: End If;
956: If (p_rec.service_minimum = hr_api.g_varchar2) then
957: p_rec.service_minimum :=
958: pqh_ptx_shd.g_old_rec.service_minimum;
959: End If;
960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
961: p_rec.term_start_day_cd :=
962: pqh_ptx_shd.g_old_rec.term_start_day_cd;
958: pqh_ptx_shd.g_old_rec.service_minimum;
959: End If;
960: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
961: p_rec.term_start_day_cd :=
962: pqh_ptx_shd.g_old_rec.term_start_day_cd;
963: End If;
964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
965: p_rec.term_start_month_cd :=
966: pqh_ptx_shd.g_old_rec.term_start_month_cd;
962: pqh_ptx_shd.g_old_rec.term_start_day_cd;
963: End If;
964: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
965: p_rec.term_start_month_cd :=
966: pqh_ptx_shd.g_old_rec.term_start_month_cd;
967: End If;
968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
969: p_rec.time_normal_finish :=
970: pqh_ptx_shd.g_old_rec.time_normal_finish;
966: pqh_ptx_shd.g_old_rec.term_start_month_cd;
967: End If;
968: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
969: p_rec.time_normal_finish :=
970: pqh_ptx_shd.g_old_rec.time_normal_finish;
971: End If;
972: If (p_rec.time_normal_start = hr_api.g_varchar2) then
973: p_rec.time_normal_start :=
974: pqh_ptx_shd.g_old_rec.time_normal_start;
970: pqh_ptx_shd.g_old_rec.time_normal_finish;
971: End If;
972: If (p_rec.time_normal_start = hr_api.g_varchar2) then
973: p_rec.time_normal_start :=
974: pqh_ptx_shd.g_old_rec.time_normal_start;
975: End If;
976: If (p_rec.transaction_status = hr_api.g_varchar2) then
977: p_rec.transaction_status :=
978: pqh_ptx_shd.g_old_rec.transaction_status;
974: pqh_ptx_shd.g_old_rec.time_normal_start;
975: End If;
976: If (p_rec.transaction_status = hr_api.g_varchar2) then
977: p_rec.transaction_status :=
978: pqh_ptx_shd.g_old_rec.transaction_status;
979: End If;
980: If (p_rec.travel_required = hr_api.g_varchar2) then
981: p_rec.travel_required :=
982: pqh_ptx_shd.g_old_rec.travel_required;
978: pqh_ptx_shd.g_old_rec.transaction_status;
979: End If;
980: If (p_rec.travel_required = hr_api.g_varchar2) then
981: p_rec.travel_required :=
982: pqh_ptx_shd.g_old_rec.travel_required;
983: End If;
984: If (p_rec.working_hours = hr_api.g_number) then
985: p_rec.working_hours :=
986: pqh_ptx_shd.g_old_rec.working_hours;
982: pqh_ptx_shd.g_old_rec.travel_required;
983: End If;
984: If (p_rec.working_hours = hr_api.g_number) then
985: p_rec.working_hours :=
986: pqh_ptx_shd.g_old_rec.working_hours;
987: End If;
988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
989: p_rec.works_council_approval_flag :=
990: pqh_ptx_shd.g_old_rec.works_council_approval_flag;
986: pqh_ptx_shd.g_old_rec.working_hours;
987: End If;
988: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
989: p_rec.works_council_approval_flag :=
990: pqh_ptx_shd.g_old_rec.works_council_approval_flag;
991: End If;
992: If (p_rec.work_any_country = hr_api.g_varchar2) then
993: p_rec.work_any_country :=
994: pqh_ptx_shd.g_old_rec.work_any_country;
990: pqh_ptx_shd.g_old_rec.works_council_approval_flag;
991: End If;
992: If (p_rec.work_any_country = hr_api.g_varchar2) then
993: p_rec.work_any_country :=
994: pqh_ptx_shd.g_old_rec.work_any_country;
995: End If;
996: If (p_rec.work_any_location = hr_api.g_varchar2) then
997: p_rec.work_any_location :=
998: pqh_ptx_shd.g_old_rec.work_any_location;
994: pqh_ptx_shd.g_old_rec.work_any_country;
995: End If;
996: If (p_rec.work_any_location = hr_api.g_varchar2) then
997: p_rec.work_any_location :=
998: pqh_ptx_shd.g_old_rec.work_any_location;
999: End If;
1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1001: p_rec.work_period_type_cd :=
1002: pqh_ptx_shd.g_old_rec.work_period_type_cd;
998: pqh_ptx_shd.g_old_rec.work_any_location;
999: End If;
1000: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1001: p_rec.work_period_type_cd :=
1002: pqh_ptx_shd.g_old_rec.work_period_type_cd;
1003: End If;
1004: If (p_rec.work_schedule = hr_api.g_varchar2) then
1005: p_rec.work_schedule :=
1006: pqh_ptx_shd.g_old_rec.work_schedule;
1002: pqh_ptx_shd.g_old_rec.work_period_type_cd;
1003: End If;
1004: If (p_rec.work_schedule = hr_api.g_varchar2) then
1005: p_rec.work_schedule :=
1006: pqh_ptx_shd.g_old_rec.work_schedule;
1007: End If;
1008: If (p_rec.work_duration = hr_api.g_varchar2) then
1009: p_rec.work_duration :=
1010: pqh_ptx_shd.g_old_rec.work_duration;
1006: pqh_ptx_shd.g_old_rec.work_schedule;
1007: End If;
1008: If (p_rec.work_duration = hr_api.g_varchar2) then
1009: p_rec.work_duration :=
1010: pqh_ptx_shd.g_old_rec.work_duration;
1011: End If;
1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1013: p_rec.work_term_end_day_cd :=
1014: pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1010: pqh_ptx_shd.g_old_rec.work_duration;
1011: End If;
1012: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1013: p_rec.work_term_end_day_cd :=
1014: pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1015: End If;
1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1017: p_rec.work_term_end_month_cd :=
1018: pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1014: pqh_ptx_shd.g_old_rec.work_term_end_day_cd;
1015: End If;
1016: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1017: p_rec.work_term_end_month_cd :=
1018: pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1019: End If;
1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1021: p_rec.proposed_fte_for_layoff :=
1022: pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1018: pqh_ptx_shd.g_old_rec.work_term_end_month_cd;
1019: End If;
1020: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1021: p_rec.proposed_fte_for_layoff :=
1022: pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1023: End If;
1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1025: p_rec.proposed_date_for_layoff :=
1026: pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1022: pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff;
1023: End If;
1024: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1025: p_rec.proposed_date_for_layoff :=
1026: pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1027: End If;
1028: If (p_rec.information1 = hr_api.g_varchar2) then
1029: p_rec.information1 :=
1030: pqh_ptx_shd.g_old_rec.information1;
1026: pqh_ptx_shd.g_old_rec.proposed_date_for_layoff;
1027: End If;
1028: If (p_rec.information1 = hr_api.g_varchar2) then
1029: p_rec.information1 :=
1030: pqh_ptx_shd.g_old_rec.information1;
1031: End If;
1032: If (p_rec.information2 = hr_api.g_varchar2) then
1033: p_rec.information2 :=
1034: pqh_ptx_shd.g_old_rec.information2;
1030: pqh_ptx_shd.g_old_rec.information1;
1031: End If;
1032: If (p_rec.information2 = hr_api.g_varchar2) then
1033: p_rec.information2 :=
1034: pqh_ptx_shd.g_old_rec.information2;
1035: End If;
1036: If (p_rec.information3 = hr_api.g_varchar2) then
1037: p_rec.information3 :=
1038: pqh_ptx_shd.g_old_rec.information3;
1034: pqh_ptx_shd.g_old_rec.information2;
1035: End If;
1036: If (p_rec.information3 = hr_api.g_varchar2) then
1037: p_rec.information3 :=
1038: pqh_ptx_shd.g_old_rec.information3;
1039: End If;
1040: If (p_rec.information4 = hr_api.g_varchar2) then
1041: p_rec.information4 :=
1042: pqh_ptx_shd.g_old_rec.information4;
1038: pqh_ptx_shd.g_old_rec.information3;
1039: End If;
1040: If (p_rec.information4 = hr_api.g_varchar2) then
1041: p_rec.information4 :=
1042: pqh_ptx_shd.g_old_rec.information4;
1043: End If;
1044: If (p_rec.information5 = hr_api.g_varchar2) then
1045: p_rec.information5 :=
1046: pqh_ptx_shd.g_old_rec.information5;
1042: pqh_ptx_shd.g_old_rec.information4;
1043: End If;
1044: If (p_rec.information5 = hr_api.g_varchar2) then
1045: p_rec.information5 :=
1046: pqh_ptx_shd.g_old_rec.information5;
1047: End If;
1048: If (p_rec.information6 = hr_api.g_varchar2) then
1049: p_rec.information6 :=
1050: pqh_ptx_shd.g_old_rec.information6;
1046: pqh_ptx_shd.g_old_rec.information5;
1047: End If;
1048: If (p_rec.information6 = hr_api.g_varchar2) then
1049: p_rec.information6 :=
1050: pqh_ptx_shd.g_old_rec.information6;
1051: End If;
1052: If (p_rec.information7 = hr_api.g_varchar2) then
1053: p_rec.information7 :=
1054: pqh_ptx_shd.g_old_rec.information7;
1050: pqh_ptx_shd.g_old_rec.information6;
1051: End If;
1052: If (p_rec.information7 = hr_api.g_varchar2) then
1053: p_rec.information7 :=
1054: pqh_ptx_shd.g_old_rec.information7;
1055: End If;
1056: If (p_rec.information8 = hr_api.g_varchar2) then
1057: p_rec.information8 :=
1058: pqh_ptx_shd.g_old_rec.information8;
1054: pqh_ptx_shd.g_old_rec.information7;
1055: End If;
1056: If (p_rec.information8 = hr_api.g_varchar2) then
1057: p_rec.information8 :=
1058: pqh_ptx_shd.g_old_rec.information8;
1059: End If;
1060: If (p_rec.information9 = hr_api.g_varchar2) then
1061: p_rec.information9 :=
1062: pqh_ptx_shd.g_old_rec.information9;
1058: pqh_ptx_shd.g_old_rec.information8;
1059: End If;
1060: If (p_rec.information9 = hr_api.g_varchar2) then
1061: p_rec.information9 :=
1062: pqh_ptx_shd.g_old_rec.information9;
1063: End If;
1064: If (p_rec.information10 = hr_api.g_varchar2) then
1065: p_rec.information10 :=
1066: pqh_ptx_shd.g_old_rec.information10;
1062: pqh_ptx_shd.g_old_rec.information9;
1063: End If;
1064: If (p_rec.information10 = hr_api.g_varchar2) then
1065: p_rec.information10 :=
1066: pqh_ptx_shd.g_old_rec.information10;
1067: End If;
1068: If (p_rec.information11 = hr_api.g_varchar2) then
1069: p_rec.information11 :=
1070: pqh_ptx_shd.g_old_rec.information11;
1066: pqh_ptx_shd.g_old_rec.information10;
1067: End If;
1068: If (p_rec.information11 = hr_api.g_varchar2) then
1069: p_rec.information11 :=
1070: pqh_ptx_shd.g_old_rec.information11;
1071: End If;
1072: If (p_rec.information12 = hr_api.g_varchar2) then
1073: p_rec.information12 :=
1074: pqh_ptx_shd.g_old_rec.information12;
1070: pqh_ptx_shd.g_old_rec.information11;
1071: End If;
1072: If (p_rec.information12 = hr_api.g_varchar2) then
1073: p_rec.information12 :=
1074: pqh_ptx_shd.g_old_rec.information12;
1075: End If;
1076: If (p_rec.information13 = hr_api.g_varchar2) then
1077: p_rec.information13 :=
1078: pqh_ptx_shd.g_old_rec.information13;
1074: pqh_ptx_shd.g_old_rec.information12;
1075: End If;
1076: If (p_rec.information13 = hr_api.g_varchar2) then
1077: p_rec.information13 :=
1078: pqh_ptx_shd.g_old_rec.information13;
1079: End If;
1080: If (p_rec.information14 = hr_api.g_varchar2) then
1081: p_rec.information14 :=
1082: pqh_ptx_shd.g_old_rec.information14;
1078: pqh_ptx_shd.g_old_rec.information13;
1079: End If;
1080: If (p_rec.information14 = hr_api.g_varchar2) then
1081: p_rec.information14 :=
1082: pqh_ptx_shd.g_old_rec.information14;
1083: End If;
1084: If (p_rec.information15 = hr_api.g_varchar2) then
1085: p_rec.information15 :=
1086: pqh_ptx_shd.g_old_rec.information15;
1082: pqh_ptx_shd.g_old_rec.information14;
1083: End If;
1084: If (p_rec.information15 = hr_api.g_varchar2) then
1085: p_rec.information15 :=
1086: pqh_ptx_shd.g_old_rec.information15;
1087: End If;
1088: If (p_rec.information16 = hr_api.g_varchar2) then
1089: p_rec.information16 :=
1090: pqh_ptx_shd.g_old_rec.information16;
1086: pqh_ptx_shd.g_old_rec.information15;
1087: End If;
1088: If (p_rec.information16 = hr_api.g_varchar2) then
1089: p_rec.information16 :=
1090: pqh_ptx_shd.g_old_rec.information16;
1091: End If;
1092: If (p_rec.information17 = hr_api.g_varchar2) then
1093: p_rec.information17 :=
1094: pqh_ptx_shd.g_old_rec.information17;
1090: pqh_ptx_shd.g_old_rec.information16;
1091: End If;
1092: If (p_rec.information17 = hr_api.g_varchar2) then
1093: p_rec.information17 :=
1094: pqh_ptx_shd.g_old_rec.information17;
1095: End If;
1096: If (p_rec.information18 = hr_api.g_varchar2) then
1097: p_rec.information18 :=
1098: pqh_ptx_shd.g_old_rec.information18;
1094: pqh_ptx_shd.g_old_rec.information17;
1095: End If;
1096: If (p_rec.information18 = hr_api.g_varchar2) then
1097: p_rec.information18 :=
1098: pqh_ptx_shd.g_old_rec.information18;
1099: End If;
1100: If (p_rec.information19 = hr_api.g_varchar2) then
1101: p_rec.information19 :=
1102: pqh_ptx_shd.g_old_rec.information19;
1098: pqh_ptx_shd.g_old_rec.information18;
1099: End If;
1100: If (p_rec.information19 = hr_api.g_varchar2) then
1101: p_rec.information19 :=
1102: pqh_ptx_shd.g_old_rec.information19;
1103: End If;
1104: If (p_rec.information20 = hr_api.g_varchar2) then
1105: p_rec.information20 :=
1106: pqh_ptx_shd.g_old_rec.information20;
1102: pqh_ptx_shd.g_old_rec.information19;
1103: End If;
1104: If (p_rec.information20 = hr_api.g_varchar2) then
1105: p_rec.information20 :=
1106: pqh_ptx_shd.g_old_rec.information20;
1107: End If;
1108: If (p_rec.information21 = hr_api.g_varchar2) then
1109: p_rec.information21 :=
1110: pqh_ptx_shd.g_old_rec.information21;
1106: pqh_ptx_shd.g_old_rec.information20;
1107: End If;
1108: If (p_rec.information21 = hr_api.g_varchar2) then
1109: p_rec.information21 :=
1110: pqh_ptx_shd.g_old_rec.information21;
1111: End If;
1112: If (p_rec.information22 = hr_api.g_varchar2) then
1113: p_rec.information22 :=
1114: pqh_ptx_shd.g_old_rec.information22;
1110: pqh_ptx_shd.g_old_rec.information21;
1111: End If;
1112: If (p_rec.information22 = hr_api.g_varchar2) then
1113: p_rec.information22 :=
1114: pqh_ptx_shd.g_old_rec.information22;
1115: End If;
1116: If (p_rec.information23 = hr_api.g_varchar2) then
1117: p_rec.information23 :=
1118: pqh_ptx_shd.g_old_rec.information23;
1114: pqh_ptx_shd.g_old_rec.information22;
1115: End If;
1116: If (p_rec.information23 = hr_api.g_varchar2) then
1117: p_rec.information23 :=
1118: pqh_ptx_shd.g_old_rec.information23;
1119: End If;
1120: If (p_rec.information24 = hr_api.g_varchar2) then
1121: p_rec.information24 :=
1122: pqh_ptx_shd.g_old_rec.information24;
1118: pqh_ptx_shd.g_old_rec.information23;
1119: End If;
1120: If (p_rec.information24 = hr_api.g_varchar2) then
1121: p_rec.information24 :=
1122: pqh_ptx_shd.g_old_rec.information24;
1123: End If;
1124: If (p_rec.information25 = hr_api.g_varchar2) then
1125: p_rec.information25 :=
1126: pqh_ptx_shd.g_old_rec.information25;
1122: pqh_ptx_shd.g_old_rec.information24;
1123: End If;
1124: If (p_rec.information25 = hr_api.g_varchar2) then
1125: p_rec.information25 :=
1126: pqh_ptx_shd.g_old_rec.information25;
1127: End If;
1128: If (p_rec.information26 = hr_api.g_varchar2) then
1129: p_rec.information26 :=
1130: pqh_ptx_shd.g_old_rec.information26;
1126: pqh_ptx_shd.g_old_rec.information25;
1127: End If;
1128: If (p_rec.information26 = hr_api.g_varchar2) then
1129: p_rec.information26 :=
1130: pqh_ptx_shd.g_old_rec.information26;
1131: End If;
1132: If (p_rec.information27 = hr_api.g_varchar2) then
1133: p_rec.information27 :=
1134: pqh_ptx_shd.g_old_rec.information27;
1130: pqh_ptx_shd.g_old_rec.information26;
1131: End If;
1132: If (p_rec.information27 = hr_api.g_varchar2) then
1133: p_rec.information27 :=
1134: pqh_ptx_shd.g_old_rec.information27;
1135: End If;
1136: If (p_rec.information28 = hr_api.g_varchar2) then
1137: p_rec.information28 :=
1138: pqh_ptx_shd.g_old_rec.information28;
1134: pqh_ptx_shd.g_old_rec.information27;
1135: End If;
1136: If (p_rec.information28 = hr_api.g_varchar2) then
1137: p_rec.information28 :=
1138: pqh_ptx_shd.g_old_rec.information28;
1139: End If;
1140: If (p_rec.information29 = hr_api.g_varchar2) then
1141: p_rec.information29 :=
1142: pqh_ptx_shd.g_old_rec.information29;
1138: pqh_ptx_shd.g_old_rec.information28;
1139: End If;
1140: If (p_rec.information29 = hr_api.g_varchar2) then
1141: p_rec.information29 :=
1142: pqh_ptx_shd.g_old_rec.information29;
1143: End If;
1144: If (p_rec.information30 = hr_api.g_varchar2) then
1145: p_rec.information30 :=
1146: pqh_ptx_shd.g_old_rec.information30;
1142: pqh_ptx_shd.g_old_rec.information29;
1143: End If;
1144: If (p_rec.information30 = hr_api.g_varchar2) then
1145: p_rec.information30 :=
1146: pqh_ptx_shd.g_old_rec.information30;
1147: End If;
1148: If (p_rec.information_category = hr_api.g_varchar2) then
1149: p_rec.information_category :=
1150: pqh_ptx_shd.g_old_rec.information_category;
1146: pqh_ptx_shd.g_old_rec.information30;
1147: End If;
1148: If (p_rec.information_category = hr_api.g_varchar2) then
1149: p_rec.information_category :=
1150: pqh_ptx_shd.g_old_rec.information_category;
1151: End If;
1152: If (p_rec.attribute1 = hr_api.g_varchar2) then
1153: p_rec.attribute1 :=
1154: pqh_ptx_shd.g_old_rec.attribute1;
1150: pqh_ptx_shd.g_old_rec.information_category;
1151: End If;
1152: If (p_rec.attribute1 = hr_api.g_varchar2) then
1153: p_rec.attribute1 :=
1154: pqh_ptx_shd.g_old_rec.attribute1;
1155: End If;
1156: If (p_rec.attribute2 = hr_api.g_varchar2) then
1157: p_rec.attribute2 :=
1158: pqh_ptx_shd.g_old_rec.attribute2;
1154: pqh_ptx_shd.g_old_rec.attribute1;
1155: End If;
1156: If (p_rec.attribute2 = hr_api.g_varchar2) then
1157: p_rec.attribute2 :=
1158: pqh_ptx_shd.g_old_rec.attribute2;
1159: End If;
1160: If (p_rec.attribute3 = hr_api.g_varchar2) then
1161: p_rec.attribute3 :=
1162: pqh_ptx_shd.g_old_rec.attribute3;
1158: pqh_ptx_shd.g_old_rec.attribute2;
1159: End If;
1160: If (p_rec.attribute3 = hr_api.g_varchar2) then
1161: p_rec.attribute3 :=
1162: pqh_ptx_shd.g_old_rec.attribute3;
1163: End If;
1164: If (p_rec.attribute4 = hr_api.g_varchar2) then
1165: p_rec.attribute4 :=
1166: pqh_ptx_shd.g_old_rec.attribute4;
1162: pqh_ptx_shd.g_old_rec.attribute3;
1163: End If;
1164: If (p_rec.attribute4 = hr_api.g_varchar2) then
1165: p_rec.attribute4 :=
1166: pqh_ptx_shd.g_old_rec.attribute4;
1167: End If;
1168: If (p_rec.attribute5 = hr_api.g_varchar2) then
1169: p_rec.attribute5 :=
1170: pqh_ptx_shd.g_old_rec.attribute5;
1166: pqh_ptx_shd.g_old_rec.attribute4;
1167: End If;
1168: If (p_rec.attribute5 = hr_api.g_varchar2) then
1169: p_rec.attribute5 :=
1170: pqh_ptx_shd.g_old_rec.attribute5;
1171: End If;
1172: If (p_rec.attribute6 = hr_api.g_varchar2) then
1173: p_rec.attribute6 :=
1174: pqh_ptx_shd.g_old_rec.attribute6;
1170: pqh_ptx_shd.g_old_rec.attribute5;
1171: End If;
1172: If (p_rec.attribute6 = hr_api.g_varchar2) then
1173: p_rec.attribute6 :=
1174: pqh_ptx_shd.g_old_rec.attribute6;
1175: End If;
1176: If (p_rec.attribute7 = hr_api.g_varchar2) then
1177: p_rec.attribute7 :=
1178: pqh_ptx_shd.g_old_rec.attribute7;
1174: pqh_ptx_shd.g_old_rec.attribute6;
1175: End If;
1176: If (p_rec.attribute7 = hr_api.g_varchar2) then
1177: p_rec.attribute7 :=
1178: pqh_ptx_shd.g_old_rec.attribute7;
1179: End If;
1180: If (p_rec.attribute8 = hr_api.g_varchar2) then
1181: p_rec.attribute8 :=
1182: pqh_ptx_shd.g_old_rec.attribute8;
1178: pqh_ptx_shd.g_old_rec.attribute7;
1179: End If;
1180: If (p_rec.attribute8 = hr_api.g_varchar2) then
1181: p_rec.attribute8 :=
1182: pqh_ptx_shd.g_old_rec.attribute8;
1183: End If;
1184: If (p_rec.attribute9 = hr_api.g_varchar2) then
1185: p_rec.attribute9 :=
1186: pqh_ptx_shd.g_old_rec.attribute9;
1182: pqh_ptx_shd.g_old_rec.attribute8;
1183: End If;
1184: If (p_rec.attribute9 = hr_api.g_varchar2) then
1185: p_rec.attribute9 :=
1186: pqh_ptx_shd.g_old_rec.attribute9;
1187: End If;
1188: If (p_rec.attribute10 = hr_api.g_varchar2) then
1189: p_rec.attribute10 :=
1190: pqh_ptx_shd.g_old_rec.attribute10;
1186: pqh_ptx_shd.g_old_rec.attribute9;
1187: End If;
1188: If (p_rec.attribute10 = hr_api.g_varchar2) then
1189: p_rec.attribute10 :=
1190: pqh_ptx_shd.g_old_rec.attribute10;
1191: End If;
1192: If (p_rec.attribute11 = hr_api.g_varchar2) then
1193: p_rec.attribute11 :=
1194: pqh_ptx_shd.g_old_rec.attribute11;
1190: pqh_ptx_shd.g_old_rec.attribute10;
1191: End If;
1192: If (p_rec.attribute11 = hr_api.g_varchar2) then
1193: p_rec.attribute11 :=
1194: pqh_ptx_shd.g_old_rec.attribute11;
1195: End If;
1196: If (p_rec.attribute12 = hr_api.g_varchar2) then
1197: p_rec.attribute12 :=
1198: pqh_ptx_shd.g_old_rec.attribute12;
1194: pqh_ptx_shd.g_old_rec.attribute11;
1195: End If;
1196: If (p_rec.attribute12 = hr_api.g_varchar2) then
1197: p_rec.attribute12 :=
1198: pqh_ptx_shd.g_old_rec.attribute12;
1199: End If;
1200: If (p_rec.attribute13 = hr_api.g_varchar2) then
1201: p_rec.attribute13 :=
1202: pqh_ptx_shd.g_old_rec.attribute13;
1198: pqh_ptx_shd.g_old_rec.attribute12;
1199: End If;
1200: If (p_rec.attribute13 = hr_api.g_varchar2) then
1201: p_rec.attribute13 :=
1202: pqh_ptx_shd.g_old_rec.attribute13;
1203: End If;
1204: If (p_rec.attribute14 = hr_api.g_varchar2) then
1205: p_rec.attribute14 :=
1206: pqh_ptx_shd.g_old_rec.attribute14;
1202: pqh_ptx_shd.g_old_rec.attribute13;
1203: End If;
1204: If (p_rec.attribute14 = hr_api.g_varchar2) then
1205: p_rec.attribute14 :=
1206: pqh_ptx_shd.g_old_rec.attribute14;
1207: End If;
1208: If (p_rec.attribute15 = hr_api.g_varchar2) then
1209: p_rec.attribute15 :=
1210: pqh_ptx_shd.g_old_rec.attribute15;
1206: pqh_ptx_shd.g_old_rec.attribute14;
1207: End If;
1208: If (p_rec.attribute15 = hr_api.g_varchar2) then
1209: p_rec.attribute15 :=
1210: pqh_ptx_shd.g_old_rec.attribute15;
1211: End If;
1212: If (p_rec.attribute16 = hr_api.g_varchar2) then
1213: p_rec.attribute16 :=
1214: pqh_ptx_shd.g_old_rec.attribute16;
1210: pqh_ptx_shd.g_old_rec.attribute15;
1211: End If;
1212: If (p_rec.attribute16 = hr_api.g_varchar2) then
1213: p_rec.attribute16 :=
1214: pqh_ptx_shd.g_old_rec.attribute16;
1215: End If;
1216: If (p_rec.attribute17 = hr_api.g_varchar2) then
1217: p_rec.attribute17 :=
1218: pqh_ptx_shd.g_old_rec.attribute17;
1214: pqh_ptx_shd.g_old_rec.attribute16;
1215: End If;
1216: If (p_rec.attribute17 = hr_api.g_varchar2) then
1217: p_rec.attribute17 :=
1218: pqh_ptx_shd.g_old_rec.attribute17;
1219: End If;
1220: If (p_rec.attribute18 = hr_api.g_varchar2) then
1221: p_rec.attribute18 :=
1222: pqh_ptx_shd.g_old_rec.attribute18;
1218: pqh_ptx_shd.g_old_rec.attribute17;
1219: End If;
1220: If (p_rec.attribute18 = hr_api.g_varchar2) then
1221: p_rec.attribute18 :=
1222: pqh_ptx_shd.g_old_rec.attribute18;
1223: End If;
1224: If (p_rec.attribute19 = hr_api.g_varchar2) then
1225: p_rec.attribute19 :=
1226: pqh_ptx_shd.g_old_rec.attribute19;
1222: pqh_ptx_shd.g_old_rec.attribute18;
1223: End If;
1224: If (p_rec.attribute19 = hr_api.g_varchar2) then
1225: p_rec.attribute19 :=
1226: pqh_ptx_shd.g_old_rec.attribute19;
1227: End If;
1228: If (p_rec.attribute20 = hr_api.g_varchar2) then
1229: p_rec.attribute20 :=
1230: pqh_ptx_shd.g_old_rec.attribute20;
1226: pqh_ptx_shd.g_old_rec.attribute19;
1227: End If;
1228: If (p_rec.attribute20 = hr_api.g_varchar2) then
1229: p_rec.attribute20 :=
1230: pqh_ptx_shd.g_old_rec.attribute20;
1231: End If;
1232: If (p_rec.attribute21 = hr_api.g_varchar2) then
1233: p_rec.attribute21 :=
1234: pqh_ptx_shd.g_old_rec.attribute21;
1230: pqh_ptx_shd.g_old_rec.attribute20;
1231: End If;
1232: If (p_rec.attribute21 = hr_api.g_varchar2) then
1233: p_rec.attribute21 :=
1234: pqh_ptx_shd.g_old_rec.attribute21;
1235: End If;
1236: If (p_rec.attribute22 = hr_api.g_varchar2) then
1237: p_rec.attribute22 :=
1238: pqh_ptx_shd.g_old_rec.attribute22;
1234: pqh_ptx_shd.g_old_rec.attribute21;
1235: End If;
1236: If (p_rec.attribute22 = hr_api.g_varchar2) then
1237: p_rec.attribute22 :=
1238: pqh_ptx_shd.g_old_rec.attribute22;
1239: End If;
1240: If (p_rec.attribute23 = hr_api.g_varchar2) then
1241: p_rec.attribute23 :=
1242: pqh_ptx_shd.g_old_rec.attribute23;
1238: pqh_ptx_shd.g_old_rec.attribute22;
1239: End If;
1240: If (p_rec.attribute23 = hr_api.g_varchar2) then
1241: p_rec.attribute23 :=
1242: pqh_ptx_shd.g_old_rec.attribute23;
1243: End If;
1244: If (p_rec.attribute24 = hr_api.g_varchar2) then
1245: p_rec.attribute24 :=
1246: pqh_ptx_shd.g_old_rec.attribute24;
1242: pqh_ptx_shd.g_old_rec.attribute23;
1243: End If;
1244: If (p_rec.attribute24 = hr_api.g_varchar2) then
1245: p_rec.attribute24 :=
1246: pqh_ptx_shd.g_old_rec.attribute24;
1247: End If;
1248: If (p_rec.attribute25 = hr_api.g_varchar2) then
1249: p_rec.attribute25 :=
1250: pqh_ptx_shd.g_old_rec.attribute25;
1246: pqh_ptx_shd.g_old_rec.attribute24;
1247: End If;
1248: If (p_rec.attribute25 = hr_api.g_varchar2) then
1249: p_rec.attribute25 :=
1250: pqh_ptx_shd.g_old_rec.attribute25;
1251: End If;
1252: If (p_rec.attribute26 = hr_api.g_varchar2) then
1253: p_rec.attribute26 :=
1254: pqh_ptx_shd.g_old_rec.attribute26;
1250: pqh_ptx_shd.g_old_rec.attribute25;
1251: End If;
1252: If (p_rec.attribute26 = hr_api.g_varchar2) then
1253: p_rec.attribute26 :=
1254: pqh_ptx_shd.g_old_rec.attribute26;
1255: End If;
1256: If (p_rec.attribute27 = hr_api.g_varchar2) then
1257: p_rec.attribute27 :=
1258: pqh_ptx_shd.g_old_rec.attribute27;
1254: pqh_ptx_shd.g_old_rec.attribute26;
1255: End If;
1256: If (p_rec.attribute27 = hr_api.g_varchar2) then
1257: p_rec.attribute27 :=
1258: pqh_ptx_shd.g_old_rec.attribute27;
1259: End If;
1260: If (p_rec.attribute28 = hr_api.g_varchar2) then
1261: p_rec.attribute28 :=
1262: pqh_ptx_shd.g_old_rec.attribute28;
1258: pqh_ptx_shd.g_old_rec.attribute27;
1259: End If;
1260: If (p_rec.attribute28 = hr_api.g_varchar2) then
1261: p_rec.attribute28 :=
1262: pqh_ptx_shd.g_old_rec.attribute28;
1263: End If;
1264: If (p_rec.attribute29 = hr_api.g_varchar2) then
1265: p_rec.attribute29 :=
1266: pqh_ptx_shd.g_old_rec.attribute29;
1262: pqh_ptx_shd.g_old_rec.attribute28;
1263: End If;
1264: If (p_rec.attribute29 = hr_api.g_varchar2) then
1265: p_rec.attribute29 :=
1266: pqh_ptx_shd.g_old_rec.attribute29;
1267: End If;
1268: If (p_rec.attribute30 = hr_api.g_varchar2) then
1269: p_rec.attribute30 :=
1270: pqh_ptx_shd.g_old_rec.attribute30;
1266: pqh_ptx_shd.g_old_rec.attribute29;
1267: End If;
1268: If (p_rec.attribute30 = hr_api.g_varchar2) then
1269: p_rec.attribute30 :=
1270: pqh_ptx_shd.g_old_rec.attribute30;
1271: End If;
1272: If (p_rec.attribute_category = hr_api.g_varchar2) then
1273: p_rec.attribute_category :=
1274: pqh_ptx_shd.g_old_rec.attribute_category;
1270: pqh_ptx_shd.g_old_rec.attribute30;
1271: End If;
1272: If (p_rec.attribute_category = hr_api.g_varchar2) then
1273: p_rec.attribute_category :=
1274: pqh_ptx_shd.g_old_rec.attribute_category;
1275: End If;
1276: If (p_rec.pay_basis_id = hr_api.g_number) then
1277: p_rec.pay_basis_id :=
1278: pqh_ptx_shd.g_old_rec.pay_basis_id;
1274: pqh_ptx_shd.g_old_rec.attribute_category;
1275: End If;
1276: If (p_rec.pay_basis_id = hr_api.g_number) then
1277: p_rec.pay_basis_id :=
1278: pqh_ptx_shd.g_old_rec.pay_basis_id;
1279: End If;
1280: If (p_rec.supervisor_id = hr_api.g_number) then
1281: p_rec.supervisor_id :=
1282: pqh_ptx_shd.g_old_rec.supervisor_id;
1278: pqh_ptx_shd.g_old_rec.pay_basis_id;
1279: End If;
1280: If (p_rec.supervisor_id = hr_api.g_number) then
1281: p_rec.supervisor_id :=
1282: pqh_ptx_shd.g_old_rec.supervisor_id;
1283: End If;
1284: If (p_rec.wf_transaction_category_id = hr_api.g_number) then
1285: p_rec.wf_transaction_category_id :=
1286: pqh_ptx_shd.g_old_rec.wf_transaction_category_id;
1282: pqh_ptx_shd.g_old_rec.supervisor_id;
1283: End If;
1284: If (p_rec.wf_transaction_category_id = hr_api.g_number) then
1285: p_rec.wf_transaction_category_id :=
1286: pqh_ptx_shd.g_old_rec.wf_transaction_category_id;
1287: End If;
1288:
1289: --
1290: hr_utility.set_location(' Leaving:'||l_proc, 10);
1296: -- ----------------------------------------------------------------------------
1297: Procedure upd
1298: (
1299: p_effective_date in date,
1300: p_rec in out nocopy pqh_ptx_shd.g_rec_type
1301: ) is
1302: --
1303: l_proc varchar2(72) := g_package||'upd';
1304: --
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: -- We must lock the row which we need to update.
1309: --
1310: pqh_ptx_shd.lck
1311: (
1312: p_rec.position_transaction_id,
1313: p_rec.object_version_number
1314: );
1486: p_supervisor_id in number default hr_api.g_number,
1487: p_wf_transaction_category_id in number default hr_api.g_number
1488: ) is
1489: --
1490: l_rec pqh_ptx_shd.g_rec_type;
1491: l_proc varchar2(72) := g_package||'upd';
1492: --
1493: Begin
1494: hr_utility.set_location('Entering:'||l_proc, 5);
1496: -- Call conversion function to turn arguments into the
1497: -- l_rec structure.
1498: --
1499: l_rec :=
1500: pqh_ptx_shd.convert_args
1501: (
1502: p_position_transaction_id,
1503: p_action_date,
1504: p_position_id,