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_BUDGET_VERSIONS

Line 10: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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,
14: X_MSG_DATA OUT NOCOPY VARCHAR2)

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 368: pa_budget_versions.fin_plan_type_id%TYPE,

364: PROCEDURE Get_Curr_Original_Version_Info(
365: p_project_id IN
366: pa_projects_all.project_id%TYPE,
367: p_fin_plan_type_id IN
368: pa_budget_versions.fin_plan_type_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

Line 370: pa_budget_versions.version_type%TYPE,

366: pa_projects_all.project_id%TYPE,
367: p_fin_plan_type_id IN
368: pa_budget_versions.fin_plan_type_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

Line 396: pa_budget_versions.version_type%TYPE;

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;
399: l_fp_options_id
400: pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 398: pa_budget_versions.budget_version_id%TYPE;

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;
399: l_fp_options_id
400: pa_proj_fp_options.proj_fp_options_id%TYPE;
401:
402: BEGIN

Line 536: FROM pa_budget_versions

532: IF p_status_code = 'CURRENT_BASELINED'
533: OR p_status_code = 'CURRENT_APPROVED' THEN
534: SELECT budget_version_id
535: INTO l_current_original_version_id
536: FROM pa_budget_versions
537: WHERE project_id = p_project_id
538: AND fin_plan_type_id = p_fin_plan_type_id
539: AND version_type = NVL(p_version_type,l_version_type)
540: AND budget_status_code = 'B'

Line 546: FROM pa_budget_versions

542: ELSIF p_status_code = 'ORIGINAL_BASELINED'
543: OR p_status_code = 'ORIGINAL_APPROVED' THEN
544: SELECT budget_version_id
545: INTO l_current_original_version_id
546: FROM pa_budget_versions
547: WHERE project_id = p_project_id
548: AND fin_plan_type_id = p_fin_plan_type_id
549: AND version_type = NVL(p_version_type,l_version_type)
550: AND budget_status_code = 'B'

Line 646: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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,
649: X_MSG_COUNT OUT NOCOPY NUMBER,
650: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 648: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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,
649: X_MSG_COUNT OUT NOCOPY NUMBER,
650: X_MSG_DATA OUT NOCOPY VARCHAR2,
651: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
652:

Line 725: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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,
728: P_TASK_ID IN
729: PA_TASKS.TASK_ID%TYPE,

Line 858: pa_budget_versions bv

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:
862: --get_proj_fp_options_rec get_proj_fp_options_csr%ROWTYPE;

Line 938: l_fp_budget_version_type pa_budget_versions.version_type%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;
942: l_txn_plan_quantity pa_fp_rollup_tmp.quantity%TYPE := NULL;

Line 1298: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

1294:
1295: END FP_DEBUG;
1296:
1297:
1298: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1299: RETURN DATE IS
1300: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1301: BEGIN
1302: SELECT etc_start_date

Line 1300: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

1296:
1297:
1298: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1299: RETURN DATE IS
1300: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1301: BEGIN
1302: SELECT etc_start_date
1303: INTO x_etc_start_date
1304: FROM pa_budget_versions

Line 1304: FROM pa_budget_versions

1300: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1301: BEGIN
1302: SELECT etc_start_date
1303: INTO x_etc_start_date
1304: FROM pa_budget_versions
1305: WHERE budget_version_id = p_budget_version_id
1306: AND etc_start_date is not null;
1307:
1308: RETURN x_etc_start_date;

Line 1315: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

1311: WHEN OTHERS THEN
1312: RETURN x_etc_start_date;
1313: END;
1314:
1315: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1316: RETURN DATE IS
1317: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1318: BEGIN
1319: SELECT (etc_start_date)-1

Line 1317: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

1313: END;
1314:
1315: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1316: RETURN DATE IS
1317: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1318: BEGIN
1319: SELECT (etc_start_date)-1
1320: INTO x_actuals_thru_date
1321: FROM pa_budget_versions

Line 1321: FROM pa_budget_versions

1317: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1318: BEGIN
1319: SELECT (etc_start_date)-1
1320: INTO x_actuals_thru_date
1321: FROM pa_budget_versions
1322: WHERE budget_version_id = p_budget_version_id
1323: AND etc_start_date is not null;
1324:
1325: RETURN x_actuals_thru_date;

Line 1332: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)

1328: WHEN OTHERS THEN
1329: RETURN x_actuals_thru_date;
1330: END;
1331:
1332: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
1333: RETURN VARCHAR2 IS
1334: x_rl_uncategorized_flag VARCHAR2(1);
1335: BEGIN
1336:

Line 1350: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,

1346: RETURN 'N';
1347: END;
1348:
1349:
1350: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1351: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
1352: RETURN NUMBER IS
1353: x_uc_res_list_rlm_id NUMBER;
1354: BEGIN

Line 1371: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,

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);
1375: x_rlm_id NUMBER;

Line 1482: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

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;
1485: l_fp_cols_rec_source PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1486:

Line 1484: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

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;
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;

Line 1521: l_source_budget_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1517:
1518: l_src_prl_flag VARCHAR2(1);
1519: l_src_prl_flag1 VARCHAR2(1);
1520: l_trg_prl_flag VARCHAR2(1);
1521: l_source_budget_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1522: BEGIN
1523: IF p_pa_debug_mode = 'Y' THEN
1524: pa_debug.set_curr_function( p_function => 'VALIDATE_SUPPORT_CASES',
1525: p_debug_mode => p_pa_debug_mode);

Line 2356: l_wp_id PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE := NULL;

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:
2360: -- ER 3491321: While doing unit testing, discovered a type-mismatch error

Line 2357: l_source_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%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:
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

Line 2367: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%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;
2371:

Line 2412: FROM pa_budget_versions

2408: as the source for the budget generation when the budget
2409: generation source is Work plan. */
2410: SELECT project_structure_version_id
2411: INTO l_wp_id
2412: FROM pa_budget_versions
2413: WHERE budget_version_id = l_source_id;
2414: ELSE
2415: l_versioning_enabled :=
2416: PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED

Line 2502: UPDATE PA_BUDGET_VERSIONS

2498: /*project structure version id is populated when create new version.
2499: IF ( l_stru_sharing_code = 'SHARE_FULL' OR
2500: l_stru_sharing_code = 'SHARE_PARTIAL' ) AND
2501: P_FP_COLS_REC_TGT.X_FIN_PLAN_LEVEL_CODE <> 'P' THEN
2502: UPDATE PA_BUDGET_VERSIONS
2503: SET project_structure_version_id = l_wp_id
2504: WHERE budget_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2505: END IF;*/
2506: ELSIF (l_gen_src_code = 'FINANCIAL_PLAN') THEN

Line 2698: FUNCTION get_src_resource_class_flag(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)

2694: END IF;
2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2696: END DEFAULT_BDGT_SRC_VER;
2697: --Added for CBS
2698: FUNCTION get_src_resource_class_flag(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
2699: RETURN VARCHAR2
2700: IS
2701: l_flag VARCHAR2(5) := NULL;
2702: BEGIN

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 2728: pa_budget_versions bv,

2724: BEGIN
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 (+)

Line 2748: FUNCTION get_trg_resource_class_flag(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)

2744: END get_resource_class_flag_fr_bdg;
2745:
2746:
2747: --Added for CBS
2748: FUNCTION get_trg_resource_class_flag(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
2749: RETURN VARCHAR2
2750: IS
2751: l_flag VARCHAR2(5) := NULL;
2752: BEGIN