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_PMD_OPT_DOC_UTIL dependencies on BSC_PMD_OPT_DOC_UTIL

Line 1: PACKAGE BODY BSC_PMD_OPT_DOC_UTIL AS

1: PACKAGE BODY BSC_PMD_OPT_DOC_UTIL AS
2: /* $Header: BSCPDGB.pls 120.6 2006/04/18 15:43:12 calaw noship $ */
3:
4: G_BSC_SCHEMA VARCHAR2(100) := BSC_APPS.get_user_schema('BSC');
5: G_APPS_SCHEMA VARCHAR2(100) := BSC_APPS.get_user_schema('APPS');

Line 24: --IF (FND_LOG.TEST(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL')) THEN

20: IS
21: BEGIN
22: --DBMS_OUTPUT.PUT_LINE(TEXT);
23: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
24: --IF (FND_LOG.TEST(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL')) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL',TEXT);
26: END IF;
27: END;
28:

Line 25: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL',TEXT);

21: BEGIN
22: --DBMS_OUTPUT.PUT_LINE(TEXT);
23: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
24: --IF (FND_LOG.TEST(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL')) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_BSC_SCHEMA||'.BSC_PMD_OPT_DOC_UTIL',TEXT);
26: END IF;
27: END;
28:
29: Procedure POPULATE_DISPLAY_TYPE

Line 247: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(t1.table_name) table_name_display, k.source_table_name source_table_name_display, t1.relation_type

243:
244: PROCEDURE MAKE_T_COLLAPSE_AND_COPY
245: IS
246: l_stmt varchar2(32767):= '
247: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(t1.table_name) table_name_display, k.source_table_name source_table_name_display, t1.relation_type
248: from '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP t1, '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP k
249: where t1.source_table_name in (
250: select t2.table_name
251: from '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP t2

Line 258: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(t1.table_name) is not null

254: and t2.table_name like ''BSC_T%''
255: )
256: and t1.TABLE_NAME like ''BSC_S_%''
257: and k.source_table_name like ''BSC_B%''
258: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(t1.table_name) is not null
259: union
260: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(t1.table_name) table_name_display, k.source_table_name source_table_name_display, t1.relation_type
261: from '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP t1, '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP k
262: where t1.source_table_name in (

Line 260: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(t1.table_name) table_name_display, k.source_table_name source_table_name_display, t1.relation_type

256: and t1.TABLE_NAME like ''BSC_S_%''
257: and k.source_table_name like ''BSC_B%''
258: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(t1.table_name) is not null
259: union
260: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(t1.table_name) table_name_display, k.source_table_name source_table_name_display, t1.relation_type
261: from '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP t1, '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP k
262: where t1.source_table_name in (
263: select t2.table_name
264: from '||G_BSC_SCHEMA||'.BSC_T_COLLAPSE_TEMP t2

Line 289: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPLAY

285: and TABLE_NAME not like ''BSC_S%''
286: and TABLE_NAME not like ''BSC_T%''
287: and relation_type = 0
288: union
289: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPLAY
290: , SOURCE_TABLE_NAME SOURCE_TABLE_NAME_DISPLAY, relation_type from bsc_db_tables_rels
291: where
292: SOURCE_TABLE_NAME like ''BSC_B%''
293: and TABLE_NAME like ''BSC_S_%''

Line 295: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null

291: where
292: SOURCE_TABLE_NAME like ''BSC_B%''
293: and TABLE_NAME like ''BSC_S_%''
294: and TABLE_NAME not like ''BSC_SB_%''
295: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
296: and relation_type = 0
297: union
298: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPLAY
299: , SOURCE_TABLE_NAME SOURCE_TABLE_NAME_DISPLAY, relation_type from bsc_db_tables_rels

Line 298: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPLAY

294: and TABLE_NAME not like ''BSC_SB_%''
295: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
296: and relation_type = 0
297: union
298: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPLAY
299: , SOURCE_TABLE_NAME SOURCE_TABLE_NAME_DISPLAY, relation_type from bsc_db_tables_rels
300: where
301: SOURCE_TABLE_NAME like ''BSC_B%''
302: and TABLE_NAME like ''BSC_SB_%''

Line 303: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) is not null

299: , SOURCE_TABLE_NAME SOURCE_TABLE_NAME_DISPLAY, relation_type from bsc_db_tables_rels
300: where
301: SOURCE_TABLE_NAME like ''BSC_B%''
302: and TABLE_NAME like ''BSC_SB_%''
303: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) is not null
304: and relation_type = 0
305: ';
306: BEGIN
307: l_stmt:='insert into ' || G_REL_DISPLAY_TABLE || l_stmt ;

Line 316: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPALY,

312: PROCEDURE GEN_SB2S_OR_SB2S_DISPLAY
313: IS
314: l_stmt varchar2(32767):= '
315: select distinct
316: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPALY,
317: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,
318: RELATION_TYPE
319: from bsc_db_tables_rels
320: where source_table_name like ''BSC_SB_%''

Line 317: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,

313: IS
314: l_stmt varchar2(32767):= '
315: select distinct
316: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_NAME_DISPALY,
317: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,
318: RELATION_TYPE
319: from bsc_db_tables_rels
320: where source_table_name like ''BSC_SB_%''
321: and table_name like ''BSC_SB_%''

Line 322: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) <>

318: RELATION_TYPE
319: from bsc_db_tables_rels
320: where source_table_name like ''BSC_SB_%''
321: and table_name like ''BSC_SB_%''
322: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) <>
323: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME)
324: union
325: select distinct
326: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPALY,

Line 323: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME)

319: from bsc_db_tables_rels
320: where source_table_name like ''BSC_SB_%''
321: and table_name like ''BSC_SB_%''
322: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) <>
323: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME)
324: union
325: select distinct
326: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPALY,
327: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,

