DBA Data[Home] [Help]

APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_REF_KEYWORDS

Line 547: FROM igs_uc_ref_keywords

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

Line 590: igs_uc_ref_keywords_pkg.insert_row --IGSXI29B.pls

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'

Line 606: igs_uc_ref_keywords_pkg.update_row --IGSXI29B.pls

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'