351: l_dummy VARCHAR2(1) := '?';
352: l_row_not_found BOOLEAN := FALSE;
353:
354: -- Cursor For OKL_SIL_SIF_FK;
355: CURSOR okl_sifv_pk_csr (p_id IN OKL_SIF_LINES_V.sif_id%TYPE) IS
356: SELECT '1'
357: FROM OKL_STREAM_INTERFACES_V
358: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
359:
502:
503: -- Cursor For OKL_SIT_SIL_FK;
504: CURSOR okl_silv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.Sil_id%TYPE) IS
505: SELECT '1'
506: FROM OKL_SIF_LINES_V
507: WHERE OKL_SIF_LINES_V.id = p_id;
508:
509: BEGIN
510:
503: -- Cursor For OKL_SIT_SIL_FK;
504: CURSOR okl_silv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.Sil_id%TYPE) IS
505: SELECT '1'
506: FROM OKL_SIF_LINES_V
507: WHERE OKL_SIF_LINES_V.id = p_id;
508:
509: BEGIN
510:
511: -- initialize return status