DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_PROGRESS_UTILS

Line 3823: l_weighting_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_dest_project_id);

3819: -- hyau Bug 2852753
3820: IF p_calling_module = 'SELF_SERVICE' THEN
3821:
3822: --3035902: process update flag changes
3823: l_weighting_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_dest_project_id);
3824: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');
3825: --3035902: end process update flag changes
3826:
3827:

Line 5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);

5638: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5639: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5640: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5641: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5642: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5643: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5644: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);
5645:
5646: END IF; /*4269830*/

Line 6185: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_project_id);

6181:
6182: /* 4269830 :
6183: This code has been moved to block tagged by <<--A-->>
6184: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struct_ver_id, 'WORKPLAN');
6185: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_project_id);
6186: */
6187: --3035902: process update flag changes
6188: OPEN get_task_type_id(l_proj_element_id);
6189: FETCH get_task_type_id INTO l_task_type_id;

Line 7750: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);

7746: end if;
7747:
7748: --bug 3053281 --set flag if not (manual and workplan only)
7749: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
7750: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
7751:
7752: --bug 3010538
7753: --Added the following lines to cache versioning and sharing information
7754: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

Line 10339: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);

10335: --bug 3010538 (Indent)
10336:
10337: --bug 3053281 --set flag if not (manual and workplan only)
10338: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
10339: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
10340:
10341: /*
10342: IF (l_shared = 'N') AND
10343: (l_wp_type = 'Y') AND

Line 11975: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);

11971:
11972: --bug 3010538 ( outdent )
11973: --bug 3053281 --set flag if not (manual and workplan only)
11974: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
11975: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
11976: /*
11977: IF (l_shared = 'N') AND
11978: (l_wp_type = 'Y') AND
11979: (l_weighting_basis_Code = 'MANUAL') THEN

Line 13659: l_weighting_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);

13655: END IF; -- IF ((nvl(p_planned_effort,0) > 0 and NVL( p_planned_effort,0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
13656:
13657: --Bug#6144931 START
13658:
13659: l_weighting_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
13660:
13661: IF l_weighting_basis = 'EFFORT' AND NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
13662: THEN
13663: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

Line 13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');

13689: END IF;
13690:
13691: --bug 3959087, start
13692: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
13694:
13695: IF l_debug_mode = 'Y' THEN
13696: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_lowest_level_task='||l_lowest_level_task, x_Log_Level=> 3);
13697: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);

Line 13707: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543

13703: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
13704: IF (l_lowest_level_task = 'Y' AND --bug 3959087
13705: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'
13706: -- Progress Management Changes, Bug # 3420093.
13707: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543
13708: AND l_assignment_exists = 'N' --bug 3959087
13709: AND p_object_type = 'PA_TASKS'
13710: AND p_calling_module <> 'AMG')
13711: THEN

Line 13787: l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id , p_task_id => l_task_id);

13783: --if ((nvl(p_etc_effort,0) > 0 and p_etc_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
13784: -- or (nvl(p_etc_cost,0) > 0 and p_etc_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) --maansari5/9
13785:
13786:
13787: l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id , p_task_id => l_task_id);
13788: IF l_debug_mode = 'Y' THEN
13789: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_next_prog_cycle_date='||l_next_prog_cycle_date, x_Log_Level=> 3);
13790: END IF;
13791:

Line 13799: --l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id

13795: -- Progress Management Changes, Bug # 3420093.
13796: -- Begin logic to create pa_progress_rollup record for the Task / Assignment:
13797: -- Get the next progress cycle id.
13798: -- Bug 3856161 : Moving this code outside
13799: --l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id
13800: -- , p_task_id => l_task_id);
13801: -- Progress Management Changes, Bug # 3420093.
13802: IF (p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
13803: l_percent_complete := null;

Line 13915: PA_PROGRESS_UTILS.Get_BAC_Value(p_project_id,l_rollup_method

13911: FETCH c_proj_element_id INTO l_proj_element_id;
13912: CLOSE c_proj_element_id;
13913:
13914: l_earned_value := nvl(l_override_pc,l_eff_rollup_pc) *
13915: PA_PROGRESS_UTILS.Get_BAC_Value(p_project_id,l_rollup_method
13916: ,l_proj_element_id,p_structure_version_id
13917: ,'WORKPLAN');
13918:
13919: --bug 3959087, start

Line 14103: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_next_prog_cycle_date) --maansari5/11

14099: ,X_PROJ_COST_EXCHANGE_RATE => null
14100: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14101: ,X_PROJ_COST_RATE_DATE => null
14102: ,X_TXN_CURRENCY_CODE => null
14103: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_next_prog_cycle_date) --maansari5/11
14104: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_next_prog_cycle_date) --maansari5/11
14105: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14106: ,X_OTH_ETC_QUANTITY => null
14107: --bug 3621404

Line 14104: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_next_prog_cycle_date) --maansari5/11

14100: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14101: ,X_PROJ_COST_RATE_DATE => null
14102: ,X_TXN_CURRENCY_CODE => null
14103: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_next_prog_cycle_date) --maansari5/11
14104: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_next_prog_cycle_date) --maansari5/11
14105: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14106: ,X_OTH_ETC_QUANTITY => null
14107: --bug 3621404
14108: ,X_OTH_ACT_RAWCOST_TO_DATE_TC => null

Line 14313: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_as_of_date) --maansari5/11

14309: ,X_PROJ_COST_EXCHANGE_RATE => null
14310: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14311: ,X_PROJ_COST_RATE_DATE => null
14312: ,X_TXN_CURRENCY_CODE => null
14313: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_as_of_date) --maansari5/11
14314: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_as_of_date) --maansari5/11
14315: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14316: ,X_OTH_ETC_QUANTITY => null
14317: --bug 3621404

Line 14314: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_as_of_date) --maansari5/11

14310: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14311: ,X_PROJ_COST_RATE_DATE => null
14312: ,X_TXN_CURRENCY_CODE => null
14313: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_as_of_date) --maansari5/11
14314: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_as_of_date) --maansari5/11
14315: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14316: ,X_OTH_ETC_QUANTITY => null
14317: --bug 3621404
14318: ,X_OTH_ACT_RAWCOST_TO_DATE_TC => null

Line 15303: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);

15299:
15300: -- End of Bug Fix 4764891.
15301:
15302: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
15303: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
15304: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);
15305:
15306: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
15307: l_task_version_id := p_task_version_id_tbl(1);