APPS.PA_FP_REV_GEN_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;

56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
64:

Line 62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;

58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
64:
65: l_cost_or_rev_code VARCHAR2(30) := 'COST';
66:

Line 63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;
61: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
62: l_approved_fp_version_id PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE;
63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
64:
65: l_cost_or_rev_code VARCHAR2(30) := 'COST';
66:
67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 113: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

109: l_pc_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0;
110: l_ratio_pc NUMBER;
111:
112: /* Variables added for Bug 4549862 */
113: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
114:
115: -- Variables added for IPM Enhancements
116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 362: FROM pa_proj_fp_options

358: 'REVENUE_ONLY', 'REVENUE' ,
359: 'COST_AND_REV_SEP', 'REVENUE',
360: 'COST_AND_REV_SAME', 'ALL')
361: INTO l_version_type
362: FROM pa_proj_fp_options
363: WHERE fin_plan_type_id = l_fin_plan_type_id
364: AND fin_plan_option_level_code = 'PLAN_TYPE'
365: AND project_id = P_FP_COLS_REC.X_PROJECT_ID;
366: