DBA Data[Home] [Help]

APPS.PAY_SE_HCIA_ARCHIVE dependencies on PAY_SE_HCIA_ARCHIVE

Line 1: PACKAGE BODY pay_se_hcia_archive AS

1: PACKAGE BODY pay_se_hcia_archive AS
2: /* $Header: pysehcia.pkb 120.0.12000000.1 2007/07/18 10:57:48 psingla noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2 (33) := 'PAY_SE_HCIA_ARCHIVE.';
5: g_payroll_action_id NUMBER;

Line 4: g_package VARCHAR2 (33) := 'PAY_SE_HCIA_ARCHIVE.';

1: PACKAGE BODY pay_se_hcia_archive AS
2: /* $Header: pysehcia.pkb 120.0.12000000.1 2007/07/18 10:57:48 psingla noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2 (33) := 'PAY_SE_HCIA_ARCHIVE.';
5: g_payroll_action_id NUMBER;
6: -- Globals to pick up all the parameter
7: g_business_group_id NUMBER;
8: g_effective_date DATE;

Line 88: pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),

84: p_payroll_action_id NUMBER
85: ) IS
86: SELECT to_number (
87: substr (
88: pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
89: 1,
90: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
91: )
92: ) legal,

Line 90: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1

86: SELECT to_number (
87: substr (
88: pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
89: 1,
90: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
91: )
92: ) legal,
93: substr (
94: pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),

Line 94: pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),

90: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
91: )
92: ) legal,
93: substr (
94: pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
95: 1,
96: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
97: ) request_for,
98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,

Line 96: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1

92: ) legal,
93: substr (
94: pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
95: 1,
96: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
97: ) request_for,
98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
99: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
100: eff_end_date,

Line 98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,

94: pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
95: 1,
96: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
97: ) request_for,
98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
99: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
100: eff_end_date,
101: effective_date effective_date, business_group_id bg_id
102: FROM pay_payroll_actions

Line 99: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))

95: 1,
96: LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
97: ) request_for,
98: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
99: (pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
100: eff_end_date,
101: effective_date effective_date, business_group_id bg_id
102: FROM pay_payroll_actions
103: WHERE payroll_action_id = p_payroll_action_id;

Line 242: pay_se_hcia_archive.get_all_parameters (

238: g_business_group_id := NULL;
239: g_effective_date := NULL;
240: g_legal_employer_id := NULL;
241: g_local_unit_id := NULL;
242: pay_se_hcia_archive.get_all_parameters (
243: p_payroll_action_id,
244: g_business_group_id,
245: g_effective_date,
246: g_legal_employer_id,

Line 440: END pay_se_hcia_archive;

436: IF g_debug THEN
437: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
438: END IF;
439: END archive_code;
440: END pay_se_hcia_archive;