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 2723: G_control_begin_balance := fnd_number.canonical_to_number(covert_amt_edifact(Lookup_Val('H', X_rec_no, X_column_name)))/ G_hdr_precision;

2719: THEN
2720: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2721: -- EDifact ER To Handle Non Numeric Values at Balances
2722: IF( G_format_type='EDIFACT_FR') THEN
2723: G_control_begin_balance := fnd_number.canonical_to_number(covert_amt_edifact(Lookup_Val('H', X_rec_no, X_column_name)))/ G_hdr_precision;
2724: ELSE
2725: G_control_begin_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2726: END IF;
2727: cep_standard.debug('Decode_Hdr_Other: ' || 'G_control_begin_balance: ' || to_char(G_control_begin_balance));

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

2721: -- EDifact ER To Handle Non Numeric Values at Balances
2722: IF( G_format_type='EDIFACT_FR') THEN
2723: G_control_begin_balance := fnd_number.canonical_to_number(covert_amt_edifact(Lookup_Val('H', X_rec_no, X_column_name)))/ G_hdr_precision;
2724: ELSE
2725: G_control_begin_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2726: END IF;
2727: cep_standard.debug('Decode_Hdr_Other: ' || 'G_control_begin_balance: ' || to_char(G_control_begin_balance));
2728:
2729: ELSIF X_column_name = 'CONTROL_END_BALANCE'

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

2730: THEN
2731: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2732: -- EDifact ER To Handle Non Numeric Values at Balances
2733: IF( G_format_type='EDIFACT_FR') THEN
2734: G_control_end_balance := fnd_number.canonical_to_number(covert_amt_edifact(Lookup_Val('H', X_rec_no, X_column_name)))/ G_hdr_precision;
2735: ELSE
2736: G_control_end_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2737: END IF;
2738: cep_standard.debug('Decode_Hdr_Other: ' || 'G_control_end_balance: ' || to_char(G_control_end_balance));

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

2732: -- EDifact ER To Handle Non Numeric Values at Balances
2733: IF( G_format_type='EDIFACT_FR') THEN
2734: G_control_end_balance := fnd_number.canonical_to_number(covert_amt_edifact(Lookup_Val('H', X_rec_no, X_column_name)))/ G_hdr_precision;
2735: ELSE
2736: G_control_end_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2737: END IF;
2738: cep_standard.debug('Decode_Hdr_Other: ' || 'G_control_end_balance: ' || to_char(G_control_end_balance));
2739: ELSIF X_column_name = 'AVAILABLE_BALANCE'
2740: THEN

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

2738: cep_standard.debug('Decode_Hdr_Other: ' || 'G_control_end_balance: ' || to_char(G_control_end_balance));
2739: ELSIF X_column_name = 'AVAILABLE_BALANCE'
2740: THEN
2741: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2742: G_cashflow_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2743: ELSIF X_column_name = 'VALUE_DATED_BALANCE'
2744: THEN
2745: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2746: G_int_calc_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

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

2742: G_cashflow_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2743: ELSIF X_column_name = 'VALUE_DATED_BALANCE'
2744: THEN
2745: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2746: G_int_calc_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2747: ELSIF X_column_name = 'ONE_DAY_FLOAT'
2748: THEN
2749: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2750: G_one_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

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

2746: G_int_calc_balance := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2747: ELSIF X_column_name = 'ONE_DAY_FLOAT'
2748: THEN
2749: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2750: G_one_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2751: ELSIF X_column_name = 'TWO_DAY_FLOAT'
2752: THEN
2753: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2754: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;

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

2750: G_one_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2751: ELSIF X_column_name = 'TWO_DAY_FLOAT'
2752: THEN
2753: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2754: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2755: ELSIF X_column_name = 'CONTROL_TOTAL_DR'
2756: THEN
2757: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2758: ELSIF X_column_name = 'CONTROL_TOTAL_CR'

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

2753: cep_standard.debug('Decode_Hdr_Other: ' || 'G_hdr_precision: ' || to_char(G_hdr_precision));
2754: G_two_day_float := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2755: ELSIF X_column_name = 'CONTROL_TOTAL_DR'
2756: THEN
2757: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2758: ELSIF X_column_name = 'CONTROL_TOTAL_CR'
2759: THEN
2760: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2761: ELSIF X_column_name = 'CONTROL_DR_LINE_COUNT'

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

2756: THEN
2757: G_control_total_dr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2758: ELSIF X_column_name = 'CONTROL_TOTAL_CR'
2759: THEN
2760: G_control_total_cr := fnd_number.canonical_to_number(Lookup_Val('H', X_rec_no, X_column_name)) / G_hdr_precision;
2761: ELSIF X_column_name = 'CONTROL_DR_LINE_COUNT'
2762: THEN
2763: G_control_dr_line_count := to_number(Lookup_Val('H', X_rec_no, X_column_name));
2764: ELSIF X_column_name = 'CONTROL_CR_LINE_COUNT'

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

2840: END IF;
2841: ELSIF X_column_name = 'AMOUNT' THEN
2842: --Edifact ER To handle the Non Numeric characters at Edifact Line Amounts
2843: IF( G_format_type='EDIFACT_FR') THEN
2844: G_amount := fnd_number.canonical_to_number(Abs(covert_amt_edifact(Lookup_Val('L', X_rec_no, X_column_name))))/ G_line_precision;
2845: ELSE
2846: G_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name))/ G_line_precision;
2847: END IF;
2848: IF l_DEBUG in ('Y', 'C') THEN

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

2842: --Edifact ER To handle the Non Numeric characters at Edifact Line Amounts
2843: IF( G_format_type='EDIFACT_FR') THEN
2844: G_amount := fnd_number.canonical_to_number(Abs(covert_amt_edifact(Lookup_Val('L', X_rec_no, X_column_name))))/ G_line_precision;
2845: ELSE
2846: G_amount := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name))/ G_line_precision;
2847: END IF;
2848: IF l_DEBUG in ('Y', 'C') THEN
2849: cep_standard.debug('Decode_Line_Other: ' || 'G_amount: ' || to_char(G_amount));
2850: END IF;

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

2850: END IF;
2851: ELSIF X_column_name = 'CURRENCY_CODE' THEN
2852: G_line_currency_code := Lookup_Val('L', X_rec_no, X_column_name);
2853: ELSIF X_column_name = 'EXCHANGE_RATE' THEN
2854: G_exchange_rate := fnd_number.canonical_to_number(Lookup_Val('L', X_rec_no, X_column_name));
2855: ELSIF X_column_name = 'BANK_TRX_NUMBER' THEN
2856: G_bank_trx_number := Lookup_Val('L', X_rec_no, X_column_name);
2857: ELSIF X_column_name = 'CUSTOMER_TEXT' THEN
2858: G_customer_text := Lookup_Val('L', X_rec_no, X_column_name);

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

2861: ELSIF X_column_name = 'EXCHANGE_RATE_DATE' THEN
2862: G_exchange_rate_date := CONV_TO_DATE(Lookup_Val('L', X_rec_no, X_column_name));
2863: ELSIF X_column_name = 'ORIGINAL_AMOUNT' THEN
2864: /* Bug 12708348 replace is added for ORGINAL_AMOUNT AND CHARGES_AMOUNT */
2865: G_original_amount := fnd_number.canonical_to_number(REPLACE(Lookup_Val('L', X_rec_no, X_column_name),',','.')) / G_line_precision;
2866: ELSIF X_column_name = 'CHARGES_AMOUNT' THEN
2867: G_charges_amount := fnd_number.canonical_to_number(REPLACE(Lookup_Val('L', X_rec_no, X_column_name),',','.')) / G_line_precision;
2868: ELSIF X_column_name = 'BANK_ACCOUNT_TEXT' THEN
2869: G_bank_account_text := Lookup_Val('L', X_rec_no, X_column_name);

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

2863: ELSIF X_column_name = 'ORIGINAL_AMOUNT' THEN
2864: /* Bug 12708348 replace is added for ORGINAL_AMOUNT AND CHARGES_AMOUNT */
2865: G_original_amount := fnd_number.canonical_to_number(REPLACE(Lookup_Val('L', X_rec_no, X_column_name),',','.')) / G_line_precision;
2866: ELSIF X_column_name = 'CHARGES_AMOUNT' THEN
2867: G_charges_amount := fnd_number.canonical_to_number(REPLACE(Lookup_Val('L', X_rec_no, X_column_name),',','.')) / G_line_precision;
2868: ELSIF X_column_name = 'BANK_ACCOUNT_TEXT' THEN
2869: G_bank_account_text := Lookup_Val('L', X_rec_no, X_column_name);
2870: END IF;
2871: IF l_DEBUG in ('Y', 'C') THEN