DBA Data[Home] [Help]

APPS.PAY_SE_SLSA_ARCHIVE dependencies on PAY_SE_SLSA_ARCHIVE

Line 1: PACKAGE BODY pay_se_slsa_archive AS

1: PACKAGE BODY pay_se_slsa_archive AS
2: /* $Header: pyseslsa.pkb 120.1 2007/08/21 05:29:27 psingla noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2 (33) := 'PAY_SE_SLSA_ARCHIVE.';
5: g_payroll_action_id NUMBER;

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

1: PACKAGE BODY pay_se_slsa_archive AS
2: /* $Header: pyseslsa.pkb 120.1 2007/08/21 05:29:27 psingla noship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4: g_package VARCHAR2 (33) := 'PAY_SE_SLSA_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 98: pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),

94: p_payroll_action_id NUMBER
95: ) IS
96: SELECT to_number (
97: substr (
98: pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
99: 1,
100: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
101: )
102: ) legal,

Line 100: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1

96: SELECT to_number (
97: substr (
98: pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
99: 1,
100: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
101: )
102: ) legal,
103: substr (
104: pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),

Line 104: pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),

100: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
101: )
102: ) legal,
103: substr (
104: pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
105: 1,
106: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
107: ) request_for,
108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,

Line 106: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1

102: ) legal,
103: substr (
104: pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
105: 1,
106: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
107: ) request_for,
108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
109: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
110: eff_end_date,

Line 108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,

104: pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
105: 1,
106: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
107: ) request_for,
108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
109: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
110: eff_end_date,
111: effective_date effective_date, business_group_id bg_id
112: FROM pay_payroll_actions

Line 109: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))

105: 1,
106: LENGTH (pay_se_slsa_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
107: ) request_for,
108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
109: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
110: eff_end_date,
111: effective_date effective_date, business_group_id bg_id
112: FROM pay_payroll_actions
113: WHERE payroll_action_id = p_payroll_action_id;

Line 933: pay_se_slsa_archive.get_all_parameters (

929: g_business_group_id := NULL;
930: g_effective_date := NULL;
931: g_legal_employer_id := NULL;
932: g_local_unit_id := NULL;
933: pay_se_slsa_archive.get_all_parameters (
934: p_payroll_action_id,
935: g_business_group_id,
936: g_effective_date,
937: g_legal_employer_id,

Line 1060: END pay_se_slsa_archive;

1056: IF g_debug THEN
1057: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1058: END IF;
1059: END archive_code;
1060: END pay_se_slsa_archive;