APPS.BSC_BSC_ADAPTER dependencies on BSC_SYS_PERIODICITIES

Line 283: select 1 from bsc_sys_periodicities

279:
280: -- added 02/13/2006 by Arun
281: -- P1 5034426
282: cursor cReportingCalCheck(p_calendar_id number) is
283: select 1 from bsc_sys_periodicities
284: where
285: calendar_id = p_calendar_id
286: and (period_type_id is null or record_type_id is null )
287: --ignoring xtd pattern due to PMD bug 4503527 not having an upgrade script yet

Line 4152: is select calendar_id from bsc_sys_periodicities where periodicity_id=p_id;

4148: l_cal number;
4149: l_stmt varchar2(1000);
4150: ---------------------------------------------
4151: cursor c1 (p_id number)
4152: is select calendar_id from bsc_sys_periodicities where periodicity_id=p_id;
4153: ---------------------------------------------
4154: Begin
4155: if g_debug then
4156: l_stmt:='select calendar_id from bsc_sys_periodicities where periodicity_id=:1';

Line 4156: l_stmt:='select calendar_id from bsc_sys_periodicities where periodicity_id=:1';

4152: is select calendar_id from bsc_sys_periodicities where periodicity_id=p_id;
4153: ---------------------------------------------
4154: Begin
4155: if g_debug then
4156: l_stmt:='select calendar_id from bsc_sys_periodicities where periodicity_id=:1';
4157: write_to_log_file_n(l_stmt||' '||p_periodicity);
4158: end if;
4159: open c1(p_periodicity);
4160: fetch c1 into l_cal;

Line 4193: cursor c1 is select periodicity_id,source,db_column_name from bsc_sys_periodicities;

4189: l_cal_periodicity BSC_IM_UTILS.number_tabletype;
4190: l_number_cal_column number;
4191: l_calendar_id number;
4192: -------------------------------------------------------
4193: cursor c1 is select periodicity_id,source,db_column_name from bsc_sys_periodicities;
4194: -------------------------------------------------------
4195: Begin
4196:
4197: l_number_periodicity:=1;

Line 4199: g_stmt:='select periodicity_id,source,db_column_name from bsc_sys_periodicities';

4195: Begin
4196:
4197: l_number_periodicity:=1;
4198: if g_debug then
4199: g_stmt:='select periodicity_id,source,db_column_name from bsc_sys_periodicities';
4200: write_to_log_file_n(g_stmt);
4201: end if;
4202: open c1;
4203: loop

Line 4338: is select db_column_name,period_col_name from bsc_sys_periodicities where periodicity_id=p_id;

4334: l_period_col_name varchar2(200);
4335: l_level varchar2(200);
4336: --------------------------------------
4337: cursor c1 (p_id number)
4338: is select db_column_name,period_col_name from bsc_sys_periodicities where periodicity_id=p_id;
4339: --------------------------------------
4340: Begin
4341: p_number_xtd_levels:=0;
4342: if g_debug then

Line 4343: l_stmt:='select db_column_name,period_col_name from bsc_sys_periodicities where periodicity_id=:1';

4339: --------------------------------------
4340: Begin
4341: p_number_xtd_levels:=0;
4342: if g_debug then
4343: l_stmt:='select db_column_name,period_col_name from bsc_sys_periodicities where periodicity_id=:1';
4344: write_to_log_file_n(l_stmt||' '||p_periodicity);
4345: end if;
4346: open c1(p_periodicity);
4347: fetch c1 into l_level,l_period_col_name;

Line 4739: period_type_id,record_type_id,xtd_pattern from bsc_sys_periodicities

4735: )return boolean is
4736: --------------------------
4737: cursor c1(p_calendar_id number) is
4738: select periodicity_id,source,db_column_name,periodicity_type,
4739: period_type_id,record_type_id,xtd_pattern from bsc_sys_periodicities
4740: where calendar_id=p_calendar_id and periodicity_type not in (11,12);
4741: --------------------------
4742: l_custom_count number;
4743: --------------------------

Line 4749: 'period_type_id,record_type_id,xtd_pattern from bsc_sys_periodicities '||

4745: Begin
4746:
4747: if g_debug then
4748: write_to_log_file_n('select periodicity_id,source,db_column_name,periodicity_type,'||
4749: 'period_type_id,record_type_id,xtd_pattern from bsc_sys_periodicities '||
4750: 'where calendar_id='||p_calendar_id||' and periodicity_type not in (11,12)');
4751: end if;
4752: l_custom_count:=0;
4753: open c1(p_calendar_id);

Line 4887: --update bsc_sys_periodicities table

4883: end loop;
4884: for i in 1..p_number_periodicity_data loop
4885: p_periodicity_data(i).xtd_pattern:=l_pattern(i);
4886: end loop;
4887: --update bsc_sys_periodicities table
4888: for i in 1..p_number_periodicity_data loop
4889: execute immediate 'update bsc_sys_periodicities set period_type_id=:1,'||
4890: 'record_type_id=:2,xtd_pattern=:3 '||
4891: 'where calendar_id=:4 and periodicity_id=:5' using p_periodicity_data(i).period_type_id,

Line 4889: execute immediate 'update bsc_sys_periodicities set period_type_id=:1,'||

4885: p_periodicity_data(i).xtd_pattern:=l_pattern(i);
4886: end loop;
4887: --update bsc_sys_periodicities table
4888: for i in 1..p_number_periodicity_data loop
4889: execute immediate 'update bsc_sys_periodicities set period_type_id=:1,'||
4890: 'record_type_id=:2,xtd_pattern=:3 '||
4891: 'where calendar_id=:4 and periodicity_id=:5' using p_periodicity_data(i).period_type_id,
4892: p_periodicity_data(i).record_type_id,p_periodicity_data(i).xtd_pattern,p_calendar_id,
4893: p_periodicity_data(i).periodicity_id;

Line 5238: cursor c1(p_periodicity number) is select period_type_id from bsc_sys_periodicities where

5234:
5235: function get_period_type_id_for_period(
5236: p_periodicity_id number
5237: )return number is
5238: cursor c1(p_periodicity number) is select period_type_id from bsc_sys_periodicities where
5239: periodicity_id=p_periodicity;
5240: l_period_type_id number;
5241: Begin
5242: if g_debug then

Line 5243: write_to_log_file_n('select period_type_id from bsc_sys_periodicities where periodicity_id='||

5239: periodicity_id=p_periodicity;
5240: l_period_type_id number;
5241: Begin
5242: if g_debug then
5243: write_to_log_file_n('select period_type_id from bsc_sys_periodicities where periodicity_id='||
5244: p_periodicity_id);
5245: end if;
5246: open c1(p_periodicity_id);
5247: fetch c1 into l_period_type_id;