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.

[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 12535: Select top_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev

12531: FROM pa_tasks
12532: WHERE project_id=p_project_id and task_id=l_task_id;
12533:
12534: /*Cursor Get_Top_Task_Id IS
12535: Select top_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev
12536: where pt.project_id=p_project_id and ppev.proj_element_id=pt.task_id
12537: and ppev.element_version_id=p_task_id and ppev.parent_structure_version_id=p_structure_version_id;*/
12538:
12539: --This returns the parent task id when element version id is passed

Line 12541: Select parent_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev

12537: and ppev.element_version_id=p_task_id and ppev.parent_structure_version_id=p_structure_version_id;*/
12538:
12539: --This returns the parent task id when element version id is passed
12540: Cursor get_parent_task(l_task_id NUMBER) IS
12541: Select parent_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev
12542: where pt.project_id=p_project_id and ppev.proj_element_id=pt.task_id
12543: and ppev.element_version_id=l_task_id and ppev.parent_structure_version_id=p_structure_version_id;
12544:
12545: BEGIN

Line 12548: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'

12544:
12545: BEGIN
12546:
12547: If p_event_mode ='ADD_FIRST' THEN
12548: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'
12549: WHERE project_id=p_project_id and element_version_id=p_task_id;
12550: ELSIF p_event_mode in ('ADD_INC','UPDATE') THEN
12551: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'
12552: WHERE project_id=p_project_id and NVL(DEFER_CODE,'X') not in ('S','P')

Line 12551: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'

12547: If p_event_mode ='ADD_FIRST' THEN
12548: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'
12549: WHERE project_id=p_project_id and element_version_id=p_task_id;
12550: ELSIF p_event_mode in ('ADD_INC','UPDATE') THEN
12551: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='C'
12552: WHERE project_id=p_project_id and NVL(DEFER_CODE,'X') not in ('S','P')
12553: AND proj_element_id=p_task_id AND parent_structure_version_id=p_structure_version_id;
12554: ELSIF p_event_mode='DELETE' THEN
12555: OPEN Get_Parent_Task_Id(p_task_id);

Line 12559: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='D'

12555: OPEN Get_Parent_Task_Id(p_task_id);
12556: FETCH Get_Parent_Task_Id INTO l_parent_task_id;
12557: CLOSE Get_Parent_Task_Id;
12558:
12559: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='D'
12560: WHERE project_id=p_project_id and NVL(DEFER_CODE,'X')<>'S'
12561: AND proj_element_id=l_parent_task_id AND parent_structure_version_id=p_structure_version_id;
12562:
12563: ELSIF p_event_mode = 'INDENT' THEN --Mark only task as S

Line 12568: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'

12564: /*OPEN Get_Top_Task_Id;
12565: FETCH Get_Top_Task_Id INTO l_top_task_id;
12566: CLOSE Get_Top_Task_Id;
12567:
12568: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12569: WHERE project_id=p_project_id AND proj_element_id=l_top_task_id
12570: AND parent_structure_version_id=p_structure_version_id;*/
12571: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12572: WHERE project_id=p_project_id and element_version_id=p_task_id

Line 12571: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'

12567:
12568: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12569: WHERE project_id=p_project_id AND proj_element_id=l_top_task_id
12570: AND parent_structure_version_id=p_structure_version_id;*/
12571: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12572: WHERE project_id=p_project_id and element_version_id=p_task_id
12573: AND parent_structure_version_id=p_structure_version_id;
12574:
12575: ELSIF p_event_mode = 'OUTDENT' THEN -- Mark its parent task and parent of parent task id as S

Line 12584: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'

12580: OPEN Get_Parent_Task_Id(l_parent_task_id);
12581: FETCH Get_Parent_Task_Id INTO l_top_parent_task_id;
12582: CLOSE Get_Parent_Task_Id;
12583:
12584: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12585: WHERE project_id=p_project_id
12586: AND proj_element_id in (l_parent_task_id,l_top_parent_task_id)
12587: AND parent_structure_version_id=p_structure_version_id;
12588:

Line 12594: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'

12590: OPEN get_parent_task(p_task_id);
12591: FETCH get_parent_task INTO l_parent_task_id;
12592: CLOSE get_parent_task;
12593:
12594: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12595: WHERE project_id=p_project_id
12596: AND proj_element_id =l_parent_task_id
12597: AND parent_structure_version_id=p_structure_version_id;
12598:

Line 12599: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'

12595: WHERE project_id=p_project_id
12596: AND proj_element_id =l_parent_task_id
12597: AND parent_structure_version_id=p_structure_version_id;
12598:
12599: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='S'
12600: WHERE project_id=p_project_id
12601: AND element_version_id =p_task_id
12602: AND parent_structure_version_id=p_structure_version_id;
12603:

Line 12605: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='P'

12601: AND element_version_id =p_task_id
12602: AND parent_structure_version_id=p_structure_version_id;
12603:
12604: ELSIF p_event_mode='PROGRESS' THEN
12605: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE='P'
12606: WHERE project_id=p_project_id and NVL(DEFER_CODE,'X') not in ('S','P')
12607: AND proj_element_id=p_task_id AND parent_structure_version_id=p_structure_version_id;
12608: ELSE
12609: RAISE FND_API.G_EXC_ERROR;