[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pay_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
82: ,p_base_key_column => 'payroll_id'
83: ,p_base_key_value => p_rec.payroll_id
84: );
85: --
86: pay_pay_shd.g_api_dml := true; -- Set the api dml status
87: --
88: -- Update the pay_all_payrolls_f Row
89: --
90: update pay_all_payrolls_f
173: and effective_end_date = p_validation_end_date;
174: --
175: --Storing the status of the above dml operation.
176: l_status_of_dml := SQL%NOTFOUND;
177: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
178: --
179: -- Set the effective start and end dates
180: --
181: p_rec.effective_start_date := p_validation_start_date;
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
201: pay_pay_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
210: Raise;
205: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
206: pay_pay_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
210: Raise;
211: End dt_update_dml;
212: --
213: -- ----------------------------------------------------------------------------
241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure update_dml
245: (p_rec in out nocopy pay_pay_shd.g_rec_type
246: ,p_effective_date in date
247: ,p_datetrack_mode in varchar2
248: ,p_validation_start_date in date
249: ,p_validation_end_date in date
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure dt_pre_update
312: (p_rec in out nocopy pay_pay_shd.g_rec_type
313: ,p_effective_date in date
314: ,p_datetrack_mode in varchar2
315: ,p_validation_start_date in date
316: ,p_validation_end_date in date
324: If (p_datetrack_mode <> hr_api.g_correction) then
325: --
326: -- Update the current effective end date
327: --
328: pay_pay_shd.upd_effective_end_date
329: (p_effective_date => p_effective_date
330: ,p_base_key_value => p_rec.payroll_id
331: ,p_new_effective_end_date => (p_validation_start_date - 1)
332: ,p_validation_start_date => p_validation_start_date
362: hr_utility.set_location(' Leaving:'||l_proc, 20);
363:
364: Exception
365: When Others Then
366: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
367: Raise;
368: --
369: End dt_pre_update;
370: --
400: --
401: -- {End Of Comments}
402: -- ----------------------------------------------------------------------------
403: Procedure pre_update
404: (p_rec in out nocopy pay_pay_shd.g_rec_type
405: ,p_effective_date in date
406: ,p_datetrack_mode in varchar2
407: ,p_validation_start_date in date
408: ,p_validation_end_date in date
423: ,p_comment_text => p_rec.comments
424: );
425: -- Update the comments if they have changed
426: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
427: pay_pay_shd.g_old_rec.comments) then
428: --
429:
430: hr_comm_api.upd(p_comment_id => p_rec.comment_id
431: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'
495: --
496: -- {End Of Comments}
497: -- ----------------------------------------------------------------------------
498: Procedure post_update
499: (p_rec in pay_pay_shd.g_rec_type
500: ,p_effective_date in date
501: ,p_datetrack_mode in varchar2
502: ,p_validation_start_date in date
503: ,p_validation_end_date in date
512:
513:
514: -- Copy new payroll_name to all rows for the payroll ie,. this should not be
515: -- datetracked.
516: if p_rec.payroll_name <> pay_pay_shd.g_old_rec.payroll_name then
517: --
518: pay_pay_shd.g_api_dml := true;
519: pay_payrolls_f_pkg.propagate_changes
520: (p_rec.payroll_id,
514: -- Copy new payroll_name to all rows for the payroll ie,. this should not be
515: -- datetracked.
516: if p_rec.payroll_name <> pay_pay_shd.g_old_rec.payroll_name then
517: --
518: pay_pay_shd.g_api_dml := true;
519: pay_payrolls_f_pkg.propagate_changes
520: (p_rec.payroll_id,
521: p_rec.payroll_name,
522: null); -- number of years
519: pay_payrolls_f_pkg.propagate_changes
520: (p_rec.payroll_id,
521: p_rec.payroll_name,
522: null); -- number of years
523: pay_pay_shd.g_api_dml := false;
524: --
525: end if;
526: --
527: -- Extend the number of payroll time periods if the number of years has been
525: end if;
526: --
527: -- Extend the number of payroll time periods if the number of years has been
528: -- increased.
529: if p_rec.number_of_years > pay_pay_shd.g_old_rec.number_of_years then
530: --
531: -- copy new number_of_years to all rows for the payroll ie,. this should
532: -- not be datetracked.
533: pay_pay_shd.g_api_dml := true;
529: if p_rec.number_of_years > pay_pay_shd.g_old_rec.number_of_years then
530: --
531: -- copy new number_of_years to all rows for the payroll ie,. this should
532: -- not be datetracked.
533: pay_pay_shd.g_api_dml := true;
534: pay_payrolls_f_pkg.propagate_changes
535: (p_rec.payroll_id,
536: null, -- payroll name
537: p_rec.number_of_years);
534: pay_payrolls_f_pkg.propagate_changes
535: (p_rec.payroll_id,
536: null, -- payroll name
537: p_rec.number_of_years);
538: pay_pay_shd.g_api_dml := false;
539: --
540: /*hr_payrolls.create_payroll_proc_periods
541: (p_rec.payroll_id,
542: null, -- last_update_date
550: end if;
551: --
552: -- If default payment method for the payroll has changed then create
553: -- opmu to represent it.
554: if p_rec.default_payment_method_id <> nvl(pay_pay_shd.g_old_rec.default_payment_method_id, 0)
555: and p_rec.default_payment_method_id is not null then
556: --
557: pay_payrolls_f_pkg.maintain_dflt_payment_method
558: (p_rec.payroll_id,
636: ,p_prl_information30 => p_rec.prl_information30
637: ,p_multi_assignments_flag => p_rec.multi_assignments_flag
638: ,p_object_version_number => p_rec.object_version_number
639: ,p_payslip_view_date_offset => p_rec.payslip_view_date_offset
640: ,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
637: ,p_multi_assignments_flag => p_rec.multi_assignments_flag
638: ,p_object_version_number => p_rec.object_version_number
639: ,p_payslip_view_date_offset => p_rec.payslip_view_date_offset
640: ,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
638: ,p_object_version_number => p_rec.object_version_number
639: ,p_payslip_view_date_offset => p_rec.payslip_view_date_offset
640: ,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
639: ,p_payslip_view_date_offset => p_rec.payslip_view_date_offset
640: ,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
640: ,p_effective_start_date_o => pay_pay_shd.g_old_rec.effective_start_date
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
641: ,p_effective_end_date_o => pay_pay_shd.g_old_rec.effective_end_date
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
642: ,p_default_payment_method_id_o => pay_pay_shd.g_old_rec.default_payment_method_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
643: ,p_business_group_id_o => pay_pay_shd.g_old_rec.business_group_id
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
644: ,p_consolidation_set_id_o => pay_pay_shd.g_old_rec.consolidation_set_id
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
645: ,p_cost_allocation_keyflex_id_o => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
646: ,p_suspense_account_keyflex_i_o => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
647: ,p_gl_set_of_books_id_o => pay_pay_shd.g_old_rec.gl_set_of_books_id
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
648: ,p_soft_coding_keyflex_id_o => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
649: ,p_period_type_o => pay_pay_shd.g_old_rec.period_type
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
650: ,p_organization_id_o => pay_pay_shd.g_old_rec.organization_id
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
651: ,p_cut_off_date_offset_o => pay_pay_shd.g_old_rec.cut_off_date_offset
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
652: ,p_direct_deposit_date_offset_o => pay_pay_shd.g_old_rec.direct_deposit_date_offset
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
653: ,p_first_period_end_date_o => pay_pay_shd.g_old_rec.first_period_end_date
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
654: ,p_negative_pay_allowed_flag_o => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
655: ,p_number_of_years_o => pay_pay_shd.g_old_rec.number_of_years
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
656: ,p_pay_advice_date_offset_o => pay_pay_shd.g_old_rec.pay_advice_date_offset
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
657: ,p_pay_date_offset_o => pay_pay_shd.g_old_rec.pay_date_offset
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
658: ,p_payroll_name_o => pay_pay_shd.g_old_rec.payroll_name
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
659: ,p_workload_shifting_level_o => pay_pay_shd.g_old_rec.workload_shifting_level
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
660: ,p_comment_id_o => pay_pay_shd.g_old_rec.comment_id
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
661: ,p_comments_o => pay_pay_shd.g_old_rec.comments
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
662: ,p_midpoint_offset_o => pay_pay_shd.g_old_rec.midpoint_offset
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
663: ,p_attribute_category_o => pay_pay_shd.g_old_rec.attribute_category
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
664: ,p_attribute1_o => pay_pay_shd.g_old_rec.attribute1
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
665: ,p_attribute2_o => pay_pay_shd.g_old_rec.attribute2
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
666: ,p_attribute3_o => pay_pay_shd.g_old_rec.attribute3
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
667: ,p_attribute4_o => pay_pay_shd.g_old_rec.attribute4
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
668: ,p_attribute5_o => pay_pay_shd.g_old_rec.attribute5
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
669: ,p_attribute6_o => pay_pay_shd.g_old_rec.attribute6
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
670: ,p_attribute7_o => pay_pay_shd.g_old_rec.attribute7
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
671: ,p_attribute8_o => pay_pay_shd.g_old_rec.attribute8
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
672: ,p_attribute9_o => pay_pay_shd.g_old_rec.attribute9
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
673: ,p_attribute10_o => pay_pay_shd.g_old_rec.attribute10
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
674: ,p_attribute11_o => pay_pay_shd.g_old_rec.attribute11
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
675: ,p_attribute12_o => pay_pay_shd.g_old_rec.attribute12
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
676: ,p_attribute13_o => pay_pay_shd.g_old_rec.attribute13
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
677: ,p_attribute14_o => pay_pay_shd.g_old_rec.attribute14
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
678: ,p_attribute15_o => pay_pay_shd.g_old_rec.attribute15
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
679: ,p_attribute16_o => pay_pay_shd.g_old_rec.attribute16
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
680: ,p_attribute17_o => pay_pay_shd.g_old_rec.attribute17
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
681: ,p_attribute18_o => pay_pay_shd.g_old_rec.attribute18
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
682: ,p_attribute19_o => pay_pay_shd.g_old_rec.attribute19
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
683: ,p_attribute20_o => pay_pay_shd.g_old_rec.attribute20
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
684: ,p_arrears_flag_o => pay_pay_shd.g_old_rec.arrears_flag
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
685: ,p_payroll_type_o => pay_pay_shd.g_old_rec.payroll_type
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
686: ,p_prl_information_category_o => pay_pay_shd.g_old_rec.prl_information_category
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
687: ,p_prl_information1_o => pay_pay_shd.g_old_rec.prl_information1
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
688: ,p_prl_information2_o => pay_pay_shd.g_old_rec.prl_information2
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
689: ,p_prl_information3_o => pay_pay_shd.g_old_rec.prl_information3
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
690: ,p_prl_information4_o => pay_pay_shd.g_old_rec.prl_information4
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
691: ,p_prl_information5_o => pay_pay_shd.g_old_rec.prl_information5
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
692: ,p_prl_information6_o => pay_pay_shd.g_old_rec.prl_information6
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
693: ,p_prl_information7_o => pay_pay_shd.g_old_rec.prl_information7
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
694: ,p_prl_information8_o => pay_pay_shd.g_old_rec.prl_information8
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
695: ,p_prl_information9_o => pay_pay_shd.g_old_rec.prl_information9
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
696: ,p_prl_information10_o => pay_pay_shd.g_old_rec.prl_information10
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
697: ,p_prl_information11_o => pay_pay_shd.g_old_rec.prl_information11
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
698: ,p_prl_information12_o => pay_pay_shd.g_old_rec.prl_information12
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
699: ,p_prl_information13_o => pay_pay_shd.g_old_rec.prl_information13
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
700: ,p_prl_information14_o => pay_pay_shd.g_old_rec.prl_information14
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
701: ,p_prl_information15_o => pay_pay_shd.g_old_rec.prl_information15
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
702: ,p_prl_information16_o => pay_pay_shd.g_old_rec.prl_information16
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
703: ,p_prl_information17_o => pay_pay_shd.g_old_rec.prl_information17
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
704: ,p_prl_information18_o => pay_pay_shd.g_old_rec.prl_information18
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
705: ,p_prl_information19_o => pay_pay_shd.g_old_rec.prl_information19
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
706: ,p_prl_information20_o => pay_pay_shd.g_old_rec.prl_information20
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
707: ,p_prl_information21_o => pay_pay_shd.g_old_rec.prl_information21
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
708: ,p_prl_information22_o => pay_pay_shd.g_old_rec.prl_information22
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
709: ,p_prl_information23_o => pay_pay_shd.g_old_rec.prl_information23
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
710: ,p_prl_information24_o => pay_pay_shd.g_old_rec.prl_information24
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
711: ,p_prl_information25_o => pay_pay_shd.g_old_rec.prl_information25
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
712: ,p_prl_information26_o => pay_pay_shd.g_old_rec.prl_information26
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
720: ,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
713: ,p_prl_information27_o => pay_pay_shd.g_old_rec.prl_information27
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
720: ,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
721: );
714: ,p_prl_information28_o => pay_pay_shd.g_old_rec.prl_information28
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
720: ,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
721: );
722: --
715: ,p_prl_information29_o => pay_pay_shd.g_old_rec.prl_information29
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
720: ,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
721: );
722: --
723: exception
716: ,p_prl_information30_o => pay_pay_shd.g_old_rec.prl_information30
717: ,p_multi_assignments_flag_o => pay_pay_shd.g_old_rec.multi_assignments_flag
718: ,p_period_reset_years_o => pay_pay_shd.g_old_rec.period_reset_years
719: ,p_object_version_number_o => pay_pay_shd.g_old_rec.object_version_number
720: ,p_payslip_view_date_offset_o => pay_pay_shd.g_old_rec.payslip_view_date_offset
721: );
722: --
723: exception
724: --
777: --
778: -- {End Of Comments}
779: -- ----------------------------------------------------------------------------
780: Procedure convert_defs
781: (p_rec in out nocopy pay_pay_shd.g_rec_type
782: ) is
783: --
784: Begin
785: --
790: --
791: If (p_rec.default_payment_method_id = hr_api.g_number) then
792: --
793: p_rec.default_payment_method_id :=
794: pay_pay_shd.g_old_rec.default_payment_method_id;
795: --
796: End If;
797: --
798: If (p_rec.business_group_id = hr_api.g_number) then
796: End If;
797: --
798: If (p_rec.business_group_id = hr_api.g_number) then
799: --
800: p_rec.business_group_id := pay_pay_shd.g_old_rec.business_group_id;
801: --
802: End if;
803: --
804: If (p_rec.consolidation_set_id = hr_api.g_number) then
802: End if;
803: --
804: If (p_rec.consolidation_set_id = hr_api.g_number) then
805: --
806: p_rec.consolidation_set_id := pay_pay_shd.g_old_rec.consolidation_set_id;
807: --
808: End If;
809: --
810: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
809: --
810: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
811: --
812: p_rec.cost_allocation_keyflex_id :=
813: pay_pay_shd.g_old_rec.cost_allocation_keyflex_id;
814: --
815: End If;
816: --
817: If (p_rec.suspense_account_keyflex_id = hr_api.g_number) then
816: --
817: If (p_rec.suspense_account_keyflex_id = hr_api.g_number) then
818: --
819: p_rec.suspense_account_keyflex_id :=
820: pay_pay_shd.g_old_rec.suspense_account_keyflex_id;
821: --
822: End If;
823: --
824: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
823: --
824: If (p_rec.gl_set_of_books_id = hr_api.g_number) then
825: --
826: p_rec.gl_set_of_books_id :=
827: pay_pay_shd.g_old_rec.gl_set_of_books_id;
828: --
829: End If;
830: --
831: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
830: --
831: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
832: --
833: p_rec.soft_coding_keyflex_id :=
834: pay_pay_shd.g_old_rec.soft_coding_keyflex_id;
835: --
836: End If;
837: --
838: If (p_rec.period_type = hr_api.g_varchar2) then
837: --
838: If (p_rec.period_type = hr_api.g_varchar2) then
839: --
840: p_rec.period_type :=
841: pay_pay_shd.g_old_rec.period_type;
842: --
843: End If;
844: --
845: If (p_rec.organization_id = hr_api.g_number) then
843: End If;
844: --
845: If (p_rec.organization_id = hr_api.g_number) then
846: --
847: p_rec.organization_id := pay_pay_shd.g_old_rec.organization_id;
848: --
849: End If;
850: --
851: If (p_rec.cut_off_date_offset = hr_api.g_number) then
849: End If;
850: --
851: If (p_rec.cut_off_date_offset = hr_api.g_number) then
852: --
853: p_rec.cut_off_date_offset := pay_pay_shd.g_old_rec.cut_off_date_offset;
854: --
855: End If;
856: --
857: If (p_rec.direct_deposit_date_offset = hr_api.g_number) then
856: --
857: If (p_rec.direct_deposit_date_offset = hr_api.g_number) then
858: --
859: p_rec.direct_deposit_date_offset :=
860: pay_pay_shd.g_old_rec.direct_deposit_date_offset;
861: --
862: End If;
863: --
864: If (p_rec.first_period_end_date = hr_api.g_date) then
863: --
864: If (p_rec.first_period_end_date = hr_api.g_date) then
865: --
866: p_rec.first_period_end_date :=
867: pay_pay_shd.g_old_rec.first_period_end_date;
868: --
869: End If;
870: If (p_rec.negative_pay_allowed_flag = hr_api.g_varchar2) then
871: --
869: End If;
870: If (p_rec.negative_pay_allowed_flag = hr_api.g_varchar2) then
871: --
872: p_rec.negative_pay_allowed_flag :=
873: pay_pay_shd.g_old_rec.negative_pay_allowed_flag;
874: --
875: End If;
876: If (p_rec.number_of_years = hr_api.g_number) then
877: --
874: --
875: End If;
876: If (p_rec.number_of_years = hr_api.g_number) then
877: --
878: p_rec.number_of_years := pay_pay_shd.g_old_rec.number_of_years;
879: --
880: End If;
881: --
882: If (p_rec.pay_advice_date_offset = hr_api.g_number) then
881: --
882: If (p_rec.pay_advice_date_offset = hr_api.g_number) then
883: --
884: p_rec.pay_advice_date_offset :=
885: pay_pay_shd.g_old_rec.pay_advice_date_offset;
886: --
887: End If;
888: --
889: If (p_rec.pay_date_offset = hr_api.g_number) then
887: End If;
888: --
889: If (p_rec.pay_date_offset = hr_api.g_number) then
890: --
891: p_rec.pay_date_offset := pay_pay_shd.g_old_rec.pay_date_offset;
892: --
893: End If;
894: --
895: If (p_rec.payroll_name = hr_api.g_varchar2) then
893: End If;
894: --
895: If (p_rec.payroll_name = hr_api.g_varchar2) then
896: --
897: p_rec.payroll_name := pay_pay_shd.g_old_rec.payroll_name;
898: --
899: End If;
900: --
901: If (p_rec.workload_shifting_level = hr_api.g_varchar2) then
900: --
901: If (p_rec.workload_shifting_level = hr_api.g_varchar2) then
902: --
903: p_rec.workload_shifting_level :=
904: pay_pay_shd.g_old_rec.workload_shifting_level;
905: --
906: End If;
907: --
908: If (p_rec.comment_id = hr_api.g_number) then
906: End If;
907: --
908: If (p_rec.comment_id = hr_api.g_number) then
909: --
910: p_rec.comment_id := pay_pay_shd.g_old_rec.comment_id;
911: --
912: End If;
913: --
914: If (p_rec.comments = hr_api.g_varchar2) then
912: End If;
913: --
914: If (p_rec.comments = hr_api.g_varchar2) then
915: --
916: p_rec.comments := pay_pay_shd.g_old_rec.comments;
917: --
918: End If;
919: --
920: If (p_rec.midpoint_offset = hr_api.g_number) then
918: End If;
919: --
920: If (p_rec.midpoint_offset = hr_api.g_number) then
921: --
922: p_rec.midpoint_offset := pay_pay_shd.g_old_rec.midpoint_offset;
923: --
924: End If;
925: --
926: If (p_rec.attribute_category = hr_api.g_varchar2) then
924: End If;
925: --
926: If (p_rec.attribute_category = hr_api.g_varchar2) then
927: --
928: p_rec.attribute_category := pay_pay_shd.g_old_rec.attribute_category;
929: --
930: End If;
931: --
932: If (p_rec.attribute1 = hr_api.g_varchar2) then
930: End If;
931: --
932: If (p_rec.attribute1 = hr_api.g_varchar2) then
933: --
934: p_rec.attribute1 := pay_pay_shd.g_old_rec.attribute1;
935: --
936: End If;
937: --
938: If (p_rec.attribute2 = hr_api.g_varchar2) then
936: End If;
937: --
938: If (p_rec.attribute2 = hr_api.g_varchar2) then
939: --
940: p_rec.attribute2 := pay_pay_shd.g_old_rec.attribute2;
941: --
942: End If;
943: --
944: If (p_rec.attribute3 = hr_api.g_varchar2) then
942: End If;
943: --
944: If (p_rec.attribute3 = hr_api.g_varchar2) then
945: --
946: p_rec.attribute3 := pay_pay_shd.g_old_rec.attribute3;
947: --
948: End If;
949: --
950: If (p_rec.attribute4 = hr_api.g_varchar2) then
948: End If;
949: --
950: If (p_rec.attribute4 = hr_api.g_varchar2) then
951: --
952: p_rec.attribute4 := pay_pay_shd.g_old_rec.attribute4;
953: --
954: End If;
955: --
956: If (p_rec.attribute5 = hr_api.g_varchar2) then
954: End If;
955: --
956: If (p_rec.attribute5 = hr_api.g_varchar2) then
957: --
958: p_rec.attribute5 := pay_pay_shd.g_old_rec.attribute5;
959: --
960: End If;
961: --
962: If (p_rec.attribute6 = hr_api.g_varchar2) then
960: End If;
961: --
962: If (p_rec.attribute6 = hr_api.g_varchar2) then
963: --
964: p_rec.attribute6 := pay_pay_shd.g_old_rec.attribute6;
965: --
966: End If;
967: --
968: If (p_rec.attribute7 = hr_api.g_varchar2) then
966: End If;
967: --
968: If (p_rec.attribute7 = hr_api.g_varchar2) then
969: --
970: p_rec.attribute7 := pay_pay_shd.g_old_rec.attribute7;
971: --
972: End If;
973: --
974: If (p_rec.attribute8 = hr_api.g_varchar2) then
972: End If;
973: --
974: If (p_rec.attribute8 = hr_api.g_varchar2) then
975: --
976: p_rec.attribute8 := pay_pay_shd.g_old_rec.attribute8;
977: --
978: End If;
979: --
980: If (p_rec.attribute9 = hr_api.g_varchar2) then
978: End If;
979: --
980: If (p_rec.attribute9 = hr_api.g_varchar2) then
981: --
982: p_rec.attribute9 := pay_pay_shd.g_old_rec.attribute9;
983: --
984: End If;
985: --
986: If (p_rec.attribute10 = hr_api.g_varchar2) then
984: End If;
985: --
986: If (p_rec.attribute10 = hr_api.g_varchar2) then
987: --
988: p_rec.attribute10 := pay_pay_shd.g_old_rec.attribute10;
989: --
990: End If;
991: --
992: If (p_rec.attribute11 = hr_api.g_varchar2) then
990: End If;
991: --
992: If (p_rec.attribute11 = hr_api.g_varchar2) then
993: --
994: p_rec.attribute11 := pay_pay_shd.g_old_rec.attribute11;
995: --
996: End If;
997: --
998: If (p_rec.attribute12 = hr_api.g_varchar2) then
996: End If;
997: --
998: If (p_rec.attribute12 = hr_api.g_varchar2) then
999: --
1000: p_rec.attribute12 := pay_pay_shd.g_old_rec.attribute12;
1001: --
1002: End If;
1003: --
1004: If (p_rec.attribute13 = hr_api.g_varchar2) then
1002: End If;
1003: --
1004: If (p_rec.attribute13 = hr_api.g_varchar2) then
1005: --
1006: p_rec.attribute13 := pay_pay_shd.g_old_rec.attribute13;
1007: --
1008: End If;
1009: --
1010: If (p_rec.attribute14 = hr_api.g_varchar2) then
1008: End If;
1009: --
1010: If (p_rec.attribute14 = hr_api.g_varchar2) then
1011: --
1012: p_rec.attribute14 := pay_pay_shd.g_old_rec.attribute14;
1013: --
1014: End If;
1015: --
1016: If (p_rec.attribute15 = hr_api.g_varchar2) then
1014: End If;
1015: --
1016: If (p_rec.attribute15 = hr_api.g_varchar2) then
1017: --
1018: p_rec.attribute15 := pay_pay_shd.g_old_rec.attribute15;
1019: --
1020: End If;
1021: --
1022: If (p_rec.attribute16 = hr_api.g_varchar2) then
1020: End If;
1021: --
1022: If (p_rec.attribute16 = hr_api.g_varchar2) then
1023: --
1024: p_rec.attribute16 := pay_pay_shd.g_old_rec.attribute16;
1025: --
1026: End If;
1027: If (p_rec.attribute17 = hr_api.g_varchar2) then
1028: --
1025: --
1026: End If;
1027: If (p_rec.attribute17 = hr_api.g_varchar2) then
1028: --
1029: p_rec.attribute17 := pay_pay_shd.g_old_rec.attribute17;
1030: --
1031: End If;
1032: --
1033: If (p_rec.attribute18 = hr_api.g_varchar2) then
1031: End If;
1032: --
1033: If (p_rec.attribute18 = hr_api.g_varchar2) then
1034: --
1035: p_rec.attribute18 := pay_pay_shd.g_old_rec.attribute18;
1036: --
1037: End If;
1038: --
1039: If (p_rec.attribute19 = hr_api.g_varchar2) then
1037: End If;
1038: --
1039: If (p_rec.attribute19 = hr_api.g_varchar2) then
1040: --
1041: p_rec.attribute19 := pay_pay_shd.g_old_rec.attribute19;
1042: --
1043: End If;
1044: --
1045: If (p_rec.attribute20 = hr_api.g_varchar2) then
1043: End If;
1044: --
1045: If (p_rec.attribute20 = hr_api.g_varchar2) then
1046: --
1047: p_rec.attribute20 := pay_pay_shd.g_old_rec.attribute20;
1048: --
1049: End If;
1050: --
1051: If (p_rec.arrears_flag = hr_api.g_varchar2) then
1049: End If;
1050: --
1051: If (p_rec.arrears_flag = hr_api.g_varchar2) then
1052: --
1053: p_rec.arrears_flag := pay_pay_shd.g_old_rec.arrears_flag;
1054: --
1055: End If;
1056: --
1057: If (p_rec.payroll_type = hr_api.g_varchar2) then
1055: End If;
1056: --
1057: If (p_rec.payroll_type = hr_api.g_varchar2) then
1058: --
1059: p_rec.payroll_type := pay_pay_shd.g_old_rec.payroll_type;
1060: --
1061: End If;
1062: --
1063: If (p_rec.prl_information_category = hr_api.g_varchar2) then
1062: --
1063: If (p_rec.prl_information_category = hr_api.g_varchar2) then
1064: --
1065: p_rec.prl_information_category :=
1066: pay_pay_shd.g_old_rec.prl_information_category;
1067: --
1068: End If;
1069: --
1070: If (p_rec.prl_information1 = hr_api.g_varchar2) then
1068: End If;
1069: --
1070: If (p_rec.prl_information1 = hr_api.g_varchar2) then
1071: --
1072: p_rec.prl_information1 := pay_pay_shd.g_old_rec.prl_information1;
1073: --
1074: End If;
1075: --
1076: If (p_rec.prl_information2 = hr_api.g_varchar2) then
1074: End If;
1075: --
1076: If (p_rec.prl_information2 = hr_api.g_varchar2) then
1077: --
1078: p_rec.prl_information2 := pay_pay_shd.g_old_rec.prl_information2;
1079: --
1080: End If;
1081: --
1082: If (p_rec.prl_information3 = hr_api.g_varchar2) then
1080: End If;
1081: --
1082: If (p_rec.prl_information3 = hr_api.g_varchar2) then
1083: --
1084: p_rec.prl_information3 := pay_pay_shd.g_old_rec.prl_information3;
1085: --
1086: End If;
1087: --
1088: If (p_rec.prl_information4 = hr_api.g_varchar2) then
1086: End If;
1087: --
1088: If (p_rec.prl_information4 = hr_api.g_varchar2) then
1089: --
1090: p_rec.prl_information4 := pay_pay_shd.g_old_rec.prl_information4;
1091: --
1092: End If;
1093: --
1094: If (p_rec.prl_information5 = hr_api.g_varchar2) then
1092: End If;
1093: --
1094: If (p_rec.prl_information5 = hr_api.g_varchar2) then
1095: --
1096: p_rec.prl_information5 := pay_pay_shd.g_old_rec.prl_information5;
1097: --
1098: End If;
1099: --
1100: If (p_rec.prl_information6 = hr_api.g_varchar2) then
1098: End If;
1099: --
1100: If (p_rec.prl_information6 = hr_api.g_varchar2) then
1101: --
1102: p_rec.prl_information6 := pay_pay_shd.g_old_rec.prl_information6;
1103: --
1104: End If;
1105: --
1106: If (p_rec.prl_information7 = hr_api.g_varchar2) then
1104: End If;
1105: --
1106: If (p_rec.prl_information7 = hr_api.g_varchar2) then
1107: --
1108: p_rec.prl_information7 := pay_pay_shd.g_old_rec.prl_information7;
1109: --
1110: End If;
1111: If (p_rec.prl_information8 = hr_api.g_varchar2) then
1112: --
1109: --
1110: End If;
1111: If (p_rec.prl_information8 = hr_api.g_varchar2) then
1112: --
1113: p_rec.prl_information8 := pay_pay_shd.g_old_rec.prl_information8;
1114: --
1115: End If;
1116: --
1117: If (p_rec.prl_information9 = hr_api.g_varchar2) then
1115: End If;
1116: --
1117: If (p_rec.prl_information9 = hr_api.g_varchar2) then
1118: --
1119: p_rec.prl_information9 := pay_pay_shd.g_old_rec.prl_information9;
1120: --
1121: End If;
1122: --
1123: If (p_rec.prl_information10 = hr_api.g_varchar2) then
1121: End If;
1122: --
1123: If (p_rec.prl_information10 = hr_api.g_varchar2) then
1124: --
1125: p_rec.prl_information10 := pay_pay_shd.g_old_rec.prl_information10;
1126: --
1127: End If;
1128: --
1129: If (p_rec.prl_information11 = hr_api.g_varchar2) then
1127: End If;
1128: --
1129: If (p_rec.prl_information11 = hr_api.g_varchar2) then
1130: --
1131: p_rec.prl_information11 := pay_pay_shd.g_old_rec.prl_information11;
1132: --
1133: End If;
1134: --
1135: If (p_rec.prl_information12 = hr_api.g_varchar2) then
1133: End If;
1134: --
1135: If (p_rec.prl_information12 = hr_api.g_varchar2) then
1136: --
1137: p_rec.prl_information12 := pay_pay_shd.g_old_rec.prl_information12;
1138: --
1139: End If;
1140: --
1141: If (p_rec.prl_information13 = hr_api.g_varchar2) then
1139: End If;
1140: --
1141: If (p_rec.prl_information13 = hr_api.g_varchar2) then
1142: --
1143: p_rec.prl_information13 := pay_pay_shd.g_old_rec.prl_information13;
1144: --
1145: End If;
1146: --
1147: If (p_rec.prl_information14 = hr_api.g_varchar2) then
1145: End If;
1146: --
1147: If (p_rec.prl_information14 = hr_api.g_varchar2) then
1148: --
1149: p_rec.prl_information14 := pay_pay_shd.g_old_rec.prl_information14;
1150: --
1151: End If;
1152: --
1153: If (p_rec.prl_information15 = hr_api.g_varchar2) then
1151: End If;
1152: --
1153: If (p_rec.prl_information15 = hr_api.g_varchar2) then
1154: --
1155: p_rec.prl_information15 := pay_pay_shd.g_old_rec.prl_information15;
1156: --
1157: End If;
1158: --
1159: If (p_rec.prl_information16 = hr_api.g_varchar2) then
1157: End If;
1158: --
1159: If (p_rec.prl_information16 = hr_api.g_varchar2) then
1160: --
1161: p_rec.prl_information16 := pay_pay_shd.g_old_rec.prl_information16;
1162: --
1163: End If;
1164: --
1165: If (p_rec.prl_information17 = hr_api.g_varchar2) then
1163: End If;
1164: --
1165: If (p_rec.prl_information17 = hr_api.g_varchar2) then
1166: --
1167: p_rec.prl_information17 := pay_pay_shd.g_old_rec.prl_information17;
1168: --
1169: End If;
1170: --
1171: If (p_rec.prl_information18 = hr_api.g_varchar2) then
1169: End If;
1170: --
1171: If (p_rec.prl_information18 = hr_api.g_varchar2) then
1172: --
1173: p_rec.prl_information18 := pay_pay_shd.g_old_rec.prl_information18;
1174: --
1175: End If;
1176: --
1177: If (p_rec.prl_information19 = hr_api.g_varchar2) then
1175: End If;
1176: --
1177: If (p_rec.prl_information19 = hr_api.g_varchar2) then
1178: --
1179: p_rec.prl_information19 := pay_pay_shd.g_old_rec.prl_information19;
1180: --
1181: End If;
1182: --
1183: If (p_rec.prl_information20 = hr_api.g_varchar2) then
1181: End If;
1182: --
1183: If (p_rec.prl_information20 = hr_api.g_varchar2) then
1184: --
1185: p_rec.prl_information20 := pay_pay_shd.g_old_rec.prl_information20;
1186: --
1187: End If;
1188: --
1189: If (p_rec.prl_information21 = hr_api.g_varchar2) then
1187: End If;
1188: --
1189: If (p_rec.prl_information21 = hr_api.g_varchar2) then
1190: --
1191: p_rec.prl_information21 := pay_pay_shd.g_old_rec.prl_information21;
1192: --
1193: End If;
1194: --
1195: If (p_rec.prl_information22 = hr_api.g_varchar2) then
1193: End If;
1194: --
1195: If (p_rec.prl_information22 = hr_api.g_varchar2) then
1196: --
1197: p_rec.prl_information22 := pay_pay_shd.g_old_rec.prl_information22;
1198: --
1199: End If;
1200: --
1201: If (p_rec.prl_information23 = hr_api.g_varchar2) then
1199: End If;
1200: --
1201: If (p_rec.prl_information23 = hr_api.g_varchar2) then
1202: --
1203: p_rec.prl_information23 := pay_pay_shd.g_old_rec.prl_information23;
1204: --
1205: End If;
1206: --
1207: If (p_rec.prl_information24 = hr_api.g_varchar2) then
1205: End If;
1206: --
1207: If (p_rec.prl_information24 = hr_api.g_varchar2) then
1208: --
1209: p_rec.prl_information24 := pay_pay_shd.g_old_rec.prl_information24;
1210: --
1211: End If;
1212: --
1213: If (p_rec.prl_information25 = hr_api.g_varchar2) then
1211: End If;
1212: --
1213: If (p_rec.prl_information25 = hr_api.g_varchar2) then
1214: --
1215: p_rec.prl_information25 := pay_pay_shd.g_old_rec.prl_information25;
1216: --
1217: End If;
1218: --
1219: If (p_rec.prl_information26 = hr_api.g_varchar2) then
1217: End If;
1218: --
1219: If (p_rec.prl_information26 = hr_api.g_varchar2) then
1220: --
1221: p_rec.prl_information26 := pay_pay_shd.g_old_rec.prl_information26;
1222: --
1223: End If;
1224: --
1225: If (p_rec.prl_information27 = hr_api.g_varchar2) then
1223: End If;
1224: --
1225: If (p_rec.prl_information27 = hr_api.g_varchar2) then
1226: --
1227: p_rec.prl_information27 := pay_pay_shd.g_old_rec.prl_information27;
1228: --
1229: End If;
1230: --
1231: If (p_rec.prl_information28 = hr_api.g_varchar2) then
1229: End If;
1230: --
1231: If (p_rec.prl_information28 = hr_api.g_varchar2) then
1232: --
1233: p_rec.prl_information28 := pay_pay_shd.g_old_rec.prl_information28;
1234: --
1235: End If;
1236: --
1237: If (p_rec.prl_information29 = hr_api.g_varchar2) then
1235: End If;
1236: --
1237: If (p_rec.prl_information29 = hr_api.g_varchar2) then
1238: --
1239: p_rec.prl_information29 := pay_pay_shd.g_old_rec.prl_information29;
1240: --
1241: End If;
1242: --
1243: If (p_rec.prl_information30 = hr_api.g_varchar2) then
1241: End If;
1242: --
1243: If (p_rec.prl_information30 = hr_api.g_varchar2) then
1244: --
1245: p_rec.prl_information30 := pay_pay_shd.g_old_rec.prl_information30;
1246: --
1247: End If;
1248: --
1249: If (p_rec.multi_assignments_flag = hr_api.g_varchar2) then
1247: End If;
1248: --
1249: If (p_rec.multi_assignments_flag = hr_api.g_varchar2) then
1250: --
1251: p_rec.multi_assignments_flag := pay_pay_shd.g_old_rec.multi_assignments_flag;
1252: --
1253: End If;
1254: --
1255: If (p_rec.period_reset_years = hr_api.g_varchar2) then
1253: End If;
1254: --
1255: If (p_rec.period_reset_years = hr_api.g_varchar2) then
1256: --
1257: p_rec.period_reset_years := pay_pay_shd.g_old_rec.period_reset_years;
1258: --
1259: End If;
1260: --
1261: IF (p_rec.payslip_view_date_offset = hr_api.g_number) then
1259: End If;
1260: --
1261: IF (p_rec.payslip_view_date_offset = hr_api.g_number) then
1262: --
1263: p_rec.payslip_view_date_offset := pay_pay_shd.g_old_rec.payslip_view_date_offset;
1264: --
1265: End If;
1266: --
1267: End convert_defs;
1271: -- ----------------------------------------------------------------------------
1272: Procedure upd
1273: (p_effective_date in date
1274: ,p_datetrack_mode in varchar2
1275: ,p_rec in out nocopy pay_pay_shd.g_rec_type
1276: ) is
1277: --
1278: l_proc varchar2(72) := g_package||'upd';
1279: l_validation_start_date date;
1277: --
1278: l_proc varchar2(72) := g_package||'upd';
1279: l_validation_start_date date;
1280: l_validation_end_date date;
1281: l_rec pay_pay_shd.g_rec_type := p_rec;
1282: --
1283: Begin
1284: hr_utility.set_location('Entering:'||l_proc, 5);
1285: --
1289: --
1290: -- We must lock the row which we need to update.
1291: --
1292:
1293: pay_pay_shd.lck
1294: (p_effective_date => p_effective_date
1295: ,p_datetrack_mode => p_datetrack_mode
1296: ,p_payroll_id => l_rec.payroll_id
1297: ,p_object_version_number => l_rec.object_version_number
1457: ,p_effective_end_date out nocopy date
1458: ,p_comment_id out nocopy number
1459: ) is
1460: --
1461: l_rec pay_pay_shd.g_rec_type;
1462: l_proc varchar2(72) := g_package||'upd';
1463: --
1464: Begin
1465: hr_utility.set_location('Entering:'||l_proc, 5);
1467: -- Call conversion function to turn arguments into the
1468: -- l_rec structure.
1469: --
1470: l_rec :=
1471: pay_pay_shd.convert_args
1472: (p_payroll_id
1473: ,null
1474: ,null
1475: ,p_default_payment_method_id