DBA Data[Home] [Help]

APPS.OKL_BOOK_CONTROLLER_PVT dependencies on FND_LOOKUPS

Line 1673: l_severity fnd_lookups.meaning%TYPE;

1669: l_init_msg_list VARCHAR2(1) := 'T';
1670: l_msg_count NUMBER;
1671: l_msg_data VARCHAR2(2000);
1672: l_qcl_id NUMBER;
1673: l_severity fnd_lookups.meaning%TYPE;
1674: l_error_sts VARCHAR2(1);
1675: l_msg_tbl OKL_QA_CHECK_PUB.msg_tbl_type;
1676: l_data_len NUMBER;
1677: l_msg_token_tbl msg_token_tbl;

Line 1690: CURSOR get_severity(p_sts_code fnd_lookups.lookup_code%TYPE) IS

1686: FROM okc_k_headers_b
1687: WHERE id = p_khr_id;
1688:
1689: --cursor to fetch severity meaning
1690: CURSOR get_severity(p_sts_code fnd_lookups.lookup_code%TYPE) IS
1691: SELECT meaning
1692: FROM fnd_lookups
1693: WHERE lookup_type = 'CP_SET_OUTCOME'
1694: AND lookup_code = p_sts_code;

Line 1692: FROM fnd_lookups

1688:
1689: --cursor to fetch severity meaning
1690: CURSOR get_severity(p_sts_code fnd_lookups.lookup_code%TYPE) IS
1691: SELECT meaning
1692: FROM fnd_lookups
1693: WHERE lookup_type = 'CP_SET_OUTCOME'
1694: AND lookup_code = p_sts_code;
1695:
1696: BEGIN