eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PTX_UPD dependencies on PQH_PTX_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is

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

Line 214: pqh_ptx_shd.constraint_error

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

Line 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

Line 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;

Line 260: Procedure pre_update(p_rec in pqh_ptx_shd.g_rec_type) is

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

Line 303: p_effective_date in date,p_rec in pqh_ptx_shd.g_rec_type) is

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;

Line 338: and nvl(pqh_ptx_shd.g_old_rec.review_flag,'N') = 'N')then

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')

Line 513: ,p_action_date_o =>pqh_ptx_shd.g_old_rec.action_date

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

Line 514: ,p_position_id_o =>pqh_ptx_shd.g_old_rec.position_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

Line 515: ,p_availability_status_id_o =>pqh_ptx_shd.g_old_rec.availability_status_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

Line 516: ,p_business_group_id_o =>pqh_ptx_shd.g_old_rec.business_group_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

Line 517: ,p_entry_step_id_o =>pqh_ptx_shd.g_old_rec.entry_step_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

Line 518: ,p_entry_grade_rule_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_rule_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

Line 519: ,p_job_id_o =>pqh_ptx_shd.g_old_rec.job_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

Line 520: ,p_location_id_o =>pqh_ptx_shd.g_old_rec.location_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

Line 521: ,p_organization_id_o =>pqh_ptx_shd.g_old_rec.organization_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

Line 522: ,p_pay_freq_payroll_id_o =>pqh_ptx_shd.g_old_rec.pay_freq_payroll_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

Line 523: ,p_position_definition_id_o =>pqh_ptx_shd.g_old_rec.position_definition_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

Line 524: ,p_prior_position_id_o =>pqh_ptx_shd.g_old_rec.prior_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

Line 525: ,p_relief_position_id_o =>pqh_ptx_shd.g_old_rec.relief_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

Line 526: ,p_entry_grade_id_o =>pqh_ptx_shd.g_old_rec.entry_grade_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
530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation

Line 527: ,p_successor_position_id_o =>pqh_ptx_shd.g_old_rec.successor_position_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
531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number

Line 528: ,p_supervisor_position_id_o =>pqh_ptx_shd.g_old_rec.supervisor_position_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
532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date

Line 529: ,p_amendment_date_o =>pqh_ptx_shd.g_old_rec.amendment_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

Line 530: ,p_amendment_recommendation_o =>pqh_ptx_shd.g_old_rec.amendment_recommendation

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

Line 531: ,p_amendment_ref_number_o =>pqh_ptx_shd.g_old_rec.amendment_ref_number

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

Line 532: ,p_avail_status_prop_end_date_o =>pqh_ptx_shd.g_old_rec.avail_status_prop_end_date

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

Line 533: ,p_bargaining_unit_cd_o =>pqh_ptx_shd.g_old_rec.bargaining_unit_cd

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

Line 534: ,p_comments_o =>pqh_ptx_shd.g_old_rec.comments

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

Line 535: ,p_country1_o =>pqh_ptx_shd.g_old_rec.country1

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

Line 536: ,p_country2_o =>pqh_ptx_shd.g_old_rec.country2

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

Line 537: ,p_country3_o =>pqh_ptx_shd.g_old_rec.country3

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

Line 538: ,p_current_job_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_job_prop_end_date

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

Line 539: ,p_current_org_prop_end_date_o =>pqh_ptx_shd.g_old_rec.current_org_prop_end_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

Line 540: ,p_date_effective_o =>pqh_ptx_shd.g_old_rec.date_effective

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

Line 541: ,p_date_end_o =>pqh_ptx_shd.g_old_rec.date_end

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

Line 542: ,p_earliest_hire_date_o =>pqh_ptx_shd.g_old_rec.earliest_hire_date

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

Line 543: ,p_fill_by_date_o =>pqh_ptx_shd.g_old_rec.fill_by_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
547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1

Line 544: ,p_frequency_o =>pqh_ptx_shd.g_old_rec.frequency

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

Line 545: ,p_fte_o =>pqh_ptx_shd.g_old_rec.fte

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

Line 546: ,p_fte_capacity_o =>pqh_ptx_shd.g_old_rec.fte_capacity

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

Line 547: ,p_location1_o =>pqh_ptx_shd.g_old_rec.location1

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

Line 548: ,p_location2_o =>pqh_ptx_shd.g_old_rec.location2

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

Line 549: ,p_location3_o =>pqh_ptx_shd.g_old_rec.location3

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

Line 550: ,p_max_persons_o =>pqh_ptx_shd.g_old_rec.max_persons

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

Line 551: ,p_name_o =>pqh_ptx_shd.g_old_rec.name

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

Line 552: ,p_other_requirements_o =>pqh_ptx_shd.g_old_rec.other_requirements

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

Line 553: ,p_overlap_period_o =>pqh_ptx_shd.g_old_rec.overlap_period

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

Line 554: ,p_overlap_unit_cd_o =>pqh_ptx_shd.g_old_rec.overlap_unit_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

Line 555: ,p_passport_required_o =>pqh_ptx_shd.g_old_rec.passport_required

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

Line 556: ,p_pay_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_day_cd

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

Line 557: ,p_pay_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.pay_term_end_month_cd

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

Line 558: ,p_permanent_temporary_flag_o =>pqh_ptx_shd.g_old_rec.permanent_temporary_flag

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

Line 559: ,p_permit_recruitment_flag_o =>pqh_ptx_shd.g_old_rec.permit_recruitment_flag

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

Line 560: ,p_position_type_o =>pqh_ptx_shd.g_old_rec.position_type

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

Line 561: ,p_posting_description_o =>pqh_ptx_shd.g_old_rec.posting_description

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

Line 562: ,p_probation_period_o =>pqh_ptx_shd.g_old_rec.probation_period

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

Line 563: ,p_probation_period_unit_cd_o =>pqh_ptx_shd.g_old_rec.probation_period_unit_cd

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

Line 564: ,p_relocate_domestically_o =>pqh_ptx_shd.g_old_rec.relocate_domestically

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

Line 565: ,p_relocate_internationally_o =>pqh_ptx_shd.g_old_rec.relocate_internationally

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

Line 566: ,p_replacement_required_flag_o =>pqh_ptx_shd.g_old_rec.replacement_required_flag

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

Line 567: ,p_review_flag_o =>pqh_ptx_shd.g_old_rec.review_flag

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

Line 568: ,p_seasonal_flag_o =>pqh_ptx_shd.g_old_rec.seasonal_flag

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

Line 569: ,p_security_requirements_o =>pqh_ptx_shd.g_old_rec.security_requirements

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

Line 570: ,p_service_minimum_o =>pqh_ptx_shd.g_old_rec.service_minimum

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

Line 571: ,p_term_start_day_cd_o =>pqh_ptx_shd.g_old_rec.term_start_day_cd

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

Line 572: ,p_term_start_month_cd_o =>pqh_ptx_shd.g_old_rec.term_start_month_cd

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

Line 573: ,p_time_normal_finish_o =>pqh_ptx_shd.g_old_rec.time_normal_finish

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

Line 574: ,p_time_normal_start_o =>pqh_ptx_shd.g_old_rec.time_normal_start

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

Line 575: ,p_transaction_status_o =>pqh_ptx_shd.g_old_rec.transaction_status

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

Line 576: ,p_travel_required_o =>pqh_ptx_shd.g_old_rec.travel_required

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

Line 577: ,p_working_hours_o =>pqh_ptx_shd.g_old_rec.working_hours

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

Line 578: ,p_works_council_approval_fla_o =>pqh_ptx_shd.g_old_rec.works_council_approval_flag

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

Line 579: ,p_work_any_country_o =>pqh_ptx_shd.g_old_rec.work_any_country

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

Line 580: ,p_work_any_location_o =>pqh_ptx_shd.g_old_rec.work_any_location

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

Line 581: ,p_work_period_type_cd_o =>pqh_ptx_shd.g_old_rec.work_period_type_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

Line 582: ,p_work_schedule_o =>pqh_ptx_shd.g_old_rec.work_schedule

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

Line 583: ,p_work_duration_o =>pqh_ptx_shd.g_old_rec.work_duration

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

Line 584: ,p_work_term_end_day_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_day_cd

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

Line 585: ,p_work_term_end_month_cd_o =>pqh_ptx_shd.g_old_rec.work_term_end_month_cd

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

Line 586: ,p_proposed_fte_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_fte_for_layoff

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

Line 587: ,p_proposed_date_for_layoff_o =>pqh_ptx_shd.g_old_rec.proposed_date_for_layoff

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

Line 588: ,p_information1_o =>pqh_ptx_shd.g_old_rec.information1

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

Line 589: ,p_information2_o =>pqh_ptx_shd.g_old_rec.information2

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

Line 590: ,p_information3_o =>pqh_ptx_shd.g_old_rec.information3

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

Line 591: ,p_information4_o =>pqh_ptx_shd.g_old_rec.information4

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

Line 592: ,p_information5_o =>pqh_ptx_shd.g_old_rec.information5

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

Line 593: ,p_information6_o =>pqh_ptx_shd.g_old_rec.information6

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

Line 594: ,p_information7_o =>pqh_ptx_shd.g_old_rec.information7

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

Line 595: ,p_information8_o =>pqh_ptx_shd.g_old_rec.information8

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

Line 596: ,p_information9_o =>pqh_ptx_shd.g_old_rec.information9

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

Line 597: ,p_information10_o =>pqh_ptx_shd.g_old_rec.information10

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

Line 598: ,p_information11_o =>pqh_ptx_shd.g_old_rec.information11

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

Line 599: ,p_information12_o =>pqh_ptx_shd.g_old_rec.information12

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

Line 600: ,p_information13_o =>pqh_ptx_shd.g_old_rec.information13

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

Line 601: ,p_information14_o =>pqh_ptx_shd.g_old_rec.information14

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

Line 602: ,p_information15_o =>pqh_ptx_shd.g_old_rec.information15

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

Line 603: ,p_information16_o =>pqh_ptx_shd.g_old_rec.information16

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

Line 604: ,p_information17_o =>pqh_ptx_shd.g_old_rec.information17

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

Line 605: ,p_information18_o =>pqh_ptx_shd.g_old_rec.information18

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

Line 606: ,p_information19_o =>pqh_ptx_shd.g_old_rec.information19

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

Line 607: ,p_information20_o =>pqh_ptx_shd.g_old_rec.information20

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

Line 608: ,p_information21_o =>pqh_ptx_shd.g_old_rec.information21

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

Line 609: ,p_information22_o =>pqh_ptx_shd.g_old_rec.information22

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

Line 610: ,p_information23_o =>pqh_ptx_shd.g_old_rec.information23

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

Line 611: ,p_information24_o =>pqh_ptx_shd.g_old_rec.information24

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

Line 612: ,p_information25_o =>pqh_ptx_shd.g_old_rec.information25

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

Line 613: ,p_information26_o =>pqh_ptx_shd.g_old_rec.information26

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

Line 614: ,p_information27_o =>pqh_ptx_shd.g_old_rec.information27

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

Line 615: ,p_information28_o =>pqh_ptx_shd.g_old_rec.information28

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

Line 616: ,p_information29_o =>pqh_ptx_shd.g_old_rec.information29

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

Line 617: ,p_information30_o =>pqh_ptx_shd.g_old_rec.information30

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

Line 618: ,p_information_category_o =>pqh_ptx_shd.g_old_rec.information_category

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

Line 619: ,p_attribute1_o =>pqh_ptx_shd.g_old_rec.attribute1

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

Line 620: ,p_attribute2_o =>pqh_ptx_shd.g_old_rec.attribute2

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

Line 621: ,p_attribute3_o =>pqh_ptx_shd.g_old_rec.attribute3

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

Line 622: ,p_attribute4_o =>pqh_ptx_shd.g_old_rec.attribute4

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

Line 623: ,p_attribute5_o =>pqh_ptx_shd.g_old_rec.attribute5

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

Line 624: ,p_attribute6_o =>pqh_ptx_shd.g_old_rec.attribute6

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

Line 625: ,p_attribute7_o =>pqh_ptx_shd.g_old_rec.attribute7

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

Line 626: ,p_attribute8_o =>pqh_ptx_shd.g_old_rec.attribute8

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

Line 627: ,p_attribute9_o =>pqh_ptx_shd.g_old_rec.attribute9

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

Line 628: ,p_attribute10_o =>pqh_ptx_shd.g_old_rec.attribute10

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

Line 629: ,p_attribute11_o =>pqh_ptx_shd.g_old_rec.attribute11

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

Line 630: ,p_attribute12_o =>pqh_ptx_shd.g_old_rec.attribute12

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

Line 631: ,p_attribute13_o =>pqh_ptx_shd.g_old_rec.attribute13

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

Line 632: ,p_attribute14_o =>pqh_ptx_shd.g_old_rec.attribute14

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

Line 633: ,p_attribute15_o =>pqh_ptx_shd.g_old_rec.attribute15

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

Line 634: ,p_attribute16_o =>pqh_ptx_shd.g_old_rec.attribute16

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

Line 635: ,p_attribute17_o =>pqh_ptx_shd.g_old_rec.attribute17

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

Line 636: ,p_attribute18_o =>pqh_ptx_shd.g_old_rec.attribute18

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

Line 637: ,p_attribute19_o =>pqh_ptx_shd.g_old_rec.attribute19

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

Line 638: ,p_attribute20_o =>pqh_ptx_shd.g_old_rec.attribute20

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

Line 639: ,p_attribute21_o =>pqh_ptx_shd.g_old_rec.attribute21

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

Line 640: ,p_attribute22_o =>pqh_ptx_shd.g_old_rec.attribute22

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

Line 641: ,p_attribute23_o =>pqh_ptx_shd.g_old_rec.attribute23

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

Line 642: ,p_attribute24_o =>pqh_ptx_shd.g_old_rec.attribute24

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

Line 643: ,p_attribute25_o =>pqh_ptx_shd.g_old_rec.attribute25

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

Line 644: ,p_attribute26_o =>pqh_ptx_shd.g_old_rec.attribute26

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

Line 645: ,p_attribute27_o =>pqh_ptx_shd.g_old_rec.attribute27

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

Line 646: ,p_attribute28_o =>pqh_ptx_shd.g_old_rec.attribute28

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

Line 647: ,p_attribute29_o =>pqh_ptx_shd.g_old_rec.attribute29

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

Line 648: ,p_attribute30_o =>pqh_ptx_shd.g_old_rec.attribute30

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

Line 649: ,p_attribute_category_o =>pqh_ptx_shd.g_old_rec.attribute_category

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

Line 650: ,p_object_version_number_o =>pqh_ptx_shd.g_old_rec.object_version_number

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: );

Line 651: ,p_pay_basis_id_o =>pqh_ptx_shd.g_old_rec.pay_basis_id

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: --

Line 652: ,p_supervisor_id_o =>pqh_ptx_shd.g_old_rec.supervisor_id

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

Line 653: ,p_wf_transaction_category_id_o =>pqh_ptx_shd.g_old_rec.wf_transaction_category_id

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: --

Line 715: Procedure convert_defs(p_rec in out nocopy pqh_ptx_shd.g_rec_type) is

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

Line 730: pqh_ptx_shd.g_old_rec.action_date;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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);

Line 1300: p_rec in out nocopy pqh_ptx_shd.g_rec_type

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: --

Line 1310: pqh_ptx_shd.lck

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: );

Line 1490: l_rec pqh_ptx_shd.g_rec_type;

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);

Line 1500: pqh_ptx_shd.convert_args

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,