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_PROGRESS_PVT dependencies on PA_PROJ_ELEMENTS_UTILS

Line 1583: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'

1579: SELECT l_process_number_temp, element_version_id object_id_from1, 'PA_TASKS', 1
1580: FROM pa_proj_element_versions
1581: WHERE project_id = p_project_id
1582: AND parent_structure_version_id = p_structure_version_id
1583: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1584: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
1585: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
1586: AND object_type = 'PA_TASKS'
1587: UNION

Line 1585: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'

1581: WHERE project_id = p_project_id
1582: AND parent_structure_version_id = p_structure_version_id
1583: --AND PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(element_version_id) = 'N'
1584: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
1585: AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(element_version_id) = 'Y'
1586: AND object_type = 'PA_TASKS'
1587: UNION
1588: SELECT l_process_number_temp, p_structure_version_id object_id_from1, 'PA_TASKS', 1
1589: FROM dual

Line 1729: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

1725: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg =>'l_tsk_base_prog_stat_code_tab('||k||')='||l_tsk_base_prog_stat_code_tab(k), x_Log_Level=> 3);
1726: END IF;
1727: l_tsk_progress_exists := 'N';
1728: l_parent_count := l_parent_count + 1;
1729: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
1730: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
1731:
1732:
1733: IF g1_debug_mode = 'Y' THEN

Line 1730: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746

1726: END IF;
1727: l_tsk_progress_exists := 'N';
1728: l_parent_count := l_parent_count + 1;
1729: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
1730: l_summary_object_flag := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_tsk_object_id_to1_tab(k)); -- 4370746
1731:
1732:
1733: IF g1_debug_mode = 'Y' THEN
1734: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT',x_Msg => 'l_action_allowed='||l_action_allowed, x_Log_Level=> 3);

Line 2118: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

2114: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
2115:
2116: -- Deliverable Status will not get rolled up for deliverable
2117:
2118: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
2119:
2120: IF nvl( l_tsk_weighting_percent_tab(k), 0 ) = 0 THEN
2121: l_action_allowed := 'N';
2122: END IF;

Line 2315: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );

2311: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
2312: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
2313: -- END IF;
2314:
2315: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(l_tsk_status_code_tab(k), 'PROGRESS_ROLLUP' );
2316:
2317: IF nvl(l_tsk_weighting_percent_tab(k), 0) = 0 THEN
2318: l_action_allowed := 'N';
2319: END IF;

Line 2369: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

2365: IF g1_debug_mode = 'Y' THEN
2366: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'Second task cursor for summary task with assignments', x_Log_Level=> 3);
2367: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'cur_tasks_rec.object_id_to1='||cur_tasks_rec.object_id_to1, x_Log_Level=> 3);
2368: END IF;
2369: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
2370:
2371: l_index := l_index + 1;
2372:
2373: l_rollup_table1(l_index).OBJECT_TYPE := cur_tasks_rec.object_type;

Line 2483: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

2479: -- l_rollup_table1(l_index).DIRTY_FLAG1 := 'N';
2480: -- l_rollup_table1(l_index).DIRTY_FLAG2 := 'N';
2481: -- END IF;
2482:
2483: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
2484:
2485: IF nvl( cur_tasks_rec.weighting_percentage, 0 ) = 0 THEN
2486: l_action_allowed := 'N';
2487: END IF;

Line 4148: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'

4144: , pa_object_relationships obj
4145: WHERE ever.project_id = p_project_id
4146: and ever.parent_structure_version_id = p_structure_version_id
4147: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4148: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'
4149: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'
4150: and ever.object_type = 'PA_TASKS'
4151: AND obj.object_id_to1 = ever.element_version_id
4152: AND obj.relationship_type = 'S'

Line 4149: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'

4145: WHERE ever.project_id = p_project_id
4146: and ever.parent_structure_version_id = p_structure_version_id
4147: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
4148: -- and PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(ever.element_version_id) = 'N'
4149: and PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(ever.element_version_id) = 'Y'
4150: and ever.object_type = 'PA_TASKS'
4151: AND obj.object_id_to1 = ever.element_version_id
4152: AND obj.relationship_type = 'S'
4153: and p_rollup_entire_wbs='Y';

Line 6935: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

6931: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Inside Tasks Loop', x_Log_Level=> 3);
6932: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'cur_tasks_rec.base_progress_status_code='||cur_tasks_rec.base_progress_status_code, x_Log_Level=> 3);
6933: END IF;
6934:
6935: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
6936:
6937: -- We only populate the asssignment and deliverable records n the PL/SQL table for the input task
6938: -- , assignments and deliverables of the sub-tasks are not considered. -- Fix for Bug # 4032987.
6939:

Line 7313: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

7309: l_rollup_table1(l_index).DIRTY_FLAG2 := 'Y';
7310:
7311: -- Deliverable Status will not get rolled up for deliverable
7312:
7313: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
7314:
7315: IF nvl( l_task_weighting_percentage, 0 ) = 0 THEN
7316: l_action_allowed := 'N';
7317: END IF;

Line 7348: -- l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);--4370746

7344: l_rollup_table1(l_index).PARENT_OBJECT_ID := cur_tasks_rec.object_id_from1; --Parent Task Version Id
7345: l_rollup_table1(l_index).WBS_LEVEL := NVL( cur_tasks_rec.wbs_level, 0 );
7346:
7347: -- 4582956 Begin
7348: -- l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);--4370746
7349: IF cur_tasks_rec.object_id_to1 = nvl(l_subproj_task_version_id, -789) THEN
7350: -- 4586449 : Passing L for link tasks
7351: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'L'; --Link task shd be treated as summary task
7352: --l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'Y'; --Link task shd be treated as summary task

Line 7354: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);

7350: -- 4586449 : Passing L for link tasks
7351: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'L'; --Link task shd be treated as summary task
7352: --l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := 'Y'; --Link task shd be treated as summary task
7353: ELSE
7354: l_rollup_table1(l_index).SUMMARY_OBJECT_FLAG := PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(cur_tasks_rec.object_id_to1);
7355: END IF;
7356: -- 4582956 end
7357:
7358: -- Rollup Percent Complete Rollup

Line 7557: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id ) = 'N'

7553:
7554: /*
7555: --bug 3951982
7556: --populate scheduling pl/sql table with sub-tasks of a summary tasks if it has assignments.
7557: IF PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_version_id ) = 'N'
7558: AND pa_progress_utils.check_assignment_exists(p_project_id,p_task_version_id, 'PA_TASKS') = 'Y'
7559: THEN
7560: -- Loop thru all tasks of a passed task
7561: FOR cur_tasks_rec in cur_tasks( p_task_version_id ) LOOP

Line 7569: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );

7565: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'Inside Tasks Loop: Second pass', x_Log_Level=> 3);
7566: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'p_task_version_id='||p_task_version_id, x_Log_Level=> 3);
7567: END IF;
7568:
7569: l_action_allowed := PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED( cur_tasks_rec.status_code, 'PROGRESS_ROLLUP' );
7570:
7571: IF g1_debug_mode = 'Y' THEN
7572: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'l_index='||l_index, x_Log_Level=> 3);
7573: END IF;

Line 8058: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_task_version_id )= 'Y'

8054: END IF;
8055: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
8056: -- 4533112 : Now base_progress_status_code is not used
8057: /*
8058: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_task_version_id )= 'Y'
8059: THEN
8060: -- l_rolled_up_base_per_comp := nvl(l_cur_pa_rollup1_rec.base_percent_complete,0);
8061: l_rolled_up_base_prog_stat := l_cur_pa_rollup1_rec.base_progress_status_code;
8062: ELSE