DBA Data[Home] [Help]

APPS.XLA_TB_BALANCE_PKG dependencies on XLA_GL_LEDGERS

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 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: