30: -- Type : PROCEDURE --
31: -- Access : Public --
32: -- Description : This procedure returns a sql string to select a --
33: -- range of assignments eligible for archival. --
34: -- It calls pay_apac_payslip_archive.range_code that --
35: -- archives the EIT definition and payroll level data --
36: -- (Messages, employer address details etc) --
37: -- --
38: -- Parameters : --
64: g_debug := hr_utility.debug_enabled;
65: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
66:
67: --------------------------------------------------------------------------------+
68: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
69: -- to archive the payroll action level data and EIT defintions.
70: --------------------------------------------------------------------------------+
71:
72: pay_apac_payslip_archive.range_code
68: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
69: -- to archive the payroll action level data and EIT defintions.
70: --------------------------------------------------------------------------------+
71:
72: pay_apac_payslip_archive.range_code
73: (
74: p_payroll_action_id => p_payroll_action_id
75: );
76:
208:
209: g_archive_pact := p_payroll_action_id;
210:
211: ------------------------------------------------------------------+
212: -- Call to common package procedure pay_apac_payslip_archive.
213: -- initialization_code to to set the global tables for EIT
214: -- that will be used by each thread in multi-threading.
215: ------------------------------------------------------------------+
216:
213: -- initialization_code to to set the global tables for EIT
214: -- that will be used by each thread in multi-threading.
215: ------------------------------------------------------------------+
216:
217: pay_apac_payslip_archive.initialization_code(
218: p_payroll_action_id => p_payroll_action_id
219: );
220:
221: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
4214: -- Access : Public --
4215: -- Description : Procedure to call the internal procedures to --
4216: -- actually the archive the data. The procedure --
4217: -- called are --
4218: -- pay_apac_payslip_archive.archive_user_balances --
4219: -- pay_apac_payslip_archive.archive_user_elements --
4220: -- archive_stat_balances --
4221: -- archive_stat_elements --
4222: -- archive_employee_details --
4215: -- Description : Procedure to call the internal procedures to --
4216: -- actually the archive the data. The procedure --
4217: -- called are --
4218: -- pay_apac_payslip_archive.archive_user_balances --
4219: -- pay_apac_payslip_archive.archive_user_elements --
4220: -- archive_stat_balances --
4221: -- archive_stat_elements --
4222: -- archive_employee_details --
4223: -- archive_accrual_details --
4593: --
4594: -- Call to procedure to archive User Configurable Balances
4595: --
4596:
4597: pay_apac_payslip_archive.archive_user_balances
4598: (
4599: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action id
4600: ,p_run_assignment_action_id => csr_rec.run_assignment_action_id -- payroll assignment action id
4601: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effecive date
4605: --
4606: -- Call to procedure to archive User Configurable Elements
4607: --
4608:
4609: pay_apac_payslip_archive.archive_user_elements
4610: (
4611: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action
4612: ,p_pre_assignment_action_id => csr_rec.pre_assignment_action_id -- prepayment assignment action id
4613: ,p_latest_run_assact_id => csr_rec.run_assignment_action_id -- payroll assignment action id