APPS.XLA_TB_BALANCE_PKG dependencies on GL_LEDGERS

Line 286: FROM gl_ledgers gl

282: --
283:
284: SELECT COUNT(1)
285: INTO l_db_cnt
286: FROM gl_ledgers gl
287: WHERE gl.ledger_id = p_ledger_id;
288:
289: IF l_db_cnt = 1 THEN
290:

Line 475: ,gl_ledgers gld

471: FROM xla_tb_balances_gt
472: WHERE code_combination_id NOT IN
473: (SELECT code_combination_id
474: FROM gl_code_combinations gcc
475: ,gl_ledgers gld
476: WHERE gcc.chart_of_accounts_id = gld.chart_of_accounts_id
477: AND gld.ledger_id = p_definition_rec.ledger_id);
478:
479: IF t_array_ccid.COUNT = 0 THEN

Line 1354: -- The procedure inserts a row into the xla_gl_ledgers table

1350:
1351: --============================================================================
1352: --
1353: -- Private Procedures
1354: -- The procedure inserts a row into the xla_gl_ledgers table
1355: -- to store default values for ledger attributes related to the Trial Balance.
1356: --============================================================================
1357:
1358: PROCEDURE create_ledger

Line 1364: l_ledger_id gl_ledgers.ledger_id%TYPE;

1360: ) IS
1361:
1362: l_log_module VARCHAR2(240);
1363: l_api_name CONSTANT VARCHAR2(30) := 'create_ledger';
1364: l_ledger_id gl_ledgers.ledger_id%TYPE;
1365: BEGIN
1366:
1367: IF g_log_enabled THEN
1368: l_log_module := C_DEFAULT_MODULE||'.create_ledger';

Line 1383: FROM xla_gl_ledgers

1379:
1380: BEGIN
1381: SELECT ledger_id
1382: INTO l_ledger_id
1383: FROM xla_gl_ledgers
1384: WHERE ledger_id = p_ledger_id;
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: INSERT INTO xla_gl_ledgers

Line 1387: INSERT INTO xla_gl_ledgers

1383: FROM xla_gl_ledgers
1384: WHERE ledger_id = p_ledger_id;
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: INSERT INTO xla_gl_ledgers
1388: ( LEDGER_ID
1389: ,OBJECT_VERSION_NUMBER
1390: ,WORK_UNIT
1391: ,NUM_OF_WORKERS

Line 2435: INSERT INTO xla_gl_ledgers

2431: ,p_level => C_LEVEL_STATEMENT
2432: ,p_module => l_log_module);
2433: END IF;
2434:
2435: INSERT INTO xla_gl_ledgers
2436: ( LEDGER_ID
2437: ,OBJECT_VERSION_NUMBER
2438: ,WORK_UNIT
2439: ,NUM_OF_WORKERS

Line 2459: FROM XLA_GL_LEDGERS

2455: ,xla_environment_pkg.g_login_id
2456: FROM xla_tb_balances_gt xtb
2457: WHERE NOT EXISTS
2458: (SELECT 1
2459: FROM XLA_GL_LEDGERS
2460: WHERE ledger_id = xtb.ledger_id);
2461:
2462: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2463: trace

Line 2464: (p_msg => 'inserted ledger info into the xla_gl_ledgers:'|| SQL%ROWCOUNT

2460: WHERE ledger_id = xtb.ledger_id);
2461:
2462: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2463: trace
2464: (p_msg => 'inserted ledger info into the xla_gl_ledgers:'|| SQL%ROWCOUNT
2465: ,p_level => C_LEVEL_STATEMENT
2466: ,p_module => l_log_module);
2467: END IF;
2468: