[Home] [Help]
1: PACKAGE BODY pay_in_tax_utils AS
2: /* $Header: pyintxut.pkb 120.53.12020000.9 2013/04/09 19:27:57 pthummal ship $ */
3:
4: type t_rent_paid is table of number index by binary_integer ;
5: type t_assact is table of number index by binary_integer ;
7: type t_bal_value is table of number index by binary_integer ;
8: type t_eff_date is table of date index by binary_integer ;
9:
10: g_debug boolean ;
11: g_package CONSTANT VARCHAR2(20):= 'pay_in_tax_utils.';
12:
13: --------------------------------------------------------------------------
14: -- Name : get_financial_year_start --
15: -- Type : Function --
804: l_procedure := g_package ||'get_monthly_max_assact';
805: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
806:
807: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
808: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
809: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
810: from pay_payroll_Actions ppa,
811: pay_assignment_Actions paa,
812: per_assignments_f asg -- Added to remove NMV as per bug 4774108
1235: --
1236:
1237:
1238: -- Bug 12401381
1239: l_year_start := pay_in_tax_utils.get_tax_year_start(l_payroll_id,p_effective_date );
1240: l_year_end := pay_in_tax_utils.get_tax_year_end(l_payroll_id,p_effective_date );
1241: l_check_date :=LEAST (l_asg_end_date,l_year_end);
1242:
1243: ------------------------------
1236:
1237:
1238: -- Bug 12401381
1239: l_year_start := pay_in_tax_utils.get_tax_year_start(l_payroll_id,p_effective_date );
1240: l_year_end := pay_in_tax_utils.get_tax_year_end(l_payroll_id,p_effective_date );
1241: l_check_date :=LEAST (l_asg_end_date,l_year_end);
1242:
1243: ------------------------------
1244: /*To get current gre_id */
2038: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
2039: pay_in_utils.trace('p_date_earned',p_date_earned);
2040: END IF;
2041:
2042: l_year_start := pay_in_tax_utils.get_financial_year_start(p_date_earned);
2043: l_year_end := pay_in_tax_utils.get_financial_year_end(p_date_earned);
2044:
2045: l_curr_mon := to_char(p_date_earned,'MON');
2046:
2039: pay_in_utils.trace('p_date_earned',p_date_earned);
2040: END IF;
2041:
2042: l_year_start := pay_in_tax_utils.get_financial_year_start(p_date_earned);
2043: l_year_end := pay_in_tax_utils.get_financial_year_end(p_date_earned);
2044:
2045: l_curr_mon := to_char(p_date_earned,'MON');
2046:
2047: l_hri_entry_id := get_house_rent_info_entry_id(p_assignment_action_id,
2345: l_message VARCHAR2(255);
2346:
2347: BEGIN
2348: g_debug := hr_utility.debug_enabled ;
2349: l_procedure := 'pay_in_tax_utils.get_perquisite_details' ;
2350: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2351: p_taxable_flag := 'Y';
2352:
2353: OPEN c_get_perk_details;
4416: pay_in_utils.trace('p_context_value',p_context_value);
4417: END IF;
4418:
4419:
4420: l_year_start := pay_in_tax_utils.get_financial_year_start(p_effective_date );
4421:
4422: l_le_start_date := le_start_date(p_tax_unit_id
4423: ,p_assignment_id
4424: ,p_effective_date);
4440: RETURN 0;
4441: END IF;
4442: CLOSE csr_cyclic_gre;
4443:
4444: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, p_dimension_name);
4445: pay_in_utils.set_location(g_debug, ' INDIA:l_def_bal_id '||l_def_bal_id,30);
4446:
4447: OPEN c_max_asact(l_pre_le_end_date);
4448: FETCH c_max_asact INTO p_assignment_action_id;
4662:
4663: IF l_assignment_action_id IS NULL THEN
4664: l_balance_value :=0;
4665: ELSE
4666: l_def_bal_id := pay_in_tax_utils.get_defined_balance(p_balance_name, '_ASG_LE_DE_PTD');
4667:
4668: l_balance_value := pay_balance_pkg.get_value
4669: (p_assignment_action_id => l_assignment_action_id
4670: ,p_defined_balance_id => l_def_bal_id
5097: RETURN 0;
5098:
5099: END bon_calculate_80g_gg;
5100:
5101: END pay_in_tax_utils ;