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_DIM_TPLATE dependencies on BSC_APPS

Line 114: BSC_APPS.DO_DDL(l_sql_stmt,

110: if (l_count <> 0) then
111: l_sql_stmt := 'Drop Table BSC_D_TYPE_OF_ACCOUNT';
112: l_debug_stmt := l_sql_stmt;
113:
114: BSC_APPS.DO_DDL(l_sql_stmt,
115: ad_ddl.drop_table,
116: 'BSC_D_TYPE_OF_ACCOUNT');
117: end if;
118:

Line 125: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||

121: 'LANGUAGE Varchar2(4) NOT NULL,'||
122: 'SOURCE_LANG Varchar2(4) NOT NULL,'||
123: 'USER_CODE Varchar2(5), ' ||
124: 'NAME Varchar2(20))'||
125: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
126: ' '||BSC_APPS.bsc_storage_clause;
127:
128: l_debug_stmt := l_sql_stmt;
129:

Line 126: ' '||BSC_APPS.bsc_storage_clause;

122: 'SOURCE_LANG Varchar2(4) NOT NULL,'||
123: 'USER_CODE Varchar2(5), ' ||
124: 'NAME Varchar2(20))'||
125: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
126: ' '||BSC_APPS.bsc_storage_clause;
127:
128: l_debug_stmt := l_sql_stmt;
129:
130: BSC_APPS.DO_DDL(l_sql_stmt,

Line 130: BSC_APPS.DO_DDL(l_sql_stmt,

126: ' '||BSC_APPS.bsc_storage_clause;
127:
128: l_debug_stmt := l_sql_stmt;
129:
130: BSC_APPS.DO_DDL(l_sql_stmt,
131: ad_ddl.create_table,
132: 'BSC_D_TYPE_OF_ACCOUNT');
133:
134:

Line 136: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

132: 'BSC_D_TYPE_OF_ACCOUNT');
133:
134:
135: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_TYPE_OF_ACCOUNT_U1 ON BSC_D_TYPE_OF_ACCOUNT (CODE,LANGUAGE)'||
136: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
137: ' '||BSC_APPS.bsc_storage_clause;
138: l_debug_stmt := l_sql_stmt;
139: BSC_APPS.DO_DDL(l_sql_stmt,
140: ad_ddl.create_index,

Line 137: ' '||BSC_APPS.bsc_storage_clause;

133:
134:
135: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_TYPE_OF_ACCOUNT_U1 ON BSC_D_TYPE_OF_ACCOUNT (CODE,LANGUAGE)'||
136: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
137: ' '||BSC_APPS.bsc_storage_clause;
138: l_debug_stmt := l_sql_stmt;
139: BSC_APPS.DO_DDL(l_sql_stmt,
140: ad_ddl.create_index,
141: 'BSC_D_TYPE_OF_ACCOUNT_U1');

Line 139: BSC_APPS.DO_DDL(l_sql_stmt,

135: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_TYPE_OF_ACCOUNT_U1 ON BSC_D_TYPE_OF_ACCOUNT (CODE,LANGUAGE)'||
136: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
137: ' '||BSC_APPS.bsc_storage_clause;
138: l_debug_stmt := l_sql_stmt;
139: BSC_APPS.DO_DDL(l_sql_stmt,
140: ad_ddl.create_index,
141: 'BSC_D_TYPE_OF_ACCOUNT_U1');
142:
143: -- Create View

Line 152: BSC_APPS.DO_DDL(l_sql_stmt,

148: ' FROM BSC_D_TYPE_OF_ACCOUNT '||
149: ' WHERE LANGUAGE = userenv(''LANG''))';
150:
151: l_debug_stmt := l_sql_stmt;
152: BSC_APPS.DO_DDL(l_sql_stmt,
153: ad_ddl.create_view,
154: 'BSC_D_2_VL');
155:
156: -- Create Input table

Line 167: BSC_APPS.DO_DDL(l_sql_stmt,

163: if (l_count <> 0) then
164: l_sql_stmt := 'Drop Table BSC_DI_2';
165: l_debug_stmt := l_sql_stmt;
166:
167: BSC_APPS.DO_DDL(l_sql_stmt,
168: ad_ddl.drop_table,
169: 'BSC_DI_2');
170: end if;
171:

Line 175: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||

171:
172: l_sql_stmt := 'Create Table BSC_DI_2 (' ||
173: 'USER_CODE Varchar2(5), ' ||
174: 'NAME Varchar2(20))'||
175: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
176: ' '||BSC_APPS.bsc_storage_clause;
177: l_debug_stmt := l_sql_stmt;
178:
179: BSC_APPS.DO_DDL(l_sql_stmt,

Line 176: ' '||BSC_APPS.bsc_storage_clause;

172: l_sql_stmt := 'Create Table BSC_DI_2 (' ||
173: 'USER_CODE Varchar2(5), ' ||
174: 'NAME Varchar2(20))'||
175: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
176: ' '||BSC_APPS.bsc_storage_clause;
177: l_debug_stmt := l_sql_stmt;
178:
179: BSC_APPS.DO_DDL(l_sql_stmt,
180: ad_ddl.create_table,

Line 179: BSC_APPS.DO_DDL(l_sql_stmt,

175: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
176: ' '||BSC_APPS.bsc_storage_clause;
177: l_debug_stmt := l_sql_stmt;
178:
179: BSC_APPS.DO_DDL(l_sql_stmt,
180: ad_ddl.create_table,
181: 'BSC_DI_2');
182:
183: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_2_U1 ON BSC_DI_2 (USER_CODE)'||

Line 184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

180: ad_ddl.create_table,
181: 'BSC_DI_2');
182:
183: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_2_U1 ON BSC_DI_2 (USER_CODE)'||
184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
185: ' '||BSC_APPS.bsc_storage_clause;
186: l_debug_stmt := l_sql_stmt;
187: BSC_APPS.DO_DDL(l_sql_stmt,
188: ad_ddl.create_index,

Line 185: ' '||BSC_APPS.bsc_storage_clause;

181: 'BSC_DI_2');
182:
183: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_2_U1 ON BSC_DI_2 (USER_CODE)'||
184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
185: ' '||BSC_APPS.bsc_storage_clause;
186: l_debug_stmt := l_sql_stmt;
187: BSC_APPS.DO_DDL(l_sql_stmt,
188: ad_ddl.create_index,
189: 'BSC_DI_2_U1');

Line 187: BSC_APPS.DO_DDL(l_sql_stmt,

183: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_2_U1 ON BSC_DI_2 (USER_CODE)'||
184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
185: ' '||BSC_APPS.bsc_storage_clause;
186: l_debug_stmt := l_sql_stmt;
187: BSC_APPS.DO_DDL(l_sql_stmt,
188: ad_ddl.create_index,
189: 'BSC_DI_2_U1');
190:
191:

Line 204: BSC_APPS.DO_DDL(l_sql_stmt,

200: if (l_count <> 0) then
201: l_sql_stmt := 'Drop Table BSC_D_ACCOUNT';
202: l_debug_stmt := l_sql_stmt;
203:
204: BSC_APPS.DO_DDL(l_sql_stmt,
205: ad_ddl.drop_table,
206: 'BSC_D_ACCOUNT');
207: end if;
208:

Line 218: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||

214: 'NAME Varchar2(20), ' ||
215: 'Typ_of_Acc_Code Number, ' ||
216: 'Typ_of_Acc_Code_Usr Varchar2(5), ' ||
217: 'Position Number(2))'||
218: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
219: ' '||BSC_APPS.bsc_storage_clause;
220: l_debug_stmt := l_sql_stmt;
221:
222: BSC_APPS.DO_DDL(l_sql_stmt,

Line 219: ' '||BSC_APPS.bsc_storage_clause;

215: 'Typ_of_Acc_Code Number, ' ||
216: 'Typ_of_Acc_Code_Usr Varchar2(5), ' ||
217: 'Position Number(2))'||
218: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
219: ' '||BSC_APPS.bsc_storage_clause;
220: l_debug_stmt := l_sql_stmt;
221:
222: BSC_APPS.DO_DDL(l_sql_stmt,
223: ad_ddl.create_table,

Line 222: BSC_APPS.DO_DDL(l_sql_stmt,

218: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
219: ' '||BSC_APPS.bsc_storage_clause;
220: l_debug_stmt := l_sql_stmt;
221:
222: BSC_APPS.DO_DDL(l_sql_stmt,
223: ad_ddl.create_table,
224: 'BSC_D_ACCOUNT');
225:
226: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_ACCOUNT_U1 ON BSC_D_ACCOUNT (CODE,LANGUAGE)'||

Line 227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

223: ad_ddl.create_table,
224: 'BSC_D_ACCOUNT');
225:
226: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_ACCOUNT_U1 ON BSC_D_ACCOUNT (CODE,LANGUAGE)'||
227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
228: ' '||BSC_APPS.bsc_storage_clause;
229: l_debug_stmt := l_sql_stmt;
230: BSC_APPS.DO_DDL(l_sql_stmt,
231: ad_ddl.create_index,

Line 228: ' '||BSC_APPS.bsc_storage_clause;

224: 'BSC_D_ACCOUNT');
225:
226: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_ACCOUNT_U1 ON BSC_D_ACCOUNT (CODE,LANGUAGE)'||
227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
228: ' '||BSC_APPS.bsc_storage_clause;
229: l_debug_stmt := l_sql_stmt;
230: BSC_APPS.DO_DDL(l_sql_stmt,
231: ad_ddl.create_index,
232: 'BSC_D_ACCOUNT_U1');

Line 230: BSC_APPS.DO_DDL(l_sql_stmt,

226: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_ACCOUNT_U1 ON BSC_D_ACCOUNT (CODE,LANGUAGE)'||
227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
228: ' '||BSC_APPS.bsc_storage_clause;
229: l_debug_stmt := l_sql_stmt;
230: BSC_APPS.DO_DDL(l_sql_stmt,
231: ad_ddl.create_index,
232: 'BSC_D_ACCOUNT_U1');
233: -- Create View
234: l_sql_stmt := 'Create or replace view BSC_D_0_VL AS (' ||

Line 245: BSC_APPS.DO_DDL(l_sql_stmt,

241: ' FROM BSC_D_ACCOUNT '||
242: ' WHERE LANGUAGE = userenv(''LANG''))';
243:
244: l_debug_stmt := l_sql_stmt;
245: BSC_APPS.DO_DDL(l_sql_stmt,
246: ad_ddl.create_view,
247: 'BSC_D_0_VL');
248:
249: -- Create Input table

Line 260: BSC_APPS.DO_DDL(l_sql_stmt,

256: if (l_count <> 0) then
257: l_sql_stmt := 'Drop Table BSC_DI_0';
258: l_debug_stmt := l_sql_stmt;
259:
260: BSC_APPS.DO_DDL(l_sql_stmt,
261: ad_ddl.drop_table,
262: 'BSC_DI_0');
263: end if;
264:

Line 270: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||

266: 'USER_CODE Varchar2(5), ' ||
267: 'NAME Varchar2(20), '||
268: 'Typ_of_Acc_Code_Usr Varchar2(5),'||
269: 'Position Number(2))'||
270: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
271: ' '||BSC_APPS.bsc_storage_clause;
272: l_debug_stmt := l_sql_stmt;
273:
274: BSC_APPS.DO_DDL(l_sql_stmt,

Line 271: ' '||BSC_APPS.bsc_storage_clause;

267: 'NAME Varchar2(20), '||
268: 'Typ_of_Acc_Code_Usr Varchar2(5),'||
269: 'Position Number(2))'||
270: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
271: ' '||BSC_APPS.bsc_storage_clause;
272: l_debug_stmt := l_sql_stmt;
273:
274: BSC_APPS.DO_DDL(l_sql_stmt,
275: ad_ddl.create_table,

Line 274: BSC_APPS.DO_DDL(l_sql_stmt,

270: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
271: ' '||BSC_APPS.bsc_storage_clause;
272: l_debug_stmt := l_sql_stmt;
273:
274: BSC_APPS.DO_DDL(l_sql_stmt,
275: ad_ddl.create_table,
276: 'BSC_DI_0');
277:
278: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_0_U1 ON BSC_DI_0 (USER_CODE)'||

Line 279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

275: ad_ddl.create_table,
276: 'BSC_DI_0');
277:
278: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_0_U1 ON BSC_DI_0 (USER_CODE)'||
279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
280: ' '||BSC_APPS.bsc_storage_clause;
281: l_debug_stmt := l_sql_stmt;
282: BSC_APPS.DO_DDL(l_sql_stmt,
283: ad_ddl.create_index,

Line 280: ' '||BSC_APPS.bsc_storage_clause;

276: 'BSC_DI_0');
277:
278: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_0_U1 ON BSC_DI_0 (USER_CODE)'||
279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
280: ' '||BSC_APPS.bsc_storage_clause;
281: l_debug_stmt := l_sql_stmt;
282: BSC_APPS.DO_DDL(l_sql_stmt,
283: ad_ddl.create_index,
284: 'BSC_DI_0_U1');

Line 282: BSC_APPS.DO_DDL(l_sql_stmt,

278: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_0_U1 ON BSC_DI_0 (USER_CODE)'||
279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
280: ' '||BSC_APPS.bsc_storage_clause;
281: l_debug_stmt := l_sql_stmt;
282: BSC_APPS.DO_DDL(l_sql_stmt,
283: ad_ddl.create_index,
284: 'BSC_DI_0_U1');
285:
286:

Line 299: BSC_APPS.DO_DDL(l_sql_stmt,

295: if (l_count <> 0) then
296: l_sql_stmt := 'Drop Table BSC_D_SUBACCOUNT';
297: l_debug_stmt := l_sql_stmt;
298:
299: BSC_APPS.DO_DDL(l_sql_stmt,
300: ad_ddl.drop_table,
301: 'BSC_D_SUBACCOUNT');
302: end if;
303:

Line 312: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||

308: 'USER_CODE Varchar2(5), ' ||
309: 'NAME Varchar2(20), ' ||
310: 'Account_Code Number, ' ||
311: 'Account_Code_Usr Varchar2(5))'||
312: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
313: ' '||BSC_APPS.bsc_storage_clause;
314:
315: l_debug_stmt := l_sql_stmt;
316: BSC_APPS.DO_DDL(l_sql_stmt,

Line 313: ' '||BSC_APPS.bsc_storage_clause;

309: 'NAME Varchar2(20), ' ||
310: 'Account_Code Number, ' ||
311: 'Account_Code_Usr Varchar2(5))'||
312: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
313: ' '||BSC_APPS.bsc_storage_clause;
314:
315: l_debug_stmt := l_sql_stmt;
316: BSC_APPS.DO_DDL(l_sql_stmt,
317: ad_ddl.create_table,

Line 316: BSC_APPS.DO_DDL(l_sql_stmt,

312: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
313: ' '||BSC_APPS.bsc_storage_clause;
314:
315: l_debug_stmt := l_sql_stmt;
316: BSC_APPS.DO_DDL(l_sql_stmt,
317: ad_ddl.create_table,
318: 'BSC_D_SUBACCOUNT');
319:
320: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_SUBACCOUNT_U1 ON BSC_D_SUBACCOUNT (CODE,LANGUAGE)'||

Line 321: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

317: ad_ddl.create_table,
318: 'BSC_D_SUBACCOUNT');
319:
320: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_SUBACCOUNT_U1 ON BSC_D_SUBACCOUNT (CODE,LANGUAGE)'||
321: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
322: ' '||BSC_APPS.bsc_storage_clause;
323: l_debug_stmt := l_sql_stmt;
324:
325: BSC_APPS.DO_DDL(l_sql_stmt,

Line 322: ' '||BSC_APPS.bsc_storage_clause;

318: 'BSC_D_SUBACCOUNT');
319:
320: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_SUBACCOUNT_U1 ON BSC_D_SUBACCOUNT (CODE,LANGUAGE)'||
321: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
322: ' '||BSC_APPS.bsc_storage_clause;
323: l_debug_stmt := l_sql_stmt;
324:
325: BSC_APPS.DO_DDL(l_sql_stmt,
326: ad_ddl.create_index,

Line 325: BSC_APPS.DO_DDL(l_sql_stmt,

321: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
322: ' '||BSC_APPS.bsc_storage_clause;
323: l_debug_stmt := l_sql_stmt;
324:
325: BSC_APPS.DO_DDL(l_sql_stmt,
326: ad_ddl.create_index,
327: 'BSC_D_SUBACCOUNT_U1');
328:
329: -- Create View

Line 340: BSC_APPS.DO_DDL(l_sql_stmt,

336: ' FROM BSC_D_SUBACCOUNT '||
337: ' WHERE LANGUAGE = userenv(''LANG''))';
338:
339: l_debug_stmt := l_sql_stmt;
340: BSC_APPS.DO_DDL(l_sql_stmt,
341: ad_ddl.create_view,
342: 'BSC_D_1_VL');
343:
344: -- Create Input table

Line 356: BSC_APPS.DO_DDL(l_sql_stmt,

352: if (l_count <> 0) then
353: l_sql_stmt := 'Drop Table BSC_DI_1';
354: l_debug_stmt := l_sql_stmt;
355:
356: BSC_APPS.DO_DDL(l_sql_stmt,
357: ad_ddl.drop_table,
358: 'BSC_DI_1');
359: end if;
360:

Line 365: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||

361: l_sql_stmt := 'Create Table BSC_DI_1 (' ||
362: 'USER_CODE Varchar2(5), ' ||
363: 'NAME Varchar2(20), '||
364: 'Account_Code_Usr Varchar2(5))'||
365: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
366: ' '||BSC_APPS.bsc_storage_clause;
367: l_debug_stmt := l_sql_stmt;
368:
369: BSC_APPS.DO_DDL(l_sql_stmt,

Line 366: ' '||BSC_APPS.bsc_storage_clause;

362: 'USER_CODE Varchar2(5), ' ||
363: 'NAME Varchar2(20), '||
364: 'Account_Code_Usr Varchar2(5))'||
365: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
366: ' '||BSC_APPS.bsc_storage_clause;
367: l_debug_stmt := l_sql_stmt;
368:
369: BSC_APPS.DO_DDL(l_sql_stmt,
370: ad_ddl.create_table,

Line 369: BSC_APPS.DO_DDL(l_sql_stmt,

365: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
366: ' '||BSC_APPS.bsc_storage_clause;
367: l_debug_stmt := l_sql_stmt;
368:
369: BSC_APPS.DO_DDL(l_sql_stmt,
370: ad_ddl.create_table,
371: 'BSC_DI_1');
372:
373: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_1_U1 ON BSC_DI_1 (USER_CODE)'||

Line 374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

370: ad_ddl.create_table,
371: 'BSC_DI_1');
372:
373: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_1_U1 ON BSC_DI_1 (USER_CODE)'||
374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
375: ' '||BSC_APPS.bsc_storage_clause;
376: l_debug_stmt := l_sql_stmt;
377: BSC_APPS.DO_DDL(l_sql_stmt,
378: ad_ddl.create_index,

Line 375: ' '||BSC_APPS.bsc_storage_clause;

371: 'BSC_DI_1');
372:
373: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_1_U1 ON BSC_DI_1 (USER_CODE)'||
374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
375: ' '||BSC_APPS.bsc_storage_clause;
376: l_debug_stmt := l_sql_stmt;
377: BSC_APPS.DO_DDL(l_sql_stmt,
378: ad_ddl.create_index,
379: 'BSC_DI_1_U1');

Line 377: BSC_APPS.DO_DDL(l_sql_stmt,

373: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_1_U1 ON BSC_DI_1 (USER_CODE)'||
374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
375: ' '||BSC_APPS.bsc_storage_clause;
376: l_debug_stmt := l_sql_stmt;
377: BSC_APPS.DO_DDL(l_sql_stmt,
378: ad_ddl.create_index,
379: 'BSC_DI_1_U1');
380:
381: if (is_cross_template) then

Line 392: BSC_APPS.DO_DDL(l_sql_stmt,

388:
389: if (l_project_count <> 0) then
390: l_sql_stmt := 'Drop Table BSC_D_PROJECT';
391: l_debug_stmt := l_sql_stmt;
392: BSC_APPS.DO_DDL(l_sql_stmt,
393: ad_ddl.drop_table,
394: 'BSC_D_PROJECT');
395:
396: end if;

Line 406: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||

402: 'LANGUAGE Varchar2(4) NOT NULL,'||
403: 'SOURCE_LANG Varchar2(4) NOT NULL,'||
404: 'USER_CODE VARCHAR2(5),' ||
405: 'NAME VARCHAR2(20))'||
406: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
407: ' '||BSC_APPS.bsc_storage_clause;
408:
409: l_debug_stmt := l_sql_stmt;
410: BSC_APPS.DO_DDL(l_sql_stmt,

Line 407: ' '||BSC_APPS.bsc_storage_clause;

403: 'SOURCE_LANG Varchar2(4) NOT NULL,'||
404: 'USER_CODE VARCHAR2(5),' ||
405: 'NAME VARCHAR2(20))'||
406: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
407: ' '||BSC_APPS.bsc_storage_clause;
408:
409: l_debug_stmt := l_sql_stmt;
410: BSC_APPS.DO_DDL(l_sql_stmt,
411: ad_ddl.create_table,

Line 410: BSC_APPS.DO_DDL(l_sql_stmt,

406: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_table_tbs_type)||
407: ' '||BSC_APPS.bsc_storage_clause;
408:
409: l_debug_stmt := l_sql_stmt;
410: BSC_APPS.DO_DDL(l_sql_stmt,
411: ad_ddl.create_table,
412: 'BSC_D_PROJECT');
413:
414: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_PROJECT_U1 ON BSC_D_PROJECT (CODE,LANGUAGE)'||

Line 415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

411: ad_ddl.create_table,
412: 'BSC_D_PROJECT');
413:
414: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_PROJECT_U1 ON BSC_D_PROJECT (CODE,LANGUAGE)'||
415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
416: ' '||BSC_APPS.bsc_storage_clause;
417: l_debug_stmt := l_sql_stmt;
418: BSC_APPS.DO_DDL(l_sql_stmt,
419: ad_ddl.create_index,

Line 416: ' '||BSC_APPS.bsc_storage_clause;

412: 'BSC_D_PROJECT');
413:
414: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_PROJECT_U1 ON BSC_D_PROJECT (CODE,LANGUAGE)'||
415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
416: ' '||BSC_APPS.bsc_storage_clause;
417: l_debug_stmt := l_sql_stmt;
418: BSC_APPS.DO_DDL(l_sql_stmt,
419: ad_ddl.create_index,
420: 'BSC_D_PROJECT_U1');

Line 418: BSC_APPS.DO_DDL(l_sql_stmt,

414: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_PROJECT_U1 ON BSC_D_PROJECT (CODE,LANGUAGE)'||
415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
416: ' '||BSC_APPS.bsc_storage_clause;
417: l_debug_stmt := l_sql_stmt;
418: BSC_APPS.DO_DDL(l_sql_stmt,
419: ad_ddl.create_index,
420: 'BSC_D_PROJECT_U1');
421: -- Create View
422: l_sql_stmt := 'Create or replace view BSC_D_3_VL AS (' ||

Line 430: BSC_APPS.DO_DDL(l_sql_stmt,

426: ' FROM BSC_D_PROJECT '||
427: ' WHERE LANGUAGE = userenv(''LANG''))';
428:
429: l_debug_stmt := l_sql_stmt;
430: BSC_APPS.DO_DDL(l_sql_stmt,
431: ad_ddl.create_view,
432: 'BSC_D_3_VL');
433: -- Create Input table
434: l_object_type := 'BSC_DI_3' ;

Line 444: BSC_APPS.DO_DDL(l_sql_stmt,

440: if (l_count <> 0) then
441: l_sql_stmt := 'Drop Table BSC_DI_3';
442: l_debug_stmt := l_sql_stmt;
443:
444: BSC_APPS.DO_DDL(l_sql_stmt,
445: ad_ddl.drop_table,
446: 'BSC_DI_1');
447: end if;
448:

Line 452: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||

448:
449: l_sql_stmt := 'Create Table BSC_DI_3 (' ||
450: 'USER_CODE Varchar2(5), ' ||
451: 'NAME Varchar2(20))'||
452: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
453: ' '||BSC_APPS.bsc_storage_clause;
454:
455: l_debug_stmt := l_sql_stmt;
456:

Line 453: ' '||BSC_APPS.bsc_storage_clause;

449: l_sql_stmt := 'Create Table BSC_DI_3 (' ||
450: 'USER_CODE Varchar2(5), ' ||
451: 'NAME Varchar2(20))'||
452: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_table_tbs_type)||
453: ' '||BSC_APPS.bsc_storage_clause;
454:
455: l_debug_stmt := l_sql_stmt;
456:
457: BSC_APPS.DO_DDL(l_sql_stmt,

Line 457: BSC_APPS.DO_DDL(l_sql_stmt,

453: ' '||BSC_APPS.bsc_storage_clause;
454:
455: l_debug_stmt := l_sql_stmt;
456:
457: BSC_APPS.DO_DDL(l_sql_stmt,
458: ad_ddl.create_table,
459: 'BSC_DI_1');
460:
461: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_3_U1 ON BSC_DI_3 (USER_CODE)'||

Line 462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

458: ad_ddl.create_table,
459: 'BSC_DI_1');
460:
461: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_3_U1 ON BSC_DI_3 (USER_CODE)'||
462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
463: ' '||BSC_APPS.bsc_storage_clause;
464: l_debug_stmt := l_sql_stmt;
465: BSC_APPS.DO_DDL(l_sql_stmt,
466: ad_ddl.create_index,

Line 463: ' '||BSC_APPS.bsc_storage_clause;

459: 'BSC_DI_1');
460:
461: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_3_U1 ON BSC_DI_3 (USER_CODE)'||
462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
463: ' '||BSC_APPS.bsc_storage_clause;
464: l_debug_stmt := l_sql_stmt;
465: BSC_APPS.DO_DDL(l_sql_stmt,
466: ad_ddl.create_index,
467: 'BSC_DI_3_U1');

Line 465: BSC_APPS.DO_DDL(l_sql_stmt,

461: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_3_U1 ON BSC_DI_3 (USER_CODE)'||
462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
463: ' '||BSC_APPS.bsc_storage_clause;
464: l_debug_stmt := l_sql_stmt;
465: BSC_APPS.DO_DDL(l_sql_stmt,
466: ad_ddl.create_index,
467: 'BSC_DI_3_U1');
468:
469:

Line 793: l_debug_stmt := bsc_apps.get_message('BSC_ERROR_CONFIG_DIM');

789: l_num_of_family := 3;
790: end if;
791:
792: if (NOT define_dim_relations(l_num_of_levels, l_num_of_family)) then
793: l_debug_stmt := bsc_apps.get_message('BSC_ERROR_CONFIG_DIM');
794: Raise BSC_DIM_ERROR;
795: end if;
796:
797: Return(TRUE);

Line 913: BSC_APPS.Execute_Immediate(l_sql);

909: 'FEM_COMP.LOOKUP_TYPE =''BSC_UI_COMMON'' AND '||
910: 'FEM_COMP.LOOKUP_CODE = ''COMPARISON'' AND '||
911: 'FEM_DIM.LANGUAGE = FEM_ALL.LANGUAGE AND '||
912: 'FEM_COMP.LANGUAGE = FEM_ALL.LANGUAGE';
913: BSC_APPS.Execute_Immediate(l_sql);
914:
915: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVEL_COLS, Dim_level_id=' ||
916: to_char(G_Pro_Tbl(i_dimension).Dim_level_id);
917:

Line 1020: BSC_APPS.Execute_Immediate(l_sql);

1016: BSC_TEMPLATE.LOOKUP_VALUES_TABLE||' FEM_ALIAS '||
1017: 'WHERE '||
1018: 'FEM_ALIAS.LOOKUP_TYPE = ''BSC_TPLATE_TAB_DIM_GROUP_NAME'' AND '||
1019: 'FEM_ALIAS.LOOKUP_CODE = '''||G_DF_Tbl(i_dem_family).Dim_group_id||'''';
1020: BSC_APPS.Execute_Immediate(l_sql);
1021:
1022: l_debug_stmt := 'Insert Into BSC_SYS_DIM_LEVELS_BY_GROUP, ' ||
1023: ' Dim_group_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_group_id) ||
1024: ', Dim_level_id=' || to_char(G_DF_Tbl(i_dem_family).Dim_level_id);