APPS.BIS_IMPL_DEV_PKG dependencies on FND_FORM_FUNCTIONS_VL

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 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