478: ) RETURN VARCHAR2 IS
479: item_not_found_error EXCEPTION;
480: CURSOR okc_scsv_pk_csr (p_code IN VARCHAR2) IS
481: SELECT 'x'
482: FROM Okc_Subclasses_V
483: WHERE okc_subclasses_v.code = p_code;
484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
479: item_not_found_error EXCEPTION;
480: CURSOR okc_scsv_pk_csr (p_code IN VARCHAR2) IS
481: SELECT 'x'
482: FROM Okc_Subclasses_V
483: WHERE okc_subclasses_v.code = p_code;
484: CURSOR fnd_lookups_pk_csr (p_lookup_code IN VARCHAR2) IS
485: SELECT 'x'
486: FROM Fnd_Lookups
487: WHERE fnd_lookups.lookup_code = p_lookup_code