DBA Data[Home] [Help]

APPS.GHR_HISTORY_CONV_RG dependencies on HR_ALL_POSITIONS_F

Line 4542: -- to the hr_all_positions_f type record.

4538:
4539: */
4540:
4541: -- Procedure conv_to_position_rg. Copies the individual fields supplied as parameters
4542: -- to the hr_all_positions_f type record.
4543: Procedure conv_to_position_rg(
4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,

Line 4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,

4540:
4541: -- Procedure conv_to_position_rg. Copies the individual fields supplied as parameters
4542: -- to the hr_all_positions_f type record.
4543: Procedure conv_to_position_rg(
4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,

Line 4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,

4541: -- Procedure conv_to_position_rg. Copies the individual fields supplied as parameters
4542: -- to the hr_all_positions_f type record.
4543: Procedure conv_to_position_rg(
4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,

Line 4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,

4542: -- to the hr_all_positions_f type record.
4543: Procedure conv_to_position_rg(
4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,

Line 4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,

4543: Procedure conv_to_position_rg(
4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,

Line 4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,

4544: p_position_id in hr_all_positions_f.position_id%TYPE default NULL,
4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,

Line 4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,

4545: p_effective_start_date in hr_all_positions_f.effective_start_date%TYPE default NULL,
4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,

Line 4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,

4546: p_effective_end_date in hr_all_positions_f.effective_end_date%TYPE default NULL,
4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,

Line 4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,

4547: p_availability_status_id in hr_all_positions_f.availability_status_id%TYPE default NULL,
4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,

Line 4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,

4548: p_business_group_id in hr_all_positions_f.business_group_id%TYPE default NULL,
4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,

Line 4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,

4549: p_entry_step_id in hr_all_positions_f.entry_step_id%TYPE default NULL,
4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,

Line 4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,

4550: p_job_id in hr_all_positions_f.job_id%TYPE default NULL,
4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,

Line 4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,

4551: p_location_id in hr_all_positions_f.location_id%TYPE default NULL,
4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,

Line 4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,

4552: p_organization_id in hr_all_positions_f.organization_id%TYPE default NULL,
4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,

Line 4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,

4553: p_pay_freq_payroll_id in hr_all_positions_f.pay_freq_payroll_id%TYPE default NULL,
4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,

Line 4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,

4554: p_position_definition_id in hr_all_positions_f.position_definition_id%TYPE default NULL,
4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,

Line 4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,

4555: p_position_transaction_id in hr_all_positions_f.position_transaction_id%TYPE default NULL,
4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,

Line 4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,

4556: p_prior_position_id in hr_all_positions_f.prior_position_id%TYPE default NULL,
4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,

Line 4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,

4557: p_relief_position_id in hr_all_positions_f.relief_position_id%TYPE default NULL,
4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,

Line 4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,

4558: p_successor_position_id in hr_all_positions_f.successor_position_id%TYPE default NULL,
4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,

Line 4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,

4559: p_supervisor_position_id in hr_all_positions_f.supervisor_position_id%TYPE default NULL,
4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,

Line 4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,

4560: p_amendment_date in hr_all_positions_f.amendment_date%TYPE default NULL,
4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,

Line 4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,

4561: p_amendment_recommendation in hr_all_positions_f.amendment_recommendation%TYPE default NULL,
4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,

Line 4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,

4562: p_amendment_ref_number in hr_all_positions_f.amendment_ref_number%TYPE default NULL,
4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,

Line 4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,

4563: p_bargaining_unit_cd in hr_all_positions_f.bargaining_unit_cd%TYPE default NULL,
4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,

Line 4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,

4564: p_current_job_prop_end_date in hr_all_positions_f.current_job_prop_end_date%TYPE default NULL,
4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,

Line 4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,

4565: p_current_org_prop_end_date in hr_all_positions_f.current_org_prop_end_date%TYPE default NULL,
4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,

Line 4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,

4566: p_avail_status_prop_end_date in hr_all_positions_f.avail_status_prop_end_date%TYPE default NULL,
4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,

Line 4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,

4567: p_date_effective in hr_all_positions_f.date_effective%TYPE default NULL,
4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,

Line 4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,

4568: p_date_end in hr_all_positions_f.date_end%TYPE default NULL,
4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,

Line 4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,

4569: p_earliest_hire_date in hr_all_positions_f.earliest_hire_date%TYPE default NULL,
4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,

Line 4574: p_name in hr_all_positions_f.name%TYPE default NULL,

4570: p_fill_by_date in hr_all_positions_f.fill_by_date%TYPE default NULL,
4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,

Line 4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,

4571: p_frequency in hr_all_positions_f.frequency%TYPE default NULL,
4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,

Line 4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,

4572: p_fte in hr_all_positions_f.fte%TYPE default NULL,
4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,

Line 4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,

4573: p_max_persons in hr_all_positions_f.max_persons%TYPE default NULL,
4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,

Line 4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,

4574: p_name in hr_all_positions_f.name%TYPE default NULL,
4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,

Line 4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,

4575: p_overlap_period in hr_all_positions_f.overlap_period%TYPE default NULL,
4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,

Line 4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,

4576: p_overlap_unit_cd in hr_all_positions_f.overlap_unit_cd%TYPE default NULL,
4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,

Line 4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,

4577: p_pay_term_end_day_cd in hr_all_positions_f.pay_term_end_day_cd%TYPE default NULL,
4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,

Line 4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,

4578: p_pay_term_end_month_cd in hr_all_positions_f.pay_term_end_month_cd%TYPE default NULL,
4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,

Line 4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,

4579: p_permanent_temporary_flag in hr_all_positions_f.permanent_temporary_flag%TYPE default NULL,
4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,

Line 4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,

4580: p_permit_recruitment_flag in hr_all_positions_f.permit_recruitment_flag%TYPE default NULL,
4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,

Line 4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,

4581: p_position_type in hr_all_positions_f.position_type%TYPE default NULL,
4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,

Line 4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,

4582: p_posting_description in hr_all_positions_f.posting_description%TYPE default NULL,
4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,

Line 4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,

4583: p_probation_period in hr_all_positions_f.probation_period%TYPE default NULL,
4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,

Line 4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,

4584: p_probation_period_unit_cd in hr_all_positions_f.probation_period_unit_cd%TYPE default NULL,
4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,

Line 4589: p_status in hr_all_positions_f.status%TYPE default NULL,

4585: p_replacement_required_flag in hr_all_positions_f.replacement_required_flag%TYPE default NULL,
4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,

Line 4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,

4586: p_review_flag in hr_all_positions_f.review_flag%TYPE default NULL,
4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,

Line 4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,

4587: p_seasonal_flag in hr_all_positions_f.seasonal_flag%TYPE default NULL,
4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,

Line 4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,

4588: p_security_requirements in hr_all_positions_f.security_requirements%TYPE default NULL,
4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,

Line 4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,

4589: p_status in hr_all_positions_f.status%TYPE default NULL,
4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,

Line 4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,

4590: p_term_start_day_cd in hr_all_positions_f.term_start_day_cd%TYPE default NULL,
4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,

Line 4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,

4591: p_term_start_month_cd in hr_all_positions_f.term_start_month_cd%TYPE default NULL,
4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,

Line 4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,

4592: p_time_normal_finish in hr_all_positions_f.time_normal_finish%TYPE default NULL,
4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,

Line 4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,

4593: p_time_normal_start in hr_all_positions_f.time_normal_start%TYPE default NULL,
4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,

Line 4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,

4594: p_update_source_cd in hr_all_positions_f.update_source_cd%TYPE default NULL,
4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,

Line 4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,

4595: p_working_hours in hr_all_positions_f.working_hours%TYPE default NULL,
4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,

Line 4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,

4596: p_works_council_approval_flag in hr_all_positions_f.works_council_approval_flag%TYPE default NULL,
4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,

Line 4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,

4597: p_work_period_type_cd in hr_all_positions_f.work_period_type_cd%TYPE default NULL,
4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,

Line 4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,

4598: p_work_term_end_day_cd in hr_all_positions_f.work_term_end_day_cd%TYPE default NULL,
4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,

Line 4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,

4599: p_work_term_end_month_cd in hr_all_positions_f.work_term_end_month_cd%TYPE default NULL,
4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,

Line 4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,

4600: p_information_category in hr_all_positions_f.information_category%TYPE default NULL,
4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,

Line 4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,

4601: p_information1 in hr_all_positions_f.information1%TYPE default NULL,
4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,

Line 4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,

4602: p_information2 in hr_all_positions_f.information2%TYPE default NULL,
4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,

Line 4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,

4603: p_information3 in hr_all_positions_f.information3%TYPE default NULL,
4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,

Line 4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,

4604: p_information4 in hr_all_positions_f.information4%TYPE default NULL,
4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,

Line 4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,

4605: p_information5 in hr_all_positions_f.information5%TYPE default NULL,
4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,

Line 4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,

4606: p_information6 in hr_all_positions_f.information6%TYPE default NULL,
4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,

Line 4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,

4607: p_information7 in hr_all_positions_f.information7%TYPE default NULL,
4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,

Line 4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,

4608: p_information8 in hr_all_positions_f.information8%TYPE default NULL,
4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,

Line 4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,

4609: p_information9 in hr_all_positions_f.information9%TYPE default NULL,
4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,

Line 4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,

4610: p_information10 in hr_all_positions_f.information10%TYPE default NULL,
4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,

Line 4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,

4611: p_information11 in hr_all_positions_f.information11%TYPE default NULL,
4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,

Line 4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,

4612: p_information12 in hr_all_positions_f.information12%TYPE default NULL,
4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,

Line 4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,

4613: p_information13 in hr_all_positions_f.information13%TYPE default NULL,
4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,

Line 4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,

4614: p_information14 in hr_all_positions_f.information14%TYPE default NULL,
4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,

Line 4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,

4615: p_information15 in hr_all_positions_f.information15%TYPE default NULL,
4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,

Line 4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,

4616: p_information16 in hr_all_positions_f.information16%TYPE default NULL,
4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,

Line 4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,

4617: p_information17 in hr_all_positions_f.information17%TYPE default NULL,
4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,

Line 4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,

4618: p_information18 in hr_all_positions_f.information18%TYPE default NULL,
4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,

Line 4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,

4619: p_information19 in hr_all_positions_f.information19%TYPE default NULL,
4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,

Line 4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,

4620: p_information20 in hr_all_positions_f.information20%TYPE default NULL,
4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,

Line 4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,

4621: p_information21 in hr_all_positions_f.information21%TYPE default NULL,
4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,

Line 4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,

4622: p_information22 in hr_all_positions_f.information22%TYPE default NULL,
4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,

Line 4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,

4623: p_information23 in hr_all_positions_f.information23%TYPE default NULL,
4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,

Line 4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,

4624: p_information24 in hr_all_positions_f.information24%TYPE default NULL,
4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,

Line 4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,

4625: p_information25 in hr_all_positions_f.information25%TYPE default NULL,
4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,

Line 4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,

4626: p_information26 in hr_all_positions_f.information26%TYPE default NULL,
4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,

Line 4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,

4627: p_information27 in hr_all_positions_f.information27%TYPE default NULL,
4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,

Line 4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,

4628: p_information28 in hr_all_positions_f.information28%TYPE default NULL,
4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,

Line 4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,

4629: p_information29 in hr_all_positions_f.information29%TYPE default NULL,
4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,

Line 4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,

4630: p_information30 in hr_all_positions_f.information30%TYPE default NULL,
4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,

Line 4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,

4631: p_attribute_category in hr_all_positions_f.attribute_category%TYPE default NULL,
4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,

Line 4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,

4632: p_attribute1 in hr_all_positions_f.attribute1%TYPE default NULL,
4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,

Line 4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,

4633: p_attribute2 in hr_all_positions_f.attribute2%TYPE default NULL,
4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,

Line 4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,

4634: p_attribute3 in hr_all_positions_f.attribute3%TYPE default NULL,
4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,

Line 4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,

4635: p_attribute4 in hr_all_positions_f.attribute4%TYPE default NULL,
4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,

Line 4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,

4636: p_attribute5 in hr_all_positions_f.attribute5%TYPE default NULL,
4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,

Line 4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,

4637: p_attribute6 in hr_all_positions_f.attribute6%TYPE default NULL,
4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,

Line 4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,

4638: p_attribute7 in hr_all_positions_f.attribute7%TYPE default NULL,
4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,

Line 4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,

4639: p_attribute8 in hr_all_positions_f.attribute8%TYPE default NULL,
4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,

Line 4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,

4640: p_attribute9 in hr_all_positions_f.attribute9%TYPE default NULL,
4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,

Line 4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,

4641: p_attribute10 in hr_all_positions_f.attribute10%TYPE default NULL,
4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,

Line 4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,

4642: p_attribute11 in hr_all_positions_f.attribute11%TYPE default NULL,
4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,

Line 4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,

4643: p_attribute12 in hr_all_positions_f.attribute12%TYPE default NULL,
4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,

Line 4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,

4644: p_attribute13 in hr_all_positions_f.attribute13%TYPE default NULL,
4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,

Line 4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,

4645: p_attribute14 in hr_all_positions_f.attribute14%TYPE default NULL,
4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,

Line 4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,

4646: p_attribute15 in hr_all_positions_f.attribute15%TYPE default NULL,
4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,

Line 4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,

4647: p_attribute16 in hr_all_positions_f.attribute16%TYPE default NULL,
4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,

Line 4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,

4648: p_attribute17 in hr_all_positions_f.attribute17%TYPE default NULL,
4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,

Line 4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,

4649: p_attribute18 in hr_all_positions_f.attribute18%TYPE default NULL,
4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,

Line 4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,

4650: p_attribute19 in hr_all_positions_f.attribute19%TYPE default NULL,
4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,

Line 4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,

4651: p_attribute20 in hr_all_positions_f.attribute20%TYPE default NULL,
4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,

Line 4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,

4652: p_attribute21 in hr_all_positions_f.attribute21%TYPE default NULL,
4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,

Line 4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,

4653: p_attribute22 in hr_all_positions_f.attribute22%TYPE default NULL,
4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,

Line 4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,

4654: p_attribute23 in hr_all_positions_f.attribute23%TYPE default NULL,
4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,

Line 4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,

4655: p_attribute24 in hr_all_positions_f.attribute24%TYPE default NULL,
4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,

Line 4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,

4656: p_attribute25 in hr_all_positions_f.attribute25%TYPE default NULL,
4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,

Line 4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,

4657: p_attribute26 in hr_all_positions_f.attribute26%TYPE default NULL,
4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,

Line 4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,

4658: p_attribute27 in hr_all_positions_f.attribute27%TYPE default NULL,
4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,

Line 4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,

4659: p_attribute28 in hr_all_positions_f.attribute28%TYPE default NULL,
4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,

Line 4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,

4660: p_attribute29 in hr_all_positions_f.attribute29%TYPE default NULL,
4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,

Line 4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,

4661: p_attribute30 in hr_all_positions_f.attribute30%TYPE default NULL,
4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,

Line 4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,

4662: p_request_id in hr_all_positions_f.request_id%TYPE default NULL,
4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,

Line 4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,

4663: p_program_application_id in hr_all_positions_f.program_application_id%TYPE default NULL,
4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,

Line 4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,

4664: p_program_id in hr_all_positions_f.program_id%TYPE default NULL,
4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,

Line 4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,

4665: p_program_update_date in hr_all_positions_f.program_update_date%TYPE default NULL,
4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is

Line 4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,

4666: p_entry_grade_id in hr_all_positions_f.entry_grade_id%TYPE default NULL,
4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is
4674:

Line 4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,

4667: p_entry_grade_rule_id in hr_all_positions_f.entry_grade_rule_id%TYPE default NULL,
4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is
4674:
4675: l_proc varchar2(30):='conv_to_position_rg';

Line 4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,

4668: p_proposed_fte_for_layoff in hr_all_positions_f.proposed_fte_for_layoff%TYPE default NULL,
4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is
4674:
4675: l_proc varchar2(30):='conv_to_position_rg';
4676: l_position_data hr_all_positions_f%rowtype;

Line 4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is

4669: p_proposed_date_for_layoff in hr_all_positions_f.proposed_date_for_layoff%TYPE default NULL,
4670: p_pay_basis_id in hr_all_positions_f.pay_basis_id%TYPE default NULL,
4671: p_supervisor_id in hr_all_positions_f.supervisor_id%TYPE default NULL,
4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is
4674:
4675: l_proc varchar2(30):='conv_to_position_rg';
4676: l_position_data hr_all_positions_f%rowtype;
4677:

Line 4676: l_position_data hr_all_positions_f%rowtype;

4672: p_copied_to_old_table_flag in hr_all_positions_f.copied_to_old_table_flag%TYPE default NULL,
4673: p_position_data in out nocopy hr_all_positions_f%rowtype ) is
4674:
4675: l_proc varchar2(30):='conv_to_position_rg';
4676: l_position_data hr_all_positions_f%rowtype;
4677:
4678: begin
4679:
4680: l_position_data :=p_position_data; --NOCOPY Changes

Line 4955: p_position_data out nocopy hr_all_positions_f%rowtype) is

4951: -- Procedure to convert the position history view rg to the position rg.
4952: --
4953: Procedure conv_to_position_rg (
4954: p_position_h_v in ghr_positions_h_v%rowtype,
4955: p_position_data out nocopy hr_all_positions_f%rowtype) is
4956:
4957: l_proc varchar2(30):='Conv_to_position_rg';
4958: l_position_data hr_all_positions_f%rowtype;
4959: Begin

Line 4958: l_position_data hr_all_positions_f%rowtype;

4954: p_position_h_v in ghr_positions_h_v%rowtype,
4955: p_position_data out nocopy hr_all_positions_f%rowtype) is
4956:
4957: l_proc varchar2(30):='Conv_to_position_rg';
4958: l_position_data hr_all_positions_f%rowtype;
4959: Begin
4960: hr_utility.set_location('Entering : ' || l_proc, 100);
4961: conv_to_position_rg(
4962: p_position_id => p_position_h_v.position_id,

Line 5110: p_position_data in hr_all_positions_f%rowtype,

5106: -- procedure to convert Position RG to Position History RG
5107: -- ghr_pa_history record type
5108: --
5109: Procedure conv_position_rg_to_hist_rg(
5110: p_position_data in hr_all_positions_f%rowtype,
5111: p_history_data in out nocopy ghr_pa_history%rowtype) as
5112:
5113: l_proc varchar2(30) := 'conv_position_rg_to_hist_rg';
5114: l_history_data ghr_pa_history%rowtype ;

Line 5266: p_position_data in out nocopy hr_all_positions_f%rowtype) as

5262: -- Procedure to convert history RG to Position RG
5263: --
5264: Procedure conv_to_position_rg(
5265: p_history_data in ghr_pa_history%rowtype,
5266: p_position_data in out nocopy hr_all_positions_f%rowtype) as
5267:
5268: l_proc varchar2(30) := 'conv_to_position_rg';
5269: l_position_data hr_all_positions_f%rowtype ;
5270:

Line 5269: l_position_data hr_all_positions_f%rowtype ;

5265: p_history_data in ghr_pa_history%rowtype,
5266: p_position_data in out nocopy hr_all_positions_f%rowtype) as
5267:
5268: l_proc varchar2(30) := 'conv_to_position_rg';
5269: l_position_data hr_all_positions_f%rowtype ;
5270:
5271: begin
5272:
5273: l_position_data :=p_position_data; --NOCOPY Changes