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.ZX_PRODUCT_INTEGRATION_PKG dependencies on FND_CURRENCIES

Line 144: l_base_precision fnd_currencies.precision%type;

140: l_security_profile_id FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE := NULL;
141:
142: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
143: l_functional_currency gl_sets_of_books.currency_code%type;
144: l_base_precision fnd_currencies.precision%type;
145: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
146: l_master_org_id oe_system_parameters_all.master_organization_id%type;
147: l_sob_test gl_sets_of_books.set_of_books_id%type;
148: -- bug fix 3142794 l_last_org_id ar_system_parameters_all.org_id%type;

Line 145: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

141:
142: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
143: l_functional_currency gl_sets_of_books.currency_code%type;
144: l_base_precision fnd_currencies.precision%type;
145: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
146: l_master_org_id oe_system_parameters_all.master_organization_id%type;
147: l_sob_test gl_sets_of_books.set_of_books_id%type;
148: -- bug fix 3142794 l_last_org_id ar_system_parameters_all.org_id%type;
149:

Line 921: FROM gl_sets_of_books sob, fnd_currencies c

917: INTO l_chart_of_accounts_id,
918: l_functional_currency,
919: l_base_precision,
920: l_base_min_acc_unit
921: FROM gl_sets_of_books sob, fnd_currencies c
922: WHERE sob.set_of_books_id = sysinfo.sysparam.set_of_books_id
923: AND sob.currency_code = c.currency_code;
924:
925: EXCEPTION

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

942: -- Test 1 passed therefore currency must not be defined
943: IF (g_level_statement >= g_current_runtime_level) THEN
944: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN CURRENCIES ' );
945: END IF;
946: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
947: APP_EXCEPTION.raise_exception;
948: RAISE; --end of WHEN NO DATA FOUND
949: END;
950:

Line 2171: l_old_foreign_currency_code fnd_currencies.currency_code%type;

2167: l_new_extended_amount NUMBER;
2168: l_new_unit_selling_price NUMBER;
2169: l_tax_incl_amount_this_line NUMBER;
2170: l_incl_amount_this_group NUMBER;
2171: l_old_foreign_currency_code fnd_currencies.currency_code%type;
2172: l_old_exchange_rate NUMBER;
2173:
2174: /* BugFix 645089: Added following 4 lines */
2175: l_ct_id Number;

Line 2962: l_precision fnd_currencies.precision%TYPE;

2958: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
2959: l_use_tax_vendor BOOLEAN;
2960: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
2961: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
2962: l_precision fnd_currencies.precision%TYPE;
2963: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
2964:
2965: CURSOR get_vat_tax_id(c_sob_id NUMBER,
2966: c_tax_code VARCHAR2,

Line 2963: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

2959: l_use_tax_vendor BOOLEAN;
2960: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
2961: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
2962: l_precision fnd_currencies.precision%TYPE;
2963: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
2964:
2965: CURSOR get_vat_tax_id(c_sob_id NUMBER,
2966: c_tax_code VARCHAR2,
2967: c_trx_date DATE,