DBA Data[Home] [Help]

APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_UTIL

Line 620: l_string :=l_label ||cr.end_character||' '||ltrim(rtrim(okc_util.decode_lookup('OKC_NUMBER_LEVEL',cr.sequence_level)));

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
623: l_string := ' '||l_string;
624: END LOOP;