Line 326: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPALY,

322: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) <>
323: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME)
324: union
325: select distinct
326: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPALY,
327: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,
328: RELATION_TYPE
329: from bsc_db_tables_rels
330: where source_table_name like ''BSC_SB_%''

Line 327: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,

323: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME)
324: union
325: select distinct
326: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_NAME_DISPALY,
327: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(SOURCE_TABLE_NAME) SOURCE_TABLE_NAME_DISPALY,
328: RELATION_TYPE
329: from bsc_db_tables_rels
330: where source_table_name like ''BSC_SB_%''
331: and table_name like ''BSC_S_%''

Line 332: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null

328: RELATION_TYPE
329: from bsc_db_tables_rels
330: where source_table_name like ''BSC_SB_%''
331: and table_name like ''BSC_S_%''
332: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
333: ';
334: BEGIN
335: l_stmt:='insert into ' || G_REL_DISPLAY_TABLE || l_stmt ;
336: execute immediate l_stmt;

Line 343: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) table_name_display,

339:
340: PROCEDURE GEN_S2S_DISPLAY
341: IS
342: l_stmt varchar2(32767):= '
343: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) table_name_display,
344: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name) source_table_name_display,
345: relation_type
346: from bsc_db_tables_rels
347: where

Line 344: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name) source_table_name_display,

340: PROCEDURE GEN_S2S_DISPLAY
341: IS
342: l_stmt varchar2(32767):= '
343: select distinct BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) table_name_display,
344: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name) source_table_name_display,
345: relation_type
346: from bsc_db_tables_rels
347: where
348: SOURCE_TABLE_NAME like ''BSC_S_%''

Line 350: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) <>

346: from bsc_db_tables_rels
347: where
348: SOURCE_TABLE_NAME like ''BSC_S_%''
349: and TABLE_NAME like ''BSC_S_%''
350: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) <>
351: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name)
352: and relation_type = 0
353: ';
354: BEGIN

Line 351: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name)

347: where
348: SOURCE_TABLE_NAME like ''BSC_S_%''
349: and TABLE_NAME like ''BSC_S_%''
350: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) <>
351: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(source_table_name)
352: and relation_type = 0
353: ';
354: BEGIN
355: l_stmt:='insert into ' || G_REL_DISPLAY_TABLE || l_stmt ;

