APPS.PA_FP_GEN_AMT_WRP_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 119: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||

115:
116: -- bug 5657334: Changed pa_projects_all to refer pa_projects as the concurrent
117: -- program has been modified to make it single org compliant.
118:
119: l_from_clause := ' FROM pa_projects pj, pa_proj_fp_options opt,' ||
120: ' pa_fin_plan_types_b pt, pa_project_types_all pta';
121: l_where_clause := ' WHERE 1 = 1 AND pj.project_id = opt.project_id' ||
122: ' AND nvl(pj.template_flag,''N'') <> ''Y''' ||
123: ' AND NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed' ||

Line 670: wp_fin_plan_ver_id to update back to pa_proj_fp_options*/

666: --hr_utility.trace('after calling fn etc wp fin ver id : '||
667: --l_etc_wp_fin_ver_id );
668: END IF; -- fp cols rec check
669: /*We need the strcut_ver_id for fcst_amt_gen,
670: wp_fin_plan_ver_id to update back to pa_proj_fp_options*/
671:
672: END IF; -- l_workplan_src_dtls_flag
673:
674: IF l_fin_plan_src_dtls_flag = 'Y' THEN

Line 784: /*update the etc source version id back to pa_proj_fp_options*/

780:
781: END IF; -- l_fin_plan_src_dtls_flag
782:
783: /*As of now, we have the l_etc_wp_struct_ver_id and l_etc_fp_ver_id*/
784: /*update the etc source version id back to pa_proj_fp_options*/
785: IF l_element_type_tab(i) = 'COST' THEN
786: UPDATE PA_PROJ_FP_OPTIONS
787: SET GEN_SRC_COST_PLAN_TYPE_ID = l_etc_fp_type_id,
788: GEN_SRC_COST_PLAN_VERSION_ID = l_etc_fp_ver_id,

Line 786: UPDATE PA_PROJ_FP_OPTIONS

782:
783: /*As of now, we have the l_etc_wp_struct_ver_id and l_etc_fp_ver_id*/
784: /*update the etc source version id back to pa_proj_fp_options*/
785: IF l_element_type_tab(i) = 'COST' THEN
786: UPDATE PA_PROJ_FP_OPTIONS
787: SET GEN_SRC_COST_PLAN_TYPE_ID = l_etc_fp_type_id,
788: GEN_SRC_COST_PLAN_VERSION_ID = l_etc_fp_ver_id,
789: GEN_SRC_COST_WP_VERSION_ID = l_etc_wp_fin_ver_id
790: WHERE fin_plan_version_id = lx_budget_version_id;

Line 792: UPDATE PA_PROJ_FP_OPTIONS

788: GEN_SRC_COST_PLAN_VERSION_ID = l_etc_fp_ver_id,
789: GEN_SRC_COST_WP_VERSION_ID = l_etc_wp_fin_ver_id
790: WHERE fin_plan_version_id = lx_budget_version_id;
791: ELSIF l_element_type_tab(i) = 'REVENUE' THEN
792: UPDATE PA_PROJ_FP_OPTIONS
793: SET GEN_SRC_REV_PLAN_TYPE_ID = l_etc_fp_type_id,
794: GEN_SRC_REV_PLAN_VERSION_ID = l_etc_fp_ver_id,
795: GEN_SRC_REV_WP_VERSION_ID = l_etc_wp_fin_ver_id
796: WHERE fin_plan_version_id = lx_budget_version_id;

Line 798: UPDATE PA_PROJ_FP_OPTIONS

794: GEN_SRC_REV_PLAN_VERSION_ID = l_etc_fp_ver_id,
795: GEN_SRC_REV_WP_VERSION_ID = l_etc_wp_fin_ver_id
796: WHERE fin_plan_version_id = lx_budget_version_id;
797: ELSIF l_element_type_tab(i) = 'ALL' THEN
798: UPDATE PA_PROJ_FP_OPTIONS
799: SET GEN_SRC_ALL_PLAN_TYPE_ID = l_etc_fp_type_id,
800: GEN_SRC_ALL_PLAN_VERSION_ID = l_etc_fp_ver_id,
801: GEN_SRC_ALL_WP_VERSION_ID = l_etc_wp_fin_ver_id
802: WHERE fin_plan_version_id = lx_budget_version_id;