APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_RECREATE_GT

Line 8749: INTO xla_bal_recreate_gt

8745: END IF;
8746:
8747: l_temp_population_dyn_stmt :=
8748: ' INSERT
8749: INTO xla_bal_recreate_gt
8750: ( application_id
8751: ,ledger_id
8752: ,code_combination_id
8753: ,balance_source_code

Line 8761: ,xla_bal_recreate_gt xbt

8757: ,xbs.code_combination_id
8758: ,xbs.balance_source_code
8759: FROM xla_balance_statuses xbs
8760: ,gl_code_combinations gcc
8761: ,xla_bal_recreate_gt xbt
8762: WHERE gcc.code_combination_id = xbs.code_combination_id
8763: AND xbt.application_id (+)= xbs.application_id
8764: AND xbt.ledger_id (+)= xbs.ledger_id
8765: AND xbt.code_combination_id (+)= xbs.code_combination_id

Line 8801: || ' records inserted in xla_bal_recreate_gt'

8797: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8798: trace
8799: (p_module => l_log_module
8800: ,p_msg => l_row_count
8801: || ' records inserted in xla_bal_recreate_gt'
8802: ,p_level => C_LEVEL_STATEMENT
8803: );
8804: END IF;
8805:

Line 8868: FROM xla_bal_recreate_gt xbt

8864: ,xbsext.program_id = l_prog_id
8865: ,xbsext.request_id = NVL(l_req_id, -1)
8866: WHERE xbsext.ROWID IN
8867: (SELECT xbs.ROWID
8868: FROM xla_bal_recreate_gt xbt
8869: ,xla_balance_statuses xbs
8870: ,fnd_concurrent_requests fnd
8871: WHERE xbs.application_id = xbt.application_id
8872: AND xbs.ledger_id = xbt.ledger_id

Line 8922: FROM xla_bal_recreate_gt xbt

8918: END LOOP;
8919:
8920: SELECT count(*)
8921: INTO l_count_unavailable
8922: FROM xla_bal_recreate_gt xbt
8923: ,xla_balance_statuses xbs
8924: WHERE xbs.application_id = xbt.application_id
8925: AND xbs.ledger_id = xbt.ledger_id
8926: AND xbs.code_combination_id = xbt.code_combination_id

Line 9246: FROM xla_bal_recreate_gt;

9242:
9243: LOOP
9244:
9245: DELETE
9246: FROM xla_bal_recreate_gt;
9247:
9248: l_row_count := SQL%ROWCOUNT;
9249:
9250: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

9249:
9250: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9251: trace
9252: (p_module => l_log_module
9253: ,p_msg => l_row_count || ' xla_bal_recreate_gt deleted.'
9254: ,p_level => C_LEVEL_STATEMENT
9255: );
9256: END IF;
9257:

Line 9708: FROM xla_bal_recreate_gt xbt

9704: (
9705: SELECT xbt.application_id
9706: ,xbt.ledger_id
9707: ,xbt.code_combination_id
9708: FROM xla_bal_recreate_gt xbt
9709: );
9710:
9711: IF l_count_unavailable > 0
9712: THEN