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_KR_YEA20120101_PKG dependencies on HR_UTILITY

Line 32: g_debug constant boolean := hr_utility.debug_enabled;

28: l_dummy_taxable_income number default 0;
29: label number default 0;
30: l_row_count number default 0;
31: l_spec_actual_amount number default 0;
32: g_debug constant boolean := hr_utility.debug_enabled;
33: -- End of Bug 9393732
34: --
35: l_credit_card_exp number default 0; -- Bug 11665554
36: -- Bug 3901912

Line 315: hr_utility.trace('* Insert Donation Details *');

311: --
312: begin
313: --
314: if g_debug then
315: hr_utility.trace('*** Insert Donation Details ***');
316: end if;
317: --
318: open get_donation_details;
319: fetch get_donation_details into

Line 332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));

328: l_ovn;
329: close get_donation_details;
330: --
331: if g_debug then
332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

Line 333: hr_utility.trace('l_donation_code = '||l_donation_code);

329: close get_donation_details;
330: --
331: if g_debug then
332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

Line 334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));

330: --
331: if g_debug then
332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);

Line 335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));

331: if g_debug then
332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);

Line 336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

332: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
340: hr_utility.trace('l_ovn = '||to_char(l_ovn));

Line 337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

333: hr_utility.trace('l_donation_code = '||l_donation_code);
334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
340: hr_utility.trace('l_ovn = '||to_char(l_ovn));
341: end if;

Line 338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);

334: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
340: hr_utility.trace('l_ovn = '||to_char(l_ovn));
341: end if;
342: --

Line 339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);

335: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
340: hr_utility.trace('l_ovn = '||to_char(l_ovn));
341: end if;
342: --
343: if l_donation_code = '31' then

Line 340: hr_utility.trace('l_ovn = '||to_char(l_ovn));

336: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
337: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
338: hr_utility.trace('l_prev_bus_reg_num = '||l_prev_bus_reg_num);
339: hr_utility.trace('l_user_entered_flag = '||l_user_entered_flag);
340: hr_utility.trace('l_ovn = '||to_char(l_ovn));
341: end if;
342: --
343: if l_donation_code = '31' then
344: if (l_donation_year + 3) > to_number(to_char(p_effective_date, 'YYYY')) then

Line 397: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(p_asg_info_id));

393:
394: if p_asg_info_id is not null then
395: --
396: if g_debug then
397: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(p_asg_info_id));
398: end if;
399: --
400: hr_assignment_extra_info_api.update_assignment_extra_info(
401: p_validate => false,

Line 436: hr_utility.trace('end of updating '||to_char(p_asg_info_id));

432: p_aei_information29 => null,
433: p_aei_information30 => null
434: );
435: --
436: hr_utility.trace('end of updating '||to_char(p_asg_info_id));
437: end if;
438: --
439: -- Creating a new row for the next year.
440: if l_carryoveramt > 0 then

Line 443: hr_utility.trace('Check if the records already exist for this donation type');

439: -- Creating a new row for the next year.
440: if l_carryoveramt > 0 then
441: --
442: if g_debug then
443: hr_utility.trace('Check if the records already exist for this donation type');
444: end if;
445: --
446: open check_records_exists(l_donation_year,l_donation_code);
447: fetch check_records_exists into l_asgInfoId,l_ovn1;

Line 451: hr_utility.trace('Create record if already not present for this donation type');

447: fetch check_records_exists into l_asgInfoId,l_ovn1;
448: if check_records_exists%NOTFOUND then
449: --
450: if g_debug then
451: hr_utility.trace('Create record if already not present for this donation type');
452: end if;
453: --
454: if p_yea_info.create_don_rec_flag = 'Y' then
455: hr_assignment_extra_info_api.create_assignment_extra_info(

Line 498: hr_utility.trace('Update record if already present for this donation type');

494: --
495: else
496: --
497: if g_debug then
498: hr_utility.trace('Update record if already present for this donation type');
499: end if;
500: --
501: hr_assignment_extra_info_api.update_assignment_extra_info(
502: p_validate => false,

Line 584: hr_utility.trace('* Update Donation Details *');

580:
581: begin
582: --
583: if g_debug then
584: hr_utility.trace('*** Update Donation Details ***');
585: end if;
586: --
587: open get_donation_details;
588: fetch get_donation_details into

Line 599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));

595: l_ovn;
596: close get_donation_details;
597: --
598: if g_debug then
599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

Line 600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);

596: close get_donation_details;
597: --
598: if g_debug then
599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

Line 601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));

597: --
598: if g_debug then
599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
605: hr_utility.trace('l_ovn = '||to_char(l_ovn));

Line 602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));

598: if g_debug then
599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
605: hr_utility.trace('l_ovn = '||to_char(l_ovn));
606: end if;

Line 603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));

599: hr_utility.trace('l_eff_date = '||to_char(l_eff_date));
600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
605: hr_utility.trace('l_ovn = '||to_char(l_ovn));
606: end if;
607: --

Line 604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));

600: hr_utility.trace('l_asg_info_id = '||l_asg_info_id);
601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
605: hr_utility.trace('l_ovn = '||to_char(l_ovn));
606: end if;
607: --
608: -- Updating the records for the target year

Line 605: hr_utility.trace('l_ovn = '||to_char(l_ovn));

601: hr_utility.trace('l_donation_year = '||to_char(l_donation_year));
602: hr_utility.trace('l_donated_amt = '||to_char(l_donated_amt));
603: hr_utility.trace('l_exem_balance = '||to_char(l_exem_balance));
604: hr_utility.trace('l_amt_sub_exem = '||to_char(l_amt_sub_exem));
605: hr_utility.trace('l_ovn = '||to_char(l_ovn));
606: end if;
607: --
608: -- Updating the records for the target year
609: if l_asg_info_id is not null then

Line 612: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(l_asg_info_id));

