DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on FND_STATS

Line 90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');

86: END IF;
87:
88: -- Bug 6118274
89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
92: -- Bug 6118274
93:
94: -- Check the target system status and do the tieback

Line 1373: FND_STATS.Gather_Table_Stats (ownname => 'GL',

1369:
1370: -- Gather the table statistics here ...
1371:
1372: begin
1373: FND_STATS.Gather_Table_Stats (ownname => 'GL',
1374: tabname => 'GL_INTERFACE');
1375: -- percent => 10,
1376: -- tmode => 'TEMPORARY');
1377: -- Above two parameters commented out for bug fix 2476829

Line 3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');

3641: BEGIN
3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:
3649: open pc_batch_cur;