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_RESOURCE_LISTS

Line 34: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

30: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
33:
34: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
35: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
36: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
37: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
38: l_err_code NUMBER;

Line 100: ,pa_resource_lists prl

96: ,x_uncat_flag
97: ,x_rl_group_type_id
98: ,x_project_id
99: FROM pa_budget_versions pbv
100: ,pa_resource_lists prl
101: WHERE budget_version_id = p_budget_version_id
102: AND pbv.resource_list_id = prl.resource_list_id; /* M21-AUG: Join was missing */
103:
104:

Line 201: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

197: ,PX_INSERTING_PARENT_TASK_LEVEL IN OUT NOCOPY boolean --File.Sql.39 bug 4440895
198: ,p_curr_rollup_level IN NUMBER) IS
199:
200: l_debug_mode VARCHAR2(30);
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;

Line 202: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

198: ,p_curr_rollup_level IN NUMBER) IS
199:
200: l_debug_mode VARCHAR2(30);
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;

Line 203: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

199:
200: l_debug_mode VARCHAR2(30);
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:

Line 204: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

200: l_debug_mode VARCHAR2(30);
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;

Line 375: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

371: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
372: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
373: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
374:
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;

Line 376: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

372: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
373: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
374:
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;

Line 377: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

373: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
374:
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;

Line 378: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

374:
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;

Line 954: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

950: l_unit_of_measure_tbl l_unit_of_measure_tbl_typ;
951: l_track_as_labor_flag_tbl l_track_as_labor_flag_tbl_typ;
952:
953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_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;

Line 955: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

951: l_track_as_labor_flag_tbl l_track_as_labor_flag_tbl_typ;
952:
953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_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;

Line 956: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

952:
953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_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:

Line 957: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

953: l_curr_res_assignment_id pa_resource_assignments.resource_assignment_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;

Line 1598: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

1594: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1595: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1596: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1597:
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;

Line 1599: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

1595: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1596: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1597:
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;

Line 1600: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

1596: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1597:
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:

Line 1601: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

1597:
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;

Line 2034: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

2030:
2031: /* Declare the local variables. to get the values of OUT parameters. */
2032:
2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_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;

Line 2035: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

2031: /* Declare the local variables. to get the values of OUT parameters. */
2032:
2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_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;

Line 2036: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

2032:
2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_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);

Line 2037: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_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:

Line 2617: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

2613: GROUP BY pt.parent_task_id;
2614:
2615: l_continue_processing_flag VARCHAR2(1);
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;

Line 2618: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

2614:
2615: l_continue_processing_flag VARCHAR2(1);
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:

Line 2619: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

2615: l_continue_processing_flag VARCHAR2(1);
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;

Line 3680: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

3676: l_currency_code_tbl l_currency_code_tbl_typ;
3677:
3678:
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;

Line 3681: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

3677:
3678:
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;

Line 3682: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

3678:
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:

Line 4396: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

4392: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
4393:
4394:
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;

Line 4397: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;

4393:
4394:
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:

Line 4398: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;

4394:
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;