APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_UOFABRV_INTS

Line 354: FROM igs_uc_uofabrv_ints

350: ,abbrevtext
351: ,letterformat
352: ,summarychar
353: ,abbrevuse
354: FROM igs_uc_uofabrv_ints
355: WHERE record_status = 'N';
356:
357: -- check whether corresponding record already exists.
358: CURSOR old_uvoffabrv_cur (p_abbrev igs_uc_ref_off_abrv.abbrev_code%TYPE) IS

Line 377: l_rec_status igs_uc_uofabrv_ints.record_status%TYPE;

373: FROM igs_uc_ref_off_abrv
374: WHERE abbrev_code = p_abbrev;
375:
376: old_uvoffabrv_rec old_uvoffabrv_cur%ROWTYPE;
377: l_rec_status igs_uc_uofabrv_ints.record_status%TYPE;
378: l_uncond igs_uc_ref_off_abrv.uncond%TYPE;
379: l_withdrawal igs_uc_ref_off_abrv.withdrawal%TYPE;
380: l_char_abbrev igs_uc_ref_off_abrv.abbrev_code%TYPE;
381:

Line 523: UPDATE igs_uc_uofabrv_ints

519: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
520: -- while processing the record.
521: IF g_error_code IS NOT NULL THEN
522:
523: UPDATE igs_uc_uofabrv_ints
524: SET error_code = g_error_code
525: WHERE rowid = new_uvoffabrv_rec.rowid;
526:
527: -- log error message/meaning.

Line 534: UPDATE igs_uc_uofabrv_ints

530: -- update error count
531: g_error_rec_cnt := g_error_rec_cnt + 1;
532:
533: ELSE
534: UPDATE igs_uc_uofabrv_ints
535: SET record_status = l_rec_status,
536: error_code = NULL
537: WHERE rowid = new_uvoffabrv_rec.rowid;
538: