DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on FND_NUMBER

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

647: 'Direct Payment') THEN --if 14
648: hr_utility.set_location(gv_package || lv_procedure_name, 125);
649: lv_action_category := 'IP EARNINGS';
650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
651: := fnd_number.number_to_canonical(ln_current_hours);
652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
653: := fnd_number.number_to_canonical(ln_ytd_hours);
654: END IF; --if 14
655:

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

649: lv_action_category := 'IP EARNINGS';
650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
651: := fnd_number.number_to_canonical(ln_current_hours);
652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
653: := fnd_number.number_to_canonical(ln_ytd_hours);
654: END IF; --if 14
655:
656: hr_utility.set_location(gv_package || lv_procedure_name, 130);
657: /* Insert this into the plsql table if Current or YTD

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

670: := p_primary_balance_id;
671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
676: := fnd_number.number_to_canonical(ln_ytd_amount);
677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
678: := p_reporting_name;

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

672: := p_processing_priority;
673: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
674: := fnd_number.number_to_canonical(ln_payments_amount);
675: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
676: := fnd_number.number_to_canonical(ln_ytd_amount);
677: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
678: := p_reporting_name;
679:
680: END IF; --if 13

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

948: 'Taxable Benefits','Employer Charges') THEN
949:
950: lv_action_info_category := 'IP EARNINGS';
951: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
952: := fnd_number.number_to_canonical(ln_ytd_hours);
953: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
954: :='0'; /*Current Hours will always be zero as we only archive YTD amounts of missing elements*/
955:
956: END IF;

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

970: := ln_primary_balance_id;
971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
976: := fnd_number.number_to_canonical(ln_ytd_amount);
977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
978: := lv_reporting_name;

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

972: := ln_processing_priority;
973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
974: := fnd_number.number_to_canonical(ln_payments_amount);
975: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
976: := fnd_number.number_to_canonical(ln_ytd_amount);
977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
978: := lv_reporting_name;
979:
980: END IF;

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

1324: 'Supplemental Earnings','Direct Payment',
1325: 'Taxable Benefits','Employer Charges') THEN
1326: lv_action_info_category := 'IP EARNINGS';
1327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1328: := fnd_number.number_to_canonical(ln_ytd_hours);
1329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1330: := fnd_number.number_to_canonical(0);
1331:
1332: END IF;

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

1326: lv_action_info_category := 'IP EARNINGS';
1327: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1328: := fnd_number.number_to_canonical(ln_ytd_hours);
1329: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1330: := fnd_number.number_to_canonical(0);
1331:
1332: END IF;
1333:
1334: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

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

1345: := ln_primary_balance_id;
1346: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1351: := fnd_number.number_to_canonical(ln_ytd_amount);
1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1353: := lv_reporting_name;

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

1347: := ln_processing_priority;
1348: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1349: := fnd_number.number_to_canonical(ln_payments_amount);
1350: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1351: := fnd_number.number_to_canonical(ln_ytd_amount);
1352: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1353: := lv_reporting_name;
1354: END IF;
1355: END IF;

Line 1973: ,p_action_information8 => fnd_number.number_to_canonical(ln_amount)

1969: ,p_action_information1 => lv_classification_name
1970: ,p_action_information2 => ln_element_type_id
1971: ,p_action_information6 => NULL --primary_ balance_id
1972: ,p_action_information7 => NULL --processing Priority
1973: ,p_action_information8 => fnd_number.number_to_canonical(ln_amount)
1974: ,p_action_information10 => lv_reporting_name
1975: ,p_action_information11 => fnd_number.number_to_canonical(ln_hours) --Current Hours
1976: ,p_action_information12 => NULL --ytd hours
1977: );

Line 1975: ,p_action_information11 => fnd_number.number_to_canonical(ln_hours) --Current Hours

1971: ,p_action_information6 => NULL --primary_ balance_id
1972: ,p_action_information7 => NULL --processing Priority
1973: ,p_action_information8 => fnd_number.number_to_canonical(ln_amount)
1974: ,p_action_information10 => lv_reporting_name
1975: ,p_action_information11 => fnd_number.number_to_canonical(ln_hours) --Current Hours
1976: ,p_action_information12 => NULL --ytd hours
1977: );
1978:
1979: hr_utility.trace('Element Name '||lv_reporting_name);

Line 1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));

1976: ,p_action_information12 => NULL --ytd hours
1977: );
1978:
1979: hr_utility.trace('Element Name '||lv_reporting_name);
1980: hr_utility.trace('Amount '||fnd_number.number_to_canonical(ln_amount));
1981: ln_step := 5;
1982: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1983: END LOOP;
1984:

Line 3009: := fnd_number.number_to_canonical(ln_amount);

3005: := dbt(i).def_bal_id;
3006: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3007: := dbt(i).dimension;
3008: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3009: := fnd_number.number_to_canonical(ln_amount);
3010: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3011: := lv_reporting_name;
3012: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
3013: := dbt(i).attribute_name;

Line 3438: ,p_action_information6 => fnd_number.number_to_canonical(csr_rec.absence_days) -- Bug 3604206

3434: ,p_action_information2 => csr_rec.reporting_name
3435: ,p_action_information3 => NULL
3436: ,p_action_information4 => l_start_date
3437: ,p_action_information5 => l_end_date
3438: ,p_action_information6 => fnd_number.number_to_canonical(csr_rec.absence_days) -- Bug 3604206
3439: ,p_action_information7 => NULL
3440: );
3441: --
3442: END LOOP;

Line 3577: lv_net_pay_run := fnd_number.number_to_canonical(

3573:
3574: END LOOP;
3575: hr_utility.set_location(l_procedure_name, 30);
3576:
3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)

Line 3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -

3574: END LOOP;
3575: hr_utility.set_location(l_procedure_name, 30);
3576:
3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));

Line 3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +

3575: hr_utility.set_location(l_procedure_name, 30);
3576:
3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);

Line 3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +

3576:
3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN

Line 3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)

3577: lv_net_pay_run := fnd_number.number_to_canonical(
3578: nvl(fnd_number.canonical_to_number(lv_gross_earnings_run),0) -
3579: (nvl(fnd_number.canonical_to_number(lv_deductions_run),0) +
3580: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_run),0) +
3581: nvl(fnd_number.canonical_to_number(lv_tax_deductions_run),0)
3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);

Line 3586: lv_net_pay_ytd := fnd_number.number_to_canonical(

3582: ));
3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +
3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)

Line 3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -

3583: hr_utility.set_location(l_procedure_name, 35);
3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +
3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)
3591: ));

Line 3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +

3584: IF gv_is_tax_unit_enabled = 'Y' THEN
3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +
3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)
3591: ));
3592: END IF;

Line 3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +

3585: hr_utility.set_location(l_procedure_name, 40);
3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +
3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)
3591: ));
3592: END IF;
3593:

Line 3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)

3586: lv_net_pay_ytd := fnd_number.number_to_canonical(
3587: nvl(fnd_number.canonical_to_number(lv_gross_earnings_ytd),0) -
3588: (nvl(fnd_number.canonical_to_number(lv_deductions_ytd),0) +
3589: nvl(fnd_number.canonical_to_number(lv_pre_tax_deductions_ytd),0) +
3590: nvl(fnd_number.canonical_to_number(lv_tax_deductions_ytd),0)
3591: ));
3592: END IF;
3593:
3594: l_ovn := 1;