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_PROJ_TASK_STRUC_PUB dependencies on PA_PROGRESS_UTILS

Line 1832: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR

1828: CLOSE get_task_type_id;
1829: --Bug No 3450684 SMukka Commented if condition
1830: --IF NOT ( p_structure_type = 'WORKPLAN' AND
1831: -- l_shared = 'N' AND
1832: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR
1833: -- pa_task_type_utils.check_tk_type_progressable(l_task_type_id)='N') )
1834: --THEN
1835:
1836: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

Line 1959: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN

1955: AND project_id = p_project_id;
1956: */
1957:
1958: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
1959: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
1960: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
1961: l_wq_planned_quantity := NULL;
1962: END IF;
1963: ELSE

Line 3224: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN

3220: WHERE proj_element_id = l_task_id
3221: AND project_id = p_project_id;
3222:
3223: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
3224: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
3225: IF (P_PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND P_PLANNED_WORK_QUANTITY IS NOT NULL) THEN
3226: l_wq_planned_quantity := NULL;
3227: END IF;
3228: ELSE

Line 13280: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );

13276: l_fn_str_ver_id NUMBER;
13277: l_wp_str_ver_id NUMBER;
13278: l_task_weight_basis PA_PROJ_PROGRESS_ATTR.task_weight_basis_code%TYPE;
13279: BEGIN
13280: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );
13281: IF NVL( l_task_weight_basis, 'X' ) = 'DURATION'
13282: THEN
13283: FOR cur_strs_n_types_rec in cur_strs_n_types LOOP
13284: IF cur_strs_n_types_rec.structure_type_id = 1 --'WORKPLAN' structure

Line 14001: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,

13997: */
13998: CURSOR cur_prev_prog (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER)
13999: IS
14000: SELECT
14001: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,
14002: pa_progress_utils.Sum_etc_values(
14003: ( Nvl(pxpv.labor_effort, 0) + Nvl(pxpv.equipment_effort, 0) ),
14004: ppr.estimated_remaining_effort,
14005: ppr.eqpmt_etc_effort,

Line 14002: pa_progress_utils.Sum_etc_values(

13998: CURSOR cur_prev_prog (p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER)
13999: IS
14000: SELECT
14001: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,
14002: pa_progress_utils.Sum_etc_values(
14003: ( Nvl(pxpv.labor_effort, 0) + Nvl(pxpv.equipment_effort, 0) ),
14004: ppr.estimated_remaining_effort,
14005: ppr.eqpmt_etc_effort,
14006: NULL,

Line 14072: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,

14068: AND ppv.proj_element_id = p_object_id
14069: AND ppv.element_version_id = p_object_version_id
14070: UNION ALL
14071: SELECT
14072: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,
14073: pa_progress_utils.Sum_etc_values(
14074: ( Nvl(pxpv.labor_effort, 0) + Nvl(pxpv.equipment_effort, 0) ),
14075: ppr.estimated_remaining_effort,
14076: ppr.eqpmt_etc_effort,

Line 14073: pa_progress_utils.Sum_etc_values(

14069: AND ppv.element_version_id = p_object_version_id
14070: UNION ALL
14071: SELECT
14072: pa_progress_utils.Calc_plan(pxpv.labor_effort, pxpv.equipment_effort) planned_effort,
14073: pa_progress_utils.Sum_etc_values(
14074: ( Nvl(pxpv.labor_effort, 0) + Nvl(pxpv.equipment_effort, 0) ),
14075: ppr.estimated_remaining_effort,
14076: ppr.eqpmt_etc_effort,
14077: NULL,

Line 14634: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_project_id) ;

14630: END IF; -- End for if p_structure_version_id is null
14631:
14632: -- Bug 3075609. Determine if we want to maintain the task weightages during the program
14633: -- flow or they will be recalculated at the end of the flow.
14634: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_project_id) ;
14635:
14636: -- In the following conditions we will be recalculating the weightages completely. So we need to
14637: -- take care of the rest of the scenarios. Where we need not take care we will just set the task
14638: -- weightage to 0.

Line 16659: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))

16655:
16656: -- Need to check if the project and the task type allows for planned work quantity. If not allowed then
16657: -- set the value to null so that it can be passed on to create_schedule_version api.
16658: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16659: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id))
16660: THEN
16661: IF (l_task_in_rec.PLANNED_WORK_QUANTITY <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
16662: l_task_in_rec.PLANNED_WORK_QUANTITY IS NOT NULL)
16663: THEN

Line 16703: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN

