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_AC_ACTION_ARCH dependencies on FND_NUMBER

Line 125: 02-JUN-2008 sapalani 115.100 7120430 Used fnd_number.canonical_to_number

121: 23-JUN-2008 sudedas 115.101 7197824 Changed get_current_element
122: ,archive_retro_element
123: ,archive_addnl_element
124: for Work at Home Condition
125: 02-JUN-2008 sapalani 115.100 7120430 Used fnd_number.canonical_to_number
126: in procedure populate_summary.
127: Removed trace_off at the end of
128: procedure populate_hours_x_rate.
129: 14-APR-2008 asgugupt 115.99 6950970 Modified get_current_elements

Line 1421: := fnd_number.number_to_canonical(ln_current_hours);

1417: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1418: lv_action_category := 'AC EARNINGS';
1419: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1420: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1421: := fnd_number.number_to_canonical(ln_current_hours);
1422: */
1423: IF p_ytd_flag = 'N' then
1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1425: := fnd_number.number_to_canonical(ln_current_hours);

Line 1425: := fnd_number.number_to_canonical(ln_current_hours);

1421: := fnd_number.number_to_canonical(ln_current_hours);
1422: */
1423: IF p_ytd_flag = 'N' then
1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1425: := fnd_number.number_to_canonical(ln_current_hours);
1426: ELSE
1427: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1428: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1429: END IF;

Line 1428: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);

1424: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1425: := fnd_number.number_to_canonical(ln_current_hours);
1426: ELSE
1427: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1428: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1429: END IF;
1430:
1431: IF ln_current_hours <> 0 AND ln_payments_amount <> 0 THEN
1432: /*12819017-Start*/

Line 1463: := fnd_number.number_to_canonical(ln_ytd_hours);

1459: END IF;
1460:
1461: IF p_ytd_flag = 'N' then
1462: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1463: := fnd_number.number_to_canonical(ln_ytd_hours);
1464: ELSE
1465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1467: END IF;

Line 1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);

1462: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1463: := fnd_number.number_to_canonical(ln_ytd_hours);
1464: ELSE
1465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1466: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1467: END IF;
1468: end if;
1469:
1470: hr_utility.set_location(gv_package || lv_procedure_name, 130);

Line 1489: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));

1485: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1486: := p_processing_priority;
1487: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1488: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1489: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1490: */
1491:
1492: IF p_ytd_flag = 'N' then
1493: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 1494: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));

1490: */
1491:
1492: IF p_ytd_flag = 'N' then
1493: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1494: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1495: ELSE
1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1498: END IF;

Line 1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);

1493: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1494: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1495: ELSE
1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1498: END IF;
1499:
1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1501:

Line 1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));

1496: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1497: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1498: END IF;
1499:
1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1501:
1502: IF p_ytd_flag = 'N' then
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

Line 1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

1500: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1501:
1502: IF p_ytd_flag = 'N' then
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1505: ELSE
1506: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1508: END IF;

Line 1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);

1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1504: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1505: ELSE
1506: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1507: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1508: END IF;
1509: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1510: := p_reporting_name;
1511: IF lv_action_category = 'AC DEDUCTIONS' THEN

Line 1883: := fnd_number.number_to_canonical(ln_retro_payvalue);

1879: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));

1880: := ln_processing_priority;
1881: hr_utility.trace('act_info7' || ln_processing_priority);
1882: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1883: := fnd_number.number_to_canonical(ln_retro_payvalue);
1884: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1885: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1886: := 0;
1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;

Line 1891: := fnd_number.number_to_canonical(ln_retro_hours);

1887: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);

Line 1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));

1888: := lv_reporting_name;
1889: hr_utility.trace('act_info10' || lv_reporting_name);
1890: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1891: := fnd_number.number_to_canonical(ln_retro_hours);
1892: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1893: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:

Line 1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);

1894: := p_xfr_action_id;
1895: hr_utility.trace('action_context_id' || p_xfr_action_id);
1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;

Line 1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));

1896:
1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;
1903: CLOSE c_retro;
1904: hr_utility.set_location(gv_package || lv_procedure_name, 77);

Line 1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));

1897: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1898: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1899: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1900: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1901: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1902: END LOOP;
1903: CLOSE c_retro;
1904: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1905:

Line 1968: := fnd_number.number_to_canonical(ln_payments_amount);

