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:
550: BEGIN
551: -- initialize variables
586:
587: -- If not found then insert
588: IF l_rowid IS NULL THEN
589: BEGIN
590: igs_uc_ref_keywords_pkg.insert_row --IGSXI29B.pls
591: (
592: x_rowid => l_rowid
593: ,x_keyword => new_refkwd_rec.keyword
594: ,x_imported => 'Y'
602: END;
603:
604: ELSE -- update
605: BEGIN
606: igs_uc_ref_keywords_pkg.update_row --IGSXI29B.pls
607: (
608: x_rowid => l_rowid
609: ,x_keyword => new_refkwd_rec.keyword
610: ,x_imported => 'Y'