APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_STATUSES_GT

Line 1400: INSERT INTO xla_bal_statuses_gt

1396: );
1397: END IF;
1398:
1399: --Create the missing records in xla_balance_statuses, if any.
1400: INSERT INTO xla_bal_statuses_gt
1401: ( application_id
1402: ,ledger_id
1403: ,code_combination_id
1404: ,balance_source_code

Line 1458: ' records inserted in xla_bal_statuses_gt'

1454: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1455: trace
1456: (p_module => l_log_module
1457: ,p_msg => l_row_count ||
1458: ' records inserted in xla_bal_statuses_gt'
1459: ,p_level => C_LEVEL_STATEMENT
1460: );
1461: END IF;
1462:

Line 1466: FROM xla_bal_statuses_gt xbs

1462:
1463: FOR i IN (
1464: SELECT DISTINCT
1465: ledger_id
1466: FROM xla_bal_statuses_gt xbs
1467: )
1468: LOOP
1469:
1470: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1554: UPDATE xla_bal_statuses_gt xbst

1550: END IF;
1551:
1552: EXECUTE IMMEDIATE
1553: '
1554: UPDATE xla_bal_statuses_gt xbst
1555: SET xbst.effective_period_num = ' ||l_latest_open_eff_period_num || '
1556: ,(
1557: xbst.natural_account_segment
1558: ,xbst.balancing_segment

Line 1576: ' records updated in xla_bal_statuses_gt'

1572: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1573: trace
1574: (p_module => l_log_module
1575: ,p_msg => l_row_count ||
1576: ' records updated in xla_bal_statuses_gt'
1577: ,p_level => C_LEVEL_STATEMENT
1578: );
1579: END IF;
1580:

Line 1621: FROM xla_bal_statuses_gt xbst;

1617: ,l_date
1618: ,l_prog_appl_id
1619: ,l_prog_id
1620: ,NVL(l_req_id, -1)
1621: FROM xla_bal_statuses_gt xbst;
1622:
1623: l_row_count := SQL%ROWCOUNT;
1624:
1625: IF (C_LEVEL_STATEMENT >= g_log_level) THEN