APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CRAWDBD_INTS

Line 220: FROM igs_uc_crawdbd_ints

216: ,sitting
217: ,awardingbody
218: ,bodyname
219: ,bodyabbrev
220: FROM igs_uc_crawdbd_ints
221: WHERE record_status = 'N';
222:
223: -- check whether corresponding record already exists.
224: CURSOR old_awdbdy_cur (p_year igs_uc_ref_awrdbdy.year%TYPE,

Line 334: UPDATE igs_uc_crawdbd_ints

330:
331: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
332: -- while processing the record.
333: IF g_error_code IS NOT NULL THEN
334: UPDATE igs_uc_crawdbd_ints
335: SET error_code = g_error_code
336: WHERE rowid = new_awdbdy_rec.rowid;
337:
338: -- log error message/meaning.

Line 344: UPDATE igs_uc_crawdbd_ints

340: -- update error count
341: g_error_rec_cnt := g_error_rec_cnt + 1;
342:
343: ELSE
344: UPDATE igs_uc_crawdbd_ints
345: SET record_status = 'D',
346: error_code = NULL
347: WHERE rowid = new_awdbdy_rec.rowid;
348: