[Home] [Help]
7510: l_api_name CONSTANT VARCHAR2(30) :='get_lookup_meaning';
7511:
7512: BEGIN
7513: select meaning into l_meaning
7514: from fnd_lookups
7515: where lookup_type = p_lookup_type
7516: and lookup_code = p_lookup_code;
7517:
7518: return l_meaning;
9599: --bug 3814702, add a variable for Lookup type
9600:
9601: l_check_external_party_exists VARCHAR2(30) := 'CHECK_EXTERNAL_PARTY_EXISTS';
9602:
9603: l_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE :='OKC_TERM_QA_LIST';
9604:
9605: CURSOR check_qa_csr(p_qa_code IN VARCHAR2) IS
9606: select qa_code, severity_flag,enable_qa_yn
9607: from okc_doc_qa_lists
9609: and qa_code = p_qa_code;
9610:
9611: CURSOR check_lookup_code_csr(p_lookup_code IN VARCHAR2) IS
9612: select enabled_flag
9613: from fnd_lookups
9614: where lookup_type = l_lookup_type --bug 3814702, use variable for lookup_type
9615: and lookup_code = p_lookup_code;
9616:
9617:
9704:
9705: l_start := l_qa_result_tbl.count;
9706:
9707:
9708: --first we check if the lookup_code is enabled in fnd_lookups
9709: --(1)if the lookup_code is disabled we do not perform the QA check
9710: --(2)if the lookup_code is enabled we query okc_qa_doc_lists
9711: --if the enable_qa_yn = 'N' we do not perform the QA check
9712: --otherwise (including when enable_qa_yn='Y' and when there is no row returned) we perform QA check
11135:
11136: -- get lookup meanings
11137: IF p_repeating_day_of_week is not null THEN
11138: select meaning into l_day_of_week
11139: from fnd_lookups
11140: where lookup_type = 'DAY_OF_WEEK'
11141: and lookup_code = p_repeating_day_of_week;
11142: END IF;
11143:
11142: END IF;
11143:
11144: IF p_repeating_day_of_month is not null THEN
11145: select meaning into l_day_of_month
11146: from fnd_lookups
11147: where lookup_type = 'OKC_DAY_OF_MONTH'
11148: and lookup_code = p_repeating_day_of_month;
11149: END IF;
11150: