APPS.PON_AUCTION_HEADERS_PKG dependencies on FND_DOCUMENTS

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

704: fndat.seq_num seq_num, dc.datatype_id datatype_id,
705: dt.description description, dt.file_name file_name, dc.media_id media_id,
706: fndat.pk3_value pk3,
707: fndat.pk4_value pk4
708: FROM fnd_documents dc, fnd_documents_tl dt, fnd_attached_documents fndat
709: WHERE fndat.document_id = dt.document_id
710: AND dt.document_id = dc.document_id
711: AND dt.language = userenv('LANG')
712: AND fndat.entity_name IN ('PON_BID_ITEM_PRICES', 'PON_BID_HEADERS')

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;