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.1 2007/08/20 09:23:18 kseth noship $ */
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 258: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')

254: ,p_archive OUT NOCOPY VARCHAR2
255: ) IS
256:
257: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
258: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
259: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
260: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
261: ,effective_date
262: ,business_group_id

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

255: ) IS
256:
257: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
258: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
259: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
260: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
261: ,effective_date
262: ,business_group_id
263: FROM pay_payroll_actions

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

256:
257: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
258: SELECT PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
259: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
260: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
261: ,effective_date
262: ,business_group_id
263: FROM pay_payroll_actions
264: WHERE payroll_action_id = p_payroll_action_id;

Line 701: pay_no_arc_rsea_07.get_all_parameters(p_payroll_action_id

697: WHERE ppa.payroll_action_id = :payroll_action_id
698: AND ppa.business_group_id = ppf.business_group_id
699: ORDER BY ppf.person_id';
700: --
701: pay_no_arc_rsea_07.get_all_parameters(p_payroll_action_id
702: ,l_business_group_id
703: ,l_legal_employer_id
704: ,l_local_unit_id
705: ,l_effective_date

Line 2323: END PAY_NO_ARC_RSEA_07;

2319: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2320: --
2321: END get_xml_rep;
2322: --
2323: END PAY_NO_ARC_RSEA_07;