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

Line 1484: fnd_number.canonical_to_number(l_config_value(l_config_value.FIRST).pcv_information2);

1480: THEN
1481: l_rolling_window_length := 6;
1482: ELSE
1483: l_rolling_window_length :=
1484: fnd_number.canonical_to_number(l_config_value(l_config_value.FIRST).pcv_information2);
1485: END IF;
1486:
1487: -- performance fix : 1
1488: g_reference_extract := l_config_value(l_config_value.FIRST).pcv_information3;

Line 1898: l_Basic_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

1894: IF csr_get_ttl_rslt%NOTFOUND
1895: THEN
1896: l_Basic_Data_Cnt := RPAD(' ',10,' ');
1897: ELSE
1898: l_Basic_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
1899: END IF;
1900: CLOSE csr_get_ttl_rslt;
1901:
1902: -- For Nuvos

Line 1926: l_Address_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_03),'0999999999')));

1922: IF csr_get_ttl_rslt%NOTFOUND
1923: THEN
1924: l_Address_Data_Cnt := RPAD(' ',10,' ');
1925: ELSE
1926: l_Address_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_03),'0999999999')));
1927: END IF;
1928: CLOSE csr_get_ttl_rslt;
1929: -- For Nuvos
1930: OPEN csr_get_eff_date(c_ext_rslt_id => l_ext_adi_rslt_id);

Line 1956: l_Salary_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

1952: l_Sal_hist_Nat_Pay_Cnt := RPAD(' ',16,' ');
1953: ELSE
1954: --
1955: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
1956: l_Salary_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
1957: ELSE
1958: l_Salary_Hist_Cnt := RPAD(' ',10,' ');
1959: END IF;
1960: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 1962: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);

1958: l_Salary_Hist_Cnt := RPAD(' ',10,' ');
1959: END IF;
1960: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
1961:
1962: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
1963: IF l_total_amount < 0 THEN
1964: l_Sal_hist_Nat_Pay_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
1965: ELSE
1966: l_Sal_hist_Nat_Pay_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2004: l_Service_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2000: IF csr_get_ttl_rslt%NOTFOUND
2001: THEN
2002: l_Service_Hist_Cnt := RPAD(' ',10,' ');
2003: ELSE
2004: l_Service_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2005: END IF;
2006: CLOSE csr_get_ttl_rslt;
2007: -- For Nuvos
2008: OPEN csr_get_eff_date(c_ext_rslt_id => l_ext_sehi_rslt_id);

Line 2035: l_Earning_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2031: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2032: ELSE
2033: --
2034: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2035: l_Earning_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2036: ELSE
2037: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2038: END IF;
2039: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2041: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);

2037: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2038: END IF;
2039: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2040:
2041: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2042: IF l_total_amount < 0 THEN
2043: l_Earning_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2044: ELSE
2045: l_Earning_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2048: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2044: ELSE
2045: l_Earning_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2046: END IF;
2047:
2048: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2049: ELSE
2050: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2051: END IF;
2052: --

Line 2088: l_Pay_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ern_ttl_rslt.payhcnt),'0999999999')));

2084: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');
2085: ELSE
2086: --
2087: IF l_get_ern_ttl_rslt.payhcnt IS NOT NULL THEN
2088: l_Pay_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ern_ttl_rslt.payhcnt),'0999999999')));
2089: ELSE
2090: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2091: END IF;
2092: IF l_get_ern_ttl_rslt.pearntot IS NOT NULL THEN

Line 2094: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pearntot);

2090: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2091: END IF;
2092: IF l_get_ern_ttl_rslt.pearntot IS NOT NULL THEN
2093:
2094: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pearntot);
2095: IF l_total_amount < 0 THEN
2096: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2097: ELSE
2098: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2101: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2097: ELSE
2098: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2099: END IF;
2100:
2101: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2102: ELSE
2103: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2104: END IF;
2105: IF l_get_ern_ttl_rslt.pdedstot IS NOT NULL THEN

Line 2107: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pdedstot);

2103: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2104: END IF;
2105: IF l_get_ern_ttl_rslt.pdedstot IS NOT NULL THEN
2106:
2107: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pdedstot);
2108: IF l_total_amount < 0 THEN
2109: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2110: ELSE
2111: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2114: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2110: ELSE
2111: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2112: END IF;
2113:
2114: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2115: ELSE
2116: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');
2117: END IF;
2118: --

Line 2158: l_Bonus_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2154: l_Bonus_Tot_Cnt := RPAD(' ',16,' ');
2155: ELSE
2156: --
2157: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2158: l_Bonus_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2159: ELSE
2160: l_Bonus_Hist_Cnt := RPAD(' ',10,' ');
2161: END IF;
2162: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2164: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);

2160: l_Bonus_Hist_Cnt := RPAD(' ',10,' ');
2161: END IF;
2162: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2163:
2164: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2165: IF l_total_amount < 0 THEN
2166: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2167: ELSE
2168: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2171: -- l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2167: ELSE
2168: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2169: END IF;
2170:
2171: -- l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2172: ELSE
2173: l_Bonus_Tot_Cnt := RPAD(' ',16,' ');
2174: END IF;
2175: --

Line 2210: l_WPS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2206: l_WPS_Tot_Cnt := RPAD(' ',16,' ');
2207: ELSE
2208: --
2209: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2210: l_WPS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2211: ELSE
2212: l_WPS_Hist_Cnt := RPAD(' ',10,' ');
2213: END IF;
2214: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2216: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);

2212: l_WPS_Hist_Cnt := RPAD(' ',10,' ');
2213: END IF;
2214: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2215:
2216: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2217: IF l_total_amount < 0 THEN
2218: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2219: ELSE
2220: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2223: -- l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2219: ELSE
2220: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2221: END IF;
2222:
2223: -- l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2224: ELSE
2225: l_WPS_Tot_Cnt := RPAD(' ',16,' ');
2226: END IF;
2227: --

Line 2262: l_STA_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2258: l_STA_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2259: ELSE
2260: --
2261: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2262: l_STA_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2263: ELSE
2264: l_STA_Hist_Cnt := RPAD(' ',10,' ');
2265: END IF;
2266: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2267: l_STA_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));

2263: ELSE
2264: l_STA_Hist_Cnt := RPAD(' ',10,' ');
2265: END IF;
2266: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2267: l_STA_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2268: ELSE
2269: l_STA_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2270: END IF;
2271: --

Line 2306: l_STS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2302: l_STS_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2303: ELSE
2304: --
2305: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2306: l_STS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2307: ELSE
2308: l_STS_Hist_Cnt := RPAD(' ',10,' ');
2309: END IF;
2310: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2311: l_STS_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));

2307: ELSE
2308: l_STS_Hist_Cnt := RPAD(' ',10,' ');
2309: END IF;
2310: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2311: l_STS_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2312: ELSE
2313: l_STS_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2314: END IF;
2315: --

Line 2350: l_Allowance_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2346: l_Allowance_Tot_Cnt := RPAD(' ',16,' ');
2347: ELSE
2348: --
2349: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2350: l_Allowance_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2351: ELSE
2352: l_Allowance_Hist_Cnt := RPAD(' ',10,' ');
2353: END IF;
2354: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2356: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);

2352: l_Allowance_Hist_Cnt := RPAD(' ',10,' ');
2353: END IF;
2354: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2355:
2356: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2357: IF l_total_amount < 0 THEN
2358: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2359: ELSE
2360: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

Line 2363: -- l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));

2359: ELSE
2360: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2361: END IF;
2362:
2363: -- l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2364: ELSE
2365: l_Allowance_Tot_Cnt := RPAD(' ',16,' ');
2366: END IF;
2367: --

Line 2403: l_PTH_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));

2399: l_Tot_Part_Time_Hours_Cnt := RPAD(' ',16,' ');
2400: ELSE
2401: --
2402: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2403: l_PTH_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2404: ELSE
2405: l_PTH_Hist_Cnt := RPAD(' ',10,' ');
2406: END IF;
2407: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

Line 2408: l_Tot_Part_Time_Hours_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));

2404: ELSE
2405: l_PTH_Hist_Cnt := RPAD(' ',10,' ');
2406: END IF;
2407: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2408: l_Tot_Part_Time_Hours_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2409: ELSE
2410: l_Tot_Part_Time_Hours_Cnt := RPAD(' ',16,' ');
2411: END IF;
2412: --

Line 2456: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));

2452: IF g_output_name IS NULL THEN
2453: l_cntrl_tot(1).seq_num := '002';
2454: ELSE
2455: IF p_parent_request_id IS NULL THEN
2456: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));
2457: ELSE
2458: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1)),'099')));
2459: END IF;
2460: END IF;

Line 2458: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1)),'099')));

2454: ELSE
2455: IF p_parent_request_id IS NULL THEN
2456: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));
2457: ELSE
2458: l_cntrl_tot(1).seq_num := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1)),'099')));
2459: END IF;
2460: END IF;
2461: END IF;
2462:

Line 3266: g_sequence_number := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));

3262: ELSE
3263: IF g_output_name IS NULL THEN
3264: g_sequence_number := '002';
3265: ELSE
3266: g_sequence_number := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));
3267: END IF;
3268: END IF;
3269:
3270: debug('g_extract_type : ' || g_extract_type);

Line 3385: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),

3381:
3382: ben_ext_thread.g_err_num := p_error_number;
3383: ben_ext_thread.g_err_name := p_error_text;
3384: l_error_text :=
3385: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),
3386: p_error_text,ben_ext_fmt.g_elmt_name);
3387:
3388: -- if any token is defined than replace the tokens in the message.
3389: -- and get the message text from fnd_messages.

Line 3531: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),

3527: debug('p_token1 is null');
3528: ben_ext_thread.g_err_num := p_error_number;
3529: ben_ext_thread.g_err_name := p_error_text;
3530: l_error_text :=
3531: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),
3532: p_error_text,ben_ext_fmt.g_elmt_name);
3533:
3534: -- if any token is defined than replace the tokens in the message.
3535: -- and get the message text from fnd_messages.