APPS.BSC_BSC_ADAPTER dependencies on BSC_APPS

Line 3257: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_denorm_table);

3253:
3254: l_stmt := 'create table '||l_denorm_table||'(parent_code '||l_data_type||', code '||l_data_type||', child_level number, parent_level number)';
3255:
3256: begin
3257: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_denorm_table);
3258: l_stmt := 'create index '||l_denorm_table||'_N1 on '||l_denorm_table||'(CODE)';
3259:
3260: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_INDEX, l_denorm_table||'_N1');
3261: exception when others then

Line 3260: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_INDEX, l_denorm_table||'_N1');

3256: begin
3257: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_denorm_table);
3258: l_stmt := 'create index '||l_denorm_table||'_N1 on '||l_denorm_table||'(CODE)';
3259:
3260: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_INDEX, l_denorm_table||'_N1');
3261: exception when others then
3262: if sqlcode = -955 then -- already exists
3263: null;
3264: else

Line 4439: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_temp_table);*/

4435: --------------create the temp table-----
4436: /*l_temp_table:='BSC_CAL_TEMP';
4437: l_stmt:='create global temporary table '||l_temp_table||'(record_type_id number,'||
4438: 'period_type_id number,period number,year number) on commit preserve rows';
4439: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_temp_table);*/
4440: ----------------------------------------
4441: ------------------------
4442: /*for each calendar, get the periodicities to fetch from bsc_db_calendar
4443: find out the relations between the periodicities, see if they are the std

Line 4578: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_temp_table);*/

4574: --------------create the temp table-----
4575: /*l_temp_table:='BSC_CAL_TEMP';
4576: l_stmt:='create global temporary table '||l_temp_table||'(record_type_id number,'||
4577: 'period_type_id number,period number,year number) on commit preserve rows';
4578: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, l_temp_table);*/
4579: ----------------------------------------
4580: ------------------------
4581: /*for this calendar, get the periodicities to fetch from bsc_db_calendar
4582: find out the relations between the periodicities, see if they are the std