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.JTF_RS_DBI_8I_CONC_PUB dependencies on BIS_COMMON_PARAMETERS

Line 115: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism);

111: END;
112:
113: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
114: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
115: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism);
116:
117: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS';
118:
119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;

Line 144: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'GLOBAL',cascade=>TRUE);

140:
141: COMMIT;
142:
143: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
144: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'GLOBAL',cascade=>TRUE);
145:
146: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS' ;
147:
148: -- Can drop index only if it exists

Line 479: ||' NOLOGGING PARALLEL (DEGREE '||bis_common_parameters.get_degree_of_parallelism||' ) ';

475: EXECUTE IMMEDIATE 'CREATE INDEX '||l_index_owner
476: ||'.JTF_RS_DBI_DENORM_RES_GRPS_N1 ON '
477: ||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS (current_id, user_id, id) '
478: ||' TABLESPACE '||l_index_tblspace
479: ||' NOLOGGING PARALLEL (DEGREE '||bis_common_parameters.get_degree_of_parallelism||' ) ';
480:
481: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
482: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
483:

Line 482: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);

478: ||' TABLESPACE '||l_index_tblspace
479: ||' NOLOGGING PARALLEL (DEGREE '||bis_common_parameters.get_degree_of_parallelism||' ) ';
480:
481: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
482: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
483:
484: ---------Commented out this code on 18th Feb 04 by NSINGHAI ------------------
485: -- we do not need first time login
486: -- child groups any more because, all teams will query the function

Line 547: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);

543:
544: COMMIT;
545:
546: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
547: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
548:
549: */
550:
551: SELECT COUNT(*)