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 372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

368: tmp_task_tab pa_plsql_datatypes.IdTabTyp;
369: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
370: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
371:
372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
375: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
376: l_dummy NUMBER;

Line 373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

369: tmp_ra_tab pa_plsql_datatypes.IdTabTyp;
370: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
371:
372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
375: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
376: l_dummy NUMBER;
377:

Line 374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

370: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%type;
371:
372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
375: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
376: l_dummy NUMBER;
377:
378: --Local pl/sql table to call Map_Rlmi_Rbs api

Line 375: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

371:
372: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
373: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
374: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
375: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
376: l_dummy NUMBER;
377:
378: --Local pl/sql table to call Map_Rlmi_Rbs api
379: l_TXN_SOURCE_ID_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 568: FROM pa_budget_versions

564: as the source for the budget generation when the budget
565: generation source is Work plan. */
566: SELECT project_structure_version_id
567: INTO l_wp_id
568: FROM pa_budget_versions
569: WHERE budget_version_id = l_source_id;
570: ELSE
571: l_versioning_enabled :=
572: PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);

Line 657: UPDATE PA_BUDGET_VERSIONS

653: /*project structure version id is populated when create new version.
654: IF ( l_stru_sharing_code = 'SHARE_FULL' OR
655: l_stru_sharing_code = 'SHARE_PARTIAL' ) AND
656: l_fp_cols_rec_target.X_FIN_PLAN_LEVEL_CODE <> 'P' THEN
657: UPDATE PA_BUDGET_VERSIONS
658: SET project_structure_version_id = l_wp_id
659: WHERE budget_version_id = P_BUDGET_VERSION_ID;
660: END IF;*/
661: ELSIF (l_gen_src_code = 'FINANCIAL_PLAN') THEN

Line 817: FROM PA_BUDGET_VERSIONS

813: NVL(APPROVED_REV_PLAN_TYPE_FLAG, 'N')
814: INTO
815: l_appr_cost_plan_type_flag,
816: l_appr_rev_plan_type_flag
817: FROM PA_BUDGET_VERSIONS
818: WHERE BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;
819:
820: /* When the Calling Context is Forecast generation and we set l_txn_currency_flag
821: * to 'A', we are really considering the case when the Source version is a Cost

Line 2723: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2719:
2720:
2721: PROCEDURE MAINTAIN_BUDGET_LINES
2722: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2723: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2724: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2725: P_CALLING_CONTEXT IN VARCHAR2,
2726: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2727: P_RETAIN_MANUAL_FLAG IN VARCHAR2,

Line 2724: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

2720:
2721: PROCEDURE MAINTAIN_BUDGET_LINES
2722: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
2723: P_SOURCE_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2724: P_TARGET_BV_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2725: P_CALLING_CONTEXT IN VARCHAR2,
2726: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
2727: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
2728: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 3194: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

3190: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
3191:
3192: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3193: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3194: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3195: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3196: l_same_planning_options_flag VARCHAR2(1);
3197:
3198: /* PL/SQL tables for copying source resource assignment attributes */

Line 3195: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

3191:
3192: /* Variables for COMPARE_ETC_SRC_TARGET_FP_OPT API call */
3193: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
3194: l_wp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3195: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
3196: l_same_planning_options_flag VARCHAR2(1);
3197:
3198: /* PL/SQL tables for copying source resource assignment attributes */
3199: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 3243: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

3239:
3240: l_rev_gen_method VARCHAR2(3);
3241: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;
3242:
3243: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3244: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3245:
3246: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3247: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 3244: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

3240: l_rev_gen_method VARCHAR2(3);
3241: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;
3242:
3243: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3244: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
3245:
3246: /* Bug 3968748: PL/SQL tables for populating PA_FP_GEN_RATE_TMP */
3247: l_nrb_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3248: l_nrb_txn_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 3259: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

3255: l_data VARCHAR2(2000);
3256: l_msg_data VARCHAR2(2000);
3257: l_msg_index_out number;
3258:
3259: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3260: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3261: l_dummy NUMBER;
3262: l_wp_track_cost_flag VARCHAR2(1);
3263:

Line 3260: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

3256: l_msg_data VARCHAR2(2000);
3257: l_msg_index_out number;
3258:
3259: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3260: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
3261: l_dummy NUMBER;
3262: l_wp_track_cost_flag VARCHAR2(1);
3263:
3264: -- Variables added for Bug 4292083

Line 3815: FROM PA_BUDGET_VERSIONS

3811: NVL(APPROVED_REV_PLAN_TYPE_FLAG, 'N')
3812: INTO
3813: l_appr_cost_plan_type_flag,
3814: l_appr_rev_plan_type_flag
3815: FROM PA_BUDGET_VERSIONS
3816: WHERE BUDGET_VERSION_ID = l_fp_cols_rec_target.x_budget_version_id;
3817:
3818: /* When the Calling Context is Forecast generation and we set l_txn_currency_flag
3819: * to 'A', we are really considering the case when the Source version is a Cost

Line 5613: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

5609: lc_BudgetGeneration CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
5610: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
5611:
5612: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
5613: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5614: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5615: l_rev_gen_method VARCHAR2(1);
5616:
5617: /* Local Calculate API flag parameters */

Line 5614: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

5610: lc_ForecastGeneration CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
5611:
5612: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
5613: l_source_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5614: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
5615: l_rev_gen_method VARCHAR2(1);
5616:
5617: /* Local Calculate API flag parameters */
5618: l_refresh_rates_flag VARCHAR2(1);