APPS.OKL_REPORT_PVT dependencies on OKL_REPORT_STREAM_PARAMS

Line 3589: CURSOR c_is_record_exists(p_strm_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS

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:

Line 3591: FROM OKL_REPORT_STREAM_PARAMS

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;