DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_PROJ_TASK_STRUC_PUB

Line 5075: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

5071: fetch cur_tasks_exist into l_tasks_exist;
5072: close cur_tasks_exist;
5073: if (nvl(l_tasks_exist, 'N') = 'Y') then
5074: --------------dbms_output.put_line('update '||l_updt_struc_ver_id);
5075: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(
5076: p_project_id => p_project_id,
5077: p_structure_version_id => l_updt_struc_ver_id,
5078: p_update_wbs_flag => 'Y',
5079: x_return_status => l_return_status,

Line 5110: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

5106: fetch cur_tasks_exist into l_tasks_exist;
5107: close cur_tasks_exist;
5108: if (nvl(l_tasks_exist, 'N') = 'Y') then
5109: --call API to update flag
5110: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(
5111: p_project_id => p_project_id,
5112: p_structure_version_id => l_updt_struc_ver_id,
5113: p_update_wbs_flag => 'Y',
5114: x_return_status => l_return_status,

Line 5144: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

5140: FETCH cur_get_wk_ver_struct_id Into l_updt_struc_ver_id;
5141: EXIT when cur_get_wk_ver_struct_id%NOTFOUND;
5142: --call API to update flag
5143: --------------dbms_output.put_line('update '||l_updt_struc_ver_id);
5144: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(
5145: p_project_id => p_project_id,
5146: p_structure_version_id => l_updt_struc_ver_id,
5147: p_update_wbs_flag => 'N',
5148: x_return_status => l_return_status,

Line 5173: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(

5169: FETCH cur_get_only_ver_struct_id Into l_updt_struc_ver_id;
5170: --------------dbms_output.put_line('update '||l_updt_struc_ver_id);
5171: CLOSE cur_get_only_ver_struct_id;
5172: --call API to update flag
5173: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG(
5174: p_project_id => p_project_id,
5175: p_structure_version_id => l_updt_struc_ver_id,
5176: p_update_wbs_flag => 'N',
5177: x_return_status => l_return_status,

Line 9473: l_wp_ver_enabled_flag := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id);

9469: open l_cur_publish(l_request_id);
9470: fetch l_cur_publish into l_rec_publish;
9471: close l_cur_publish;
9472:
9473: l_wp_ver_enabled_flag := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id);
9474:
9475: if ((l_rec_publish.process = 'CONC_PUBLISH')
9476: and (l_process_code in ('WUP', 'WUE'))
9477: and (l_wp_ver_enabled_flag = 'Y')) then

Line 18052: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP

18048: pa_debug.log_message('GET_SUMM_ACT: Done looping thru all the records. Inserts = '||l_index2||' Updates = '||l_index3, 1);
18049: /* Bug 13419867 starts */
18050: select count(*) into l_asgmt_count from pa_asgmt_plan_change_t where project_id = l_project_id;
18051: IF l_asgmt_count > 0 then
18052: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
18053: ( p_calling_context => 'ASGMT_PLAN_CHANGE'
18054: ,p_project_id => l_project_id
18055: ,p_structure_version_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)
18056: ,p_pub_struc_ver_id => pa_project_structure_utils.get_latest_wp_version(l_project_id)

Line 18065: pa_debug.log_message('PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: Error in PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', 1);

18061: pa_task_assignment_utils.g_require_progress_rollup := 'N';
18062: END IF;
18063:
18064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
18065: pa_debug.log_message('PA_PROGRESS_PUB.GET_SUMMARIZED_ACTUALS: Error in PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', 1);
18066: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
18067: p_msg_name => x_msg_data);
18068: x_msg_data := x_msg_data;
18069: x_return_status := 'E';

Line 22914: l_wp_ver_enabled_flag := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id_tbl(i));

22910: fetch l_cur_publish into l_rec_publish;
22911: close l_cur_publish;
22912:
22913:
22914: l_wp_ver_enabled_flag := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id_tbl(i));
22915:
22916: if ((l_rec_publish.process = 'CONC_PUBLISH')
22917: and (l_process_code in ('WUP', 'WUE'))
22918: and (l_wp_ver_enabled_flag = 'Y')) then

Line 23338: PA_PROGRESS_PUB.G_IS_WP_VERSION_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( p_project_id_tbl(i) );

23334: IF NVL(l_last_project_id,-1234) <> p_project_id_tbl(i) THEN
23335: l_last_project_id := p_project_id_tbl(i);
23336:
23337: -- added below 2 lines of code for Huawei bug 13923366 skkoppul
23338: PA_PROGRESS_PUB.G_IS_WP_VERSION_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( p_project_id_tbl(i) );
23339: PA_PROGRESS_PUB.G_STRUCTURE_SHARING_CODE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_project_id_tbl(i));
23340:
23341: OPEN c_get_org_id(p_project_id_tbl(i));
23342: FETCH c_get_org_id INTO l_org_id;

Line 23339: PA_PROGRESS_PUB.G_STRUCTURE_SHARING_CODE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_project_id_tbl(i));

23335: l_last_project_id := p_project_id_tbl(i);
23336:
23337: -- added below 2 lines of code for Huawei bug 13923366 skkoppul
23338: PA_PROGRESS_PUB.G_IS_WP_VERSION_ENABLED := PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED( p_project_id_tbl(i) );
23339: PA_PROGRESS_PUB.G_STRUCTURE_SHARING_CODE := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_project_id_tbl(i));
23340:
23341: OPEN c_get_org_id(p_project_id_tbl(i));
23342: FETCH c_get_org_id INTO l_org_id;
23343: CLOSE c_get_org_id;

Line 23895: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Before calling PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG', x_Log_Level=> 3);

23891: IF g1_debug_mode = 'Y' THEN
23892: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP Start : Passed Parameters :', x_Log_Level=> 3);
23893: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
23894: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'p_working_str_version_id='||p_working_str_version_id, x_Log_Level=> 3);
23895: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Before calling PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG', x_Log_Level=> 3);
23896: END IF;
23897: -- 4392189 : Program Reporting Changes - Phase 2
23898: -- We do not have to set wbs_flag here. Bcoz depending on this flag, process_wbs_updates call wbs_maint API.
23899: /*

Line 23900: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG

23896: END IF;
23897: -- 4392189 : Program Reporting Changes - Phase 2
23898: -- We do not have to set wbs_flag here. Bcoz depending on this flag, process_wbs_updates call wbs_maint API.
23899: /*
23900: PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG
23901: (
23902: p_calling_context => p_calling_module
23903: ,p_project_id => p_project_id
23904: ,p_structure_version_id => p_working_str_version_id

Line 23912: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Done with PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG l_return_status='||l_return_status, x_Log_Level=> 3);

23908: ,x_msg_data => l_msg_data);
23909: */
23910:
23911: IF g1_debug_mode = 'Y' THEN
23912: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Done with PA_PROJ_TASK_STRUC_PUB.SET_UPDATE_WBS_FLAG l_return_status='||l_return_status, x_Log_Level=> 3);
23913: END IF;
23914:
23915:
23916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 23926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Before calling PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', x_Log_Level=> 3);

23922: RAISE FND_API.G_EXC_ERROR;
23923: END IF;
23924:
23925: IF g1_debug_mode = 'Y' THEN
23926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Before calling PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', x_Log_Level=> 3);
23927: END IF;
23928: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP(
23929: p_calling_context => 'APPLY_PROGRESS',
23930: p_project_id => p_project_id,

Line 23928: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP(

23924:
23925: IF g1_debug_mode = 'Y' THEN
23926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Before calling PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP', x_Log_Level=> 3);
23927: END IF;
23928: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP(
23929: p_calling_context => 'APPLY_PROGRESS',
23930: p_project_id => p_project_id,
23931: p_structure_version_id => p_working_str_version_id,
23932: x_return_status => l_return_status,

Line 23938: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Done with PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP l_return_status='||l_return_status, x_Log_Level=> 3);

23934: x_msg_data => l_msg_data
23935: );
23936:
23937: IF g1_debug_mode = 'Y' THEN
23938: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'Done with PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP l_return_status='||l_return_status, x_Log_Level=> 3);
23939: END IF;
23940:
23941: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
23942: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',