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_ROLLUP_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 147: FROM pa_proj_fp_options

143: SELECT decode(fin_plan_preference_code, PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,cost_fin_plan_level_code,
144: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,revenue_fin_plan_level_code,
145: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,all_fin_plan_level_code) planning_level
146: INTO x_planning_level
147: FROM pa_proj_fp_options
148: WHERE fin_plan_version_id = p_budget_version_id;
149: */
150:
151: pa_debug.reset_err_stack;

Line 206: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

202: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
203: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
204: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
205: l_project_id pa_projects.project_id%TYPE;
206: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
207:
208: l_msg_count NUMBER := 0;
209: l_msg_data VARCHAR2(2000);
210: l_return_status VARCHAR2(2000);

Line 380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

376: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
377: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
378: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
379: l_project_id pa_projects.project_id%TYPE;
380: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
381: l_proj_raw_cost pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE;
382: l_proj_burdened_cost pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE;
383: l_proj_revenue pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE;
384: /* l_quantity pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE; -- bug 3441943 */

Line 959: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

955: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
956: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
957: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
958: l_project_id pa_projects.project_id%TYPE;
959: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
960:
961: l_proj_raw_cost pa_resource_assignments.total_project_raw_cost%TYPE;
962: l_proj_burd_cost pa_resource_assignments.total_project_burdened_cost%TYPE;
963: l_proj_revenue pa_resource_assignments.total_project_revenue%TYPE;

Line 1603: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

1599: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
1600: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
1601: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
1602: l_project_id pa_projects.project_id%TYPE;
1603: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
1604:
1605: l_msg_count NUMBER := 0;
1606: l_data VARCHAR2(2000);
1607: l_msg_data VARCHAR2(2000);

Line 2039: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

2035: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
2036: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
2037: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
2038: l_project_id pa_projects.project_id%TYPE;
2039: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
2040: l_data_source VARCHAR2(20);
2041:
2042: l_msg_count NUMBER := 0;
2043: l_data VARCHAR2(2000);

Line 2621: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

2617: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
2618: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
2619: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
2620: l_project_id pa_projects.project_id%TYPE;
2621: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
2622:
2623: l_ra_id_tbl l_ra_id_tbl_typ;
2624: l_parent_res_id_tbl l_ra_id_tbl_typ;
2625: l_parent_ra_id_tbl l_par_id_tbl_typ;

Line 3684: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

3680: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
3681: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
3682: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
3683: l_project_id pa_projects.project_id%TYPE;
3684: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
3685: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
3686:
3687: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3688:

Line 4400: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

4396: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
4397: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
4398: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
4399: l_project_id pa_projects.project_id%TYPE;
4400: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
4401:
4402: l_parent_assignment_id pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE;
4403: l_rec_exists VARCHAR2(1);
4404: l_child_res_count NUMBER;