APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_STATUSES_GT

Line 1389: INSERT INTO xla_bal_statuses_gt

1385: );
1386: END IF;
1387:
1388: --Create the missing records in xla_balance_statuses, if any.
1389: INSERT INTO xla_bal_statuses_gt
1390: ( application_id
1391: ,ledger_id
1392: ,code_combination_id
1393: ,balance_source_code

Line 1447: ' records inserted in xla_bal_statuses_gt'

1443: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1444: trace
1445: (p_module => l_log_module
1446: ,p_msg => l_row_count ||
1447: ' records inserted in xla_bal_statuses_gt'
1448: ,p_level => C_LEVEL_STATEMENT
1449: );
1450: END IF;
1451:

Line 1455: FROM xla_bal_statuses_gt xbs

1451:
1452: FOR i IN (
1453: SELECT DISTINCT
1454: ledger_id
1455: FROM xla_bal_statuses_gt xbs
1456: )
1457: LOOP
1458:
1459: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1543: UPDATE xla_bal_statuses_gt xbst

1539: END IF;
1540:
1541: EXECUTE IMMEDIATE
1542: '
1543: UPDATE xla_bal_statuses_gt xbst
1544: SET xbst.effective_period_num = ' ||l_latest_open_eff_period_num || '
1545: ,(
1546: xbst.natural_account_segment
1547: ,xbst.balancing_segment

Line 1565: ' records updated in xla_bal_statuses_gt'

1561: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1562: trace
1563: (p_module => l_log_module
1564: ,p_msg => l_row_count ||
1565: ' records updated in xla_bal_statuses_gt'
1566: ,p_level => C_LEVEL_STATEMENT
1567: );
1568: END IF;
1569:

Line 1610: FROM xla_bal_statuses_gt xbst;

1606: ,l_date
1607: ,l_prog_appl_id
1608: ,l_prog_id
1609: ,NVL(l_req_id, -1)
1610: FROM xla_bal_statuses_gt xbst;
1611:
1612: l_row_count := SQL%ROWCOUNT;
1613:
1614: IF (C_LEVEL_STATEMENT >= g_log_level) THEN