509:
510: -- Cursor For OKL_FPR_DSF_FK;
511: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
512: SELECT '1'
513: FROM OKL_DATA_SRC_FNCTNS_V
514: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id;
515:
516: BEGIN
517:
510: -- Cursor For OKL_FPR_DSF_FK;
511: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
512: SELECT '1'
513: FROM OKL_DATA_SRC_FNCTNS_V
514: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id;
515:
516: BEGIN
517:
518: -- initialize return status
586:
587: -- Cursor For OKL_FPR_DSF_FK;
588: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
589: SELECT '1'
590: FROM OKL_DATA_SRC_FNCTNS_V
591: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id
592: AND OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE = 'PLSQL';
593:
594: BEGIN
587: -- Cursor For OKL_FPR_DSF_FK;
588: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
589: SELECT '1'
590: FROM OKL_DATA_SRC_FNCTNS_V
591: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id
592: AND OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE = 'PLSQL';
593:
594: BEGIN
595:
588: CURSOR okl_dsfv_pk_csr (p_id IN OKL_FNCTN_PRMTRS_V.dsf_id%TYPE) IS
589: SELECT '1'
590: FROM OKL_DATA_SRC_FNCTNS_V
591: WHERE OKL_DATA_SRC_FNCTNS_V.id = p_id
592: AND OKL_DATA_SRC_FNCTNS_V.FNCTN_CODE = 'PLSQL';
593:
594: BEGIN
595:
596: -- initialize return status