DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_REPORT_PARAMETERS

Line 3487: CURSOR c_is_record_exists(p_param_id OKL_REPORT_PARAMETERS.PARAMETER_ID%TYPE) IS

3483: x_crt_rpp_tbl OUT NOCOPY rpp_tbl_type,
3484: x_upd_rpp_tbl OUT NOCOPY rpp_tbl_type,
3485: x_del_rpp_tbl OUT NOCOPY rpp_tbl_type) IS
3486:
3487: CURSOR c_is_record_exists(p_param_id OKL_REPORT_PARAMETERS.PARAMETER_ID%TYPE) IS
3488: SELECT 1
3489: FROM OKL_REPORT_PARAMETERS
3490: WHERE PARAMETER_ID = p_param_id;
3491:

Line 3489: FROM OKL_REPORT_PARAMETERS

3485: x_del_rpp_tbl OUT NOCOPY rpp_tbl_type) IS
3486:
3487: CURSOR c_is_record_exists(p_param_id OKL_REPORT_PARAMETERS.PARAMETER_ID%TYPE) IS
3488: SELECT 1
3489: FROM OKL_REPORT_PARAMETERS
3490: WHERE PARAMETER_ID = p_param_id;
3491:
3492: i NUMBER := 0;
3493: crt_idx NUMBER := 0;