APPS.ARP_CREDIT_MEMO_MODULE dependencies on FND_NUMBER

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

921: l_amount_fragment || CRLF ||
922: ' / foreign_fc.minimum_accountable_unit) *
923: foreign_fc.minimum_accountable_unit
924: ) * nvl(ct.exchange_rate, 1) / ' ||
925: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || CRLF ||
926: ' ) * ' || fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ', /* acctd_amount */' ;
927:
928:
929: END IF;

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

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

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

1084: ELSE
1085:
1086: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||
1087: ' round(ctl.extended_amount * nvl(ct.exchange_rate, 1) / ' ||
1088: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ') * ' ||
1089: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) ;
1090:
1091: END IF;
1092:

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

1085:
1086: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||
1087: ' round(ctl.extended_amount * nvl(ct.exchange_rate, 1) / ' ||
1088: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ') * ' ||
1089: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) ;
1090:
1091: END IF;
1092:
1093: l_nonrule_insert_dist_sql := l_nonrule_insert_dist_sql || CRLF ||

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

1254: ELSE
1255:
1256: l_amount_fragment :=
1257: 'round((ctl.extended_amount * nvl(ct.exchange_rate, 1)) / ' ||
1258: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ') * ' ||
1259: fnd_number.number_to_canonical(system_info.base_min_acc_unit);
1260:
1261: END IF;
1262:

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

1255:
1256: l_amount_fragment :=
1257: 'round((ctl.extended_amount * nvl(ct.exchange_rate, 1)) / ' ||
1258: fnd_number.number_to_canonical(system_info.base_min_acc_unit) || ') * ' ||
1259: fnd_number.number_to_canonical(system_info.base_min_acc_unit);
1260:
1261: END IF;
1262:
1263: l_nonrule_update_dist2_sql :=

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

1722: round((:amount_3 * ' || l_temp || ' ) /
1723: fc.minimum_accountable_unit)
1724: * fc.minimum_accountable_unit )
1725: * nvl(ct.exchange_rate, 1)
1726: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1727: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1728:
1729: END IF;
1730:

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

1723: fc.minimum_accountable_unit)
1724: * fc.minimum_accountable_unit )
1725: * nvl(ct.exchange_rate, 1)
1726: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1727: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1728:
1729: END IF;
1730:
1731: l_rule_insert_dist_sql := l_rule_insert_dist_sql || CRLF ||

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

1892: round((:amount_3 * (lgd.percent / 100) ) /
1893: fc.minimum_accountable_unit)
1894: * fc.minimum_accountable_unit )
1895: * nvl(ct.exchange_rate, 1)
1896: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1897: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1898:
1899: END IF;
1900:

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

1893: fc.minimum_accountable_unit)
1894: * fc.minimum_accountable_unit )
1895: * nvl(ct.exchange_rate, 1)
1896: ) / ' || fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ' ) *' || CRLF ||
1897: fnd_number.number_to_canonical(p_system_info.base_min_acc_unit) || ')';
1898:
1899: END IF;
1900:
1901: l_rule_insert_dist_sql := l_rule_insert_dist_sql || CRLF ||