[Home] [Help]
825: )
826: IS
827:
828: l_grant_id FND_GRANTS.GRANT_GUID%TYPE;
829: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
830: l_role_id FND_GRANTS.MENU_ID%TYPE;
831: l_return_status VARCHAR2(30);
832: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
833: l_msg_count NUMBER;
961: IS
962:
963: l_set_id FND_GRANTS.INSTANCE_SET_ID%TYPE;
964: l_set_name FND_OBJECT_INSTANCE_SETS.INSTANCE_SET_NAME%TYPE;
965: l_object_name FND_OBJECTS.OBJ_NAME%TYPE;
966: l_role_id FND_GRANTS.MENU_ID%TYPE;
967: l_return_status VARCHAR2(30);
968: l_msg_data VARCHAR2(2000); -- Changed from 30 to 2000 to avoid ora 6502 error
969: l_msg_count NUMBER;
1328:
1329: -- pick the Object id for the organization
1330: SELECT distinct object_id
1331: INTO v_objid
1332: FROM fnd_objects
1333: WHERE obj_name = v_objname;
1334:
1335: -- get the roleid for the Responsibility of type 'Resource Authority');
1336: v_roleid := pa_security_pvt.get_menu_id(v_rolename);
1745:
1746: -- pick the Object id for the organization (seeded data)
1747: SELECT distinct object_id
1748: INTO x_objid
1749: FROM fnd_objects
1750: WHERE obj_name = P_objname;
1751:
1752:
1753: -- reset the error stack
2826: pep.person_id
2827: INTO l_primary_contact_name,
2828: l_primary_contact_id
2829: FROM fnd_grants fg,
2830: fnd_objects fob,
2831: per_all_people_f pep, -- Bug 4684198 - use base table not secure view
2832: wf_roles wfr
2833: /* Bug# 2499051 - Moved the function call to fetch to a local variable at the start of the procedure
2834: (select pa_security_pvt.get_menu_id(p_prim_role_name) menu_id from dual) temp */
3349: CURSOR check_staff_mgr IS
3350: SELECT 'Y'
3351: FROM pa_resources_denorm res,
3352: fnd_grants fg,
3353: fnd_objects fob,
3354: per_all_people_f per,
3355: wf_roles wfr,
3356: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
3357: from dual) res_auth_menu