APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_RECREATE_GT

Line 8570: INTO xla_bal_recreate_gt

8566: END IF;
8567:
8568: l_temp_population_dyn_stmt :=
8569: ' INSERT
8570: INTO xla_bal_recreate_gt
8571: ( application_id
8572: ,ledger_id
8573: ,code_combination_id
8574: ,balance_source_code

Line 8582: ,xla_bal_recreate_gt xbt

8578: ,xbs.code_combination_id
8579: ,xbs.balance_source_code
8580: FROM xla_balance_statuses xbs
8581: ,gl_code_combinations gcc
8582: ,xla_bal_recreate_gt xbt
8583: WHERE gcc.code_combination_id = xbs.code_combination_id
8584: AND xbt.application_id (+)= xbs.application_id
8585: AND xbt.ledger_id (+)= xbs.ledger_id
8586: AND xbt.code_combination_id (+)= xbs.code_combination_id

Line 8622: || ' records inserted in xla_bal_recreate_gt'

8618: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8619: trace
8620: (p_module => l_log_module
8621: ,p_msg => l_row_count
8622: || ' records inserted in xla_bal_recreate_gt'
8623: ,p_level => C_LEVEL_STATEMENT
8624: );
8625: END IF;
8626:

Line 8689: FROM xla_bal_recreate_gt xbt

8685: ,xbsext.program_id = l_prog_id
8686: ,xbsext.request_id = NVL(l_req_id, -1)
8687: WHERE xbsext.ROWID IN
8688: (SELECT xbs.ROWID
8689: FROM xla_bal_recreate_gt xbt
8690: ,xla_balance_statuses xbs
8691: ,fnd_concurrent_requests fnd
8692: WHERE xbs.application_id = xbt.application_id
8693: AND xbs.ledger_id = xbt.ledger_id

Line 8743: FROM xla_bal_recreate_gt xbt

8739: END LOOP;
8740:
8741: SELECT count(*)
8742: INTO l_count_unavailable
8743: FROM xla_bal_recreate_gt xbt
8744: ,xla_balance_statuses xbs
8745: WHERE xbs.application_id = xbt.application_id
8746: AND xbs.ledger_id = xbt.ledger_id
8747: AND xbs.code_combination_id = xbt.code_combination_id

Line 9067: FROM xla_bal_recreate_gt;

9063:
9064: LOOP
9065:
9066: DELETE
9067: FROM xla_bal_recreate_gt;
9068:
9069: l_row_count := SQL%ROWCOUNT;
9070:
9071: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 9074: ,p_msg => l_row_count || ' xla_bal_recreate_gt deleted.'

9070:
9071: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9072: trace
9073: (p_module => l_log_module
9074: ,p_msg => l_row_count || ' xla_bal_recreate_gt deleted.'
9075: ,p_level => C_LEVEL_STATEMENT
9076: );
9077: END IF;
9078:

Line 9526: FROM xla_bal_recreate_gt xbt

9522: (
9523: SELECT xbt.application_id
9524: ,xbt.ledger_id
9525: ,xbt.code_combination_id
9526: FROM xla_bal_recreate_gt xbt
9527: );
9528:
9529: IF l_count_unavailable > 0
9530: THEN