eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 10: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

6:
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: PROCEDURE GET_PLAN_VERSION_DTLS
10: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
11: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: X_FP_COLS_REC OUT NOCOPY FP_COLS,
13: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 227: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,

223: X_FP_COLS_REC.X_PROJECT_VALUE,
224: X_FP_COLS_REC.X_TRACK_WORKPLAN_COSTS_FLAG,
225: X_FP_COLS_REC.X_GEN_SRC_WP_VERSION_ID,
226: X_FP_COLS_REC.X_GEN_SRC_WP_VER_CODE
227: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
228: PA_PROJECTS_ALL P, PA_IMPLEMENTATIONS_ALL I,
229: PA_FIN_PLAN_AMOUNT_SETS FP,
230: PA_FIN_PLAN_TYPES_B FB
231: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID

Line 353: pa_proj_fp_options.proj_fp_options_id%TYPE,

349: p_version_type IN
350: pa_budget_versions.version_type%TYPE,
351: p_status_code IN VARCHAR2,
352: x_fp_options_id OUT NOCOPY
353: pa_proj_fp_options.proj_fp_options_id%TYPE,
354: x_fin_plan_version_id OUT NOCOPY
355: pa_proj_fp_options.fin_plan_version_id%TYPE,
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,

Line 355: pa_proj_fp_options.fin_plan_version_id%TYPE,

351: p_status_code IN VARCHAR2,
352: x_fp_options_id OUT NOCOPY
353: pa_proj_fp_options.proj_fp_options_id%TYPE,
354: x_fin_plan_version_id OUT NOCOPY
355: pa_proj_fp_options.fin_plan_version_id%TYPE,
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2)
359: AS

Line 374: pa_proj_fp_options.fin_plan_preference_code%TYPE;

370: l_debug_mode VARCHAR2(30);
371: --End of variables used for debugging
372:
373: l_fp_preference_code
374: pa_proj_fp_options.fin_plan_preference_code%TYPE;
375: l_version_type
376: pa_budget_versions.version_type%TYPE;
377: l_current_original_version_id
378: pa_budget_versions.budget_version_id%TYPE;

Line 380: pa_proj_fp_options.proj_fp_options_id%TYPE;

376: pa_budget_versions.version_type%TYPE;
377: l_current_original_version_id
378: pa_budget_versions.budget_version_id%TYPE;
379: l_fp_options_id
380: pa_proj_fp_options.proj_fp_options_id%TYPE;
381:
382: BEGIN
383:
384: x_msg_count := 0;

Line 443: FROM pa_proj_fp_options

439: END IF;
440:
441: SELECT fin_plan_preference_code
442: INTO l_fp_preference_code
443: FROM pa_proj_fp_options
444: WHERE project_id = p_project_id
445: AND fin_plan_type_id = p_fin_plan_type_id
446: AND fin_plan_option_level_code =
447: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line 546: FROM pa_proj_fp_options

542: END IF;
543:
544: SELECT proj_fp_options_id
545: INTO l_fp_options_id
546: FROM pa_proj_fp_options
547: WHERE fin_plan_version_id = l_current_original_version_id;
548:
549: EXCEPTION
550:

Line 624: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

620: END Get_Curr_Original_Version_Info;
621:
622: PROCEDURE VALIDATE_PLAN_VERSION
623: (P_PROJECT_ID IN
624: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
625: P_SRC_BDGT_VERSION_ID IN
626: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
627: P_TRGT_BDGT_VERSION_ID IN
628: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 703: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

699: END VALIDATE_PLAN_VERSION;
700:
701: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
702: (P_PROJECT_ID IN
703: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
704: P_BUDGET_VERSION_ID IN
705: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
706: P_RESOURCE_ASSIGNMENT_ID IN
707: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

Line 837: FROM pa_proj_fp_options pfo,

833: pfo.cost_burden_rate_sch_id,'ALL',
834: pfo.cost_burden_rate_sch_id, NULL))
835: cost_burden_rate_sch_id
836: ,bv.version_type
837: FROM pa_proj_fp_options pfo,
838: pa_budget_versions bv
839: WHERE pfo.fin_plan_version_id = bv.budget_version_id
840: AND bv.budget_version_id = p_budget_version_id;
841:

Line 907: -- Local variables for pa_proj_fp_options table

903:
904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;

Line 908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;

904: -- Local variables for pa_resource_list_members table
905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;

Line 909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;

905: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;

Line 910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;

906:
907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

Line 911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;

907: -- Local variables for pa_proj_fp_options table
908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;

Line 912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;

908: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;

Line 913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;

909: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;

Line 914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

910: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
918: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;

Line 915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;

911: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
918: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
919:

Line 916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;

912: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
918: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
919:
920: -- Local variables for pa_fp_rollup_tmp table

Line 917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;

913: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
914: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
915: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
916: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
917: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
918: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
919:
920: -- Local variables for pa_fp_rollup_tmp table
921: l_txn_currency_code pa_fp_rollup_tmp.txn_currency_code%TYPE := NULL;

Line 1350: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

1346: WHEN OTHERS THEN
1347: RETURN -1;
1348: END;
1349:
1350: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1351: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1352: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
1353: RETURN NUMBER IS
1354: l_control_flag VARCHAR2(10);

Line 1467: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

1463: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
1464: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1465: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1466:
1467: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1468: l_count NUMBER;
1469:
1470: l_fp_cols_rec_tgt PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1471: x_fp_cols_rec_tgt PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 2271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

2267: IS
2268: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_AMOUNT_UTILS.DEFAULT_BDGT_SRC_VER';
2269:
2270: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
2272:
2273: -- Variables for Budget Generation source version defaulting logic
2274: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;
2275: l_wp_id PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE := NULL;

Line 2274: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;

2270: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
2271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
2272:
2273: -- Variables for Budget Generation source version defaulting logic
2274: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;
2275: l_wp_id PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE := NULL;
2276: l_source_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2277: l_versioning_enabled PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_flag%TYPE;
2278:

Line 2283: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;

2279: -- ER 3491321: While doing unit testing, discovered a type-mismatch error
2280: -- which was not reached during unit testing for ER 4391254, where this bug
2281: -- was introduced. Previous type was GEN_SRC_COST_PLAN_VERSION_ID%TYPE.
2282:
2283: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
2284:
2285: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2286: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
2287:

Line 2285: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

2281: -- was introduced. Previous type was GEN_SRC_COST_PLAN_VERSION_ID%TYPE.
2282:
2283: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
2284:
2285: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2286: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
2287:
2288: l_update_details_flag VARCHAR2(1);
2289: l_dummy NUMBER;

Line 2402: * Now, we need to update back to pa_proj_fp_options*/

2398:
2399: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2400: /*As of now, we have the l_wp_id as wp struct version id
2401: * l_source_id as wp fin version id
2402: * Now, we need to update back to pa_proj_fp_options*/
2403: IF l_version_type = 'COST' THEN
2404: UPDATE PA_PROJ_FP_OPTIONS
2405: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2406: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;

Line 2404: UPDATE PA_PROJ_FP_OPTIONS

2400: /*As of now, we have the l_wp_id as wp struct version id
2401: * l_source_id as wp fin version id
2402: * Now, we need to update back to pa_proj_fp_options*/
2403: IF l_version_type = 'COST' THEN
2404: UPDATE PA_PROJ_FP_OPTIONS
2405: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2406: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2407: ELSIF l_version_type = 'ALL' THEN
2408: UPDATE PA_PROJ_FP_OPTIONS

Line 2408: UPDATE PA_PROJ_FP_OPTIONS

2404: UPDATE PA_PROJ_FP_OPTIONS
2405: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2406: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2407: ELSIF l_version_type = 'ALL' THEN
2408: UPDATE PA_PROJ_FP_OPTIONS
2409: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
2410: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2411: ELSIF l_version_type = 'REVENUE' THEN
2412: UPDATE PA_PROJ_FP_OPTIONS

Line 2412: UPDATE PA_PROJ_FP_OPTIONS

2408: UPDATE PA_PROJ_FP_OPTIONS
2409: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
2410: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2411: ELSIF l_version_type = 'REVENUE' THEN
2412: UPDATE PA_PROJ_FP_OPTIONS
2413: SET GEN_SRC_REV_WP_VERSION_ID = l_source_id
2414: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2415: END IF;
2416:

Line 2512: * Now, we need to update back to pa_proj_fp_options*/

2508: --dbms_output.put_line('==l_source_id:'||l_source_id);
2509:
2510: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2511: /*As of now, we have l_source_id as fin version id
2512: * Now, we need to update back to pa_proj_fp_options*/
2513: IF l_version_type = 'COST' THEN
2514: UPDATE PA_PROJ_FP_OPTIONS
2515: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2516: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;

Line 2514: UPDATE PA_PROJ_FP_OPTIONS

2510: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2511: /*As of now, we have l_source_id as fin version id
2512: * Now, we need to update back to pa_proj_fp_options*/
2513: IF l_version_type = 'COST' THEN
2514: UPDATE PA_PROJ_FP_OPTIONS
2515: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2516: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2517: ELSIF l_version_type = 'ALL' THEN
2518: UPDATE PA_PROJ_FP_OPTIONS

Line 2518: UPDATE PA_PROJ_FP_OPTIONS

2514: UPDATE PA_PROJ_FP_OPTIONS
2515: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2516: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2517: ELSIF l_version_type = 'ALL' THEN
2518: UPDATE PA_PROJ_FP_OPTIONS
2519: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
2520: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2521: ELSIF l_version_type = 'REVENUE' THEN
2522: UPDATE PA_PROJ_FP_OPTIONS

Line 2522: UPDATE PA_PROJ_FP_OPTIONS

2518: UPDATE PA_PROJ_FP_OPTIONS
2519: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
2520: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2521: ELSIF l_version_type = 'REVENUE' THEN
2522: UPDATE PA_PROJ_FP_OPTIONS
2523: SET GEN_SRC_REV_PLAN_VERSION_ID = l_source_id
2524: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2525: END IF;
2526: END IF; -- end gen_src_code-based logic