[Home] [Help]
102: l_procedure varchar2(200) ;
103:
104: begin
105:
106: g_debug :=hr_utility.debug_enabled ;
107:
108: if g_debug then
109: l_procedure := g_package||'range_code';
110: hr_utility.set_location('Entering '||l_procedure,1);
106: g_debug :=hr_utility.debug_enabled ;
107:
108: if g_debug then
109: l_procedure := g_package||'range_code';
110: hr_utility.set_location('Entering '||l_procedure,1);
111: end if ;
112:
113: -- Archive the payroll action level data and EIT defintions.
114: -- sql string to SELECT a range of assignments eligible for archival.
119: ' and p.business_group_id = pa.business_group_id' ||
120: ' order by p.person_id';
121:
122: if g_debug then
123: hr_utility.set_location('Leaving '||l_procedure,1000);
124: end if;
125:
126: end range_code;
127:
200: l_procedure varchar2(200) ;
201:
202: begin
203:
204: g_debug :=hr_utility.debug_enabled ;
205: if g_debug then
206: l_procedure := g_package||'initialization_code';
207: hr_utility.set_location('Entering '||l_procedure,1);
208: end if;
203:
204: g_debug :=hr_utility.debug_enabled ;
205: if g_debug then
206: l_procedure := g_package||'initialization_code';
207: hr_utility.set_location('Entering '||l_procedure,1);
208: end if;
209:
210: g_balance_value_tab.delete;
211:
224: g_tax_unit_id := g_parameters.legal_employer;
225:
226: if g_debug
227: then
228: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
225:
226: if g_debug
227: then
228: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
226: if g_debug
227: then
228: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
227: then
228: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
228: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
229: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
230: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
231: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
239: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
232: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
239: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
240: end if;
233: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
239: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
240: end if;
241:
234: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
239: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
240: end if;
241:
242: /* SET FBT Defined_balance ID */
235: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
236: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
237: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
238: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
239: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
240: end if;
241:
242: /* SET FBT Defined_balance ID */
243: If g_fbt_defined_balance_id is null OR g_fbt_defined_balance_id =0 Then
255: END LOOP;
256:
257:
258: IF g_debug THEN
259: hr_utility.trace('Defined Balance ids for YTD dimension');
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
256:
257:
258: IF g_debug THEN
259: hr_utility.trace('Defined Balance ids for YTD dimension');
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
257:
258: IF g_debug THEN
259: hr_utility.trace('Defined Balance ids for YTD dimension');
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
258: IF g_debug THEN
259: hr_utility.trace('Defined Balance ids for YTD dimension');
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
259: hr_utility.trace('Defined Balance ids for YTD dimension');
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
260: hr_utility.trace('-------------------------------------');
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
261: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
262: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
263: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
264: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
265: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
266: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
267: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
268: hr_utility.trace('Voluntary Deductionsn ===>' || g_balance_value_tab(7).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
269: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
270: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
271: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
272: hr_utility.trace('Lump Sum A Payments ===>' || g_balance_value_tab(11).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
273: hr_utility.trace('Lump Sum B Payments ===>' || g_balance_value_tab(12).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
274: hr_utility.trace('Lump Sum C Payments ===>' || g_balance_value_tab(13).defined_balance_id);
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
282: end if;
275: hr_utility.trace('Lump Sum D Payments ===>' || g_balance_value_tab(14).defined_balance_id);
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
282: end if;
283:
276: hr_utility.trace('Lump Sum E Payments ===>' || g_balance_value_tab(15).defined_balance_id);
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
282: end if;
283:
284: if g_debug then
277: hr_utility.trace('Invalidity Payments ===>' || g_balance_value_tab(16).defined_balance_id);
278: hr_utility.trace('CDEP ===>' || g_balance_value_tab(17).defined_balance_id);
279: hr_utility.trace('Leave Payments Marginal===>' || g_balance_value_tab(18).defined_balance_id);
280: hr_utility.trace('Other Income ===>' || g_balance_value_tab(19).defined_balance_id);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
282: end if;
283:
284: if g_debug then
285: hr_utility.set_location('Leaving '||l_procedure,1000);
281: hr_utility.trace('Union Fees ===>' || g_balance_value_tab(20).defined_balance_id);
282: end if;
283:
284: if g_debug then
285: hr_utility.set_location('Leaving '||l_procedure,1000);
286: end if;
287:
288: exception
289: when others then
286: end if;
287:
288: exception
289: when others then
290: hr_utility.set_location('Error in '||l_procedure,999999);
291: raise;
292: end initialization_code;
293:
294:
330: l_report_type VARCHAR2(50);
331:
332: BEGIN
333:
334: g_debug := hr_utility.debug_enabled;
335:
336: IF g_debug
337: THEN
338: hr_utility.set_location('range_person_on',10);
334: g_debug := hr_utility.debug_enabled;
335:
336: IF g_debug
337: THEN
338: hr_utility.set_location('range_person_on',10);
339: END IF;
340:
341: BEGIN
342:
345: close csr_action_parameter;
346:
347: IF g_debug
348: THEN
349: hr_utility.set_location('range_person_on',20);
350: END IF;
351:
352: IF p_report_mode = 'S'
353: THEN
361: fetch csr_range_format_param into l_report_param_val;
362: close csr_range_format_param;
363: IF g_debug
364: THEN
365: hr_utility.set_location('range_person_on',30);
366: END IF;
367: EXCEPTION WHEN NO_DATA_FOUND THEN
368: l_return := FALSE;
369: END;
369: END;
370: --
371: IF g_debug
372: THEN
373: hr_utility.set_location('range_person_on',40);
374: END IF;
375:
376: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
377: l_return := TRUE;
377: l_return := TRUE;
378:
379: IF g_debug
380: THEN
381: hr_utility.trace('Range Person = True');
382: END IF;
383: ELSE
384: l_return := FALSE;
385: END IF;
688: l_lst_fbt_yr_start date;
689:
690: begin
691:
692: g_debug :=hr_utility.debug_enabled;
693: if g_debug
694: then
695: l_procedure := '.assignment_action_code';
696: hr_utility.set_location('Entering '||l_procedure,1);
692: g_debug :=hr_utility.debug_enabled;
693: if g_debug
694: then
695: l_procedure := '.assignment_action_code';
696: hr_utility.set_location('Entering '||l_procedure,1);
697: end if;
698:
699: g_arc_payroll_action_id := p_payroll_action_id;
700:
725: end if;
726:
727: if g_debug
728: then
729: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
726:
727: if g_debug
728: then
729: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
727: if g_debug
728: then
729: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
728: then
729: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
729: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
730: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
731: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
732: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
733: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
734: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
735: hr_utility.set_location('g_parameters.assignment_id.........= ' || g_parameters.assignment_id,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
736: hr_utility.set_location('g_parameters.fin_year_start_date..............= ' || g_parameters.fin_year_start_date,30);
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
744: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
737: hr_utility.set_location('g_parameters.fin_year_end_date................= ' || g_parameters.fin_year_end_date,30);
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
744: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
745: end if;
738: hr_utility.set_location('g_parameters.fbt_year_start_date..............= ' || g_parameters.fbt_year_start_date,30);
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
744: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
745: end if;
746:
739: hr_utility.set_location('g_parameters.fbt_year_end_date................= ' || g_parameters.fbt_year_end_date,30);
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
744: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
745: end if;
746:
747: /* SET FBT Defined_balance ID */
740: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
741: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30); /*Bug 4142159*/
742: hr_utility.set_location('l_lst_yr_start.........................='||l_lst_yr_start,30);
743: hr_utility.set_location('l_lst_fbt_yr_start.....................='||l_lst_fbt_yr_start,30);
744: hr_utility.set_location('g_parameters.report_mode..........= '||g_parameters.report_mode,30); /*Bug 3891577*/
745: end if;
746:
747: /* SET FBT Defined_balance ID */
748: If g_fbt_defined_balance_id is null OR g_fbt_defined_balance_id =0 Then
775: fetch csr_next_action_id into l_next_assignment_action_id;
776: close csr_next_action_id;
777:
778: IF g_debug THEN
779: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
780: END if;
781:
782: hr_nonrun_asact.insact(l_next_assignment_action_id,
783: csr_rec.assignment_id,
816: fetch csr_next_action_id into l_next_assignment_action_id;
817: close csr_next_action_id;
818:
819: IF g_debug THEN
820: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
821: END if;
822:
823: hr_nonrun_asact.insact(l_next_assignment_action_id,
824: csr_rec.assignment_id,
852: fetch csr_next_action_id into l_next_assignment_action_id;
853: close csr_next_action_id;
854:
855: IF g_debug THEN
856: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
857: END if;
858:
859: hr_nonrun_asact.insact(l_next_assignment_action_id,
860: csr_rec.assignment_id,
866: END IF; /* End Range Person Check */
867: END IF;
868:
869: if g_debug then
870: hr_utility.set_location('Leaving '||l_procedure,1000);
871: end if;
872: exception
873: when others then
874: hr_utility.set_location('Error in '||l_procedure,999999);
870: hr_utility.set_location('Leaving '||l_procedure,1000);
871: end if;
872: exception
873: when others then
874: hr_utility.set_location('Error in '||l_procedure,999999);
875: raise;
876: end assignment_action_code;
877:
878: --------------------------------------------------------------------+
1088: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
1089:
1090: begin
1091:
1092: g_debug :=hr_utility.debug_enabled ;
1093:
1094: if g_debug then
1095: l_procedure := g_package||'archive_code';
1096: hr_utility.set_location('Entering '||l_procedure,300);
1092: g_debug :=hr_utility.debug_enabled ;
1093:
1094: if g_debug then
1095: l_procedure := g_package||'archive_code';
1096: hr_utility.set_location('Entering '||l_procedure,300);
1097: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1098: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1099: end if;
1100:
1093:
1094: if g_debug then
1095: l_procedure := g_package||'archive_code';
1096: hr_utility.set_location('Entering '||l_procedure,300);
1097: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1098: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1099: end if;
1100:
1101: if (g_parameters.lst_year_term ='Y' or g_parameters.lst_year_term is NULL )
1094: if g_debug then
1095: l_procedure := g_package||'archive_code';
1096: hr_utility.set_location('Entering '||l_procedure,300);
1097: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1098: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1099: end if;
1100:
1101: if (g_parameters.lst_year_term ='Y' or g_parameters.lst_year_term is NULL )
1102: then
1114: fetch c_employee_details into l_employee_details;
1115: if c_employee_details%notfound
1116: then
1117: if g_debug then
1118: hr_utility.set_location('No Employee details found!!',3002);
1119: end if;
1120: end if;
1121: close c_employee_details;
1122:
1197: g_allowance_balance_value := 0;
1198:
1199:
1200: if g_debug then
1201: hr_utility.set_location('Assignment_id' ||l_employee_details.assignment_id,300);
1202: end if;
1203:
1204: open get_max_action(l_employee_details.assignment_id,g_start_date,g_end_date,g_tax_unit_id);
1205: fetch get_max_action into l_assignment_action_id,l_action_sequence;
1211: end if;
1212: close get_max_action;
1213:
1214: if g_debug then
1215: hr_utility.set_location('Assignment_ACTION_id ' ||l_assignment_action_id,300);
1216: end if;
1217:
1218: if ( l_employee_details.actual_termination_date is NOT NULL
1219: and l_employee_details.actual_termination_date
1224: /* Archive only FBT Balance - Set all other Balance Values to 0 */
1225:
1226: if g_debug
1227: then
1228: hr_utility.set_location('FBT Employee Assignment ID======.....'||l_employee_details.assignment_id,300);
1229: end if;
1230:
1231: get_fbt_balance(p_assignment_id => l_employee_details.assignment_id
1232: ,p_start_date => add_months(g_start_date,-3)
1235: );
1236:
1237: if g_debug
1238: then
1239: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,300);
1240: end if;
1241:
1242: g_result_table.delete;
1243: FOR i in 1..21
1268: p_output_table=>g_result_table);
1269:
1270: else
1271: if g_debug then
1272: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);
1273: end if;
1274: end if;
1275:
1276: if g_debug
1274: end if;
1275:
1276: if g_debug
1277: then
1278: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1275:
1276: if g_debug
1277: then
1278: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1276: if g_debug
1277: then
1278: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1277: then
1278: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1278: hr_utility.set_location('FBT Balance Value ======.....'||g_fbt_balance_value,100);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1279: hr_utility.trace('Balance values for YTD dimension');
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1280: hr_utility.trace('-------------------------------------');
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1281: hr_utility.trace('Earnings_Total ===>'||g_result_table(1).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1282: hr_utility.trace('Workplace Giving Deductions ===>' || g_balance_value_tab(21).defined_balance_id);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1283: hr_utility.trace('Direct Payments ===>'||g_result_table(2).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1284: hr_utility.trace('Termination_Payments ===>'||g_result_table(3).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1285: hr_utility.trace('Involuntary Deductions ===>'||g_result_table(4).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1286: hr_utility.trace('Pre Tax Deductions ===>'||g_result_table(5).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1287: hr_utility.trace('Termination Deductions ===>'||g_result_table(6).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1288: hr_utility.trace('Voluntary Deductions ===>'||g_result_table(7).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1289: hr_utility.trace('Total_Tax_Deduction ===>'||g_result_table(8).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1290: hr_utility.trace('Earnings_Non_Taxable ===>'||g_result_table(9).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1291: hr_utility.trace('Employer_Charges ===>'||g_result_table(10).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1292: hr_utility.trace('Lump Sum A Payments ===>'||g_result_table(11).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1293: hr_utility.trace('Lump Sum B Payments ===>'||g_result_table(12).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1301: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1294: hr_utility.trace('Lump Sum C Payments ===>'||g_result_table(13).balance_value);
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1301: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1302: end if;
1295: hr_utility.trace('Lump Sum D Payments ===>'||g_result_table(14).balance_value);
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1301: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1302: end if;
1303:
1296: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1301: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1302: end if;
1303:
1304: /* Call procedure to Adjust Lump SUM E Payments Value
1297: hr_utility.trace('Invalidity Payments ===>'||g_result_table(16).balance_value);
1298: hr_utility.trace('CDEP ===>'||g_result_table(17).balance_value);
1299: hr_utility.trace('Leave Payments Marginal ===>'||g_result_table(18).balance_value);
1300: hr_utility.trace('Other Income ===>'||g_result_table(19).balance_value);
1301: hr_utility.trace('Union Fees ===>'||g_result_table(20).balance_value);
1302: end if;
1303:
1304: /* Call procedure to Adjust Lump SUM E Payments Value
1305: */
1309: Adjust_lumpsum_E_payments(l_employee_details.assignment_id);
1310:
1311: if g_debug
1312: then
1313: hr_utility.trace('Lump Sum E Payments ===>'||g_result_table(15).balance_value);
1314: end if;
1315:
1316: /* If Lump Sum C Payments get Pre-Post Ratios
1317: */
1377: ,l_post30jun1983_ratio
1378: ,l_action_sequence);
1379:
1380: if g_debug then
1381: hr_utility.set_location('Leaving '||l_procedure,300);
1382: end if;
1383:
1384: end archive_code;
1385:
1440: l_procedure varchar2(240);
1441:
1442: begin
1443:
1444: g_debug := hr_utility.debug_enabled;
1445:
1446: if g_debug then
1447: l_procedure := g_package||'.Get_fbt_balance' ;
1448: hr_utility.set_location('Entering '||l_procedure,400);
1444: g_debug := hr_utility.debug_enabled;
1445:
1446: if g_debug then
1447: l_procedure := g_package||'.Get_fbt_balance' ;
1448: hr_utility.set_location('Entering '||l_procedure,400);
1449: end if;
1450:
1451: open c_max_assignment_action_id(p_assignment_id,g_tax_unit_id,p_start_date,p_end_date);
1452: fetch c_max_assignment_action_id into l_max_assignment_action_id,l_max_action_sequence;
1482:
1483: g_fbt_balance_value := l_bal_value / (1 - (l_fbt_rate + l_med_levy));
1484:
1485: if g_debug then
1486: hr_utility.set_location('Fringe Balance Value got := '||l_bal_value,302);
1487: hr_utility.set_location('Value to be archived := '||g_fbt_balance_value,302);
1488: end if;
1489:
1490: p_action_sequence := l_max_action_sequence;
1483: g_fbt_balance_value := l_bal_value / (1 - (l_fbt_rate + l_med_levy));
1484:
1485: if g_debug then
1486: hr_utility.set_location('Fringe Balance Value got := '||l_bal_value,302);
1487: hr_utility.set_location('Value to be archived := '||g_fbt_balance_value,302);
1488: end if;
1489:
1490: p_action_sequence := l_max_action_sequence;
1491:
1489:
1490: p_action_sequence := l_max_action_sequence;
1491:
1492: if g_debug then
1493: hr_utility.set_location('Leaving '||l_procedure,400);
1494: end if;
1495:
1496: end;
1497:
1635: counter number;
1636:
1637: begin
1638:
1639: g_debug := hr_utility.debug_enabled;
1640: l_counter := 0;
1641: l_prev_bal_type_id := 0;
1642:
1643: g_balance_type_tab.delete;
1644:
1645: if g_debug
1646: then
1647: l_procedure := g_package||'Element_Details';
1648: hr_utility.set_location('Entering ' || l_procedure,500);
1649: end if;
1650:
1651: FOR csr_ele_det IN c_ps_element_details(p_assignment_id,g_business_group_id,g_tax_unit_id,g_start_date,g_end_date)
1652: LOOP
1652: LOOP
1653:
1654: if g_debug
1655: then
1656: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);
1657: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);
1658: end if;
1659:
1660: /* In case of Allowance,store the Balance Type ID's in PL/SQL table.
1653:
1654: if g_debug
1655: then
1656: hr_utility.set_location('Element Name '||csr_ele_det.element_name,500);
1657: hr_utility.set_location('Classification Name '||csr_ele_det.classification_name,500);
1658: end if;
1659:
1660: /* In case of Allowance,store the Balance Type ID's in PL/SQL table.
1661: Ensure the Balance Type ID is not duplicated in table.
1700: csr_ele_det.payment,
1701: p_assignment_id);
1702:
1703: if g_debug then
1704: hr_utility.set_location('After Inserting Element Values ',500);
1705: end if;
1706: END LOOP;
1707:
1708: p_allowance_exists := l_counter ;/* To Show Allowances Exist */
1717: 'Invalidity Payments ===>' g_result_table(16).balance_value
1718: */
1719:
1720: if g_debug then
1721: hr_utility.set_location('p_pre01jul1983_ratio........=>'||p_pre01jul1983_ratio,200);
1722: hr_utility.set_location('p_post30jun1983_ratio........=>'||p_post30jun1983_ratio,200);
1723: end if;
1724:
1725: counter := 0;
1718: */
1719:
1720: if g_debug then
1721: hr_utility.set_location('p_pre01jul1983_ratio........=>'||p_pre01jul1983_ratio,200);
1722: hr_utility.set_location('p_post30jun1983_ratio........=>'||p_post30jun1983_ratio,200);
1723: end if;
1724:
1725: counter := 0;
1726: if (g_result_table(11).balance_value > 0)
1823: end loop;
1824: end if;
1825:
1826: if g_debug then
1827: hr_utility.set_location('Leaving '||l_procedure,500 );
1828: end if;
1829:
1830: end archive_element_details;
1831:
1894:
1895:
1896: begin
1897:
1898: g_debug := hr_utility.debug_enabled;
1899: if g_debug then
1900: l_procedure := 'Adjust_lumpsum_E_payments';
1901: hr_utility.set_location('In procedure '||g_package||l_procedure,600);
1902: end if;
1897:
1898: g_debug := hr_utility.debug_enabled;
1899: if g_debug then
1900: l_procedure := 'Adjust_lumpsum_E_payments';
1901: hr_utility.set_location('In procedure '||g_package||l_procedure,600);
1902: end if;
1903:
1904: /*'Lump Sum E Payments ===>' g_result_table(15).balance_value */
1905:
1927: g_result_table(15).balance_value := v_lump_sum_E_ytd;
1928: g_adjusted_lump_sum_e_pay := v_adj_lump_sum_E_ptd; /* Bug 4201894*/
1929:
1930: if g_debug then
1931: hr_utility.set_location('In procedure '||g_package||l_procedure,600);
1932: end if;
1933: end;
1934:
1935: --------------------------------------------------------------------+
1972:
1973:
1974: begin
1975:
1976: g_debug := hr_utility.debug_enabled;
1977:
1978: if g_debug then
1979: l_procedure := g_package||'.Get_allowance_balances';
1980: hr_utility.set_location('Entering '||l_procedure,700);
1976: g_debug := hr_utility.debug_enabled;
1977:
1978: if g_debug then
1979: l_procedure := g_package||'.Get_allowance_balances';
1980: hr_utility.set_location('Entering '||l_procedure,700);
1981: end if;
1982:
1983: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
1984: loop
1982:
1983: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
1984: loop
1985: if g_debug then
1986: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);
1987: end if;
1988:
1989: open c_allowance_balance(g_balance_type_tab(i));
1990: fetch c_allowance_balance into tab_allownace_balance(i).balance_name, allow_balance_value_tab(i).defined_balance_id; /* 4177630 */
1988:
1989: open c_allowance_balance(g_balance_type_tab(i));
1990: fetch c_allowance_balance into tab_allownace_balance(i).balance_name, allow_balance_value_tab(i).defined_balance_id; /* 4177630 */
1991: IF c_allowance_balance%NOTFOUND THEN
1992: hr_utility.set_location('Defined balanced id not found for balance type id :'||g_balance_type_tab(i),700); /* 4177630 */
1993: raise_application_error(-20101, 'Allowance Balance Type ' || g_balance_type_tab(i) || ' not associated with dimension _ASG_LE_YTD'); /* 4177630 */
1994: END IF;
1995: close c_allowance_balance;
1996:
2011: p_output_table=>allow_result_table);
2012:
2013: else
2014: if g_debug then
2015: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);
2016: end if;
2017: end if;
2018:
2019: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
2018:
2019: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
2020: loop
2021: if g_debug then
2022: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);
2023: end if;
2024:
2025: tab_allownace_balance(i).balance_value := allow_result_table(i).balance_value;
2026:
2041:
2042: g_allowance_balance_value := l_YTD_allowance;
2043:
2044: if g_debug then
2045: hr_utility.set_location('Set the Global Balance Value '||l_YTD_allowance,700);
2046: hr_utility.set_location('Leaving '||l_procedure,700);
2047: end if;
2048: end;
2049:
2042: g_allowance_balance_value := l_YTD_allowance;
2043:
2044: if g_debug then
2045: hr_utility.set_location('Set the Global Balance Value '||l_YTD_allowance,700);
2046: hr_utility.set_location('Leaving '||l_procedure,700);
2047: end if;
2048: end;
2049:
2050: --------------------------------------------------------------------+
2088: l_YTD_WORKPLACE_GIVING_DED number; /*4085496 */
2089:
2090: begin
2091:
2092: g_debug := hr_utility.debug_enabled;
2093: if g_debug then
2094: l_procedure := 'archive_balance_details';
2095: hr_utility.set_location('In procedure '||g_package||l_procedure,800);
2096: end if;
2091:
2092: g_debug := hr_utility.debug_enabled;
2093: if g_debug then
2094: l_procedure := 'archive_balance_details';
2095: hr_utility.set_location('In procedure '||g_package||l_procedure,800);
2096: end if;
2097: /*
2098: ===============================================================================================
2099: Balances for Archive are computed in the following manner,
2236: p_run_action_sequence,
2237: L_YTD_WORKPLACE_GIVING_DED); /* 4015082 */
2238:
2239: if g_debug then
2240: hr_utility.set_location('Leaving '||g_package||l_procedure,800);
2241: end if;
2242:
2243: end archive_balance_details;
2244:
2313:
2314: begin
2315: l_count :=0;
2316: ps_request_id :=-1;
2317: g_debug :=hr_utility.debug_enabled ;
2318:
2319: if g_debug then
2320: l_procedure := g_package||' spawn_archive_reports';
2321: hr_utility.set_location('Entering '||l_procedure,999);
2317: g_debug :=hr_utility.debug_enabled ;
2318:
2319: if g_debug then
2320: l_procedure := g_package||' spawn_archive_reports';
2321: hr_utility.set_location('Entering '||l_procedure,999);
2322: end if;
2323:
2324: -- Set User Parameters for Report.
2325:
2351: l_negative_records := 'N'; /* Do not Suppress Records with Negative Earnings */
2352: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
2353:
2354: if g_debug then
2355: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2352: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
2353:
2354: if g_debug then
2355: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2353:
2354: if g_debug then
2355: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2354: if g_debug then
2355: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2355: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2356: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2357: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2358: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2359: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2360: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2361: hr_utility.set_location('in zero records'||l_zero_records,911);
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2369: end if;
2362: hr_utility.set_location('in Negative records'||l_negative_records,912);
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2369: end if;
2370:
2363: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2369: end if;
2370:
2371: if g_debug then
2364: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2365: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2366: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2367: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919); /*Bug 4142159*/
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2369: end if;
2370:
2371: if g_debug then
2372: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2368: hr_utility.set_location('In Output Type '||l_parameters.p_output_type,920);
2369: end if;
2370:
2371: if g_debug then
2372: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2373: hr_utility.set_location('Before calling report',900);
2374: end if;
2375:
2376: OPEN csr_get_print_options(p_payroll_action_id);
2369: end if;
2370:
2371: if g_debug then
2372: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2373: hr_utility.set_location('Before calling report',900);
2374: end if;
2375:
2376: OPEN csr_get_print_options(p_payroll_action_id);
2377: FETCH csr_get_print_options INTO rec_print_options;
2387: save_output => hr_general.char_to_bool(rec_print_options.save_output),
2388: print_together => l_print_together);
2389: -- Submit report
2390: if g_debug then
2391: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);
2392: end if;
2393:
2394: ps_request_id := fnd_request.submit_request
2395: ('PAY',
2433: NULL, NULL, NULL, NULL, NULL, NULL,
2434: NULL, NULL, NULL, NULL
2435: );
2436: if g_debug then
2437: hr_utility.set_location('After calling report',900);
2438: end if;
2439:
2440: end;
2441:
2487: l_procedure varchar2(80);
2488:
2489: begin
2490: l_counter := 0;
2491: g_debug := hr_utility.debug_enabled ;
2492: g_balance_type_tab.delete;
2493:
2494: if g_debug then
2495: l_procedure := g_package||' summary_rep_populate_allowance';
2492: g_balance_type_tab.delete;
2493:
2494: if g_debug then
2495: l_procedure := g_package||' summary_rep_populate_allowance';
2496: hr_utility.set_location('Entering '||l_procedure,999);
2497: end if;
2498:
2499: FOR csr_bal in get_allowance_balance_types(p_assignment_id
2500: ,g_start_date
2507:
2508: p_allowance_exists := l_counter;
2509:
2510: if g_debug then
2511: hr_utility.set_location('Leaving '||l_procedure,999);
2512: end if;
2513:
2514: end summary_rep_populate_allowance;
2515:
2571:
2572: begin
2573: l_count :=0;
2574: ps_request_id :=-1;
2575: g_debug :=hr_utility.debug_enabled ;
2576:
2577: if g_debug then
2578: l_procedure := g_package||' spawn_summary_archive_reports';
2579: hr_utility.set_location('Entering '||l_procedure,999);
2575: g_debug :=hr_utility.debug_enabled ;
2576:
2577: if g_debug then
2578: l_procedure := g_package||' spawn_summary_archive_reports';
2579: hr_utility.set_location('Entering '||l_procedure,999);
2580: end if;
2581:
2582: -- Set User Parameters for Report.
2583:
2591: l_negative_records := 'N'; /* Do not Suppress Records with Negative Earnings */
2592: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
2593:
2594: if g_debug then
2595: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2592: l_zero_records:= 'N'; /* Do not Suppress Records with Zero Earnings */
2593:
2594: if g_debug then
2595: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2593:
2594: if g_debug then
2595: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2594: if g_debug then
2595: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2595: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,900);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2596: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,901);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2597: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,903);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2598: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,904);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2599: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,908);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2600: hr_utility.set_location('in YTD totals '||l_ytd_totals,910);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2601: hr_utility.set_location('in zero records'||l_zero_records,911);
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2609: end if;
2602: hr_utility.set_location('in Negative records'||l_negative_records,912);
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2609: end if;
2610:
2603: hr_utility.set_location('in emp_type '||l_parameters.employee_type,914);
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2609: end if;
2610:
2611: if g_debug then
2604: hr_utility.set_location('In Start Date '||l_parameters.fin_year_start_date,916);
2605: hr_utility.set_location('In End Date '||l_parameters.fin_year_end_date,917);
2606: hr_utility.set_location('In Last Year Term'||l_parameters.lst_year_term,918);
2607: hr_utility.set_location('In Delete Actions'||l_parameters.delete_actions,919);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2609: end if;
2610:
2611: if g_debug then
2612: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2608: hr_utility.set_location('In Report Mode'||l_parameters.report_mode,920);
2609: end if;
2610:
2611: if g_debug then
2612: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2613: hr_utility.set_location('Before calling report',900);
2614: end if;
2615:
2616: OPEN csr_get_print_options(p_payroll_action_id);
2609: end if;
2610:
2611: if g_debug then
2612: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 900);
2613: hr_utility.set_location('Before calling report',900);
2614: end if;
2615:
2616: OPEN csr_get_print_options(p_payroll_action_id);
2617: FETCH csr_get_print_options INTO rec_print_options;
2627: save_output => hr_general.char_to_bool(rec_print_options.save_output),
2628: print_together => l_print_together);
2629: -- Submit report
2630: if g_debug then
2631: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,900);
2632: end if;
2633:
2634: ps_request_id := fnd_request.submit_request
2635: ('PAY',
2673: NULL, NULL, NULL, NULL, NULL, NULL,
2674: NULL, NULL, NULL, NULL
2675: );
2676: if g_debug then
2677: hr_utility.set_location('After calling report',900);
2678: end if;
2679:
2680: end spawn_summary_reports;
2681: