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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_VERSIONS

Line 7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE GENERATE_WP_BUDGET_AMT
6: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
11: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 11: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

7: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
9: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
10: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
11: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
12: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
13: P_CALLED_MODE IN VARCHAR2,
14: P_INC_CHG_DOC_FLAG IN VARCHAR2,
15: P_INC_BILL_EVENT_FLAG IN VARCHAR2,

Line 23: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,

19: P_COMMIT_FLAG IN VARCHAR2,
20: P_CALLING_CONTEXT IN VARCHAR2,
21: P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
22: P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
23: P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
24: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
25: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
26: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
27: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

403: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
404: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
405: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
406:
407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
410: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
411: l_dummy NUMBER;

Line 408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

404: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
405: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
406:
407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
410: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
411: l_dummy NUMBER;
412:

Line 409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

405: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
406:
407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
410: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
411: l_dummy NUMBER;
412:
413: --Local pl/sql table to call Map_Rlmi_Rbs api

Line 410: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

406:
407: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
408: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
409: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
410: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
411: l_dummy NUMBER;
412:
413: --Local pl/sql table to call Map_Rlmi_Rbs api
414: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 604: FROM pa_budget_versions

600: as the source for the budget generation when the budget
601: generation source is Work plan. */
602: SELECT project_structure_version_id
603: INTO l_wp_id
604: FROM pa_budget_versions
605: WHERE budget_version_id = l_source_id;
606: ELSE
607: l_versioning_enabled :=
608: PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);

Line 693: UPDATE PA_BUDGET_VERSIONS

689: /*project structure version id is populated when create new version.
690: IF ( l_stru_sharing_code = 'SHARE_FULL' OR
691: l_stru_sharing_code = 'SHARE_PARTIAL' ) AND
692: l_fp_cols_rec_target.X_FIN_PLAN_LEVEL_CODE <> 'P' THEN
693: UPDATE PA_BUDGET_VERSIONS
694: SET project_structure_version_id = l_wp_id
695: WHERE budget_version_id = P_BUDGET_VERSION_ID;
696: END IF;*/
697: ELSIF (l_gen_src_code = 'FINANCIAL_PLAN') THEN

Line 853: FROM PA_BUDGET_VERSIONS

849: NVL(APPROVED_REV_PLAN_TYPE_FLAG, 'N')
850: INTO
851: l_appr_cost_plan_type_flag,
852: l_appr_rev_plan_type_flag
853: FROM PA_BUDGET_VERSIONS
854: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
855:
856: /* When the Calling Context is Forecast generation and we set l_txn_currency_flag
857: * to 'A', we are really considering the case when the Source version is a Cost

Line 2765: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2761:
2762:
2763: PROCEDURE MAINTAIN_BUDGET_LINES
2764: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2765: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2766: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2767: P_CALLING_CONTEXT IN VARCHAR2,
2768: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2769: P_RETAIN_MANUAL_FLAG IN VARCHAR2,

Line 2766: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2762:
2763: PROCEDURE MAINTAIN_BUDGET_LINES
2764: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2765: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2766: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2767: P_CALLING_CONTEXT IN VARCHAR2,
2768: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2769: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
2770: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 3272: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

3268: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3269:
3270: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3272: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3273: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3274: l_same_planning_options_flag VARCHAR2(1);
3275:
3276: /* PL/SQL tables for copying source resource assignment attributes */

Line 3273: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

3269:
3270: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3271: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3272: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3273: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3274: l_same_planning_options_flag VARCHAR2(1);
3275:
3276: /* PL/SQL tables for copying source resource assignment attributes */
3277: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 3321: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

3317:
3318: l_rev_gen_method VARCHAR2(3);
3319: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;
3320:
3321: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3322: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3323:
3324: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3325: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 3322: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

3318: l_rev_gen_method VARCHAR2(3);
3319: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;
3320:
3321: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3322: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3323:
3324: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3325: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3326: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 3337: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

3333: l_data VARCHAR2(2000);
3334: l_msg_data VARCHAR2(2000);
3335: l_msg_index_out number;
3336:
3337: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3338: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3339: l_dummy NUMBER;
3340: l_wp_track_cost_flag VARCHAR2(1);
3341:

Line 3338: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

3334: l_msg_data VARCHAR2(2000);
3335: l_msg_index_out number;
3336:
3337: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3338: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3339: l_dummy NUMBER;
3340: l_wp_track_cost_flag VARCHAR2(1);
3341:
3342: -- Variables added for Bug 4292083

Line 3893: FROM PA_BUDGET_VERSIONS

3889: NVL(APPROVED_REV_PLAN_TYPE_FLAG, 'N')
3890: INTO
3891: l_appr_cost_plan_type_flag,
3892: l_appr_rev_plan_type_flag
3893: FROM PA_BUDGET_VERSIONS
3894: WHERE BUDGET_VERSION_ID = l_fp_cols_rec_target.x_budget_version_id;
3895:
3896: /* When the Calling Context is Forecast generation and we set l_txn_currency_flag
3897: * to 'A', we are really considering the case when the Source version is a Cost

Line 5692: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

5688: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
5689: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
5690:
5691: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
5692: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5693: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5694: l_rev_gen_method VARCHAR2(1);
5695:
5696: /* Local Calculate API flag parameters */

Line 5693: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

5689: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
5690:
5691: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
5692: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5693: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5694: l_rev_gen_method VARCHAR2(1);
5695:
5696: /* Local Calculate API flag parameters */
5697: l_refresh_rates_flag VARCHAR2(1);