APPS.XLA_TB_BALANCE_PKG dependencies on GL_LEDGERS

Line 298: FROM gl_ledgers gl

294: --
295:
296: SELECT COUNT(1)
297: INTO l_db_cnt
298: FROM gl_ledgers gl
299: WHERE gl.ledger_id = p_ledger_id;
300:
301: IF l_db_cnt = 1 THEN
302:

Line 487: ,gl_ledgers gld

483: FROM xla_tb_balances_gt
484: WHERE code_combination_id NOT IN
485: (SELECT code_combination_id
486: FROM gl_code_combinations gcc
487: ,gl_ledgers gld
488: WHERE gcc.chart_of_accounts_id = gld.chart_of_accounts_id
489: AND gld.ledger_id = p_definition_rec.ledger_id);
490:
491: IF t_array_ccid.COUNT = 0 THEN

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

1362:
1363: --============================================================================
1364: --
1365: -- Private Procedures
1366: -- The procedure inserts a row into the xla_gl_ledgers table
1367: -- to store default values for ledger attributes related to the Trial Balance.
1368: --============================================================================
1369:
1370: PROCEDURE create_ledger

Line 1376: l_ledger_id gl_ledgers.ledger_id%TYPE;

1372: ) IS
1373:
1374: l_log_module VARCHAR2(240);
1375: l_api_name CONSTANT VARCHAR2(30) := 'create_ledger';
1376: l_ledger_id gl_ledgers.ledger_id%TYPE;
1377: BEGIN
1378:
1379: IF g_log_enabled THEN
1380: l_log_module := C_DEFAULT_MODULE||'.create_ledger';

Line 1395: FROM xla_gl_ledgers

1391:
1392: BEGIN
1393: SELECT ledger_id
1394: INTO l_ledger_id
1395: FROM xla_gl_ledgers
1396: WHERE ledger_id = p_ledger_id;
1397: EXCEPTION
1398: WHEN NO_DATA_FOUND THEN
1399: INSERT INTO xla_gl_ledgers

Line 1399: INSERT INTO xla_gl_ledgers

1395: FROM xla_gl_ledgers
1396: WHERE ledger_id = p_ledger_id;
1397: EXCEPTION
1398: WHEN NO_DATA_FOUND THEN
1399: INSERT INTO xla_gl_ledgers
1400: ( LEDGER_ID
1401: ,OBJECT_VERSION_NUMBER
1402: ,WORK_UNIT
1403: ,NUM_OF_WORKERS

Line 2448: INSERT INTO xla_gl_ledgers

2444: ,p_level => C_LEVEL_STATEMENT
2445: ,p_module => l_log_module);
2446: END IF;
2447:
2448: INSERT INTO xla_gl_ledgers
2449: ( LEDGER_ID
2450: ,OBJECT_VERSION_NUMBER
2451: ,WORK_UNIT
2452: ,NUM_OF_WORKERS

Line 2472: FROM XLA_GL_LEDGERS

2468: ,xla_environment_pkg.g_login_id
2469: FROM xla_tb_balances_gt xtb
2470: WHERE NOT EXISTS
2471: (SELECT 1
2472: FROM XLA_GL_LEDGERS
2473: WHERE ledger_id = xtb.ledger_id);
2474:
2475: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2476: trace

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

2473: WHERE ledger_id = xtb.ledger_id);
2474:
2475: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2476: trace
2477: (p_msg => 'inserted ledger info into the xla_gl_ledgers:'|| SQL%ROWCOUNT
2478: ,p_level => C_LEVEL_STATEMENT
2479: ,p_module => l_log_module);
2480: END IF;
2481: