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 970: -- pay_apac_payslip_archive.archive_user_elements

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

Line 973: -- pay_apac_payslip_archive.archive_user_balances

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

Line 1092: pay_apac_payslip_archive.archive_user_balances

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

Line 1122: pay_apac_payslip_archive.archive_user_elements

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