42:
43:
44: TYPE r_definition IS RECORD
45: (definition_code xla_tb_definitions_b.definition_code%TYPE
46: ,name xla_tb_definitions_tl.name%TYPE
47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
48: ,description xla_tb_definitions_tl.description%TYPE
49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
50:
44: TYPE r_definition IS RECORD
45: (definition_code xla_tb_definitions_b.definition_code%TYPE
46: ,name xla_tb_definitions_tl.name%TYPE
47: ,ledger_id xla_tb_definitions_b.ledger_id%TYPE
48: ,description xla_tb_definitions_tl.description%TYPE
49: ,balance_side_code xla_tb_definitions_b.balance_side_code%TYPE);
50:
51:
52: --
2479: ,p_module => l_log_module);
2480: END IF;
2481:
2482:
2483: INSERT INTO xla_tb_definitions_tl
2484: (
2485: definition_code
2486: ,name
2487: ,description
2508: ,xla_tb_balances_gt tb
2509: WHERE l.installed_flag in ('I', 'B')
2510: AND NOT EXISTS
2511: (SELECT 1
2512: FROM xla_tb_definitions_tl t
2513: WHERE t.definition_code = tb.definition_code
2514: AND t.language = l.language_code);
2515:
2516: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2514: AND t.language = l.language_code);
2515:
2516: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2517: trace
2518: (p_msg => 'inserted definition into the xla_tb_definitions_tl:'|| SQL%ROWCOUNT
2519: ,p_level => C_LEVEL_STATEMENT
2520: ,p_module => l_log_module);
2521: END IF;
2522: