DBA Data[Home] [Help]

APPS.GR_COVER_LETTERS_B_PKG dependencies on GR_COVER_LETTERS_TL

Line 637: FROM gr_cover_letters_tl clt

633:
634: CURSOR c_get_letter_text
635: IS
636: SELECT COUNT(*)
637: FROM gr_cover_letters_tl clt
638: WHERE clt.cover_letter_id = p_cover_letter_id;
639:
640:
641: BEGIN

Line 655: l_msg_data := l_msg_data || ' gr_cover_letters_tl';

651: OPEN c_get_letter_text;
652: FETCH c_get_letter_text INTO l_record_count;
653: IF l_record_count <> 0 THEN
654: l_return_status := 'E';
655: l_msg_data := l_msg_data || ' gr_cover_letters_tl';
656: END IF;
657: CLOSE c_get_letter_text;
658: IF l_return_status <> 'S' THEN
659: RAISE INTEGRITY_ERROR;