eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECTS_ALL

Line 336: pa_projects_all ppa

332:
333: SELECT ci.project_id, ppa.org_id
334: INTO l_project_id, l_project_org_id
335: FROM pa_control_items ci,
336: pa_projects_all ppa
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

Line 393: pa_projects_all ppa

389: /*
390: SELECT ci.project_id, ppa.org_id
391: INTO l_project_id, l_project_org_id
392: FROM pa_control_items ci,
393: pa_projects_all ppa
394: WHERE ppa.project_id=ci.project_id
395: AND ci.ci_id=p_ci_id;
396: */
397:

Line 450: FROM pa_control_items ci, pa_projects_all ppa

446: l_project_org_id NUMBER;
447: BEGIN
448: SELECT ci.project_id, ppa.org_id
449: INTO l_project_id, l_project_org_id
450: FROM pa_control_items ci, pa_projects_all ppa
451: WHERE ci.project_id=ppa.project_id
452: AND ci.ci_id = p_ci_id;
453:
454: --Bug#9791886

Line 561: FROM pa_control_items ci, pa_projects_all ppa

557: end if;-- if(p_calling_context <> 'AMG') then
558:
559: SELECT ci.project_id, ppa.org_id
560: INTO l_project_id, l_project_org_id
561: FROM pa_control_items ci, pa_projects_all ppa
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

Line 600: FROM pa_control_items ci, pa_projects_all ppa

596:
597: BEGIN
598: SELECT ci.project_id, ppa.org_id
599: INTO l_project_id, l_project_org_id
600: FROM pa_control_items ci, pa_projects_all ppa
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

Line 711: FROM pa_projects_all WHERE project_id=p_project_id;

707: l_resource_id NUMBER := -999;
708: l_project_org_id NUMBER; -- Bug#12847666
709: BEGIN
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.

Line 750: pa_projects_all ppa,

746: BEGIN
747: SELECT 1
748: INTO l_tmp
749: FROM pa_ci_type_usage citu,
750: pa_projects_all ppa,
751: pa_project_types_all ppt
752: WHERE ppa.project_id = p_project_id
753: AND ppt.project_type = ppa.project_type
754: AND citu.project_type_id = ppt.project_type_id