224: g_archive_item t_archive_item;
225: ------------------------------------------------------------------------
226: -- Global variable for debugging
227: ------------------------------------------------------------------------
228: g_debug constant boolean := hr_utility.debug_enabled;
229: ------------------------------------------------------------------------
230: function convert_to_rec(
231: p_user_entity_id_tbl in t_number_tbl,
232: p_archive_item_value_tbl in t_varchar2_tbl) return t_yea_info
1562: And information_type = 'KR_YEA_FOREIGN_WORKER_TAX';
1563: begin
1564: --
1565: if g_debug then
1566: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',10);
1567: end if;
1568: --
1569: ------------------------------------------------------------------------
1570: -- Derive Resident/Non-resident Information from element entry.
1585: end;
1586: /* End of Bug 6716506 */
1587: --
1588: if g_debug then
1589: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',15);
1590: end if;
1591: ------------------------------------------------------------------------
1592: -- Bug 3201332 Derive Nationality from national identifier
1593: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality
1611: CLOSE csr_fixed_tax_rate;
1612: end if;
1613: --
1614: if g_debug then
1615: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',20);
1616: end if;
1617: --
1618: ------------------------------------------------------------------------
1619: -- Get latest assignment action in this calendar year.
1622: fetch csr_assact into l_assignment_action_id;
1623: if csr_assact%FOUND then
1624: --
1625: if g_debug then
1626: hr_utility.trace('l_assignment_action_id '||to_char(l_assignment_action_id));
1627: end if;
1628: --
1629: ------------------------------------------------------------------------
1630: -- Current Employer's Information
1637: pay_balance_pkg.get_value ( p_assignment_action_id => l_assignment_action_id
1638: ,p_defined_balance_lst => g_balance_value_tab );
1639: --
1640: if g_debug then
1641: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',30);
1642: end if;
1643: --
1644: l_cur_sp_irreg_bonus_mth := g_balance_value_tab(1).balance_value;
1645: l_cur_sp_irreg_bonus_bon := g_balance_value_tab(2).balance_value;
1697: l_corp_pension_prem_bal_value := g_balance_value_tab(21).balance_value+
1698: p_yea_info.corp_pension_prem;
1699: --
1700: if g_debug then
1701: hr_utility.trace('p_yea_info.cur_itax '||to_char(p_yea_info.cur_itax));
1702: hr_utility.trace('p_yea_info.cur_rtax '||to_char(p_yea_info.cur_rtax));
1703: hr_utility.trace('p_yea_info.cur_stax '||to_char(p_yea_info.cur_stax));
1704: end if;
1705: --
1698: p_yea_info.corp_pension_prem;
1699: --
1700: if g_debug then
1701: hr_utility.trace('p_yea_info.cur_itax '||to_char(p_yea_info.cur_itax));
1702: hr_utility.trace('p_yea_info.cur_rtax '||to_char(p_yea_info.cur_rtax));
1703: hr_utility.trace('p_yea_info.cur_stax '||to_char(p_yea_info.cur_stax));
1704: end if;
1705: --
1706: end if;
1699: --
1700: if g_debug then
1701: hr_utility.trace('p_yea_info.cur_itax '||to_char(p_yea_info.cur_itax));
1702: hr_utility.trace('p_yea_info.cur_rtax '||to_char(p_yea_info.cur_rtax));
1703: hr_utility.trace('p_yea_info.cur_stax '||to_char(p_yea_info.cur_stax));
1704: end if;
1705: --
1706: end if;
1707: close csr_assact;
1710: -- This code will be changed in the near future by using PER_CONTACT_RELATIONSHIPS.
1711: ------------------------------------------------------------------------
1712: --
1713: if g_debug then
1714: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',40);
1715: end if;
1716: --
1717: l_dummy := pay_kr_ff_functions_pkg.get_dependent_info(
1718: p_assignment_id => p_assignment_id,
1736: ------------------------------------------------------------------------
1737: -- Derive YEA Information from assignment EIT.
1738: ------------------------------------------------------------------------
1739: if g_debug then
1740: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',50);
1741: end if;
1742: ------------------------------------------------------------------------
1743: -- Previous Employers' Information
1744: ------------------------------------------------------------------------
1785: ------------------------------------------------------------------------
1786: -- Special Tax Exemption Information
1787: ------------------------------------------------------------------------
1788: if g_debug then
1789: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',60);
1790: end if;
1791: --
1792: sp_tax_exem_info(
1793: p_assignment_id => p_assignment_id,
1832: ------------------------------------------------------------------------
1833: -- Dependent Education Expense Tax Exemption Information
1834: ------------------------------------------------------------------------
1835: if g_debug then
1836: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',70);
1837: end if;
1838: --
1839: dpnt_educ_tax_exem_info(
1840: p_assignment_id => p_assignment_id,
1846: -- Changes for Bug 3201332
1847: -- Foreign Worker PreTax Deduction Information
1848: ------------------------------------------------------------------------
1849: if g_debug then
1850: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',75);
1851: end if;
1852: --
1853: fw_tax_exem_info(
1854: p_assignment_id => p_assignment_id,
1859: -- Housing Expenses Tax Exemption
1860: -- Changed for Bug 2523481
1861: ------------------------------------------------------------------------
1862: if g_debug then
1863: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',80);
1864: end if;
1865: --
1866: hous_exp_tax_exem_info(
1867: p_assignment_id => p_assignment_id,
1872: -- Tax Exemption Information
1873: -- Direct card expenses introduced for fix 2879008
1874: ------------------------------------------------------------------------
1875: if g_debug then
1876: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',90);
1877: end if;
1878: --
1879: tax_exem_info(
1880: p_assignment_id => p_assignment_id,
1910: ------------------------------------------------------------------------
1911: -- Tax Break Information
1912: ------------------------------------------------------------------------
1913: if g_debug then
1914: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',100);
1915: end if;
1916: --
1917: tax_break_info(
1918: p_assignment_id => p_assignment_id,
1924: ------------------------------------------------------------------------
1925: -- Overseas Tax Break Information
1926: ------------------------------------------------------------------------
1927: if g_debug then
1928: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',110);
1929: end if;
1930: --
1931: ovs_tax_break_info(
1932: p_assignment_id => p_assignment_id,
1950: ------------------------------------------------------------------------
1951: -- Foreign Worker Tax Break Information
1952: ------------------------------------------------------------------------
1953: if g_debug then
1954: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',120);
1955: end if;
1956: --
1957: -- Bug 5083240: Update call for new parameters p_assignment_action_id, p_contr_taxable_earn, and p_contr_non_taxable_earn
1958: fw_tax_break_info(
1989: -- Derive Tax Exemption, Tax Break, Tax Adjustment etc.
1990: -- which depends on effective_date.
1991: ------------------------------------------------------------------------
1992: if g_debug then
1993: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',130);
1994: end if;
1995: --
1996: -- Bug 6705170
1997: --
2062: p_yea_info => p_yea_info);
2063: end if;
2064: ---------------
2065: if g_debug then
2066: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2063: end if;
2064: ---------------
2065: if g_debug then
2066: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2064: ---------------
2065: if g_debug then
2066: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2065: if g_debug then
2066: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2066: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2074: hr_utility.trace('=====================================================');
2067: hr_utility.trace('Current Taxable : '||to_char(p_yea_info.cur_taxable));
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2074: hr_utility.trace('=====================================================');
2075: end if;
2068: hr_utility.trace('Previous Taxable : '||to_char(p_yea_info.prev_taxable));
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2074: hr_utility.trace('=====================================================');
2075: end if;
2076: ----------------
2069: hr_utility.trace('Total Taxable : '||to_char(p_yea_info.taxable));
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2074: hr_utility.trace('=====================================================');
2075: end if;
2076: ----------------
2077: ------------------------------------------------------------------------
2070: hr_utility.trace('Income Tax : '||to_char(p_yea_info.cur_itax));
2071: hr_utility.trace('Resident Tax : '||to_char(p_yea_info.cur_itax));
2072: hr_utility.trace('Income Tax Adjustment : '||to_char(p_yea_info.itax_adj));
2073: hr_utility.trace('Resident Tax Adjustment : '||to_char(p_yea_info.rtax_adj));
2074: hr_utility.trace('=====================================================');
2075: end if;
2076: ----------------
2077: ------------------------------------------------------------------------
2078: -- Setup output warnings
2286:
2287: begin
2288: --
2289: if g_debug then
2290: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',10);
2291: end if;
2292: --
2293: hr_api.mandatory_arg_error(
2294: p_api_name => l_proc,
2311: p_argument => 'report_category',
2312: p_argument_value => p_report_category);
2313: --
2314: if g_debug then
2315: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',20);
2316: end if;
2317: --
2318: open csr_asg;
2319: fetch csr_asg into l_business_group_id, l_esd, l_eed, l_payroll_id;
2322: --
2323: close csr_asg;
2324: --
2325: if g_debug then
2326: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',30);
2327: end if;
2328: --
2329: fnd_message.set_name('PAY', 'PAY_KR_INV_ASG');
2330: p_error := fnd_message.get;
2333: --
2334: close csr_asg;
2335: --
2336: if g_debug then
2337: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',40);
2338: end if;
2339: --
2340: --
2341: -- Business Group Validation
2363: end if;
2364: end if;
2365: --
2366: if g_debug then
2367: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',50);
2368: end if;
2369: ------------------------------------------------------------------------
2370: -- If invalid assacts exist before effective_date, raise error.
2371: ------------------------------------------------------------------------
2383: close csr_incomplete_exists;
2384: end if;
2385: --
2386: if g_debug then
2387: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',60);
2388: end if;
2389: ------------------------------------------------------------------------
2390: -- YEA Type Validation
2391: ------------------------------------------------------------------------
2394:
2395: if csr_archive_exists%FOUND then
2396: --
2397: if g_debug then
2398: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',70);
2399: end if;
2400: --
2401: close csr_archive_exists;
2402:
2414: end if;
2415: else
2416: --
2417: if g_debug then
2418: hr_utility.set_location('pay_kr_yea_pkg.chk_assignment_id.',80);
2419: end if;
2420: --
2421: close csr_archive_exists;
2422:
2497: ------------------------------------------------------------------------
2498: -- Process YEA
2499: ------------------------------------------------------------------------
2500: if g_debug then
2501: hr_utility.trace('Running YEA ..........................................');
2502: end if;
2503: --
2504: yea_info(
2505: p_assignment_id => p_assignment_id,
2517: p_tax_adj_warning => l_tax_adj_warning);
2518:
2519: --
2520: if g_debug then
2521: hr_utility.trace('p_yea_info.cur_itax '||to_char(l_yea_info.cur_itax));
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2518:
2519: --
2520: if g_debug then
2521: hr_utility.trace('p_yea_info.cur_itax '||to_char(l_yea_info.cur_itax));
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2519: --
2520: if g_debug then
2521: hr_utility.trace('p_yea_info.cur_itax '||to_char(l_yea_info.cur_itax));
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2527: hr_utility.trace('Checking Balance...........');
2520: if g_debug then
2521: hr_utility.trace('p_yea_info.cur_itax '||to_char(l_yea_info.cur_itax));
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2527: hr_utility.trace('Checking Balance...........');
2528: end if;
2521: hr_utility.trace('p_yea_info.cur_itax '||to_char(l_yea_info.cur_itax));
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2527: hr_utility.trace('Checking Balance...........');
2528: end if;
2529: --
2522: hr_utility.trace('p_yea_info.cur_rtax '||to_char(l_yea_info.cur_rtax));
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2527: hr_utility.trace('Checking Balance...........');
2528: end if;
2529: --
2530: pay_balance_pkg.get_value ( p_assignment_action_id => p_bal_asg_action_id
2523: hr_utility.trace('p_yea_info.cur_stax '||to_char(l_yea_info.cur_stax));
2524: hr_utility.trace('p_yea_info.itax_adj '||to_char(l_yea_info.itax_adj));
2525: hr_utility.trace('p_yea_info.rtax_adj '||to_char(l_yea_info.rtax_adj));
2526: hr_utility.trace('p_yea_info.stax_adj '||to_char(l_yea_info.stax_adj));
2527: hr_utility.trace('Checking Balance...........');
2528: end if;
2529: --
2530: pay_balance_pkg.get_value ( p_assignment_action_id => p_bal_asg_action_id
2531: ,p_defined_balance_lst => g_tax_adj_balance_tab );
2530: pay_balance_pkg.get_value ( p_assignment_action_id => p_bal_asg_action_id
2531: ,p_defined_balance_lst => g_tax_adj_balance_tab );
2532: --
2533: if g_debug then
2534: hr_utility.trace('Balance Value of itax_adj = '||to_char(g_tax_adj_balance_tab(1).balance_value));
2535: hr_utility.trace('Balance Value of rtax_adj = '||to_char(g_tax_adj_balance_tab(2).balance_value));
2536: hr_utility.trace('Balance Value of stax_adj = '||to_char(g_tax_adj_balance_tab(3).balance_value));
2537: end if;
2538: -----------------------------------------------------------------------
2531: ,p_defined_balance_lst => g_tax_adj_balance_tab );
2532: --
2533: if g_debug then
2534: hr_utility.trace('Balance Value of itax_adj = '||to_char(g_tax_adj_balance_tab(1).balance_value));
2535: hr_utility.trace('Balance Value of rtax_adj = '||to_char(g_tax_adj_balance_tab(2).balance_value));
2536: hr_utility.trace('Balance Value of stax_adj = '||to_char(g_tax_adj_balance_tab(3).balance_value));
2537: end if;
2538: -----------------------------------------------------------------------
2539: if g_tax_adj_balance_tab(1).balance_value <> l_yea_info.itax_adj OR
2532: --
2533: if g_debug then
2534: hr_utility.trace('Balance Value of itax_adj = '||to_char(g_tax_adj_balance_tab(1).balance_value));
2535: hr_utility.trace('Balance Value of rtax_adj = '||to_char(g_tax_adj_balance_tab(2).balance_value));
2536: hr_utility.trace('Balance Value of stax_adj = '||to_char(g_tax_adj_balance_tab(3).balance_value));
2537: end if;
2538: -----------------------------------------------------------------------
2539: if g_tax_adj_balance_tab(1).balance_value <> l_yea_info.itax_adj OR
2540: g_tax_adj_balance_tab(2).balance_value <> l_yea_info.rtax_adj OR
2541: g_tax_adj_balance_tab(3).balance_value <> l_yea_info.stax_adj
2542: then
2543: --
2544: if g_debug then
2545: hr_utility.trace('Incorrect Balance Adjustment amount');
2546: end if;
2547: --
2548: fnd_message.set_name('PAY', 'PAY_KR_INCORRECT_ADJ_AMT');
2549: fnd_message.set_token('ASSIGNMENT_ID', p_assignment_id);
2565: fnd_message.raise_error;
2566: else
2567: --
2568: if g_debug then
2569: hr_utility.trace('Archiving...................');
2570: end if;
2571: ------------------------------------------------------------------------
2572: -- Convert from YEA result from record variable to PL/SQL table.
2573: ------------------------------------------------------------------------
2685: --
2686: hr_api.validate_bus_grp_id(p_business_group_id);
2687: --
2688: if g_debug then
2689: hr_utility.trace('Assignment Id: '||to_char(p_assignment_id)||' Payroll Action Id: '||to_char(p_payroll_action_id));
2690: hr_utility.trace('Effective Date: '||to_char(p_effective_date)||' Business Group Id: '||to_char(p_business_group_id));
2691: end if;
2692: --
2693: open csr_pact;
2686: hr_api.validate_bus_grp_id(p_business_group_id);
2687: --
2688: if g_debug then
2689: hr_utility.trace('Assignment Id: '||to_char(p_assignment_id)||' Payroll Action Id: '||to_char(p_payroll_action_id));
2690: hr_utility.trace('Effective Date: '||to_char(p_effective_date)||' Business Group Id: '||to_char(p_business_group_id));
2691: end if;
2692: --
2693: open csr_pact;
2694: fetch csr_pact into r_pact;
2694: fetch csr_pact into r_pact;
2695: close csr_pact;
2696: --
2697: if g_debug then
2698: hr_utility.trace('Checking Assignment');
2699: end if;
2700: ------------------------------------------------------------------------
2701: -- Assignment validation
2702: ------------------------------------------------------------------------
2709: p_report_category => r_pact.report_category,
2710: p_error => p_error);
2711: --
2712: if g_debug then
2713: hr_utility.trace('After checking assignment');
2714: end if;
2715: --
2716: if p_error is not null then
2717: return 1; -- failure
2717: return 1; -- failure
2718: else
2719: --
2720: if g_debug then
2721: hr_utility.trace('Calculating Adjustments');
2722: end if;
2723: --
2724: -------------------------------------------------------------------------
2725: -- Calculate Tax Adjustments
2743: p_rtax_adj := l_yea_info.rtax_adj;
2744: p_stax_adj := l_yea_info.stax_adj;
2745:
2746: if g_debug then
2747: hr_utility.trace('p_itax_adj '||to_char(p_itax_adj));
2748: hr_utility.trace('p_rtax_adj '||to_char(p_rtax_adj));
2749: hr_utility.trace('p_stax_adj '||to_char(p_stax_adj));
2750: end if;
2751:
2744: p_stax_adj := l_yea_info.stax_adj;
2745:
2746: if g_debug then
2747: hr_utility.trace('p_itax_adj '||to_char(p_itax_adj));
2748: hr_utility.trace('p_rtax_adj '||to_char(p_rtax_adj));
2749: hr_utility.trace('p_stax_adj '||to_char(p_stax_adj));
2750: end if;
2751:
2752: return 0; -- success
2745:
2746: if g_debug then
2747: hr_utility.trace('p_itax_adj '||to_char(p_itax_adj));
2748: hr_utility.trace('p_rtax_adj '||to_char(p_rtax_adj));
2749: hr_utility.trace('p_stax_adj '||to_char(p_stax_adj));
2750: end if;
2751:
2752: return 0; -- success
2753: end if;