[Home] [Help]
430: END IF;
431:
432: SELECT COUNT(1)
433: INTO l_db_cnt
434: FROM xla_tb_balances_gt
435: WHERE definition_code = p_definition_rec.definition_code;
436:
437: IF l_db_cnt = 0 THEN
438:
467: --
468: SELECT code_combination_id
469: BULK COLLECT
470: INTO t_array_ccid
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
1050: ,l_created_by
1051: ,l_last_update_date
1052: ,l_last_updated_by
1053: ,l_last_update_login
1054: FROM xla_tb_balances_gt
1055: WHERE definition_code = p_definition_code;
1056:
1057: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1058: trace
1293: MERGE INTO xla_tb_defn_details dt
1294: USING (SELECT code_combination_id
1295: ,balance_date
1296: ,balance_amount
1297: FROM xla_tb_balances_gt
1298: WHERE definition_code = p_definition_code) gt
1299:
1300: ON (dt.code_combination_id = gt.code_combination_id)
1301:
2347: p_owner => 'XLA',
2348: p_event_name => 'XLA_AP_TRIAL_UPG_DEFN'))) THEN
2349: SELECT DISTINCT definition_code, ledger_id
2350: BULK COLLECT INTO l_array_defn_code, l_array_ledger_id
2351: FROM xla_tb_balances_gt tb
2352: WHERE definition_code NOT IN
2353: (
2354: SELECT definition_code
2355: FROM xla_tb_definitions_b
2452: ,xla_environment_pkg.g_usr_id
2453: ,SYSDATE
2454: ,xla_environment_pkg.g_usr_id
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);
2491: ,xla_environment_pkg.g_login_Id
2492: ,l.language_code
2493: ,userenv('LANG')
2494: FROM fnd_languages l
2495: ,xla_tb_balances_gt tb
2496: WHERE l.installed_flag in ('I', 'B')
2497: AND NOT EXISTS
2498: (SELECT 1
2499: FROM xla_tb_definitions_tl t
2706: ,gcc.segment27
2707: ,gcc.segment28
2708: ,gcc.segment29
2709: ,gcc.segment30
2710: FROM xla_tb_balances_gt tdd
2711: ,gl_code_combinations gcc
2712: WHERE gcc.code_combination_id = tdd.code_combination_id;
2713:
2714: