[Home] [Help]
245: X_FP_COLS_REC.X_GEN_SRC_WP_VER_CODE
246: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
247: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,
248: PA_FIN_PLAN_AMOUNT_SETS FP,
249: PA_FIN_PLAN_TYPES_B FB
250: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
251: AND OPT.PROJECT_ID = BV.PROJECT_ID
252: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID
253: AND OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
1476: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_AMOUNT_UTILS.VALIDATE_SUPPORT_CASES';
1477:
1478: l_wp_track_cost_flag VARCHAR2(1);
1479: l_rev_gen_method VARCHAR2(1);
1480: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1481:
1482: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1483: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1484: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2347: X_MSG_DATA OUT NOCOPY VARCHAR2)
2348: IS
2349: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_AMOUNT_UTILS.DEFAULT_BDGT_SRC_VER';
2350:
2351: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2352: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
2353:
2354: -- Variables for Budget Generation source version defaulting logic
2355: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;