DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_PROGRESS_UTILS

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

3987: -- hyau Bug 2852753
3988: IF p_calling_module = 'SELF_SERVICE' THEN
3989:
3990: --3035902: process update flag changes
3991: l_weighting_basis_code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_dest_project_id);
3992: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_dest_structure_version_id, 'WORKPLAN');
3993: --3035902: end process update flag changes
3994:
3995:

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

5913: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_cur_project_id);
5914: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
5915: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id,'WORKPLAN');
5916: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(l_cur_project_id);
5917: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_cur_project_id);
5918: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_cur_project_id);
5919: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_cur_project_id);
5920:
5921: END IF; /*4269830*/

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

6463:
6464: /* 4269830 :
6465: This code has been moved to block tagged by <<--A-->>
6466: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_parent_struct_ver_id, 'WORKPLAN');
6467: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(l_project_id);
6468: */
6469: --3035902: process update flag changes
6470: OPEN get_task_type_id(l_proj_element_id);
6471: FETCH get_task_type_id INTO l_task_type_id;

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

8043: end if;
8044:
8045: --bug 3053281 --set flag if not (manual and workplan only)
8046: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
8047: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
8048:
8049: --bug 3010538
8050: --Added the following lines to cache versioning and sharing information
8051: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(

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

10715: --bug 3010538 (Indent)
10716:
10717: --bug 3053281 --set flag if not (manual and workplan only)
10718: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
10719: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
10720:
10721: /*
10722: IF (l_shared = 'N') AND
10723: (l_wp_type = 'Y') AND

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

12387:
12388: --bug 3010538 ( outdent )
12389: --bug 3053281 --set flag if not (manual and workplan only)
12390: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
12391: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
12392: /*
12393: IF (l_shared = 'N') AND
12394: (l_wp_type = 'Y') AND
12395: (l_weighting_basis_Code = 'MANUAL') THEN

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

14179: END IF; -- IF ((nvl(p_planned_effort,0) > 0 and NVL( p_planned_effort,0) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14180:
14181: --Bug#6144931 START
14182:
14183: l_weighting_basis := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
14184:
14185: IF l_weighting_basis = 'EFFORT' AND NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
14186: THEN
14187: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

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

14213: END IF;
14214:
14215: --bug 3959087, start
14216: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
14217: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
14218:
14219: IF l_debug_mode = 'Y' THEN
14220: 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);
14221: 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 14231: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543

14227: --IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id ) = 'Y' AND
14228: IF (l_lowest_level_task = 'Y' AND --bug 3959087
14229: PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y'
14230: -- Progress Management Changes, Bug # 3420093.
14231: --AND PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_task_ver_id,p_object_type) = 'N' --bug 3864543
14232: AND l_assignment_exists = 'N' --bug 3959087
14233: AND p_object_type = 'PA_TASKS'
14234: AND p_calling_module <> 'AMG')
14235: THEN

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

14307: --if ((nvl(p_etc_effort,0) > 0 and p_etc_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14308: -- or (nvl(p_etc_cost,0) > 0 and p_etc_cost <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) --maansari5/9
14309:
14310:
14311: l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id , p_task_id => l_task_id);
14312: IF l_debug_mode = 'Y' THEN
14313: 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);
14314: END IF;
14315:

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

14319: -- Progress Management Changes, Bug # 3420093.
14320: -- Begin logic to create pa_progress_rollup record for the Task / Assignment:
14321: -- Get the next progress cycle id.
14322: -- Bug 3856161 : Moving this code outside
14323: --l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id
14324: -- , p_task_id => l_task_id);
14325: -- Progress Management Changes, Bug # 3420093.
14326: IF (p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
14327: l_percent_complete := null;

Line 14439: PA_PROGRESS_UTILS.Get_BAC_Value(p_project_id,l_rollup_method

14435: FETCH c_proj_element_id INTO l_proj_element_id;
14436: CLOSE c_proj_element_id;
14437:
14438: l_earned_value := nvl(l_override_pc,l_eff_rollup_pc) *
14439: PA_PROGRESS_UTILS.Get_BAC_Value(p_project_id,l_rollup_method
14440: ,l_proj_element_id,p_structure_version_id
14441: ,'WORKPLAN');
14442:
14443: --bug 3959087, start

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

14623: ,X_PROJ_COST_EXCHANGE_RATE => null
14624: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14625: ,X_PROJ_COST_RATE_DATE => null
14626: ,X_TXN_CURRENCY_CODE => null
14627: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_next_prog_cycle_date) --maansari5/11
14628: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_next_prog_cycle_date) --maansari5/11
14629: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14630: ,X_OTH_ETC_QUANTITY => null
14631: --bug 3621404

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

14624: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14625: ,X_PROJ_COST_RATE_DATE => null
14626: ,X_TXN_CURRENCY_CODE => null
14627: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_next_prog_cycle_date) --maansari5/11
14628: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_next_prog_cycle_date) --maansari5/11
14629: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14630: ,X_OTH_ETC_QUANTITY => null
14631: --bug 3621404
14632: ,X_OTH_ACT_RAWCOST_TO_DATE_TC => null

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

14833: ,X_PROJ_COST_EXCHANGE_RATE => null
14834: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14835: ,X_PROJ_COST_RATE_DATE => null
14836: ,X_TXN_CURRENCY_CODE => null
14837: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_as_of_date) --maansari5/11
14838: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_as_of_date) --maansari5/11
14839: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14840: ,X_OTH_ETC_QUANTITY => null
14841: --bug 3621404

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

14834: -- ,X_PROJ_COST_RATE_DATE_TYPE => null
14835: ,X_PROJ_COST_RATE_DATE => null
14836: ,X_TXN_CURRENCY_CODE => null
14837: ,X_PROG_PA_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(l_as_of_date) --maansari5/11
14838: ,X_PROG_GL_PERIOD_NAME => PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(l_as_of_date) --maansari5/11
14839: ,X_OTH_QUANTITY_to_date => null --maansari5/9
14840: ,X_OTH_ETC_QUANTITY => null
14841: --bug 3621404
14842: ,X_OTH_ACT_RAWCOST_TO_DATE_TC => null

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

15832:
15833: -- End of Bug Fix 4764891.
15834:
15835: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
15836: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
15837: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);
15838:
15839: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
15840: l_task_version_id := p_task_version_id_tbl(1);