DBA Data[Home] [Help]

APPS.AZ_DELETE dependencies on FND_PROFILE

Line 16: COMMIT_BATCH_SIZE := FND_PROFILE.VALUE('AZ_COMMIT_ROWCOUNT');

12: v_id_list TYP_NEST_TAB_NUMBER;
13:
14: BEGIN
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||