eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_UTILITY

Line 251: -- hr_utility.trace_on(null,'NOEC');

247: --------------- Begin -------------------------------------
248:
249: BEGIN
250:
251: -- hr_utility.trace_on(null,'NOEC');
252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );

Line 252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');

248:
249: BEGIN
250:
251: -- hr_utility.trace_on(null,'NOEC');
252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );

Line 253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

249: BEGIN
250:
251: -- hr_utility.trace_on(null,'NOEC');
252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );

Line 254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );

250:
251: -- hr_utility.trace_on(null,'NOEC');
252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );

Line 255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );

251: -- hr_utility.trace_on(null,'NOEC');
252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );

Line 256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );

252: hr_utility.trace('2007 EMP_CONT ::: Enterd procedure GET_EMPLOYER_DEDUCTION ----------------------------------');
253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );

Line 257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );

253: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );

Line 258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );

254: hr_utility.trace('2007 EMP_CONT ::: p_tax_unit_id = '|| p_tax_unit_id );
255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );

Line 259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );

255: hr_utility.trace('2007 EMP_CONT ::: p_local_unit_id = '|| p_local_unit_id );
256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );

Line 260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );

256: hr_utility.trace('2007 EMP_CONT ::: p_jurisdiction_code = '|| p_jurisdiction_code );
257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

Line 261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );

257: hr_utility.trace('2007 EMP_CONT ::: p_payroll_id = '|| p_payroll_id );
258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
265:

Line 262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );

258: hr_utility.trace('2007 EMP_CONT ::: p_payroll_action_id = '|| p_payroll_action_id );
259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
265:
266:

Line 263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );

259: hr_utility.trace('2007 EMP_CONT ::: p_asg_act_id = '|| p_asg_act_id );
260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
265:
266:
267: -- cursor retrieves bimonth end date for the p_date_earned

Line 264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');

260: hr_utility.trace('2007 EMP_CONT ::: p_bus_group_id = '|| p_bus_group_id );
261: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '|| p_date_earned );
262: hr_utility.trace('2007 EMP_CONT ::: p_under_age_high_rate = '|| p_under_age_high_rate );
263: hr_utility.trace('2007 EMP_CONT ::: p_over_age_high_rate = '|| p_over_age_high_rate );
264: hr_utility.trace('2007 EMP_CONT ::: -------------------------------------------------');
265:
266:
267: -- cursor retrieves bimonth end date for the p_date_earned
268: OPEN csr_get_bimonth_end_date (p_date_earned);

Line 278: hr_utility.trace('2007 EMP_CONT ::: l_curr_zone = '|| l_curr_zone );

274: -- zone will now be fetched from user tables, have to change the below call
275: -- l_curr_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',p_jurisdiction_code),1,1));
276: l_curr_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', p_jurisdiction_code, p_date_earned ) ;
277:
278: hr_utility.trace('2007 EMP_CONT ::: l_curr_zone = '|| l_curr_zone );
279:
280: -- Get the Status , Report Separately and Tax Municipality for the Local Unit of the current assignment
281: OPEN PAY_NO_EMP_CONT_2007.get_lu_details(p_local_unit_id);
282: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;

Line 285: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );

281: OPEN PAY_NO_EMP_CONT_2007.get_lu_details(p_local_unit_id);
282: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;
283: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
284:
285: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
286: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
287: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
288: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
289:

Line 286: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );

282: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_lu_status , l_lu_rep_sep , l_lu_tax_mun ;
283: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
284:
285: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
286: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
287: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
288: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
289:
290: -- check if Local Unit is Report separately = yes

Line 287: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );

283: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details;
284:
285: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
286: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
287: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
288: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
289:
290: -- check if Local Unit is Report separately = yes
291: IF trim(l_lu_rep_sep) = 'Y'

Line 288: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');

284:
285: hr_utility.trace('2007 EMP_CONT ::: l_lu_status = '|| l_lu_status );
286: hr_utility.trace('2007 EMP_CONT ::: l_lu_rep_sep = '|| l_lu_rep_sep );
287: hr_utility.trace('2007 EMP_CONT ::: l_lu_tax_mun = '|| l_lu_tax_mun );
288: hr_utility.trace('2007 EMP_CONT ::: goin to test for local unit report separately..........');
289:
290: -- check if Local Unit is Report separately = yes
291: IF trim(l_lu_rep_sep) = 'Y'
292:

Line 296: hr_utility.trace('2007 EMP_CONT ::: Local unit is Rep Sep');

292:
293: THEN ---------------------------------------------------------------------------------------------------------------------------------
294: -- since LU is report separately, check if LE LU combination exists
295:
296: hr_utility.trace('2007 EMP_CONT ::: Local unit is Rep Sep');
297:
298: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
299: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;
300: l_le_lu_exists := FALSE;

Line 313: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');

309: THEN
310: l_le_lu_exists := TRUE;
311: l_le_lu_index := start_index_main;
312:
313: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');
314: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
315: EXIT;
316: END IF;
317: start_index_main := start_index_main + 1;

Line 314: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );

310: l_le_lu_exists := TRUE;
311: l_le_lu_index := start_index_main;
312:
313: hr_utility.trace('2007 EMP_CONT ::: LE LU combination found');
314: hr_utility.trace('2007 EMP_CONT ::: l_le_lu_index = '|| l_le_lu_index );
315: EXIT;
316: END IF;
317: start_index_main := start_index_main + 1;
318: END LOOP; -- end while loop

Line 330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');

326: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_base;
327: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_contribution;
328: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
329:
330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

Line 331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );

327: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_lu_index).run_contribution;
328: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
329:
330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
335:

Line 332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );

328: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
329:
330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
335:
336: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

Line 333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );

329:
330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
335:
336: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
337:

Line 334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

330: hr_utility.trace('2007 EMP_CONT ::: LU found, since results exist, just returning them');
331: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_le_lu_index = '|| l_le_lu_index );
332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
335:
336: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
337:
338: RETURN 1; -- here return le_run and the other values thru OUT parameters

Line 336: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

332: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
333: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
334: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
335:
336: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
337:
338: RETURN 1; -- here return le_run and the other values thru OUT parameters
339:
340: ELSE --------------------------------------------------------------------------------------------------------------------------

Line 342: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');

338: RETURN 1; -- here return le_run and the other values thru OUT parameters
339:
340: ELSE --------------------------------------------------------------------------------------------------------------------------
341: -- combination does not exist, calculation has to be done and values returned
342: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');
343:
344: ------------------- initializing the g_tab_calc table for LE LU combination
345: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');
346: -- loop for each zone

Line 345: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');

341: -- combination does not exist, calculation has to be done and values returned
342: hr_utility.trace('2007 EMP_CONT ::: LU does not exist, calculate for this LU');
343:
344: ------------------- initializing the g_tab_calc table for LE LU combination
345: hr_utility.trace('2007 EMP_CONT ::: LU ***** initializing g_tab_calc ');
346: -- loop for each zone
347:
348: g_tab_calc(1).zone := '1' ;
349: g_tab_calc(2).zone := '1a' ;

Line 371: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

367: g_tab_calc(i).run_contribution := 0 ;
368:
369: END LOOP; -- end i loop
370:
371: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
372: l_check := display_table_calc(g_tab_calc);
373: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
374:
375: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');

Line 373: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

369: END LOOP; -- end i loop
370:
371: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
372: l_check := display_table_calc(g_tab_calc);
373: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
374:
375: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
376: -------------------- finished initializing the g_tab_lu table
377:

Line 375: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');

371: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
372: l_check := display_table_calc(g_tab_calc);
373: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
374:
375: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
376: -------------------- finished initializing the g_tab_lu table
377:
378: ------------------ get exemption limit used for LU
379: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');

Line 379: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');

375: hr_utility.trace('2007 EMP_CONT ::: LU ***** finished initializing g_tab_calc ');
376: -------------------- finished initializing the g_tab_lu table
377:
378: ------------------ get exemption limit used for LU
379: hr_utility.trace('2007 EMP_CONT ::: LU ***** get exemption limit ');
380:
381: -- set the context values for balance
382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
383:

Line 388: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

384: -- get defined balance ids
385: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
386: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
387:
388: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
389: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
390:
391: -- get the balance value
392: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 389: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

385: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
386: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
387:
388: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
389: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
390:
391: -- get the balance value
392: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
393: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 397: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );

393: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
394:
395: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
396:
397: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
400:
401: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );

Line 398: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );

394:
395: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
396:
397: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
400:
401: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
402:

Line 399: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

395: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
396:
397: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_ytd = '|| l_bal_val_ytd );
398: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '|| l_bal_val_bimonth );
399: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
400:
401: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_local_unit_id ,p_date_earned );
402:
403: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );

405: FETCH PAY_NO_EMP_CONT_2007.csr_get_exemption_limit INTO l_exemption_limit , l_economic_aid ;
406:
407: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );
411:
412: -- 2007 Legislative changes for 'Economic Aid' to Employer
413: l_exemption_limit := l_exemption_limit - l_economic_aid ;

Line 410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );

406:
407: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
408:
409: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = ' || l_exemption_limit );
410: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_economic_aid = ' || l_economic_aid );
411:
412: -- 2007 Legislative changes for 'Economic Aid' to Employer
413: l_exemption_limit := l_exemption_limit - l_economic_aid ;
414:

Line 415: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit after reducing eco aid = ' || l_exemption_limit );

411:
412: -- 2007 Legislative changes for 'Economic Aid' to Employer
413: l_exemption_limit := l_exemption_limit - l_economic_aid ;
414:
415: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit after reducing eco aid = ' || l_exemption_limit );
416:
417:
418: IF l_exemption_limit_used_yet >= l_exemption_limit
419: THEN

Line 425: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );

421: ELSE
422: l_LU_over_limit := 'N';
423: END IF ; -- end if exemption limit check
424:
425: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
426: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
427: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
428:
429: ------------------- got exemption limit used for LU

Line 426: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );

422: l_LU_over_limit := 'N';
423: END IF ; -- end if exemption limit check
424:
425: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
426: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
427: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
428:
429: ------------------- got exemption limit used for LU
430:

Line 427: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );

423: END IF ; -- end if exemption limit check
424:
425: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit = '||l_exemption_limit );
426: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '|| l_LU_over_limit );
427: hr_utility.trace('2007 EMP_CONT ::: LU ***** got exemtion limt , leaving' );
428:
429: ------------------- got exemption limit used for LU
430:
431: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)

Line 435: hr_utility.trace('2007 EMP_CONT ::: LU ***** populating g_lu_tab and g_mu_tab , entering ' );

431: ----------------- populating the tables g_lu_tab (LU) and g_mu_tab (MU)
432:
433: -- from 2007 , the tax municipality will be picked from the local unit
434:
435: hr_utility.trace('2007 EMP_CONT ::: LU ***** populating g_lu_tab and g_mu_tab , entering ' );
436:
437: l_temp := populate_tables
438: (p_tax_unit_id
439: ,p_payroll_id

Line 445: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );

441: ,g_lu_tab
442: ,g_mu_tab );
443:
444:
445: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
446: ----------------- Fetch the run base using assignment level balances (at LU level)
447: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
448:
449: -- get defined balance ids

Line 447: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );

443:
444:
445: hr_utility.trace('2007 EMP_CONT ::: LU ***** populated g_lu_tab and g_mu_tab , leaving ' );
446: ----------------- Fetch the run base using assignment level balances (at LU level)
447: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the run base using assignment level balances , enetring ' );
448:
449: -- get defined balance ids
450: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
451: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

Line 453: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

449: -- get defined balance ids
450: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
451: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
452:
453: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
455: -- Added 29-dec-2012
456:
457: OPEN get_balance_type_id ('Employer Contribution Base');

Line 454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

450: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
451: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
452:
453: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
454: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
455: -- Added 29-dec-2012
456:
457: OPEN get_balance_type_id ('Employer Contribution Base');
458: FETCH get_balance_type_id INTO l_bal_id_1;

Line 465: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );

461: OPEN get_balance_type_id ('Employer Contribution Base 2');
462: FETCH get_balance_type_id INTO l_bal_id_2;
463: CLOSE get_balance_type_id;
464:
465: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
466: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
467:
468: -- End Added 29-dec-2012
469: ----- test only , Remove it

Line 466: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );

462: FETCH get_balance_type_id INTO l_bal_id_2;
463: CLOSE get_balance_type_id;
464:
465: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
466: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
467:
468: -- End Added 29-dec-2012
469: ----- test only , Remove it
470: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 473: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );

469: ----- test only , Remove it
470: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
471: FETCH csr_test_aag_act_id INTO l_check2;
472: CLOSE csr_test_aag_act_id;
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
474: -- remove till here
475:
476: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
477:

Line 476: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );

472: CLOSE csr_test_aag_act_id;
473: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
474: -- remove till here
475:
476: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave' );
477:
478: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
479: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
480:

Line 486: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 , loop csr_curr_le_asg_act_id ' );

482:
483: -- loop to get all assignment_action_id in the current payroll_action_id
484: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
485:
486: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 , loop csr_curr_le_asg_act_id ' );
487:
488: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
489: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
490:

Line 493: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );

489: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
490:
491: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
492:
493: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
494: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
495:
496: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
497:

Line 494: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

490:
491: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
492:
493: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 2, g_mu_tab ' );
494: hr_utility.trace('2007 EMP_CONT ::: LU ***** ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
495:
496: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
497:
498: -- get the balance value

Line 504: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

500: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
501: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
502:
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
505: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
506: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
507: -- Added on 29-Dec-2012
508: OPEN get_ASG_TU_MU_LU_BIMONTH

Line 505: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );

501: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
502:
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
505: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
506: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
507: -- Added on 29-Dec-2012
508: OPEN get_ASG_TU_MU_LU_BIMONTH
509: (csr1_rec.ASSIGNMENT_ACTION_ID

Line 506: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */

502:
503:
504: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
505: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
506: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
507: -- Added on 29-Dec-2012
508: OPEN get_ASG_TU_MU_LU_BIMONTH
509: (csr1_rec.ASSIGNMENT_ACTION_ID
510: , l_bal_id_1

Line 530: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

526: CLOSE get_ASG_TU_MU_LU_BIMONTH;
527:
528: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
529:
530: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
531: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
532: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
533: -- End 29-Dec-2012
534:

Line 531: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );

527:
528: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
529:
530: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
531: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
532: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
533: -- End 29-Dec-2012
534:
535:

Line 532: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

528: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
529:
530: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
531: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
532: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
533: -- End 29-Dec-2012
534:
535:
536: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');

Line 536: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');

532: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
533: -- End 29-Dec-2012
534:
535:
536: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
537: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
538:
539: l_zone_temp := to_char(g_mu_tab(start_index_mu));
540:

Line 537: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

533: -- End 29-Dec-2012
534:
535:
536: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking================= ');
537: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
538:
539: l_zone_temp := to_char(g_mu_tab(start_index_mu));
540:
541: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

Line 541: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

537: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
538:
539: l_zone_temp := to_char(g_mu_tab(start_index_mu));
540:
541: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
542:
543: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
544: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
545:

Line 547: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );

543: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
544: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
545:
546:
547: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );
548:
549: l_cell := lookup_cell(g_tab_calc, l_zone);
550: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
551:

Line 552: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );

548:
549: l_cell := lookup_cell(g_tab_calc, l_zone);
550: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
551:
552: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );
553:
554: start_index_mu := start_index_mu + 1;
555:
556: END LOOP; -- end while loop

Line 561: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );

557:
558: END LOOP; -- end loop csr1_rec
559:
560:
561: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
562:
563: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
564: l_check := display_table_calc(g_tab_calc);
565: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 563: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

559:
560:
561: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
562:
563: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
564: l_check := display_table_calc(g_tab_calc);
565: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
566:
567: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );

Line 565: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

561: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
562:
563: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
564: l_check := display_table_calc(g_tab_calc);
565: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
566:
567: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
568: ---------------------- Fetched the run base using assignment level balances (at LU level)
569:

Line 567: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );

563: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
564: l_check := display_table_calc(g_tab_calc);
565: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
566:
567: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
568: ---------------------- Fetched the run base using assignment level balances (at LU level)
569:
570: ----------------- Fetch the bimonth base using group level balances (at LU level)
571: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );

Line 571: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );

567: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the run base using assignment level balances , leaving ' );
568: ---------------------- Fetched the run base using assignment level balances (at LU level)
569:
570: ----------------- Fetch the bimonth base using group level balances (at LU level)
571: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetch the bimonth base using group level balances , entering ' );
572:
573: -- get defined balance ids
574: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
575: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

Line 577: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );

573: -- get defined balance ids
574: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
575: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
576:
577: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
579: -- added 29-dec-2012
580: OPEN get_balance_type_id ('Employer Contribution Base');
581: FETCH get_balance_type_id INTO l_bal_id_1;

Line 578: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );

574: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
575: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
576:
577: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_1 = '|| l_def_bal_id_1 );
578: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_def_bal_id_2 = '|| l_def_bal_id_2 );
579: -- added 29-dec-2012
580: OPEN get_balance_type_id ('Employer Contribution Base');
581: FETCH get_balance_type_id INTO l_bal_id_1;
582: CLOSE get_balance_type_id;

Line 588: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );

584: OPEN get_balance_type_id ('Employer Contribution');
585: FETCH get_balance_type_id INTO l_bal_id_2;
586: CLOSE get_balance_type_id;
587:
588: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
589: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
590:
591: --end 29-Dec-2012
592: -- loop to get all MU in g_mu_tab

Line 589: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );

585: FETCH get_balance_type_id INTO l_bal_id_2;
586: CLOSE get_balance_type_id;
587:
588: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
589: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
590:
591: --end 29-Dec-2012
592: -- loop to get all MU in g_mu_tab
593:

Line 597: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );

593:
594: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
595: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
596:
597: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 leave ' );
598:
599: --pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);
600:
601:

Line 604: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );

600:
601:
602: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
603:
604: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
605:
606: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
607:
608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

Line 608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );

604: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 1 ,g_mu_tab ' );
605:
606: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
607:
608: hr_utility.trace('2007 EMP_CONT ::: LU ***** MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| p_local_unit_id );
609:
610: -- get the balance value
611: /*l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
612: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);

Line 614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);

610: -- get the balance value
611: /*l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
612: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers ); */
616: -- added 29-dec-2012
617:
618: OPEN get_TU_MU_LU_BIMONTH

Line 615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers ); */

611: /*l_lu_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
612: l_lu_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
613:
614: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
615: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_lu_ers = '||l_lu_ers ); */
616: -- added 29-dec-2012
617:
618: OPEN get_TU_MU_LU_BIMONTH
619: (l_bimonth_end_date

Line 636: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);

632: , p_local_unit_id );
633: FETCH get_TU_MU_LU_BIMONTH INTO l_lu_ers;
634: CLOSE get_TU_MU_LU_BIMONTH;
635:
636: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
637: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers = '||l_lu_ers );
638:
639: -- End 29-dec-2012
640:

Line 637: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers = '||l_lu_ers );

633: FETCH get_TU_MU_LU_BIMONTH INTO l_lu_ers;
634: CLOSE get_TU_MU_LU_BIMONTH;
635:
636: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers_base = '|| l_lu_ers_base);
637: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers = '||l_lu_ers );
638:
639: -- End 29-dec-2012
640:
641: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');

Line 641: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');

637: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_lu_ers = '||l_lu_ers );
638:
639: -- End 29-dec-2012
640:
641: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
642:
643: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
644:
645: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 643: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

639: -- End 29-dec-2012
640:
641: hr_utility.trace('2007 EMP_CONT ::: LU ***** ============== just checking again ================= ');
642:
643: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
644:
645: l_zone_temp := to_char(g_mu_tab(start_index_mu));
646:
647: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

Line 647: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );

643: hr_utility.trace('2007 EMP_CONT ::: LU ***** g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
644:
645: l_zone_temp := to_char(g_mu_tab(start_index_mu));
646:
647: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_temp = '|| l_zone_temp );
648:
649: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
650: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
651:

Line 652: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );

648:
649: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
650: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
651:
652: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone = '|| l_zone );
653:
654: l_cell := lookup_cell(g_tab_calc, l_zone);
655: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
656: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;

Line 658: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );

654: l_cell := lookup_cell(g_tab_calc, l_zone);
655: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_lu_ers_base ;
656: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_lu_ers ;
657:
658: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_cell = '|| l_cell );
659:
660: start_index_mu := start_index_mu + 1;
661: END LOOP; -- end while loop
662:

Line 663: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );

659:
660: start_index_mu := start_index_mu + 1;
661: END LOOP; -- end while loop
662:
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
664:
665: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
666: l_check := display_table_calc(g_tab_calc);
667: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 665: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

661: END LOOP; -- end while loop
662:
663: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
664:
665: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
666: l_check := display_table_calc(g_tab_calc);
667: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
668:
669: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );

Line 667: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

663: hr_utility.trace('2007 EMP_CONT ::: LU ***** level 0 back' );
664:
665: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
666: l_check := display_table_calc(g_tab_calc);
667: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
668:
669: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
670: ---------------------- Fetched the bimonth base using group level balances (at LU level)
671:

Line 669: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );

665: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
666: l_check := display_table_calc(g_tab_calc);
667: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
668:
669: hr_utility.trace('2007 EMP_CONT ::: LU ***** Fetched the bimonth base using group level balances , leaving ' );
670: ---------------------- Fetched the bimonth base using group level balances (at LU level)
671:
672:
673: ------------------------------ apply differential rate and check exemption limit at LU Level

Line 675: hr_utility.trace('2007 EMP_CONT ::: LU ***** apply differential rate and check exemption limit , entering ' );

671:
672:
673: ------------------------------ apply differential rate and check exemption limit at LU Level
674:
675: hr_utility.trace('2007 EMP_CONT ::: LU ***** apply differential rate and check exemption limit , entering ' );
676: --l_lu_status status for LU
677: --l_le_status status for LE
678: l_total_saving := 0;
679:

Line 686: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = Y ' );

682: -- check if exemption limit already used up
683: IF l_LU_over_limit = 'Y'
684:
685: THEN
686: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = Y ' );
687:
688: -- as limit is over, put under_limit as N for all rows
689: FOR i IN 1..7 LOOP
690: g_tab_calc(i).under_limit := 'N';

Line 693: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );

689: FOR i IN 1..7 LOOP
690: g_tab_calc(i).under_limit := 'N';
691: END LOOP; -- end i loop
692:
693: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
694:
695: ELSE
696: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
697:

Line 696: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );

692:
693: hr_utility.trace('2007 EMP_CONT ::: LU ***** as limit is over, put under_limit as N for all rows ' );
694:
695: ELSE
696: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = N ' );
697:
698: -- limit is not over
699: -- perform exemption limit check only if status = AA,CC,GG
700: IF ( l_lu_status = 'AA' OR l_lu_status = 'GG' OR l_lu_status = 'CC' )

Line 703: hr_utility.trace('2007 EMP_CONT ::: LU ***** status is = '|| l_lu_status );

699: -- perform exemption limit check only if status = AA,CC,GG
700: IF ( l_lu_status = 'AA' OR l_lu_status = 'GG' OR l_lu_status = 'CC' )
701:
702: THEN
703: hr_utility.trace('2007 EMP_CONT ::: LU ***** status is = '|| l_lu_status );
704:
705: -------- performing exemption limit check
706: l_table_name := 'NO_NIS_ZONE_RATES';
707:

Line 718: hr_utility.trace('2007 EMP_CONT ::: LU ***** exemption limit check ----------------------------' );

714:
715: l_col_name := 'NIS Rates';
716: l_high_rate := p_under_age_high_rate;
717:
718: hr_utility.trace('2007 EMP_CONT ::: LU ***** exemption limit check ----------------------------' );
719:
720: l_zone_value := g_tab_calc(i).zone;
721: -- l_normal_rate := TO_NUMBER(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
722: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

Line 729: hr_utility.trace('2007 EMP_CONT ::: LU ***** i = '||i||' l_zone_value = '||l_zone_value

725:
726: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
727: l_total_saving := l_total_saving + l_saving ;
728:
729: hr_utility.trace('2007 EMP_CONT ::: LU ***** i = '||i||' l_zone_value = '||l_zone_value
730: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
731: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
732:
733: -- check if exemption limit exceeded

Line 736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');

732:
733: -- check if exemption limit exceeded
734: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
735: THEN
736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );

Line 737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );

733: -- check if exemption limit exceeded
734: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
735: THEN
736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );

Line 738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );

734: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
735: THEN
736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );

Line 739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );

735: THEN
736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );

Line 740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );

736: hr_utility.trace('2007 EMP_CONT ::: LU******** exemption limit exceeded in table');
737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );

Line 741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );

737: hr_utility.trace('2007 EMP_CONT ::: LU ***** bimonth_base = '|| g_tab_calc(i).bimonth_base );
738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

Line 742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );

738: hr_utility.trace('2007 EMP_CONT ::: LU ***** run_base = '||g_tab_calc(i).run_base );
739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
746:

Line 743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );

739: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_zone_value = '|| l_zone_value );
740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
746:
747: -- get the exceeding amount

Line 744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );

740: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_normal_rate = '|| l_normal_rate );
741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
746:
747: -- get the exceeding amount
748: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

Line 745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

741: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_high_rate = '|| l_high_rate );
742: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_diff_rate = '|| l_diff_rate );
743: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_saving = '|| l_saving );
744: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving= '|| l_total_saving );
745: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
746:
747: -- get the exceeding amount
748: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
749: l_base_over_limit := (l_amount_over_limit / l_diff_rate) * 100 ;

Line 773: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );

769: -- set the new l_total_saving
770:
771: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
772:
773: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
774: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
775: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
776: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
777:

Line 774: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );

770:
771: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
772:
773: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
774: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
775: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
776: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
777:
778: -- insert a new row for exceeded limit

Line 775: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );

771: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
772:
773: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
774: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
775: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
776: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
777:
778: -- insert a new row for exceeded limit
779:

Line 776: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );

772:
773: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_amount_over_limit = '|| l_amount_over_limit );
774: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_base_over_limit = '|| l_base_over_limit );
775: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
776: hr_utility.trace('2007 EMP_CONT ::: LU ***** NEW l_total_saving = '|| l_total_saving );
777:
778: -- insert a new row for exceeded limit
779:
780: g_tab_calc(8).zone := g_tab_calc(i).zone;

Line 798: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );

794: END LOOP; --end j loop
795:
796: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
797:
798: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );
799: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
800:
801: EXIT; -- exit loop i since no more check is required
802: END IF; -- end check if exemption limit exceeded

Line 799: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );

795:
796: l_LU_over_limit := 'Y'; -- indicating exemption limit on LU level is over
797:
798: --hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit Y' );
799: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_LU_over_limit = '||l_LU_over_limit );
800:
801: EXIT; -- exit loop i since no more check is required
802: END IF; -- end check if exemption limit exceeded
803:

Line 821: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );

817: -- from the total saving, removing exemption limit reported in the bimonth period
818: -- exemption limit used currently at LU level
819: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
820:
821: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
822: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
824:
825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

Line 822: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );

818: -- exemption limit used currently at LU level
819: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
820:
821: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
822: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
824:
825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
826: l_check := display_table_calc(g_tab_calc);

Line 823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );

819: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
820:
821: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
822: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
824:
825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
826: l_check := display_table_calc(g_tab_calc);
827: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

821: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_total_saving = '||l_total_saving );
822: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_bal_val_bimonth = '||l_bal_val_bimonth );
823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
824:
825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
826: l_check := display_table_calc(g_tab_calc);
827: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
828:
829: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );

Line 827: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

823: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_exemption_limit_used = '||l_exemption_limit_used );
824:
825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
826: l_check := display_table_calc(g_tab_calc);
827: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
828:
829: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
830: ------------------------------ applied differential rate and check exemption limit at LU Level
831:

Line 829: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );

825: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
826: l_check := display_table_calc(g_tab_calc);
827: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
828:
829: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
830: ------------------------------ applied differential rate and check exemption limit at LU Level
831:
832: -- ec_main_calculation function call for LU
833: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );

Line 833: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );

829: hr_utility.trace('2007 EMP_CONT ::: LU ***** applied differential rate and check exemption limit , leaving ' );
830: ------------------------------ applied differential rate and check exemption limit at LU Level
831:
832: -- ec_main_calculation function call for LU
833: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , entering ' );
834:
835: l_main_index := ec_main_calculation ( g_tab_calc
836: ,PAY_NO_EMP_CONT_2007.g_tab_main
837: ,p_tax_unit_id

Line 847: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

843: ,p_under_age_high_rate
844: ,p_over_age_high_rate
845: ,l_curr_zone ) ;
846:
847: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
848: l_check := display_table_calc(g_tab_calc);
849: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
850:
851: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );

Line 849: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

845: ,l_curr_zone ) ;
846:
847: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
848: l_check := display_table_calc(g_tab_calc);
849: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
850:
851: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
852:
853: -- done all caclculation and entered values in the main table for next time usage

Line 851: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );

847: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
848: l_check := display_table_calc(g_tab_calc);
849: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
850:
851: hr_utility.trace('2007 EMP_CONT ::: LU ***** ec_main_calculation function call for LU , leaving ' );
852:
853: -- done all caclculation and entered values in the main table for next time usage
854:
855: -- returning values at LU level

Line 860: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );

856: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_base;
857: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
858: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
859:
860: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
864:

Line 861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );

857: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
858: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
859:
860: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
864:
865: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

Line 862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );

858: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
859:
860: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
864:
865: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
866:

Line 863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

859:
860: hr_utility.trace('2007 EMP_CONT ::: LU ***** l_main_index = '|| l_main_index );
861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
864:
865: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
866:
867: RETURN 1; -- here return 1 , other values thru OUT parameters

Line 865: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');

861: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_base = '|| p_run_base );
862: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_run_contribution = '|| p_run_contribution );
863: hr_utility.trace('2007 EMP_CONT ::: LU ***** p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
864:
865: hr_utility.trace('2007 EMP_CONT ::: LU ***** Leaving procedure-----------------------------------');
866:
867: RETURN 1; -- here return 1 , other values thru OUT parameters
868:
869: END IF; --end if l_le_lu_exists

Line 875: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');

871:
872: ELSE ---------------------------------------------------------------------------------------------------------------------------------
873: -- since LU is NOT report separately, check if LE -9999 combination exists
874:
875: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');
876: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');
877:
878: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
879: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;

Line 876: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');

872: ELSE ---------------------------------------------------------------------------------------------------------------------------------
873: -- since LU is NOT report separately, check if LE -9999 combination exists
874:
875: hr_utility.trace('2007 EMP_CONT ::: LU is not report separately');
876: hr_utility.trace('2007 EMP_CONT ::: checking if LE exists');
877:
878: start_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.FIRST, 0) ;
879: end_index_main := NVL (PAY_NO_EMP_CONT_2007.g_tab_main.LAST, 0) ;
880: l_le_exists := FALSE;

Line 893: hr_utility.trace('2007 EMP_CONT ::: LE exists');

889: THEN
890: l_le_exists := TRUE;
891: l_le_index := start_index_main;
892:
893: hr_utility.trace('2007 EMP_CONT ::: LE exists');
894: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);
895:
896: EXIT;
897: END IF;

Line 894: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);

890: l_le_exists := TRUE;
891: l_le_index := start_index_main;
892:
893: hr_utility.trace('2007 EMP_CONT ::: LE exists');
894: hr_utility.trace('2007 EMP_CONT ::: l_le_index = '||l_le_index);
895:
896: EXIT;
897: END IF;
898: start_index_main := start_index_main + 1;

Line 910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );

906: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_base;
907: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_contribution;
908: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
909:
910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

Line 911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );

907: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_le_index).run_contribution;
908: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
909:
910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
915:

Line 912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );

908: p_curr_exemption_limit_used := 0; -- coz this value must have been returned before
909:
910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
915:
916: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

Line 913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );

909:
910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
915:
916: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
917:

Line 914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

910: hr_utility.trace('2007 EMP_CONT ::: LE #### LE already exists, so just returning vales' );
911: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_index = '|| l_le_index );
912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
915:
916: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
917:
918:

Line 916: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

912: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
913: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
914: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
915:
916: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
917:
918:
919: RETURN 1; -- here return le_run and the other values thru OUT parameters
920:

Line 925: hr_utility.trace('2007 EMP_CONT ::: LE #### initializing the g_tab_calc , entering');

921: ELSE --------------------------------------------------------------------------------------------------------------------------
922: -- combination does not exist, calculation has to be done and values returned
923:
924: ---------- initializing the g_tab_calc table for LE and -9999 combination
925: hr_utility.trace('2007 EMP_CONT ::: LE #### initializing the g_tab_calc , entering');
926:
927: OPEN PAY_NO_EMP_CONT_2007.get_le_status(p_tax_unit_id);
928: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_le_status;
929: CLOSE PAY_NO_EMP_CONT_2007.get_le_status;

Line 931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_status = '|| l_le_status );

927: OPEN PAY_NO_EMP_CONT_2007.get_le_status(p_tax_unit_id);
928: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_le_status;
929: CLOSE PAY_NO_EMP_CONT_2007.get_le_status;
930:
931: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_status = '|| l_le_status );
932:
933: -- loop for each zone
934:
935: g_tab_calc(1).zone := '1' ;

Line 958: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

954: g_tab_calc(i).run_contribution := 0 ;
955:
956: END LOOP; -- end i loop
957:
958: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
959: l_check := display_table_calc(g_tab_calc);
960: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
961:
962: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');

Line 960: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

956: END LOOP; -- end i loop
957:
958: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
959: l_check := display_table_calc(g_tab_calc);
960: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
961:
962: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
963: ---------------- finished initializing the g_tab_lu table
964:

Line 962: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');

958: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
959: l_check := display_table_calc(g_tab_calc);
960: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
961:
962: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
963: ---------------- finished initializing the g_tab_lu table
964:
965: ---------------- get exemption limit used for LE
966: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');

Line 966: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');

962: hr_utility.trace('2007 EMP_CONT ::: LE #### finished initializing the g_tab_calc , leaving ');
963: ---------------- finished initializing the g_tab_lu table
964:
965: ---------------- get exemption limit used for LE
966: hr_utility.trace('2007 EMP_CONT ::: LE #### get exemption limit used for LE , entering');
967:
968: -- set the context values for balance
969:
970: pay_balance_pkg.set_context('LOCAL_UNIT_ID',p_local_unit_id);

Line 976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

972: -- get defined balance ids
973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
975:
976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- get the balance value
980: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

973: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_YTD') ;
974: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_LU_BIMONTH') ;
975:
976: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
977: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
978:
979: -- get the balance value
980: l_bal_val_ytd := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);
981: l_bal_val_bimonth := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,p_jurisdiction_code,NULL,NULL,NULL,l_bimonth_end_date);

Line 988: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );

984: --l_bal_val_bimonth := 0 ;
985:
986: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
987:
988: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
989: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
990: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
991:
992: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );

Line 989: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );

985:
986: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
987:
988: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
989: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
990: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
991:
992: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
993:

Line 990: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

986: l_exemption_limit_used_yet := l_bal_val_ytd - l_bal_val_bimonth ;
987:
988: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_ytd = '|| l_bal_val_ytd );
989: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '|| l_bal_val_bimonth );
990: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
991:
992: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit(p_tax_unit_id ,p_date_earned );
993:
994: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 1000: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );

996: FETCH PAY_NO_EMP_CONT_2007.csr_get_exemption_limit INTO l_exemption_limit , l_economic_aid ;
997:
998: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
999:
1000: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );
1001: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );
1002:
1003: -- 2007 Legislative changes for 'Economic Aid' to Employer
1004: l_exemption_limit := l_exemption_limit - l_economic_aid ;

Line 1001: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );

997:
998: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;
999:
1000: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = ' || l_exemption_limit );
1001: hr_utility.trace('2007 EMP_CONT ::: LE #### l_economic_aid = ' || l_economic_aid );
1002:
1003: -- 2007 Legislative changes for 'Economic Aid' to Employer
1004: l_exemption_limit := l_exemption_limit - l_economic_aid ;
1005:

Line 1006: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit after reducing eco aid = ' || l_exemption_limit );

1002:
1003: -- 2007 Legislative changes for 'Economic Aid' to Employer
1004: l_exemption_limit := l_exemption_limit - l_economic_aid ;
1005:
1006: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit after reducing eco aid = ' || l_exemption_limit );
1007:
1008: IF l_exemption_limit_used_yet >= l_exemption_limit
1009: THEN
1010: l_LE_over_limit := 'Y';

Line 1015: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );

1011: ELSE
1012: l_LE_over_limit := 'N';
1013: END IF ; -- end if exemption limit check
1014:
1015: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
1016: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
1018: ------------------- got exemption limit used for LE
1019:

Line 1016: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );

1012: l_LE_over_limit := 'N';
1013: END IF ; -- end if exemption limit check
1014:
1015: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
1016: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
1018: ------------------- got exemption limit used for LE
1019:
1020: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)

Line 1017: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');

1013: END IF ; -- end if exemption limit check
1014:
1015: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit = '|| l_exemption_limit );
1016: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '|| l_LE_over_limit );
1017: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
1018: ------------------- got exemption limit used for LE
1019:
1020: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
1021: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');

Line 1021: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');

1017: hr_utility.trace('2007 EMP_CONT ::: LE #### got exemption limit used for LE , leaving ');
1018: ------------------- got exemption limit used for LE
1019:
1020: ------------------ populating the tables g_lu_tab (LU) and g_mu_tab (MU)
1021: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab , entering');
1022:
1023: -- from 2007 , the tax municipality will be picked from the local unit
1024:
1025: l_temp := populate_tables

Line 1032: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');

1028: ,p_date_earned
1029: ,g_lu_tab
1030: ,g_mu_tab );
1031:
1032: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
1033:
1034: -------------------- Fetch the run base using assignment level balances (at LE level)
1035: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
1036:

Line 1035: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');

1031:
1032: hr_utility.trace('2007 EMP_CONT ::: LE #### populating the tables g_lu_tab and g_mu_tab, leaving ');
1033:
1034: -------------------- Fetch the run base using assignment level balances (at LE level)
1035: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the run base using assignment level balances , entering');
1036:
1037: -- get defined balance ids
1038: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
1039: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;

Line 1041: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

1037: -- get defined balance ids
1038: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
1039: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
1040:
1041: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1042: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1043: -- Added 29-dec-2012
1044:
1045: OPEN get_balance_type_id ('Employer Contribution Base');

Line 1042: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

1038: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_ASG_TU_MU_LU_BIMONTH') ;
1039: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution Base 2','_ASG_TU_MU_LU_BIMONTH') ;
1040:
1041: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1042: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1043: -- Added 29-dec-2012
1044:
1045: OPEN get_balance_type_id ('Employer Contribution Base');
1046: FETCH get_balance_type_id INTO l_bal_id_1;

Line 1053: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );

1049: OPEN get_balance_type_id ('Employer Contribution Base 2');
1050: FETCH get_balance_type_id INTO l_bal_id_2;
1051: CLOSE get_balance_type_id;
1052:
1053: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
1054: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
1055:
1056: -- End Added 29-dec-2012
1057: ----- test only , Remove it

Line 1054: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );

1050: FETCH get_balance_type_id INTO l_bal_id_2;
1051: CLOSE get_balance_type_id;
1052:
1053: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
1054: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
1055:
1056: -- End Added 29-dec-2012
1057: ----- test only , Remove it
1058: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);

Line 1061: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );

1057: ----- test only , Remove it
1058: OPEN csr_test_aag_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned);
1059: FETCH csr_test_aag_act_id INTO l_check2;
1060: CLOSE csr_test_aag_act_id;
1061: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
1062: -- remove till here
1063:
1064: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
1065:

Line 1064: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );

1060: CLOSE csr_test_aag_act_id;
1061: hr_utility.trace('2007 EMP_CONT ::: LE #### l_check2 , no of rows returned by asg act id cursor = '||l_check2 );
1062: -- remove till here
1063:
1064: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave' );
1065:
1066: -- change 2b -1
1067: -- pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1068: ----

Line 1073: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 , loop csr_curr_le_asg_act_id ' );

1069:
1070: -- loop to get all assignment_action_id in the current payroll_action_id
1071: FOR csr1_rec IN csr_curr_le_asg_act_id (p_tax_unit_id , p_payroll_action_id, p_date_earned) LOOP
1072:
1073: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 , loop csr_curr_le_asg_act_id ' );
1074:
1075: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
1076: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1077:

Line 1080: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2, g_lu_tab ' );

1076: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1077:
1078: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1079:
1080: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2, g_lu_tab ' );
1081:
1082: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1083: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1084:

Line 1091: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );

1087: -----
1088:
1089: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1090:
1091: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
1092: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1093:
1094: --setting the context values
1095: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

Line 1092: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );

1088:
1089: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1090:
1091: hr_utility.trace('2007 EMP_CONT ::: LE #### level 3, g_mu_tab ' );
1092: hr_utility.trace('2007 EMP_CONT ::: LE #### ASS_ACT_ID = '|| csr1_rec.ASSIGNMENT_ACTION_ID || ' MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1093:
1094: --setting the context values
1095: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));
1096:

Line 1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );

1098: /* l_asg_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1100: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1101:
1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1103: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1104: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
1105: -- Added on 29-Dec-2012
1106: OPEN get_ASG_TU_MU_LU_BIMONTH

Line 1103: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );

1099: l_asg_ers_base2 := pay_balance_pkg.get_value(l_def_bal_id_2,csr1_rec.ASSIGNMENT_ACTION_ID,TRUE,FALSE);
1100: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1101:
1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1103: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1104: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
1105: -- Added on 29-Dec-2012
1106: OPEN get_ASG_TU_MU_LU_BIMONTH
1107: (csr1_rec.ASSIGNMENT_ACTION_ID

Line 1104: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */

1100: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1101:
1102: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base = '|| l_asg_ers_base );
1103: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base2 = '|| l_asg_ers_base2 );
1104: hr_utility.trace('2007 EMP_CONT ::: LE #### l_asg_ers_base_diff = '|| l_asg_ers_base_diff ); */
1105: -- Added on 29-Dec-2012
1106: OPEN get_ASG_TU_MU_LU_BIMONTH
1107: (csr1_rec.ASSIGNMENT_ACTION_ID
1108: , l_bal_id_1

Line 1128: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );

1124: CLOSE get_ASG_TU_MU_LU_BIMONTH;
1125:
1126: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1127:
1128: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
1129: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
1130: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1131:
1132:

Line 1129: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );

1125:
1126: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1127:
1128: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
1129: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
1130: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1131:
1132:
1133: -- End 29-Dec-2012

Line 1130: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );

1126: l_asg_ers_base_diff := l_asg_ers_base - l_asg_ers_base2;
1127:
1128: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base = '|| l_asg_ers_base );
1129: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base2 = '|| l_asg_ers_base2 );
1130: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1131:
1132:
1133: -- End 29-Dec-2012
1134: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');

Line 1134: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');

1130: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_asg_ers_base_diff = '|| l_asg_ers_base_diff );
1131:
1132:
1133: -- End 29-Dec-2012
1134: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
1135:
1136: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1137:
1138: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 1136: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

1132:
1133: -- End 29-Dec-2012
1134: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking================= ');
1135:
1136: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1137:
1138: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1139:
1140: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

Line 1140: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

1136: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1137:
1138: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1139:
1140: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
1141:
1142: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1143: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1144:

Line 1145: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );

1141:
1142: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1143: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1144:
1145: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );
1146:
1147: l_cell := lookup_cell(g_tab_calc,l_zone);
1148: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
1149:

Line 1150: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );

1146:
1147: l_cell := lookup_cell(g_tab_calc,l_zone);
1148: g_tab_calc(l_cell).run_base := g_tab_calc(l_cell).run_base + l_asg_ers_base_diff ;
1149:
1150: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );
1151:
1152: start_index_mu := start_index_mu + 1;
1153: END LOOP; -- end while loop g_mu_tab
1154:

Line 1160: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );

1156: END LOOP; -- end while loop g_lu_tab
1157:
1158: END LOOP; -- end loop csr1_rec
1159:
1160: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1161:
1162: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1163: l_check := display_table_calc(g_tab_calc);
1164: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 1162: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1158: END LOOP; -- end loop csr1_rec
1159:
1160: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1161:
1162: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1163: l_check := display_table_calc(g_tab_calc);
1164: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1165:
1166: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');

Line 1164: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1160: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1161:
1162: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1163: l_check := display_table_calc(g_tab_calc);
1164: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1165:
1166: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1167: -------------------- Fetched the run base using assignment level balances (at LE level)
1168:

Line 1166: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');

1162: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1163: l_check := display_table_calc(g_tab_calc);
1164: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1165:
1166: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1167: -------------------- Fetched the run base using assignment level balances (at LE level)
1168:
1169: -------------------- Fetch the bimonth base using group level balances (at LE level)
1170: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');

Line 1170: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');

1166: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetched the run base using assignment level balances , leaving');
1167: -------------------- Fetched the run base using assignment level balances (at LE level)
1168:
1169: -------------------- Fetch the bimonth base using group level balances (at LE level)
1170: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , entering');
1171:
1172: -- get defined balance ids
1173: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1174: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;

Line 1176: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );

1172: -- get defined balance ids
1173: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1174: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
1175:
1176: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1177: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1178: -- added 29-dec-2012
1179: OPEN get_balance_type_id ('Employer Contribution Base');
1180: FETCH get_balance_type_id INTO l_bal_id_1;

Line 1177: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );

1173: l_def_bal_id_1 := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1174: l_def_bal_id_2 := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
1175:
1176: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_1 = '|| l_def_bal_id_1 );
1177: hr_utility.trace('2007 EMP_CONT ::: LE #### l_def_bal_id_2 = '|| l_def_bal_id_2 );
1178: -- added 29-dec-2012
1179: OPEN get_balance_type_id ('Employer Contribution Base');
1180: FETCH get_balance_type_id INTO l_bal_id_1;
1181: CLOSE get_balance_type_id;

Line 1187: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );

1183: OPEN get_balance_type_id ('Employer Contribution');
1184: FETCH get_balance_type_id INTO l_bal_id_2;
1185: CLOSE get_balance_type_id;
1186:
1187: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
1188: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
1189:
1190: --end 29-Dec-2012
1191:

Line 1188: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );

1184: FETCH get_balance_type_id INTO l_bal_id_2;
1185: CLOSE get_balance_type_id;
1186:
1187: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_1 = '|| l_bal_id_1 );
1188: hr_utility.trace('2007 RP EMP_CONT ::: LU ***** l_bal_id_2 = '|| l_bal_id_2 );
1189:
1190: --end 29-Dec-2012
1191:
1192: -- loop to get all LU in g_lu_tab

Line 1197: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );

1193:
1194: start_index_lu := NVL (g_lu_tab.FIRST, 0) ;
1195: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1196:
1197: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 leave ' );
1198:
1199: -- change 3b -1
1200: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1201: ----

Line 1205: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 ,g_lu_tab ' );

1201: ----
1202:
1203: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1204:
1205: hr_utility.trace('2007 EMP_CONT ::: LE #### level 1 ,g_lu_tab ' );
1206:
1207: -- loop to get all MU in g_mu_tab
1208: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1209: end_index_mu := NVL (g_mu_tab.LAST, 0) ;

Line 1217: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );

1213: ----
1214:
1215: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1216:
1217: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1218:
1219: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1220:
1221: --setting the context values

Line 1219: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );

1215: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1216:
1217: hr_utility.trace('2007 EMP_CONT ::: LE #### level 2 ,g_mu_tab ' );
1218:
1219: hr_utility.trace('2007 EMP_CONT ::: LE #### MU = '|| g_mu_tab(start_index_mu)|| ' LU = '|| g_lu_tab(start_index_lu) );
1220:
1221: --setting the context values
1222: --pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
1223: -- pay_balance_pkg.set_context('JURISDICTION_CODE',g_mu_tab(start_index_mu));

Line 1230: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);

1226: -- get the balance value
1227: /* l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1228: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1229:
1230: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers ); */
1232: -- added 29-dec-2012
1233:
1234: OPEN get_TU_MU_LU_BIMONTH

Line 1231: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers ); */

1227: /* l_le_ers_base := pay_balance_pkg.get_value(l_def_bal_id_1,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1228: l_le_ers := pay_balance_pkg.get_value(l_def_bal_id_2,p_asg_act_id,p_tax_unit_id,g_mu_tab(start_index_mu),NULL,NULL,NULL,l_bimonth_end_date);
1229:
1230: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers_base = '|| l_le_ers_base);
1231: hr_utility.trace('2007 EMP_CONT ::: LE #### l_le_ers = '||l_le_ers ); */
1232: -- added 29-dec-2012
1233:
1234: OPEN get_TU_MU_LU_BIMONTH
1235: (l_bimonth_end_date

Line 1252: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers_base = '|| l_le_ers_base);

1248: , g_lu_tab(start_index_lu) );
1249: FETCH get_TU_MU_LU_BIMONTH INTO l_le_ers;
1250: CLOSE get_TU_MU_LU_BIMONTH;
1251:
1252: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers_base = '|| l_le_ers_base);
1253: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers = '||l_le_ers );
1254:
1255: -- End 29-dec-2012
1256:

Line 1253: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers = '||l_le_ers );

1249: FETCH get_TU_MU_LU_BIMONTH INTO l_le_ers;
1250: CLOSE get_TU_MU_LU_BIMONTH;
1251:
1252: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers_base = '|| l_le_ers_base);
1253: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers = '||l_le_ers );
1254:
1255: -- End 29-dec-2012
1256:
1257: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');

Line 1257: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');

1253: hr_utility.trace('2007 EMP_CONT RP::: LU ***** l_le_ers = '||l_le_ers );
1254:
1255: -- End 29-dec-2012
1256:
1257: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1258:
1259: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1260:
1261: l_zone_temp := to_char(g_mu_tab(start_index_mu));

Line 1259: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );

1255: -- End 29-dec-2012
1256:
1257: hr_utility.trace('2007 EMP_CONT ::: LE #### ============== just checking again ================= ');
1258:
1259: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1260:
1261: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1262:
1263: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

Line 1263: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );

1259: hr_utility.trace('2007 EMP_CONT ::: LE #### g_mu_tab(start_index_mu) = '|| g_mu_tab(start_index_mu) );
1260:
1261: l_zone_temp := to_char(g_mu_tab(start_index_mu));
1262:
1263: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_temp = '|| l_zone_temp );
1264:
1265: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1266: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1267:

Line 1268: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );

1264:
1265: -- l_zone := to_number(substr(get_lookup_meaning('NO_TAX_MUNICIPALITY',l_zone_temp),1,1));
1266: l_zone := hruserdt.get_table_value (p_bus_group_id, 'NO_TAX_MUNICIPALITY' , 'ZONE', l_zone_temp, p_date_earned ) ;
1267:
1268: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone = '|| l_zone );
1269:
1270: l_cell := lookup_cell(g_tab_calc,l_zone);
1271: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1272: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;

Line 1274: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );

1270: l_cell := lookup_cell(g_tab_calc,l_zone);
1271: g_tab_calc(l_cell).bimonth_base := g_tab_calc(l_cell).bimonth_base + l_le_ers_base ;
1272: g_tab_calc(l_cell).bimonth_contribution_todate := g_tab_calc(l_cell).bimonth_contribution_todate + l_le_ers ;
1273:
1274: hr_utility.trace('2007 EMP_CONT ::: LE #### l_cell = '|| l_cell );
1275:
1276: start_index_mu := start_index_mu + 1;
1277: END LOOP; -- end while loop g_mu_tab
1278:

Line 1282: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );

1278:
1279: start_index_lu := start_index_lu + 1;
1280: END LOOP; -- end while loop g_lu_tab
1281:
1282: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1283:
1284: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1285: l_check := display_table_calc(g_tab_calc);
1286: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 1284: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1280: END LOOP; -- end while loop g_lu_tab
1281:
1282: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1283:
1284: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1285: l_check := display_table_calc(g_tab_calc);
1286: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1287:
1288: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');

Line 1286: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1282: hr_utility.trace('2007 EMP_CONT ::: LE #### level 0 back' );
1283:
1284: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1285: l_check := display_table_calc(g_tab_calc);
1286: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1287:
1288: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1289: -------------------- Fetched the bimonth base using group level balances (at LE level)
1290:

Line 1288: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');

1284: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1285: l_check := display_table_calc(g_tab_calc);
1286: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1287:
1288: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1289: -------------------- Fetched the bimonth base using group level balances (at LE level)
1290:
1291: ------------------------------ apply differential rate and check exemption limit at LE Level
1292: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');

Line 1292: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');

1288: hr_utility.trace('2007 EMP_CONT ::: LE #### Fetch the bimonth base using group level balances , leaving ');
1289: -------------------- Fetched the bimonth base using group level balances (at LE level)
1290:
1291: ------------------------------ apply differential rate and check exemption limit at LE Level
1292: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , entering ');
1293:
1294: --l_lu_status --status for LU
1295: --l_le_status --status for LE
1296: l_total_saving := 0;

Line 1302: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = Y ' );

1298: -- check if exemption limit already used up
1299: IF l_LE_over_limit = 'Y'
1300:
1301: THEN
1302: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = Y ' );
1303:
1304: -- as limit is over, put under_limit as N for all rows
1305: FOR i IN 1..7 LOOP
1306: g_tab_calc(i).under_limit := 'N';

Line 1309: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');

1305: FOR i IN 1..7 LOOP
1306: g_tab_calc(i).under_limit := 'N';
1307: END LOOP; -- end i loop
1308:
1309: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1310:
1311: ELSE
1312: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1313:

Line 1312: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );

1308:
1309: hr_utility.trace('2007 EMP_CONT ::: LE #### as limit is over, put under_limit as N for all rows ');
1310:
1311: ELSE
1312: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = N ' );
1313:
1314: -- limit is not over
1315: -- perform exemption limit check only if status = AA,CC,GG
1316: IF ( l_le_status = 'AA' OR l_le_status = 'GG' OR l_le_status = 'CC' )

Line 1319: hr_utility.trace('2007 EMP_CONT ::: LE #### status is = '|| l_le_status );

1315: -- perform exemption limit check only if status = AA,CC,GG
1316: IF ( l_le_status = 'AA' OR l_le_status = 'GG' OR l_le_status = 'CC' )
1317:
1318: THEN
1319: hr_utility.trace('2007 EMP_CONT ::: LE #### status is = '|| l_le_status );
1320:
1321: -------- performing exemption limit check
1322: l_table_name := 'NO_NIS_ZONE_RATES';
1323:

Line 1334: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit check ----------------------' );

1330:
1331: l_col_name := 'NIS Rates';
1332: l_high_rate := p_under_age_high_rate;
1333:
1334: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit check ----------------------' );
1335:
1336: l_zone_value := to_char(g_tab_calc(i).zone);
1337: -- l_normal_rate := TO_NUMBER(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));
1338: l_normal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value (p_bus_group_id, l_table_name, l_col_name, l_zone_value, p_date_earned ));

Line 1344: hr_utility.trace('2007 EMP_CONT ::: LE #### i = '||i||' l_zone_value = '||l_zone_value

1340:
1341: l_saving := ( g_tab_calc(i).bimonth_base * l_diff_rate ) / 100 ;
1342: l_total_saving := l_total_saving + l_saving ;
1343:
1344: hr_utility.trace('2007 EMP_CONT ::: LE #### i = '||i||' l_zone_value = '||l_zone_value
1345: ||' l_normal_rate = '||l_normal_rate||' l_high_rate = '||l_high_rate
1346: ||' l_diff_rate = '||l_diff_rate||' l_saving = '||l_saving||' l_total_saving = '||l_total_saving );
1347:
1348: -- check if exemption limit exceeded

Line 1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');

1347:
1348: -- check if exemption limit exceeded
1349: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1350: THEN
1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );

Line 1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );

1348: -- check if exemption limit exceeded
1349: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1350: THEN
1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );

Line 1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );

1349: IF ((l_exemption_limit_used_yet + l_total_saving) >= l_exemption_limit)
1350: THEN
1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );

Line 1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );

1350: THEN
1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );

Line 1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );

1351: hr_utility.trace('2007 EMP_CONT ::: LE #### exemption limit exceeded in table');
1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );

Line 1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );

1352: hr_utility.trace('2007 EMP_CONT ::: LE #### bimonth_base = '|| g_tab_calc(i).bimonth_base );
1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

Line 1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );

1353: hr_utility.trace('2007 EMP_CONT ::: LE #### run_base = '||g_tab_calc(i).run_base );
1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1361:

Line 1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );

1354: hr_utility.trace('2007 EMP_CONT ::: LE #### l_zone_value = '|| l_zone_value );
1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1361:
1362: -- get the exceeding amount

Line 1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );

1355: hr_utility.trace('2007 EMP_CONT ::: LE #### l_normal_rate = '|| l_normal_rate );
1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1361:
1362: -- get the exceeding amount
1363: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);

Line 1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );

1356: hr_utility.trace('2007 EMP_CONT ::: LE #### l_high_rate = '|| l_high_rate );
1357: hr_utility.trace('2007 EMP_CONT ::: LE #### l_diff_rate = '|| l_diff_rate );
1358: hr_utility.trace('2007 EMP_CONT ::: LE #### l_saving = '|| l_saving );
1359: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving= '|| l_total_saving );
1360: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used_yet = '|| l_exemption_limit_used_yet );
1361:
1362: -- get the exceeding amount
1363: l_amount_over_limit := ((l_exemption_limit_used_yet + l_total_saving) - l_exemption_limit);
1364: l_base_over_limit := ( l_amount_over_limit / l_diff_rate ) * 100 ;

Line 1390: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );

1386: -- set the new l_total_saving
1387:
1388: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1389:
1390: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1391: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1392: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1393: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1394:

Line 1391: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );

1387:
1388: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1389:
1390: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1391: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1392: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1393: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1394:
1395: -- insert a new row for exceeded limit

Line 1392: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );

1388: l_total_saving := l_exemption_limit - l_exemption_limit_used_yet ;
1389:
1390: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1391: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1392: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1393: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1394:
1395: -- insert a new row for exceeded limit
1396:

Line 1393: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );

1389:
1390: hr_utility.trace('2007 EMP_CONT ::: LE #### l_amount_over_limit = '|| l_amount_over_limit );
1391: hr_utility.trace('2007 EMP_CONT ::: LE #### l_base_over_limit = '|| l_base_over_limit );
1392: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW bimonth base for current row = '|| g_tab_calc(i).bimonth_base );
1393: hr_utility.trace('2007 EMP_CONT ::: LE #### NEW l_total_saving = '|| l_total_saving );
1394:
1395: -- insert a new row for exceeded limit
1396:
1397: g_tab_calc(8).zone := g_tab_calc(i).zone;

Line 1415: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );

1411: END LOOP; --end j loop
1412:
1413: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1414:
1415: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );
1416: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1417:
1418: EXIT; -- exit loop i since no more check is required
1419: END IF; -- end check if exemption limit exceeded

Line 1416: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );

1412:
1413: l_LE_over_limit := 'Y'; -- indicating exemption limit on LE level is over
1414:
1415: --hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit Y' );
1416: hr_utility.trace('2007 EMP_CONT ::: LE #### l_LE_over_limit = '||l_LE_over_limit );
1417:
1418: EXIT; -- exit loop i since no more check is required
1419: END IF; -- end check if exemption limit exceeded
1420:

Line 1436: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );

1432: END IF; -- end if l_LE_over_limit = Y
1433:
1434: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1435:
1436: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1437: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1439:
1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

Line 1437: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );

1433:
1434: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1435:
1436: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1437: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1439:
1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1441: l_check := display_table_calc(g_tab_calc);

Line 1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );

1434: l_exemption_limit_used := l_total_saving - l_bal_val_bimonth ;
1435:
1436: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1437: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1439:
1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1441: l_check := display_table_calc(g_tab_calc);
1442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

Line 1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1436: hr_utility.trace('2007 EMP_CONT ::: LE #### l_total_saving = '||l_total_saving );
1437: hr_utility.trace('2007 EMP_CONT ::: LE #### l_bal_val_bimonth = '||l_bal_val_bimonth );
1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1439:
1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1441: l_check := display_table_calc(g_tab_calc);
1442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1443:
1444: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');

Line 1442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1438: hr_utility.trace('2007 EMP_CONT ::: LE #### l_exemption_limit_used = '||l_exemption_limit_used );
1439:
1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1441: l_check := display_table_calc(g_tab_calc);
1442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1443:
1444: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1445: ------------------------------ applied differential rate and check exemption limit at LE Level
1446:

Line 1444: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');

1440: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1441: l_check := display_table_calc(g_tab_calc);
1442: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1443:
1444: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1445: ------------------------------ applied differential rate and check exemption limit at LE Level
1446:
1447: -- ec_main_calculation function call for LE
1448: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );

Line 1448: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );

1444: hr_utility.trace('2007 EMP_CONT ::: LE #### apply differential rate and check exemption limit , leaving ');
1445: ------------------------------ applied differential rate and check exemption limit at LE Level
1446:
1447: -- ec_main_calculation function call for LE
1448: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , entering ' );
1449:
1450: l_main_index := ec_main_calculation ( g_tab_calc
1451: ,PAY_NO_EMP_CONT_2007.g_tab_main
1452: ,p_tax_unit_id

Line 1464: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');

1460: ,l_curr_zone ) ;
1461:
1462:
1463:
1464: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1465: l_check := display_table_calc(g_tab_calc);
1466: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1467:
1468: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );

Line 1466: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');

1462:
1463:
1464: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1465: l_check := display_table_calc(g_tab_calc);
1466: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1467:
1468: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1469:
1470: -- done all caclculation and entered values in the main table for next time usage

Line 1468: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );

1464: hr_utility.trace('2007 EMP_CONT ::: -- calling display_table_calc function ');
1465: l_check := display_table_calc(g_tab_calc);
1466: hr_utility.trace('2007 EMP_CONT ::: -- returned from display_table_calc function ');
1467:
1468: hr_utility.trace('2007 EMP_CONT ::: LE #### ec_main_calculation function call for LE , leaving ' );
1469:
1470: -- done all caclculation and entered values in the main table for next time usage
1471:
1472: -- returning values at LE level

Line 1477: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );

1473: p_run_base := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_base;
1474: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
1475: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1476:
1477: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1481:

Line 1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );

1474: p_run_contribution := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).run_contribution;
1475: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1476:
1477: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1481:
1482: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

Line 1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );

1475: p_curr_exemption_limit_used := PAY_NO_EMP_CONT_2007.g_tab_main(l_main_index).exemption_limit_used;
1476:
1477: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1481:
1482: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1483:

Line 1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );

1476:
1477: hr_utility.trace('2007 EMP_CONT ::: LE #### l_main_index = '|| l_main_index );
1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1481:
1482: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1483:
1484: RETURN 1; -- here return 1 and the other values thru OUT parameters

Line 1482: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');

1478: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_base = '|| p_run_base );
1479: hr_utility.trace('2007 EMP_CONT ::: LE #### p_run_contribution = '|| p_run_contribution );
1480: hr_utility.trace('2007 EMP_CONT ::: LE #### p_curr_exemption_limit_used = '|| p_curr_exemption_limit_used );
1481:
1482: hr_utility.trace('2007 EMP_CONT ::: LE #### Leaving procedure-----------------------------------');
1483:
1484: RETURN 1; -- here return 1 and the other values thru OUT parameters
1485:
1486:

Line 1492: hr_utility.trace('2007 EMP_CONT ::: exiting main function');

1488:
1489:
1490: END IF; -- end if l_lu_rep_sep = 'Y'
1491:
1492: hr_utility.trace('2007 EMP_CONT ::: exiting main function');
1493: --hr_utility.trace_off();
1494:
1495: -----------------------------------Exception -----------------------------------------------------------
1496: --EXCEPTION

Line 1493: --hr_utility.trace_off();

1489:
1490: END IF; -- end if l_lu_rep_sep = 'Y'
1491:
1492: hr_utility.trace('2007 EMP_CONT ::: exiting main function');
1493: --hr_utility.trace_off();
1494:
1495: -----------------------------------Exception -----------------------------------------------------------
1496: --EXCEPTION
1497:

Line 1597: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');

1593:
1594: -- loop to get local unit and tax municipality for all assignment actions obtained above
1595: FOR csr3_rec IN PAY_NO_EMP_CONT_2007.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_ele_type_id ) LOOP
1596:
1597: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');
1598:
1599: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1600: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1601:

Line 1599: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID

1595: FOR csr3_rec IN PAY_NO_EMP_CONT_2007.csr_lu_mu (csr2_rec.ASSIGNMENT_ID , csr2_rec.ASSIGNMENT_ACTION_ID , p_date_earned , l_tax_ele_type_id ) LOOP
1596:
1597: hr_utility.trace('2007 EMP_CONT ::: --------------------------------------------------------');
1598:
1599: hr_utility.trace('2007 EMP_CONT ::: PAY_ACT_ID = '||csr1_rec.PAYROLL_ACTION_ID||' ASS_ID = '||csr2_rec.ASSIGNMENT_ID||' ASS_ACT_ID = '||csr2_rec.ASSIGNMENT_ACTION_ID
1600: ||' Local Unit = '||csr3_rec.local_unit_id||' Tax Mul = '||csr3_rec.tax_mun_id);
1601:
1602: ----------------------------- check for MU -------------------------------------------
1603: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;

Line 1675: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

1671: start_index_mu := NVL (g_mu_tab.FIRST, 0) ;
1672: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1673:
1674: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1675: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1676: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1677:
1678: start_index_mu := start_index_mu + 1;
1679: END LOOP; -- end while loop

Line 1676: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));

1672: end_index_mu := NVL (g_mu_tab.LAST, 0) ;
1673:
1674: WHILE (g_mu_tab.EXISTS(start_index_mu)) and (start_index_mu <= end_index_mu) LOOP
1675: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1676: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1677:
1678: start_index_mu := start_index_mu + 1;
1679: END LOOP; -- end while loop
1680: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

Line 1680: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');

1676: hr_utility.trace('2007 EMP_CONT ::: Tax Mul = '|| g_mu_tab(start_index_mu));
1677:
1678: start_index_mu := start_index_mu + 1;
1679: END LOOP; -- end while loop
1680: hr_utility.trace('2007 EMP_CONT ::: *****************************************************************************');
1681:
1682: -- end sub test 1
1683: -------------------------------------------------------------------------------------------------
1684:

Line 1693: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1689: end_index_lu := NVL (g_lu_tab.LAST, 0) ;
1690:
1691:
1692: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1693: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1694: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1695:
1696: start_index_lu := start_index_lu + 1;
1697: END LOOP; -- end while loop

Line 1694: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));

1690:
1691:
1692: WHILE (g_lu_tab.EXISTS(start_index_lu)) and (start_index_lu <= end_index_lu) LOOP
1693: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1694: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1695:
1696: start_index_lu := start_index_lu + 1;
1697: END LOOP; -- end while loop
1698: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

Line 1698: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');

1694: hr_utility.trace('2007 EMP_CONT ::: Local Unit = '|| g_lu_tab(start_index_lu));
1695:
1696: start_index_lu := start_index_lu + 1;
1697: END LOOP; -- end while loop
1698: hr_utility.trace('2007 EMP_CONT ::: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\');
1699:
1700: -- end sub test 2
1701:
1702: ------------------------------

Line 1796: hr_utility.trace('2007 EMP_CONT ::: Initializing Main Table --------');

1792: start_main_index := NVL (g_tab_main.LAST, 0) + 1 ;
1793: end_main_index := start_main_index + 6 ;
1794: x := 1;
1795:
1796: hr_utility.trace('2007 EMP_CONT ::: Initializing Main Table --------');
1797:
1798: -- initialize 7 rows of the main table g_tab_main
1799: ------------------------------------------------------------------------------------------------------
1800:

Line 1829: hr_utility.trace('2007 EMP_CONT ::: Finished Initializing Main Table --------');

1825:
1826:
1827: END LOOP; -- end loop for initializing g_tab_main
1828:
1829: hr_utility.trace('2007 EMP_CONT ::: Finished Initializing Main Table --------');
1830: ------------------------------------------------------------------------------------------------------
1831:
1832: l_run_base := 0;
1833: l_unallocated_cont := 0;

Line 1838: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );

1834:
1835: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1836: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1837:
1838: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );
1839: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1840:
1841: FOR i IN start_index_calc..end_index_calc LOOP
1842:

Line 1839: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );

1835: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
1836: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
1837:
1838: hr_utility.trace('2007 EMP_CONT ::: Main Calc Entered--------' );
1839: hr_utility.trace('2007 EMP_CONT ::: Main Calc i -- p_org_status - zone -- under_limit -- l_rate = -- bimonth_base -- bimonth_cont -- bimonth_todate -- run_cont ' );
1840:
1841: FOR i IN start_index_calc..end_index_calc LOOP
1842:
1843: l_rate := PAY_NO_EMP_CONT_2007.get_ec_rate (g_tab_calc(i).zone

Line 1867: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i

1863: THEN
1864: l_unallocated_cont := l_unallocated_cont + g_tab_calc(i).run_contribution ;
1865: END IF;
1866:
1867: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i
1868: ||' '||p_org_status
1869: ||' '||g_tab_calc(i).zone
1870: ||' '||g_tab_calc(i).under_limit
1871: ||' '||l_rate

Line 1879: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );

1875: ||' '||g_tab_calc(i).run_contribution );
1876:
1877: END LOOP;
1878:
1879: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1880: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1881: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1882:
1883: -- re-allocating the run_contributions that can be allocated

Line 1880: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );

1876:
1877: END LOOP;
1878:
1879: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1880: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1881: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1882:
1883: -- re-allocating the run_contributions that can be allocated
1884: -- and also summing the values to get the final values

Line 1881: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );

1877: END LOOP;
1878:
1879: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- exited from Main calc loop' );
1880: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_run_base = '|| l_run_base );
1881: hr_utility.trace('2007 EMP_CONT ::: Main Calc l_unallocated_cont = '|| l_unallocated_cont );
1882:
1883: -- re-allocating the run_contributions that can be allocated
1884: -- and also summing the values to get the final values
1885:

Line 1886: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- entered loop for re-allocation and summing up values' );

1882:
1883: -- re-allocating the run_contributions that can be allocated
1884: -- and also summing the values to get the final values
1885:
1886: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- entered loop for re-allocation and summing up values' );
1887:
1888: FOR i IN start_index_calc..end_index_calc LOOP
1889:
1890: -- to handle the error of division by zero

Line 1906: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i

1902: l_extra_run_cont := 0 ;
1903:
1904: END IF;
1905:
1906: hr_utility.trace('2007 EMP_CONT ::: Main Calc '||i
1907: ||' '||g_tab_calc(i).run_base
1908: ||' '||l_run_base
1909: ||' '||l_unallocated_cont
1910: ||' '||l_extra_run_cont

Line 1924: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );

1920: g_tab_main(l_curr_index).run_contribution := g_tab_main(l_curr_index).run_contribution + g_tab_calc(i).run_contribution ;
1921:
1922: END LOOP;
1923:
1924: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1925:
1926: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );
1927:
1928: RETURN l_main_index ;

Line 1926: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );

1922: END LOOP;
1923:
1924: hr_utility.trace('2007 EMP_CONT ::: Main Calc --- leaving loop for re-allocation and summing up values' );
1925:
1926: hr_utility.trace('2007 EMP_CONT ::: Main Calc Leaving--------' );
1927:
1928: RETURN l_main_index ;
1929:
1930: END ec_main_calculation ;

Line 2056: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');

2052:
2053: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
2054: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
2055:
2056: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
2057: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2058:
2059: FOR i IN start_index_calc..end_index_calc LOOP
2060:

Line 2057: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');

2053: start_index_calc := NVL (g_tab_calc.FIRST, 0) ;
2054: end_index_calc := NVL (g_tab_calc.LAST, 0) ;
2055:
2056: hr_utility.trace('2007 EMP_CONT ::: ---------- Displaying g_tab_calc table data ----------------------');
2057: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2058:
2059: FOR i IN start_index_calc..end_index_calc LOOP
2060:
2061: hr_utility.trace('2007 EMP_CONT ::: '

Line 2061: hr_utility.trace('2007 EMP_CONT ::: '

2057: hr_utility.trace('2007 EMP_CONT ::: zone -- under_limit -- status -- bimonth_base -- run_base -- bimonth_cont -- bimonth_cont_todate -- run_cont ');
2058:
2059: FOR i IN start_index_calc..end_index_calc LOOP
2060:
2061: hr_utility.trace('2007 EMP_CONT ::: '
2062: ||' '||g_tab_calc(i).zone
2063: ||' '||g_tab_calc(i).under_limit
2064: ||' '||g_tab_calc(i).status
2065: ||' '||g_tab_calc(i).bimonth_base

Line 2072: hr_utility.trace('2007 EMP_CONT ::: ---------- Displayed g_tab_calc table data , exiting function ----------------------');

2068: ||' '||g_tab_calc(i).bimonth_contribution_todate
2069: ||' '||g_tab_calc(i).run_contribution );
2070:
2071: END LOOP;
2072: hr_utility.trace('2007 EMP_CONT ::: ---------- Displayed g_tab_calc table data , exiting function ----------------------');
2073:
2074: RETURN 1 ;
2075:
2076: END display_table_calc ;

Line 2161: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);

2157: l_start_of_year := trunc(p_date_earned, 'Y');
2158:
2159: l_cum_base_rate_value := 0 ;
2160:
2161: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
2162: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2163: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2164: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
2165:

Line 2162: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);

2158:
2159: l_cum_base_rate_value := 0 ;
2160:
2161: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
2162: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2163: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2164: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
2165:
2166: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.

Line 2163: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);

2159: l_cum_base_rate_value := 0 ;
2160:
2161: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
2162: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2163: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2164: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
2165:
2166: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
2167: -- modifying call for cursor csr_get_ni_base_rates

Line 2164: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');

2160:
2161: hr_utility.trace('2007 EMP_CONT ::: p_date_earned = '||p_date_earned);
2162: hr_utility.trace('2007 EMP_CONT ::: l_start_of_year = '||l_start_of_year);
2163: hr_utility.trace('2007 EMP_CONT ::: l_end_of_year = '||l_end_of_year);
2164: hr_utility.trace('2007 EMP_CONT ::: ========================================= ');
2165:
2166: -- Bug Fix 5566622 : Value of G (National Insurance Base Rate) to be taken from Global and not user table.
2167: -- modifying call for cursor csr_get_ni_base_rates
2168:

Line 2180: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);

2176: -- check if effective start date is before the starting of the year
2177:
2178: IF (l_eff_start_date < l_start_of_year)
2179: THEN
2180: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
2181: l_eff_start_date := l_start_of_year;
2182: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
2183: END IF;
2184:

Line 2182: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);

2178: IF (l_eff_start_date < l_start_of_year)
2179: THEN
2180: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_start_date = '||l_eff_start_date);
2181: l_eff_start_date := l_start_of_year;
2182: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_start_date = '||l_eff_start_date);
2183: END IF;
2184:
2185: -- check if effective end date is after the end of the period
2186:

Line 2189: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);

2185: -- check if effective end date is after the end of the period
2186:
2187: IF (l_eff_end_date > l_end_of_year)
2188: THEN
2189: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
2190: l_eff_end_date := l_end_of_year;
2191: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
2192: END IF;
2193:

Line 2191: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);

2187: IF (l_eff_end_date > l_end_of_year)
2188: THEN
2189: hr_utility.trace('2007 EMP_CONT ::: OLD l_eff_end_date = '||l_eff_end_date);
2190: l_eff_end_date := l_end_of_year;
2191: hr_utility.trace('2007 EMP_CONT ::: NEW l_eff_end_date = '||l_eff_end_date);
2192: END IF;
2193:
2194: -- calculating the number of months the value is valid for
2195:

Line 2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

2196: l_no_of_mths := months_between(l_eff_end_date , (l_eff_start_date -1) );
2197: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
2198:
2199:
2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);

Line 2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);

2197: l_cum_base_rate_value := l_cum_base_rate_value + (l_base_rate_value * l_no_of_mths) ;
2198:
2199:
2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);

Line 2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);

2198:
2199:
2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

Line 2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);

2199:
2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

Line 2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);

2200: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2208:

Line 2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);

2201: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value = '||l_base_rate_value);
2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2208:
2209: END LOOP; -- end cursor loop

Line 2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

2202: hr_utility.trace('2007 EMP_CONT ::: l_eff_start_date = '||l_eff_start_date);
2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2208:
2209: END LOOP; -- end cursor loop
2210:

Line 2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');

2203: hr_utility.trace('2007 EMP_CONT ::: l_eff_end_date = '||l_eff_end_date);
2204: hr_utility.trace('2007 EMP_CONT ::: l_no_of_mths = '||l_no_of_mths);
2205: hr_utility.trace('2007 EMP_CONT ::: l_base_rate_value * l_no_of_mths = '||l_base_rate_value * l_no_of_mths);
2206: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2207: hr_utility.trace('2007 EMP_CONT ::: -------------- ');
2208:
2209: END LOOP; -- end cursor loop
2210:
2211: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;

Line 2213: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');

2209: END LOOP; -- end cursor loop
2210:
2211: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2212:
2213: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
2214: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2215: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2216: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
2217:

Line 2214: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);

2210:
2211: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2212:
2213: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
2214: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2215: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2216: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
2217:
2218:

Line 2215: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);

2211: l_avg_base_rate_value := l_cum_base_rate_value / 12 ;
2212:
2213: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
2214: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2215: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2216: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
2217:
2218:
2219: RETURN l_avg_base_rate_value ;

Line 2216: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');

2212:
2213: hr_utility.trace('2007 EMP_CONT ::: =================================================== ');
2214: hr_utility.trace('2007 EMP_CONT ::: l_cum_base_rate_value = '||l_cum_base_rate_value);
2215: hr_utility.trace('2007 EMP_CONT ::: l_avg_base_rate_value = '||l_avg_base_rate_value);
2216: hr_utility.trace('2007 EMP_CONT ::: ---------------- OVER ---------------- ');
2217:
2218:
2219: RETURN l_avg_base_rate_value ;
2220:

Line 2276: hr_utility.trace('2007 EXEM_LIM ::: Entered the procedure for exemption limit ');

2272: l_economic_aid NUMBER;
2273:
2274: BEGIN
2275:
2276: hr_utility.trace('2007 EXEM_LIM ::: Entered the procedure for exemption limit ');
2277: --p_err_text := '';
2278:
2279: IF ( g_error_flag = TRUE )
2280:

Line 2282: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1' );

2278:
2279: IF ( g_error_flag = TRUE )
2280:
2281: THEN
2282: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1' );
2283: RETURN 1 ; -- error has occured already , return 1 to formula funnction and from there just RETURN
2284:
2285: ELSIF ( g_error_check = TRUE )
2286:

Line 2288: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALE but g_error_check = TRUE , returning 0' );

2284:
2285: ELSIF ( g_error_check = TRUE )
2286:
2287: THEN
2288: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALE but g_error_check = TRUE , returning 0' );
2289: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2290:
2291: ELSE -- the error condition has not been checked yet
2292:

Line 2293: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');

2289: RETURN 0 ; -- checking has been done but no error is there , return 0 to formula function , continue processing
2290:
2291: ELSE -- the error condition has not been checked yet
2292:
2293: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');
2294: -- since we are checking the condition now , set the check global to TRUE
2295: g_error_check := TRUE ;
2296: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');
2297:

Line 2296: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');

2292:
2293: hr_utility.trace('2007 EXEM_LIM ::: both globals are false , nocheck has been performed ');
2294: -- since we are checking the condition now , set the check global to TRUE
2295: g_error_check := TRUE ;
2296: hr_utility.trace('2007 EXEM_LIM ::: made g_error_check := TRUE ');
2297:
2298: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2299:
2300: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP

Line 2302: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );

2298: -- loop thru the cursor csr_get_lu_le and get all LE and LU
2299:
2300: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2301:
2302: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );
2303: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2304: -- get the status and report separately for the LU
2305:
2306: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);

Line 2303: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );

2299:
2300: FOR csr_rec in PAY_NO_EMP_CONT_2007.csr_get_lu_le (p_payroll_action_id ,p_date_earned ) LOOP
2301:
2302: hr_utility.trace('2007 EXEM_LIM ::: ------------------Inside For loop------------- ' );
2303: hr_utility.trace('2007 EXEM_LIM ::: Local unit id = '||csr_rec.loc_unit ||' Legal Employer ID = '||csr_rec.leg_emp );
2304: -- get the status and report separately for the LU
2305:
2306: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);
2307: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;

Line 2310: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );

2306: OPEN PAY_NO_EMP_CONT_2007.get_lu_details (csr_rec.loc_unit);
2307: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;
2308: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details ;
2309:
2310: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );
2311: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2312:
2313: -- if report separately = yes and status in AA,CC,GG
2314: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )

Line 2311: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );

2307: FETCH PAY_NO_EMP_CONT_2007.get_lu_details INTO l_status , l_rep_sep , l_lu_tax_mun ;
2308: CLOSE PAY_NO_EMP_CONT_2007.get_lu_details ;
2309:
2310: hr_utility.trace('2007 EXEM_LIM ::: l_status '|| l_status );
2311: hr_utility.trace('2007 EXEM_LIM ::: l_rep_sep '||l_rep_sep );
2312:
2313: -- if report separately = yes and status in AA,CC,GG
2314: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )
2315:

Line 2317: hr_utility.trace('2007 EXEM_LIM ::: local unit is rep sep and status in AA,CC,GG....fetching exemption limit ');

2313: -- if report separately = yes and status in AA,CC,GG
2314: IF ( trim(l_rep_sep) = 'Y' ) AND ( l_status IN ('AA','CC','GG') )
2315:
2316: THEN
2317: hr_utility.trace('2007 EXEM_LIM ::: local unit is rep sep and status in AA,CC,GG....fetching exemption limit ');
2318: -- then open exemption limit cursor
2319: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit (csr_rec.loc_unit, p_date_earned) ;
2320:
2321: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 2329: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );

2325: -- if any error is there
2326: -- checking if no data returned for Exemption Limit
2327: IF (PAY_NO_EMP_CONT_2007.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2328: THEN
2329: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );
2330: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2331:
2332: -- get global error flag to TRUE
2333: g_error_flag := TRUE ;

Line 2334: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');

2330: -- Exemption Limit for this Local Unit Not Specified for this Period or not specified at all
2331:
2332: -- get global error flag to TRUE
2333: g_error_flag := TRUE ;
2334: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');
2335:
2336: -- get the name of the local unit
2337: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2338: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;

Line 2341: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );

2337: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.loc_unit ,p_bus_grp_id );
2338: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;
2339: CLOSE PAY_NO_EMP_CONT_2007.csr_org_name;
2340:
2341: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2342:
2343: -- Set the message and message token
2344: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2345: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

Line 2344: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');

2340:
2341: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2342:
2343: -- Set the message and message token
2344: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2345: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2346:
2347: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:

Line 2345: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

2341: hr_utility.trace('2007 EXEM_LIM ::: name of local unit = '|| l_org_name );
2342:
2343: -- Set the message and message token
2344: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2345: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2346:
2347: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file

Line 2347: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );

2343: -- Set the message and message token
2344: hr_utility.set_message (801, 'PAY_376856_NO_LU_NO_EXEM_LIMIT');
2345: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2346:
2347: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351:

Line 2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

2346:
2347: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351:
2352: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2353:
2354: -- p_err_text := p_err_text || hr_utility.get_message ;

Line 2352: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

2348:
2349: -- Put the meassage in the log file
2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351:
2352: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2353:
2354: -- p_err_text := p_err_text || hr_utility.get_message ;
2355:
2356: END IF; -- end exemption limit got check

Line 2354: -- p_err_text := p_err_text || hr_utility.get_message ;

2350: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2351:
2352: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2353:
2354: -- p_err_text := p_err_text || hr_utility.get_message ;
2355:
2356: END IF; -- end exemption limit got check
2357:
2358: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;

Line 2363: hr_utility.trace('2007 EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');

2359:
2360: ELSIF ( trim(l_rep_sep) = 'N' ) -- else if LU is not rep sep , check at the legal employer level
2361:
2362: THEN
2363: hr_utility.trace('2007 EXEM_LIM ::: local unit is NOT rep sep....fetching LE Status ');
2364: -- get the status of the LE
2365: OPEN PAY_NO_EMP_CONT_2007.get_le_status (csr_rec.leg_emp) ;
2366: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_status ;
2367: CLOSE PAY_NO_EMP_CONT_2007.get_le_status ;

Line 2369: hr_utility.trace('2007 EXEM_LIM ::: LE l_status '|| l_status );

2365: OPEN PAY_NO_EMP_CONT_2007.get_le_status (csr_rec.leg_emp) ;
2366: FETCH PAY_NO_EMP_CONT_2007.get_le_status INTO l_status ;
2367: CLOSE PAY_NO_EMP_CONT_2007.get_le_status ;
2368:
2369: hr_utility.trace('2007 EXEM_LIM ::: LE l_status '|| l_status );
2370:
2371: -- if the status of LE in AA,CC,GG
2372: IF ( l_status IN ('AA','CC','GG') )
2373: THEN

Line 2374: hr_utility.trace('2007 EXEM_LIM ::: Legal Emp status in AA,CC,GG ....fetching exemption limit ');

2370:
2371: -- if the status of LE in AA,CC,GG
2372: IF ( l_status IN ('AA','CC','GG') )
2373: THEN
2374: hr_utility.trace('2007 EXEM_LIM ::: Legal Emp status in AA,CC,GG ....fetching exemption limit ');
2375: -- then open exemption limit cursor
2376: OPEN PAY_NO_EMP_CONT_2007.csr_get_exemption_limit (csr_rec.leg_emp, p_date_earned) ;
2377:
2378: -- 2007 Legislative changes for 'Economic Aid' to Employer

Line 2386: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );

2382: -- if any error is there
2383: -- checking if no data returned for Exemption Limit
2384: IF (PAY_NO_EMP_CONT_2007.csr_get_exemption_limit%NOTFOUND OR l_exempt_limit IS NULL)
2385: THEN
2386: hr_utility.trace('2007 EXEM_LIM ::: Problem in getting Exemption limit ' );
2387: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2388:
2389: -- get global error flag to TRUE
2390: g_error_flag := TRUE ;

Line 2391: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');

2387: -- Exemption Limit for this Legal Emplyer Not Specified for this Period or not specified at all
2388:
2389: -- get global error flag to TRUE
2390: g_error_flag := TRUE ;
2391: hr_utility.trace('2007 EXEM_LIM ::: set g_error_flag = TRUE ');
2392:
2393: -- get the name of the Legal Employer
2394: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2395: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;

Line 2398: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );

2394: OPEN PAY_NO_EMP_CONT_2007.csr_org_name(csr_rec.leg_emp ,p_bus_grp_id );
2395: FETCH PAY_NO_EMP_CONT_2007.csr_org_name INTO l_org_name ;
2396: CLOSE PAY_NO_EMP_CONT_2007.csr_org_name;
2397:
2398: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2399:
2400: -- Set the message and message token
2401: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

Line 2401: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');

2397:
2398: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2399:
2400: -- Set the message and message token
2401: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2404:
2405: -- Put the meassage in the log file

Line 2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);

2398: hr_utility.trace('2007 EXEM_LIM ::: name of legal employer = '|| l_org_name );
2399:
2400: -- Set the message and message token
2401: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2404:
2405: -- Put the meassage in the log file
2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );

2399:
2400: -- Set the message and message token
2401: hr_utility.set_message (801, 'PAY_376857_NO_LE_NO_EXEM_LIMIT');
2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2404:
2405: -- Put the meassage in the log file
2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2407: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

Line 2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

2402: hr_utility.set_message_token (801, 'ORG_NAME', l_org_name);
2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2404:
2405: -- Put the meassage in the log file
2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2407: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2408:
2409: -- p_err_text := p_err_text || hr_utility.get_message ;
2410:

Line 2407: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');

2403: hr_utility.trace('2007 EXEM_LIM ::: set the message = '||hr_utility.get_message );
2404:
2405: -- Put the meassage in the log file
2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2407: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2408:
2409: -- p_err_text := p_err_text || hr_utility.get_message ;
2410:
2411: END IF; -- end exemption limit got check

Line 2409: -- p_err_text := p_err_text || hr_utility.get_message ;

2405: -- Put the meassage in the log file
2406: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
2407: hr_utility.trace('2007 EXEM_LIM ::: put the msg in the log file ');
2408:
2409: -- p_err_text := p_err_text || hr_utility.get_message ;
2410:
2411: END IF; -- end exemption limit got check
2412:
2413: CLOSE PAY_NO_EMP_CONT_2007.csr_get_exemption_limit;

Line 2421: hr_utility.trace('2007 EXEM_LIM ::: **** end of loop * ');

2417: END IF ; -- end if report separately = yes and status in AA,CC,GG
2418:
2419: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2420:
2421: hr_utility.trace('2007 EXEM_LIM ::: **************** end of loop ************* ');
2422:
2423: hr_utility.trace('2007 EXEM_LIM ::: final error check ');
2424:
2425: -- finally check if any error did occur

Line 2423: hr_utility.trace('2007 EXEM_LIM ::: final error check ');

2419: END LOOP; -- end loop thru the cursor csr_get_lu_le and get all LE and LU
2420:
2421: hr_utility.trace('2007 EXEM_LIM ::: **************** end of loop ************* ');
2422:
2423: hr_utility.trace('2007 EXEM_LIM ::: final error check ');
2424:
2425: -- finally check if any error did occur
2426: IF ( g_error_flag = TRUE )
2427: THEN

Line 2428: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');

2424:
2425: -- finally check if any error did occur
2426: IF ( g_error_flag = TRUE )
2427: THEN
2428: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2429: RETURN 1 ; -- error did occur
2430: ELSE
2431: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2432: RETURN 0 ; -- error didnot occur

Line 2431: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');

2427: THEN
2428: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = TRUE , returning 1 ');
2429: RETURN 1 ; -- error did occur
2430: ELSE
2431: hr_utility.trace('2007 EXEM_LIM ::: g_error_flag = FALSE , returning 1 ');
2432: RETURN 0 ; -- error didnot occur
2433:
2434: END IF; -- end final check for error
2435: