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:
138:
139: g_archive_pact := p_payroll_action_id;
140:
141: ------------------------------------------------------------------+
142: -- Call to common package procedure pay_apac_payslip_archive.
143: -- initialization_code to to set the global tables for EIT
144: -- that will be used by each thread in multi-threading.
145: ------------------------------------------------------------------+
146:
143: -- initialization_code to to set the global tables for EIT
144: -- that will be used by each thread in multi-threading.
145: ------------------------------------------------------------------+
146:
147: pay_apac_payslip_archive.initialization_code(
148: p_payroll_action_id => p_payroll_action_id
149: );
150:
151: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
3994: -- Access : Public --
3995: -- Description : Procedure to call the internal procedures to --
3996: -- actually the archive the data. The procedure --
3997: -- called are --
3998: -- pay_apac_payslip_archive.archive_user_balances --
3999: -- pay_apac_payslip_archive.archive_user_elements --
4000: -- archive_stat_balances --
4001: -- archive_stat_elements --
4002: -- archive_employee_details --
3995: -- Description : Procedure to call the internal procedures to --
3996: -- actually the archive the data. The procedure --
3997: -- called are --
3998: -- pay_apac_payslip_archive.archive_user_balances --
3999: -- pay_apac_payslip_archive.archive_user_elements --
4000: -- archive_stat_balances --
4001: -- archive_stat_elements --
4002: -- archive_employee_details --
4003: -- archive_accrual_details --
4368: --
4369: -- Call to procedure to archive User Configurable Balances
4370: --
4371:
4372: pay_apac_payslip_archive.archive_user_balances
4373: (
4374: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action id
4375: ,p_run_assignment_action_id => csr_rec.run_assignment_action_id -- payroll assignment action id
4376: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effecive date
4380: --
4381: -- Call to procedure to archive User Configurable Elements
4382: --
4383:
4384: pay_apac_payslip_archive.archive_user_elements
4385: (
4386: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action
4387: ,p_pre_assignment_action_id => csr_rec.pre_assignment_action_id -- prepayment assignment action id
4388: ,p_latest_run_assact_id => csr_rec.run_assignment_action_id -- payroll assignment action id