DBA Data[Home] [Help]

APPS.CE_CASH_FCST dependencies on CE_FORECAST_COLUMNS

Line 870: FROM ce_forecast_columns

866: col_count NUMBER;
867: BEGIN
868: SELECT count(1)
869: INTO col_count
870: FROM ce_forecast_columns
871: WHERE forecast_header_id = G_rp_forecast_header_id;
872:
873: IF( col_count = 0)THEN
874: SELECT count(1)

Line 908: FROM ce_forecast_columns

904: | 21-AUG-1997 Created Wynne Chan |
905: --------------------------------------------------------------------- */
906: FUNCTION valid_col_range RETURN BOOLEAN IS
907: CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
908: FROM ce_forecast_columns
909: WHERE forecast_header_id = G_rp_forecast_header_id;
910:
911: error_msg FND_NEW_MESSAGES.message_text%TYPE;
912: col_num NUMBER;

Line 1455: FROM ce_forecast_columns

1451: IF(G_overdue_transactions = 'INCLUDE')THEN
1452: BEGIN
1453: SELECT forecast_column_id
1454: INTO G_overdue_column_id
1455: FROM ce_forecast_columns
1456: WHERE forecast_header_id = G_rp_forecast_header_id AND
1457: developer_column_num = 0;
1458: EXCEPTION
1459: WHEN OTHERS THEN

Line 1538: -- If column setup is automatic populate CE_FORECAST_COLUMNS

1534: IF ((standalone_process AND (NOT G_gl_cash_only)) OR child_process) THEN
1535: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1536: cep_standard.debug('Forecast defn valid');
1537:
1538: -- If column setup is automatic populate CE_FORECAST_COLUMNS
1539: -- before populating cells.
1540: SELECT nvl(column_setup,'M')
1541: INTO col_setup
1542: FROM ce_forecast_headers