DBA Data[Home] [Help]

APPS.BSC_IM_UTILS dependencies on DUAL

Line 13: from dual;

9: IS
10: cursor cIndicator is
11: select substr(p_Stable, instr(p_Stable, '_',1, 2)+1,
12: instr(p_Stable, '_', 1, 3)- (instr(p_Stable, '_',1, 2)+1))
13: from dual;
14: l_indicator NUMBER;
15: BEGIN
16: OPEN cIndicator;
17: FETCH cIndicator INTO l_indicator;

Line 560: g_stmt:='select '||p_seq||'.nextval from dual';

556: TYPE CurTyp IS REF CURSOR;
557: cv CurTyp;
558: l_id number;
559: Begin
560: g_stmt:='select '||p_seq||'.nextval from dual';
561: write_to_debug_n(g_stmt);
562: execute immediate g_stmt into l_id;
563: return l_id;
564: Exception when others then