APPS.JTF_RS_ACTIVE_REC_CONC_PUB dependencies on FND_STATS

Line 30: FND_STATS.GATHER_COLUMN_STATS, which are added

26: RGOKAVAR 13-AUG-2008 Bug 6800249: Changing Insert statement into
27: jtf_rs_grp_den_ltst_rel_1_tmp Table to Improve
28: Performance.
29: RGOKAVAR 06-FEB-2009 Bug 8220580: Revert the changes in
30: FND_STATS.GATHER_COLUMN_STATS, which are added
31: in Bug7587760.
32:
33:
34: Usage Note: For table JTF_RS_GROUPS_DENORM, there are 2 columns populated

Line 276: --FND_STATS.GATHER_TABLE_STATS(ownname=>'JTF'

272: END;
273:
274: -- commenting out code on 02/18/2004 because 8i does not support gathering stats
275: -- on Temporary Tables.
276: --FND_STATS.GATHER_TABLE_STATS(ownname=>'JTF'
277: -- ,tabname=>'JTF_RS_GRP_DEN_LTST_REL_2_TMP'
278: -- );
279:
280: -- do the real update of table if anything is there to be updated

Line 363: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu

359: Instead of gathering stats on tables, will do it directly for column,
360: so that it performs faster, that too only if columns are updated.
361: As per perf team guidelines "percent" should be 10% */
362:
363: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu
364: -- ,tabname=>'JTF_RS_GROUPS_DENORM'
365: -- );
366:
367: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu

Line 367: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu

363: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu
364: -- ,tabname=>'JTF_RS_GROUPS_DENORM'
365: -- );
366:
367: --FND_STATS.GATHER_TABLE_STATS(ownname=> l_jtfu
368: -- ,tabname=>'JTF_RS_ROLE_RELATIONS'
369: -- );
370:
371: IF (l_den_update_count > 0) THEN

Line 373: /* FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,

369: -- );
370:
371: IF (l_den_update_count > 0) THEN
372:
373: /* FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,
374: tabname => 'JTF_RS_GROUPS_DENORM',
375: colname => 'LATEST_RELATIONSHIP_FLAG',
376: percent => 10,
377: degree => null,

Line 384: FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,

380: partname => null,
381: hmode => 'FULL'
382: );
383: */
384: FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,
385: tabname => 'JTF_RS_GROUPS_DENORM',
386: colname => 'LATEST_RELATIONSHIP_FLAG',
387: percent => 10
388: );

Line 392: /* FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,

388: );
389: END IF;
390:
391: IF (l_role_update_count > 0) THEN
392: /* FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,
393: tabname => 'JTF_RS_ROLE_RELATIONS',
394: colname => 'ACTIVE_FLAG',
395: percent => 10,
396: degree => null,

Line 403: FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,

399: partname => null,
400: hmode => 'FULL'
401: );
402: */
403: FND_STATS.GATHER_COLUMN_STATS(ownname => l_jtfu,
404: tabname => 'JTF_RS_ROLE_RELATIONS',
405: colname => 'ACTIVE_FLAG',
406: percent => 10
407: );