eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_PHRASES_TL_PKG dependencies on GR_PHRASES_TL

Line 1: PACKAGE BODY GR_PHRASES_TL_PKG AS

1: PACKAGE BODY GR_PHRASES_TL_PKG AS
2: /*$Header: GRHIPHTB.pls 115.12 2002/10/28 19:54:36 methomas ship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 158: INSERT INTO gr_phrases_tl

154: IF FND_API.To_Boolean(l_key_exists) THEN
155: RAISE Item_Exists_Error;
156: END IF;
157:
158: INSERT INTO gr_phrases_tl
159: (phrase_code,
160: language,
161: source_lang,
162: key_word1,

Line 489: UPDATE gr_phrases_tl

485:
486: IF l_return_status <> 'S' THEN
487: RAISE Foreign_Key_Error;
488: ELSE
489: UPDATE gr_phrases_tl
490: SET phrase_code = p_phrase_code,
491: language = p_language,
492: source_lang = p_source_lang,
493: key_word1 = p_key_word1,

Line 617: L_BASE_DESC GR_PHRASES_TL.phrase_text%TYPE;

613:
614: L_RETURN_STATUS VARCHAR2(1) := 'S';
615: L_MSG_DATA VARCHAR2(2000);
616: L_MSG_TOKEN VARCHAR2(100);
617: L_BASE_DESC GR_PHRASES_TL.phrase_text%TYPE;
618: L_LANGUAGE VARCHAR2(4);
619: L_CREATION_DATE DATE;
620: L_LAST_UPDATE_DATE DATE;
621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;

Line 621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;

617: L_BASE_DESC GR_PHRASES_TL.phrase_text%TYPE;
618: L_LANGUAGE VARCHAR2(4);
619: L_CREATION_DATE DATE;
620: L_LAST_UPDATE_DATE DATE;
621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;
622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;

Line 622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;

618: L_LANGUAGE VARCHAR2(4);
619: L_CREATION_DATE DATE;
620: L_LAST_UPDATE_DATE DATE;
621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;
622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;

Line 623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;

619: L_CREATION_DATE DATE;
620: L_LAST_UPDATE_DATE DATE;
621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;
622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;

Line 624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;

620: L_LAST_UPDATE_DATE DATE;
621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;
622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;

Line 625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;

621: L_KEY_WORD1 GR_PHRASES_TL.key_word1%TYPE;
622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;

Line 626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;

622: L_KEY_WORD2 GR_PHRASES_TL.key_word2%TYPE;
623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;

Line 627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;

623: L_KEY_WORD3 GR_PHRASES_TL.key_word3%TYPE;
624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;

Line 628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;

624: L_KEY_WORD4 GR_PHRASES_TL.key_word4%TYPE;
625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;

Line 629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;

625: L_KEY_WORD5 GR_PHRASES_TL.key_word5%TYPE;
626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;

Line 630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;

626: L_KEY_WORD6 GR_PHRASES_TL.key_word6%TYPE;
627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;

Line 631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;

627: L_PRINT_FONT GR_PHRASES_TL.print_font%TYPE;
628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;

Line 632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;

628: L_IMAGE_PATHNAME GR_PHRASES_TL.image_pathname%TYPE;
629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;

Line 633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;

629: L_IMAGE_PRINT_LOCATION GR_PHRASES_TL.image_print_location%TYPE;
630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;

Line 634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;

630: L_ATTRIBUTE_CATEGORY GR_PHRASES_TL.attribute_category%TYPE;
631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;

Line 635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;

631: L_ATTRIBUTE1 GR_PHRASES_TL.attribute1%TYPE;
632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;

Line 636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;

632: L_ATTRIBUTE2 GR_PHRASES_TL.attribute2%TYPE;
633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;

Line 637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;

633: L_ATTRIBUTE3 GR_PHRASES_TL.attribute3%TYPE;
634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;

Line 638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;

634: L_ATTRIBUTE4 GR_PHRASES_TL.attribute4%TYPE;
635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;

Line 639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;

635: L_ATTRIBUTE5 GR_PHRASES_TL.attribute5%TYPE;
636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;

Line 640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;

636: L_ATTRIBUTE6 GR_PHRASES_TL.attribute6%TYPE;
637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;

Line 641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;

637: L_ATTRIBUTE7 GR_PHRASES_TL.attribute7%TYPE;
638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;

Line 642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;

638: L_ATTRIBUTE8 GR_PHRASES_TL.attribute8%TYPE;
639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;

Line 643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;

639: L_ATTRIBUTE9 GR_PHRASES_TL.attribute9%TYPE;
640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;

Line 644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;

640: L_ATTRIBUTE10 GR_PHRASES_TL.attribute10%TYPE;
641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;

Line 645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;

641: L_ATTRIBUTE11 GR_PHRASES_TL.attribute11%TYPE;
642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;

Line 646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;

642: L_ATTRIBUTE12 GR_PHRASES_TL.attribute12%TYPE;
643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;

Line 647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;

643: L_ATTRIBUTE13 GR_PHRASES_TL.attribute13%TYPE;
644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;

Line 648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;

644: L_ATTRIBUTE14 GR_PHRASES_TL.attribute14%TYPE;
645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;

Line 649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;

645: L_ATTRIBUTE15 GR_PHRASES_TL.attribute15%TYPE;
646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;

Line 650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;

646: L_ATTRIBUTE16 GR_PHRASES_TL.attribute16%TYPE;
647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;

Line 651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;

647: L_ATTRIBUTE17 GR_PHRASES_TL.attribute17%TYPE;
648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;

Line 652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;

648: L_ATTRIBUTE18 GR_PHRASES_TL.attribute18%TYPE;
649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;

Line 653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;

649: L_ATTRIBUTE19 GR_PHRASES_TL.attribute19%TYPE;
650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;

Line 654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;

650: L_ATTRIBUTE20 GR_PHRASES_TL.attribute20%TYPE;
651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;

Line 655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;

651: L_ATTRIBUTE21 GR_PHRASES_TL.attribute21%TYPE;
652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;

Line 656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;

652: L_ATTRIBUTE22 GR_PHRASES_TL.attribute22%TYPE;
653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;
660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;

Line 657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;

653: L_ATTRIBUTE23 GR_PHRASES_TL.attribute23%TYPE;
654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;
660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;
661:

Line 658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;

654: L_ATTRIBUTE24 GR_PHRASES_TL.attribute24%TYPE;
655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;
660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;
661:
662: /* Number Variables */