1964: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:

Line 1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/

1965: := ln_processing_priority;
1966: hr_utility.trace('act_info72' || ln_processing_priority);
1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1971: := fnd_number.number_to_canonical(ln_ytd_amount);

1967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1968: := fnd_number.number_to_canonical(ln_payments_amount);
1969: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1970: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1971: := fnd_number.number_to_canonical(ln_ytd_amount);
1972:
1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);

Line 1977: := fnd_number.number_to_canonical(ln_hours);

1973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

Line 1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));

1974: := lv_reporting_name;
1975: hr_utility.trace('act_info102' || lv_reporting_name);
1976: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1977: := fnd_number.number_to_canonical(ln_hours);
1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);

Line 1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);

1978: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1979: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));

Line 1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));

1980: := p_xfr_action_id;
1981: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1988: prev_element_type_id := ln_element_type_id;

Line 1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));

1982: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1988: prev_element_type_id := ln_element_type_id;
1989: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1990: end loop;

Line 1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));

1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1984: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 --13938951
1986: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1987: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1988: prev_element_type_id := ln_element_type_id;
1989: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1990: end loop;
1991: end if;

Line 3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

3177: := ln_primary_balance_id;
3178: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3179: := ln_processing_priority;
3180: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3181: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3183: := lv_reporting_name;
3184: if lv_action_info_category = 'AC EARNINGS' then
3185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

Line 3186: := fnd_number.number_to_canonical(ln_ytd_hours);

3182: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3183: := lv_reporting_name;
3184: if lv_action_info_category = 'AC EARNINGS' then
3185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3186: := fnd_number.number_to_canonical(ln_ytd_hours);
3187: end if;
3188:
3189: -- Added for Bug# 7348767, Bug# 7348838
3190: if lv_action_info_category = 'AC DEDUCTIONS' THEN

Line 3316: := fnd_number.number_to_canonical(ln_ytd_hours);

3312: 'Imputed Earnings',
3313: 'Non-payroll Payments') then
3314: lv_action_info_category := 'AC EARNINGS';
3315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3316: := fnd_number.number_to_canonical(ln_ytd_hours);
3317: end if;
3318:
3319: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3320: := lv_action_info_category;

Line 3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));

3330: := ln_primary_balance_id;
3331: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3336: := fnd_number.number_to_canonical(ln_ytd_amount);
3337: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3338: := lv_reporting_name;

Line 3336: := fnd_number.number_to_canonical(ln_ytd_amount);

3332: := ln_processing_priority;
3333: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3334: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3335: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3336: := fnd_number.number_to_canonical(ln_ytd_amount);
3337: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3338: := lv_reporting_name;
3339: -- Added for Bug# 7348767, Bug# 7348838
3340: if lv_action_info_category = 'AC DEDUCTIONS' THEN

Line 3616: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/

3612: 'Imputed Earnings',
3613: 'Non-payroll Payments') then
3614: lv_action_info_category := 'AC EARNINGS';
3615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3616: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3617: end if;
3618:
3619: ln_step := 20;
3620: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

Line 3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));

3631: := ln_primary_balance_id;
3632: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3639: := lv_reporting_name;

Line 3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

3633: := ln_processing_priority;
3634: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3635: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3636: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3637: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3638: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3639: := lv_reporting_name;
3640: -- Added for Bug# 7348767, Bug# 7348838
3641: if lv_action_info_category = 'AC DEDUCTIONS' THEN

Line 4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4162: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4163: ln_step := 3;
4164: lv_earnings
4165: := lv_earnings +
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4167: lv_ytd_earnings
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4165: := lv_earnings +
4166: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4167: lv_ytd_earnings
4168: := lv_ytd_earnings +
4169: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4170: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4171: = 'Supplemental Earnings' then
4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;

Line 4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4172: hr_utility.set_location(gv_package || lv_procedure_name, 40);
4173: ln_step := 4;
4174: lv_supplemental_earnings
4175: := lv_supplemental_earnings +
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4177: lv_ytd_supplemental_earnings
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4175: := lv_supplemental_earnings +
4176: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4177: lv_ytd_supplemental_earnings
4178: := lv_ytd_supplemental_earnings +
4179: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4180: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4181: = 'Imputed Earnings' then
4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;

Line 4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4182: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4183: ln_step := 5;
4184: lv_imputed_earnings
4185: := lv_imputed_earnings +
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4187: lv_ytd_imputed_earnings
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4185: := lv_imputed_earnings +
4186: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4187: lv_ytd_imputed_earnings
4188: := lv_ytd_imputed_earnings +
4189: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4190: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4191: = 'Non-payroll Payments' then
4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;

Line 4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4192: hr_utility.set_location(gv_package || lv_procedure_name, 50);
4193: ln_step := 6;
4194: lv_non_payroll_payments
4195: := lv_non_payroll_payments +
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4197: lv_ytd_non_payroll_payments
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4195: := lv_non_payroll_payments +
4196: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4197: lv_ytd_non_payroll_payments
4198: := lv_ytd_non_payroll_payments +
4199: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4200: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4201: = 'Taxable Benefits' then
4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;

Line 4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4202: hr_utility.set_location(gv_package || lv_procedure_name, 55);
4203: ln_step := 7;
4204: lv_taxable_benefits
4205: := lv_taxable_benefits +
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4207: lv_ytd_taxable_benefits
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4205: := lv_taxable_benefits +
4206: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4207: lv_ytd_taxable_benefits
4208: := lv_ytd_taxable_benefits +
4209: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4210: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4211: = 'Alien/Expat Earnings' then
4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;

Line 4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4212: hr_utility.set_location(gv_package || lv_procedure_name, 56);
4213: ln_step := 8;
4214: lv_alien_expat_earnings
4215: := lv_alien_expat_earnings +
4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4217: lv_ytd_alien_expat_earnings
4218: := lv_ytd_alien_expat_earnings +
4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4220: end if;

Line 4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4215: := lv_alien_expat_earnings +
4216: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4217: lv_ytd_alien_expat_earnings
4218: := lv_ytd_alien_expat_earnings +
4219: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4220: end if;
4221:
4222: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
4223: = 'AC DEDUCTIONS' then

Line 4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4226: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4227: ln_step := 15;
4228: lv_pre_tax_deductions
4229: := lv_pre_tax_deductions +
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4231: lv_ytd_pre_tax_deductions
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4229: := lv_pre_tax_deductions +
4230: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4231: lv_ytd_pre_tax_deductions
4232: := lv_ytd_pre_tax_deductions +
4233: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4234: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4235: = 'Involuntary Deductions' then
4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;

Line 4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4236: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4237: ln_step := 16;
4238: lv_involuntary_deductions
4239: := lv_involuntary_deductions +
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4241: lv_ytd_involuntary_deductions
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4239: := lv_involuntary_deductions +
4240: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4241: lv_ytd_involuntary_deductions
4242: := lv_ytd_involuntary_deductions +
4243: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4244: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4245: = 'Voluntary Deductions' then
4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;

Line 4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4246: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4247: ln_step := 17;
4248: lv_voluntary_deductions
4249: := lv_voluntary_deductions +
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4251: lv_ytd_voluntary_deductions
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

Line 4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4249: := lv_voluntary_deductions +
4250: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4251: lv_ytd_voluntary_deductions
4252: := lv_ytd_voluntary_deductions +
4253: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4254: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
4255: = 'Tax Deductions' then
4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;

Line 4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);

4256: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4257: ln_step := 18;
4258: lv_tax_deductions
4259: := lv_tax_deductions +
4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4261: lv_ytd_tax_deductions
4262: := lv_ytd_tax_deductions +
4263: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4264: end if;

Line 4263: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);

4259: := lv_tax_deductions +
4260: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
4261: lv_ytd_tax_deductions
4262: := lv_ytd_tax_deductions +
4263: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
4264: end if;
4265: end if;
4266: end if;
4267: end loop;

Line 4302: := fnd_number.number_to_canonical(lv_earnings); /Bug 3311866/

4298: := 'AC SUMMARY CURRENT';
4299: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);

Line 4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;

4300: := '00-000-0000';
4301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;

Line 4306: := fnd_number.number_to_canonical(lv_imputed_earnings);

4302: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
4303: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);

Line 4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;

4304: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
4305: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;

Line 4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);

4306: := fnd_number.number_to_canonical(lv_imputed_earnings);
4307: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;

Line 4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;

4308: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
4309: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);

Line 4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;

4310: := fnd_number.number_to_canonical(lv_involuntary_deductions);
4311: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);

Line 4316: := fnd_number.number_to_canonical(lv_taxable_benefits);

4312: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
4313: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);

Line 4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);

4314: := fnd_number.number_to_canonical(lv_tax_deductions) ;
4315: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4322: := lv_current_label;

Line 4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);

4316: := fnd_number.number_to_canonical(lv_taxable_benefits);
4317: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4318: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
4319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4320: := fnd_number.number_to_canonical(lv_non_payroll_payments);
4321: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4322: := lv_current_label;
4323:
4324: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /Bug 3311866/

4329: := 'AC SUMMARY YTD';
4330: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);

Line 4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;

4331: := '00-000-0000';
4332: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;

Line 4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);

4333: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
4334: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);

Line 4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;

4335: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
4336: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;

Line 4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);

4337: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
4338: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;

Line 4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;

4339: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
4340: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);

Line 4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;

4341: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
4342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);

Line 4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);

4343: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
4344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);

Line 4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);

4345: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
4346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4353: := lv_ytd_label;

Line 4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);

4347: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
4348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4349: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
4350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
4351: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
4352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4353: := lv_ytd_label;
4354: end if;
4355:

Line 4543: := fnd_number.number_to_canonical(ln_current_hours); /Bug 3311866/

4539: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4540: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4544: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4545: := fnd_number.number_to_canonical(ln_ytd_hours);
4546: else
4547: lv_action_category := 'AC DEDUCTIONS';

Line 4545: := fnd_number.number_to_canonical(ln_ytd_hours);

4541: ln_step := 80;
4542: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4543: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4544: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4545: := fnd_number.number_to_canonical(ln_ytd_hours);
4546: else
4547: lv_action_category := 'AC DEDUCTIONS';
4548: end if;
4549: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 4571: := fnd_number.number_to_canonical(ln_payments_amount); /Bug 3311866/

4567: := ln_primary_balance_id;
4568: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4573: := fnd_number.number_to_canonical(ln_ytd_amount);
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4575: := lv_reporting_name;

Line 4573: := fnd_number.number_to_canonical(ln_ytd_amount);

4569: := ln_processing_priority;
4570: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4571: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4573: := fnd_number.number_to_canonical(ln_ytd_amount);
4574: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4575: := lv_reporting_name;
4576:
4577: end if;

Line 5166: := fnd_number.number_to_canonical(ln_hours);

5162: 'Alien/Expat Earnings') then
5163: lv_action_category := 'AC EARNINGS';
5164:
5165: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5166: := fnd_number.number_to_canonical(ln_hours);
5167: -- YTD Hours
5168: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5169: := round(ln_rate,2);
5170:

Line 5172: := fnd_number.number_to_canonical(0);

5168: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5169: := round(ln_rate,2);
5170:
5171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5172: := fnd_number.number_to_canonical(0);
5173: end if; -- Classification Earnings
5174:
5175: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5176: /* Insert this into the plsql table if Current or YTD

Line 5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));

5194: := p_primary_balance_id;
5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN

Line 5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

5195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5196: := p_processing_priority;
5197: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5198: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5199: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5200: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5201: := p_reporting_name;
5202: IF lv_action_category = 'AC DEDUCTIONS' THEN
5203: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24

Line 5221: := fnd_number.number_to_canonical(0);

5217: hr_utility.trace('lv_category ' || lv_category );
5218: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5219: := lv_jurisdiction_flag;
5220: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5221: := fnd_number.number_to_canonical(0);
5222:
5223: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5224:
5225: ln_step := 20;

Line 5287: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

5283: end if;
5284: end if;
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5287: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5288: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5289:
5290: /*Bug# 13785386 - Start*/
5291: /* if ln_hours_derv_flag then --to pull YTD hours if hours is dervied.

Line 5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047

5298: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5299: = 'AC EARNINGS' then
5300:
5301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5302: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5303: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5304: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5305:
5306: end if;

Line 5313: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

5309: -- Global Variable Setting Needed Here
5310: -- That Can be Subtracted during Base Population
5311: --
5312: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5313: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5314: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5315: gv_ytd_amount := ln_ytd_amount ;
5316: /*gv_ytd_amount := nvl(gv_ytd_amount,0)+ln_ytd_amount ; --Bug# 13785386 */
5317:

Line 5319: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047

5315: gv_ytd_amount := ln_ytd_amount ;
5316: /*gv_ytd_amount := nvl(gv_ytd_amount,0)+ln_ytd_amount ; --Bug# 13785386 */
5317:
5318: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5319: := fnd_number.number_to_canonical(ln_ytd_hours); -- Bug# 13877047
5320: gv_ytd_hour := ln_ytd_hours ;
5321: /*gv_ytd_hour := nvl(gv_ytd_hour,0)+ln_ytd_hours ; --Bug# 13785386 */
5322:
5323: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);

Line 5708: := fnd_number.number_to_canonical(ln_hours);

5704: ln_step := 15;
5705: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5706:
5707: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5708: := fnd_number.number_to_canonical(ln_hours);
5709: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5710: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5711: /* Insert this into the plsql table if Current or YTD
5712: amount is not Zero */

Line 5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));

5729: := p_primary_balance_id;
5730: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

Line 5735: := fnd_number.number_to_canonical(0);

5731: := p_processing_priority;
5732: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5739: := p_reporting_name;

Line 5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

5733: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5734: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5735: := fnd_number.number_to_canonical(0);
5736:
5737: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5738: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5739: := p_reporting_name;
5740:
5741: IF lv_temp_AAA <> 'AAA' THEN

Line 5906: := fnd_number.number_to_canonical(ln_ytd_amount);

5902:
5903: ln_step := 15;
5904:
5905: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5906: := fnd_number.number_to_canonical(ln_ytd_amount);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5910: := fnd_number.number_to_canonical(ln_ytd_hours);

Line 5910: := fnd_number.number_to_canonical(ln_ytd_hours);

5906: := fnd_number.number_to_canonical(ln_ytd_amount);
5907: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5908:
5909: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5910: := fnd_number.number_to_canonical(ln_ytd_hours);
5911: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5912:
5913: /* Following later to be re-valuated IF worth doing wrt Cost
5914:

Line 5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

5913: /* Following later to be re-valuated IF worth doing wrt Cost
5914:
5915: IF count_j is null THEN
5916: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5921: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);

Line 5920: := fnd_number.number_to_canonical(ln_ytd_hours);

5916: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5917: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5918: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5919: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5920: := fnd_number.number_to_canonical(ln_ytd_hours);
5921: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5922: END IF;
5923: */
5924:

Line 6320: := fnd_number.number_to_canonical(ln_hours);

6316: ln_step := 15;
6317: ln_index := pay_ac_action_arch.lrr_act_tab.count;
6318:
6319: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
6320: := fnd_number.number_to_canonical(ln_hours);
6321: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
6322: hr_utility.set_location(gv_package || lv_procedure_name, 130);
6323: /* Insert this into the plsql table if Current or YTD
6324: amount is not Zero */

Line 6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));

6341: := p_primary_balance_id;
6342: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

Line 6347: := fnd_number.number_to_canonical(0);

6343: := p_processing_priority;
6344: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6351: := p_reporting_name;

Line 6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

6345: := fnd_number.number_to_canonical(nvl(ln_amount,0));
6346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6347: := fnd_number.number_to_canonical(0);
6348:
6349: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
6350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
6351: := p_reporting_name;
6352:
6353: IF lv_temp_AAA <> 'AAA' THEN

Line 6518: := fnd_number.number_to_canonical(ln_ytd_amount);

6514:
6515: ln_step := 15;
6516:
6517: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6518: := fnd_number.number_to_canonical(ln_ytd_amount);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6522: := fnd_number.number_to_canonical(ln_ytd_hours);

Line 6522: := fnd_number.number_to_canonical(ln_ytd_hours);

6518: := fnd_number.number_to_canonical(ln_ytd_amount);
6519: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
6520:
6521: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6522: := fnd_number.number_to_canonical(ln_ytd_hours);
6523: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6524:
6525: /* Following later to be re-valuated IF worth doing wrt Cost
6526:

Line 6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

6525: /* Following later to be re-valuated IF worth doing wrt Cost
6526:
6527: IF count_j is null THEN
6528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6533: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);

Line 6532: := fnd_number.number_to_canonical(ln_ytd_hours);

6528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6529: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
6530: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
6531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
6532: := fnd_number.number_to_canonical(ln_ytd_hours);
6533: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
6534: END IF;
6535: */
6536: