APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CRKYWD_INTS

Line 541: FROM igs_uc_crkywd_ints

537: -- Get new interface records
538: CURSOR int_refkwd_cur IS
539: SELECT rowid,
540: keyword
541: FROM igs_uc_crkywd_ints
542: WHERE record_status = 'N';
543:
544: -- check whether corresponding record already exists.
545: CURSOR old_refkwd_cur (p_keyword igs_uc_crkywd_ints.keyword%TYPE) IS

Line 545: CURSOR old_refkwd_cur (p_keyword igs_uc_crkywd_ints.keyword%TYPE) IS

541: FROM igs_uc_crkywd_ints
542: WHERE record_status = 'N';
543:
544: -- check whether corresponding record already exists.
545: CURSOR old_refkwd_cur (p_keyword igs_uc_crkywd_ints.keyword%TYPE) IS
546: SELECT rowid
547: FROM igs_uc_ref_keywords
548: WHERE keyword = p_keyword ;
549:

Line 640: UPDATE igs_uc_crkywd_ints

636:
637: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
638: -- while processing the record.
639: IF g_error_code IS NOT NULL THEN
640: UPDATE igs_uc_crkywd_ints
641: SET error_code = g_error_code
642: WHERE rowid = new_refkwd_rec.rowid;
643:
644: -- log error message/meaning.

Line 650: UPDATE igs_uc_crkywd_ints

646: -- update error count
647: g_error_rec_cnt := g_error_rec_cnt + 1;
648:
649: ELSE
650: UPDATE igs_uc_crkywd_ints
651: SET record_status = 'D',
652: error_code = NULL
653: WHERE rowid = new_refkwd_rec.rowid;
654: