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 826: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );

822:
823: IF p_object_type = 'PA_TASKS'
824: THEN
825: -- 4490532 : Changed from IS_LOWEST_TASK to is_summary_task_or_structure
826: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );
827: --ELSE
828: --l_lowest_level_task := 'N';
829: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_object_version_id) = 'Y' THEN
830: l_lowest_level_task := 'N';

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

825: -- 4490532 : Changed from IS_LOWEST_TASK to is_summary_task_or_structure
826: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id );
827: --ELSE
828: --l_lowest_level_task := 'N';
829: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(p_object_version_id) = 'Y' THEN
830: l_lowest_level_task := 'N';
831: ELSE
832: l_lowest_level_task := 'Y';
833: END IF;

Line 3597: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (

3593: --- call apis if the status is 'CANCELLED'
3594: IF PA_PROGRESS_UTILS.get_system_task_status( l_TASK_STATUS ) = 'CANCELLED'
3595: AND l_element_struc_type = 'WORKPLAN' --maansari: fpm changes
3596: THEN
3597: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok (
3598: p_task_id => p_object_id
3599: ,p_task_version_id => p_object_version_id
3600: ,p_new_task_status => l_task_status
3601: ,x_return_status => l_return_status

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

3768: END;
3769:
3770: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
3771: AND
3772: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_object_id) = 'Y') --Bug 3784405 Satish
3773: AND
3774: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
3775: THEN
3776: --copy to transaction dates

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

5822: END LOOP; -- cur_task_assignments_rec in cur_task_assignments(p_object_version_id, p_object_id) LOOP
5823:
5824: -- Now tasks processing starts
5825: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
5826: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_tasks_rec.object_id_to1 );
5827: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( cur_tasks_rec.object_id_to1) = 'Y' THEN
5828: l_lowest_level_task := 'N';
5829: ELSE
5830: l_lowest_level_task := 'Y';

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

5823:
5824: -- Now tasks processing starts
5825: -- 4490532 : changed from IS_LOWEST_TASK to is_summary_task_or_structure
5826: --l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => cur_tasks_rec.object_id_to1 );
5827: IF PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure( cur_tasks_rec.object_id_to1) = 'Y' THEN
5828: l_lowest_level_task := 'N';
5829: ELSE
5830: l_lowest_level_task := 'Y';
5831: END IF;

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

6855: from pa_progress_rollup ppr, pa_proj_element_versions ppev --4871809
6856: where ppr.project_id = p_project_id
6857: and ppr.structure_version_id is null
6858: and ppr.object_type in ('PA_STRUCTURES','PA_ASSIGNMENTS','PA_TASKS')
6859: --and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' --bug 4050532
6860: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
6861: and current_flag = 'Y'
6862: and ppr.proj_element_id = ppev.proj_element_id
6863: and ppev.parent_structure_version_id = p_working_str_version_id

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

6963: -- and resource_assignment_id = p_object_id Bug 3764224
6964: and resource_list_member_id = p_object_id -- Bug 3764224
6965: and task_id = p_task_id
6966: --and task_version_id = p_task_version_id --bug 3911600
6967: and structure_version_id = pa_proj_elements_utils.latest_published_ver_id(p_project_id,'WORKPLAN');
6968:
6969: cursor cur_proj_prog_attr
6970: is
6971: select pppa.task_weight_basis_code

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

7237: -- Bug 3834339 : Using function to decide whether assignment exists on task or not
7238: l_assignment_exists := 'N';
7239: IF l_c1rec.object_type = 'PA_TASKS' THEN
7240: l_assignment_exists := NVL(PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,l_c1rec.object_version_id,l_c1rec.object_type),'N');
7241: l_lowest_level_task := NVL(pa_proj_elements_utils.is_lowest_task(l_c1rec.object_version_id),'N'); --bug 4050532
7242: END IF;
7243:
7244:
7245: IF g1_debug_mode = 'Y' THEN

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

8063:
8064: pa_progress_pvt.copy_actuals_for_workplan(
8065: p_calling_context => 'WP_APPLY_PROGRESS_TO_WORKING'
8066: ,p_project_id => p_project_id
8067: ,p_source_struct_ver_id => PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id)
8068: ,p_target_struct_ver_id => p_working_str_version_id
8069: ,x_return_status => l_return_status
8070: ,x_msg_count => l_msg_count
8071: ,x_msg_data => l_msg_data);

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

9379: OPEN c_get_task_version_id(p_task_id, p_project_id ,p_structure_version_id);
9380: FETCH c_get_task_version_id INTO l_task_version_id, l_structure_version_id;
9381: CLOSE c_get_task_version_id;
9382: END IF;
9383: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );
9384: l_task_id := p_task_id; -- 3603636
9385: ELSE
9386: l_object_type := p_object_type;
9387: l_task_version_id := p_object_version_id;

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

9384: l_task_id := p_task_id; -- 3603636
9385: ELSE
9386: l_object_type := p_object_type;
9387: l_task_version_id := p_object_version_id;
9388: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id );
9389: l_structure_version_id := p_structure_version_id;
9390: l_task_id := p_object_id; -- 3603636
9391: END IF;
9392:

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

9646: END;
9647:
9648: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
9649: AND
9650: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id) = 'Y') --Bug 3784405 Satish
9651: AND
9652: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id) = 'Y'))
9653: THEN
9654: --copy to transaction dates

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

10709: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr
10710: WHERE ppv.project_id = p_project_id
10711: AND ppv.financial_task_flag = 'Y'
10712: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3957457
10713: -- AND PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id) = 'N' bug 4086613
10714: AND ppv.project_id = ppr.project_id(+)
10715: -- AND ppv.element_version_id = ppc.object_version_id(+)
10716: AND ppv.proj_element_id = ppr.object_id(+) -- Bug 3696820
10717: AND ppr.current_flag(+) = 'Y'

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

10816: FROM pa_projects_all
10817: WHERE project_id = p_project_id;
10818:
10819:
10820: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');
10821:
10822:
10823: IF PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled(p_project_id) = 'N'
10824: THEN

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

10898: END LOOP;
10899:
10900: ELSIF l_structure_sharing_code = 'SPLIT_MAPPING'
10901: THEN
10902: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);
10903:
10904: IF l_structure_version_id = -1
10905: THEN
10906: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

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

11416: where ppr.project_id = p_project_id
11417: and ppr.structure_version_id is null
11418: and ppr.object_type = 'PA_TASKS'
11419: and structure_type = 'WORKPLAN'
11420: and pa_proj_elements_utils.is_lowest_task(ppr.object_version_id) = 'Y' -- Bug 3627315 issue 8 Added this condition
11421: 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
11422: and current_flag = 'Y'
11423: Union
11424: select *

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

11685:
11686: -- On this l_as_of_date, there can be working progress record which we will update
11687: -- with working wp version progress
11688:
11689: l_latest_pub_wp_version_id := p_pub_structure_version_id;--PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
11690: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
11691:
11692: IF g1_debug_mode = 'Y' THEN
11693: 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 12009: ELSIF l_rec.object_type = 'PA_TASKS' AND NVL(pa_proj_elements_utils.is_lowest_task(l_object_version_id),'N') = 'Y' THEN

12005: END IF;
12006: l_EFF_ROLLUP_PERCENT_COMP := l_rec.eff_rollup_percent_comp; --bug 3906362
12007: --bug 4191360, consider for lowest level task only
12008: --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
12009: ELSIF l_rec.object_type = 'PA_TASKS' AND NVL(pa_proj_elements_utils.is_lowest_task(l_object_version_id),'N') = 'Y' THEN
12010: l_ptav_rec := null;
12011: --bug 4191360, added IF NVL(l_assignment_exists, 'N')
12012: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,l_object_version_id,l_rec.object_type);
12013: IF NVL(l_assignment_exists, 'N') = 'N'

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

14558: l_object_id := all_objects_in_temp_rec.project_element_id;
14559: l_object_type := 'PA_TASKS';
14560: --- here get the planned value if task is lowest level and PC deriv is EFFORT based and no assignments for the task
14561: if (l_base_pc_deriv_code = 'EFFORT' or l_base_pc_deriv_code = 'COST') and
14562: (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_object_version_id ) = 'Y') and
14563: (PA_PROGRESS_UTILS.check_assignment_exists(l_project_id,l_object_version_id,'PA_TASKS') <> 'Y') then
14564: open get_planned_val_for_task;
14565: fetch get_planned_val_for_task into l_planned_eff, l_planned_cost;
14566: close get_planned_val_for_task;

Line 17288: 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')

17284: -- Bug 4533112 Begin
17285: pa_debug.log_message('GET_SUMM_ACT: Calling Progress Client Extension.', 1);
17286: FOR l_index1 IN 1..l_index2 LOOP
17287:
17288: 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')
17289: THEN
17290:
17291: l_db_date_override_flag := 'N';
17292: l_db_estimated_start_date := null;

Line 17479: 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'))

17475: u_actual_start_date(l_index1) := l_db_actual_start_date;
17476: u_base_progress_status_code(l_index1) := l_db_date_override_flag;
17477:
17478:
17479: 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'))
17480: AND l_db_current_flag IN ('Y','N')
17481: THEN
17482:
17483: IF nvl(l_db_date_override_flag, 'N') = 'Y' THEN

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

21782: OPEN c_get_task_version_id(p_task_id_tbl(i), p_project_id_tbl(i) ,p_structure_version_id_tbl(i));
21783: FETCH c_get_task_version_id INTO l_task_version_id_tbl(i), l_structure_version_id_tbl(i);
21784: CLOSE c_get_task_version_id;
21785: END IF;
21786: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );
21787: l_task_id_tbl(i) := p_task_id_tbl(i);
21788: ELSE
21789: l_object_type_tbl(i) := p_object_type_tbl(i);
21790: l_task_version_id_tbl(i) := p_object_version_id_tbl(i);

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

21787: l_task_id_tbl(i) := p_task_id_tbl(i);
21788: ELSE
21789: l_object_type_tbl(i) := p_object_type_tbl(i);
21790: l_task_version_id_tbl(i) := p_object_version_id_tbl(i);
21791: l_lowest_level_task_tbl(i) := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_task_version_id_tbl(i) );
21792: l_structure_version_id_tbl(i) := p_structure_version_id_tbl(i);
21793: l_task_id_tbl(i) := p_object_id_tbl(i);
21794: END IF;
21795:

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

22195: END;
22196:
22197: IF ((PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_structure_id) = 'Y')
22198: AND
22199: (PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_task_id_tbl(i)) = 'Y') --Bug 3784405 Satish
22200: AND
22201: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id_tbl(i)) = 'Y'))
22202: THEN
22203: --copy to transaction dates