APPS.IGS_AD_IMP_ACIDX_PKG dependencies on IGS_AD_ACIDX_HDR_ALL

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

105: BEGIN
106: l_gather_return := fnd_installation.get_app_info('IGS', l_gather_status, l_industry, l_schema);
107:
108: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_ACAD_IDX_INT_ALL', cascade => TRUE);
109: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema, tabname => 'IGS_AD_ACIDX_HDR_ALL', cascade => TRUE);
110: EXCEPTION WHEN OTHERS THEN
111: NULL;
112: END;
113: --FND_FILE.PUT_LINE(FND_FILE.LOG, '2: After gathering statistics');

Line 163: DELETE igs_ad_acidx_hdr_all

159: --FND_FILE.PUT_LINE(FND_FILE.LOG, '9: Before purging the parent record');
160: OPEN c_purge(p_acadindex_batch_id);
161: FETCH c_purge INTO l_purge;
162: IF c_purge%NOTFOUND THEN
163: DELETE igs_ad_acidx_hdr_all
164: WHERE acadindex_batch_id = p_acadindex_batch_id;
165: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_REC_DELETED');
166: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET||' - '||p_acadindex_batch_id);
167: END IF;