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

Line 2283: G_control_begin_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2279: ELSIF X_column_name = 'CONTROL_BEGIN_BALANCE' THEN
2280: IF l_DEBUG in ('Y', 'C') THEN
2281: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2282: END IF;
2283: G_control_begin_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2284: ELSIF X_column_name = 'CONTROL_END_BALANCE' THEN
2285: IF l_DEBUG in ('Y', 'C') THEN
2286: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2287: END IF;

Line 2288: G_control_end_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2284: ELSIF X_column_name = 'CONTROL_END_BALANCE' THEN
2285: IF l_DEBUG in ('Y', 'C') THEN
2286: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2287: END IF;
2288: G_control_end_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2289: ELSIF X_column_name = 'AVAILABLE_BALANCE' THEN
2290: IF l_DEBUG in ('Y', 'C') THEN
2291: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2292: END IF;

Line 2293: G_cashflow_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2289: ELSIF X_column_name = 'AVAILABLE_BALANCE' THEN
2290: IF l_DEBUG in ('Y', 'C') THEN
2291: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2292: END IF;
2293: G_cashflow_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2294: ELSIF X_column_name = 'VALUE_DATED_BALANCE' THEN
2295: IF l_DEBUG in ('Y', 'C') THEN
2296: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2297: END IF;

Line 2298: G_int_calc_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2294: ELSIF X_column_name = 'VALUE_DATED_BALANCE' THEN
2295: IF l_DEBUG in ('Y', 'C') THEN
2296: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2297: END IF;
2298: G_int_calc_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2299: ELSIF X_column_name = 'ONE_DAY_FLOAT' THEN
2300: IF l_DEBUG in ('Y', 'C') THEN
2301: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2302: END IF;

Line 2303: G_one_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2299: ELSIF X_column_name = 'ONE_DAY_FLOAT' THEN
2300: IF l_DEBUG in ('Y', 'C') THEN
2301: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2302: END IF;
2303: G_one_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2304: ELSIF X_column_name = 'TWO_DAY_FLOAT' THEN
2305: IF l_DEBUG in ('Y', 'C') THEN
2306: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2307: END IF;

Line 2308: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2304: ELSIF X_column_name = 'TWO_DAY_FLOAT' THEN
2305: IF l_DEBUG in ('Y', 'C') THEN
2306: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2307: END IF;
2308: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2309: ELSIF X_column_name = 'CONTROL_TOTAL_DR' THEN
2310: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2311: ELSIF X_column_name = 'CONTROL_TOTAL_CR' THEN
2312: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

Line 2310: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2306: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2307: END IF;
2308: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2309: ELSIF X_column_name = 'CONTROL_TOTAL_DR' THEN
2310: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2311: ELSIF X_column_name = 'CONTROL_TOTAL_CR' THEN
2312: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2313: ELSIF X_column_name = 'CONTROL_DR_LINE_COUNT' THEN
2314: G_control_dr_line_count := to_number(Lookup_Val('H', X_rec_no, X_column_name));

Line 2312: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

2308: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2309: ELSIF X_column_name = 'CONTROL_TOTAL_DR' THEN
2310: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2311: ELSIF X_column_name = 'CONTROL_TOTAL_CR' THEN
2312: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2313: ELSIF X_column_name = 'CONTROL_DR_LINE_COUNT' THEN
2314: G_control_dr_line_count := to_number(Lookup_Val('H', X_rec_no, X_column_name));
2315: ELSIF X_column_name = 'CONTROL_CR_LINE_COUNT' THEN
2316: G_control_cr_line_count := to_number(Lookup_Val('H', X_rec_no, X_column_name));

Line 2380: G_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;

2376: G_trx_text := Lookup_Val('L', X_rec_no, X_column_name);
2377: ELSIF X_column_name = 'INVOICE_TEXT' THEN
2378: G_invoice_text := Lookup_Val('L', X_rec_no, X_column_name);
2379: ELSIF X_column_name = 'AMOUNT' THEN
2380: G_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2381: ELSIF X_column_name = 'CURRENCY_CODE' THEN
2382: G_line_currency_code := Lookup_Val('L', X_rec_no, X_column_name);
2383: ELSIF X_column_name = 'EXCHANGE_RATE' THEN
2384: G_exchange_rate := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name));

Line 2384: G_exchange_rate := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name));

2380: G_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2381: ELSIF X_column_name = 'CURRENCY_CODE' THEN
2382: G_line_currency_code := Lookup_Val('L', X_rec_no, X_column_name);
2383: ELSIF X_column_name = 'EXCHANGE_RATE' THEN
2384: G_exchange_rate := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name));
2385: ELSIF X_column_name = 'BANK_TRX_NUMBER' THEN
2386: G_bank_trx_number := Lookup_Val('L', X_rec_no, X_column_name);
2387: ELSIF X_column_name = 'CUSTOMER_TEXT' THEN
2388: G_customer_text := Lookup_Val('L', X_rec_no, X_column_name);

Line 2394: G_original_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;

2390: G_user_exchange_rate_type := Lookup_Val('L', X_rec_no, X_column_name);
2391: ELSIF X_column_name = 'EXCHANGE_RATE_DATE' THEN
2392: G_exchange_rate_date := CONV_TO_DATE(Lookup_Val('L', X_rec_no, X_column_name));
2393: ELSIF X_column_name = 'ORIGINAL_AMOUNT' THEN
2394: G_original_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2395: ELSIF X_column_name = 'CHARGES_AMOUNT' THEN
2396: G_charges_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2397: ELSIF X_column_name = 'BANK_ACCOUNT_TEXT' THEN
2398: G_bank_account_text := Lookup_Val('L', X_rec_no, X_column_name);

Line 2396: G_charges_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;

2392: G_exchange_rate_date := CONV_TO_DATE(Lookup_Val('L', X_rec_no, X_column_name));
2393: ELSIF X_column_name = 'ORIGINAL_AMOUNT' THEN
2394: G_original_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2395: ELSIF X_column_name = 'CHARGES_AMOUNT' THEN
2396: G_charges_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name)) / G_line_precision;
2397: ELSIF X_column_name = 'BANK_ACCOUNT_TEXT' THEN
2398: G_bank_account_text := Lookup_Val('L', X_rec_no, X_column_name);
2399: END IF;
2400: IF l_DEBUG in ('Y', 'C') THEN