DBA Data[Home] [Help]

APPS.BSC_BSC_ADAPTER dependencies on DUAL

Line 5317: select to_char(systimestamp, 'HHMISSFF') into randomString from dual; --Bug 4027813

5313: end loop;
5314: end if;
5315: -------------------------
5316: --we need to create a function dynamically and execute it.
5317: select to_char(systimestamp, 'HHMISSFF') into randomString from dual; --Bug 4027813
5318: l_stmt:='create or replace procedure ld_rpt_cal_'||randomString||' as
5319: type cal_record is record(calendar_year number,calendar_month number,calendar_day number'||newline;
5320: for i in 1..l_number_periods loop
5321: l_stmt:=l_stmt||','||l_period_column(i)||' number';