APPS.CZ_SECURITY_PVT dependencies on FND_FORM_FUNCTIONS

Line 75: FROM fnd_form_functions

71: l_function_id NUMBER := 0;
72: BEGIN
73: SELECT function_id
74: INTO l_function_id
75: FROM fnd_form_functions
76: WHERE function_name = UPPER(p_function_name);
77: RETURN l_function_id;
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN

Line 134: FROM fnd_form_functions

130: SELECT menu_id
131: INTO l_menu_id
132: FROM fnd_compiled_menu_functions
133: WHERE fnd_compiled_menu_functions.function_id IN (SELECT function_id
134: FROM fnd_form_functions
135: WHERE fnd_form_functions.function_name = p_function_name)
136: AND fnd_compiled_menu_functions.menu_id = (SELECT menu_id
137: FROM fnd_menus
138: WHERE fnd_menus.menu_name = p_menu_name);

Line 135: WHERE fnd_form_functions.function_name = p_function_name)

131: INTO l_menu_id
132: FROM fnd_compiled_menu_functions
133: WHERE fnd_compiled_menu_functions.function_id IN (SELECT function_id
134: FROM fnd_form_functions
135: WHERE fnd_form_functions.function_name = p_function_name)
136: AND fnd_compiled_menu_functions.menu_id = (SELECT menu_id
137: FROM fnd_menus
138: WHERE fnd_menus.menu_name = p_menu_name);
139: RETURN l_menu_id;

Line 330: l_function_name fnd_form_functions.function_name%TYPE;

326: l_menu_id NUMBER;
327: l_object_id NUMBER;
328: l_instance_set_id NUMBER;
329: l_resp_id NUMBER;
330: l_function_name fnd_form_functions.function_name%TYPE;
331: l_check_grant NUMBER := 0;
332: l_inst_name VARCHAR2(30);
333: l_entity_type VARCHAR2(30);
334:

Line 650: l_function_name fnd_form_functions.function_name%TYPE;

646: l_priv VARCHAR2(100) := 'T';
647: l_profile_value VARCHAR2(1000);
648: l_api_name CONSTANT VARCHAR2(1000) := 'has_privileges';
649: l_api_version CONSTANT NUMBER := 1.0;
650: l_function_name fnd_form_functions.function_name%TYPE;
651: l_user_name VARCHAR2(40);
652: BEGIN
653: ---check api version
654: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 679: l_function_name fnd_form_functions.function_name%TYPE;

675: p_entity_type IN VARCHAR2,
676: p_instance_pk1_value IN NUMBER)
677: RETURN VARCHAR2
678: IS
679: l_function_name fnd_form_functions.function_name%TYPE;
680: l_user_name VARCHAR2(40);
681: BEGIN
682: RETURN 'T';
683: EXCEPTION

Line 1145: l_function_name fnd_form_functions.function_name%TYPE;

1141:
1142: l_api_name CONSTANT VARCHAR2(30) := 'ulock_entity';
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_user_priv VARCHAR2(1);
1145: l_function_name fnd_form_functions.function_name%TYPE;
1146: l_proj_id NUMBER := 0;
1147: l_locked_entities_tbl number_type_tbl;
1148: BEGIN
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;