APPS.AP_IMPORT_VALIDATION_PKG dependencies on FND_CURRENCIES

Line 2933: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

2929: l_start_date_active DATE;
2930: l_end_date_active DATE;
2931: current_calling_sequence VARCHAR2(2000);
2932: debug_info VARCHAR2(500);
2933: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2934: l_precision_inv_curr fnd_currencies.precision%TYPE;
2935: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2936:
2937: l_valid_inv_currency fnd_currencies.currency_code%TYPE;

Line 2934: l_precision_inv_curr fnd_currencies.precision%TYPE;

2930: l_end_date_active DATE;
2931: current_calling_sequence VARCHAR2(2000);
2932: debug_info VARCHAR2(500);
2933: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2934: l_precision_inv_curr fnd_currencies.precision%TYPE;
2935: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2936:
2937: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2938:

Line 2935: l_enabled_flag fnd_currencies.enabled_flag%TYPE;

2931: current_calling_sequence VARCHAR2(2000);
2932: debug_info VARCHAR2(500);
2933: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2934: l_precision_inv_curr fnd_currencies.precision%TYPE;
2935: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2936:
2937: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2938:
2939: BEGIN

Line 2937: l_valid_inv_currency fnd_currencies.currency_code%TYPE;

2933: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2934: l_precision_inv_curr fnd_currencies.precision%TYPE;
2935: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2936:
2937: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2938:
2939: BEGIN
2940: -- Update the calling sequence
2941: --

Line 3018: FROM fnd_currencies

3014: /*SELECT start_date_active, end_date_active,
3015: minimum_accountable_unit, precision, enabled_flag
3016: INTO l_start_date_active, l_end_date_active,
3017: l_min_acc_unit_inv_curr,l_precision_inv_curr, l_enabled_flag
3018: FROM fnd_currencies
3019: WHERE currency_code = p_inv_currency_code; */
3020:
3021: -- Bug 5448579
3022: FOR i IN AP_IMPORT_INVOICES_PKG.g_fnd_currency_tab.First..AP_IMPORT_INVOICES_PKG.g_fnd_currency_tab.Last

Line 6018: l_valid_pay_currency FND_CURRENCIES.Currency_Code%TYPE;

6014: current_calling_sequence VARCHAR2(2000);
6015: debug_info VARCHAR2(500);
6016:
6017: l_fnd_currency_table AP_IMPORT_INVOICES_PKG.Fnd_Currency_Tab_Type;
6018: l_valid_pay_currency FND_CURRENCIES.Currency_Code%TYPE;
6019:
6020: BEGIN
6021: --
6022: -- Update the calling sequence

Line 6053: FROM fnd_currencies

6049: -------------------------------------------------------------------------
6050:
6051: /*SELECT start_date_active, end_date_active
6052: INTO l_start_date_active, l_end_date_active
6053: FROM fnd_currencies
6054: WHERE currency_code = p_invoice_rec.payment_currency_code; */
6055:
6056: -- Bug 5448579
6057: FOR i IN l_fnd_currency_table.First..l_fnd_currency_table.Last LOOP