APPS.PON_AUCTION_HEADERS_PKG dependencies on FND_DOCUMENTS

Line 685: FROM fnd_documents dc, fnd_documents_tl dt, fnd_attached_documents fndat

681: fndat.seq_num seq_num, dc.datatype_id datatype_id,
682: dt.description description, dt.file_name file_name, dc.media_id media_id,
683: fndat.pk3_value pk3,
684: fndat.pk4_value pk4
685: FROM fnd_documents dc, fnd_documents_tl dt, fnd_attached_documents fndat
686: WHERE fndat.document_id = dt.document_id
687: AND dt.document_id = dc.document_id
688: AND dt.language = userenv('LANG')
689: AND fndat.entity_name IN ('PON_BID_ITEM_PRICES', 'PON_BID_HEADERS')

Line 697: v_text fnd_documents_short_text.short_text%TYPE;

693: SHORT_TEXT number := 1;
694: WEB_PAGE number := 5;
695: EXTERNAL_FILE number := 6;
696: ACCESS_URL VARCHAR2(255) := '/jsp/pon/attachments/get_attachment.jsp?sequence_num=';
697: v_text fnd_documents_short_text.short_text%TYPE;
698: v_url VARCHAR2(255);
699: v_document_id NUMBER := NULL;
700: v_file_id NUMBER := NULL;
701: v_attachment_cat_id NUMBER := NULL;

Line 723: FROM fnd_documents_short_text

719:
720: IF (bid_att.datatype_id = SHORT_TEXT) THEN
721: SELECT short_text
722: INTO v_text
723: FROM fnd_documents_short_text
724: WHERE media_id = bid_att.media_id;
725: --
726: ELSE
727: v_text := null;