APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_OPENING_BAL

Line 980: -- Populate CE_FORECAST_OPENING_BAL

976: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
977: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
978: END IF;
979:
980: -- Populate CE_FORECAST_OPENING_BAL
981: Populate_Opening_Bal;
982:
983: clear_aging_buckets;
984: zero_fill_cells;

Line 1276: | This procedure populates CE_FORECAST_OPENING_BAL with the |

1272: | PUBLIC PROCEDURE |
1273: | Populate_Opening_Bal |
1274: | |
1275: | DESCRIPTION |
1276: | This procedure populates CE_FORECAST_OPENING_BAL with the |
1277: | appropriate opening bank balance or opening GL cash account |
1278: | balance if the balance isn't already populated. |
1279: | |
1280: | CALLED BY |

Line 1358: FROM ce_forecast_opening_bal

1354: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO')) THEN
1355: FOR p_bank in C_bank LOOP
1356: SELECT count(1)
1357: INTO counter
1358: FROM ce_forecast_opening_bal
1359: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1360: AND bank_account_id = p_bank.bank_account_id;
1361:
1362: IF counter = 0 THEN

Line 1577: INSERT INTO ce_forecast_opening_bal

1573: 'CE_FC_NO_BANK_BALANCE',
1574: error_msg);
1575: END IF;
1576:
1577: INSERT INTO ce_forecast_opening_bal
1578: (balance_id,
1579: forecast_id,
1580: balance_type,
1581: bank_account_id,

Line 1593: (CE_FORECAST_OPENING_BAL_S.nextval,

1589: last_updated_by,
1590: last_update_date,
1591: last_update_login)
1592: VALUES
1593: (CE_FORECAST_OPENING_BAL_S.nextval,
1594: CE_CASH_FCST.G_forecast_id,
1595: 'BANK',
1596: p_bank.bank_account_id,
1597: null,

Line 1624: FROM ce_forecast_opening_bal

1620:
1621: -- Check if we have already processed this legal entity
1622: SELECT count(1)
1623: INTO counter
1624: FROM ce_forecast_opening_bal
1625: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1626: AND bank_account_id = -2
1627: AND legal_entity_id = nvl(CE_CASH_FCST.G_legal_entity_id,-1);
1628:

Line 1695: INSERT INTO ce_forecast_opening_bal

1691: END IF;
1692:
1693: l_opening_balance := round(l_opening_balance,CE_CASH_FCST.G_precision);
1694:
1695: INSERT INTO ce_forecast_opening_bal
1696: (balance_id,
1697: forecast_id,
1698: balance_type,
1699: bank_account_id,

Line 1711: (CE_FORECAST_OPENING_BAL_S.nextval,

1707: last_updated_by,
1708: last_update_date,
1709: last_update_login)
1710: VALUES
1711: (CE_FORECAST_OPENING_BAL_S.nextval,
1712: CE_CASH_FCST.G_forecast_id,
1713: 'BANK',
1714: -2,
1715: null,

Line 1737: FROM ce_forecast_opening_bal

1733: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO')) THEN
1734: FOR p_glcp in C_glcp LOOP
1735: SELECT count(1)
1736: INTO counter
1737: FROM ce_forecast_opening_bal
1738: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1739: AND code_combination_id = p_glcp.code_combination_id;
1740: IF (counter = 0) THEN
1741: l_opening_balance := Calc_Initial_Cash_Position(p_glcp.code_combination_id);

Line 1744: INSERT INTO ce_forecast_opening_bal

1740: IF (counter = 0) THEN
1741: l_opening_balance := Calc_Initial_Cash_Position(p_glcp.code_combination_id);
1742: l_opening_balance := round(l_opening_balance,CE_CASH_FCST.G_precision);
1743:
1744: INSERT INTO ce_forecast_opening_bal
1745: (balance_id,
1746: forecast_id,
1747: balance_type,
1748: bank_account_id,

Line 1758: (CE_FORECAST_OPENING_BAL_S.nextval,

1754: last_updated_by,
1755: last_update_date,
1756: last_update_login)
1757: VALUES
1758: (CE_FORECAST_OPENING_BAL_S.nextval,
1759: CE_CASH_FCST.G_forecast_id,
1760: 'GLCP',
1761: null,
1762: p_glcp.code_combination_id,