608: -- Updating the records for the target year
609: if l_asg_info_id is not null then
610: --
611: if g_debug then
612: hr_utility.trace('Updating the records for the asg_info_id : '||to_char(l_asg_info_id));
613: end if;
614: --
615: hr_assignment_extra_info_api.update_assignment_extra_info(
616: p_validate => false,

Line 774: hr_utility.trace('* Inside Yea Package *');

770: end;
771: begin
772: --
773: if g_debug then
774: hr_utility.trace('*** Inside Yea Package ***');
775: end if;
776: --
777: ----------------------------------------------------------------------------+
778: -- Populating Local variables with Global values

Line 908: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);

904: l_card_exp_not_exempted := 0 ; -- Bug 6763554
905: --
906: p_tax_adj_warning := false;
907: -- Bug 3172960
908: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);
909: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);
910: if (p_yea_info.nationality = 'F' and p_yea_info.fixed_tax_rate = 'Y' and p_effective_date < c_20130101) then
911: --
912: p_yea_info.taxable := p_yea_info.taxable + p_yea_info.non_taxable + p_yea_info.non_rep_non_taxable; --Bug 12807687

Line 909: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);

905: --
906: p_tax_adj_warning := false;
907: -- Bug 3172960
908: hr_utility.trace('*** p_yea_info.nationality : '||p_yea_info.nationality);
909: hr_utility.trace('*** p_yea_info.fixed_tax_rate : '||p_yea_info.fixed_tax_rate);
910: if (p_yea_info.nationality = 'F' and p_yea_info.fixed_tax_rate = 'Y' and p_effective_date < c_20130101) then
911: --
912: p_yea_info.taxable := p_yea_info.taxable + p_yea_info.non_taxable + p_yea_info.non_rep_non_taxable; --Bug 12807687
913: p_yea_info.taxable_income := p_yea_info.taxable;

Line 1036: hr_utility.trace('p_yea_info.taxable= '||to_char(p_yea_info.taxable));

1032: p_yea_info.basic_income_exem := l_addend + trunc(l_multiplier / 100 * (p_yea_info.taxable - l_subtrahend));
1033: p_yea_info.taxable_income := p_yea_info.taxable - p_yea_info.basic_income_exem;
1034: end if;
1035: p_yea_info.taxable_income2 := p_yea_info.taxable_income;
1036: hr_utility.trace('p_yea_info.taxable= '||to_char(p_yea_info.taxable));
1037: hr_utility.trace('p_yea_info.basic_income_exem = '||to_char(p_yea_info.basic_income_exem));
1038: hr_utility.trace('p_yea_info.taxable_income= '||to_char(p_yea_info.taxable_income));
1039: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1040: ----------------------------------------------------------------

Line 1037: hr_utility.trace('p_yea_info.basic_income_exem = '||to_char(p_yea_info.basic_income_exem));

1033: p_yea_info.taxable_income := p_yea_info.taxable - p_yea_info.basic_income_exem;
1034: end if;
1035: p_yea_info.taxable_income2 := p_yea_info.taxable_income;
1036: hr_utility.trace('p_yea_info.taxable= '||to_char(p_yea_info.taxable));
1037: hr_utility.trace('p_yea_info.basic_income_exem = '||to_char(p_yea_info.basic_income_exem));
1038: hr_utility.trace('p_yea_info.taxable_income= '||to_char(p_yea_info.taxable_income));
1039: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1040: ----------------------------------------------------------------
1041: -- Employee Tax Exemption

Line 1038: hr_utility.trace('p_yea_info.taxable_income= '||to_char(p_yea_info.taxable_income));

1034: end if;
1035: p_yea_info.taxable_income2 := p_yea_info.taxable_income;
1036: hr_utility.trace('p_yea_info.taxable= '||to_char(p_yea_info.taxable));
1037: hr_utility.trace('p_yea_info.basic_income_exem = '||to_char(p_yea_info.basic_income_exem));
1038: hr_utility.trace('p_yea_info.taxable_income= '||to_char(p_yea_info.taxable_income));
1039: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1040: ----------------------------------------------------------------
1041: -- Employee Tax Exemption
1042: ----------------------------------------------------------------

Line 1039: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));

1035: p_yea_info.taxable_income2 := p_yea_info.taxable_income;
1036: hr_utility.trace('p_yea_info.taxable= '||to_char(p_yea_info.taxable));
1037: hr_utility.trace('p_yea_info.basic_income_exem = '||to_char(p_yea_info.basic_income_exem));
1038: hr_utility.trace('p_yea_info.taxable_income= '||to_char(p_yea_info.taxable_income));
1039: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1040: ----------------------------------------------------------------
1041: -- Employee Tax Exemption
1042: ----------------------------------------------------------------
1043: p_yea_info.ee_tax_exem := l_ee_tax_exem;

Line 1144: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));

1140: end if;
1141: end loop;
1142: p_yea_info.taxable_income2 := greatest(p_yea_info.taxable_income2 - nvl(p_yea_info.corp_pension_prem_tax_exem,0) - nvl(p_yea_info.scientific_technician_tax_exem,0),0);
1143:
1144: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1145: ----------------------------------------------------------------
1146: -- Supplemental Tax Exemption
1147: ----------------------------------------------------------------
1148: /* Bug 5734313 : Obsoleted code for Supplemental Tax Exemption */

Line 1198: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));

1194: + p_yea_info.ei_prem_tax_exem
1195: + p_yea_info.pers_ins_prem_tax_exem
1196: + p_yea_info.disabled_ins_prem_tax_exem;
1197:
1198: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1199: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1200: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1201:
1202: -- Bug 3971542

Line 1199: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));

1195: + p_yea_info.pers_ins_prem_tax_exem
1196: + p_yea_info.disabled_ins_prem_tax_exem;
1197:
1198: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1199: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1200: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1201:
1202: -- Bug 3971542
1203: -- l_cuml_special_exem := l_cuml_special_exem + p_yea_info.ins_prem_tax_exem ;

Line 1200: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));

1196: + p_yea_info.disabled_ins_prem_tax_exem;
1197:
1198: hr_utility.trace('p_yea_info.hi_prem_tax_exem = '||to_char(p_yea_info.hi_prem_tax_exem));
1199: hr_utility.trace('long_term_ins_prem_tax_exem = '||to_char(p_yea_info.long_term_ins_prem_tax_exem ));
1200: hr_utility.trace('p_yea_info.ei_prem_tax_exem = '||to_char(p_yea_info.ei_prem_tax_exem));
1201:
1202: -- Bug 3971542
1203: -- l_cuml_special_exem := l_cuml_special_exem + p_yea_info.ins_prem_tax_exem ;
1204: -- End of 3971542

