DBA Data[Home] [Help]

APPS.AZ_DELETE dependencies on FND_STATS

Line 19: FND_STATS.GATHER_TABLE_STATS('AZ',p_table_name);

15: EXECUTE IMMEDIATE 'ALTER SESSION SET CURSOR_SHARING=''SIMILAR''';
16: COMMIT_BATCH_SIZE := FND_PROFILE.VALUE('AZ_COMMIT_ROWCOUNT');
17: COMMIT_BATCH_SIZE := COMMIT_BATCH_SIZE*2; --can take more records for deletion
18: --gather stats on the table from which the records are to be deleted
19: FND_STATS.GATHER_TABLE_STATS('AZ',p_table_name);
20: execute immediate 'select distinct(source) from '||p_table_name||
21: ' where request_id='||p_request_id
22: BULK COLLECT INTO v_source_list;
23:

Line 44: FND_STATS.GATHER_TABLE_STATS('AZ',p_table_name);

40:
41: WHEN OTHERS THEN
42: raise_application_error(-20001,
43: 'Error occurred while deleting records for request id:'||p_request_id);
44: FND_STATS.GATHER_TABLE_STATS('AZ',p_table_name);
45: END delete_all;
46:
47:
48: -- procedure to delete all the records for a given source