APPS.PA_PROJ_TEMPLATE_SETUP_UTILS dependencies on PA_PROJECTS

Line 553: from pa_projects

549: l_id_found_flag VARCHAR2(1) := 'N';
550:
551: cursor c IS
552: select project_id
553: from pa_projects
554: where UPPER(name) = UPPER(p_template_name);
555:
556: BEGIN
557: IF (p_template_id IS NULL) OR (p_template_id = -9999 ) THEN

Line 586: FROM pa_projects

582: -- ID is not empty;
583: IF (p_check_id_flag = 'Y') THEN
584: SELECT project_id
585: INTO x_template_id
586: FROM pa_projects
587: WHERE project_id = p_template_id;
588: ELSIF (p_check_id_flag = 'N') THEN
589: x_template_id := p_template_id;
590: ELSIF (p_check_id_flag = 'A') THEN

Line 665: from pa_projects_v --cannot replace with project_all bcoz project name user enters must be validated with secuured view.

661: l_ndf_exception NUMBER; --to indicate which part of the code raised no_data_found exception
662:
663: cursor c IS
664: select project_id
665: from pa_projects_v --cannot replace with project_all bcoz project name user enters must be validated with secuured view.
666: where name = p_project_name; -- removed the UPPER function for perf. bug 2786121
667:
668: BEGIN
669:

Line 701: FROM pa_projects_all --replaced pa_projects_v with pa_projects_all for perf. bug 2786121

697: -- ID is not empty;
698: IF (p_check_id_flag = 'Y') THEN
699: SELECT project_id
700: INTO x_project_id
701: FROM pa_projects_all --replaced pa_projects_v with pa_projects_all for perf. bug 2786121
702: WHERE project_id = p_project_id;
703: ELSIF (p_check_id_flag = 'N') THEN
704: x_project_id := p_project_id;
705: ELSIF (p_check_id_flag = 'A') THEN

Line 862: FROM PA_PROJECTS_ALL

858:
859: CURSOR get_template_id
860: IS
861: SELECT created_from_project_id
862: FROM PA_PROJECTS_ALL
863: WHERE project_id = p_project_id;
864:
865: CURSOR cur_pa_proj_options(c_project_id NUMBER)
866: IS

Line 875: FROM PA_PROJECTS_ALL

871:
872: CURSOR check_template
873: IS
874: SELECT 'Y'
875: FROM PA_PROJECTS_ALL
876: WHERE project_id = p_project_id
877: AND template_flag = 'Y';
878:
879: BEGIN