eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on AD_DDL

Line 4156: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.create_view, p_Dim_Level_Rec.Bsc_Level_View_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4152: UPDATE BSC_SYS_DIM_LEVELS_B
4153: SET Table_Type = 1
4154: WHERE Short_Name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
4155:
4156: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.create_view, p_Dim_Level_Rec.Bsc_Level_View_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4157:
4158: EXCEPTION
4159: --if exception, it means PMF View does not exists,
4160: --in this case update Table_Type = -1, which is a indication of view does not exists

Line 4327: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4323: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4324:
4325: IF (l_count <> 0) THEN
4326: l_sql_stmt := 'DROP TABLE '||l_master_table;
4327: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4328: END IF;
4329:
4330: -- CHANGED THIS TO REARRANGE THE COLS MASTER TABLES
4331: -- BUG #3081595

Line 4340: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4336: ' LANGUAGE VARCHAR2(4) NOT NULL,'||
4337: ' SOURCE_LANG VARCHAR2(4) NOT NULL )'||
4338: ' '||' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4339:
4340: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4341:
4342: -- in case we need to rollback the ddl
4343: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4344: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_master_table;

Line 4345: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_table;

4341:
4342: -- in case we need to rollback the ddl
4343: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4344: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_master_table;
4345: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_table;
4346: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).object_name := l_master_table;
4347:
4348: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4349: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||

Line 4352: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4348: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4349: ' ON '||l_master_table||' (CODE,LANGUAGE) '||' '||
4350: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4351:
4352: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4353:
4354: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4355: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4356: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||

Line 4359: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4355: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4356: ' ON '||l_master_table||' (USER_CODE,LANGUAGE) '||' '||
4357: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4358:
4359: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4360:
4361: l_col_names := NULL;
4362: --Bug #3081595
4363: l_col_names := 'USER_CODE, NAME ';

Line 4372: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4368: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
4369:
4370: IF (l_count <> 0) THEN
4371: l_sql_stmt := 'DROP TABLE '||l_input_table;
4372: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4373: END IF;
4374: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
4375: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4376: ' AS SELECT '||l_col_names||' FROM '||l_master_table||' WHERE 1 = 2';

Line 4378: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4374: l_sql_stmt := ' CREATE TABLE '||l_input_table||' '||' TABLESPACE '||
4375: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4376: ' AS SELECT '||l_col_names||' FROM '||l_master_table||' WHERE 1 = 2';
4377:
4378: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4379:
4380: -- in case we need to rollback the ddl
4381: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4382: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_input_table;

Line 4383: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_table;

4379:
4380: -- in case we need to rollback the ddl
4381: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4382: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP TABLE '||l_input_table;
4383: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_table;
4384: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).object_name := l_input_table;
4385:
4386: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
4387: ' ON '||l_input_table||' (USER_CODE) '||' '||

Line 4390: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4386: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_input_table||'_U1 '||
4387: ' ON '||l_input_table||' (USER_CODE) '||' '||
4388: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Input_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4389:
4390: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4391:
4392: l_col_names := NULL;
4393: FOR cd IN c_view_cols LOOP
4394: IF (l_col_names IS NULL )THEN

Line 4406: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4402: ' SELECT '||l_col_names||
4403: ' FROM '||l_master_table||
4404: ' WHERE LANGUAGE = USERENV(''LANG''))';
4405:
4406: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4407:
4408: -- in case we need to rollback the ddl
4409: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4410: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP VIEW '||l_view_name;

Line 4411: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_view;

4407:
4408: -- in case we need to rollback the ddl
4409: l_num_rollback_ddl_stmts := l_num_rollback_ddl_stmts + 1;
4410: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).sql_stmt := 'DROP VIEW '||l_view_name;
4411: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).stmt_type := ad_ddl.drop_view;
4412: l_rollback_ddl_stmts(l_num_rollback_ddl_stmts).object_name := l_view_name;
4413:
4414:
4415: FOR i_project IN 0..5 LOOP

Line 4679: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4675: l_sql_stmt := 'ALTER TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name||
4676: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||
4677: ' MODIFY NAME VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size||') ';
4678:
4679: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4680:
4681:
4682: l_sql_stmt := 'ALTER TABLE BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id||' '||
4683: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||

Line 4686: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, 'BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4682: l_sql_stmt := 'ALTER TABLE BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id||' '||
4683: ' MODIFY USER_CODE VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') '||
4684: ' MODIFY NAME VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_Disp_Key_Size||') ';
4685:
4686: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, 'BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4687: IF ((p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size)) THEN
4688: FOR cd IN c_db_tables LOOP
4689: l_sql_stmt := ' ALTER TABLE '||cd.Table_Name||
4690: ' MODIFY '||cd.Column_Name||

Line 4692: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, cd.TABLE_NAME, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4688: FOR cd IN c_db_tables LOOP
4689: l_sql_stmt := ' ALTER TABLE '||cd.Table_Name||
4690: ' MODIFY '||cd.Column_Name||
4691: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
4692: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, cd.TABLE_NAME, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4693: END LOOP;
4694: END IF;
4695:
4696: /********************************************************

Line 4711: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4707:
4708: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4709: IF (l_count <> 0) THEN
4710: l_sql_stmt := 'DROP TABLE '||l_master_table;
4711: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4712: END IF;
4713: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4714: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4715: ' AS SELECT * FROM '||p_Dim_Level_Rec_Old.Bsc_Level_Name;

Line 4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4713: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4714: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4715: ' AS SELECT * FROM '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4716:
4717: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4719: ' ON '||l_master_table||' (CODE, LANGUAGE) '||' '||
4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4721:

Line 4722: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4718: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U1 '||
4719: ' ON '||l_master_table||' (CODE, LANGUAGE) '||' '||
4720: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4721:
4722: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4723:
4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4725: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4726: ' ON '||l_master_table||' (USER_CODE, LANGUAGE) '||' '||

Line 4728: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4724: -- Create a new UNIQUE INDEX for Loader Performance - Bug #3090828
4725: l_sql_stmt := ' CREATE UNIQUE INDEX '||l_master_table||'_U2 '||
4726: ' ON '||l_master_table||' (USER_CODE, LANGUAGE) '||' '||
4727: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.Bsc_Storage_Clause;
4728: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4729: l_count := 1;
4730: FOR cd IN c_One_To_N_Index LOOP
4731: -- Create a new Non-Unique INDEX for Loader Performance - Bug #3120190
4732:

Line 4738: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4734: l_sql_stmt := ' CREATE INDEX '||l_master_table||'_N'||l_count||' '||
4735: ' ON '||l_master_table||' ('||cd.Level_Pk_Col||') '||' '||
4736: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
4737:
4738: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4739: l_count := l_count + 1;
4740: ELSE
4741: EXIT;
4742: END IF;

Line 4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4742: END IF;
4743: END LOOP;
4744: l_sql_stmt := 'DROP TABLE '||p_Dim_Level_Rec_Old.Bsc_Level_Name;
4745:
4746: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, p_Dim_Level_Rec_Old.Bsc_Level_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4747: --update BSC_DB_TABLES_RELS
4748: UPDATE BSC_DB_TABLES_RELS
4749: SET Table_Name = l_master_table
4750: WHERE Source_Table_Name = l_input_table;

Line 4768: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4764: ' SELECT '||l_col_names||
4765: ' FROM '||l_master_table||
4766: ' WHERE LANGUAGE = USERENV(''LANG''))';
4767:
4768: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4769: END IF;
4770: l_flag := BSC_BIS_DIM_OBJ_PUB.Alter_M_By_N_Tables
4771: ( p_Dim_Level_Rec => p_Dim_Level_Rec
4772: , p_Dim_Level_Rec_Old => p_Dim_Level_Rec_Old

Line 4917: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4913:
4914: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4915: IF (l_count <> 0) THEN
4916: l_sql_stmt := 'DROP TABLE '||l_master_table;
4917: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4918: END IF;
4919: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4920: ' WHERE OBJECT_NAME = :1';
4921:

Line 4931: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4927: l_sql_stmt := ' CREATE TABLE '||l_master_table||' '||' TABLESPACE '||
4928: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||
4929: ' AS SELECT * FROM '||l_old_mas_name;
4930:
4931: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4932:
4933: --meastmon 02-27-2004: Here is missing the sql statement. I found this by casualty. So fixing
4934: -- -----
4935: ---Need to update the following table when there is change in abbrevation bug#4091924

Line 4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4948: END IF;
4949:
4950: l_sql_stmt := 'DROP TABLE '||l_old_mas_name;
4951: -- -----
4952: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_old_mas_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4953:
4954: --update BSC_DB_TABLES_RELS
4955: UPDATE BSC_DB_TABLES_RELS
4956: SET Table_Name = l_master_table

Line 4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4961:
4962: l_Tbl_Statements.DELETE;
4963: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER )';
4964:
4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
4969: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;

4964:
4965: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4966: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4967: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4968: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
4969: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
4970: l_Tbl_Statements(0).x_Object_Name := l_master_table;
4971:
4972: l_sql_stmt := 'UPDATE '||l_master_table||' SET '||

Line 4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4980: l_Tbl_Statements(1).x_Object_Name := NULL;
4981:
4982: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
4983:
4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;

4983:
4984: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4985: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4986: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4987: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
4988: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
4989: l_Tbl_Statements(2).x_Object_Name := l_master_table;
4990: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
4991:

Line 4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

4992: l_Tbl_Statements.DELETE;
4993: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
4994: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
4995:
4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5000: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;

4995:
4996: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4997: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
4998: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
4999: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5000: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5001: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5002:
5003: l_sql_stmt := 'UPDATE '||l_input_table||' SET '||

Line 5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5011: l_Tbl_Statements(1).x_Object_Name := NULL;
5012:
5013: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5014:
5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;

5014:
5015: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5016: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5017: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5018: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5019: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5020: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5021: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5022:

Line 5027: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5023: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5024: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5025: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5026: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5027: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5028: END IF;
5029:
5030: /********************************************************************
5031: Here we need to call the API BSC_SYNC_MVLOGS.Sync_dim_table_mv_log

Line 5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5210: END IF;
5211: l_Tbl_Statements.DELETE;
5212: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||' NUMBER)';
5213:
5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5218: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;

5213:
5214: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5215: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5216: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5217: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5218: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5219: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5220:
5221: l_sql_stmt := 'UPDATE '||l_master_table||' SET '||

Line 5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5229: l_Tbl_Statements(1).x_Object_Name := NULL;
5230:
5231: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||p_Dim_Level_Rec_Old.Bsc_Pk_Col;
5232:
5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;

5232:
5233: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5234: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5235: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5236: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5237: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5238: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5239: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5240:

Line 5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5241: l_Tbl_Statements.DELETE;
5242: l_sql_stmt := 'ALTER TABLE '||l_master_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5243: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5244:
5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5249: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;

5244:
5245: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5246: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5247: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5248: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5249: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5250: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5251:
5252:

Line 5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5261: l_Tbl_Statements(1).x_Object_Name := NULL;
5262: l_sql_stmt := 'ALTER TABLE '||l_master_table||' DROP COLUMN '||
5263: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5264:
5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;

5264:
5265: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5266: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5267: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5268: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5269: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5270: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5271: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5272:

Line 5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5273: l_Tbl_Statements.DELETE;
5274: l_sql_stmt := 'ALTER TABLE '||l_input_table||' ADD ('||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5275: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||'))';
5276:
5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5281: l_Tbl_Statements(0).x_Statement := l_sql_stmt;

Line 5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;

5276:
5277: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5278: l_Tbl_Statements(0).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5279: l_Tbl_Statements(0).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5280: l_Tbl_Statements(0).x_Statement_Type := AD_DDL.Alter_Table;
5281: l_Tbl_Statements(0).x_Statement := l_sql_stmt;
5282: l_Tbl_Statements(0).x_Object_Name := l_master_table;
5283:
5284: l_sql_stmt := 'UPDATE '||l_input_table||' SET '||

Line 5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5294:
5295: l_sql_stmt := 'ALTER TABLE '||l_input_table||' DROP COLUMN '||
5296: p_Dim_Level_Rec_Old.Bsc_Pk_Col||'_USR';
5297:
5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;

Line 5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;

5297:
5298: --BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5299: l_Tbl_Statements(2).x_Fnd_Apps_Schema := BSC_APPS.Fnd_Apps_Schema;
5300: l_Tbl_Statements(2).x_Bsc_Apps_Short_Name := BSC_APPS.Bsc_Apps_Short_Name;
5301: l_Tbl_Statements(2).x_Statement_Type := AD_DDL.Alter_Table;
5302: l_Tbl_Statements(2).x_Statement := l_sql_stmt;
5303: l_Tbl_Statements(2).x_Object_Name := l_master_table;
5304: BSC_APPS.Do_Ddl_AT(x_Statements_Tbl => l_Tbl_Statements);
5305:

Line 5321: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5317: IF (LENGTH(l_index_Name) <= 30) THEN
5318: l_sql_stmt := ' CREATE INDEX '||l_index_Name||' '||
5319: ' ON '||l_master_table||' ('||p_Dim_Level_Rec.Bsc_Pk_Col||') '||' '||
5320: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Index_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause;
5321: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_index, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5322: END IF;
5323: ELSIF (p_Dim_Level_Rec.Bsc_Level_User_Key_Size <> p_Dim_Level_Rec_Old.Bsc_Level_User_Key_Size) THEN
5324: l_Create_View := TRUE;
5325:

Line 5330: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5326: l_sql_stmt := ' ALTER TABLE '||l_master_table||
5327: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5328: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5329:
5330: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5331:
5332: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5333: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5334: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';

Line 5336: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5332: l_sql_stmt := ' ALTER TABLE '||l_input_table||
5333: ' MODIFY '||p_Dim_Level_Rec.Bsc_Pk_Col||'_USR '||
5334: ' VARCHAR2('||p_Dim_Level_Rec.Bsc_Level_User_Key_Size||') ';
5335:
5336: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.alter_table, l_input_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5337: END IF;
5338: IF (l_Create_View) THEN
5339: l_col_names := NULL;
5340: FOR cd IN c_view_cols LOOP

Line 5353: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

5349: ' SELECT '||l_col_names||
5350: ' FROM '||l_master_table||
5351: ' WHERE LANGUAGE = USERENV(''LANG''))';
5352:
5353: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.create_view, l_view_name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
5354: END IF;
5355:
5356: --Now synch up the MLOG tables with the new User_Key_Size and Disp_Key_Size
5357:

Line 6132: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, PMF_EDW.Level_Table_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);

6128: SET Table_Type = -1
6129: WHERE Short_Name = PMF_EDW.Short_Name;
6130:
6131: l_sql := 'DROP VIEW ' || PMF_EDW.Level_Table_Name;
6132: BSC_APPS.Do_Ddl_AT(l_sql, ad_ddl.drop_view, PMF_EDW.Level_Table_Name, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
6133: END LOOP;
6134: EXCEPTION
6135: WHEN OTHERS THEN
6136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;