APPS.AP_IMPORT_VALIDATION_PKG dependencies on FND_CURRENCIES

Line 2791: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

2787: l_start_date_active DATE;
2788: l_end_date_active DATE;
2789: current_calling_sequence VARCHAR2(2000);
2790: debug_info VARCHAR2(500);
2791: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2792: l_precision_inv_curr fnd_currencies.precision%TYPE;
2793: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2794:
2795: l_valid_inv_currency fnd_currencies.currency_code%TYPE;

Line 2792: l_precision_inv_curr fnd_currencies.precision%TYPE;

2788: l_end_date_active DATE;
2789: current_calling_sequence VARCHAR2(2000);
2790: debug_info VARCHAR2(500);
2791: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2792: l_precision_inv_curr fnd_currencies.precision%TYPE;
2793: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2794:
2795: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2796:

Line 2793: l_enabled_flag fnd_currencies.enabled_flag%TYPE;

2789: current_calling_sequence VARCHAR2(2000);
2790: debug_info VARCHAR2(500);
2791: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2792: l_precision_inv_curr fnd_currencies.precision%TYPE;
2793: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2794:
2795: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2796:
2797: BEGIN

Line 2795: l_valid_inv_currency fnd_currencies.currency_code%TYPE;

2791: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
2792: l_precision_inv_curr fnd_currencies.precision%TYPE;
2793: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
2794:
2795: l_valid_inv_currency fnd_currencies.currency_code%TYPE;
2796:
2797: BEGIN
2798: -- Update the calling sequence
2799: --

Line 2854: FROM fnd_currencies

2850: /*SELECT start_date_active, end_date_active,
2851: minimum_accountable_unit, precision, enabled_flag
2852: INTO l_start_date_active, l_end_date_active,
2853: l_min_acc_unit_inv_curr,l_precision_inv_curr, l_enabled_flag
2854: FROM fnd_currencies
2855: WHERE currency_code = p_inv_currency_code; */
2856:
2857: -- Bug 5448579
2858: FOR i IN AP_IMPORT_INVOICES_PKG.g_fnd_currency_tab.First..AP_IMPORT_INVOICES_PKG.g_fnd_currency_tab.Last

Line 5580: l_valid_pay_currency FND_CURRENCIES.Currency_Code%TYPE;

5576: current_calling_sequence VARCHAR2(2000);
5577: debug_info VARCHAR2(500);
5578:
5579: l_fnd_currency_table AP_IMPORT_INVOICES_PKG.Fnd_Currency_Tab_Type;
5580: l_valid_pay_currency FND_CURRENCIES.Currency_Code%TYPE;
5581:
5582: BEGIN
5583: --
5584: -- Update the calling sequence

Line 5615: FROM fnd_currencies

5611: -------------------------------------------------------------------------
5612:
5613: /*SELECT start_date_active, end_date_active
5614: INTO l_start_date_active, l_end_date_active
5615: FROM fnd_currencies
5616: WHERE currency_code = p_invoice_rec.payment_currency_code; */
5617:
5618: -- Bug 5448579
5619: FOR i IN l_fnd_currency_table.First..l_fnd_currency_table.Last LOOP