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 1548: fnd_number.canonical_to_number(l_config_value(l_config_value.FIRST).pcv_information2);

1544: THEN
1545: l_rolling_window_length := 6;
1546: ELSE
1547: l_rolling_window_length :=
1548: fnd_number.canonical_to_number(l_config_value(l_config_value.FIRST).pcv_information2);
1549: END IF;
1550:
1551: -- performance fix : 1
1552: g_reference_extract := l_config_value(l_config_value.FIRST).pcv_information3;

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

1958: IF csr_get_ttl_rslt%NOTFOUND
1959: THEN
1960: l_Basic_Data_Cnt := RPAD(' ',10,' ');
1961: ELSE
1962: l_Basic_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
1963: END IF;
1964: CLOSE csr_get_ttl_rslt;
1965:
1966: -- For Nuvos

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

1986: IF csr_get_ttl_rslt%NOTFOUND
1987: THEN
1988: l_Address_Data_Cnt := RPAD(' ',10,' ');
1989: ELSE
1990: l_Address_Data_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_03),'0999999999')));
1991: END IF;
1992: CLOSE csr_get_ttl_rslt;
1993: -- For Nuvos
1994: OPEN csr_get_eff_date(c_ext_rslt_id => l_ext_adi_rslt_id);

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

2016: l_Sal_hist_Nat_Pay_Cnt := RPAD(' ',16,' ');
2017: ELSE
2018: --
2019: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2020: l_Salary_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2021: ELSE
2022: l_Salary_Hist_Cnt := RPAD(' ',10,' ');
2023: END IF;
2024: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2022: l_Salary_Hist_Cnt := RPAD(' ',10,' ');
2023: END IF;
2024: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2025:
2026: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2027: IF l_total_amount < 0 THEN
2028: l_Sal_hist_Nat_Pay_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2029: ELSE
2030: l_Sal_hist_Nat_Pay_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2064: IF csr_get_ttl_rslt%NOTFOUND
2065: THEN
2066: l_Service_Hist_Cnt := RPAD(' ',10,' ');
2067: ELSE
2068: l_Service_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2069: END IF;
2070: CLOSE csr_get_ttl_rslt;
2071: -- For Nuvos
2072: OPEN csr_get_eff_date(c_ext_rslt_id => l_ext_sehi_rslt_id);

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

2095: l_Earning_Tot_Cnt := RPAD(' ',16,' ');
2096: ELSE
2097: --
2098: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2099: l_Earning_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2100: ELSE
2101: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2102: END IF;
2103: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2101: l_Earning_Hist_Cnt := RPAD(' ',10,' ');
2102: END IF;
2103: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2104:
2105: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2106: IF l_total_amount < 0 THEN
2107: l_Earning_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2108: ELSE
2109: l_Earning_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

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

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

2148: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');
2149: ELSE
2150: --
2151: IF l_get_ern_ttl_rslt.payhcnt IS NOT NULL THEN
2152: l_Pay_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ern_ttl_rslt.payhcnt),'0999999999')));
2153: ELSE
2154: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2155: END IF;
2156: IF l_get_ern_ttl_rslt.pearntot IS NOT NULL THEN

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

2154: l_Pay_Hist_Cnt := RPAD(' ',10,' ');
2155: END IF;
2156: IF l_get_ern_ttl_rslt.pearntot IS NOT NULL THEN
2157:
2158: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pearntot);
2159: IF l_total_amount < 0 THEN
2160: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2161: ELSE
2162: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2161: ELSE
2162: l_Pay_Tot_EARN_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2163: END IF;
2164:
2165: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2166: ELSE
2167: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2168: END IF;
2169: IF l_get_ern_ttl_rslt.pdedstot IS NOT NULL THEN

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

2167: l_Pay_Tot_EARN_Cnt := RPAD(' ',16,' ');
2168: END IF;
2169: IF l_get_ern_ttl_rslt.pdedstot IS NOT NULL THEN
2170:
2171: l_total_amount := fnd_number.canonical_to_number(l_get_ern_ttl_rslt.pdedstot);
2172: IF l_total_amount < 0 THEN
2173: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2174: ELSE
2175: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2174: ELSE
2175: l_Pay_Tot_DEDS_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2176: END IF;
2177:
2178: -- l_Earning_Tot_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2179: ELSE
2180: l_Pay_Tot_DEDS_Cnt := RPAD(' ',16,' ');
2181: END IF;
2182: --

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

2218: l_Bonus_Tot_Cnt := RPAD(' ',16,' ');
2219: ELSE
2220: --
2221: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2222: l_Bonus_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2223: ELSE
2224: l_Bonus_Hist_Cnt := RPAD(' ',10,' ');
2225: END IF;
2226: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2224: l_Bonus_Hist_Cnt := RPAD(' ',10,' ');
2225: END IF;
2226: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2227:
2228: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2229: IF l_total_amount < 0 THEN
2230: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2231: ELSE
2232: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2231: ELSE
2232: l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2233: END IF;
2234:
2235: -- l_Bonus_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2236: ELSE
2237: l_Bonus_Tot_Cnt := RPAD(' ',16,' ');
2238: END IF;
2239: --

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

2270: l_WPS_Tot_Cnt := RPAD(' ',16,' ');
2271: ELSE
2272: --
2273: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2274: l_WPS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2275: ELSE
2276: l_WPS_Hist_Cnt := RPAD(' ',10,' ');
2277: END IF;
2278: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2276: l_WPS_Hist_Cnt := RPAD(' ',10,' ');
2277: END IF;
2278: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2279:
2280: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2281: IF l_total_amount < 0 THEN
2282: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2283: ELSE
2284: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2283: ELSE
2284: l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2285: END IF;
2286:
2287: -- l_WPS_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2288: ELSE
2289: l_WPS_Tot_Cnt := RPAD(' ',16,' ');
2290: END IF;
2291: --

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

2322: l_STA_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2323: ELSE
2324: --
2325: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2326: l_STA_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2327: ELSE
2328: l_STA_Hist_Cnt := RPAD(' ',10,' ');
2329: END IF;
2330: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2327: ELSE
2328: l_STA_Hist_Cnt := RPAD(' ',10,' ');
2329: END IF;
2330: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2331: l_STA_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2332: ELSE
2333: l_STA_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2334: END IF;
2335: --

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

2366: l_STS_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2367: ELSE
2368: --
2369: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2370: l_STS_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2371: ELSE
2372: l_STS_Hist_Cnt := RPAD(' ',10,' ');
2373: END IF;
2374: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2371: ELSE
2372: l_STS_Hist_Cnt := RPAD(' ',10,' ');
2373: END IF;
2374: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2375: l_STS_Tot_AdjHrs_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2376: ELSE
2377: l_STS_Tot_AdjHrs_Cnt := RPAD(' ',16,' ');
2378: END IF;
2379: --

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

2410: l_Allowance_Tot_Cnt := RPAD(' ',16,' ');
2411: ELSE
2412: --
2413: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2414: l_Allowance_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2415: ELSE
2416: l_Allowance_Hist_Cnt := RPAD(' ',10,' ');
2417: END IF;
2418: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2416: l_Allowance_Hist_Cnt := RPAD(' ',10,' ');
2417: END IF;
2418: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2419:
2420: l_total_amount := fnd_number.canonical_to_number(l_get_ttl_rslt.val_02);
2421: IF l_total_amount < 0 THEN
2422: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'S099999999999.99')));
2423: ELSE
2424: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));

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

2423: ELSE
2424: l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(l_total_amount,'0999999999999.99')));
2425: END IF;
2426:
2427: -- l_Allowance_Tot_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'0999999999999.99')));
2428: ELSE
2429: l_Allowance_Tot_Cnt := RPAD(' ',16,' ');
2430: END IF;
2431: --

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

2463: l_Tot_Part_Time_Hours_Cnt := RPAD(' ',16,' ');
2464: ELSE
2465: --
2466: IF l_get_ttl_rslt.val_01 IS NOT NULL THEN
2467: l_PTH_Hist_Cnt :=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_01),'0999999999')));
2468: ELSE
2469: l_PTH_Hist_Cnt := RPAD(' ',10,' ');
2470: END IF;
2471: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN

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

2468: ELSE
2469: l_PTH_Hist_Cnt := RPAD(' ',10,' ');
2470: END IF;
2471: IF l_get_ttl_rslt.val_02 IS NOT NULL THEN
2472: l_Tot_Part_Time_Hours_Cnt:=rtrim(ltrim(to_char(fnd_number.canonical_to_number(l_get_ttl_rslt.val_02),'S099999999999D99')));
2473: ELSE
2474: l_Tot_Part_Time_Hours_Cnt := RPAD(' ',16,' ');
2475: END IF;
2476: --

Line 2520: 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')));

2516: IF g_output_name IS NULL THEN
2517: l_cntrl_tot(1).seq_num := '002';
2518: ELSE
2519: IF p_parent_request_id IS NULL THEN
2520: 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')));
2521: ELSE
2522: 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')));
2523: END IF;
2524: END IF;

Line 2522: 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')));

2518: ELSE
2519: IF p_parent_request_id IS NULL THEN
2520: 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')));
2521: ELSE
2522: 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')));
2523: END IF;
2524: END IF;
2525: END IF;
2526:

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

3326: ELSE
3327: IF g_output_name IS NULL THEN
3328: g_sequence_number := '002';
3329: ELSE
3330: g_sequence_number := rtrim(ltrim(to_char(fnd_number.canonical_to_number(substr(g_output_name,INSTR(g_output_name,'.')+1))+1,'099')));
3331: END IF;
3332: END IF;
3333:
3334: debug('g_extract_type : ' || g_extract_type);

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

3445:
3446: ben_ext_thread.g_err_num := p_error_number;
3447: ben_ext_thread.g_err_name := p_error_text;
3448: l_error_text :=
3449: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),
3450: p_error_text,ben_ext_fmt.g_elmt_name);
3451:
3452: -- if any token is defined than replace the tokens in the message.
3453: -- and get the message text from fnd_messages.

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

3591: debug('p_token1 is null');
3592: ben_ext_thread.g_err_num := p_error_number;
3593: ben_ext_thread.g_err_name := p_error_text;
3594: l_error_text :=
3595: ben_ext_fmt.get_error_msg(fnd_number.canonical_to_number(substr(p_error_text, 5, 5)),
3596: p_error_text,ben_ext_fmt.g_elmt_name);
3597:
3598: -- if any token is defined than replace the tokens in the message.
3599: -- and get the message text from fnd_messages.