Line 659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;

655: L_ATTRIBUTE25 GR_PHRASES_TL.attribute25%TYPE;
656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;
660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;
661:
662: /* Number Variables */
663:

Line 660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;

656: L_ATTRIBUTE26 GR_PHRASES_TL.attribute26%TYPE;
657: L_ATTRIBUTE27 GR_PHRASES_TL.attribute27%TYPE;
658: L_ATTRIBUTE28 GR_PHRASES_TL.attribute28%TYPE;
659: L_ATTRIBUTE29 GR_PHRASES_TL.attribute29%TYPE;
660: L_ATTRIBUTE30 GR_PHRASES_TL.attribute30%TYPE;
661:
662: /* Number Variables */
663:
664: L_ORACLE_ERROR NUMBER;

Line 726: FROM gr_phrases_tl pht

722: pht.creation_date,
723: pht.last_updated_by,
724: pht.last_update_date,
725: pht.last_update_login
726: FROM gr_phrases_tl pht
727: WHERE pht.phrase_code = p_phrase_code
728: AND pht.language = l_language;
729: PhraseDesc c_get_descs%ROWTYPE;
730:

Line 751: delete from GR_PHRASES_TL T

747: l_msg_token := p_phrase_code || ' ' || p_language;
748:
749: /* Remove translations with no base row */
750:
751: delete from GR_PHRASES_TL T
752: where not exists
753: (select NULL
754: from GR_PHRASES_B B
755: where B.PHRASE_CODE = T.PHRASE_CODE

Line 760: update gr_phrases_tl t set (

756: );
757:
758: /* Redefault translations from the source language */
759:
760: update gr_phrases_tl t set (
761: phrase_text ) =
762: ( select
763: B.PHRASE_TEXT
764: from GR_PHRASES_TL B

Line 764: from GR_PHRASES_TL B

760: update gr_phrases_tl t set (
761: phrase_text ) =
762: ( select
763: B.PHRASE_TEXT
764: from GR_PHRASES_TL B
765: where B.PHRASE_CODE = T.PHRASE_CODE
766: and B.LANGUAGE = T.SOURCE_LANG)
767: where (
768: T.PHRASE_CODE,

Line 773: from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT

769: T.LANGUAGE
770: ) in (select
771: SUBT.PHRASE_CODE,
772: SUBT.LANGUAGE
773: from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT
774: where SUBB.PHRASE_CODE = SUBT.PHRASE_CODE
775: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
776: and (SUBB.PHRASE_TEXT <> SUBT.PHRASE_TEXT
777: or (SUBB.PHRASE_TEXT is null and SUBT.PHRASE_TEXT is not null)

Line 856: INSERT INTO gr_phrases_tl

852: OPEN c_get_descs;
853: FETCH c_get_descs INTO PhraseDesc;
854: IF c_get_descs%NOTFOUND THEN
855: CLOSE c_get_descs;
856: INSERT INTO gr_phrases_tl
857: (phrase_code,
858: language,
859: source_lang,
860: key_word1,

Line 1085: FROM gr_phrases_tl

1081:
1082: CURSOR c_lock_phrases_tl
1083: IS
1084: SELECT last_update_date
1085: FROM gr_phrases_tl
1086: WHERE rowid = p_rowid
1087: FOR UPDATE NOWAIT;
1088: LockPhraseRcd c_lock_phrases_tl%ROWTYPE;
1089:

Line 1317: DELETE FROM gr_phrases_tl

1313: IF l_return_status <> 'S' THEN
1314: RAISE Check_Integrity_Error;
1315: END IF;
1316:
1317: DELETE FROM gr_phrases_tl
1318: WHERE rowid = p_rowid;
1319:
1320: /* Check the commit flag and if set, then commit the work. */
1321:

Line 1402: DELETE FROM gr_phrases_tl

1398: x_oracle_error := 0;
1399: x_msg_data := NULL;
1400: l_msg_token := p_phrase_code;
1401:
1402: DELETE FROM gr_phrases_tl
1403: WHERE phrase_code = p_phrase_code;
1404:
1405: IF FND_API.To_Boolean(p_commit) THEN
1406: COMMIT WORK;

Line 1717: FROM gr_phrases_tl pht

1713:
1714: CURSOR c_get_phrases_tl_rowid
1715: IS
1716: SELECT pht.rowid
1717: FROM gr_phrases_tl pht
1718: WHERE pht.phrase_code = p_phrase_code
1719: AND pht.language = p_language;
1720: PhraseTLRecord c_get_phrases_tl_rowid%ROWTYPE;
1721:

Line 1769: UPDATE GR_PHRASES_TL SET

1765: ,X_PRINT_SIZE IN NUMBER
1766: ,X_IMAGE_PATHNAME IN VARCHAR2
1767: ) IS
1768: BEGIN
1769: UPDATE GR_PHRASES_TL SET
1770: PHRASE_TEXT = X_PHRASE_TEXT,
1771: SOURCE_LANG = USERENV('LANG'),
1772: LAST_UPDATE_DATE = sysdate,
1773: LAST_UPDATED_BY = 0,

Line 1798: FROM GR_PHRASES_TL

1794: ,X_IMAGE_PATHNAME IN VARCHAR2
1795: ) IS
1796: CURSOR Cur_rowid IS
1797: SELECT rowid
1798: FROM GR_PHRASES_TL
1799: WHERE (PHRASE_CODE = X_PHRASE_CODE)
1800: AND (LANGUAGE = X_LANGUAGE);
1801: l_user_id NUMBER DEFAULT 1;
1802: l_row_id VARCHAR2(64);

Line 1810: GR_PHRASES_TL_PKG.UPDATE_ROW(

1806: BEGIN
1807: OPEN Cur_rowid;
1808: FETCH Cur_rowid INTO l_row_id;
1809: IF Cur_rowid%FOUND THEN
1810: GR_PHRASES_TL_PKG.UPDATE_ROW(
1811: P_COMMIT => 'T'
1812: ,P_CALLED_BY_FORM => 'F'
1813: ,P_ROWID => l_row_id
1814: ,P_IMAGE_PRINT_LOCATION => X_IMAGE_PRINT_LOCATION

Line 1868: GR_PHRASES_TL_PKG.INSERT_ROW(

1864: ,X_RETURN_STATUS => l_return_status
1865: ,X_ORACLE_ERROR => l_oracle_error
1866: ,X_MSG_DATA => l_msg_data);
1867: ELSE
1868: GR_PHRASES_TL_PKG.INSERT_ROW(
1869: P_COMMIT => 'T'
1870: ,P_CALLED_BY_FORM => 'F'
1871: ,P_IMAGE_PRINT_LOCATION => X_IMAGE_PRINT_LOCATION
1872: ,P_PHRASE_CODE => X_PHRASE_CODE

Line 1940: delete from GR_PHRASES_TL T

1936:
1937: procedure NEW_LANGUAGE
1938: is
1939: begin
1940: delete from GR_PHRASES_TL T
1941: where not exists
1942: (select NULL
1943: from GR_PHRASES_B B
1944: where B.PHRASE_CODE = T.PHRASE_CODE

Line 1947: update GR_PHRASES_TL T set (

1943: from GR_PHRASES_B B
1944: where B.PHRASE_CODE = T.PHRASE_CODE
1945: );
1946:
1947: update GR_PHRASES_TL T set (
1948: PHRASE_TEXT
1949: ) = (select
1950: B.PHRASE_TEXT
1951: from GR_PHRASES_TL B

Line 1951: from GR_PHRASES_TL B

1947: update GR_PHRASES_TL T set (
1948: PHRASE_TEXT
1949: ) = (select
1950: B.PHRASE_TEXT
1951: from GR_PHRASES_TL B
1952: where B.PHRASE_CODE = T.PHRASE_CODE
1953: and B.LANGUAGE = T.SOURCE_LANG)
1954: where (
1955: T.PHRASE_CODE,

Line 1960: from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT

1956: T.LANGUAGE
1957: ) in (select
1958: SUBT.PHRASE_CODE,
1959: SUBT.LANGUAGE
1960: from GR_PHRASES_TL SUBB, GR_PHRASES_TL SUBT
1961: where SUBB.PHRASE_CODE = SUBT.PHRASE_CODE
1962: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1963: and (SUBB.PHRASE_TEXT <> SUBT.PHRASE_TEXT
1964: ));

Line 1966: insert into GR_PHRASES_TL (

1962: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1963: and (SUBB.PHRASE_TEXT <> SUBT.PHRASE_TEXT
1964: ));
1965:
1966: insert into GR_PHRASES_TL (
1967: IMAGE_PRINT_LOCATION,
1968: ATTRIBUTE_CATEGORY,
1969: ATTRIBUTE1,
1970: ATTRIBUTE2,

Line 2068: from GR_PHRASES_TL B, FND_LANGUAGES L

2064: B.PRINT_SIZE,
2065: B.IMAGE_PATHNAME,
2066: L.LANGUAGE_CODE,
2067: B.SOURCE_LANG
2068: from GR_PHRASES_TL B, FND_LANGUAGES L
2069: where L.INSTALLED_FLAG in ('I', 'B')
2070: and B.LANGUAGE = userenv('LANG')
2071: and not exists
2072: (select NULL

Line 2073: from GR_PHRASES_TL T

2069: where L.INSTALLED_FLAG in ('I', 'B')
2070: and B.LANGUAGE = userenv('LANG')
2071: and not exists
2072: (select NULL
2073: from GR_PHRASES_TL T
2074: where T.PHRASE_CODE = B.PHRASE_CODE
2075: and T.LANGUAGE = L.LANGUAGE_CODE);
2076:
2077: end NEW_LANGUAGE;

Line 2079: END GR_PHRASES_TL_PKG;

2075: and T.LANGUAGE = L.LANGUAGE_CODE);
2076:
2077: end NEW_LANGUAGE;
2078:
2079: END GR_PHRASES_TL_PKG;