APPS.ADI_DISPLAY_REPORT dependencies on FND_DOCUMENT_CATEGORIES

Line 184: g_CategoryId FND_DOCUMENT_CATEGORIES.category_id%TYPE;

180: g_TimeFrame_List TimeFrameTable;
181: g_ExpandedValue_List ExpandedTable;
182: g_ParameterFrame VARCHAR2(32767) DEFAULT '';
183: g_ReleaseName FND_PRODUCT_GROUPS.release_name%TYPE DEFAULT '';
184: g_CategoryId FND_DOCUMENT_CATEGORIES.category_id%TYPE;
185: -----------------------------------------------------------------------------
186: -- PROCEDURE: DisplayFile --
187: -- --
188: -- DESCRIPTION: Procedure extracts the file from FND_DOCUMENTS_LONG_TEXT --

Line 315: v_category_name FND_DOCUMENT_CATEGORIES.name%TYPE;

311: p_PageType IN VARCHAR2 default '') AS
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 := '';

Line 323: v_query := v_query || 'FROM FND_DOCUMENT_CATEGORIES CAT, ';

319: v_query := '';
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 || ''') ';

Line 461: v_ReportType FND_DOCUMENT_CATEGORIES.name%TYPE;

457: v_periodicReport INTEGER default 0;
458: v_expansionReport INTEGER default 0;
459: v_URL_Params VARCHAR2(1000);
460: v_URL_Contents VARCHAR2(1000);
461: v_ReportType FND_DOCUMENT_CATEGORIES.name%TYPE;
462: v_dummy BOOLEAN;
463: v_frameHeight NUMBER;
464: v_serverAddress VARCHAR2(255);
465: