DBA Data[Home] [Help]

APPS.PA_SECURITY dependencies on PA_SECURITY_PVT

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

570: fnd_grants fg,
571: fnd_objects fo
572: WHERE
573: --fg.grantee_key = 'PER:'||X_person_id and /* commenting this line for 11.5.10 security changes */
574: fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and
575: /* replaced the above line with this call. The last paramater will assert that the function will not write to database. */
576: fg.grantee_type = 'USER' and
577: fg.menu_id = ppr.menu_id and -- Added for bug 3224170
578: ppr.project_role_id = 3 and -- Added for bug 3224170

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

679: fnd_objects fo,
680: fnd_menus fm
681: WHERE */
682: --fg.grantee_key = 'PER:'||X_person_id and /* commenting this line for 11.5.10 security changes */
683: /* fg.grantee_key = PA_SECURITY_PVT.get_grantee_key( 'PERSON', X_person_id, 'N') and*/
684: /* replaced the above line with this call. The last paramater will assert that the function will not write to database. */
685: /* fg.grantee_type = 'USER' and
686: ppa.project_id = X_project_id and
687: to_char(ppa.carrying_out_organization_id) = fg.instance_pk1_value and -- bug2777621