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.FTE_LTL_LOADER dependencies on FND_NUMBER

Line 972: expiry_date = (G_VALID_DATE-Fnd_Number.Canonical_To_Number('0.0001')),

968:
969: UPDATE
970: FTE_LANES
971: SET
972: expiry_date = (G_VALID_DATE-Fnd_Number.Canonical_To_Number('0.0001')),
973: last_updated_by = G_USER_ID,
974: last_update_date = SYSDATE,
975: last_update_login = G_USER_ID
976: WHERE

Line 1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp

1621:
1622: v_validate_keys STRINGARRAY;
1623: v_validate_data STRINGARRAY;
1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),

Line 1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),

1622: v_validate_keys STRINGARRAY;
1623: v_validate_data STRINGARRAY;
1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),

Line 1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),

1623: v_validate_data STRINGARRAY;
1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),

Line 1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),

1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),

Line 1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),

1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),
1633: Fnd_Number.Canonical_To_Number('9999999'));

Line 1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),

1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),
1633: Fnd_Number.Canonical_To_Number('9999999'));
1634:

Line 1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),

1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),
1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),
1633: Fnd_Number.Canonical_To_Number('9999999'));
1634:
1635: -- variables for creating commodity classes from class_string

Line 1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),

1628: Fnd_Number.Canonical_To_Number('4999.999999999999999'),
1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),
1633: Fnd_Number.Canonical_To_Number('9999999'));
1634:
1635: -- variables for creating commodity classes from class_string
1636: v_class_string VARCHAR2(200) := p_class_string;

Line 1633: Fnd_Number.Canonical_To_Number('9999999'));

1629: Fnd_Number.Canonical_To_Number('9999.999999999999999'),
1630: Fnd_Number.Canonical_To_Number('19999.999999999999999'),
1631: Fnd_Number.Canonical_To_Number('29999.999999999999999'),
1632: Fnd_Number.Canonical_To_Number('39999.999999999999999'),
1633: Fnd_Number.Canonical_To_Number('9999999'));
1634:
1635: -- variables for creating commodity classes from class_string
1636: v_class_string VARCHAR2(200) := p_class_string;
1637:

Line 1853: v_break_max := Fnd_Number.Canonical_To_Number('0');

1849: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1850: RETURN;
1851: END IF;
1852:
1853: v_break_max := Fnd_Number.Canonical_To_Number('0');
1854: -- example (break_min,break_max) pairs are (0, 500..), (500, 1000..), ...
1855: v_current_linenum := 0;
1856:
1857: FOR i IN 1..v_numBreaks_perClass LOOP

Line 1858: v_break_min := v_break_max + Fnd_Number.Canonical_To_Number('0');

1854: -- example (break_min,break_max) pairs are (0, 500..), (500, 1000..), ...
1855: v_current_linenum := 0;
1856:
1857: FOR i IN 1..v_numBreaks_perClass LOOP
1858: v_break_min := v_break_max + Fnd_Number.Canonical_To_Number('0');
1859: v_break_max := v_break_max_vals(i);
1860: v_break_charge := v_break_charges(v_current_break);
1861:
1862: v_break_charge := ltrim(v_break_charge, '0');

Line 1866: v_break_charge := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(v_break_charge)/10000);

1862: v_break_charge := ltrim(v_break_charge, '0');
1863:
1864: IF (LENGTH(v_break_charge) > 0) THEN -- skip if it was all 0's.
1865: v_current_linenum := v_current_linenum + 1;
1866: v_break_charge := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(v_break_charge)/10000);
1867:
1868: l_rate_break_data('ACTION') := 'ADD';
1869: l_rate_break_data('LINE_NUMBER'):= (v_parent_linenum + v_current_linenum);
1870: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_min);

Line 1870: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_min);

1866: v_break_charge := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(v_break_charge)/10000);
1867:
1868: l_rate_break_data('ACTION') := 'ADD';
1869: l_rate_break_data('LINE_NUMBER'):= (v_parent_linenum + v_current_linenum);
1870: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_min);
1871: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_max);
1872: l_rate_break_data('RATE') := v_break_charge;
1873:
1874: l_rate_break_block_tbl(1) := l_rate_break_data;

Line 1871: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_max);

1867:
1868: l_rate_break_data('ACTION') := 'ADD';
1869: l_rate_break_data('LINE_NUMBER'):= (v_parent_linenum + v_current_linenum);
1870: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_min);
1871: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(v_break_max);
1872: l_rate_break_data('RATE') := v_break_charge;
1873:
1874: l_rate_break_block_tbl(1) := l_rate_break_data;
1875:

Line 2606: l_conc_request_data := G_VALID_DATE_STRING ||','|| Fnd_Number.Number_To_Canonical(p_number_of_loads) ||','||

2602: END IF;
2603: END LOOP;
2604:
2605: IF (x_status <> 2) THEN
2606: l_conc_request_data := G_VALID_DATE_STRING ||','|| Fnd_Number.Number_To_Canonical(p_number_of_loads) ||','||
2607: p_origin ||','|| p_origin_name ||','||
2608: l_debug_on ||','|| G_DIRECTION_FLAG ||',' ||
2609: G_REPORT_HEADER.STARTDATE;
2610:

Line 2943: l_min_charge1 := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(l_min_charge1)/100);

2939: hash_size => g_hash_size);
2940: l_min_charge1 := ltrim(l_min_charge1, '0');
2941:
2942: IF (l_min_charge1 IS NOT NULL AND length(l_min_charge1) > 0) THEN
2943: l_min_charge1 := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(l_min_charge1)/100);
2944: END IF;
2945:
2946: l_min_charge_match := FALSE;
2947: l_rate_chart_match := 'N';

Line 3901: l_number_of_loads := Fnd_Number.Canonical_To_Number(t_varchar2_tab(2));

3897: l_var_string := FND_CONC_GLOBAL.request_data;
3898: t_varchar2_tab := FTE_UTIL_PKG.TOKENIZE_STRING(l_var_string, ',');
3899:
3900: G_VALID_DATE := to_date(t_varchar2_tab(1), 'rrrrmmdd');
3901: l_number_of_loads := Fnd_Number.Canonical_To_Number(t_varchar2_tab(2));
3902: l_origin := t_varchar2_tab(3);
3903: l_origin_name := t_varchar2_tab(4);
3904: l_debug_on := t_varchar2_tab(5);
3905: G_DIRECTION_FLAG := t_varchar2_tab(6);