DBA Data[Home] [Help]

APPS.PA_SECURITY dependencies on PA_SECURITY_PVT

Line 490: fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and

486: fnd_grants fg,
487: fnd_objects fo
488: WHERE
489: --fg.grantee_key = 'PER:'||X_person_id and /* commenting this line for 11.5.10 security changes */
490: fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and
491: /* replaced the above line with this call. The last paramater will assert that the function will not write to database. */
492: fg.grantee_type = 'USER' and
493: fg.menu_id = ppr.menu_id and -- Added for bug 3224170
494: ppr.project_role_id = 3 and -- Added for bug 3224170

Line 599: /* fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and*/

595: fnd_objects fo,
596: fnd_menus fm
597: WHERE */
598: --fg.grantee_key = 'PER:'||X_person_id and /* commenting this line for 11.5.10 security changes */
599: /* fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and*/
600: /* replaced the above line with this call. The last paramater will assert that the function will not write to database. */
601: /* fg.grantee_type = 'USER' and
602: ppa.project_id = X_project_id and
603: to_char(ppa.carrying_out_organization_id) = fg.instance_pk1_value and -- bug2777621