DBA Data[Home] [Help]

APPS.PON_AUCTION_HEADERS_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 720: v_text fnd_documents_short_text.short_text%TYPE;

716: SHORT_TEXT number := 1;
717: WEB_PAGE number := 5;
718: EXTERNAL_FILE number := 6;
719: ACCESS_URL VARCHAR2(255) := '/jsp/pon/attachments/get_attachment.jsp?sequence_num=';
720: v_text fnd_documents_short_text.short_text%TYPE;
721: v_url VARCHAR2(255);
722: v_document_id NUMBER := NULL;
723: v_file_id NUMBER := NULL;
724: v_attachment_cat_id NUMBER := NULL;

Line 746: FROM fnd_documents_short_text

742:
743: IF (bid_att.datatype_id = SHORT_TEXT) THEN
744: SELECT short_text
745: INTO v_text
746: FROM fnd_documents_short_text
747: WHERE media_id = bid_att.media_id;
748: --
749: ELSE
750: v_text := null;