DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKS_STATUS_FORECAST

Line 5400: DELETE FROM oks_status_forecast

5396: l_klf_amount := 0;
5397: l_number_k := 0;
5398: l_row_count := 0;
5399:
5400: DELETE FROM oks_status_forecast
5401: WHERE conc_request_id = p_conc_request_id;
5402:
5403: COMMIT;
5404:

Line 5476: INSERT INTO oks_status_forecast

5472: IF (l_curncy_status_prev <> l_curncy_status_curr)
5473: AND (l_row_count <> 1)
5474: THEN
5475: --Insert into Forecast Summary Table...
5476: INSERT INTO oks_status_forecast
5477: (conc_request_id, run_flag, run_time, status_type,
5478: status_code, number_of_contracts, contract_value,
5479: rev_rec_value, forecast_value,
5480: booking_forecast, currency

Line 5571: INSERT INTO oks_status_forecast

5567: THEN
5568: CLOSE l_kh_csr4;
5569: END IF;
5570:
5571: INSERT INTO oks_status_forecast
5572: (conc_request_id, run_flag, run_time, status_type,
5573: status_code, number_of_contracts, contract_value,
5574: rev_rec_value, forecast_value, booking_forecast,
5575: currency