APPS.OKC_ART_BLK_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 349: FROM fnd_lookup_values_vl

345: status <> 'PENDING_APPROVAL';
346:
347: CURSOR l_status_csr is
348: SELECT NVL(lookup_code, 'X'), NVL(meaning, 'UNDEFINED')
349: FROM fnd_lookup_values_vl
350: WHERE lookup_type = 'OKC_ARTICLE_STATUS';
351:
352: errnum INTEGER := 0;
353: initerrnum INTEGER := 0;

Line 365: l_to_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;

361:
362: l_status_code_tbl varchar_tbl_type;
363: l_status_meaning_tbl varchar_tbl_type;
364:
365: l_to_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;
366: l_from_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;
367:
368: FUNCTION get_status_meaning(p_status IN VARCHAR2) RETURN VARCHAR2
369: IS

Line 366: l_from_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;

362: l_status_code_tbl varchar_tbl_type;
363: l_status_meaning_tbl varchar_tbl_type;
364:
365: l_to_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;
366: l_from_status_meaning FND_LOOKUP_VALUES_VL.MEANING%TYPE;
367:
368: FUNCTION get_status_meaning(p_status IN VARCHAR2) RETURN VARCHAR2
369: IS
370: BEGIN