191:
192: CURSOR csr ( C_Role_ID NUMBER )
193: IS
194: SELECT default_access_level
195: FROM pa_project_role_types prt
196: WHERE prt.project_role_id = C_Role_ID;
197:
198: L_Access_Level VARCHAR2(30);
199: L_Role_ID NUMBER;
501: CURSOR c1 IS
502: SELECT 'T'
503: FROM fnd_form_functions ff
504: , fnd_menu_entries me
505: , pa_project_role_types prt
506: WHERE prt.project_role_id = X_Role_ID
507: AND me.menu_id = prt.menu_id
508: AND me.grant_flag = 'Y'
509: AND ff.function_id = me.function_id