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_PROJECTS

Line 205: l_project_id pa_projects.project_id%TYPE;

201: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%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);

Line 379: l_project_id pa_projects.project_id%TYPE;

375: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%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;

Line 587: , pa_projects_all p

583: BEGIN
584: SELECT org_project_flag
585: INTO l_org_forecast_flag
586: FROM pa_budget_versions v
587: , pa_projects_all p
588: , pa_project_types_all pt
589: WHERE v.budget_version_id = p_budget_version_id
590: AND v.project_id = p.project_id
591: AND p.project_type = pt.project_type

Line 958: l_project_id pa_projects.project_id%TYPE;

954: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%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;

Line 1602: l_project_id pa_projects.project_id%TYPE;

1598: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%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);

Line 2038: l_project_id pa_projects.project_id%TYPE;

2034: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%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;

Line 2055: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

2051: L_INSERTING_RES_GROUP_LEVEL boolean := false;
2052: L_INSERTING_TASK_LEVEL boolean := false;
2053: L_INSERTING_PARENT_TASK_LEVEL boolean := false;
2054:
2055: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
2056:
2057: BEGIN
2058:
2059: -- Set the error stack.

Line 2128: FROM pa_projects_all

2124: /* #2801522: Getting the project currency code for storing in the 'QAUNTITY' record. */
2125:
2126: SELECT project_currency_code
2127: INTO l_proj_currency_code
2128: FROM pa_projects_all
2129: WHERE project_id = l_project_id;
2130:
2131: IF (l_period_profile_id IS NOT NULL) THEN
2132:

Line 2620: l_project_id pa_projects.project_id%TYPE;

2616: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%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;

Line 3683: l_project_id pa_projects.project_id%TYPE;

3679: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%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;

Line 3685: l_proj_currency_code pa_projects_all.project_currency_code%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:
3689: l_curr_rollup_level NUMBER := 0;

Line 3782: FROM pa_projects_all

3778: /* #2801522: Getting the project currency code for storing in the 'QAUNTITY' record. */
3779:
3780: SELECT project_currency_code
3781: INTO l_proj_currency_code
3782: FROM pa_projects_all
3783: WHERE project_id = l_project_id;
3784:
3785: /* set total number of levels in rollup.
3786: Total number of level = number of levels in WBS + resource group (in case resource list is grouped)

Line 4399: l_project_id pa_projects.project_id%TYPE;

4395: l_uncat_rlm_id pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%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);

Line 4425: l_project_currency_code pa_projects_all.project_currency_code%type;

4421: l_task_id pa_tasks.task_id%type;
4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;
4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
4427:
4428:
4429: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;

4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;
4426: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
4427:
4428:
4429: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
4430: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type();

Line 4522: from pa_projects_all

4518:
4519: --Bug # 2615807.
4520: select project_currency_code,projfunc_currency_code
4521: into l_project_currency_code,l_projfunc_currency_code
4522: from pa_projects_all
4523: where project_id = l_project_id;
4524:
4525: IF (p_txn_currency_code IS NULL) THEN
4526: