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;
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
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;
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
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.
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
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;
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
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;
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
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;
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
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);
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: