APPS.PAY_NO_ARC_RSEA_07 dependencies on PAY_NO_ARC_RSEA_07

Line 1: PACKAGE BODY PAY_NO_ARC_RSEA_07 AS

1: PACKAGE BODY PAY_NO_ARC_RSEA_07 AS
2: /* $Header: pynorse7.pkb 120.3.12020000.7 2013/03/22 09:18:07 smeduri ship $ */
3: --
4: -- -----------------------------------------------------------------------------
5: -- Data types.

Line 21: g_package VARCHAR2(33) := ' PAY_NO_ARC_RSEA_07.';

17: -- -----------------------------------------------------------------------------
18: --
19: g_xml_element_table t_xml_element_table;
20: g_debug boolean := hr_utility.debug_enabled;
21: g_package VARCHAR2(33) := ' PAY_NO_ARC_RSEA_07.';
22: g_err_num NUMBER;
23: g_errm VARCHAR2(150);
24: --
25: -- -----------------------------------------------------------------------------

Line 260: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')

256: ,p_employee_id out NOCOPY NUMBER -- 14260836
257: ) IS
258:
259: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
260: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
261: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
263: ,effective_date
264: ,business_group_id

Line 261: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')

257: ) IS
258:
259: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
260: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
261: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
263: ,effective_date
264: ,business_group_id
265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix

Line 262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')

258:
259: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
260: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
261: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
263: ,effective_date
264: ,business_group_id
265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix
266: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'EMPLOYEE_NAME') -- 14260836

Line 265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix

261: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
263: ,effective_date
264: ,business_group_id
265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix
266: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'EMPLOYEE_NAME') -- 14260836
267: FROM pay_payroll_actions
268: WHERE payroll_action_id = p_payroll_action_id;
269: --

Line 266: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'EMPLOYEE_NAME') -- 14260836

262: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
263: ,effective_date
264: ,business_group_id
265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix
266: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'EMPLOYEE_NAME') -- 14260836
267: FROM pay_payroll_actions
268: WHERE payroll_action_id = p_payroll_action_id;
269: --
270: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';

Line 740: pay_no_arc_rsea_07.get_all_parameters(p_payroll_action_id

736: WHERE ppa.payroll_action_id = :payroll_action_id
737: AND ppa.business_group_id = ppf.business_group_id
738: ORDER BY ppf.person_id';
739: --
740: pay_no_arc_rsea_07.get_all_parameters(p_payroll_action_id
741: ,l_business_group_id
742: ,l_legal_employer_id
743: ,l_local_unit_id
744: ,l_effective_date

Line 2658: END PAY_NO_ARC_RSEA_07;

2654: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2655: --
2656: END get_xml_rep;
2657: --
2658: END PAY_NO_ARC_RSEA_07;