Line 363: select distinct BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(table_name) table_name_display,

359:
360: PROCEDURE GEN_ZMV_DISPLAY
361: IS
362: l_stmt varchar2(32767):= '
363: select distinct BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(table_name) table_name_display,
364: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) source_table_name_display,
365: null relation_type
366: from bsc_db_tables
367: where

Line 364: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) source_table_name_display,

360: PROCEDURE GEN_ZMV_DISPLAY
361: IS
362: l_stmt varchar2(32767):= '
363: select distinct BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(table_name) table_name_display,
364: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(table_name) source_table_name_display,
365: null relation_type
366: from bsc_db_tables
367: where
368: TABLE_NAME like ''BSC_S_%''

Line 369: and BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(table_name) is not null

365: null relation_type
366: from bsc_db_tables
367: where
368: TABLE_NAME like ''BSC_S_%''
369: and BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(table_name) is not null
370: ';
371: BEGIN
372: l_stmt:='insert into ' || G_REL_DISPLAY_TABLE || l_stmt ;
373: execute immediate l_stmt;

Line 389: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,

385: from bsc_db_tables
386: where ( TABLE_NAME like ''BSC_I_%'' OR TABLE_NAME like ''BSC_B_%'' OR TABLE_NAME like ''BSC_DI_%'' )
387: union /* for _MV*/
388: select
389: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,
390: TABLE_TYPE,
391: null DISPLAY_TYPE,
392: o.object_type PHYSICAL_TYPE
393: from bsc_db_tables, all_objects o

Line 398: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null

394: where o.owner in (:1, :2)
395: and o.object_type in (''VIEW'', ''MATERIALIZED VIEW'')
396: and TABLE_TYPE = 1
397: and TABLE_NAME like ''BSC_S_%''
398: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
399: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
400: union /* for _ZMV*/
401: select
402: BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,

Line 399: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)

395: and o.object_type in (''VIEW'', ''MATERIALIZED VIEW'')
396: and TABLE_TYPE = 1
397: and TABLE_NAME like ''BSC_S_%''
398: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
399: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
400: union /* for _ZMV*/
401: select
402: BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,
403: TABLE_TYPE,

Line 402: BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,

398: and BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME) is not null
399: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
400: union /* for _ZMV*/
401: select
402: BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) TABLE_DISPLAY,
403: TABLE_TYPE,
404: null DISPLAY_TYPE,
405: o.object_type PHYSICAL_TYPE
406: from bsc_db_tables, all_objects o

Line 409: and BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) is not null

405: o.object_type PHYSICAL_TYPE
406: from bsc_db_tables, all_objects o
407: where TABLE_TYPE =1
408: and TABLE_NAME like ''BSC_S_%''
409: and BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) is not null
410: and o.owner in (:3, :4)
411: and o.object_type in (''VIEW'', ''MATERIALIZED VIEW'')
412: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
413: union /* for SB tables*/

Line 412: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)

408: and TABLE_NAME like ''BSC_S_%''
409: and BSC_PMD_OPT_DOC_UTIL.GET_ZMV_BY_STABLE(TABLE_NAME) is not null
410: and o.owner in (:3, :4)
411: and o.object_type in (''VIEW'', ''MATERIALIZED VIEW'')
412: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
413: union /* for SB tables*/
414: select
415: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_DISPLAY,
416: TABLE_TYPE,

Line 415: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_DISPLAY,

411: and o.object_type in (''VIEW'', ''MATERIALIZED VIEW'')
412: and o.object_name = BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_STABLE(TABLE_NAME)
413: union /* for SB tables*/
414: select
415: BSC_PMD_OPT_DOC_UTIL.GET_MV_BY_SBTABLE(TABLE_NAME) TABLE_DISPLAY,
416: TABLE_TYPE,
417: null DISPLAY_TYPE,
418: ''TABLE'' PHYSICAL_TYPE
419: from bsc_db_tables

Line 510: END BSC_PMD_OPT_DOC_UTIL;

506:
507: COMMIT;
508: END;
509:
510: END BSC_PMD_OPT_DOC_UTIL;