eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_ES_SS_REP_ARCHIVE_PKG

Line 1: PACKAGE BODY PER_ES_SS_REP_ARCHIVE_PKG AS

1: PACKAGE BODY PER_ES_SS_REP_ARCHIVE_PKG AS
2: /* $Header: peesssar.pkb 120.4 2006/03/02 01:10:21 kseth noship $ */
3:
4: --
5: -- Globals

Line 180: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'TEST_FLAG')

176: ,p_assignment_set_id OUT NOCOPY NUMBER) IS
177: --
178: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
179: SELECT effective_date
180: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'TEST_FLAG')
181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')
182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')
183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')
184: ,business_group_id

Line 181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')

177: --
178: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
179: SELECT effective_date
180: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'TEST_FLAG')
181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')
182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')
183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')
184: ,business_group_id
185: FROM pay_payroll_actions

Line 182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')

178: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
179: SELECT effective_date
180: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'TEST_FLAG')
181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')
182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')
183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')
184: ,business_group_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = p_payroll_action_id;

Line 183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')

179: SELECT effective_date
180: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'TEST_FLAG')
181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')
182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')
183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')
184: ,business_group_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = p_payroll_action_id;
187: --

Line 217: SELECT per_es_ss_rep_archive_pkg.get_parameter(legislative_parameters

213: ,p_arch_payroll_action_id OUT NOCOPY NUMBER
214: ,p_effective_end_date OUT NOCOPY DATE) IS
215: --
216: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
217: SELECT per_es_ss_rep_archive_pkg.get_parameter(legislative_parameters
218: ,'PAYROLL_ACTION_ID')
219: FROM pay_payroll_actions
220: WHERE payroll_action_id = p_payroll_action_id;
221: --

Line 308: per_es_ss_rep_archive_pkg.get_all_parameters (

304: l_unused_number := 0;
305: l_test_flag := 0;
306: -- Get the legislative parameters used in the call to prove the seed data
307: -- retrict the list of addresses
308: per_es_ss_rep_archive_pkg.get_all_parameters (
309: p_payroll_action_id => pactid
310: ,p_effective_end_date => g_effective_end_date
311: ,p_test_flag => g_test_flag
312: ,p_effective_date => g_effective_date

Line 606: per_es_ss_rep_archive_pkg.get_all_parameters (

602: BEGIN
603: --
604: l_unused_number := 0;
605: --
606: per_es_ss_rep_archive_pkg.get_all_parameters (
607: p_payroll_action_id => pactid
608: ,p_effective_end_date => g_effective_end_date
609: ,p_test_flag => g_test_flag
610: ,p_effective_date => g_effective_date

Line 651: PER_ES_SS_REP_ARCHIVE_PKG.ARCHIVE_CODE(qualifying_assignments.assignment_id, pactid, l_actid, g_effective_end_date);

647: ,pactid
648: ,chunk
649: ,NULL);
650: /* call the procedure that archives the FAB data into the table for that particular assignment id */
651: PER_ES_SS_REP_ARCHIVE_PKG.ARCHIVE_CODE(qualifying_assignments.assignment_id, pactid, l_actid, g_effective_end_date);
652: -- Check whether the employee is already archived or not
653: OPEN check_employee_exists (qualifying_assignments.assignment_id, l_actid);
654: FETCH check_employee_exists INTO l_unused_number;
655: CLOSE check_employee_exists;

Line 860: per_es_ss_rep_archive_pkg.get_disability_degree(p_assignment_id

856: OPEN csr_asg_status_type(l_asg_status_type_id);
857: FETCH csr_asg_status_type INTO l_system_status;
858: CLOSE csr_asg_status_type;
859: --
860: per_es_ss_rep_archive_pkg.get_disability_degree(p_assignment_id
861: ,p_effective_end_date
862: ,l_disability_degree);
863: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id
864: ,p_effective_end_date

Line 863: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id

859: --
860: per_es_ss_rep_archive_pkg.get_disability_degree(p_assignment_id
861: ,p_effective_end_date
862: ,l_disability_degree);
863: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id
864: ,p_effective_end_date
865: ,l_under_repres_women
866: ,l_rehired_disabled
867: ,l_unemployment_status

Line 1236: per_es_ss_rep_archive_pkg.get_disability_degree

1232: BEGIN
1233: OPEN csr_get_asg_values(p_assignment_id, p_effective_end_date);
1234: FETCH csr_get_asg_values INTO l_employee_category, l_collective_agreement;
1235: CLOSE csr_get_asg_values;
1236: per_es_ss_rep_archive_pkg.get_disability_degree
1237: (p_assignment_id
1238: ,p_effective_end_date
1239: ,l_disability_degree);
1240: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id

Line 1240: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id

1236: per_es_ss_rep_archive_pkg.get_disability_degree
1237: (p_assignment_id
1238: ,p_effective_end_date
1239: ,l_disability_degree);
1240: per_es_ss_rep_archive_pkg.get_ss_details(p_assignment_id
1241: ,p_effective_end_date
1242: ,l_under_repres_women
1243: ,l_rehired_disabled
1244: ,l_unemployment_status

Line 1303: PER_ES_SS_REP_ARCHIVE_PKG.get_disability_degree

1299: CLOSE csr_stat_leav_reas;
1300: END IF;
1301: CLOSE csr_stat_leav_reas_bgspec;
1302:
1303: PER_ES_SS_REP_ARCHIVE_PKG.get_disability_degree
1304: (p_assignment_id
1305: ,l_actual_date
1306: ,l_disability_degree_ter);
1307: PER_ES_SS_REP_ARCHIVE_PKG.get_ss_details(p_assignment_id

Line 1307: PER_ES_SS_REP_ARCHIVE_PKG.get_ss_details(p_assignment_id

1303: PER_ES_SS_REP_ARCHIVE_PKG.get_disability_degree
1304: (p_assignment_id
1305: ,l_actual_date
1306: ,l_disability_degree_ter);
1307: PER_ES_SS_REP_ARCHIVE_PKG.get_ss_details(p_assignment_id
1308: ,l_actual_date
1309: ,l_under_repres_women_ter
1310: ,l_rehired_disabled_ter
1311: ,l_unemployment_status_ter

Line 1457: PER_ES_SS_REP_ARCHIVE_PKG.get_all_parameters_lock (

1453: BEGIN
1454: --
1455: l_unused_number := 0;
1456: --
1457: PER_ES_SS_REP_ARCHIVE_PKG.get_all_parameters_lock (
1458: p_payroll_action_id => pactid
1459: ,p_arch_payroll_action_id => g_arch_payroll_action_id
1460: ,p_effective_end_date => g_effective_end_date);
1461: --

Line 1527: per_es_ss_rep_archive_pkg.get_all_parameters_lock (

1523: l_unused_number NUMBER;
1524: l_effective_start_date DATE;
1525: --
1526: BEGIN
1527: per_es_ss_rep_archive_pkg.get_all_parameters_lock (
1528: p_payroll_action_id => pactid
1529: ,p_arch_payroll_action_id => g_arch_payroll_action_id
1530: ,p_effective_end_date => g_effective_end_date);
1531: --

Line 1863: END per_es_ss_rep_archive_pkg;

1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: NULL;
1862: END action_creation_lock;
1863: END per_es_ss_rep_archive_pkg;