APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on PAY_SE_HOLIDAY_PAY_DEBT

Line 1: PACKAGE BODY pay_se_holiday_pay_debt AS

1: PACKAGE BODY pay_se_holiday_pay_debt AS
2: /* $Header: pysehpdr.pkb 120.1 2010/10/28 08:58:29 vijranga ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (

Line 16: g_package VARCHAR2 (33) := 'PAY_SE_HOLIDAY_PAY_DEBT.';

12: g_lock_table lock_table;
13: g_index NUMBER := -1;
14: g_index_assact NUMBER := -1;
15: g_index_bal NUMBER := -1;
16: g_package VARCHAR2 (33) := 'PAY_SE_HOLIDAY_PAY_DEBT.';
17: g_payroll_action_id NUMBER;
18: g_arc_payroll_action_id NUMBER;
19: -- Globals to pick up all the parameter
20: g_business_group_id NUMBER;

Line 157: (pay_se_holiday_pay_debt.get_parameter

153: CURSOR csr_parameter_info (p_payroll_action_id NUMBER)
154: IS
155: SELECT TO_NUMBER
156: (SUBSTR
157: (pay_se_holiday_pay_debt.get_parameter
158: (legislative_parameters
159: , 'LEGAL_EMPLOYER'
160: )
161: , 1

Line 163: (pay_se_holiday_pay_debt.get_parameter

159: , 'LEGAL_EMPLOYER'
160: )
161: , 1
162: , LENGTH
163: (pay_se_holiday_pay_debt.get_parameter
164: (legislative_parameters
165: , 'LEGAL_EMPLOYER'
166: )
167: )

Line 172: (pay_se_holiday_pay_debt.get_parameter

168: - 1
169: )
170: ) legal
171: , SUBSTR
172: (pay_se_holiday_pay_debt.get_parameter
173: (legislative_parameters
174: , 'REQUEST_FOR'
175: )
176: , 1

Line 178: (pay_se_holiday_pay_debt.get_parameter

174: , 'REQUEST_FOR'
175: )
176: , 1
177: , LENGTH
178: (pay_se_holiday_pay_debt.get_parameter
179: (legislative_parameters
180: , 'REQUEST_FOR'
181: )
182: )

Line 185: , (pay_se_holiday_pay_debt.get_parameter

181: )
182: )
183: - 1
184: ) request_for
185: , (pay_se_holiday_pay_debt.get_parameter
186: (legislative_parameters
187: , 'EFFECTIVE_START_DATE'
188: )
189: ) eff_start_date

Line 190: , (pay_se_holiday_pay_debt.get_parameter

186: (legislative_parameters
187: , 'EFFECTIVE_START_DATE'
188: )
189: ) eff_start_date
190: , (pay_se_holiday_pay_debt.get_parameter
191: (legislative_parameters
192: , 'EFFECTIVE_END_DATE'
193: )
194: ) eff_end_date

Line 363: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id

359: g_effective_date := NULL;
360: g_pension_provider_id := NULL;
361: g_legal_employer_id := NULL;
362: g_local_unit_id := NULL;
363: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id
364: , g_business_group_id
365: , g_effective_date
366: , g_legal_employer_id
367: , g_request_for

Line 641: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id

637: );
638: END IF;
639:
640: fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');
641: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id
642: , g_business_group_id
643: , g_effective_date
644: , g_legal_employer_id
645: , g_request_for

Line 762: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id

758: g_payroll_action_id := p_payroll_action_id;
759: g_business_group_id := NULL;
760: g_effective_date := NULL;
761: g_legal_employer_id := NULL;
762: pay_se_holiday_pay_debt.get_all_parameters (p_payroll_action_id
763: , g_business_group_id
764: , g_effective_date
765: , g_legal_employer_id
766: , g_request_for

Line 1750: END pay_se_holiday_pay_debt;

1746: END IF; /* for p_payroll_action_id IS NULL */
1747:
1748: writetoclob (p_xml);
1749: END get_xml_for_report;
1750: END pay_se_holiday_pay_debt;