DBA Data[Home] [Help]

APPS.JTF_RS_DBI_CONC_PUB dependencies on BIS_COMMON_PARAMETERS

Line 237: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism

233: END IF;
234:
235: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
236: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
237: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism
238: ||': Partition= '||l_partition);
239:
240: -- Truncate Table Partitions
241: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS TRUNCATE PARTITION '||l_partition ;

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

332: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS '||
333: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
334:
335: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
336: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'ALL',cascade=>TRUE);
337:
338: -- first time login child groups
339: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_dbi_denorm_res_groups a
340: (VALUE,

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

665: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS '||
666: ' MODIFY PARTITION '||l_partition||' REBUILD UNUSABLE LOCAL INDEXES ';
667:
668: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
669: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
670:
671: BIS_COLLECTION_UTILITIES.wrapup(
672: p_status => TRUE ,
673: p_count => l_insert_count,