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.

[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_PROJ_FP_OPTIONS

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

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

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

242: X_FP_COLS_REC.X_PROJECT_VALUE,
243: X_FP_COLS_REC.X_TRACK_WORKPLAN_COSTS_FLAG,
244: X_FP_COLS_REC.X_GEN_SRC_WP_VERSION_ID,
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

Line 373: pa_proj_fp_options.proj_fp_options_id%TYPE,

369: p_version_type IN
370: pa_budget_versions.version_type%TYPE,
371: p_status_code IN VARCHAR2,
372: x_fp_options_id OUT NOCOPY
373: pa_proj_fp_options.proj_fp_options_id%TYPE,
374: x_fin_plan_version_id OUT NOCOPY
375: pa_proj_fp_options.fin_plan_version_id%TYPE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,

Line 375: pa_proj_fp_options.fin_plan_version_id%TYPE,

371: p_status_code IN VARCHAR2,
372: x_fp_options_id OUT NOCOPY
373: pa_proj_fp_options.proj_fp_options_id%TYPE,
374: x_fin_plan_version_id OUT NOCOPY
375: pa_proj_fp_options.fin_plan_version_id%TYPE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2)
379: AS

Line 394: pa_proj_fp_options.fin_plan_preference_code%TYPE;

390: l_debug_mode VARCHAR2(30);
391: --End of variables used for debugging
392:
393: l_fp_preference_code
394: pa_proj_fp_options.fin_plan_preference_code%TYPE;
395: l_version_type
396: pa_budget_versions.version_type%TYPE;
397: l_current_original_version_id
398: pa_budget_versions.budget_version_id%TYPE;

Line 400: pa_proj_fp_options.proj_fp_options_id%TYPE;

396: pa_budget_versions.version_type%TYPE;
397: l_current_original_version_id
398: pa_budget_versions.budget_version_id%TYPE;
399: l_fp_options_id
400: pa_proj_fp_options.proj_fp_options_id%TYPE;
401:
402: BEGIN
403:
404: x_msg_count := 0;

Line 463: FROM pa_proj_fp_options

459: END IF;
460:
461: SELECT fin_plan_preference_code
462: INTO l_fp_preference_code
463: FROM pa_proj_fp_options
464: WHERE project_id = p_project_id
465: AND fin_plan_type_id = p_fin_plan_type_id
466: AND fin_plan_option_level_code =
467: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line 566: FROM pa_proj_fp_options

562: END IF;
563:
564: SELECT proj_fp_options_id
565: INTO l_fp_options_id
566: FROM pa_proj_fp_options
567: WHERE fin_plan_version_id = l_current_original_version_id;
568:
569: EXCEPTION
570:

Line 644: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

640: END Get_Curr_Original_Version_Info;
641:
642: PROCEDURE VALIDATE_PLAN_VERSION
643: (P_PROJECT_ID IN
644: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
645: P_SRC_BDGT_VERSION_ID IN
646: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
647: P_TRGT_BDGT_VERSION_ID IN
648: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 723: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

719: END VALIDATE_PLAN_VERSION;
720:
721: PROCEDURE GET_VALUES_FOR_PLANNING_RATE
722: (P_PROJECT_ID IN
723: PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
724: P_BUDGET_VERSION_ID IN
725: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
726: P_RESOURCE_ASSIGNMENT_ID IN
727: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

Line 857: FROM pa_proj_fp_options pfo,

853: pfo.cost_burden_rate_sch_id,'ALL',
854: pfo.cost_burden_rate_sch_id, NULL))
855: cost_burden_rate_sch_id
856: ,bv.version_type
857: FROM pa_proj_fp_options pfo,
858: pa_budget_versions bv
859: WHERE pfo.fin_plan_version_id = bv.budget_version_id
860: AND bv.budget_version_id = p_budget_version_id;
861:

Line 927: -- Local variables for pa_proj_fp_options table

923:
924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;

Line 928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;

924: -- Local variables for pa_resource_list_members table
925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;

Line 929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;

925: l_res_format_id pa_resource_list_members.res_format_id%TYPE;
926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;

Line 930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;

926:
927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

Line 931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;

927: -- Local variables for pa_proj_fp_options table
928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;

Line 932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;

928: l_fp_res_cl_bill_rate_sch_id pa_proj_fp_options.res_class_bill_rate_sch_id%TYPE;
929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;

Line 933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;

929: l_fp_res_cl_raw_cost_sch_id pa_proj_fp_options.res_class_raw_cost_sch_id%TYPE;
930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;

Line 934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;

930: l_fp_use_planning_rt_flag pa_proj_fp_options.use_planning_rates_flag%TYPE;
931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
938: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;

Line 935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;

931: l_fp_rev_job_rate_sch_id pa_proj_fp_options.rev_job_rate_sch_id%TYPE;
932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
938: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
939:

Line 936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;

932: l_fp_cost_job_rate_sch_id pa_proj_fp_options.cost_job_rate_sch_id%TYPE;
933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
938: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
939:
940: -- Local variables for pa_fp_rollup_tmp table

Line 937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;

933: l_fp_rev_emp_rate_sch_id pa_proj_fp_options.rev_emp_rate_sch_id%TYPE;
934: l_fp_cost_emp_rate_sch_id pa_proj_fp_options.cost_emp_rate_sch_id%TYPE;
935: l_fp_rev_non_lab_rs_rt_sch_id pa_proj_fp_options.rev_non_labor_res_rate_sch_id%TYPE;
936: l_fp_cost_non_lab_rs_rt_sch_id pa_proj_fp_options.cost_non_labor_res_rate_sch_id%TYPE;
937: l_fp_cost_burden_rate_sch_id pa_proj_fp_options.cost_burden_rate_sch_id%TYPE;
938: l_fp_budget_version_type pa_budget_versions.version_type%TYPE;
939:
940: -- Local variables for pa_fp_rollup_tmp table
941: l_txn_currency_code pa_fp_rollup_tmp.txn_currency_code%TYPE := NULL;

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

1366: WHEN OTHERS THEN
1367: RETURN -1;
1368: END;
1369:
1370: FUNCTION GET_RLM_ID(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
1371: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1372: P_RESOURCE_CLASS_CODE pa_resource_assignments.resource_class_code%type)
1373: RETURN NUMBER IS
1374: l_control_flag VARCHAR2(10);

Line 1487: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%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;
1485: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1486:
1487: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1488: l_count NUMBER;
1489:
1490: l_fp_cols_rec_tgt PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1491: x_fp_cols_rec_tgt PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 2352: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

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;
2356: l_wp_id PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE := NULL;

Line 2355: l_wp_status PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%TYPE;

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;
2356: l_wp_id PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE := NULL;
2357: l_source_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
2358: l_versioning_enabled PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_flag%TYPE;
2359:

Line 2364: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;

2360: -- ER 3491321: While doing unit testing, discovered a type-mismatch error
2361: -- which was not reached during unit testing for ER 4391254, where this bug
2362: -- was introduced. Previous type was GEN_SRC_COST_PLAN_VERSION_ID%TYPE.
2363:
2364: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
2365:
2366: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2367: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
2368:

Line 2366: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

2362: -- was introduced. Previous type was GEN_SRC_COST_PLAN_VERSION_ID%TYPE.
2363:
2364: l_gen_src_plan_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_VER_CODE%TYPE;
2365:
2366: l_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2367: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
2368:
2369: l_update_details_flag VARCHAR2(1);
2370: l_dummy NUMBER;

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

2479:
2480: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2481: /*As of now, we have the l_wp_id as wp struct version id
2482: * l_source_id as wp fin version id
2483: * Now, we need to update back to pa_proj_fp_options*/
2484: IF l_version_type = 'COST' THEN
2485: UPDATE PA_PROJ_FP_OPTIONS
2486: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2487: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;

Line 2485: UPDATE PA_PROJ_FP_OPTIONS

2481: /*As of now, we have the l_wp_id as wp struct version id
2482: * l_source_id as wp fin version id
2483: * Now, we need to update back to pa_proj_fp_options*/
2484: IF l_version_type = 'COST' THEN
2485: UPDATE PA_PROJ_FP_OPTIONS
2486: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2487: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2488: ELSIF l_version_type = 'ALL' THEN
2489: UPDATE PA_PROJ_FP_OPTIONS

Line 2489: UPDATE PA_PROJ_FP_OPTIONS

2485: UPDATE PA_PROJ_FP_OPTIONS
2486: SET GEN_SRC_COST_WP_VERSION_ID = l_source_id
2487: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2488: ELSIF l_version_type = 'ALL' THEN
2489: UPDATE PA_PROJ_FP_OPTIONS
2490: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
2491: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2492: ELSIF l_version_type = 'REVENUE' THEN
2493: UPDATE PA_PROJ_FP_OPTIONS

Line 2493: UPDATE PA_PROJ_FP_OPTIONS

2489: UPDATE PA_PROJ_FP_OPTIONS
2490: SET GEN_SRC_ALL_WP_VERSION_ID = l_source_id
2491: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2492: ELSIF l_version_type = 'REVENUE' THEN
2493: UPDATE PA_PROJ_FP_OPTIONS
2494: SET GEN_SRC_REV_WP_VERSION_ID = l_source_id
2495: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2496: END IF;
2497:

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

2589: --dbms_output.put_line('==l_source_id:'||l_source_id);
2590:
2591: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2592: /*As of now, we have l_source_id as fin version id
2593: * Now, we need to update back to pa_proj_fp_options*/
2594: IF l_version_type = 'COST' THEN
2595: UPDATE PA_PROJ_FP_OPTIONS
2596: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2597: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;

Line 2595: UPDATE PA_PROJ_FP_OPTIONS

2591: l_version_type := P_FP_COLS_REC_TGT.x_version_type;
2592: /*As of now, we have l_source_id as fin version id
2593: * Now, we need to update back to pa_proj_fp_options*/
2594: IF l_version_type = 'COST' THEN
2595: UPDATE PA_PROJ_FP_OPTIONS
2596: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2597: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2598: ELSIF l_version_type = 'ALL' THEN
2599: UPDATE PA_PROJ_FP_OPTIONS

Line 2599: UPDATE PA_PROJ_FP_OPTIONS

2595: UPDATE PA_PROJ_FP_OPTIONS
2596: SET GEN_SRC_COST_PLAN_VERSION_ID = l_source_id
2597: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2598: ELSIF l_version_type = 'ALL' THEN
2599: UPDATE PA_PROJ_FP_OPTIONS
2600: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
2601: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2602: ELSIF l_version_type = 'REVENUE' THEN
2603: UPDATE PA_PROJ_FP_OPTIONS

Line 2603: UPDATE PA_PROJ_FP_OPTIONS

2599: UPDATE PA_PROJ_FP_OPTIONS
2600: SET GEN_SRC_ALL_PLAN_VERSION_ID = l_source_id
2601: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2602: ELSIF l_version_type = 'REVENUE' THEN
2603: UPDATE PA_PROJ_FP_OPTIONS
2604: SET GEN_SRC_REV_PLAN_VERSION_ID = l_source_id
2605: WHERE fin_plan_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2606: END IF;
2607: END IF; -- end gen_src_code-based logic

Line 2705: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT,

2701: l_flag VARCHAR2(5) := NULL;
2702: BEGIN
2703: SELECT NVL(res.RESOURCE_CLASS_FLAG,'Y')
2704: INTO l_flag
2705: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT,
2706: pa_resource_lists_all_bg res
2707: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2708: AND OPT.PROJECT_ID = BV.PROJECT_ID
2709: AND OPT.FIN_PLAN_TYPE_ID = BV.FIN_PLAN_TYPE_ID

Line 2720: FUNCTION get_resource_class_flag_fr_bdg(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE , p_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE)

2716: WHEN OTHERS THEN
2717: RETURN l_flag;
2718: END get_src_resource_class_flag;
2719:
2720: FUNCTION get_resource_class_flag_fr_bdg(P_PROJECT_ID PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE , p_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE)
2721: RETURN VARCHAR2
2722: IS
2723: l_flag VARCHAR2(5) := NULL;
2724: BEGIN

Line 2729: pa_proj_fp_options pfo

2725: select NVL(PA_FP_GEN_AMOUNT_UTILS.get_src_resource_class_flag(bv.budget_version_id),'Y') as Resource_Class_Flag
2726: into l_flag
2727: FROM pa_fin_plan_types_vl pt,
2728: pa_budget_versions bv,
2729: pa_proj_fp_options pfo
2730: WHERE pfo.project_id = P_PROJECT_ID
2731: AND pfo.project_id =bv.project_id (+)
2732: AND pfo.fin_plan_type_id =bv.fin_plan_type_id (+)
2733: AND pfo.fin_plan_type_id =pt.fin_plan_type_id