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 GL_SETS_OF_BOOKS

Line 165: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

161: l_last_org_id NUMBER;
162: l_debug_flag VARCHAR2(1);
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;

Line 166: l_functional_currency gl_sets_of_books.currency_code%type;

162: l_debug_flag VARCHAR2(1);
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;

Line 170: l_sob_test gl_sets_of_books.set_of_books_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:
173: type l_ar_sys_rec is record(
174: DEFAULT_GROUPING_RULE_ID AR_SYSTEM_PARAMETERS_ALL.DEFAULT_GROUPING_RULE_ID%TYPE,

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 965: begin -- Test 1: Check row exists in gl sets of books

961:
962: EXCEPTION
963: WHEN NO_DATA_FOUND THEN
964: -- test for reasons why failure occured
965: begin -- Test 1: Check row exists in gl sets of books
966: select sob.set_of_books_id
967: into l_sob_test
968: from gl_sets_of_books sob
969: where sob.set_of_books_id = sysinfo.sysparam.set_of_books_id;

Line 968: from gl_sets_of_books sob

964: -- test for reasons why failure occured
965: begin -- Test 1: Check row exists in gl sets of books
966: select sob.set_of_books_id
967: into l_sob_test
968: from gl_sets_of_books sob
969: where sob.set_of_books_id = sysinfo.sysparam.set_of_books_id;
970: exception when no_data_found then
971: IF (g_level_statement >= g_current_runtime_level) THEN
972: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );