DBA Data[Home] [Help]

APPS.CE_CASH_FCST dependencies on CE_FORECAST_COLUMNS

Line 884: FROM ce_forecast_columns

880: col_count NUMBER;
881: BEGIN
882: SELECT count(1)
883: INTO col_count
884: FROM ce_forecast_columns
885: WHERE forecast_header_id = G_rp_forecast_header_id;
886:
887: IF( col_count = 0)THEN
888: SELECT count(1)

Line 922: FROM ce_forecast_columns

918: | 21-AUG-1997 Created Wynne Chan |
919: --------------------------------------------------------------------- */
920: FUNCTION valid_col_range RETURN BOOLEAN IS
921: CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
922: FROM ce_forecast_columns
923: WHERE forecast_header_id = G_rp_forecast_header_id;
924:
925: error_msg FND_NEW_MESSAGES.message_text%TYPE;
926: col_num NUMBER;

Line 1482: FROM ce_forecast_columns

1478: THEN
1479: BEGIN
1480: SELECT forecast_column_id
1481: INTO G_overdue_column_id
1482: FROM ce_forecast_columns
1483: WHERE forecast_header_id = G_rp_forecast_header_id
1484: AND developer_column_num = 0;
1485: EXCEPTION
1486: WHEN OTHERS THEN

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

1571: THEN
1572: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1573: cep_standard.debug('Forecast defn valid');
1574:
1575: -- If column setup is automatic populate CE_FORECAST_COLUMNS
1576: -- before populating cells.
1577: SELECT nvl(column_setup,'M')
1578: INTO col_setup
1579: FROM ce_forecast_headers