3585: p_rps_tbl IN rps_tbl_type,
3586: x_crt_rps_tbl OUT NOCOPY rps_tbl_type,
3587: x_upd_rps_tbl OUT NOCOPY rps_tbl_type) IS
3588:
3589: CURSOR c_is_record_exists(p_strm_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
3590: SELECT 1
3591: FROM OKL_REPORT_STREAM_PARAMS
3592: WHERE STREAM_PARAMETER_ID = p_strm_param_id;
3593:
3587: x_upd_rps_tbl OUT NOCOPY rps_tbl_type) IS
3588:
3589: CURSOR c_is_record_exists(p_strm_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
3590: SELECT 1
3591: FROM OKL_REPORT_STREAM_PARAMS
3592: WHERE STREAM_PARAMETER_ID = p_strm_param_id;
3593:
3594: i NUMBER := 0;
3595: crt_idx NUMBER := 0;