DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on PA_MOAC_UTILS

Line 326: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id

322: WHERE ppa.project_id=ci.project_id
323: AND ci.ci_id=p_ci_id;
324:
325: --Control item cannot be updated across OU
326: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
327: --for the project in concern to this function. The function would return N if the project is not secured.
328: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
329: RETURN 'F';
330: END IF;

Line 328: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

324:
325: --Control item cannot be updated across OU
326: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
327: --for the project in concern to this function. The function would return N if the project is not secured.
328: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
329: RETURN 'F';
330: END IF;
331:
332: --Project Authorities and Owner can update the item

Line 387: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id

383: l_project_id := p_project_id;
384: l_project_org_id := p_proj_org_id;
385:
386: --Control item cannot be updated across OU
387: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
388: --for the project in concern to this function. The function would return N if the project is not secured.
389: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
390: RETURN 'F';
391: END IF;

Line 389: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

385:
386: --Control item cannot be updated across OU
387: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
388: --for the project in concern to this function. The function would return N if the project is not secured.
389: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
390: RETURN 'F';
391: END IF;
392:
393: --Project Authorities and Owner can update the item

Line 440: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id

436: WHERE ci.project_id=ppa.project_id
437: AND ci.ci_id = p_ci_id;
438:
439: --Control item cannot be updated across OU
440: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
441: --for the project in concern to this function. The function would return N if the project is not secured.
442: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
443: RETURN 'F';
444: END IF;

Line 442: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

438:
439: --Control item cannot be updated across OU
440: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
441: --for the project in concern to this function. The function would return N if the project is not secured.
442: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
443: RETURN 'F';
444: END IF;
445:
446: --Project Authorities and Owner can change the owner the item

Line 549: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id

545: WHERE ci.project_id=ppa.project_id
546: AND ci.ci_id = p_ci_id;
547:
548: --Control item cannot be updated across OU
549: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
550: --for the project in concern to this function. The function would return N if the project is not secured.
551: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
552: RETURN 'F';
553: END IF;

Line 551: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

547:
548: --Control item cannot be updated across OU
549: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
550: --for the project in concern to this function. The function would return N if the project is not secured.
551: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
552: RETURN 'F';
553: END IF;
554:
555: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR

Line 588: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id

584: WHERE ci.project_id=ppa.project_id
585: AND ci.ci_id = p_ci_id;
586:
587: --Control item cannot be updated across OU
588: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
589: --for the project in concern to this function. The function would return N if the project is not secured.
590: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
591: RETURN 'F';
592: END IF;

Line 590: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

586:
587: --Control item cannot be updated across OU
588: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
589: --for the project in concern to this function. The function would return N if the project is not secured.
590: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
591: RETURN 'F';
592: END IF;
593:
594: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR