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 36: 02-JUN-2008 sapalani 115.100 7120430 Used fnd_number.canonical_to_number

32: 23-JUN-2008 sudedas 115.101 7197824 Changed get_current_element
33: ,archive_retro_element
34: ,archive_addnl_element
35: for Work at Home Condition
36: 02-JUN-2008 sapalani 115.100 7120430 Used fnd_number.canonical_to_number
37: in procedure populate_summary.
38: Removed trace_off at the end of
39: procedure populate_hours_x_rate.
40: 14-APR-2008 asgugupt 115.99 6950970 Modified get_current_elements

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

1131: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1132: lv_action_category := 'AC EARNINGS';
1133: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1134: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1135: := fnd_number.number_to_canonical(ln_current_hours);
1136: */
1137: IF p_ytd_flag = 'N' then
1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1139: := fnd_number.number_to_canonical(ln_current_hours);

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

1135: := fnd_number.number_to_canonical(ln_current_hours);
1136: */
1137: IF p_ytd_flag = 'N' then
1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1139: := fnd_number.number_to_canonical(ln_current_hours);
1140: ELSE
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1142: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1143: END IF;

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

1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1139: := fnd_number.number_to_canonical(ln_current_hours);
1140: ELSE
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1142: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1143: END IF;
1144:
1145: IF ln_current_hours <> 0 AND ln_payments_amount <> 0 THEN
1146: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22

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

1151: END IF;
1152:
1153: IF p_ytd_flag = 'N' then
1154: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1155: := fnd_number.number_to_canonical(ln_ytd_hours);
1156: ELSE
1157: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1158: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1159: END IF;

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

1154: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1155: := fnd_number.number_to_canonical(ln_ytd_hours);
1156: ELSE
1157: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1158: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1159: END IF;
1160: end if;
1161:
1162: hr_utility.set_location(gv_package || lv_procedure_name, 130);

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

1177: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1178: := p_processing_priority;
1179: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1180: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1181: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1182: */
1183:
1184: IF p_ytd_flag = 'N' then
1185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

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

1182: */
1183:
1184: IF p_ytd_flag = 'N' then
1185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1186: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1187: ELSE
1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1190: END IF;

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

1185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1186: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1187: ELSE
1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1190: END IF;
1191:
1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1193:

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

1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1190: END IF;
1191:
1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1193:
1194: IF p_ytd_flag = 'N' then
1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));

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

1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1193:
1194: IF p_ytd_flag = 'N' then
1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1197: ELSE
1198: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1199: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1200: END IF;

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

1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1197: ELSE
1198: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1199: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1200: END IF;
1201: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1202: := p_reporting_name;
1203: IF lv_action_category = 'AC DEDUCTIONS' THEN

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

1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

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

1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;

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

1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);

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

1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:

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

1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1590: END LOOP;
1591: CLOSE c_retro;
1592: hr_utility.set_location(gv_package || lv_procedure_name, 77);

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

1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1590: END LOOP;
1591: CLOSE c_retro;
1592: hr_utility.set_location(gv_package || lv_procedure_name, 77);
1593:

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

1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:

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

1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

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

1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);

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

1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

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

1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);

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

1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1674: prev_element_type_id := ln_element_type_id;

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

1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1674: prev_element_type_id := ln_element_type_id;
1675: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1676: end loop;

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

1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1674: prev_element_type_id := ln_element_type_id;
1675: prev_run_asg_act_id := hbr(j).run_asg_act_id;
1676: end loop;
1677: end if;

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

2686: := ln_primary_balance_id;
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2688: := ln_processing_priority;
2689: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2690: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2692: := lv_reporting_name;
2693: if lv_action_info_category = 'AC EARNINGS' then
2694: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

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

2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2692: := lv_reporting_name;
2693: if lv_action_info_category = 'AC EARNINGS' then
2694: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2695: := fnd_number.number_to_canonical(ln_ytd_hours);
2696: end if;
2697:
2698: -- Added for Bug# 7348767, Bug# 7348838
2699: if lv_action_info_category = 'AC DEDUCTIONS' THEN

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

2819: 'Imputed Earnings',
2820: 'Non-payroll Payments') then
2821: lv_action_info_category := 'AC EARNINGS';
2822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2823: := fnd_number.number_to_canonical(ln_ytd_hours);
2824: end if;
2825:
2826: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2827: := lv_action_info_category;

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

2837: := ln_primary_balance_id;
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2843: := fnd_number.number_to_canonical(ln_ytd_amount);
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2845: := lv_reporting_name;

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

2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2843: := fnd_number.number_to_canonical(ln_ytd_amount);
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2845: := lv_reporting_name;
2846: -- Added for Bug# 7348767, Bug# 7348838
2847: if lv_action_info_category = 'AC DEDUCTIONS' THEN

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

3117: 'Imputed Earnings',
3118: 'Non-payroll Payments') then
3119: lv_action_info_category := 'AC EARNINGS';
3120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3121: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3122: end if;
3123:
3124: ln_step := 20;
3125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

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

3136: := ln_primary_balance_id;
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3142: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3144: := lv_reporting_name;

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

3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3142: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3144: := lv_reporting_name;
3145: -- Added for Bug# 7348767, Bug# 7348838
3146: if lv_action_info_category = 'AC DEDUCTIONS' THEN

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

3667: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3668: ln_step := 3;
3669: lv_earnings
3670: := lv_earnings +
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3672: lv_ytd_earnings
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3670: := lv_earnings +
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3672: lv_ytd_earnings
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3676: = 'Supplemental Earnings' then
3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;

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

3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;
3679: lv_supplemental_earnings
3680: := lv_supplemental_earnings +
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3682: lv_ytd_supplemental_earnings
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3680: := lv_supplemental_earnings +
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3682: lv_ytd_supplemental_earnings
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3686: = 'Imputed Earnings' then
3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;

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

3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;
3689: lv_imputed_earnings
3690: := lv_imputed_earnings +
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3692: lv_ytd_imputed_earnings
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3690: := lv_imputed_earnings +
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3692: lv_ytd_imputed_earnings
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3696: = 'Non-payroll Payments' then
3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;

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

3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;
3699: lv_non_payroll_payments
3700: := lv_non_payroll_payments +
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3702: lv_ytd_non_payroll_payments
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3700: := lv_non_payroll_payments +
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3702: lv_ytd_non_payroll_payments
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3706: = 'Taxable Benefits' then
3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;

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

3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;
3709: lv_taxable_benefits
3710: := lv_taxable_benefits +
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3712: lv_ytd_taxable_benefits
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3710: := lv_taxable_benefits +
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3712: lv_ytd_taxable_benefits
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3716: = 'Alien/Expat Earnings' then
3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;

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

3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;
3719: lv_alien_expat_earnings
3720: := lv_alien_expat_earnings +
3721: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3722: lv_ytd_alien_expat_earnings
3723: := lv_ytd_alien_expat_earnings +
3724: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3725: end if;

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

3720: := lv_alien_expat_earnings +
3721: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3722: lv_ytd_alien_expat_earnings
3723: := lv_ytd_alien_expat_earnings +
3724: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3725: end if;
3726:
3727: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
3728: = 'AC DEDUCTIONS' then

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

3731: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3732: ln_step := 15;
3733: lv_pre_tax_deductions
3734: := lv_pre_tax_deductions +
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3736: lv_ytd_pre_tax_deductions
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3734: := lv_pre_tax_deductions +
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3736: lv_ytd_pre_tax_deductions
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3740: = 'Involuntary Deductions' then
3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;

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

3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;
3743: lv_involuntary_deductions
3744: := lv_involuntary_deductions +
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3746: lv_ytd_involuntary_deductions
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3744: := lv_involuntary_deductions +
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3746: lv_ytd_involuntary_deductions
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3750: = 'Voluntary Deductions' then
3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;

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

3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;
3753: lv_voluntary_deductions
3754: := lv_voluntary_deductions +
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3756: lv_ytd_voluntary_deductions
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1

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

3754: := lv_voluntary_deductions +
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3756: lv_ytd_voluntary_deductions
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3760: = 'Tax Deductions' then
3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;

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

3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;
3763: lv_tax_deductions
3764: := lv_tax_deductions +
3765: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3766: lv_ytd_tax_deductions
3767: := lv_ytd_tax_deductions +
3768: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3769: end if;

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

3764: := lv_tax_deductions +
3765: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3766: lv_ytd_tax_deductions
3767: := lv_ytd_tax_deductions +
3768: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3769: end if;
3770: end if;
3771: end if;
3772: end loop;

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

3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);

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

3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;

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

3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);

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

3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;

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

3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;

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

3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);

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

3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);

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

3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);

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

3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3827: := lv_current_label;

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

3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3827: := lv_current_label;
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);

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

3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);

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

3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;

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

3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);

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

3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;

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

3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;

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

3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);

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

3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);

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

3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);

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

3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3858: := lv_ytd_label;

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

3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3858: := lv_ytd_label;
3859: end if;
3860:

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

4044: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4049: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4050: := fnd_number.number_to_canonical(ln_ytd_hours);
4051: else
4052: lv_action_category := 'AC DEDUCTIONS';

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

4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4049: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4050: := fnd_number.number_to_canonical(ln_ytd_hours);
4051: else
4052: lv_action_category := 'AC DEDUCTIONS';
4053: end if;
4054: hr_utility.set_location(gv_package || lv_procedure_name, 60);

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

4072: := ln_primary_balance_id;
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4078: := fnd_number.number_to_canonical(ln_ytd_amount);
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4080: := lv_reporting_name;

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

4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4078: := fnd_number.number_to_canonical(ln_ytd_amount);
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4080: := lv_reporting_name;
4081:
4082: end if;

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

4561:
4562: lv_action_category := 'AC EARNINGS';
4563:
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4565: := fnd_number.number_to_canonical(ln_hours);
4566:
4567:
4568: -- YTD Hours
4569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22

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

4569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
4570: := ln_rate;
4571:
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4573: := fnd_number.number_to_canonical(0);
4574:
4575: end if; -- Classification Earnings
4576:
4577: hr_utility.set_location(gv_package || lv_procedure_name, 130);

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

4598: := p_primary_balance_id;
4599: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4604: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
4605:
4606: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

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

4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4604: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
4605:
4606: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4607: := p_reporting_name;
4608: IF lv_action_category = 'AC DEDUCTIONS' THEN

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

4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4625: := lv_jurisdiction_flag;
4626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4627: := fnd_number.number_to_canonical(0);
4628:
4629: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4630:
4631: ln_step := 20;

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

4688: end if;
4689: end if;
4690:
4691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4692: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4693: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4694:
4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4696: = 'AC EARNINGS' then

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

4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4696: = 'AC EARNINGS' then
4697:
4698: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4699: := fnd_number.number_to_canonical(ln_ytd_hours);
4700: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
4701:
4702: end if;
4703: -- End Addition

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

4705: -- Global Variable Setting Needed Here
4706: -- That Can be Subtracted during Base Population
4707: --
4708: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4709: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4710: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4711: gv_ytd_amount := ln_ytd_amount ;
4712:
4713: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

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

4710: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4711: gv_ytd_amount := ln_ytd_amount ;
4712:
4713: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4714: := fnd_number.number_to_canonical(ln_ytd_hours);
4715: gv_ytd_hour := ln_ytd_hours ;
4716:
4717: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
4718:

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

5081: ln_step := 15;
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: 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*/
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5089: amount is not Zero */

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

5106: := p_primary_balance_id;
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));

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

5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5116: := p_reporting_name;

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

5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5116: := p_reporting_name;
5117:
5118: IF lv_temp_AAA <> 'AAA' THEN

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

5279:
5280: ln_step := 15;
5281:
5282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5283: := fnd_number.number_to_canonical(ln_ytd_amount);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5287: := fnd_number.number_to_canonical(ln_ytd_hours);

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

5283: := fnd_number.number_to_canonical(ln_ytd_amount);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5287: := fnd_number.number_to_canonical(ln_ytd_hours);
5288: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5289:
5290: /* Following later to be re-valuated IF worth doing wrt Cost
5291:

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

5290: /* Following later to be re-valuated IF worth doing wrt Cost
5291:
5292: IF count_j is null THEN
5293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5298: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);

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

5293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5298: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5299: END IF;
5300: */
5301: