DBA Data[Home] [Help]

APPS.PA_MU_DETAILS_V_PKG dependencies on PA_SECURITY

Line 240: pa_security.allow_update(p.project_id) allow_update

236: -- specified by the X_Search_Organization_ID parameter
237: --
238: CURSOR l_proj_csr IS
239: SELECT p.project_id, p.carrying_out_organization_id organization_id,
240: pa_security.allow_update(p.project_id) allow_update
241: FROM pa_projects p
242: WHERE
243: -- p.project_status_code <> 'CLOSED'. **** Archive Purge changes ****
244: pa_project_stus_utils.is_project_status_closed(p.project_status_code) <> 'Y'

Line 246: AND pa_security.Allow_Query(p.project_id) = 'Y';

242: WHERE
243: -- p.project_status_code <> 'CLOSED'. **** Archive Purge changes ****
244: pa_project_stus_utils.is_project_status_closed(p.project_status_code) <> 'Y'
245: AND p.carrying_out_organization_id = X_Search_Organization_ID
246: AND pa_security.Allow_Query(p.project_id) = 'Y';
247:
248: --
249: -- Line_Exists
250: -- This is a local function that will return whether or not the given

Line 308: pa_security.allow_update(project_id)

304: --
305:
306: -- Get the organization_id of the given project
307: SELECT carrying_out_organization_id,
308: pa_security.allow_update(project_id)
309: INTO l_proj_organization_id, l_allow_update
310: FROM pa_projects
311: WHERE project_id = X_Search_Project_ID;
312: