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 1357: from pa_projects_all

1353: IF (p_project_id IS NOT NULL) THEN
1354: IF (p_check_id_flag = 'Y') THEN
1355: select project_id
1356: into x_project_id
1357: from pa_projects_all
1358: where project_id = p_project_id;
1359: ELSE
1360: x_project_id := p_project_id;
1361: END IF;

Line 1365: from pa_projects_all

1361: END IF;
1362: ELSE
1363: select project_id
1364: into x_project_id
1365: from pa_projects_all
1366: where segment1 = p_project_name;
1367: END IF;
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: EXCEPTION

Line 3651: ( p_project_id IN pa_projects_all.project_id%TYPE

3647: This value is used when we create a task version.
3648: ==================================================================*/
3649:
3650: PROCEDURE GET_STRUCTURE_INFO
3651: ( p_project_id IN pa_projects_all.project_id%TYPE
3652: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
3653: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
3654: ,p_is_wp_separate_from_fn IN VARCHAR2
3655: ,p_is_wp_versioning_enabled IN VARCHAR2

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

4510: API Name : GET_TASK_LEVEL
4511:
4512: Parameters Description Type Of Parameter
4513: ========== =============== ===================
4514: p_project_id The Project ID PA_PROJECTS_ALL.PROJECT_ID%TYPE
4515: p_proj_element_id The ProjElementID PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE
4516:
4517: Return Value of this function :
4518: ===============================

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

4523:
4524: In this case,There will not be any entry for those 'pure' workplan tasks in PA_TASKS table.
4525: Hence,for such passed Proj_element_id's this API will return 'X'
4526: */
4527: FUNCTION GET_TASK_LEVEL(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4528: p_proj_element_id PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) RETURN VARCHAR2
4529: IS
4530: l_task_level VARCHAR2(1) :='L';
4531:

Line 4614: FROM pa_projects_all

4610:
4611: BEGIN
4612:
4613: SELECT structure_sharing_code INTO str_sharing_code
4614: FROM pa_projects_all
4615: WHERE project_id = p_project_id;
4616:
4617: --If sharing is enabled, then financial and workplan tasks would be common
4618: IF str_sharing_code = 'SHARE_FULL' OR