APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 142: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

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

Line 143: l_functional_currency gl_sets_of_books.currency_code%type;

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

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

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

924:
925: EXCEPTION
926: WHEN NO_DATA_FOUND THEN
927: -- test for reasons why failure occured
928: begin -- Test 1: Check row exists in gl sets of books
929: select sob.set_of_books_id
930: into l_sob_test
931: from gl_sets_of_books sob
932: where sob.set_of_books_id = sysinfo.sysparam.set_of_books_id;

Line 931: from gl_sets_of_books sob

927: -- test for reasons why failure occured
928: begin -- Test 1: Check row exists in gl sets of books
929: select sob.set_of_books_id
930: into l_sob_test
931: from gl_sets_of_books sob
932: where sob.set_of_books_id = sysinfo.sysparam.set_of_books_id;
933: exception when no_data_found then
934: IF (g_level_statement >= g_current_runtime_level) THEN
935: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','EXCEPTION: NO_DATA_FOUND IN SET OF BOOKS ' );