APPS.PMI_LOT_GENEALOGY_PKG dependencies on FND_STATS

Line 22: 08-Feb-2002 P. Dong Add call to fnd_stats.gather_table_stats

18: genealogies should be removed or added for entire doc.
19: Date param removed from add and remove _current_genealogy
20: 13-Jun-2000 P. Dong Put getting and setting of last_refresh_date into indiv
21: code units, in anticipation of change of access meth.
22: 08-Feb-2002 P. Dong Add call to fnd_stats.gather_table_stats
23: */
24: transaction_duration CONSTANT NUMBER := 1/24/60; -- in minutes
25: datetime_format CONSTANT VARCHAR2(32) := 'DD-MON-YYYY HH24:MI:SS';
26:

Line 258: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_LOT_GENEALOGY');

254: END LOOP;
255: SELECT TABLE_OWNER INTO l_table_owner
256: FROM USER_SYNONYMS
257: WHERE SYNONYM_NAME = 'PMI_LOT_GENEALOGY';
258: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_LOT_GENEALOGY');
259:
260: set_last_refresh_date(lv_current_refresh_date);
261:
262: COMMIT;