14: -- Type : PROCEDURE --
15: -- Access : Public --
16: -- Description : This procedure returns a sql string to select a --
17: -- range of assignments eligible for archival. --
18: -- It calls pay_apac_payslip_archive.range_code that --
19: -- archives the EIT definition and payroll level data --
20: -- (Messages, employer address details etc) --
21: -- --
22: -- Parameters : --
48: l_procedure := g_package || '.range_code';
49: hr_utility.set_location('Entering ' || l_procedure,10);
50:
51: --------------------------------------------------------------------------------+
52: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
53: -- to archive the payroll action level data and EIT defintions.
54: --------------------------------------------------------------------------------+
55:
56: pay_apac_payslip_archive.range_code
52: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
53: -- to archive the payroll action level data and EIT defintions.
54: --------------------------------------------------------------------------------+
55:
56: pay_apac_payslip_archive.range_code
57: (
58: p_payroll_action_id => p_payroll_action_id
59: );
60:
120:
121: g_archive_pact := p_payroll_action_id;
122:
123: ------------------------------------------------------------------+
124: -- Call to common package procedure pay_apac_payslip_archive.
125: -- initialization_code to to set the global tables for EIT
126: -- that will be used by each thread in multi-threading.
127: ------------------------------------------------------------------+
128:
125: -- initialization_code to to set the global tables for EIT
126: -- that will be used by each thread in multi-threading.
127: ------------------------------------------------------------------+
128:
129: pay_apac_payslip_archive.initialization_code(
130: p_payroll_action_id => p_payroll_action_id
131: );
132:
133: hr_utility.set_location('Leaving ' || l_procedure,20);
1971: -- Access : Public --
1972: -- Description : Procedure to call the internal procedures to --
1973: -- actually the archive the data. The procedure --
1974: -- called are --
1975: -- pay_apac_payslip_archive.archive_user_balances --
1976: -- pay_apac_payslip_archive.archive_user_elements --
1977: -- archive_stat_balances --
1978: -- archive_stat_elements --
1979: -- archive_employee_details --
1972: -- Description : Procedure to call the internal procedures to --
1973: -- actually the archive the data. The procedure --
1974: -- called are --
1975: -- pay_apac_payslip_archive.archive_user_balances --
1976: -- pay_apac_payslip_archive.archive_user_elements --
1977: -- archive_stat_balances --
1978: -- archive_stat_elements --
1979: -- archive_employee_details --
1980: -- archive_accrual_details --
2124: --
2125: -- Call to procedure to archive User Configurable Balances
2126: --
2127:
2128: pay_apac_payslip_archive.archive_user_balances
2129: (
2130: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action id
2131: ,p_run_assignment_action_id => csr_rec.run_assignment_action_id -- payroll assignment action id
2132: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effecive date
2136: --
2137: -- Call to procedure to archive User Configurable Elements
2138: --
2139:
2140: pay_apac_payslip_archive.archive_user_elements
2141: (
2142: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action
2143: ,p_pre_assignment_action_id => csr_rec.pre_assignment_action_id -- prepayment assignment action id
2144: ,p_latest_run_assact_id => csr_rec.run_assignment_action_id -- payroll assignment action id