APPS.ARP_CREDIT_MEMO_MODULE dependencies on FND_NUMBER

Line 929: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || CRLF ||

925: l_amount_fragment || CRLF ||
926: ' / foreign_fc.minimum_accountable_unit) *
927: foreign_fc.minimum_accountable_unit
928: ) * nvl(ct.exchange_rate, 1) / ' ||
929: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || CRLF ||
930: ' ) * ' || fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ', /* acctd_amount */' ;
931:
932:
933: END IF;

Line 930: ' ) * ' || fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ', /* acctd_amount */' ;

926: ' / foreign_fc.minimum_accountable_unit) *
927: foreign_fc.minimum_accountable_unit
928: ) * nvl(ct.exchange_rate, 1) / ' ||
929: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || CRLF ||
930: ' ) * ' || fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ', /* acctd_amount */' ;
931:
932:
933: END IF;
934:

Line 1095: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ') * ' ||

1091: ELSE
1092:
1093: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||
1094: ' round(ctl.extended_amount * nvl(ct.exchange_rate, 1) / ' ||
1095: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ') * ' ||
1096: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) ;
1097:
1098: END IF;
1099:

Line 1096: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) ;

1092:
1093: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||
1094: ' round(ctl.extended_amount * nvl(ct.exchange_rate, 1) / ' ||
1095: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ') * ' ||
1096: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) ;
1097:
1098: END IF;
1099:
1100: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||

Line 1265: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ') * ' ||

1261: ELSE
1262:
1263: l_amount_fragment :=
1264: 'round((ctl.extended_amount * nvl(ct.exchange_rate, 1)) / ' ||
1265: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ') * ' ||
1266: fnd_number.number_to_canonical(system_info.base_min_acc_unit);
1267:
1268: END IF;
1269:

Line 1266: fnd_number.number_to_canonical(system_info.base_min_acc_unit);

1262:
1263: l_amount_fragment :=
1264: 'round((ctl.extended_amount * nvl(ct.exchange_rate, 1)) / ' ||
1265: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ') * ' ||
1266: fnd_number.number_to_canonical(system_info.base_min_acc_unit);
1267:
1268: END IF;
1269:
1270: l_nonrule_update_dist2_sql :=

Line 1738: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||

1734: round((:amount_3 * ' || l_temp || ' ) /
1735: fc.minimum_accountable_unit)
1736: * fc.minimum_accountable_unit )
1737: * nvl(ct.exchange_rate, 1)
1738: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1739: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1740:
1741: END IF;
1742:

Line 1739: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';

1735: fc.minimum_accountable_unit)
1736: * fc.minimum_accountable_unit )
1737: * nvl(ct.exchange_rate, 1)
1738: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1739: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1740:
1741: END IF;
1742:
1743: l_rule_insert_dist_sql := l_rule_insert_dist_sql || CRLF ||

Line 1910: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||

1906: round((:amount_3 * (lgd.percent / 100) ) /
1907: fc.minimum_accountable_unit)
1908: * fc.minimum_accountable_unit )
1909: * nvl(ct.exchange_rate, 1)
1910: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1911: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1912:
1913: END IF;
1914:

Line 1911: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';

1907: fc.minimum_accountable_unit)
1908: * fc.minimum_accountable_unit )
1909: * nvl(ct.exchange_rate, 1)
1910: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1911: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1912:
1913: END IF;
1914:
1915: l_rule_insert_dist_sql := l_rule_insert_dist_sql || CRLF ||