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.FND_FORM_FUNCTIONS_PKG dependencies on FND_GLOBAL

Line 224: columns_name := columns_name||fnd_global.newline;

220: */
221:
222: -- For formatting purpose
223: if (columns_name is not null) then
224: columns_name := columns_name||fnd_global.newline;
225: end if;
226:
227: declare
228: applname varchar2(8);

Line 262: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;

258: (type='WWW' and substr(function_name,1,2) = 'QA'))) then
259: form_id := '';
260: application_id := '';
261: type := 'MOBILE';
262: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
263: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
264: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
265: end if;
266:

Line 263: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;

259: form_id := '';
260: application_id := '';
261: type := 'MOBILE';
262: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
263: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
264: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
265: end if;
266:
267: if (upper(web_html_call) like '%MOBILE%' and

Line 264: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;

260: application_id := '';
261: type := 'MOBILE';
262: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
263: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
264: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
265: end if;
266:
267: if (upper(web_html_call) like '%MOBILE%' and
268: function_name in ('PN_MOBILE_CUST_DIR',

Line 276: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;

272: 'AR_MAM_APPLICATION_FUNCTION')) then
273: type := 'MOBILE';
274: form_id := '';
275: application_id := '';
276: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
277: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
278: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
279: end if;
280:

Line 277: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;

273: type := 'MOBILE';
274: form_id := '';
275: application_id := '';
276: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
277: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
278: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
279: end if;
280:
281: if (type = 'FORM' and

Line 278: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;

274: form_id := '';
275: application_id := '';
276: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
277: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
278: columns_name := columns_name||'TYPE = MOBILE'||fnd_global.newline;
279: end if;
280:
281: if (type = 'FORM' and
282: web_html_call is not null) then

Line 284: columns_name := columns_name||'WEB_HTML_CALL = null'||fnd_global.newline;

280:
281: if (type = 'FORM' and
282: web_html_call is not null) then
283: web_html_call := '';
284: columns_name := columns_name||'WEB_HTML_CALL = null'||fnd_global.newline;
285: end if;
286:
287: /*
288: +-----+-------------------------------+---------------------------------+-----+

Line 297: fnd_global.newline;

293: if (type = 'FORM' and
294: region_application_id is not null) then
295: region_application_id := '';
296: columns_name := columns_name||'REGION_APPLICATION_ID = null'||
297: fnd_global.newline;
298: end if;
299:
300: /*
301: +-----+-------------------------------+---------------------------------+-----+

Line 310: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

306: if (type = 'JSP' and
307: upper(web_html_call) not like '%JSP%' and
308: upper(web_html_call) not like '%JAVASCRIPT%') then
309: type := 'UNKNOWN';
310: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
311: end if;
312:
313: /*
314: +-----+-------------------------------+---------------------------------+-----+

Line 325: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;

321: form_id is not null and
322: application_id is not null) then
323: form_id := '';
324: application_id := '';
325: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
326: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
327: end if;
328:
329: /*

Line 326: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;

322: application_id is not null) then
323: form_id := '';
324: application_id := '';
325: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
326: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
327: end if;
328:
329: /*
330: +-----+-------------------------------+---------------------------------+-----+

Line 340: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;

336: if (type = 'WWW' and
337: (form_id is not null or application_id is not null)) then
338: form_id := '';
339: application_id := '';
340: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
341: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
342: end if;
343:
344: /*

Line 341: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;

337: (form_id is not null or application_id is not null)) then
338: form_id := '';
339: application_id := '';
340: columns_name := columns_name||'FORM_ID = null'||fnd_global.newline;
341: columns_name := columns_name||'APPLICATION_ID = null'||fnd_global.newline;
342: end if;
343:
344: /*
345: +-----+-------------------------------+---------------------------------+-----+

Line 359: columns_name := columns_name||'TYPE = FORM'||fnd_global.newline;

355: and parameters is null
356: and web_html_call is null
357: and region_code is null) then
358: type := 'FORM';
359: columns_name := columns_name||'TYPE = FORM'||fnd_global.newline;
360: end if;
361:
362: /*
363: +-----+----------------------------- -+---------------------------------+-----+

Line 377: columns_name := columns_name||'REGION_CODE = null'||fnd_global.newline;

373: and parameters is null
374: and web_html_call is null
375: and region_code is not null) then
376: region_code := '';
377: columns_name := columns_name||'REGION_CODE = null'||fnd_global.newline;
378: end if;
379:
380: /*
381: +-----+----------------------------- -+---------------------------------+-----+

Line 397: columns_name := columns_name||'TYPE = JSP'||fnd_global.newline;

393: and web_html_call is not null
394: and upper(web_html_call) like '%JSP%'
395: and region_code is null) then
396: type := 'JSP';
397: columns_name := columns_name||'TYPE = JSP'||fnd_global.newline;
398: end if;
399:
400: /*
401: +-----+-------------------------------+---------------------------------+-----+

Line 417: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

413: and web_html_call is not null
414: and upper(web_html_call) not like '%JSP%'
415: and region_code is null) then
416: type := 'UNKNOWN';
417: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
418: end if;
419:
420: /*
421: +-----+-------------------------------+---------------------------------+-----+

Line 435: columns_name := columns_name||'TYPE = FORM'||fnd_global.newline;

431: and parameters is not null
432: and web_html_call is null
433: and region_code is null ) then
434: type := 'FORM';
435: columns_name := columns_name||'TYPE = FORM'||fnd_global.newline;
436: end if;
437:
438: /*
439: +-----+-------------------------------+---------------------------------+-----+

Line 447: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

443: */
444: if ( type = 'JTFWEBPORTLET'
445: and web_html_call is null) then
446: type := 'UNKNOWN';
447: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
448: end if;
449:
450: /*
451: +-----+-------------------------------+---------------------------------+-----+

Line 459: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

455: */
456: if ( type = 'INTEROPJSP'
457: and web_html_call is null) then
458: type := 'UNKNOWN';
459: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
460: end if;
461:
462: /*
463: +-----+-------------------------------+---------------------------------+-----+

Line 469: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

465: +-----+-------------------------------+---------------------------------+-----+
466: */
467: if (type = 'OBJECT') then
468: type := 'UNKNOWN';
469: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
470: end if;
471:
472: /*
473: +-----+-------------------------------+---------------------------------+-----+

Line 480: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

476: +-----+-------------------------------+---------------------------------+-----+
477: */
478: if (type = 'HTML') then
479: type := 'UNKNOWN';
480: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
481: end if;
482:
483: /* Bug4507567 - Added for R12
484: +-----+-------------------------------+---------------------------------+-----+

Line 501: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;

497: and irep_lifecycle is null
498: and irep_description is null
499: and irep_class_id is null) then
500: type := 'UNKNOWN';
501: columns_name := columns_name||'TYPE = UNKNOWN'||fnd_global.newline;
502: end if;
503: */
504:
505: return(columns_name);