APPS.IGS_AD_IMP_ACIDX_PKG dependencies on IGS_AD_ACAD_IDX_INT_ALL

Line 39: FROM igs_ad_acad_idx_int_all aii,

35: aii.nominated_course_cd,
36: aii.sequence_number,
37: aii.admission_index,
38: aii.calculation_date
39: FROM igs_ad_acad_idx_int_all aii,
40: igs_ad_acidx_hdr aih
41: WHERE aii.record_status ='2'
42: AND aih.acadindex_batch_id = p_acadindex_batch_id
43: AND aii.acadindex_batch_id = aih.acadindex_batch_id;

Line 48: FROM igs_ad_acad_idx_int_all

44:
45:
46: CURSOR c_purge (p_acadindex_batch_id NUMBER) IS
47: SELECT 'x'
48: FROM igs_ad_acad_idx_int_all
49: WHERE acadindex_batch_id = p_acadindex_batch_id;
50:
51: -- l_appl_inst_rec c_acai%ROWTYPE;
52: e_resource_busy_exception EXCEPTION;

Line 80: UPDATE igs_ad_acad_idx_int_all

76: p_error_code VARCHAR2,
77: p_acadindex_id NUMBER,
78: p_log_text VARCHAR2) AS
79: BEGIN
80: UPDATE igs_ad_acad_idx_int_all
81: SET record_status = p_rec_status,
82: error_code = p_error_code,
83: error_Text = p_log_text
84: WHERE acadindex_id = p_acadindex_id;

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

104: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1: Start of procedure');
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;

Line 147: DELETE igs_ad_acad_idx_int_all

143: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '6: If Return status ='||FND_API.G_RET_STS_UNEXP_ERROR);
144: update_int_table('3','E004',c_acai_inst_rec.acadindex_id,'IGS_GE_UNHANDLED_EXCEPTION');
145: ELSE -- Delete the successful record from Interface Table
146: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '7: If Return status = success then delete the record');
147: DELETE igs_ad_acad_idx_int_all
148: WHERE acadindex_id=c_acai_inst_rec.acadindex_id;
149: END IF;
150:
151: EXCEPTION