DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKS_STATUS_FORECAST

Line 5446: DELETE FROM oks_status_forecast

5442: l_klf_amount := 0;
5443: l_number_k := 0;
5444: l_row_count := 0;
5445:
5446: DELETE FROM oks_status_forecast
5447: WHERE conc_request_id = p_conc_request_id;
5448:
5449: COMMIT;
5450:

Line 5522: INSERT INTO oks_status_forecast

5518: IF (l_curncy_status_prev <> l_curncy_status_curr)
5519: AND (l_row_count <> 1)
5520: THEN
5521: --Insert into Forecast Summary Table...
5522: INSERT INTO oks_status_forecast
5523: (conc_request_id, run_flag, run_time, status_type,
5524: status_code, number_of_contracts, contract_value,
5525: rev_rec_value, forecast_value,
5526: booking_forecast, currency

Line 5617: INSERT INTO oks_status_forecast

5613: THEN
5614: CLOSE l_kh_csr4;
5615: END IF;
5616:
5617: INSERT INTO oks_status_forecast
5618: (conc_request_id, run_flag, run_time, status_type,
5619: status_code, number_of_contracts, contract_value,
5620: rev_rec_value, forecast_value, booking_forecast,
5621: currency