APPS.DOM_SECURITY_PUB dependencies on FND_MENUS

Line 59: l_role_name FND_MENUS.MENU_NAME%TYPE;

55: l_api_name CONSTANT VARCHAR2(50) := 'Grant_Document_Role';
56: l_grant_guid FND_GRANTS.GRANT_GUID%TYPE ;
57: l_grant_exist VARCHAR2(10);
58: l_return_status VARCHAR2(3) ;
59: l_role_name FND_MENUS.MENU_NAME%TYPE;
60: l_pk4_value VARCHAR2(50);
61: BEGIN
62:
63: -- Initialize API return status to success

Line 68: FROM fnd_menus

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: SELECT menu_name
67: INTO l_role_name
68: FROM fnd_menus
69: WHERE menu_id = p_role_id;
70:
71: FOR lcount in p_party_ids.first .. p_party_ids.last LOOP
72:

Line 189: l_role_name FND_MENUS.MENU_NAME%TYPE;

185:
186: l_api_name CONSTANT VARCHAR2(50) := 'Revoke_Document_Role';
187: l_return_status VARCHAR2(1) ;
188: l_error_code NUMBER(1) ;
189: l_role_name FND_MENUS.MENU_NAME%TYPE;
190: l_role_ids FND_ARRAY_OF_NUMBER_25;
191: l_object_id NUMBER ;
192: lcount1 NUMBER;
193: l_ocs_role_to_revoke VARCHAR2(30);

Line 232: FROM fnd_menus

228:
229: if p_role_id is not null then
230: SELECT menu_name
231: INTO l_role_name
232: FROM fnd_menus
233: WHERE menu_id = p_role_id;
234:
235: FND_GRANTS_PKG.delete_grant(
236: p_grantee_type => l_grantee_type,

Line 274: FROM fnd_menus

270: if l_role_ids(lcount1) is not null then
271:
272: SELECT menu_name
273: INTO l_role_name
274: FROM fnd_menus
275: WHERE menu_id = l_role_ids(lcount1);
276:
277: FND_GRANTS_PKG.delete_grant(
278: p_grantee_type => l_grantee_type,

Line 382: l_role_name FND_MENUS.MENU_NAME%TYPE;

378: IS
379: l_api_name CONSTANT VARCHAR2(50) := 'Grant_Attachments_OCSRole';
380: l_return_status VARCHAR2(1) ;
381: l_error_code NUMBER(1) ;
382: l_role_name FND_MENUS.MENU_NAME%TYPE;
383: l_user_name VARCHAR2(30);
384: l_service_url VARCHAR2(100);
385: l_user_login VARCHAR2(30);
386: l_protocol VARCHAR2(30);

Line 708: l_role_name FND_MENUS.MENU_NAME%TYPE;

704:
705: l_api_name CONSTANT VARCHAR2(50) := 'Revoke_Attachments_OCSRole';
706: l_return_status VARCHAR2(1) ;
707: l_error_code NUMBER(1) ;
708: l_role_name FND_MENUS.MENU_NAME%TYPE;
709: l_user_name VARCHAR2(30);
710: l_service_url VARCHAR2(100);
711: l_user_login VARCHAR2(30);
712: l_protocol VARCHAR2(30);