DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_FP_WP_GEN_AMT_UTILS

Line 787: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

783: --end add by rtarway for BUG 4085882
784:
785: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);
786: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id,p_object_version_id,p_object_type); -- Bug 3784904
787: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
788:
789: --bug 3824042
790: SELECT project_currency_code, projfunc_currency_code
791: INTO l_prj_currency_code, l_prjfunc_currency_code

Line 7212: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

7208: END IF;
7209:
7210: -- Set B and F package variable.
7211: PA_FP_CALC_PLAN_PKG.G_SPREAD_FROM_DATE := l_max_as_of_date;
7212: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
7213:
7214: --moved from below to use it in % complete recalculation.
7215: OPEN cur_proj_prog_attr;
7216: FETCH cur_proj_prog_attr INTO l_task_weight_basis_code;

Line 9515: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

9511:
9512: IF p_structure_type = 'WORKPLAN' THEN
9513: BEGIN
9514: --- getting plan id
9515: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
9516: p_project_id => p_project_id,
9517: p_plan_type_id => -1,
9518: p_proj_str_ver_id => l_structure_version_id) ;
9519: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE(

Line 10132: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

10128: FND_MSG_PUB.initialize;
10129: END IF;
10130:
10131: x_return_status := FND_API.G_RET_STS_SUCCESS;
10132: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
10133:
10134: IF NVL(p_structure_version_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3625085
10135: THEN
10136: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

Line 10252: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);

10248:
10249: --bug 3675107
10250:
10251: BEGIN
10252: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
10253: EXCEPTION
10254: WHEN OTHERS THEN
10255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10256: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',

Line 10257: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id:'||SQLERRM,1,120));

10253: EXCEPTION
10254: WHEN OTHERS THEN
10255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10256: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10257: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id:'||SQLERRM,1,120));
10258: RAISE FND_API.G_EXC_ERROR;
10259: END;
10260:
10261: BEGIN

Line 10262: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

10258: RAISE FND_API.G_EXC_ERROR;
10259: END;
10260:
10261: BEGIN
10262: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
10263: p_project_id => p_project_id,
10264: p_plan_type_id => -1,
10265: p_proj_str_ver_id => l_structure_version_id) ;
10266: EXCEPTION

Line 10270: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_version_id:'||SQLERRM,1,120));

10266: EXCEPTION
10267: WHEN OTHERS THEN
10268: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10269: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10270: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_version_id:'||SQLERRM,1,120));
10271: RAISE FND_API.G_EXC_ERROR;
10272: END;
10273:
10274: BEGIN

Line 11690: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

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);
11694: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'l_latest_pub_wp_version_id='||l_latest_pub_wp_version_id, x_Log_Level=> 3);

Line 14173: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745

14169: end if;
14170: end if;
14171: /* End for Bug 6414995 */
14172:
14173: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14174: l_plan_type := calendar_type_tbl(l_index);
14175: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14176: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14177: p_project_id => l_project_id,

Line 14175: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);

14171: /* End for Bug 6414995 */
14172:
14173: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14174: l_plan_type := calendar_type_tbl(l_index);
14175: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14176: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14177: p_project_id => l_project_id,
14178: p_plan_type_id => -1,
14179: p_proj_str_ver_id => l_latest_wp_struct_ver_id) ;

Line 14176: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

14172:
14173: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14174: l_plan_type := calendar_type_tbl(l_index);
14175: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14176: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14177: p_project_id => l_project_id,
14178: p_plan_type_id => -1,
14179: p_proj_str_ver_id => l_latest_wp_struct_ver_id) ;
14180: l_proj_curr_code := proj_curr_code_tbl(l_index);

Line 20194: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);

20190: open proj_info;
20191: fetch proj_info into l_org_id,l_proj_curr_code,l_proj_func_curr_code;
20192: close proj_info;
20193: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(p_dst_str_ver_id);
20194: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
20195: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
20196: p_project_id => p_project_id,
20197: p_plan_type_id => -1,
20198: p_proj_str_ver_id => p_dst_str_ver_id) ;

Line 20195: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

20191: fetch proj_info into l_org_id,l_proj_curr_code,l_proj_func_curr_code;
20192: close proj_info;
20193: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(p_dst_str_ver_id);
20194: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
20195: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
20196: p_project_id => p_project_id,
20197: p_plan_type_id => -1,
20198: p_proj_str_ver_id => p_dst_str_ver_id) ;
20199: IF ( l_calling_context = 'PUBLISH')

Line 21978: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

21974: IF g1_debug_mode = 'Y' THEN
21975: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK', x_Msg => 'Calling PLAN_UPDATE', x_Log_Level=> 3);
21976: END IF;
21977:
21978: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
21979: p_project_id => p_project_id_tbl(i),
21980: p_plan_type_id => -1,
21981: p_proj_str_ver_id => l_structure_version_id_tbl(i)) ;
21982: