APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJECTS_ALL

Line 51: select '1' from pa_projects_all

47: l_msg_count NUMBER;
48: l_msg_data varchar2(250);
49:
50: cursor c1 IS
51: select '1' from pa_projects_all
52: where project_id = p_project_id
53: and template_flag = 'Y';
54: l_dummy VARCHAR2(1);
55: -- bug 4239490

Line 1316: from pa_projects_all

1312: IF (p_project_id IS NOT NULL) THEN
1313: IF (p_check_id_flag = 'Y') THEN
1314: select project_id
1315: into x_project_id
1316: from pa_projects_all
1317: where project_id = p_project_id;
1318: ELSE
1319: x_project_id := p_project_id;
1320: END IF;

Line 1324: from pa_projects_all

1320: END IF;
1321: ELSE
1322: select project_id
1323: into x_project_id
1324: from pa_projects_all
1325: where segment1 = p_project_name;
1326: END IF;
1327: x_return_status := FND_API.G_RET_STS_SUCCESS;
1328: EXCEPTION

Line 3558: ( p_project_id IN pa_projects_all.project_id%TYPE

3554: This value is used when we create a task version.
3555: ==================================================================*/
3556:
3557: PROCEDURE GET_STRUCTURE_INFO
3558: ( p_project_id IN pa_projects_all.project_id%TYPE
3559: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
3560: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
3561: ,p_is_wp_separate_from_fn IN VARCHAR2
3562: ,p_is_wp_versioning_enabled IN VARCHAR2

Line 4421: p_project_id The Project ID PA_PROJECTS_ALL.PROJECT_ID%TYPE

4417: API Name : GET_TASK_LEVEL
4418:
4419: Parameters Description Type Of Parameter
4420: ========== =============== ===================
4421: p_project_id The Project ID PA_PROJECTS_ALL.PROJECT_ID%TYPE
4422: p_proj_element_id The ProjElementID PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE
4423:
4424: Return Value of this function :
4425: ===============================

Line 4434: FUNCTION GET_TASK_LEVEL(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4430:
4431: In this case,There will not be any entry for those 'pure' workplan tasks in PA_TASKS table.
4432: Hence,for such passed Proj_element_id's this API will return 'X'
4433: */
4434: FUNCTION GET_TASK_LEVEL(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4435: p_proj_element_id PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
4436: IS
4437: l_task_level VARCHAR2(1) :='L';
4438:

Line 4521: FROM pa_projects_all

4517:
4518: BEGIN
4519:
4520: SELECT structure_sharing_code INTO str_sharing_code
4521: FROM pa_projects_all
4522: WHERE project_id = p_project_id;
4523:
4524: --If sharing is enabled, then financial and workplan tasks would be common
4525: IF str_sharing_code = 'SHARE_FULL' OR