DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on PA_MOAC_UTILS

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

337: WHERE ppa.project_id=ci.project_id
338: AND ci.ci_id=p_ci_id;
339:
340: --Control item cannot be updated across OU
341: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
342: --for the project in concern to this function. The function would return N if the project is not secured.
343: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
344: RETURN 'F';
345: END IF;

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

339:
340: --Control item cannot be updated across OU
341: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
342: --for the project in concern to this function. The function would return N if the project is not secured.
343: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
344: RETURN 'F';
345: END IF;
346:
347: --Project Authorities and Owner can update the item

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

398: l_project_id := p_project_id;
399: l_project_org_id := p_proj_org_id;
400:
401: --Control item cannot be updated across OU
402: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
403: --for the project in concern to this function. The function would return N if the project is not secured.
404: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
405: RETURN 'F';
406: END IF;

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

400:
401: --Control item cannot be updated across OU
402: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
403: --for the project in concern to this function. The function would return N if the project is not secured.
404: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
405: RETURN 'F';
406: END IF;
407:
408: --Project Authorities and Owner can update the item

Line 455: -- The Function pa_moac_utils.check_access was failing since MOAC initialization was not done

451: WHERE ci.project_id=ppa.project_id
452: AND ci.ci_id = p_ci_id;
453:
454: --Bug#9791886
455: -- The Function pa_moac_utils.check_access was failing since MOAC initialization was not done
456: pa_moac_utils.initialize;
457: --Control item cannot be updated across OU
458: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
459: --for the project in concern to this function. The function would return N if the project is not secured.

Line 456: pa_moac_utils.initialize;

452: AND ci.ci_id = p_ci_id;
453:
454: --Bug#9791886
455: -- The Function pa_moac_utils.check_access was failing since MOAC initialization was not done
456: pa_moac_utils.initialize;
457: --Control item cannot be updated across OU
458: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
459: --for the project in concern to this function. The function would return N if the project is not secured.
460: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN

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

454: --Bug#9791886
455: -- The Function pa_moac_utils.check_access was failing since MOAC initialization was not done
456: pa_moac_utils.initialize;
457: --Control item cannot be updated across OU
458: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
459: --for the project in concern to this function. The function would return N if the project is not secured.
460: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
461: RETURN 'F';
462: END IF;

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

456: pa_moac_utils.initialize;
457: --Control item cannot be updated across OU
458: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
459: --for the project in concern to this function. The function would return N if the project is not secured.
460: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
461: RETURN 'F';
462: END IF;
463: --Project Authorities and Owner can change the owner the item
464: IF check_proj_auth_ci(l_project_id, p_user_id, p_resp_id) = 'T' OR

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

562: WHERE ci.project_id=ppa.project_id
563: AND ci.ci_id = p_ci_id;
564:
565: --Control item cannot be updated across OU
566: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
567: --for the project in concern to this function. The function would return N if the project is not secured.
568: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
569: RETURN 'F';
570: END IF;

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

564:
565: --Control item cannot be updated across OU
566: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
567: --for the project in concern to this function. The function would return N if the project is not secured.
568: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
569: RETURN 'F';
570: END IF;
571:
572: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR

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

601: WHERE ci.project_id=ppa.project_id
602: AND ci.ci_id = p_ci_id;
603:
604: --Control item cannot be updated across OU
605: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
606: --for the project in concern to this function. The function would return N if the project is not secured.
607: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
608: RETURN 'F';
609: END IF;

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

603:
604: --Control item cannot be updated across OU
605: --Bug#4519391.Modified the if below to use the function pa_moac_utils.check_access.Passing the org_id
606: --for the project in concern to this function. The function would return N if the project is not secured.
607: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
608: RETURN 'F';
609: END IF;
610:
611: IF check_proj_auth_ci(l_project_id, p_user_id, fnd_global.resp_id) = 'T' OR

Line 714: --Bug#12847666. Added the if below to use the function pa_moac_utils.check_access.Passing the org_id

710: SELECT org_id INTO l_project_org_id
711: FROM pa_projects_all WHERE project_id=p_project_id;
712:
713: --Control item cannot be updated across OU
714: --Bug#12847666. Added the if below to use the function pa_moac_utils.check_access.Passing the org_id
715: --for the project in concern to this function. The function would return N if the project is not secured.
716: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
717: G_ci_type_tab(p_ci_type_id) := 'F';
718: RETURN G_ci_type_tab(p_ci_type_id);

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

712:
713: --Control item cannot be updated across OU
714: --Bug#12847666. Added the if below to use the function pa_moac_utils.check_access.Passing the org_id
715: --for the project in concern to this function. The function would return N if the project is not secured.
716: IF (pa_moac_utils.check_access(l_project_org_id) = 'N') THEN
717: G_ci_type_tab(p_ci_type_id) := 'F';
718: RETURN G_ci_type_tab(p_ci_type_id);
719: END IF;
720: