APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_IFRMQUL_INTS

Line 7145: FROM igs_uc_ifrmqul_ints ivfq

7141: -- get the records from interface tables where status is NEW.
7142: CURSOR new_ivfrmqual_cur IS
7143: SELECT ivfq.rowid,
7144: ivfq.*
7145: FROM igs_uc_ifrmqul_ints ivfq
7146: WHERE ivfq.record_status = 'N';
7147:
7148: -- check for corresponding record in main table.
7149: CURSOR old_frmqual_cur(p_appno igs_uc_form_quals.app_no%TYPE,

Line 7289: UPDATE igs_uc_ifrmqul_ints

7285: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
7286: -- while processing the record.
7287: IF g_error_code IS NOT NULL THEN
7288:
7289: UPDATE igs_uc_ifrmqul_ints
7290: SET error_code = g_error_code
7291: WHERE rowid = new_ivfrmqual_rec.rowid;
7292:
7293: -- log error message/meaning.

Line 7301: UPDATE igs_uc_ifrmqul_ints

7297: g_error_rec_cnt := g_error_rec_cnt + 1;
7298:
7299: ELSE
7300:
7301: UPDATE igs_uc_ifrmqul_ints
7302: SET record_status = 'D',
7303: error_code = NULL
7304: WHERE rowid = new_ivfrmqual_rec.rowid;
7305: