[Home] [Help]
7109: l_api_name CONSTANT VARCHAR2(30) :='get_lookup_meaning';
7110:
7111: BEGIN
7112: select meaning into l_meaning
7113: from fnd_lookups
7114: where lookup_type = p_lookup_type
7115: and lookup_code = p_lookup_code;
7116:
7117: return l_meaning;
8773: --bug 3814702, add a variable for Lookup type
8774:
8775: l_check_external_party_exists VARCHAR2(30) := 'CHECK_EXTERNAL_PARTY_EXISTS';
8776:
8777: l_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE :='OKC_TERM_QA_LIST';
8778:
8779: CURSOR check_qa_csr(p_qa_code IN VARCHAR2) IS
8780: select qa_code, severity_flag,enable_qa_yn
8781: from okc_doc_qa_lists
8783: and qa_code = p_qa_code;
8784:
8785: CURSOR check_lookup_code_csr(p_lookup_code IN VARCHAR2) IS
8786: select enabled_flag
8787: from fnd_lookups
8788: where lookup_type = l_lookup_type --bug 3814702, use variable for lookup_type
8789: and lookup_code = p_lookup_code;
8790:
8791:
8878:
8879: l_start := l_qa_result_tbl.count;
8880:
8881:
8882: --first we check if the lookup_code is enabled in fnd_lookups
8883: --(1)if the lookup_code is disabled we do not perform the QA check
8884: --(2)if the lookup_code is enabled we query okc_qa_doc_lists
8885: --if the enable_qa_yn = 'N' we do not perform the QA check
8886: --otherwise (including when enable_qa_yn='Y' and when there is no row returned) we perform QA check
10176:
10177: -- get lookup meanings
10178: IF p_repeating_day_of_week is not null THEN
10179: select meaning into l_day_of_week
10180: from fnd_lookups
10181: where lookup_type = 'DAY_OF_WEEK'
10182: and lookup_code = p_repeating_day_of_week;
10183: END IF;
10184:
10183: END IF;
10184:
10185: IF p_repeating_day_of_month is not null THEN
10186: select meaning into l_day_of_month
10187: from fnd_lookups
10188: where lookup_type = 'OKC_DAY_OF_MONTH'
10189: and lookup_code = p_repeating_day_of_month;
10190: END IF;
10191: