DBA Data[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on FND_CURRENCIES

Line 167: l_base_precision fnd_currencies.precision%type;

163: l_security_profile_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE := NULL;
164:
165: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
166: l_functional_currency gl_sets_of_books.currency_code%type;
167: l_base_precision fnd_currencies.precision%type;
168: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
169: l_master_org_id oe_system_parameters_all.master_organization_id%type;
170: l_sob_test gl_sets_of_books.set_of_books_id%type;
171: -- bug fix 3142794 l_last_org_id ar_system_parameters_all.org_id%type;

Line 168: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

164:
165: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
166: l_functional_currency gl_sets_of_books.currency_code%type;
167: l_base_precision fnd_currencies.precision%type;
168: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
169: l_master_org_id oe_system_parameters_all.master_organization_id%type;
170: l_sob_test gl_sets_of_books.set_of_books_id%type;
171: -- bug fix 3142794 l_last_org_id ar_system_parameters_all.org_id%type;
172:

Line 958: FROM gl_sets_of_books sob, fnd_currencies c

954: INTO l_chart_of_accounts_id,
955: l_functional_currency,
956: l_base_precision,
957: l_base_min_acc_unit
958: FROM gl_sets_of_books sob, fnd_currencies c
959: WHERE sob.set_of_books_id = sysinfo.sysparam.set_of_books_id
960: AND sob.currency_code = c.currency_code;
961:
962: EXCEPTION

Line 983: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');

979: -- Test 1 passed therefore currency must not be defined
980: IF (g_level_statement >= g_current_runtime_level) THEN
981: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
982: END IF;
983: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
984: APP_EXCEPTION.raise_exception;
985: RAISE; --end of WHEN NO DATA FOUND
986: END;
987:

Line 2490: l_old_foreign_currency_code fnd_currencies.currency_code%type;

2486: l_new_extended_amount NUMBER;
2487: l_new_unit_selling_price NUMBER;
2488: l_tax_incl_amount_this_line NUMBER;
2489: l_incl_amount_this_group NUMBER;
2490: l_old_foreign_currency_code fnd_currencies.currency_code%type;
2491: l_old_exchange_rate NUMBER;
2492:
2493: /* BugFix 645089: Added following 4 lines */
2494: l_ct_id Number;

Line 3280: l_precision fnd_currencies.precision%TYPE;

3276: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
3277: l_use_tax_vendor BOOLEAN;
3278: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
3279: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3280: l_precision fnd_currencies.precision%TYPE;
3281: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3282:
3283: CURSOR get_vat_tax_id(c_sob_id NUMBER,
3284: c_tax_code VARCHAR2,

Line 3281: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

3277: l_use_tax_vendor BOOLEAN;
3278: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
3279: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3280: l_precision fnd_currencies.precision%TYPE;
3281: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3282:
3283: CURSOR get_vat_tax_id(c_sob_id NUMBER,
3284: c_tax_code VARCHAR2,
3285: c_trx_date DATE,