684: USAGE_TYPE FND_DOCUMENTS.USAGE_TYPE%TYPE,
685: START_DATE_ACTIVE FND_DOCUMENTS.START_DATE_ACTIVE%TYPE,
686: END_DATE_ACTIVE FND_DOCUMENTS.END_DATE_ACTIVE%TYPE,
687: ---------------------------------------
688: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
689: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
690: FILE_NAME fnd_documents.FILE_NAME%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
685: START_DATE_ACTIVE FND_DOCUMENTS.START_DATE_ACTIVE%TYPE,
686: END_DATE_ACTIVE FND_DOCUMENTS.END_DATE_ACTIVE%TYPE,
687: ---------------------------------------
688: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
689: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
690: FILE_NAME fnd_documents.FILE_NAME%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
688: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
689: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
690: FILE_NAME fnd_documents.FILE_NAME%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
689: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
690: FILE_NAME fnd_documents.FILE_NAME%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
690: FILE_NAME fnd_documents.FILE_NAME%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
691: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
692: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
693: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
694: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
695: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
696: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
697: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
698: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
699: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
700: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
708: URL FND_DOCUMENTS.URL%TYPE,
701: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
708: URL FND_DOCUMENTS.URL%TYPE,
709: TITLE fnd_documents_tl.TITLE%TYPE
702: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
708: URL FND_DOCUMENTS.URL%TYPE,
709: TITLE fnd_documents_tl.TITLE%TYPE
710: );
703: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
704: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
708: URL FND_DOCUMENTS.URL%TYPE,
709: TITLE fnd_documents_tl.TITLE%TYPE
710: );
711:
705: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
706: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
707: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
708: URL FND_DOCUMENTS.URL%TYPE,
709: TITLE fnd_documents_tl.TITLE%TYPE
710: );
711:
712: -- Bug 9756187 Start
713:
755: USAGE_TYPE FND_DOCUMENTS.USAGE_TYPE%TYPE,
756: START_DATE_ACTIVE FND_DOCUMENTS.START_DATE_ACTIVE%TYPE,
757: END_DATE_ACTIVE FND_DOCUMENTS.END_DATE_ACTIVE%TYPE,
758: ---------------------------------------
759: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
760: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
761: FILE_NAME fnd_documents.FILE_NAME%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
756: START_DATE_ACTIVE FND_DOCUMENTS.START_DATE_ACTIVE%TYPE,
757: END_DATE_ACTIVE FND_DOCUMENTS.END_DATE_ACTIVE%TYPE,
758: ---------------------------------------
759: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
760: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
761: FILE_NAME fnd_documents.FILE_NAME%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
759: l_LANGUAGE fnd_documents_tl.LANGUAGE%TYPE,
760: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
761: FILE_NAME fnd_documents.FILE_NAME%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
760: DESCRIPTION fnd_documents_tl.DESCRIPTION%TYPE,
761: FILE_NAME fnd_documents.FILE_NAME%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
761: FILE_NAME fnd_documents.FILE_NAME%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
762: MEDIA_ID fnd_documents.MEDIA_ID%TYPE, -- IN OUT NOCOPY
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
763: DOC_ATTRIBUTE_CATEGORY fnd_documents_tl.DOC_ATTRIBUTE_CATEGORY%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
764: DOC_ATTRIBUTE1 fnd_documents_tl.DOC_ATTRIBUTE1%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
765: DOC_ATTRIBUTE2 fnd_documents_tl.DOC_ATTRIBUTE2%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
766: DOC_ATTRIBUTE3 fnd_documents_tl.DOC_ATTRIBUTE3%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
767: DOC_ATTRIBUTE4 fnd_documents_tl.DOC_ATTRIBUTE4%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
768: DOC_ATTRIBUTE5 fnd_documents_tl.DOC_ATTRIBUTE5%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
769: DOC_ATTRIBUTE6 fnd_documents_tl.DOC_ATTRIBUTE6%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
770: DOC_ATTRIBUTE7 fnd_documents_tl.DOC_ATTRIBUTE7%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
771: DOC_ATTRIBUTE8 fnd_documents_tl.DOC_ATTRIBUTE8%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
779: URL FND_DOCUMENTS.URL%TYPE,
772: DOC_ATTRIBUTE9 fnd_documents_tl.DOC_ATTRIBUTE9%TYPE,
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
779: URL FND_DOCUMENTS.URL%TYPE,
780: TITLE fnd_documents_tl.TITLE%TYPE
773: DOC_ATTRIBUTE10 fnd_documents_tl.DOC_ATTRIBUTE10%TYPE,
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
779: URL FND_DOCUMENTS.URL%TYPE,
780: TITLE fnd_documents_tl.TITLE%TYPE
781: );
774: DOC_ATTRIBUTE11 fnd_documents_tl.DOC_ATTRIBUTE11%TYPE,
775: DOC_ATTRIBUTE12 fnd_documents_tl.DOC_ATTRIBUTE12%TYPE,
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
779: URL FND_DOCUMENTS.URL%TYPE,
780: TITLE fnd_documents_tl.TITLE%TYPE
781: );
782:
776: DOC_ATTRIBUTE13 fnd_documents_tl.DOC_ATTRIBUTE13%TYPE,
777: DOC_ATTRIBUTE14 fnd_documents_tl.DOC_ATTRIBUTE14%TYPE,
778: DOC_ATTRIBUTE15 fnd_documents_tl.DOC_ATTRIBUTE15%TYPE,
779: URL FND_DOCUMENTS.URL%TYPE,
780: TITLE fnd_documents_tl.TITLE%TYPE
781: );
782:
783: -- Bug 9756187 End
784:
1162: tl.TITLE
1163:
1164: from fnd_documents docs,
1165: FND_ATTACHED_DOCUMENTS atth,
1166: fnd_documents_tl tl
1167:
1168: where entity_name = ''FUN_TRX_HEADERS''
1169: and tl.LANGUAGE=''' || icx_language || '''
1170: and pk1_value=''' || l_trx_id.TRX_ID || '''
1434: tl.TITLE
1435:
1436: from fnd_documents docs,
1437: FND_ATTACHED_DOCUMENTS atth,
1438: fnd_documents_tl tl
1439:
1440: where entity_name = ''FUN_TRX_BATCHES''
1441: and tl.LANGUAGE=''' || icx_language || '''
1442: and pk1_value=''' || l_partial_batch.BATCH_ID || '''