16699: FETCH cur_task_type_id INTO l_task_type_id;
16700: CLOSE cur_task_type_id;
16701:
16702: IF ('N' = PA_TASK_TYPE_UTILS.check_tk_type_wq_enabled(l_task_type_id) OR
16703: 'N' = PA_PROGRESS_UTILS.get_project_wq_flag(p_project_id)) THEN
16704: l_wq_planned_quantity := null;
16705: ELSE
16706: IF (l_task_in_rec.PLANNED_WORK_QUANTITY = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16707: --Added by rtarway, for 4029755

Line 17255: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR

17251: --3035902: process update flag changes
17252: --Bug No 3450684 SMukka Commented if condition
17253: --IF NOT ( p_structure_type = 'WORKPLAN' AND
17254: -- p_is_wp_separate_from_fn = 'Y' AND
17255: -- ( PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id) = 'MANUAL' OR
17256: -- NVL( l_progressable_task, 'N' ) = 'N' ))
17257: --THEN
17258: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
17259: (

Line 17364: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_project_id) ;

17360: END IF;
17361: END IF;
17362: --Bug3802469, rtarway
17363:
17364: l_task_weight_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id => p_project_id) ;
17365:
17366: -- Recalculate the task weightings.
17367: IF nvl(l_task_weight_basis_code,'-1') = 'MANUAL' AND
17368: (l_new_structure_version = 'Y' OR -- Bug 3075609. Recalculate the task weightings only if it is a

Line 18626: l_task_weighting_basis := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);

18622: -- basis code is MANUAL or flag is N.
18623:
18624: l_update_wbs_flag := pa_project_structure_utils.GET_UPDATE_WBS_FLAG(p_project_id => p_project_id,
18625: p_structure_version_id => p_structure_version_id);
18626: l_task_weighting_basis := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);
18627:
18628:
18629: -- See if the structure version being processed is WORKPLAN.
18630: open cur_structure_type(p_project_id,p_structure_version_id,'WORKPLAN');

Line 19423: l_task_weight_basis_code := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);

19419:
19420: IF (p_calling_context = 'ASGMT_PLAN_CHANGE') THEN ---bug 4492493
19421: --- find the as_of_date for which to rollup and
19422: --- rollup method
19423: l_task_weight_basis_code := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);
19424: begin
19425: select max(as_of_date)
19426: into l_as_of_date
19427: from pa_progress_rollup ppr

Line 20384: l_pub_wp_ok := pa_progress_utils.check_wwp_prog_publishing_ok(l_project_id,p_structure_version_id);

20380: END IF;
20381: END IF; -- ((l_workplan_type = 'Y') AND (l_financial_type = 'Y')) THEN
20382:
20383: -- 5029112 (4925192)
20384: l_pub_wp_ok := pa_progress_utils.check_wwp_prog_publishing_ok(l_project_id,p_structure_version_id);
20385: --bug 4232150
20386:
20387: IF p_pub_prog_flag = 'Y' THEN
20388:

Line 20622: PA_PROGRESS_UTILS.clear_prog_outdated_flag(

20618: IF l_debug_mode = 'Y' THEN
20619: pa_debug.write(G_PKG_NAME, 'Calling clear_prog_outdated_flag', 3);
20620: END IF;
20621:
20622: PA_PROGRESS_UTILS.clear_prog_outdated_flag(
20623: p_project_id => l_Project_ID
20624: ,p_structure_version_id => l_pub_ver_id
20625: ,p_object_id => null
20626: ,p_object_type => null

Line 21338: l_task_weighting_basis := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);

21334:
21335: -- Obtain the task weighting basis and do nothing if the basis is MANUAL and throw error if it is NULL.
21336: -- This is a redundant check incorporated just to ensure no processing is done in case the api
21337: -- is wrongly called.
21338: l_task_weighting_basis := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);
21339:
21340: IF l_task_weighting_basis is NULL THEN
21341: IF l_debug_mode = 'Y' THEN
21342: pa_debug.g_err_stage:= 'PROCESS_TASK_WEIGHTAGE API has been called when task weighting basis is NULL';

Line 21956: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );

21952: /* The following is the simple solution for this.
21953: Update the Process_WBS_flag only for WORKPLAN enabled structures
21954: if task weighting basis is DURATION.
21955: Call the concurrent wrapper for all structure versions */
21956: l_task_weight_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( p_dest_project_id );
21957: -- IF NVL( l_task_weight_basis, 'X' ) in( 'DURATION', 'EFFORT') --3127640
21958: -- THEN
21959: FOR cur_strs_n_types_rec in cur_strs_n_types LOOP
21960: IF cur_strs_n_types_rec.structure_type_id = 1 --'WORKPLAN' structure