APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_OPENING_BAL

Line 1048: -- Populate CE_FORECAST_OPENING_BAL

1044: AND forecast_row_id = CE_CASH_FCST.G_forecast_row_id
1045: AND forecast_column_id = CE_CASH_FCST.G_overdue_column_id;
1046: END IF;
1047:
1048: -- Populate CE_FORECAST_OPENING_BAL
1049: Populate_Opening_Bal;
1050:
1051: clear_aging_buckets;
1052: zero_fill_cells;

Line 1345: | This procedure populates CE_FORECAST_OPENING_BAL with the |

1341: | PUBLIC PROCEDURE |
1342: | Populate_Opening_Bal |
1343: | |
1344: | DESCRIPTION |
1345: | This procedure populates CE_FORECAST_OPENING_BAL with the |
1346: | appropriate opening bank balance or opening GL cash account |
1347: | balance if the balance isn't already populated. |
1348: | |
1349: | CALLED BY |

Line 1427: FROM ce_forecast_opening_bal

1423: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO')) THEN
1424: FOR p_bank in C_bank LOOP
1425: SELECT count(1)
1426: INTO counter
1427: FROM ce_forecast_opening_bal
1428: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1429: AND bank_account_id = p_bank.bank_account_id;
1430:
1431: IF counter = 0 THEN

Line 1646: INSERT INTO ce_forecast_opening_bal

1642: 'CE_FC_NO_BANK_BALANCE',
1643: error_msg);
1644: END IF;
1645:
1646: INSERT INTO ce_forecast_opening_bal
1647: (balance_id,
1648: forecast_id,
1649: balance_type,
1650: bank_account_id,

Line 1662: (CE_FORECAST_OPENING_BAL_S.nextval,

1658: last_updated_by,
1659: last_update_date,
1660: last_update_login)
1661: VALUES
1662: (CE_FORECAST_OPENING_BAL_S.nextval,
1663: CE_CASH_FCST.G_forecast_id,
1664: 'BANK',
1665: p_bank.bank_account_id,
1666: null,

Line 1693: FROM ce_forecast_opening_bal

1689:
1690: -- Check if we have already processed this legal entity
1691: SELECT count(1)
1692: INTO counter
1693: FROM ce_forecast_opening_bal
1694: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1695: AND bank_account_id = -2
1696: AND legal_entity_id = nvl(CE_CASH_FCST.G_legal_entity_id,-1);
1697:

Line 1764: INSERT INTO ce_forecast_opening_bal

1760: END IF;
1761:
1762: l_opening_balance := round(l_opening_balance,CE_CASH_FCST.G_precision);
1763:
1764: INSERT INTO ce_forecast_opening_bal
1765: (balance_id,
1766: forecast_id,
1767: balance_type,
1768: bank_account_id,

Line 1780: (CE_FORECAST_OPENING_BAL_S.nextval,

1776: last_updated_by,
1777: last_update_date,
1778: last_update_login)
1779: VALUES
1780: (CE_FORECAST_OPENING_BAL_S.nextval,
1781: CE_CASH_FCST.G_forecast_id,
1782: 'BANK',
1783: -2,
1784: null,

Line 1806: FROM ce_forecast_opening_bal

1802: IF (CE_CASH_FCST.G_trx_type IN ('APP','ARR','PAY','XTI','XTO')) THEN
1803: FOR p_glcp in C_glcp LOOP
1804: SELECT count(1)
1805: INTO counter
1806: FROM ce_forecast_opening_bal
1807: WHERE forecast_id = CE_CASH_FCST.G_forecast_id
1808: AND code_combination_id = p_glcp.code_combination_id;
1809: IF (counter = 0) THEN
1810: l_opening_balance := Calc_Initial_Cash_Position(p_glcp.code_combination_id);

Line 1813: INSERT INTO ce_forecast_opening_bal

1809: IF (counter = 0) THEN
1810: l_opening_balance := Calc_Initial_Cash_Position(p_glcp.code_combination_id);
1811: l_opening_balance := round(l_opening_balance,CE_CASH_FCST.G_precision);
1812:
1813: INSERT INTO ce_forecast_opening_bal
1814: (balance_id,
1815: forecast_id,
1816: balance_type,
1817: bank_account_id,

Line 1827: (CE_FORECAST_OPENING_BAL_S.nextval,

1823: last_updated_by,
1824: last_update_date,
1825: last_update_login)
1826: VALUES
1827: (CE_FORECAST_OPENING_BAL_S.nextval,
1828: CE_CASH_FCST.G_forecast_id,
1829: 'GLCP',
1830: null,
1831: p_glcp.code_combination_id,