Line 1305: hr_utility.trace('* Housing Expense Tax Exemption *');

1301: -- Housing Expense Tax Exemption
1302: ----------------------------------------------------------------
1303: --
1304: if g_debug then
1305: hr_utility.trace('*** Housing Expense Tax Exemption ***');
1306: end if;
1307: --
1308: l_dummy := 0;
1309: for i in 1..p_yea_info.hou_saving_type_tbl.count loop

Line 1314: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);

1310: if p_yea_info.hou_saving_type_tbl(i) <> 'HST2' then
1311: l_dummy := l_dummy + nvl(p_yea_info.hou_saving_cont_amount_tbl(i),0);
1312: end if;
1313: end loop;
1314: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1315: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1316:
1317: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1318: hr_utility.trace('*** INSIDE house_holder_flag ***');

Line 1315: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);

1311: l_dummy := l_dummy + nvl(p_yea_info.hou_saving_cont_amount_tbl(i),0);
1312: end if;
1313: end loop;
1314: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1315: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1316:
1317: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1318: hr_utility.trace('*** INSIDE house_holder_flag ***');
1319: if l_dummy > 0

Line 1318: hr_utility.trace('* INSIDE house_holder_flag *');

1314: hr_utility.trace('p_yea_info.house_holder_flag : '||p_yea_info.house_holder_flag);
1315: hr_utility.trace('p_yea_info.house_holder_exception_flag : '|| p_yea_info.house_holder_exception_flag);
1316:
1317: if (p_yea_info.house_holder_flag = 'Y' or p_yea_info.house_holder_exception_flag = 'Y') then -- Bug 9737699
1318: hr_utility.trace('*** INSIDE house_holder_flag ***');
1319: if l_dummy > 0
1320: or p_yea_info.housing_loan_repay > 0
1321: or p_yea_info.housing_prv_loan_repay > 0
1322: or p_yea_info.lt_housing_loan_interest_repay > 0

Line 1467: hr_utility.trace('p_yea_info.lt_housing_loan_int_rep_exem1 = '||to_char(p_yea_info.lt_housing_loan_int_rep_exem1 ));

1463: -- End of Bug -- 7142620
1464:
1465: end if;
1466:
1467: hr_utility.trace('p_yea_info.lt_housing_loan_int_rep_exem1 = '||to_char(p_yea_info.lt_housing_loan_int_rep_exem1 ));
1468:
1469:
1470: -- Long term loan due 15 - 29 years
1471: --

Line 1507: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));

1503: p_yea_info.lt_2012_house_fixed_intr_exem := p_yea_info.max_housing_exp_tax_exem - p_yea_info.lt_housing_loan_int_rep_exem3 - p_yea_info.lt_housing_loan_int_rep_exem2
1504: - p_yea_info.lt_housing_loan_int_rep_exem1 - p_yea_info.housing_loan_repay_exem - p_yea_info.housing_rent_exp_tax_exem;
1505: end if;
1506: if p_yea_info.max_housing_exp_tax_exem < l_long_term_house_limit and p_yea_info.lt_2012_housing_other_intr > 0 then
1507: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));
1508: p_yea_info.max_housing_exp_tax_exem := p_yea_info.max_housing_exp_tax_exem + least(p_yea_info.lt_2012_housing_other_intr,l_house_2012_other_lim) ;
1509: p_yea_info.max_housing_exp_tax_exem := least(p_yea_info.max_housing_exp_tax_exem,l_long_term_house_limit);
1510: p_yea_info.lt_2012_house_othr_intr_exem := p_yea_info.max_housing_exp_tax_exem - p_yea_info.lt_2012_house_fixed_intr_exem - p_yea_info.lt_housing_loan_int_rep_exem3 - p_yea_info.lt_housing_loan_int_rep_exem2
1511: - p_yea_info.lt_housing_loan_int_rep_exem1 - p_yea_info.housing_loan_repay_exem - p_yea_info.housing_rent_exp_tax_exem;

Line 1517: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));

1513: p_yea_info.max_housing_exp_tax_exem := least(p_yea_info.lt_2012_housing_other_intr,l_house_2012_other_lim) ;
1514: p_yea_info.lt_2012_house_othr_intr_exem := p_yea_info.max_housing_exp_tax_exem ;
1515: end if;
1516:
1517: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));
1518: hr_utility.trace('p_yea_info.lt_2012_house_fixed_intr_exem = '||to_char(p_yea_info.lt_2012_house_fixed_intr_exem ));
1519: hr_utility.trace('p_yea_info.lt_2012_house_othr_intr_exem = '||to_char(p_yea_info.lt_2012_house_othr_intr_exem ));
1520: p_yea_info.lt_housing_loan_intr_exem := greatest(p_yea_info.max_housing_exp_tax_exem - p_yea_info.housing_loan_repay_exem - p_yea_info.housing_rent_exp_tax_exem,0);
1521: -- End of Bug 14754836 2012 Long term loan fixed interest without grace

Line 1518: hr_utility.trace('p_yea_info.lt_2012_house_fixed_intr_exem = '||to_char(p_yea_info.lt_2012_house_fixed_intr_exem ));

1514: p_yea_info.lt_2012_house_othr_intr_exem := p_yea_info.max_housing_exp_tax_exem ;
1515: end if;
1516:
1517: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));
1518: hr_utility.trace('p_yea_info.lt_2012_house_fixed_intr_exem = '||to_char(p_yea_info.lt_2012_house_fixed_intr_exem ));
1519: hr_utility.trace('p_yea_info.lt_2012_house_othr_intr_exem = '||to_char(p_yea_info.lt_2012_house_othr_intr_exem ));
1520: p_yea_info.lt_housing_loan_intr_exem := greatest(p_yea_info.max_housing_exp_tax_exem - p_yea_info.housing_loan_repay_exem - p_yea_info.housing_rent_exp_tax_exem,0);
1521: -- End of Bug 14754836 2012 Long term loan fixed interest without grace
1522: -- Bug 4119483: Apply upper limit based on cumulative special exemption

Line 1519: hr_utility.trace('p_yea_info.lt_2012_house_othr_intr_exem = '||to_char(p_yea_info.lt_2012_house_othr_intr_exem ));

1515: end if;
1516:
1517: hr_utility.trace(' p_yea_info.max_housing_exp_tax_exem = '||to_char( p_yea_info.max_housing_exp_tax_exem ));
1518: hr_utility.trace('p_yea_info.lt_2012_house_fixed_intr_exem = '||to_char(p_yea_info.lt_2012_house_fixed_intr_exem ));
1519: hr_utility.trace('p_yea_info.lt_2012_house_othr_intr_exem = '||to_char(p_yea_info.lt_2012_house_othr_intr_exem ));
1520: p_yea_info.lt_housing_loan_intr_exem := greatest(p_yea_info.max_housing_exp_tax_exem - p_yea_info.housing_loan_repay_exem - p_yea_info.housing_rent_exp_tax_exem,0);
1521: -- End of Bug 14754836 2012 Long term loan fixed interest without grace
1522: -- Bug 4119483: Apply upper limit based on cumulative special exemption
1523: --Start of Bug -- 7142620

Line 1571: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));

1567: --
1568: -- Calculate for Statutory Donation
1569: --
1570: if g_debug then
1571: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1572: hr_utility.trace('*** Calculate Statutory Donation ***');
1573: end if;
1574: --
1575: l_political2_exem := 0;

Line 1572: hr_utility.trace('* Calculate Statutory Donation *');

1568: -- Calculate for Statutory Donation
1569: --
1570: if g_debug then
1571: hr_utility.trace('Taxable Income just before Donation: '||to_char(p_yea_info.taxation_base));
1572: hr_utility.trace('*** Calculate Statutory Donation ***');
1573: end if;
1574: --
1575: l_political2_exem := 0;
1576: --

Line 1577: hr_utility.trace('p_yea_info.taxation_base = '||p_yea_info.taxation_base);

1573: end if;
1574: --
1575: l_political2_exem := 0;
1576: --
1577: hr_utility.trace('p_yea_info.taxation_base = '||p_yea_info.taxation_base);
1578: p_yea_info.taxable_income2 := greatest(p_yea_info.taxation_base,0);
1579: l_actual_max_donation_dummy := greatest(p_yea_info.taxation_base,0);
1580: --
1581: p_yea_info.donation1_tax_exem := 0;

Line 1585: hr_utility.trace('* Calculate Political Donation *');

1581: p_yea_info.donation1_tax_exem := 0;
1582: --
1583:
1584: if g_debug then
1585: hr_utility.trace('*** Calculate Political Donation ***');
1586: end if;
1587: --
1588: if p_yea_info.political_donation1 > 0 then
1589: p_yea_info.donation1_tax_exem := p_yea_info.donation1_tax_exem + least(l_actual_max_donation_dummy,p_yea_info.taxable_income2,greatest(p_yea_info.political_donation1 - l_political_tax_brk_lim2004, 0));

Line 1634: hr_utility.trace('* Calculate Special Donation *');

1630: -- Bug 7142612: Added Public Legal Entity Donation Trust to Tax Law Amount
1631: --
1632: --
1633: if g_debug then
1634: hr_utility.trace('*** Calculate Special Donation ***');
1635: end if;
1636: --
1637: p_yea_info.donation3_tax_exem := 0;
1638: l_max_donation3_dummy := 0;

Line 1686: hr_utility.trace('* Calculate ESOA Donation *');

1682: --
1683: -- Calculate for ESOA Donation
1684: --
1685: if g_debug then
1686: hr_utility.trace('*** Calculate ESOA Donation ***');
1687: end if;
1688: --
1689: if p_yea_info.esoa_don2004 > 0 then
1690: if p_yea_info.taxable_income2 > (p_yea_info.donation1_tax_exem + p_yea_info.donation3_tax_exem) then

Line 1707: hr_utility.trace('* Calculate Specified and Religious Donation *');

1703: -- Calculate for Specified and Religious Donation
1704: --
1705: --
1706: if g_debug then
1707: hr_utility.trace('*** Calculate Specified and Religious Donation ***');
1708: end if;
1709: --
1710: l_max_donation2_dummy := 0;
1711: p_yea_info.donation2_tax_exem := 0;

Line 1843: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));

1839: -- Now calculate total political donation income exemption
1840: p_yea_info.donation_tax_exem := p_yea_info.donation1_tax_exem + p_yea_info.donation2_tax_exem + p_yea_info.donation3_tax_exem + p_yea_info.esoa_don_tax_exem2004 ;
1841: --
1842: if g_debug then
1843: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1844: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1845: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
1846: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
1847: end if;

Line 1844: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));

1840: p_yea_info.donation_tax_exem := p_yea_info.donation1_tax_exem + p_yea_info.donation2_tax_exem + p_yea_info.donation3_tax_exem + p_yea_info.esoa_don_tax_exem2004 ;
1841: --
1842: if g_debug then
1843: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1844: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1845: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
1846: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
1847: end if;
1848: --

Line 1845: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));

1841: --
1842: if g_debug then
1843: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1844: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1845: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
1846: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
1847: end if;
1848: --
1849: --

Line 1846: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));

1842: if g_debug then
1843: hr_utility.trace('Total Statutory + Political Donation = '||to_char(p_yea_info.donation1_tax_exem));
1844: hr_utility.trace('Total PLEDT + Tax Reduction Law = '||to_char(p_yea_info.donation3_tax_exem));
1845: hr_utility.trace('Total Specified + Religious Donation = '||to_char(p_yea_info.donation2_tax_exem));
1846: hr_utility.trace('Total ESOA Donation = '||to_char(p_yea_info.esoa_don_tax_exem2004));
1847: end if;
1848: --
1849: --
1850: -- Bug 4119483: Apply upper limit based on cumulative special exemption

Line 1861: hr_utility.trace('p_yea_info.taxable_income2: = '||p_yea_info.taxable_income2);

1857: --
1858: l_cuml_special_exem := l_cuml_special_exem + p_yea_info.donation_tax_exem ;
1859: p_yea_info.taxable_income2 := greatest(0,p_yea_info.taxable_income2 - p_yea_info.donation_tax_exem);
1860: --
1861: hr_utility.trace('p_yea_info.taxable_income2: = '||p_yea_info.taxable_income2);
1862: --
1863: check_donation_details(p_assignment_id,
1864: p_effective_date);
1865:

Line 1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));

1878: + p_yea_info.housing_exp_tax_exem
1879: + p_yea_info.donation_tax_exem
1880: + p_yea_info.marr_fun_relo_exemption;
1881:
1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));

Line 1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));

1879: + p_yea_info.donation_tax_exem
1880: + p_yea_info.marr_fun_relo_exemption;
1881:
1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));

Line 1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));

1880: + p_yea_info.marr_fun_relo_exemption;
1881:
1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
1888:

Line 1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));

1881:
1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
1888:
1889:

Line 1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));

1882: hr_utility.trace('p_yea_info.ins_prem_tax_exem = '||to_char(p_yea_info.ins_prem_tax_exem));
1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
1888:
1889:
1890: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 + p_yea_info.sp_tax_exem;

Line 1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));

1883: hr_utility.trace(' p_yea_info.med_exp_tax_exem = '||to_char( p_yea_info.med_exp_tax_exem));
1884: hr_utility.trace(' p_yea_info.educ_exp_tax_exem= '||to_char( p_yea_info.educ_exp_tax_exem));
1885: hr_utility.trace(' p_yea_info.housing_exp_tax_exem= '||to_char( p_yea_info.housing_exp_tax_exem));
1886: hr_utility.trace(' p_yea_info.donation_tax_exem= '||to_char( p_yea_info.donation_tax_exem));
1887: hr_utility.trace(' p_yea_info.marr_fun_relo_exemption= '||to_char(p_yea_info.marr_fun_relo_exemption));
1888:
1889:
1890: p_yea_info.taxable_income2 := p_yea_info.taxable_income2 + p_yea_info.sp_tax_exem;
1891: if (p_yea_info.sp_tax_exem < l_std_sp_tax_exem ) then -- Bug 11768555

Line 1899: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));

1895:
1896: p_yea_info.taxable_income2 := greatest(p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem,0);
1897: --
1898: if g_debug then
1899: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1900: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1901: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1902: end if;
1903: --

Line 1900: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));

1896: p_yea_info.taxable_income2 := greatest(p_yea_info.taxable_income2 - p_yea_info.sp_tax_exem - p_yea_info.std_sp_tax_exem,0);
1897: --
1898: if g_debug then
1899: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1900: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1901: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1902: end if;
1903: --
1904: end if;

Line 1901: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));

1897: --
1898: if g_debug then
1899: hr_utility.trace('Special Tax Exemption = '||to_char(p_yea_info.sp_tax_exem));
1900: hr_utility.trace('Std Special Tax Exemption = '||to_char(p_yea_info.std_sp_tax_exem));
1901: hr_utility.trace('Taxable Income2 = '||to_char(p_yea_info.taxable_income2));
1902: end if;
1903: --
1904: end if;
1905:

Line 2023: hr_utility.trace('p_yea_info.taxable_income, 10 = '||to_char(p_yea_info.taxable_income));

2019: ----------------------------------------------------------------
2020: -- Bug 9079450: Removed code for investment partnership financing1
2021: -- Bug 13247926: Removed code for investment partnership financing2
2022: -- BUG 14219478 Start
2023: hr_utility.trace('p_yea_info.taxable_income, 10 = '||to_char(p_yea_info.taxable_income));
2024: hr_utility.trace('p_yea_info.taxable_income2, 10 = '||to_char(p_yea_info.taxable_income2));
2025: hr_utility.trace('p_effective_date = '||to_char(p_effective_date));
2026: if p_effective_date > c_20120101 and p_yea_info.taxable_income > 0 then
2027: p_yea_info.invest_partner_fin_tax_exem := 0;

Line 2024: hr_utility.trace('p_yea_info.taxable_income2, 10 = '||to_char(p_yea_info.taxable_income2));

2020: -- Bug 9079450: Removed code for investment partnership financing1
2021: -- Bug 13247926: Removed code for investment partnership financing2
2022: -- BUG 14219478 Start
2023: hr_utility.trace('p_yea_info.taxable_income, 10 = '||to_char(p_yea_info.taxable_income));
2024: hr_utility.trace('p_yea_info.taxable_income2, 10 = '||to_char(p_yea_info.taxable_income2));
2025: hr_utility.trace('p_effective_date = '||to_char(p_effective_date));
2026: if p_effective_date > c_20120101 and p_yea_info.taxable_income > 0 then
2027: p_yea_info.invest_partner_fin_tax_exem := 0;
2028: l_invest_fin_tax_exem_2011 := 0;

Line 2025: hr_utility.trace('p_effective_date = '||to_char(p_effective_date));

2021: -- Bug 13247926: Removed code for investment partnership financing2
2022: -- BUG 14219478 Start
2023: hr_utility.trace('p_yea_info.taxable_income, 10 = '||to_char(p_yea_info.taxable_income));
2024: hr_utility.trace('p_yea_info.taxable_income2, 10 = '||to_char(p_yea_info.taxable_income2));
2025: hr_utility.trace('p_effective_date = '||to_char(p_effective_date));
2026: if p_effective_date > c_20120101 and p_yea_info.taxable_income > 0 then
2027: p_yea_info.invest_partner_fin_tax_exem := 0;
2028: l_invest_fin_tax_exem_2011 := 0;
2029: l_invest_fin_tax_exem_2012_ord := 0;

Line 2034: hr_utility.trace('l_invest_fin_tax_exem_2011, 10 = '||to_char(l_invest_fin_tax_exem_2011));

2030: l_invest_fin_tax_exem_2012_ven := 0;
2031: if p_yea_info.invest_partner_fin4 > 0 then
2032: l_invest_fin_tax_exem_2011 := least(trunc(p_yea_info.invest_partner_fin4 * l_inv_part_fin3_tax_exem_per),
2033: trunc(p_yea_info.taxable_income * l_inv_part_fin3_tax_exem_lim));
2034: hr_utility.trace('l_invest_fin_tax_exem_2011, 10 = '||to_char(l_invest_fin_tax_exem_2011));
2035: if p_yea_info.invest_partner_fin5 > 0 then
2036: l_invest_fin_tax_exem_2012_ord := least(trunc(p_yea_info.invest_partner_fin5 * l_inv_part_fin3_tax_exem_per),
2037: trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim));
2038: if (l_invest_fin_tax_exem_2012_ord + l_invest_fin_tax_exem_2011 > p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) then

Line 2042: hr_utility.trace('l_invest_fin_tax_exem_2012_ord, 10 = '||to_char(l_invest_fin_tax_exem_2012_ord));

2038: if (l_invest_fin_tax_exem_2012_ord + l_invest_fin_tax_exem_2011 > p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) then
2039: l_invest_fin_tax_exem_2012_ord := greatest(0, trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) - l_invest_fin_tax_exem_2011);
2040: end if;
2041: end if;
2042: hr_utility.trace('l_invest_fin_tax_exem_2012_ord, 10 = '||to_char(l_invest_fin_tax_exem_2012_ord));
2043: if p_yea_info.invest_partner_fin6 >0 then
2044: l_invest_fin_tax_exem_2012_ven := least(trunc(p_yea_info.invest_partner_fin6 * l_inv_part_fin4_tax_exem_per),
2045: trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim));
2046: if (l_invest_fin_tax_exem_2012_ven + l_invest_fin_tax_exem_2012_ord + l_invest_fin_tax_exem_2011 > p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) then

Line 2050: hr_utility.trace('l_invest_fin_tax_exem_2012_ven, 10 = '||to_char(l_invest_fin_tax_exem_2012_ven));

2046: if (l_invest_fin_tax_exem_2012_ven + l_invest_fin_tax_exem_2012_ord + l_invest_fin_tax_exem_2011 > p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) then
2047: l_invest_fin_tax_exem_2012_ven := greatest(0, trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim) - l_invest_fin_tax_exem_2012_ord - l_invest_fin_tax_exem_2011);
2048: end if;
2049: end if;
2050: hr_utility.trace('l_invest_fin_tax_exem_2012_ven, 10 = '||to_char(l_invest_fin_tax_exem_2012_ven));
2051: p_yea_info.invest_partner_fin_tax_exem := l_invest_fin_tax_exem_2011
2052: + l_invest_fin_tax_exem_2012_ord
2053: + l_invest_fin_tax_exem_2012_ven;
2054: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem = '||to_char(p_yea_info.invest_partner_fin_tax_exem));

Line 2054: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem = '||to_char(p_yea_info.invest_partner_fin_tax_exem));

2050: hr_utility.trace('l_invest_fin_tax_exem_2012_ven, 10 = '||to_char(l_invest_fin_tax_exem_2012_ven));
2051: p_yea_info.invest_partner_fin_tax_exem := l_invest_fin_tax_exem_2011
2052: + l_invest_fin_tax_exem_2012_ord
2053: + l_invest_fin_tax_exem_2012_ven;
2054: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem = '||to_char(p_yea_info.invest_partner_fin_tax_exem));
2055: else
2056: p_yea_info.invest_partner_fin_tax_exem := least(trunc(p_yea_info.invest_partner_fin5 * l_inv_part_fin3_tax_exem_per
2057: + p_yea_info.invest_partner_fin6 * l_inv_part_fin4_tax_exem_per), trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim));
2058: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem, 10 = '||to_char(p_yea_info.invest_partner_fin_tax_exem));

Line 2058: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem, 10 = '||to_char(p_yea_info.invest_partner_fin_tax_exem));

2054: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem = '||to_char(p_yea_info.invest_partner_fin_tax_exem));
2055: else
2056: p_yea_info.invest_partner_fin_tax_exem := least(trunc(p_yea_info.invest_partner_fin5 * l_inv_part_fin3_tax_exem_per
2057: + p_yea_info.invest_partner_fin6 * l_inv_part_fin4_tax_exem_per), trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim));
2058: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem, 10 = '||to_char(p_yea_info.invest_partner_fin_tax_exem));
2059: end if;
2060: p_yea_info.taxation_base := greatest(0, p_yea_info.taxation_base - p_yea_info.invest_partner_fin_tax_exem);
2061: hr_utility.trace('p_yea_info.taxation_base, 10 = '||to_char(p_yea_info.taxation_base));
2062: end if;

Line 2061: hr_utility.trace('p_yea_info.taxation_base, 10 = '||to_char(p_yea_info.taxation_base));

2057: + p_yea_info.invest_partner_fin6 * l_inv_part_fin4_tax_exem_per), trunc(p_yea_info.taxable_income * l_inv_part_fin4_tax_exem_lim));
2058: hr_utility.trace('p_yea_info.invest_partner_fin_tax_exem, 10 = '||to_char(p_yea_info.invest_partner_fin_tax_exem));
2059: end if;
2060: p_yea_info.taxation_base := greatest(0, p_yea_info.taxation_base - p_yea_info.invest_partner_fin_tax_exem);
2061: hr_utility.trace('p_yea_info.taxation_base, 10 = '||to_char(p_yea_info.taxation_base));
2062: end if;
2063: ----------------------------------------------------------------
2064: -- Credit Card Expense Tax Exem
2065: -- Bug 3966549: Now differentiate between employee's and

Line 2089: hr_utility.trace('p_yea_info.credit_card_expense = '||to_char(p_yea_info.credit_card_expense));

2085: -- End of Bug 6716401
2086:
2087: -- Start of BUG 14219478
2088: p_yea_info.total_credit_card_exp := p_yea_info.credit_card_expense - p_yea_info.company_related_exp ;
2089: hr_utility.trace('p_yea_info.credit_card_expense = '||to_char(p_yea_info.credit_card_expense));
2090: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));
2091:
2092: if p_yea_info.total_credit_card_exp > 0 and p_effective_date < c_20130101 then
2093:

Line 2090: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));

2086:
2087: -- Start of BUG 14219478
2088: p_yea_info.total_credit_card_exp := p_yea_info.credit_card_expense - p_yea_info.company_related_exp ;
2089: hr_utility.trace('p_yea_info.credit_card_expense = '||to_char(p_yea_info.credit_card_expense));
2090: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));
2091:
2092: if p_yea_info.total_credit_card_exp > 0 and p_effective_date < c_20130101 then
2093:
2094: l_threshold_amnt := (greatest(p_yea_info.taxable, 0) * l_cre_card_exp_tax_exem_per1);

Line 2120: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));

2116: -- Collect total credit card expenses into p_yea_info.credit_card_exp
2117: p_yea_info.credit_card_exp := p_yea_info.total_credit_card_exp;
2118: --
2119: end if;
2120: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));
2121: hr_utility.trace('p_yea_info.total_credit_card_exp_tax_exem = '||to_char(p_yea_info.total_credit_card_exp_tax_exem));
2122: hr_utility.trace('p_yea_info.taxation_base = '||to_char(p_yea_info.taxation_base));
2123: -- End of BUG 14219478
2124: end if;

Line 2121: hr_utility.trace('p_yea_info.total_credit_card_exp_tax_exem = '||to_char(p_yea_info.total_credit_card_exp_tax_exem));

2117: p_yea_info.credit_card_exp := p_yea_info.total_credit_card_exp;
2118: --
2119: end if;
2120: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));
2121: hr_utility.trace('p_yea_info.total_credit_card_exp_tax_exem = '||to_char(p_yea_info.total_credit_card_exp_tax_exem));
2122: hr_utility.trace('p_yea_info.taxation_base = '||to_char(p_yea_info.taxation_base));
2123: -- End of BUG 14219478
2124: end if;
2125: ----------------------------------------------------------------

Line 2122: hr_utility.trace('p_yea_info.taxation_base = '||to_char(p_yea_info.taxation_base));

2118: --
2119: end if;
2120: hr_utility.trace('p_yea_info.total_credit_card_exp = '||to_char(p_yea_info.total_credit_card_exp));
2121: hr_utility.trace('p_yea_info.total_credit_card_exp_tax_exem = '||to_char(p_yea_info.total_credit_card_exp_tax_exem));
2122: hr_utility.trace('p_yea_info.taxation_base = '||to_char(p_yea_info.taxation_base));
2123: -- End of BUG 14219478
2124: end if;
2125: ----------------------------------------------------------------
2126: -- Employee Stock Ownership Plan Contribution Tax Exemption

Line 2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));

2218: -- Bug 14754822 Start
2219: ----------------------------------------------------------------
2220: -- 2012 Tax Reduction Calculations
2221: ----------------------------------------------------------------
2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));
2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));

Line 2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));

2219: ----------------------------------------------------------------
2220: -- 2012 Tax Reduction Calculations
2221: ----------------------------------------------------------------
2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));
2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));
2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));

Line 2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));

2220: -- 2012 Tax Reduction Calculations
2221: ----------------------------------------------------------------
2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));
2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));
2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));
2228: if p_yea_info.taxable > 0 then

Line 2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));

2221: ----------------------------------------------------------------
2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));
2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));
2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));
2228: if p_yea_info.taxable > 0 then
2229: --

Line 2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));

2222: hr_utility.trace('p_yea_info.taxable_earnings_smb = '||to_char(p_yea_info.taxable_earnings_smb));
2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));
2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));
2228: if p_yea_info.taxable > 0 then
2229: --
2230: p_yea_info.tax_reduction_smb := greatest(trunc((p_yea_info.calc_tax * p_yea_info.taxable_earnings_smb/p_yea_info.taxable),0),0);

Line 2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));

2223: hr_utility.trace('p_yea_info.taxable_earnings_teachers = '||to_char(p_yea_info.taxable_earnings_teachers));
2224: hr_utility.trace('p_yea_info.taxable_earnings_marine = '||to_char(p_yea_info.taxable_earnings_marine));
2225: hr_utility.trace('p_yea_info.calc_tax = '||to_char(p_yea_info.calc_tax));
2226: hr_utility.trace('p_yea_info.taxable_income2 = '||to_char(p_yea_info.taxable_income2));
2227: hr_utility.trace('p_yea_info.taxable = '||to_char(p_yea_info.taxable));
2228: if p_yea_info.taxable > 0 then
2229: --
2230: p_yea_info.tax_reduction_smb := greatest(trunc((p_yea_info.calc_tax * p_yea_info.taxable_earnings_smb/p_yea_info.taxable),0),0);
2231: p_yea_info.tax_reduction_teachers := greatest(trunc((p_yea_info.calc_tax * p_yea_info.taxable_earnings_teachers/p_yea_info.taxable),0),0);

Line 2238: hr_utility.trace('p_yea_info.tax_reduction_smb = '||to_char(p_yea_info.tax_reduction_smb));

2234: p_yea_info.tax_reduction_smb :=0;
2235: p_yea_info.tax_reduction_teachers := 0;
2236: p_yea_info.tax_reduction_marine := 0;
2237: end if;
2238: hr_utility.trace('p_yea_info.tax_reduction_smb = '||to_char(p_yea_info.tax_reduction_smb));
2239: hr_utility.trace('p_yea_info.tax_reduction_teachers = '||to_char(p_yea_info.tax_reduction_teachers));
2240: hr_utility.trace('p_yea_info.tax_reduction_marine = '||to_char(p_yea_info.tax_reduction_marine));
2241: -- Bug 14754822 End
2242:

Line 2239: hr_utility.trace('p_yea_info.tax_reduction_teachers = '||to_char(p_yea_info.tax_reduction_teachers));

2235: p_yea_info.tax_reduction_teachers := 0;
2236: p_yea_info.tax_reduction_marine := 0;
2237: end if;
2238: hr_utility.trace('p_yea_info.tax_reduction_smb = '||to_char(p_yea_info.tax_reduction_smb));
2239: hr_utility.trace('p_yea_info.tax_reduction_teachers = '||to_char(p_yea_info.tax_reduction_teachers));
2240: hr_utility.trace('p_yea_info.tax_reduction_marine = '||to_char(p_yea_info.tax_reduction_marine));
2241: -- Bug 14754822 End
2242:
2243: ----------------------------------------------------------------

Line 2240: hr_utility.trace('p_yea_info.tax_reduction_marine = '||to_char(p_yea_info.tax_reduction_marine));

2236: p_yea_info.tax_reduction_marine := 0;
2237: end if;
2238: hr_utility.trace('p_yea_info.tax_reduction_smb = '||to_char(p_yea_info.tax_reduction_smb));
2239: hr_utility.trace('p_yea_info.tax_reduction_teachers = '||to_char(p_yea_info.tax_reduction_teachers));
2240: hr_utility.trace('p_yea_info.tax_reduction_marine = '||to_char(p_yea_info.tax_reduction_marine));
2241: -- Bug 14754822 End
2242:
2243: ----------------------------------------------------------------
2244: -- Basic Tax Break

Line 2281: hr_utility.trace('l_available_tax_break = '||to_char(l_available_tax_break));

2277: p_row_value => to_char(l_dummy),
2278: p_effective_date => p_effective_date));
2279: p_yea_info.basic_tax_break := least(trunc(l_addend + trunc((l_dummy - l_subtrahend) * l_multiplier / 100)), l_basic_tax_break);
2280: -- Bug 14754822
2281: hr_utility.trace('l_available_tax_break = '||to_char(l_available_tax_break));
2282:
2283: p_yea_info.basic_tax_break := trunc(p_yea_info.basic_tax_break *(1- (p_yea_info.taxable_earnings_smb + p_yea_info.taxable_earnings_teachers
2284: + p_yea_info.taxable_earnings_marine)/p_yea_info.taxable));
2285: p_yea_info.basic_tax_break := least(p_yea_info.basic_tax_break, l_available_tax_break);

Line 2438: hr_utility.trace('p_yea_info.foreign_worker_tax_break2 = '||to_char(p_yea_info.foreign_worker_tax_break2));

2434: end if;
2435: -- Bug 14754822
2436: p_yea_info.foreign_worker_tax_break2 := nvl(p_yea_info.foreign_worker_tax_break2,0) + nvl(p_yea_info.tax_reduction_marine,0); -- Bug 14754822
2437: p_yea_info.foreign_worker_tax_break := p_yea_info.foreign_worker_tax_break2 + nvl(p_yea_info.tax_reduction_smb,0) + nvl(p_yea_info.tax_reduction_teachers,0);
2438: hr_utility.trace('p_yea_info.foreign_worker_tax_break2 = '||to_char(p_yea_info.foreign_worker_tax_break2));
2439: hr_utility.trace('p_yea_info.foreign_worker_tax_break = '||to_char(p_yea_info.foreign_worker_tax_break));
2440: ----------------------------------------------------------------
2441: -- Annual Tax
2442: ----------------------------------------------------------------

Line 2439: hr_utility.trace('p_yea_info.foreign_worker_tax_break = '||to_char(p_yea_info.foreign_worker_tax_break));

2435: -- Bug 14754822
2436: p_yea_info.foreign_worker_tax_break2 := nvl(p_yea_info.foreign_worker_tax_break2,0) + nvl(p_yea_info.tax_reduction_marine,0); -- Bug 14754822
2437: p_yea_info.foreign_worker_tax_break := p_yea_info.foreign_worker_tax_break2 + nvl(p_yea_info.tax_reduction_smb,0) + nvl(p_yea_info.tax_reduction_teachers,0);
2438: hr_utility.trace('p_yea_info.foreign_worker_tax_break2 = '||to_char(p_yea_info.foreign_worker_tax_break2));
2439: hr_utility.trace('p_yea_info.foreign_worker_tax_break = '||to_char(p_yea_info.foreign_worker_tax_break));
2440: ----------------------------------------------------------------
2441: -- Annual Tax
2442: ----------------------------------------------------------------
2443: if p_yea_info.foreign_worker_tax_break < p_yea_info.calc_tax then

Line 2449: hr_utility.trace('p_yea_info.basic_tax_break = '||to_char(p_yea_info.basic_tax_break));

2445: p_yea_info.basic_tax_break := p_yea_info.calc_tax - p_yea_info.foreign_worker_tax_break;
2446: end if;
2447: -- Bug 14754822
2448: p_yea_info.total_tax_break := p_yea_info.total_tax_break + p_yea_info.basic_tax_break;
2449: hr_utility.trace('p_yea_info.basic_tax_break = '||to_char(p_yea_info.basic_tax_break));
2450: hr_utility.trace('p_yea_info.total_tax_break = '||to_char(p_yea_info.total_tax_break));
2451: p_yea_info.annual_itax := trunc(greatest(p_yea_info.calc_tax - p_yea_info.total_tax_break - p_yea_info.foreign_worker_tax_break, 0),0);
2452: p_yea_info.annual_rtax := trunc(p_yea_info.annual_itax * l_annual_itax_per,0);
2453:

Line 2450: hr_utility.trace('p_yea_info.total_tax_break = '||to_char(p_yea_info.total_tax_break));

2446: end if;
2447: -- Bug 14754822
2448: p_yea_info.total_tax_break := p_yea_info.total_tax_break + p_yea_info.basic_tax_break;
2449: hr_utility.trace('p_yea_info.basic_tax_break = '||to_char(p_yea_info.basic_tax_break));
2450: hr_utility.trace('p_yea_info.total_tax_break = '||to_char(p_yea_info.total_tax_break));
2451: p_yea_info.annual_itax := trunc(greatest(p_yea_info.calc_tax - p_yea_info.total_tax_break - p_yea_info.foreign_worker_tax_break, 0),0);
2452: p_yea_info.annual_rtax := trunc(p_yea_info.annual_itax * l_annual_itax_per,0);
2453:
2454: -- bug 12778151