DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_FORM_FUNCTIONS

Line 1579: l_privilege_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308

1575: )
1576: RETURN VARCHAR2
1577: IS
1578:
1579: l_privilege_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1580:
1581: BEGIN
1582:
1583: IF (UPPER(p_which_priv_to_return) = 'VIEW') THEN

Line 1587: FROM FND_FORM_FUNCTIONS F

1583: IF (UPPER(p_which_priv_to_return) = 'VIEW') THEN
1584:
1585: SELECT F.FUNCTION_NAME
1586: INTO l_privilege_name
1587: FROM FND_FORM_FUNCTIONS F
1588: ,EGO_FND_DSC_FLX_CTX_EXT E
1589: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1590: AND E.VIEW_PRIVILEGE_ID = F.FUNCTION_ID;
1591:

Line 1596: FROM FND_FORM_FUNCTIONS F

1592: ELSIF (UPPER(p_which_priv_to_return) = 'EDIT') THEN
1593:
1594: SELECT F.FUNCTION_NAME
1595: INTO l_privilege_name
1596: FROM FND_FORM_FUNCTIONS F
1597: ,EGO_FND_DSC_FLX_CTX_EXT E
1598: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1599: AND E.EDIT_PRIVILEGE_ID = F.FUNCTION_ID;
1600:

Line 4745: FROM fnd_form_functions

4741: IF l_data_level_rec.enable_view_priv = 'Y' THEN
4742: IF p_view_priv_id IS NOT NULL THEN
4743: SELECT function_id
4744: INTO l_view_priv_id
4745: FROM fnd_form_functions
4746: WHERE function_id = p_view_priv_id;
4747: ELSIF p_view_priv_name IS NOT NULL THEN
4748: SELECT function_id
4749: INTO l_view_priv_id

Line 4750: FROM fnd_form_functions

4746: WHERE function_id = p_view_priv_id;
4747: ELSIF p_view_priv_name IS NOT NULL THEN
4748: SELECT function_id
4749: INTO l_view_priv_id
4750: FROM fnd_form_functions
4751: WHERE function_name = p_view_priv_name;
4752: ELSIF p_user_view_priv_name IS NOT NULL THEN
4753: SELECT function_id
4754: INTO l_view_priv_id

Line 4755: FROM fnd_form_functions_vl

4751: WHERE function_name = p_view_priv_name;
4752: ELSIF p_user_view_priv_name IS NOT NULL THEN
4753: SELECT function_id
4754: INTO l_view_priv_id
4755: FROM fnd_form_functions_vl
4756: WHERE user_function_name = p_user_view_priv_name;
4757: ELSE
4758: l_view_priv_id := NULL;
4759: END IF;

Line 4792: FROM fnd_form_functions

4788: IF l_data_level_rec.enable_edit_priv = 'Y' THEN
4789: IF p_edit_priv_id IS NOT NULL THEN
4790: SELECT function_id
4791: INTO l_edit_priv_id
4792: FROM fnd_form_functions
4793: WHERE function_id = p_edit_priv_id;
4794: ELSIF p_edit_priv_name IS NOT NULL THEN
4795: SELECT function_id
4796: INTO l_edit_priv_id

Line 4797: FROM fnd_form_functions

4793: WHERE function_id = p_edit_priv_id;
4794: ELSIF p_edit_priv_name IS NOT NULL THEN
4795: SELECT function_id
4796: INTO l_edit_priv_id
4797: FROM fnd_form_functions
4798: WHERE function_name = p_edit_priv_name;
4799: ELSIF p_user_edit_priv_name IS NOT NULL THEN
4800: SELECT function_id
4801: INTO l_edit_priv_id

Line 4802: FROM fnd_form_functions_vl

4798: WHERE function_name = p_edit_priv_name;
4799: ELSIF p_user_edit_priv_name IS NOT NULL THEN
4800: SELECT function_id
4801: INTO l_edit_priv_id
4802: FROM fnd_form_functions_vl
4803: WHERE user_function_name = p_user_edit_priv_name;
4804: ELSE
4805: l_edit_priv_id := NULL;
4806: END IF;

Line 15697: FROM EGO_ACTIONS_V EAV, FND_FORM_FUNCTIONS FFF

15693: EAV.SECURITY_PRIVILEGE_NAME,
15694: FFF.FUNCTION_NAME,
15695: EAV.ATTR_GROUP_ID,
15696: EAV.ENABLE_KEY_ATTRIBUTES
15697: FROM EGO_ACTIONS_V EAV, FND_FORM_FUNCTIONS FFF
15698: WHERE EAV.SECURITY_PRIVILEGE_ID = FFF.FUNCTION_ID(+)
15699: AND classification_code IN
15700: (SELECT classification_code
15701: FROM ego_obj_attr_grp_assocs_v