APPS.BIS_PMV_UTIL dependencies on FND_FORM_FUNCTIONS

Line 498: l_ref_function_name fnd_form_functions.function_name%TYPE;

494: l_region VARCHAR2(30);
495: l_index NUMBER;
496: l_type VARCHAR2(30);
497: l_web_html_call VARCHAR2(240);
498: l_ref_function_name fnd_form_functions.function_name%TYPE;
499:
500: cursor c_form_func(cpFunctionName varchar2) is
501: select web_html_call,parameters,type
502: from fnd_form_functions

Line 502: from fnd_form_functions

498: l_ref_function_name fnd_form_functions.function_name%TYPE;
499:
500: cursor c_form_func(cpFunctionName varchar2) is
501: select web_html_call,parameters,type
502: from fnd_form_functions
503: where function_name = cpFunctionName;
504:
505: BEGIN
506:

Line 521: from fnd_form_functions

517: select web_html_call
518: ,parameters
519: ,type
520: into l_web_html_call, l_parameters, l_type
521: from fnd_form_functions
522: where function_name = pFunctionName;
523: exception
524: WHEN OTHERS THEN NULL;
525: end;

Line 559: from fnd_form_functions

555: select web_html_call
556: ,parameters
557: ,type
558: into l_web_html_call, l_parameters, l_type
559: from fnd_form_functions
560: where function_name = l_ref_function_name;
561: exception
562: WHEN OTHERS THEN NULL;
563: end;

Line 631: l_function_name fnd_form_functions.function_name%TYPE;

627: return varchar2 IS
628: l_resp_id fnd_responsibility.responsibility_id%TYPE;
629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1

Line 636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1
636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
637: WHERE MEV.MENU_ID = l_menu_id
638: AND RF.RESPONSIBILITY_ID (+) = l_resp_id
639: AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')
640: AND RF.ACTION_ID(+) <> DECODE(DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F'), 'F', MEV.FUNCTION_ID,

Line 648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

644: AND FF.function_name = l_function_name
645: AND RF.APPLICATION_ID(+) = l_appl_id
646: UNION
647: SELECT 1
648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
649: WHERE MEV.MENU_ID IN(
650: SELECT SUB_MENU_ID
651: FROM FND_MENU_ENTRIES
652: WHERE SUB_MENU_ID IS NOT NULL

Line 968: FROM fnd_form_functions

964: RETURN VARCHAR2
965: IS
966: CURSOR c_form_function IS
967: SELECT web_html_call, parameters, type
968: FROM fnd_form_functions
969: WHERE function_name = pPageFunctionName;
970:
971: CURSOR c_paramPortlet_funcName(p_menu_name VARCHAR2) IS
972: SELECT FF.FUNCTION_NAME

Line 973: FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF

969: WHERE function_name = pPageFunctionName;
970:
971: CURSOR c_paramPortlet_funcName(p_menu_name VARCHAR2) IS
972: SELECT FF.FUNCTION_NAME
973: FROM FND_MENU_ENTRIES_VL MEV, FND_FORM_FUNCTIONS FF
974: WHERE MEV.MENU_ID IN (
975: SELECT SUB_MENU_ID
976: FROM FND_MENU_ENTRIES
977: WHERE SUB_MENU_ID IS NOT NULL