eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ADI_DISPLAY_REPORT dependencies on DBMS_SQL

Line 334: v_cursor := DBMS_SQL.OPEN_CURSOR;

330: v_query := v_query || 'AND CAT.NAME = ''ADI_KIOSK_DEFAULT_PUBLIC'' ';
331: ELSIF (p_PageType = 'SECURED') THEN
332: v_query := v_query || 'AND CAT.NAME = ''ADI_KIOSK_DEFAULT_SECURED'' ';
333: END IF;
334: v_cursor := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);

Line 335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);

331: ELSIF (p_PageType = 'SECURED') THEN
332: v_query := v_query || 'AND CAT.NAME = ''ADI_KIOSK_DEFAULT_SECURED'' ';
333: END IF;
334: v_cursor := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);

Line 337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);

333: END IF;
334: v_cursor := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);

Line 338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);

334: v_cursor := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);

Line 339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);

335: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);

Line 340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);

336: -- GHOOKER 14-May-2003 SQL Bind Compliance.
337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);

Line 341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);

337: DBMS_SQL.BIND_VARIABLE (v_cursor, ':pfilename', P_FILENAME);
338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);

Line 342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);

338: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_Category_Name, 30);
339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);
346: DBMS_SQL.Close_Cursor (v_cursor);

Line 343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);

339: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_DocumentId);
340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);
346: DBMS_SQL.Close_Cursor (v_cursor);
347: IF (v_Category_Name IN ('ADI_KIOSK_REPORT', 'ADI_KIOSK_DEFAULT_SECURED')) THEN

Line 344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);

340: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_MimeType, 255);
341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);
346: DBMS_SQL.Close_Cursor (v_cursor);
347: IF (v_Category_Name IN ('ADI_KIOSK_REPORT', 'ADI_KIOSK_DEFAULT_SECURED')) THEN
348: IF (NOT ICX_SEC.ValidateSession) THEN

Line 345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);

341: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);
346: DBMS_SQL.Close_Cursor (v_cursor);
347: IF (v_Category_Name IN ('ADI_KIOSK_REPORT', 'ADI_KIOSK_DEFAULT_SECURED')) THEN
348: IF (NOT ICX_SEC.ValidateSession) THEN
349: GOTO EndOfStaticDisplay;

Line 346: DBMS_SQL.Close_Cursor (v_cursor);

342: v_dummy := DBMS_SQL.FETCH_ROWS (v_cursor);
343: DBMS_SQL.COLUMN_VALUE (v_cursor, 1, v_Category_Name);
344: DBMS_SQL.COLUMN_VALUE (v_cursor, 2, v_DocumentId);
345: DBMS_SQL.COLUMN_VALUE (v_cursor, 3, v_MimeType);
346: DBMS_SQL.Close_Cursor (v_cursor);
347: IF (v_Category_Name IN ('ADI_KIOSK_REPORT', 'ADI_KIOSK_DEFAULT_SECURED')) THEN
348: IF (NOT ICX_SEC.ValidateSession) THEN
349: GOTO EndOfStaticDisplay;
350: END IF;

Line 399: l_cursor := DBMS_SQL.OPEN_CURSOR;

395: l_query := l_query || 'AND (NVL(O.END_DATE_ACTIVE,SYSDATE) >= SYSDATE) ';
396: l_query := l_query || 'AND (V.LEVEL_ID (+) = 10001 AND V.LEVEL_VALUE (+) = 0) ';
397: l_query := l_query || 'AND O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID (+) ';
398: l_query := l_query || 'AND O.APPLICATION_ID = V.APPLICATION_ID (+) ';
399: l_cursor := DBMS_SQL.OPEN_CURSOR;
400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);

Line 400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);

396: l_query := l_query || 'AND (V.LEVEL_ID (+) = 10001 AND V.LEVEL_VALUE (+) = 0) ';
397: l_query := l_query || 'AND O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID (+) ';
398: l_query := l_query || 'AND O.APPLICATION_ID = V.APPLICATION_ID (+) ';
399: l_cursor := DBMS_SQL.OPEN_CURSOR;
400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);

Line 401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);

397: l_query := l_query || 'AND O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID (+) ';
398: l_query := l_query || 'AND O.APPLICATION_ID = V.APPLICATION_ID (+) ';
399: l_cursor := DBMS_SQL.OPEN_CURSOR;
400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);
405: DBMS_SQL.CLOSE_CURSOR (l_cursor);

Line 402: l_dummy := DBMS_SQL.execute (l_cursor);

398: l_query := l_query || 'AND O.APPLICATION_ID = V.APPLICATION_ID (+) ';
399: l_cursor := DBMS_SQL.OPEN_CURSOR;
400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);
405: DBMS_SQL.CLOSE_CURSOR (l_cursor);
406: END IF;

Line 403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);

399: l_cursor := DBMS_SQL.OPEN_CURSOR;
400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);
405: DBMS_SQL.CLOSE_CURSOR (l_cursor);
406: END IF;
407:

Line 404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);

400: DBMS_SQL.parse (l_cursor, l_query, DBMS_SQL.native);
401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);
405: DBMS_SQL.CLOSE_CURSOR (l_cursor);
406: END IF;
407:
408: -- Check for trailing slash.

Line 405: DBMS_SQL.CLOSE_CURSOR (l_cursor);

401: DBMS_SQL.Define_Column (l_cursor, 1, g_ServerAddress, 240);
402: l_dummy := DBMS_SQL.execute (l_cursor);
403: l_dummy := DBMS_SQL.Fetch_Rows (l_cursor);
404: DBMS_SQL.Column_Value (l_cursor, 1, g_ServerAddress);
405: DBMS_SQL.CLOSE_CURSOR (l_cursor);
406: END IF;
407:
408: -- Check for trailing slash.
409: IF (SUBSTR (g_ServerAddress, LENGTH (g_ServerAddress), 1) <> '/') THEN