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_ELEMENTS_PUB dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 947: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;

943: l_res_planned_for_task CONSTANT pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE := 'N';
944: l_plan_amt_exists_flag CONSTANT pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE := 'N';
945:
946: /* Bug 2586647*/
947: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
948: l_is_resource_list_grouped VARCHAR2(1);
949: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
950:
951: /* According to guidelines from Performance group

Line 949: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;

945:
946: /* Bug 2586647*/
947: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
948: l_is_resource_list_grouped VARCHAR2(1);
949: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
950:
951: /* According to guidelines from Performance group
952: plsql table size should never exceed 200 */
953:

Line 1145: FROM pa_resource_lists_all_bg R1, pa_implementations_all I

1141: END IF;
1142:
1143: /* SELECT decode(uncategorized_flag,'Y',NULL,PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R)
1144: INTO l_res_planning_level
1145: FROM pa_resource_lists_all_bg R1, pa_implementations_all I
1146: WHERE R1.resource_list_id = l_resource_list_id
1147: AND R1.business_group_id = I.business_group_id;
1148: */
1149:

Line 2265: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

2261: pa_debug.write('create_enterable_resources: ' || l_module_name,pa_debug.g_err_stage,3);
2262: END IF;
2263:
2264: DECLARE
2265: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
2266: BEGIN
2267:
2268: PA_FIN_PLAN_UTILS.Get_Uncat_Resource_List_Info
2269: (x_resource_list_id => l_dummy_res_list_id

Line 3378: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;

3374: l_msg_data VARCHAR2(2000);
3375: l_msg_index_out NUMBER;
3376: l_return_status VARCHAR2(2000);
3377: l_debug_mode VARCHAR2(30);
3378: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
3379: l_is_resource_list_grouped VARCHAR2(1);
3380: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
3381: l_resource_list_id PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE;
3382: l_res_planning_level PA_FP_ELEMENTS.RESOURCE_PLANNING_LEVEL%TYPE;

Line 3380: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;

3376: l_return_status VARCHAR2(2000);
3377: l_debug_mode VARCHAR2(30);
3378: l_res_list_is_uncategorized PA_RESOURCE_LISTS_ALL_BG.UNCATEGORIZED_FLAG%TYPE;
3379: l_is_resource_list_grouped VARCHAR2(1);
3380: l_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%TYPE;
3381: l_resource_list_id PA_PROJ_FP_OPTIONS.ALL_RESOURCE_LIST_ID%TYPE;
3382: l_res_planning_level PA_FP_ELEMENTS.RESOURCE_PLANNING_LEVEL%TYPE;
3383: l_fin_plan_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
3384: l_stage NUMBER := 100;

Line 4535: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE

4531: PROCEDURE Add_resources_automatically
4532: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
4533: ,p_element_type IN pa_fp_elements.element_type%TYPE
4534: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
4535: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
4536: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
4537: ,p_entire_option IN VARCHAR2
4538: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ
4539: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4554: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

4550: l_task_tbl_index NUMBER;
4551: l_rlm_tbl_index NUMBER;
4552: l_res_uncategorized_flag VARCHAR2(1);
4553: l_is_resource_list_grouped VARCHAR2(1);
4554: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
4555:
4556:
4557: /*
4558: The following pl/sql tables are used to store task_id, top_task_id,

Line 4608: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4604: 'UNCLASSIFIED' resource list member is filtered as that
4605: shouldn't be added to the option.
4606: */
4607: CURSOR ungrouped_res_cur
4608: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4609: IS
4610: SELECT resource_list_member_id
4611: FROM pa_resource_list_members
4612: WHERE resource_list_id = c_resource_list_id

Line 4624: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4620: is Resource.'UNCLASSIFIED' resource list member is filtered as that
4621: shouldn't be added to the option.
4622: */
4623: CURSOR grouped_res_level_res_cur
4624: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4625: IS
4626: SELECT resource_list_member_id
4627: FROM pa_resource_list_members
4628: WHERE resource_list_id = c_resource_list_id

Line 4641: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4637: is Resource Group.'UNCLASSIFIED' resource list member is filtered as that
4638: shouldn't be added to the option.
4639: */
4640: CURSOR grouped_resgrp_level_res_cur
4641: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4642: IS
4643: SELECT resource_list_member_id
4644: FROM pa_resource_list_members
4645: WHERE resource_list_id = c_resource_list_id