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 11: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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

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

344: PROCEDURE Get_Curr_Original_Version_Info(
345: p_project_id IN
346: pa_projects_all.project_id%TYPE,
347: p_fin_plan_type_id IN
348: pa_budget_versions.fin_plan_type_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

Line 350: pa_budget_versions.version_type%TYPE,

346: pa_projects_all.project_id%TYPE,
347: p_fin_plan_type_id IN
348: pa_budget_versions.fin_plan_type_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

Line 376: pa_budget_versions.version_type%TYPE;

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

Line 378: pa_budget_versions.budget_version_id%TYPE;

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;
379: l_fp_options_id
380: pa_proj_fp_options.proj_fp_options_id%TYPE;
381:
382: BEGIN

Line 516: FROM pa_budget_versions

512: IF p_status_code = 'CURRENT_BASELINED'
513: OR p_status_code = 'CURRENT_APPROVED' THEN
514: SELECT budget_version_id
515: INTO l_current_original_version_id
516: FROM pa_budget_versions
517: WHERE project_id = p_project_id
518: AND fin_plan_type_id = p_fin_plan_type_id
519: AND version_type = NVL(p_version_type,l_version_type)
520: AND budget_status_code = 'B'

Line 526: FROM pa_budget_versions

522: ELSIF p_status_code = 'ORIGINAL_BASELINED'
523: OR p_status_code = 'ORIGINAL_APPROVED' THEN
524: SELECT budget_version_id
525: INTO l_current_original_version_id
526: FROM pa_budget_versions
527: WHERE project_id = p_project_id
528: AND fin_plan_type_id = p_fin_plan_type_id
529: AND version_type = NVL(p_version_type,l_version_type)
530: AND budget_status_code = 'B'

Line 626: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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

Line 628: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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,
629: X_MSG_COUNT OUT NOCOPY NUMBER,
630: X_MSG_DATA OUT NOCOPY VARCHAR2,
631: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
632:

Line 705: PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

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

Line 838: pa_budget_versions bv

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

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

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

1274:
1275: END FP_DEBUG;
1276:
1277:
1278: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1279: RETURN DATE IS
1280: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1281: BEGIN
1282: SELECT etc_start_date

Line 1280: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

1276:
1277:
1278: FUNCTION GET_ETC_START_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1279: RETURN DATE IS
1280: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1281: BEGIN
1282: SELECT etc_start_date
1283: INTO x_etc_start_date
1284: FROM pa_budget_versions

Line 1284: FROM pa_budget_versions

1280: x_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1281: BEGIN
1282: SELECT etc_start_date
1283: INTO x_etc_start_date
1284: FROM pa_budget_versions
1285: WHERE budget_version_id = p_budget_version_id
1286: AND etc_start_date is not null;
1287:
1288: RETURN x_etc_start_date;

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

1291: WHEN OTHERS THEN
1292: RETURN x_etc_start_date;
1293: END;
1294:
1295: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1296: RETURN DATE IS
1297: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1298: BEGIN
1299: SELECT (etc_start_date)-1

Line 1297: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;

1293: END;
1294:
1295: FUNCTION GET_ACTUALS_THRU_DATE(P_BUDGET_VERSION_ID PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
1296: RETURN DATE IS
1297: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1298: BEGIN
1299: SELECT (etc_start_date)-1
1300: INTO x_actuals_thru_date
1301: FROM pa_budget_versions

Line 1301: FROM pa_budget_versions

1297: x_actuals_thru_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
1298: BEGIN
1299: SELECT (etc_start_date)-1
1300: INTO x_actuals_thru_date
1301: FROM pa_budget_versions
1302: WHERE budget_version_id = p_budget_version_id
1303: AND etc_start_date is not null;
1304:
1305: RETURN x_actuals_thru_date;

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

1308: WHEN OTHERS THEN
1309: RETURN x_actuals_thru_date;
1310: END;
1311:
1312: FUNCTION GET_RL_UNCATEGORIZED_FLAG(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE)
1313: RETURN VARCHAR2 IS
1314: x_rl_uncategorized_flag VARCHAR2(1);
1315: BEGIN
1316:

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

1326: RETURN 'N';
1327: END;
1328:
1329:
1330: FUNCTION GET_UC_RES_LIST_RLM_ID(P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,
1331: P_RESOURCE_CLASS_CODE pa_resource_list_members.RESOURCE_CLASS_CODE%TYPE)
1332: RETURN NUMBER IS
1333: x_uc_res_list_rlm_id NUMBER;
1334: BEGIN

Line 1351: P_RESOURCE_LIST_ID PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE,

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

Line 1462: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1458: l_wp_track_cost_flag VARCHAR2(1);
1459: l_rev_gen_method VARCHAR2(1);
1460: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1461:
1462: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%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:

Line 1464: l_source_fp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1460: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
1461:
1462: l_source_wp_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%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;

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

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

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

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

Line 2331: FROM pa_budget_versions

2327: as the source for the budget generation when the budget
2328: generation source is Work plan. */
2329: SELECT project_structure_version_id
2330: INTO l_wp_id
2331: FROM pa_budget_versions
2332: WHERE budget_version_id = l_source_id;
2333: ELSE
2334: l_versioning_enabled :=
2335: PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED

Line 2421: UPDATE PA_BUDGET_VERSIONS

2417: /*project structure version id is populated when create new version.
2418: IF ( l_stru_sharing_code = 'SHARE_FULL' OR
2419: l_stru_sharing_code = 'SHARE_PARTIAL' ) AND
2420: P_FP_COLS_REC_TGT.X_FIN_PLAN_LEVEL_CODE <> 'P' THEN
2421: UPDATE PA_BUDGET_VERSIONS
2422: SET project_structure_version_id = l_wp_id
2423: WHERE budget_version_id = P_FP_COLS_REC_TGT.X_BUDGET_VERSION_ID;
2424: END IF;*/
2425: ELSIF (l_gen_src_code = 'FINANCIAL_PLAN') THEN