APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_COLUMNS_S

Line 770: select ce_forecast_columns_s.nextval

766: end if;
767: END LOOP;
768:
769: FOR p_fcol in C_fcol LOOP
770: select ce_forecast_columns_s.nextval
771: into l_forecast_column_id
772: from dual;
773:
774: INSERT INTO ce_forecast_columns(

Line 968: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

964: l_days_to := l_days_from;
965:
966: IF l_column_num <= 80 THEN
967: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
968: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
969: ELSE
970: --More than 80 columns
971: EXIT;
972: END IF;

Line 986: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

982: l_days_to := l_days_from + 6;
983:
984: IF l_column_num <= 80 THEN
985: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
986: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
987: ELSE
988: --More than 80 columns
989: EXIT;
990: END IF;

Line 1004: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

1000: l_days_to := l_days_from + TRUNC(LAST_DAY(l_current_date)) - l_current_date;
1001:
1002: IF l_column_num <= 80 THEN
1003: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1004: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
1005: ELSE
1006: --More than 80 columns
1007: EXIT;
1008: END IF;