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

Line 467: select fnd_number.canonical_to_number(cinst.value) rate,

463: l_high_value number := 0;
464: l_effective_date date;
465: --
466: cursor csr_get_band_values is
467: select fnd_number.canonical_to_number(cinst.value) rate,
468: fnd_number.canonical_to_number(cinst2.value) high_value,
469: fnd_number.canonical_to_number(cinst3.value) low_value
470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c

Line 468: fnd_number.canonical_to_number(cinst2.value) high_value,

464: l_effective_date date;
465: --
466: cursor csr_get_band_values is
467: select fnd_number.canonical_to_number(cinst.value) rate,
468: fnd_number.canonical_to_number(cinst2.value) high_value,
469: fnd_number.canonical_to_number(cinst3.value) low_value
470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c
472: ,pay_user_column_instances_f cinst2

Line 469: fnd_number.canonical_to_number(cinst3.value) low_value

465: --
466: cursor csr_get_band_values is
467: select fnd_number.canonical_to_number(cinst.value) rate,
468: fnd_number.canonical_to_number(cinst2.value) high_value,
469: fnd_number.canonical_to_number(cinst3.value) low_value
470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c
472: ,pay_user_column_instances_f cinst2
473: ,pay_user_columns c2

Line 505: select fnd_number.canonical_to_number(R.row_low_range_or_name) low_value

501: and r.user_row_id = cinst3.user_row_id;
502: /*
503: --
504: -- Table structures changed - select below is if everything is in one row.
505: select fnd_number.canonical_to_number(R.row_low_range_or_name) low_value
506: ,fnd_number.canonical_to_number(R.row_high_range) high_value
507: ,cinst.value rate
508: from pay_user_column_instances_f cinst
509: ,pay_user_columns c

Line 506: ,fnd_number.canonical_to_number(R.row_high_range) high_value

502: /*
503: --
504: -- Table structures changed - select below is if everything is in one row.
505: select fnd_number.canonical_to_number(R.row_low_range_or_name) low_value
506: ,fnd_number.canonical_to_number(R.row_high_range) high_value
507: ,cinst.value rate
508: from pay_user_column_instances_f cinst
509: ,pay_user_columns c
510: ,pay_user_rows_f r

Line 803: if l_balance_itd < fnd_number.canonical_to_number(o.amount) then

799: monthly payment value - if it would then set the monthly amount to the remaining that is owed,
800: as at the start of the period.
801: ================================================================================================*/
802: if o.priority <> 10 then
803: if l_balance_itd < fnd_number.canonical_to_number(o.amount) then
804: if o.priority in (15,50) and
805: ((l_balance_itd +
806: nvl(fnd_number.canonical_to_number(o.monthly_payment),0)) >
807: fnd_number.canonical_to_number(o.amount))

Line 806: nvl(fnd_number.canonical_to_number(o.monthly_payment),0)) >

802: if o.priority <> 10 then
803: if l_balance_itd < fnd_number.canonical_to_number(o.amount) then
804: if o.priority in (15,50) and
805: ((l_balance_itd +
806: nvl(fnd_number.canonical_to_number(o.monthly_payment),0)) >
807: fnd_number.canonical_to_number(o.amount))
808: then
809: court_order(o.source_id).monthly_payment :=
810: fnd_number.canonical_to_number(o.amount) -

Line 807: fnd_number.canonical_to_number(o.amount))

803: if l_balance_itd < fnd_number.canonical_to_number(o.amount) then
804: if o.priority in (15,50) and
805: ((l_balance_itd +
806: nvl(fnd_number.canonical_to_number(o.monthly_payment),0)) >
807: fnd_number.canonical_to_number(o.amount))
808: then
809: court_order(o.source_id).monthly_payment :=
810: fnd_number.canonical_to_number(o.amount) -
811: (l_balance_itd - l_balance_ptd);

Line 810: fnd_number.canonical_to_number(o.amount) -

806: nvl(fnd_number.canonical_to_number(o.monthly_payment),0)) >
807: fnd_number.canonical_to_number(o.amount))
808: then
809: court_order(o.source_id).monthly_payment :=
810: fnd_number.canonical_to_number(o.amount) -
811: (l_balance_itd - l_balance_ptd);
812: end if;
813: else
814: raise co_paid_off;

Line 822: fnd_number.canonical_to_number(o.monthly_payment);

818: If the monthly payment has not already been assigned above then assign it now.
819: ==============================================================================*/
820: if not court_order.exists(o.source_id) then
821: court_order(o.source_id).monthly_payment :=
822: fnd_number.canonical_to_number(o.monthly_payment);
823: end if;
824: court_order(o.source_id).amount :=
825: fnd_number.canonical_to_number(o.amount);
826: court_order(o.source_id).outstanding_balance :=

Line 825: fnd_number.canonical_to_number(o.amount);

821: court_order(o.source_id).monthly_payment :=
822: fnd_number.canonical_to_number(o.monthly_payment);
823: end if;
824: court_order(o.source_id).amount :=
825: fnd_number.canonical_to_number(o.amount);
826: court_order(o.source_id).outstanding_balance :=
827: court_order(o.source_id).amount - (l_balance_itd - l_balance_ptd);
828: court_order(o.source_id).balance_ptd := l_balance_ptd;
829: court_order(o.source_id).priority := o.priority;

Line 840: fnd_number.canonical_to_number(o.processing_order);

836: if o.priority = 50 then
837: if l_index < 50 then
838: l_index := 50;
839: l_old_proc_order :=
840: fnd_number.canonical_to_number(o.processing_order);
841: end if;
842: if l_old_proc_order <>
843: fnd_number.canonical_to_number(o.processing_order)
844: then

Line 843: fnd_number.canonical_to_number(o.processing_order)

839: l_old_proc_order :=
840: fnd_number.canonical_to_number(o.processing_order);
841: end if;
842: if l_old_proc_order <>
843: fnd_number.canonical_to_number(o.processing_order)
844: then
845: l_index := l_index + 10;
846: end if;
847: else

Line 857: total_order(l_index).amount := total_order(l_index).amount + fnd_number.canonical_to_number(o.amount);

853: end if;
854: --
855: if total_order.exists(l_index) then
856: total_order(l_index).monthly_payment := total_order(l_index).monthly_payment + court_order(o.source_id).monthly_payment;
857: total_order(l_index).amount := total_order(l_index).amount + fnd_number.canonical_to_number(o.amount);
858: total_order(l_index).number_of_orders := total_order(l_index).number_of_orders+1;
859: total_order(l_index).outstanding_balance := total_order(l_index).outstanding_balance + court_order(o.source_id).outstanding_balance;
860: total_order(l_index).start_pos := total_order(l_last_priority).end_pos + 1;
861: total_order(l_index).end_pos := i;

Line 871: fnd_number.canonical_to_number(o.monthly_payment);

867: don't know as they are defined by the user.
868: =========================================================================================*/
869: if o.priority > 40 then
870: total_order(l_index).monthly_payment :=
871: fnd_number.canonical_to_number(o.monthly_payment);
872: total_order(l_index).payment := 0;
873: total_order(l_index).amount :=
874: fnd_number.canonical_to_number(o.amount);
875: total_order(l_index).number_of_orders := 1;

Line 874: fnd_number.canonical_to_number(o.amount);

870: total_order(l_index).monthly_payment :=
871: fnd_number.canonical_to_number(o.monthly_payment);
872: total_order(l_index).payment := 0;
873: total_order(l_index).amount :=
874: fnd_number.canonical_to_number(o.amount);
875: total_order(l_index).number_of_orders := 1;
876: total_order(l_index).outstanding_balance := court_order(o.source_id).outstanding_balance;
877: total_order(l_index).start_pos := total_order(l_last_priority).end_pos + 1;
878: total_order(l_index).end_pos := i;

Line 884: fnd_number.canonical_to_number(o.processing_order);

880: end if;
881: --
882: if o.priority = 50 then
883: l_old_proc_order :=
884: fnd_number.canonical_to_number(o.processing_order);
885: end if;
886: --
887: l_old_priority := l_index;
888: -- Row counter