[Home] [Help]
215:
216: BEGIN
217:
218: IF apps_env THEN
219: AD_DDL.Do_DDL(fnd_apps_schema,
220: bsc_apps_short_name,
221: x_statement_type,
222: x_statement,
223: x_object_name);
240: ) IS
241: PRAGMA AUTONOMOUS_TRANSACTION;
242: BEGIN
243:
244: AD_DDL.Do_DDL(x_fnd_apps_schema,
245: x_bsc_apps_short_name,
246: x_statement_type,
247: x_statement,
248: x_object_name);
866: IF NOT Table_Exists('BSC_TMP_BIG_IN_COND') THEN
867: h_sql := 'CREATE TABLE BSC_TMP_BIG_IN_COND ('||
868: 'SESSION_ID NUMBER, VARIABLE_ID NUMBER, VALUE_N NUMBER, VALUE_V VARCHAR2(2000)'||
869: ') TABLESPACE '||Get_Tablespace_Name(other_table_tbs_type)||' '||bsc_storage_clause;
870: Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_BIG_IN_COND');
871: END IF;
872:
873: IF NOT Index_Exists('BSC_TMP_BIG_IN_COND_N1') THEN
874: h_sql := 'CREATE INDEX BSC_TMP_BIG_IN_COND_N1'||
873: IF NOT Index_Exists('BSC_TMP_BIG_IN_COND_N1') THEN
874: h_sql := 'CREATE INDEX BSC_TMP_BIG_IN_COND_N1'||
875: ' ON BSC_TMP_BIG_IN_COND (SESSION_ID, VARIABLE_ID) '||
876: ' TABLESPACE '||Get_Tablespace_Name(other_index_tbs_type)||' '||bsc_storage_clause;
877: Do_DDL(h_sql, AD_DDL.CREATE_INDEX, 'BSC_TMP_BIG_IN_COND_N1');
878: END IF;
879:
880: h_sql := 'DELETE FROM BSC_TMP_BIG_IN_COND '||
881: 'WHERE SESSION_ID = USERENV(''SESSIONID'')';
1760: FOR i IN 0..(x_Statements_Tbl.COUNT-1) LOOP
1761: IF ((x_Statements_Tbl(i).x_statement_type IS NULL) OR (x_Statements_Tbl(i).x_Object_Name IS NULL)) THEN
1762: EXECUTE IMMEDIATE x_Statements_Tbl(i).x_statement;
1763: ELSE
1764: AD_DDL.Do_DDL
1765: ( Applsys_Schema => NVL(x_Statements_Tbl(i).x_Fnd_Apps_Schema, BSC_APPS.Fnd_Apps_Schema)
1766: , Application_Short_Name => NVL(x_Statements_Tbl(i).x_Bsc_Apps_Short_Name, BSC_APPS.Bsc_Apps_Short_Name)
1767: , Statement_Type => x_Statements_Tbl(i).x_Statement_Type
1768: , Statement => x_Statements_Tbl(i).x_Statement