[Home] [Help]
49: ELSE
50: lv_ret_success := 'FALSE';
51: -- Get the hash value of the Type + Code + View Appl ID
52: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
53: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
54: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
55: 1000,
56: 25000);
57:
50: lv_ret_success := 'FALSE';
51: -- Get the hash value of the Type + Code + View Appl ID
52: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
53: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
54: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
55: 1000,
56: 25000);
57:
58: IF g_hash_lookup_code_tab.EXISTS(ln_hash_lkcode_idx) THEN
66: ELSE
67: -- Check if the Type is already cached
68: -- Get the hash value of the Type + View Appl ID
69: ln_hash_lktype_idx := DBMS_UTILITY.get_hash_value (
70: p_lookup_type||'@*?'||igs_ge_number.to_cann(p_application_id)
71: ||'@*?'||igs_ge_number.to_cann(l_security_group_id),
72: 1000,
73: 25000);
74:
67: -- Check if the Type is already cached
68: -- Get the hash value of the Type + View Appl ID
69: ln_hash_lktype_idx := DBMS_UTILITY.get_hash_value (
70: p_lookup_type||'@*?'||igs_ge_number.to_cann(p_application_id)
71: ||'@*?'||igs_ge_number.to_cann(l_security_group_id),
72: 1000,
73: 25000);
74:
75: IF g_hash_lookup_type_tab.EXISTS(ln_hash_lktype_idx) THEN
93: g_hash_lookup_type_tab(ln_hash_lktype_idx) := p_lookup_type;
94: END IF;
95:
96: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
97: p_lookup_type||'@*?'||lr_fetched_lkcode.lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
98: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
99: 1000,
100: 25000);
101:
94: END IF;
95:
96: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
97: p_lookup_type||'@*?'||lr_fetched_lkcode.lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
98: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
99: 1000,
100: 25000);
101:
102: g_hash_lookup_code_tab(ln_hash_lkcode_idx).lookup_code := lr_fetched_lkcode.lookup_code;
158: p_application_id => p_application_id) = 'TRUE' THEN
159:
160: -- Get the hash value of the Type + Code + View Appl ID
161: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
162: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
163: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
164: 1000,
165: 25000);
166:
159:
160: -- Get the hash value of the Type + Code + View Appl ID
161: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
162: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
163: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
164: 1000,
165: 25000);
166:
167: RETURN (g_hash_lookup_code_tab(ln_hash_lkcode_idx).meaning);
212: ELSE
213: lv_ret_success := 'FALSE';
214: -- Get the hash value of the Type + Code + View Appl ID
215: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (
216: p_message_name||'@*?'||igs_ge_number.to_cann(ln_application_id)||'@*?'||l_language,
217: 1000,
218: 25000);
219:
220: IF g_hash_msg_type_tab.EXISTS(ln_hash_msg_type_idx) THEN
231: FETCH c_msg_type into lr_fetched_msg_type;
232: EXIT WHEN c_msg_type%NOTFOUND;
233:
234: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (
235: p_message_name||'@*?'||igs_ge_number.to_cann(ln_application_id)||'@*?'||l_language,
236: 1000,
237: 25000);
238:
239: g_hash_msg_type_tab(ln_hash_msg_type_idx) := lr_fetched_msg_type.type;
335: ELSE
336: lv_ret_success := 'FALSE';
337: -- Get the hash value of the Source Type ID + Category
338: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (
339: igs_ge_number.to_cann(p_source_type_id)||'@*?'||p_category_name,
340: 1000,
341: 25000);
342:
343: IF g_hash_srccat_tab.EXISTS(ln_hash_srccat_idx) THEN
370: ELSE
371: -- Check if the Source Type ID is already cached
372: -- Get the hash value of the Source Type ID
373: ln_hash_stypeid_idx := DBMS_UTILITY.get_hash_value (
374: igs_ge_number.to_cann(p_source_type_id),
375: 1000,
376: 25000);
377:
378: IF g_hash_stypeid_tab.EXISTS(ln_hash_stypeid_idx) THEN
396: g_hash_stypeid_tab(ln_hash_stypeid_idx) := p_source_type_id;
397: END IF;
398:
399: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (
400: igs_ge_number.to_cann(p_source_type_id)||'@*?'||lr_fetched_srccat.category_name,
401: 1000,
402: 25000);
403:
404: g_hash_srccat_tab(ln_hash_srccat_idx).category_name := lr_fetched_srccat.category_name;
586:
587: ELSIF p_code_id IS NOT NULL THEN
588: -- Get the hash value of the Type + Code ID
589: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (
590: p_class||'@*?'||igs_ge_number.to_cann(p_code_id),
591: 1000,
592: 25000);
593: END IF;
594:
660: g_hash_cclass_tab(ln_hash_cclass_idx) := p_class;
661: END IF;
662:
663: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (
664: p_class||'@*?'||igs_ge_number.to_cann(lr_fetched_ccode.code_id),
665: 1000,
666: 25000);
667:
668: g_hash_ccode_tab(ln_hash_ccode_idx).code_id := lr_fetched_ccode.code_id;