DBA Data[Home] [Help]

APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on FND_STATS

Line 1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);

1020: -- by rrengara on 20-jan-2003 bug 2711176
1021:
1022: BEGIN
1023: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);
1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);
1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);
1027: EXCEPTION WHEN OTHERS THEN
1028: NULL;

Line 1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);

1021:
1022: BEGIN
1023: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);
1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);
1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);
1027: EXCEPTION WHEN OTHERS THEN
1028: NULL;
1029: END;

Line 1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);

1022: BEGIN
1023: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
1024: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_BATCH', cascade => TRUE);
1025: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_INT', cascade => TRUE);
1026: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_OFFRESP_ERR', cascade => TRUE);
1027: EXCEPTION WHEN OTHERS THEN
1028: NULL;
1029: END;
1030: