APPS.ADI_DISPLAY_REPORT dependencies on FND_DOCUMENTS_VL

Line 196: -- field in FND_DOCUMENTS_VL is correct --

192: -- PARAMETERS: p_ReportTitle Report name from FND_FORM_FUNCTIONS --
193: -- p_Media_Id Unique identifier in --
194: -- FND_DOCUMENTS_LONG_TEXT --
195: -- p_Description Passed to check that the description --
196: -- field in FND_DOCUMENTS_VL is correct --
197: -- and that the user has not modified the --
198: -- URL before calling the Display process. --
199: -- --
200: -- MODIFICATIONS --

Line 316: v_DocumentId FND_DOCUMENTS_VL.Document_Id%TYPE;

312: v_query VARCHAR2(500);
313: v_cursor INTEGER;
314: v_dummy INTEGER;
315: v_category_name FND_DOCUMENT_CATEGORIES.name%TYPE;
316: v_DocumentId FND_DOCUMENTS_VL.Document_Id%TYPE;
317: v_mimeType FND_DOCUMENTS_VL.Description%TYPE;
318: BEGIN
319: v_query := '';
320: v_query := v_query || 'SELECT CAT.NAME, ';

Line 317: v_mimeType FND_DOCUMENTS_VL.Description%TYPE;

313: v_cursor INTEGER;
314: v_dummy INTEGER;
315: v_category_name FND_DOCUMENT_CATEGORIES.name%TYPE;
316: v_DocumentId FND_DOCUMENTS_VL.Document_Id%TYPE;
317: v_mimeType FND_DOCUMENTS_VL.Description%TYPE;
318: BEGIN
319: v_query := '';
320: v_query := v_query || 'SELECT CAT.NAME, ';
321: v_query := v_query || ' DOCS.DOCUMENT_ID, ';

Line 324: v_query := v_query || ' FND_DOCUMENTS_VL DOCS ';

320: v_query := v_query || 'SELECT CAT.NAME, ';
321: v_query := v_query || ' DOCS.DOCUMENT_ID, ';
322: v_query := v_query || ' DOCS.DESCRIPTION ';
323: v_query := v_query || 'FROM FND_DOCUMENT_CATEGORIES CAT, ';
324: v_query := v_query || ' FND_DOCUMENTS_VL DOCS ';
325: v_query := v_query || 'WHERE CAT.CATEGORY_ID = DOCS.CATEGORY_ID ';
326: -- GHOOKER 14-May-2003 SQL Bind Compliance.
327: -- v_query := v_query || 'AND LOWER (DOCS.FILE_NAME) = LOWER (''' || P_FILENAME || ''') ';
328: v_query := v_query || 'AND LOWER (DOCS.FILE_NAME) = LOWER ( :pfilename ) ';