DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_FORM_FUNCTIONS

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

1517: )
1518: RETURN VARCHAR2
1519: IS
1520:
1521: l_privilege_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE; --4105308
1522:
1523: BEGIN
1524:
1525: IF (UPPER(p_which_priv_to_return) = 'VIEW') THEN

Line 1529: FROM FND_FORM_FUNCTIONS F

1525: IF (UPPER(p_which_priv_to_return) = 'VIEW') THEN
1526:
1527: SELECT F.FUNCTION_NAME
1528: INTO l_privilege_name
1529: FROM FND_FORM_FUNCTIONS F
1530: ,EGO_FND_DSC_FLX_CTX_EXT E
1531: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1532: AND E.VIEW_PRIVILEGE_ID = F.FUNCTION_ID;
1533:

Line 1538: FROM FND_FORM_FUNCTIONS F

1534: ELSIF (UPPER(p_which_priv_to_return) = 'EDIT') THEN
1535:
1536: SELECT F.FUNCTION_NAME
1537: INTO l_privilege_name
1538: FROM FND_FORM_FUNCTIONS F
1539: ,EGO_FND_DSC_FLX_CTX_EXT E
1540: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1541: AND E.EDIT_PRIVILEGE_ID = F.FUNCTION_ID;
1542:

Line 4609: FROM fnd_form_functions

4605: IF l_data_level_rec.enable_view_priv = 'Y' THEN
4606: IF p_view_priv_id IS NOT NULL THEN
4607: SELECT function_id
4608: INTO l_view_priv_id
4609: FROM fnd_form_functions
4610: WHERE function_id = p_view_priv_id;
4611: ELSIF p_view_priv_name IS NOT NULL THEN
4612: SELECT function_id
4613: INTO l_view_priv_id

Line 4614: FROM fnd_form_functions

4610: WHERE function_id = p_view_priv_id;
4611: ELSIF p_view_priv_name IS NOT NULL THEN
4612: SELECT function_id
4613: INTO l_view_priv_id
4614: FROM fnd_form_functions
4615: WHERE function_name = p_view_priv_name;
4616: ELSIF p_user_view_priv_name IS NOT NULL THEN
4617: SELECT function_id
4618: INTO l_view_priv_id

Line 4619: FROM fnd_form_functions_vl

4615: WHERE function_name = p_view_priv_name;
4616: ELSIF p_user_view_priv_name IS NOT NULL THEN
4617: SELECT function_id
4618: INTO l_view_priv_id
4619: FROM fnd_form_functions_vl
4620: WHERE user_function_name = p_user_view_priv_name;
4621: ELSE
4622: l_view_priv_id := NULL;
4623: END IF;

Line 4656: FROM fnd_form_functions

4652: IF l_data_level_rec.enable_edit_priv = 'Y' THEN
4653: IF p_edit_priv_id IS NOT NULL THEN
4654: SELECT function_id
4655: INTO l_edit_priv_id
4656: FROM fnd_form_functions
4657: WHERE function_id = p_edit_priv_id;
4658: ELSIF p_edit_priv_name IS NOT NULL THEN
4659: SELECT function_id
4660: INTO l_edit_priv_id

Line 4661: FROM fnd_form_functions

4657: WHERE function_id = p_edit_priv_id;
4658: ELSIF p_edit_priv_name IS NOT NULL THEN
4659: SELECT function_id
4660: INTO l_edit_priv_id
4661: FROM fnd_form_functions
4662: WHERE function_name = p_edit_priv_name;
4663: ELSIF p_user_edit_priv_name IS NOT NULL THEN
4664: SELECT function_id
4665: INTO l_edit_priv_id

Line 4666: FROM fnd_form_functions_vl

4662: WHERE function_name = p_edit_priv_name;
4663: ELSIF p_user_edit_priv_name IS NOT NULL THEN
4664: SELECT function_id
4665: INTO l_edit_priv_id
4666: FROM fnd_form_functions_vl
4667: WHERE user_function_name = p_user_edit_priv_name;
4668: ELSE
4669: l_edit_priv_id := NULL;
4670: END IF;