APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_APAC_PAYSLIP_ARCHIVE

Line 13: -- It calls pay_apac_payslip_archive.range_code that archives the EIT

9:
10: --------------------------------------------------------------------+
11: -- This procedure returns a sql string to SELECT a range
12: -- of assignments eligible for archival.
13: -- It calls pay_apac_payslip_archive.range_code that archives the EIT
14: -- definition and payroll level data (Messages, employer address details etc)
15: -- Major changes were made to the procedure as part of
16: -- fix for bug 3580587
17: --------------------------------------------------------------------+

Line 27: -- Call to range_code from common apac package 'pay_apac_payslip_archive'

23: BEGIN
24:
25: hr_utility.set_location('Start of range_code',1);
26: --------------------------------------------------------------------------------+
27: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
28: -- to archive the payroll action level data and EIT defintions.
29: --------------------------------------------------------------------------------+
30: pay_apac_payslip_archive.range_code( p_payroll_action_id => p_payroll_action_id );
31: --

Line 30: pay_apac_payslip_archive.range_code( p_payroll_action_id => p_payroll_action_id );

26: --------------------------------------------------------------------------------+
27: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
28: -- to archive the payroll action level data and EIT defintions.
29: --------------------------------------------------------------------------------+
30: pay_apac_payslip_archive.range_code( p_payroll_action_id => p_payroll_action_id );
31: --
32: pay_core_payslip_utils.range_cursor( p_payroll_action_id,
33: p_sql
34: );

Line 61: -- Call to common package procedure pay_apac_payslip_archive.

57:
58: g_archive_pact := p_payroll_action_id;
59:
60: ------------------------------------------------------------------+
61: -- Call to common package procedure pay_apac_payslip_archive.
62: -- initialization_code to to set the global tables for EIT
63: -- that will be used by each thread in multi-threading.
64: ------------------------------------------------------------------+
65:

Line 66: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);

62: -- initialization_code to to set the global tables for EIT
63: -- that will be used by each thread in multi-threading.
64: ------------------------------------------------------------------+
65:
66: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);
67:
68: hr_utility.set_location('End of initialization_code',2);
69:
70: EXCEPTION

Line 770: -- pay_apac_payslip_archive.archive_user_elements

766: -- Procedure to call the internal procedures to actually
767: -- the archive the data. The procedure called are -
768: -- archive_accrual_details
769: -- archive_employee_details
770: -- pay_apac_payslip_archive.archive_user_elements
771: -- archive_stat_balances
772: -- archive_cpf_balances
773: -- archive_stat_elements
774: -- pay_apac_payslip_archive.archive_user_balances

Line 774: -- pay_apac_payslip_archive.archive_user_balances

770: -- pay_apac_payslip_archive.archive_user_elements
771: -- archive_stat_balances
772: -- archive_cpf_balances
773: -- archive_stat_elements
774: -- pay_apac_payslip_archive.archive_user_balances
775: -- Major changes were made to the procedure as part of
776: -- fix for bug 3580587
777: --------------------------------------------------------------------+
778:

Line 875: pay_apac_payslip_archive.archive_user_balances(

871: -- Loop to be executed only once for a prepayment with latest payroll run details
872: -- in the prepayment
873: IF l_pre_pay_assact_id <> csr_rec.pre_assignment_action_id THEN
874: -- Call to procedure to archive User Configurable Balnaces
875: pay_apac_payslip_archive.archive_user_balances(
876: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id, -- archive assignment action id
877: p_run_assignment_action_id => csr_rec.run_assignment_action_id, -- payroll assignment action id
878: p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effecive date
879: );

Line 896: pay_apac_payslip_archive.archive_user_elements (

892: p_effective_date => csr_rec.pre_effective_date, -- prepayment effective date
893: p_assact_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action id
894: );
895: -- Call to procedure to archive User Configurable Elements
896: pay_apac_payslip_archive.archive_user_elements (
897: p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id, -- archive assignment action
898: p_pre_assignment_action_id => csr_rec.pre_assignment_action_id, -- prepayment assignment action id
899: p_latest_run_assact_id => csr_rec.run_assignment_action_id, -- payroll assignment action id
900: p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effective date