APPS.OKC_NUMBER_SCHEME_GRP dependencies on DUAL

Line 101: Select GETALPHABET(Decode( l_mod,0,l_floor-1,l_floor),type) into l_out from dual;

97: l_mod := mod(seq_number,26);
98:
99: if l_floor > 0 and not(l_floor=1 and l_mod = 0) then
100:
101: Select GETALPHABET(Decode( l_mod,0,l_floor-1,l_floor),type) into l_out from dual;
102:
103: end if;
104:
105: If l_mod=0 then

Line 107: into l_out from dual;

103: end if;
104:
105: If l_mod=0 then
106: SELECT l_out||fnd_global.local_chr(26+decode(type,'L',96,'U',64))
107: into l_out from dual;
108: return l_out;
109: else
110: SELECT l_out||fnd_global.local_chr(l_mod+decode(type,'L',96,'U',64))
111: into l_out from dual;

Line 111: into l_out from dual;

107: into l_out from dual;
108: return l_out;
109: else
110: SELECT l_out||fnd_global.local_chr(l_mod+decode(type,'L',96,'U',64))
111: into l_out from dual;
112: return l_out;
113: end if;
114: end;
115:

Line 295: INTO l_vl_seq_code from dual;

291: G_PKG_NAME, '100: p_level : '||p_level );
292: END IF;
293:
294: Select decode(p_level,1,l_lvl1_seq_code,2,l_lvl2_seq_code,3,l_lvl3_seq_code,4,l_lvl4_seq_code,5,l_lvl5_seq_code,NULL)
295: INTO l_vl_seq_code from dual;
296:
297: /*IF (l_debug = 'Y') THEN
298: okc_debug.log('150: l_vl_seq_code : '||l_vl_seq_code, 2);
299: END IF;*/

Line 449: into l_concat_yn ,l_end_char from dual;

445: END IF;
446:
447: select decode(p_level,1,NULL,2,l_lvl1_concat_yn,3,l_lvl2_concat_yn,4,l_lvl3_concat_yn,5,l_lvl4_concat_yn,'N'),
448: decode(p_level,1,l_lvl1_end_char ,2,l_lvl2_end_char ,3,l_lvl3_end_char ,4,l_lvl4_end_char ,5,l_lvl5_end_char ,NULL)
449: into l_concat_yn ,l_end_char from dual;
450:
451: /*IF (l_debug = 'Y') THEN
452: okc_debug.log('110: l_concat_yn : '||l_concat_yn, 2);
453: okc_debug.log('110: l_end_char : '||l_end_char, 2);

Line 618: INTO l_label FROM DUAL;

614: k:=k+1;
615:
616: SELECT
617: decode(l_concat_yn,'Y',l_label||'.'||decode(k,1,decode(i,1,cr.label1,2,cr.label2,cr.label1),cr.label1),decode(k,1,decode(i,1,cr.label1,2,cr.label2,cr.label1),cr.label1))
618: INTO l_label FROM DUAL;
619:
620: l_string :=l_label ||cr.end_character||' '||ltrim(rtrim(okc_util.decode_lookup('OKC_NUMBER_LEVEL',cr.sequence_level)));
621:
622: FOR i in 1..cr.sequence_level LOOP

Line 1418: into l_concat_yn ,l_end_char from dual;

1414: END IF;
1415:
1416: select decode(p_level,1,NULL,2,l_lvl1_concat_yn,3,l_lvl2_concat_yn,4,l_lvl3_concat_yn,5,l_lvl4_concat_yn,'N'),
1417: decode(p_level,1,l_lvl1_end_char ,2,l_lvl2_end_char ,3,l_lvl3_end_char ,4,l_lvl4_end_char ,5,l_lvl5_end_char ,NULL)
1418: into l_concat_yn ,l_end_char from dual;
1419:
1420: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1421: FND_LOG.STRING(G_PROC_LEVEL,
1422: G_PKG_NAME, '110: l_concat_yn : '||l_concat_yn );