DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_APAC_PAYSLIP_ARCHIVE

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

11:
12: --------------------------------------------------------------------+
13: -- This procedure returns a sql string to SELECT a range
14: -- of assignments eligible for archival.
15: -- It calls pay_apac_payslip_archive.range_code that archives the EIT
16: -- definition and payroll level data (Messages, employer address details etc)
17: --------------------------------------------------------------------+
18:
19: PROCEDURE range_code(p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

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

29: END IF;
30:
31:
32: --------------------------------------------------------------------------------+
33: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
34: -- to archive the payroll action level data and EIT defintions.
35: --------------------------------------------------------------------------------+
36:
37: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);

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

33: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
34: -- to archive the payroll action level data and EIT defintions.
35: --------------------------------------------------------------------------------+
36:
37: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);
38:
39: -- Bug#3580617 Replaced Dynamic SQL with a function sql.
40: pay_core_payslip_utils.range_cursor( p_payroll_action_id,
41: p_sql

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

73:
74: g_archive_pact := p_payroll_action_id;
75:
76: ------------------------------------------------------------------+
77: -- Call to common package procedure pay_apac_payslip_archive.
78: -- initialization_code to to set the global tables for EIT
79: -- that will be used by each thread in multi-threading.
80: ------------------------------------------------------------------+
81:

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

78: -- initialization_code to to set the global tables for EIT
79: -- that will be used by each thread in multi-threading.
80: ------------------------------------------------------------------+
81:
82: pay_apac_payslip_archive.initialization_code(p_payroll_action_id => p_payroll_action_id);
83:
84: IF g_debug THEN
85: hr_utility.set_location('End of initialization_code',2);
86: END IF;

Line 971: -- pay_apac_payslip_archive.archive_user_elements

967: -- Procedure to call the internal procedures to actually
968: -- the archive the data. The procedure called are -
969: -- archive_accrual_details
970: -- archive_employee_details
971: -- pay_apac_payslip_archive.archive_user_elements
972: -- archive_stat_balances
973: -- archive_stat_elements
974: -- pay_apac_payslip_archive.archive_user_balances
975: --------------------------------------------------------------------+

Line 974: -- pay_apac_payslip_archive.archive_user_balances

970: -- archive_employee_details
971: -- pay_apac_payslip_archive.archive_user_elements
972: -- archive_stat_balances
973: -- archive_stat_elements
974: -- pay_apac_payslip_archive.archive_user_balances
975: --------------------------------------------------------------------+
976:
977: PROCEDURE archive_code (p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
978: p_effective_date IN DATE) IS

Line 1093: pay_apac_payslip_archive.archive_user_balances

1089: IF l_pre_pay_assact_id <> csr_rec.pre_assignment_action_id THEN
1090:
1091: -- Call to procedure to archive User Configurable Balnaces
1092:
1093: pay_apac_payslip_archive.archive_user_balances
1094: ( p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action id
1095: , p_run_assignment_action_id => csr_rec.run_assignment_action_id -- payroll assignment action id
1096: , p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effecive date
1097: );

Line 1123: pay_apac_payslip_archive.archive_user_elements

1119:
1120:
1121: -- Call to procedure to archive User Configurable Elements
1122:
1123: pay_apac_payslip_archive.archive_user_elements
1124: ( p_arch_assignment_action_id => csr_rec.chld_arc_assignment_action_id -- archive assignment action
1125: , p_pre_assignment_action_id => csr_rec.pre_assignment_action_id -- prepayment assignment action id
1126: , p_latest_run_assact_id => csr_rec.run_assignment_action_id -- payroll assignment action id
1127: , p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effective date