DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_STATS

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

3095: --insert into psp_stout values(5, ' request submitted ');
3096: COMMIT;
3097:
3098: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
3099: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
3100: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
3101:
3102: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Journal Import request to complete');
3103:

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

5771: -- set the context again to multiple
5772: mo_global.set_policy_context('M', null);
5773:
5774: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
5775: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
5776: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
5777:
5778: FOR I IN 1..org_id_tab.count
5779: LOOP