DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PA_FP_WP_GEN_AMT_UTILS

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

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

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

7621: END IF;
7622:
7623: -- Set B and F package variable.
7624: PA_FP_CALC_PLAN_PKG.G_SPREAD_FROM_DATE := l_max_as_of_date;
7625: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
7626:
7627: --moved from below to use it in % complete recalculation.
7628: OPEN cur_proj_prog_attr;
7629: FETCH cur_proj_prog_attr INTO l_task_weight_basis_code;

Line 9948: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

9944:
9945: IF p_structure_type = 'WORKPLAN' THEN
9946: BEGIN
9947: --- getting plan id
9948: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
9949: p_project_id => p_project_id,
9950: p_plan_type_id => -1,
9951: p_proj_str_ver_id => l_structure_version_id) ;
9952: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE(

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

10563: FND_MSG_PUB.initialize;
10564: END IF;
10565:
10566: x_return_status := FND_API.G_RET_STS_SUCCESS;
10567: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
10568:
10569: IF NVL(p_structure_version_id,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3625085
10570: THEN
10571: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id);

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

10683:
10684: --bug 3675107
10685:
10686: BEGIN
10687: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
10688: EXCEPTION
10689: WHEN OTHERS THEN
10690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10691: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',

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

10688: EXCEPTION
10689: WHEN OTHERS THEN
10690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10691: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10692: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id:'||SQLERRM,1,120));
10693: RAISE FND_API.G_EXC_ERROR;
10694: END;
10695:
10696: BEGIN

Line 10697: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

10693: RAISE FND_API.G_EXC_ERROR;
10694: END;
10695:
10696: BEGIN
10697: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
10698: p_project_id => p_project_id,
10699: p_plan_type_id => -1,
10700: p_proj_str_ver_id => l_structure_version_id) ;
10701: EXCEPTION

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

10701: EXCEPTION
10702: WHEN OTHERS THEN
10703: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10704: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10705: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_version_id:'||SQLERRM,1,120));
10706: RAISE FND_API.G_EXC_ERROR;
10707: END;
10708:
10709: BEGIN

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

12139: -- On this l_as_of_date, there can be working progress record which we will update
12140: -- with working wp version progress
12141:
12142: l_latest_pub_wp_version_id := p_pub_structure_version_id;--PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
12143: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745
12144:
12145: IF g1_debug_mode = 'Y' THEN
12146: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUBLISH_PROGRESS', x_Msg => 'l_as_of_date='||l_as_of_date, x_Log_Level=> 3);
12147: 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 14695: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745

14691: end if;
14692: end if;
14693: /* End for Bug 6414995 */
14694:
14695: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14696: l_plan_type := calendar_type_tbl(l_index);
14697: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14698: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14699: p_project_id => l_project_id,

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

14693: /* End for Bug 6414995 */
14694:
14695: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14696: l_plan_type := calendar_type_tbl(l_index);
14697: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14698: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14699: p_project_id => l_project_id,
14700: p_plan_type_id => -1,
14701: p_proj_str_ver_id => l_latest_wp_struct_ver_id) ;

Line 14698: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

14694:
14695: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(l_project_id); --Bug 3801745
14696: l_plan_type := calendar_type_tbl(l_index);
14697: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => l_project_id);
14698: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
14699: p_project_id => l_project_id,
14700: p_plan_type_id => -1,
14701: p_proj_str_ver_id => l_latest_wp_struct_ver_id) ;
14702: --added for the Bug 13640836

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

21653: open proj_info;
21654: fetch proj_info into l_org_id,l_proj_curr_code,l_proj_func_curr_code;
21655: close proj_info;
21656: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(p_dst_str_ver_id);
21657: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
21658: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
21659: p_project_id => p_project_id,
21660: p_plan_type_id => -1,
21661: p_proj_str_ver_id => p_dst_str_ver_id) ;

Line 21658: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

21654: fetch proj_info into l_org_id,l_proj_curr_code,l_proj_func_curr_code;
21655: close proj_info;
21656: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(p_dst_str_ver_id);
21657: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
21658: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
21659: p_project_id => p_project_id,
21660: p_plan_type_id => -1,
21661: p_proj_str_ver_id => p_dst_str_ver_id) ;
21662: IF ( l_calling_context = 'PUBLISH')

Line 23470: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(

23466: IF g1_debug_mode = 'Y' THEN
23467: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK', x_Msg => 'Calling PLAN_UPDATE', x_Log_Level=> 3);
23468: END IF;
23469:
23470: l_plan_version_id := Pa_Fp_wp_gen_amt_utils.get_wp_version_id(
23471: p_project_id => p_project_id_tbl(i),
23472: p_plan_type_id => -1,
23473: p_proj_str_ver_id => l_structure_version_id_tbl(i)) ;
23474: