[Home] [Help]
108: l_procedure varchar2(200) ;
109:
110: begin
111:
112: g_debug :=hr_utility.debug_enabled ;
113:
114: if g_debug then
115: l_procedure := g_package||'range_code';
116: hr_utility.set_location('Entering '||l_procedure,1);
112: g_debug :=hr_utility.debug_enabled ;
113:
114: if g_debug then
115: l_procedure := g_package||'range_code';
116: hr_utility.set_location('Entering '||l_procedure,1);
117: end if ;
118:
119: -- Archive the payroll action level data and EIT defintions.
120: -- sql string to SELECT a range of assignments eligible for archival.
125: ' and p.business_group_id = pa.business_group_id' ||
126: ' order by p.person_id';
127:
128: if g_debug then
129: hr_utility.set_location('Leaving '||l_procedure,1000);
130: end if;
131:
132: end range_code;
133:
215: /*Bug 4132149 - Modification ends here*/
216:
217: begin
218:
219: g_debug :=hr_utility.debug_enabled ;
220: if g_debug then
221: l_procedure := g_package||'initialization_code';
222: hr_utility.set_location('Entering '||l_procedure,1);
223: end if;
218:
219: g_debug :=hr_utility.debug_enabled ;
220: if g_debug then
221: l_procedure := g_package||'initialization_code';
222: hr_utility.set_location('Entering '||l_procedure,1);
223: end if;
224:
225:
226: /*Bug 4132149 - Modification begins here*/
237: CLOSE csr_params;
238:
239:
240: if g_debug then
241: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
238:
239:
240: if g_debug then
241: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
239:
240: if g_debug then
241: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
240: if g_debug then
241: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
241: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
242: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
243: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
244: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
245: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
246: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
247: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
255: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
248: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
255: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
256: end if;
249: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
255: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
256: end if;
257:
250: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
255: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
256: end if;
257:
258:
251: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
252: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
253: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
254: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
255: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
256: end if;
257:
258:
259: g_business_group_id := g_parameters.business_group_id ;
283:
284: pay_au_reconciliation_pkg.populate_defined_balance_ids('Y',g_parameters.legal_employer);
285:
286: if g_debug then
287: hr_utility.set_location('Leaving '||l_procedure,1000);
288: end if;
289:
290: exception
291: when others then
288: end if;
289:
290: exception
291: when others then
292: hr_utility.set_location('Error in '||l_procedure,999999);
293: raise;
294: end initialization_code;
295:
296: --------------------------------------------------------------------+
845:
846:
847: begin
848: i := 1;
849: g_debug :=hr_utility.debug_enabled ;
850:
851: if g_debug then
852: l_procedure := g_package||'assignment_action_code';
853: hr_utility.set_location('Entering ' || l_procedure,1);
849: g_debug :=hr_utility.debug_enabled ;
850:
851: if g_debug then
852: l_procedure := g_package||'assignment_action_code';
853: hr_utility.set_location('Entering ' || l_procedure,1);
854: hr_utility.set_location('Entering assignment_Action_code',302);
855: end if;
856:
857: -- initialization_code to to set the global tables for EIT
850:
851: if g_debug then
852: l_procedure := g_package||'assignment_action_code';
853: hr_utility.set_location('Entering ' || l_procedure,1);
854: hr_utility.set_location('Entering assignment_Action_code',302);
855: end if;
856:
857: -- initialization_code to to set the global tables for EIT
858: -- that will be used by each thread in multi-threading.
866: CLOSE csr_params;
867:
868:
869: if g_debug then
870: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
867:
868:
869: if g_debug then
870: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
868:
869: if g_debug then
870: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
869: if g_debug then
870: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
870: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
871: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
872: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
873: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
874: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
875: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
876: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
877: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
878: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
886: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
879: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
886: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
887: end if;
880: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
886: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
887: end if;
888:
881: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
886: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
887: end if;
888:
889:
882: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
883: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
884: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
885: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
886: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
887: end if;
888:
889:
890: g_business_group_id := g_parameters.business_group_id ;
929: close csr_next_action_id;
930:
931: if g_debug then
932:
933: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
934: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
935: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
936: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
937:
930:
931: if g_debug then
932:
933: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
934: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
935: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
936: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
937:
938: end if;
931: if g_debug then
932:
933: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
934: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
935: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
936: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
937:
938: end if;
939:
932:
933: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
934: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
935: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
936: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
937:
938: end if;
939:
940:
972:
973:
974: END LOOP;/* Loop 1 */
975: if g_debug then
976: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
977: end if;
978:
979: else
980: FOR csr_rec in csr_assignment_org_run(p_payroll_action_id,
990: fetch csr_next_action_id into l_next_assignment_action_id;
991: close csr_next_action_id;
992:
993: if g_debug then
994: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
995: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
996: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
997: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
998: end if;
991: close csr_next_action_id;
992:
993: if g_debug then
994: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
995: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
996: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
997: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
998: end if;
999:
992:
993: if g_debug then
994: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
995: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
996: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
997: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
998: end if;
999:
1000: -- Create the archive assignment actions
993: if g_debug then
994: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
995: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
996: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
997: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
998: end if;
999:
1000: -- Create the archive assignment actions
1001: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1029:
1030:
1031: END LOOP; /* Loop 2 */
1032: if g_debug then
1033: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
1034: end if;
1035: end if; /* End of Inner Organization */
1036: else /* Not Org,check for others */
1037:
1051: open csr_next_action_id;
1052: fetch csr_next_action_id into l_next_assignment_action_id;
1053: close csr_next_action_id;
1054: if g_debug then
1055: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1056: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1057: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1058: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1059: end if;
1052: fetch csr_next_action_id into l_next_assignment_action_id;
1053: close csr_next_action_id;
1054: if g_debug then
1055: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1056: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1057: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1058: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1059: end if;
1060:
1053: close csr_next_action_id;
1054: if g_debug then
1055: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1056: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1057: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1058: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1059: end if;
1060:
1061: -- Create the archive assignment actions
1054: if g_debug then
1055: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1056: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1057: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1058: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1059: end if;
1060:
1061: -- Create the archive assignment actions
1062: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1090:
1091:
1092: END LOOP;/* Loop 3 */
1093: if g_debug then
1094: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
1095: end if;
1096:
1097: else
1098: FOR csr_rec in csr_assignment_legal_run(p_payroll_action_id,
1108: fetch csr_next_action_id into l_next_assignment_action_id;
1109: close csr_next_action_id;
1110:
1111: if g_debug then
1112: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1113: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1114: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1115: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1116: end if;
1109: close csr_next_action_id;
1110:
1111: if g_debug then
1112: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1113: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1114: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1115: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1116: end if;
1117:
1110:
1111: if g_debug then
1112: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1113: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1114: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1115: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1116: end if;
1117:
1118: -- Create the archive assignment actions
1111: if g_debug then
1112: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1113: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1114: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1115: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1116: end if;
1117:
1118: -- Create the archive assignment actions
1119: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1147:
1148:
1149: END LOOP; /* Loop 4 */
1150: if g_debug then
1151: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
1152: end if;
1153: end if; /* End of Inner Legal Employer */
1154: else /* Not Org,Legal Emp Check others */
1155:
1170: fetch csr_next_action_id into l_next_assignment_action_id;
1171: close csr_next_action_id;
1172:
1173: if g_debug then
1174: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1175: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1176: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1177: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1178: end if;
1171: close csr_next_action_id;
1172:
1173: if g_debug then
1174: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1175: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1176: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1177: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1178: end if;
1179:
1172:
1173: if g_debug then
1174: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1175: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1176: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1177: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1178: end if;
1179:
1180: -- Create the archive assignment actions
1173: if g_debug then
1174: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1175: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1176: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1177: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1178: end if;
1179:
1180: -- Create the archive assignment actions
1181: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1210:
1211: END LOOP;/* Loop 5 */
1212:
1213: if g_debug then
1214: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
1215: end if;
1216:
1217: else
1218: FOR csr_rec in csr_assignment_payroll_run(p_payroll_action_id,
1228: fetch csr_next_action_id into l_next_assignment_action_id;
1229: close csr_next_action_id;
1230:
1231: if g_debug then
1232: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1233: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1234: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1235: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1236: end if;
1229: close csr_next_action_id;
1230:
1231: if g_debug then
1232: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1233: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1234: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1235: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1236: end if;
1237:
1230:
1231: if g_debug then
1232: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1233: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1234: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1235: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1236: end if;
1237:
1238: -- Create the archive assignment actions
1231: if g_debug then
1232: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1233: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1234: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1235: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1236: end if;
1237:
1238: -- Create the archive assignment actions
1239: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1267:
1268:
1269: END LOOP; /* Loop 6 */
1270: if g_debug then
1271: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
1272: end if;
1273: end if; /* End of Inner Payroll */
1274: else /* Not Org,Legal,Payroll check others */
1275:
1290: fetch csr_next_action_id into l_next_assignment_action_id;
1291: close csr_next_action_id;
1292:
1293: if g_debug then
1294: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1295: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1296: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1297: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1298: end if;
1291: close csr_next_action_id;
1292:
1293: if g_debug then
1294: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1295: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1296: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1297: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1298: end if;
1299:
1292:
1293: if g_debug then
1294: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1295: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1296: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1297: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1298: end if;
1299:
1300: -- Create the archive assignment actions
1293: if g_debug then
1294: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1295: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1296: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1297: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1298: end if;
1299:
1300: -- Create the archive assignment actions
1301: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1329:
1330:
1331: END LOOP;/* Loop 7 */
1332: if g_debug then
1333: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
1334: end if;
1335:
1336: else
1337: FOR csr_rec in csr_assignment_run(p_payroll_action_id,
1347: fetch csr_next_action_id into l_next_assignment_action_id;
1348: close csr_next_action_id;
1349:
1350: if g_debug then
1351: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1352: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1353: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1354: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1355: end if;
1348: close csr_next_action_id;
1349:
1350: if g_debug then
1351: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1352: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1353: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1354: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1355: end if;
1356:
1349:
1350: if g_debug then
1351: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1352: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1353: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1354: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1355: end if;
1356:
1357: -- Create the archive assignment actions
1350: if g_debug then
1351: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1352: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1353: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1354: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1355: end if;
1356:
1357: -- Create the archive assignment actions
1358: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1386:
1387:
1388: END LOOP; /* Loop 8 */
1389: if g_debug then
1390: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
1391: end if;
1392: end if; /* End of Inner Assignment */
1393:
1394: else
1409: fetch csr_next_action_id into l_next_assignment_action_id;
1410: close csr_next_action_id;
1411:
1412: if g_debug then
1413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1417: end if;
1410: close csr_next_action_id;
1411:
1412: if g_debug then
1413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1417: end if;
1418:
1411:
1412: if g_debug then
1413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1417: end if;
1418:
1419: -- Create the archive assignment actions
1412: if g_debug then
1413: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1414: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1415: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1416: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1417: end if;
1418:
1419: -- Create the archive assignment actions
1420: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1448:
1449:
1450: END LOOP;/* Loop 9 */
1451: if g_debug then
1452: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
1453: end if;
1454:
1455: else
1456: FOR csr_rec in csr_assignment_default_run(p_payroll_action_id,
1465: fetch csr_next_action_id into l_next_assignment_action_id;
1466: close csr_next_action_id;
1467:
1468: if g_debug then
1469: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1470: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1471: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1472: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1473: end if;
1466: close csr_next_action_id;
1467:
1468: if g_debug then
1469: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1470: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1471: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1472: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1473: end if;
1474:
1467:
1468: if g_debug then
1469: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1470: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1471: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1472: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1473: end if;
1474:
1475: -- Create the archive assignment actions
1468: if g_debug then
1469: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1470: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1471: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1472: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1473: end if;
1474:
1475: -- Create the archive assignment actions
1476: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1504:
1505:
1506: END LOOP; /* Loop 10 */
1507: if g_debug then
1508: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
1509: end if;
1510: end if; /* End of Inner Default */
1511:
1512:
1516: end if; /* End Organization */
1517:
1518: exception
1519: when others then
1520: hr_utility.set_location('Error in '||l_procedure,999999);
1521: raise;
1522: end assignment_action_code;
1523:
1524: --------------------------------------------------------------------+
1832: END get_fin_year_code;
1833:
1834: begin
1835:
1836: g_debug :=hr_utility.debug_enabled ;
1837: l_balance_flag := 'Y' ; /* Bug 3627293 - Balances have to be stored */
1838: l_YTD_GROSS_EARNINGS :=0 ;
1839: l_YTD_NON_TAXABLE_EARNINGS :=0 ;
1840: l_YTD_PRE_TAX_DEDUCTIONS :=0 ;
1846: l_YTD_EMPLOYER_CHARGES :=0 ;
1847:
1848: if g_debug then
1849: l_procedure := g_package||'archive_code';
1850: hr_utility.set_location('Entering '||l_procedure,1);
1851: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1852: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1853: end if;
1854:
1847:
1848: if g_debug then
1849: l_procedure := g_package||'archive_code';
1850: hr_utility.set_location('Entering '||l_procedure,1);
1851: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1852: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1853: end if;
1854:
1855: OPEN csr_get_data(p_assignment_action_id);
1848: if g_debug then
1849: l_procedure := g_package||'archive_code';
1850: hr_utility.set_location('Entering '||l_procedure,1);
1851: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1852: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1853: end if;
1854:
1855: OPEN csr_get_data(p_assignment_action_id);
1856: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
1856: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
1857: CLOSE csr_get_data;
1858:
1859: if g_debug then
1860: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1861: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1862: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1863: end if;
1864:
1857: CLOSE csr_get_data;
1858:
1859: if g_debug then
1860: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1861: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1862: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1863: end if;
1864:
1865: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1858:
1859: if g_debug then
1860: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1861: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1862: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1863: end if;
1864:
1865: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1866: LOOP
1865: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1866: LOOP
1867:
1868: if g_debug then
1869: hr_utility.set_location('csr_rec.full_name............= '|| csr_rec.full_name,10);
1870: end if;
1871:
1872: IF (NVL(g_prev_assignment_id,0) <> csr_rec.assignment_id) THEN
1873:
1950:
1951: /*Bug 4040688 - end of modification*/
1952:
1953: if g_debug then
1954: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
1955: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
1956: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
1957: end if;
1958:
1951: /*Bug 4040688 - end of modification*/
1952:
1953: if g_debug then
1954: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
1955: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
1956: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
1957: end if;
1958:
1959: -- Archive employee details
1952:
1953: if g_debug then
1954: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
1955: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
1956: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
1957: end if;
1958:
1959: -- Archive employee details
1960: /* Bug 3953702 - Archived the Grade Name details into pay_action_information */
2216:
2217: Begin
2218: l_count :=0;
2219: ps_request_id :=-1;
2220: g_debug :=hr_utility.debug_enabled ;
2221:
2222: if g_debug then
2223: l_procedure := g_package||' spawn_archive_reports';
2224: hr_utility.set_location('Entering '||l_procedure,999);
2220: g_debug :=hr_utility.debug_enabled ;
2221:
2222: if g_debug then
2223: l_procedure := g_package||' spawn_archive_reports';
2224: hr_utility.set_location('Entering '||l_procedure,999);
2225: end if;
2226:
2227: -- Set User Parameters for Report.
2228:
2255:
2256:
2257:
2258: if g_debug then
2259: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2256:
2257:
2258: if g_debug then
2259: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2257:
2258: if g_debug then
2259: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2258: if g_debug then
2259: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2259: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2260: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2261: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2262: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2263: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2264: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2265: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2266: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2267: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2268: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2269: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2270: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2271: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2279: end if;
2272: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2279: end if;
2280:
2273: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2279: end if;
2280:
2281: if g_debug then
2274: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2275: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2276: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2277: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2279: end if;
2280:
2281: if g_debug then
2282: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2278: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
2279: end if;
2280:
2281: if g_debug then
2282: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2283:
2284: hr_utility.set_location('Before calling report',24);
2285: end if;
2286:
2280:
2281: if g_debug then
2282: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2283:
2284: hr_utility.set_location('Before calling report',24);
2285: end if;
2286:
2287: OPEN csr_get_print_options(p_payroll_action_id);
2288: FETCH csr_get_print_options INTO rec_print_options;
2298: save_output => hr_general.char_to_bool(rec_print_options.save_output),
2299: print_together => l_print_together);
2300: -- Submit report
2301: if g_debug then
2302: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
2303: end if;
2304:
2305: ps_request_id := fnd_request.submit_request
2306: ('PAY',
2342: NULL, NULL, NULL, NULL, NULL, NULL,
2343: NULL, NULL, NULL, NULL
2344: );
2345: if g_debug then
2346: hr_utility.set_location('After calling report',24);
2347: end if;
2348:
2349:
2350:
2404: AND prrv.input_value_id = c_input_value_id;
2405:
2406: BEGIN
2407:
2408: g_debug := hr_utility.debug_enabled;
2409:
2410: /* Bug 5987877 - Added Check for Multiple Hours Input
2411: If Input Name = "Hours", return run result for it
2412: else sum the run results for all "H_" UOM type.
2482: AND prrv.input_value_id = c_input_value_id;
2483:
2484: BEGIN
2485:
2486: g_debug := hr_utility.debug_enabled;
2487:
2488: if g_debug then
2489: hr_utility.trace('Entering get_element_payment_rate');
2490: end if;
2485:
2486: g_debug := hr_utility.debug_enabled;
2487:
2488: if g_debug then
2489: hr_utility.trace('Entering get_element_payment_rate');
2490: end if;
2491:
2492: OPEN get_rate_input_value(p_element_type_id,p_effective_date);
2493: FETCH get_rate_input_value INTO l_input_value_id;
2502:
2503: /* Avoid Divide by Zero Errors when used for computing Rate, Report Hours and Rate as Null */
2504:
2505: if g_debug then
2506: hr_utility.trace('l_result is ' || l_result);
2507: end if;
2508:
2509: IF l_result = 0
2510: THEN
2512: END IF;
2513:
2514:
2515: if g_debug then
2516: hr_utility.trace('Leaving get_element_payment_rate');
2517: end if;
2518:
2519: RETURN l_result;
2520: END get_element_payment_rate;