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.BIS_IMPL_DEV_PKG dependencies on FND_FORM_FUNCTIONS

Line 393: from fnd_form_functions_vl func, bis_obj_dependency dep

389: CURSOR c_page(p_user_object_name VARCHAR2, p_object_name VARCHAR2, p_is_oa_page VARCHAR2) IS
390: SELECT object_name, user_object_name, oa_page
391: FROM (-- portal pages existing in RSG
392: (select DISTINCT dep.object_name object_name, func.user_function_name user_object_name, 'N' oa_page
393: from fnd_form_functions_vl func, bis_obj_dependency dep
394: where upper(web_html_call)='ORACLESSWA.SWITCHPAGE'
395: and dep.object_type = 'PAGE'
396: and dep.object_name = substr(parameters,10))
397: UNION ALL

Line 400: from fnd_form_functions_vl func, bis_obj_dependency dep

396: and dep.object_name = substr(parameters,10))
397: UNION ALL
398: -- oa page existing in RSG repository
399: (select DISTINCT dep.object_name object_name, func.user_function_name user_object_name, 'Y' oa_page
400: from fnd_form_functions_vl func, bis_obj_dependency dep
401: where upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
402: and dep.object_type = 'PAGE'
403: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = func.function_name)
404: UNION ALL

Line 407: from fnd_form_functions_vl func

403: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = func.function_name)
404: UNION ALL
405: -- oa page not in RSG repository
406: select func.function_name object_name, func.user_function_name user_object_name, 'Y' oa_page
407: from fnd_form_functions_vl func
408: where upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
409: and func.function_name not in (select f.function_name
410: from fnd_form_functions f, bis_obj_dependency dep
411: where upper(f.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'

Line 410: from fnd_form_functions f, bis_obj_dependency dep

406: select func.function_name object_name, func.user_function_name user_object_name, 'Y' oa_page
407: from fnd_form_functions_vl func
408: where upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
409: and func.function_name not in (select f.function_name
410: from fnd_form_functions f, bis_obj_dependency dep
411: where upper(f.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
412: and dep.object_type = 'PAGE'
413: and bis_impl_dev_pkg.get_function_by_page(dep.object_name) = f.function_name)
414: UNION ALL

Line 420: and not exists (select 1 from fnd_form_functions func

416: (select DISTINCT objdep.object_name object_name, /*objdep.user_object_name user_object_name*/ objdep.object_name user_object_name, 'N' oa_page
417: --from bis_obj_dependency_v objdep
418: from bis_obj_dependency objdep
419: where objdep.object_type = 'PAGE'
420: and not exists (select 1 from fnd_form_functions func
421: where (upper(func.web_html_call) = 'ORACLESSWA.SWITCHPAGE'
422: and substr(func.parameters,10) = objdep.object_name)
423: /* or (upper(func.web_html_call) LIKE '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
424: and (func.function_name = objdep.object_name

Line 500: from fnd_form_functions_vl

496: ---fix bug 4067976. Added type WEBPORTLETX for portlet form
497: ---function
498: cursor c_portlet_function(p_user_object_name VARCHAR2) is
499: select function_name
500: from fnd_form_functions_vl
501: where type in ('WEBPORTLET','WEBPORTLETX')
502: and user_function_name = p_user_object_name;
503:
504: cursor c_report_function(p_user_object_name VARCHAR2) is

Line 506: from fnd_form_functions_vl

502: and user_function_name = p_user_object_name;
503:
504: cursor c_report_function(p_user_object_name VARCHAR2) is
505: select function_name
506: from fnd_form_functions_vl
507: where type in ('WWW','JSP') --modified for bug 4717956
508: and user_function_name = p_user_object_name;
509:
510: cursor c_portlet_function_name(p_user_object_name VARCHAR2, p_function_name VARCHAR2) IS

Line 512: from fnd_form_functions_vl

508: and user_function_name = p_user_object_name;
509:
510: cursor c_portlet_function_name(p_user_object_name VARCHAR2, p_function_name VARCHAR2) IS
511: select function_name
512: from fnd_form_functions_vl
513: where type in ('WEBPORTLET','WEBPORTLETX')
514: and user_function_name = p_user_object_name
515: and function_name = p_function_name;
516:

Line 519: from fnd_form_functions_vl

515: and function_name = p_function_name;
516:
517: cursor c_report_function_name(p_user_object_name VARCHAR2, p_function_name VARCHAR2) IS
518: select function_name
519: from fnd_form_functions_vl
520: where type in ('WWW','JSP') ---modified for bug 4717956
521: and user_function_name = p_user_object_name
522: and function_name = p_function_name;
523:

Line 1686: from fnd_form_functions_vl

1682: i number;
1683:
1684: cursor c_portlet_report(p_object_name varchar2) is
1685: select user_function_name
1686: from fnd_form_functions_vl
1687: where function_name = p_object_name;
1688:
1689: -- new implementation to uptake get_function_by_page
1690: cursor c_oa_page(p_object_name varchar2) is

Line 1692: from fnd_form_functions_vl

1688:
1689: -- new implementation to uptake get_function_by_page
1690: cursor c_oa_page(p_object_name varchar2) is
1691: select user_function_name
1692: from fnd_form_functions_vl
1693: where UPPER(web_html_call) like '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
1694: and get_function_by_page(p_object_name) = function_name;
1695:
1696: begin

Line 1760: fnd_form_functions f

1756: IS
1757: cursor c_page1(P_PAGE_NAME varchar2) is
1758: select f.function_name
1759: from
1760: fnd_form_functions f
1761: where
1762: UPPER(f.web_html_call) like '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
1763: and function_name = P_PAGE_NAME;
1764:

Line 1768: fnd_form_functions f

1764:
1765: cursor c_page2(P_PAGE_NAME varchar2) is
1766: select f.function_name
1767: from
1768: fnd_form_functions f
1769: where
1770: UPPER(f.web_html_call) like '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
1771: and P_PAGE_NAME like '%_OA'
1772: and function_name = SUBSTR(P_PAGE_NAME, 1, LENGTH(P_PAGE_NAME) - 3);

Line 1774: L_FUNCTION_NAME fnd_form_functions.function_name%TYPE := NULL;

1770: UPPER(f.web_html_call) like '%BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
1771: and P_PAGE_NAME like '%_OA'
1772: and function_name = SUBSTR(P_PAGE_NAME, 1, LENGTH(P_PAGE_NAME) - 3);
1773:
1774: L_FUNCTION_NAME fnd_form_functions.function_name%TYPE := NULL;
1775: BEGIN
1776: open c_page1(P_PAGE_NAME);
1777: fetch c_page1 into L_FUNCTION_NAME;
1778: close c_page1;

Line 1799: fnd_form_functions f,

1795:
1796: cursor skip_migrate(P_PAGE_NAME varchar2) is
1797: select /*+ FIRST_ROWS*/ 'Y'
1798: from
1799: fnd_form_functions f,
1800: bis_obj_dependency d
1801: where
1802: d.object_name = f.function_name
1803: and d.object_type = 'PAGE'