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

Line 846: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );

842: */
843: IF p_object_type = 'PA_TASKS'
844: THEN
845: -- 4490532 : Changed from IS_LOWEST_TASK to is_summary_task_or_structure
846: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );
847: --ELSE
848: --l_lowest_level_task := 'N';
849: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_object_version_id) = 'Y' THEN
850: l_lowest_level_task := 'N';

Line 849: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_object_version_id) = 'Y' THEN

845: -- 4490532 : Changed from IS_LOWEST_TASK to is_summary_task_or_structure
846: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );
847: --ELSE
848: --l_lowest_level_task := 'N';
849: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_object_version_id) = 'Y' THEN
850: l_lowest_level_task := 'N';
851: ELSE
852: l_lowest_level_task := 'Y';
853: END IF;

Line 3912: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (

3908: --- call apis if the status is 'CANCELLED'
3909: IF PA_PROGRESS_UTILS.get_system_task_status( l_TASK_STATUS ) = 'CANCELLED'
3910: AND l_element_struc_type = 'WORKPLAN' --maansari: fpm changes
3911: THEN
3912: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (
3913: p_task_id => p_object_id
3914: ,p_task_version_id => p_object_version_id
3915: ,p_new_task_status => l_task_status
3916: ,x_return_status => l_return_status

Line 4176: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_object_id) = 'Y') --Bug 3784405 Satish

4172: END;
4173:
4174: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
4175: AND
4176: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_object_id) = 'Y') --Bug 3784405 Satish
4177: AND
4178: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
4179: THEN
4180: --copy to transaction dates

Line 6230: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_tasks_rec.object_id_to1 );

6226: END LOOP; -- cur_task_assignments_rec in cur_task_assignments(p_object_version_id, p_object_id) LOOP
6227:
6228: -- Now tasks processing starts
6229: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
6230: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_tasks_rec.object_id_to1 );
6231: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( cur_tasks_rec.object_id_to1) = 'Y' THEN
6232: l_lowest_level_task := 'N';
6233: ELSE
6234: l_lowest_level_task := 'Y';

Line 6231: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( cur_tasks_rec.object_id_to1) = 'Y' THEN

6227:
6228: -- Now tasks processing starts
6229: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
6230: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_tasks_rec.object_id_to1 );
6231: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( cur_tasks_rec.object_id_to1) = 'Y' THEN
6232: l_lowest_level_task := 'N';
6233: ELSE
6234: l_lowest_level_task := 'Y';
6235: END IF;

Line 7263: --and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' --bug 4050532

7259: from pa_progress_rollup ppr, pa_proj_element_versions ppev --4871809
7260: where ppr.project_id = p_project_id
7261: and ppr.structure_version_id is null
7262: and ppr.object_type in ('PA_STRUCTURES','PA_ASSIGNMENTS','PA_TASKS')
7263: --and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' --bug 4050532
7264: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
7265: and current_flag = 'Y'
7266: and ppr.proj_element_id = ppev.proj_element_id
7267: and ppev.parent_structure_version_id = p_working_str_version_id

Line 7375: and structure_version_id = pa_proj_elements_utils.latest_published_ver_id(p_project_id,'WORKPLAN')

7371: -- and resource_assignment_id = p_object_id Bug 3764224
7372: and resource_list_member_id = p_object_id -- Bug 3764224 ---:::DJ
7373: and task_id = p_task_id
7374: --and task_version_id = p_task_version_id --bug 3911600
7375: and structure_version_id = pa_proj_elements_utils.latest_published_ver_id(p_project_id,'WORKPLAN')
7376: and NVL(cbs_element_id,-1) = NVL(c_cbs_element_id,-1);--added for cbs 16895485
7377:
7378: cursor cur_proj_prog_attr
7379: is

Line 7654: l_lowest_level_task := NVL(pa_proj_elements_utils.is_lowest_task(l_c1rec.object_version_id),'N'); --bug 4050532

7650: -- Bug 3834339 : Using function to decide whether assignment exists on task or not
7651: l_assignment_exists := 'N';
7652: IF l_c1rec.object_type = 'PA_TASKS' THEN
7653: l_assignment_exists := NVL(PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,l_c1rec.object_version_id,l_c1rec.object_type),'N');
7654: l_lowest_level_task := NVL(pa_proj_elements_utils.is_lowest_task(l_c1rec.object_version_id),'N'); --bug 4050532
7655: END IF;
7656:
7657:
7658: IF g1_debug_mode = 'Y' THEN

Line 8485: ,p_source_struct_ver_id => PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id)

8481:
8482: pa_progress_pvt.copy_actuals_for_workplan(
8483: p_calling_context => 'WP_APPLY_PROGRESS_TO_WORKING'
8484: ,p_project_id => p_project_id
8485: ,p_source_struct_ver_id => PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id)
8486: ,p_target_struct_ver_id => p_working_str_version_id
8487: ,x_return_status => l_return_status
8488: ,x_msg_count => l_msg_count
8489: ,x_msg_data => l_msg_data);

Line 9816: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );

9812: OPEN c_get_task_version_id(p_task_id, p_project_id ,p_structure_version_id);
9813: FETCH c_get_task_version_id INTO l_task_version_id, l_structure_version_id;
9814: CLOSE c_get_task_version_id;
9815: END IF;
9816: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );
9817: l_task_id := p_task_id; -- 3603636
9818: ELSE
9819: l_object_type := p_object_type;
9820: l_task_version_id := p_object_version_id;

Line 9821: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );

9817: l_task_id := p_task_id; -- 3603636
9818: ELSE
9819: l_object_type := p_object_type;
9820: l_task_version_id := p_object_version_id;
9821: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );
9822: l_structure_version_id := p_structure_version_id;
9823: l_task_id := p_object_id; -- 3603636
9824: END IF;
9825:

Line 10083: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') --Bug 3784405 Satish

10079: END;
10080:
10081: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
10082: AND
10083: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') --Bug 3784405 Satish
10084: AND
10085: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
10086: THEN
10087: --copy to transaction dates

Line 11155: -- AND PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id) = 'N' bug 4086613

11151: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr
11152: WHERE ppv.project_id = p_project_id
11153: AND ppv.financial_task_flag = 'Y'
11154: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3957457
11155: -- AND PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id) = 'N' bug 4086613
11156: AND ppv.project_id = ppr.project_id(+)
11157: -- AND ppv.element_version_id = ppc.object_version_id(+)
11158: AND ppv.proj_element_id = ppr.object_id(+) -- Bug 3696820
11159: AND ppr.current_flag(+) = 'Y'

Line 11262: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');

11258: FROM pa_projects_all
11259: WHERE project_id = p_project_id;
11260:
11261:
11262: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');
11263:
11264:
11265: IF PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled(p_project_id) = 'N'
11266: THEN

Line 11344: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);

11340: END LOOP;
11341:
11342: ELSIF l_structure_sharing_code = 'SPLIT_MAPPING'
11343: THEN
11344: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);
11345:
11346: IF l_structure_version_id = -1
11347: THEN
11348: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 11870: and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' -- Bug 3627315 issue 8 Added this condition

11866: where ppr.project_id = p_project_id
11867: and ppr.structure_version_id is null
11868: and ppr.object_type = 'PA_TASKS'
11869: and structure_type = 'WORKPLAN'
11870: and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' -- Bug 3627315 issue 8 Added this condition
11871: and pa_progress_utils.check_assignment_exists(p_project_id,ppr.object_version_id,ppr.object_type) = 'N' -- Bug 3627315 issue 8 Added this condition
11872: and current_flag = 'Y'
11873: Union
11874: select *

Line 12142: l_latest_pub_wp_version_id := p_pub_structure_version_id;--PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');

12138:
12139: -- On this l_as_of_date, there can be working progress record which we will update
12140: -- with working wp version progress
12141:
12142: l_latest_pub_wp_version_id := p_pub_structure_version_id;--PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
12143: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
12144:
12145: IF g1_debug_mode = 'Y' THEN
12146: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'l_as_of_date='||l_as_of_date, x_Log_Level=> 3);

Line 12465: ELSIF l_rec.object_type = 'PA_TASKS' AND NVL(pa_proj_elements_utils.is_lowest_task(l_object_version_id),'N') = 'Y' THEN

12461: END IF;
12462: l_EFF_ROLLUP_PERCENT_COMP := l_rec.eff_rollup_percent_comp; --bug 3906362
12463: --bug 4191360, consider for lowest level task only
12464: --ELSIF l_rec.object_type = 'PA_TASKS' AND NVL(PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,l_object_version_id,l_rec.object_type),'N') = 'N' THEN
12465: ELSIF l_rec.object_type = 'PA_TASKS' AND NVL(pa_proj_elements_utils.is_lowest_task(l_object_version_id),'N') = 'Y' THEN
12466: l_ptav_rec := null;
12467: --bug 4191360, added IF NVL(l_assignment_exists, 'N')
12468: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,l_object_version_id,l_rec.object_type);
12469: IF NVL(l_assignment_exists, 'N') = 'N'

Line 15154: (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_object_version_id ) = 'Y') and

15150: l_object_id := all_objects_in_temp_rec.project_element_id;
15151: l_object_type := 'PA_TASKS';
15152: --- here get the planned value if task is lowest level and PC deriv is EFFORT based and no assignments for the task
15153: if (l_base_pc_deriv_code = 'EFFORT' or l_base_pc_deriv_code = 'COST') and
15154: (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_object_version_id ) = 'Y') and
15155: (PA_PROGRESS_UTILS.check_assignment_exists(l_project_id,l_object_version_id,'PA_TASKS') <> 'Y') then
15156: open get_planned_val_for_task;
15157: fetch get_planned_val_for_task into l_planned_eff, l_planned_cost;
15158: close get_planned_val_for_task;

Line 18462: IF OBJECT_TYPE(l_index1) = 'PA_ASSIGNMENTS' OR (OBJECT_TYPE(l_index1) = 'PA_TASKS' AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(OBJECT_VERSION_ID(l_index1))= 'N')

18458: -- Bug 4533112 Begin
18459: pa_debug.log_message('GET_SUMM_ACT: Calling Progress Client Extension.', 1);
18460: FOR l_index1 IN 1..l_index2 LOOP
18461:
18462: IF OBJECT_TYPE(l_index1) = 'PA_ASSIGNMENTS' OR (OBJECT_TYPE(l_index1) = 'PA_TASKS' AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(OBJECT_VERSION_ID(l_index1))= 'N')
18463: THEN
18464:
18465: l_db_date_override_flag := 'N';
18466: l_db_estimated_start_date := null;

Line 18653: IF (l_db_object_type = 'PA_ASSIGNMENTS' OR (l_db_object_type = 'PA_TASKS' AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_db_object_version_id)= 'N'))

18649: u_actual_start_date(l_index1) := l_db_actual_start_date;
18650: u_base_progress_status_code(l_index1) := l_db_date_override_flag;
18651:
18652:
18653: IF (l_db_object_type = 'PA_ASSIGNMENTS' OR (l_db_object_type = 'PA_TASKS' AND PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_db_object_version_id)= 'N'))
18654: AND l_db_current_flag IN ('Y','N')
18655: THEN
18656:
18657: IF nvl(l_db_date_override_flag, 'N') = 'Y' THEN

Line 23269: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );

23265: OPEN c_get_task_version_id(p_task_id_tbl(i), p_project_id_tbl(i) ,p_structure_version_id_tbl(i));
23266: FETCH c_get_task_version_id INTO l_task_version_id_tbl(i), l_structure_version_id_tbl(i);
23267: CLOSE c_get_task_version_id;
23268: END IF;
23269: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );
23270: l_task_id_tbl(i) := p_task_id_tbl(i);
23271: ELSE
23272: l_object_type_tbl(i) := p_object_type_tbl(i);
23273: l_task_version_id_tbl(i) := p_object_version_id_tbl(i);

Line 23274: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );

23270: l_task_id_tbl(i) := p_task_id_tbl(i);
23271: ELSE
23272: l_object_type_tbl(i) := p_object_type_tbl(i);
23273: l_task_version_id_tbl(i) := p_object_version_id_tbl(i);
23274: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );
23275: l_structure_version_id_tbl(i) := p_structure_version_id_tbl(i);
23276: l_task_id_tbl(i) := p_object_id_tbl(i);
23277: END IF;
23278:

Line 23720: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i)) = 'Y') --Bug 3784405 Satish

23716: END;
23717:
23718: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
23719: AND
23720: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i)) = 'Y') --Bug 3784405 Satish
23721: AND
23722: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id_tbl(i)) = 'Y'))
23723: THEN
23724: --copy to transaction dates