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

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 1585: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

1581: l_msg_index_out NUMBER;
1582: l_return_status VARCHAR2(2000);
1583: l_debug_mode VARCHAR2(30);
1584:
1585: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
1586: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
1587: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
1588: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
1589: l_err_code NUMBER;

Line 2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;

2092: l_max_fetch_size NUMBER := 200; -- limiting the max fetch size
2093:
2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;

Line 2242: FROM pa_resource_lists

2238: END IF;
2239:
2240: SELECT NVL(uncategorized_flag,'N')
2241: INTO l_uncat_flag
2242: FROM pa_resource_lists
2243: WHERE resource_list_id = l_resource_list_id;
2244:
2245:
2246: /* Checking uncategorised flag to avoid a join with

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 2697: ,p_uncategorized_flag IN pa_resource_lists.uncategorized_flag%TYPE

2693: The following function returns resource_planning_level based upon the i/ps.
2694: ========================================================================*/
2695: FUNCTION get_resource_planning_level(
2696: p_parent_member_id IN pa_resource_list_members.parent_member_id%TYPE
2697: ,p_uncategorized_flag IN pa_resource_lists.uncategorized_flag%TYPE
2698: ,p_grouped_flag IN VARCHAR2)
2699: RETURN pa_fp_elements.resource_planning_level%TYPE IS
2700:
2701: l_resource_planning_level pa_fp_elements.resource_planning_level%TYPE;

Line 2768: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

2764: l_debug_mode VARCHAR2(30);
2765:
2766: l_plsql_max_array_size NUMBER := 200;
2767:
2768: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2769: l_grouped_flag VARCHAR2(1); --indicates if resource_list is grouped
2770: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
2771:
2772: l_task_id_tbl l_task_id_tbl_typ;

Line 2770: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;

2766: l_plsql_max_array_size NUMBER := 200;
2767:
2768: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2769: l_grouped_flag VARCHAR2(1); --indicates if resource_list is grouped
2770: l_group_resource_type_id pa_resource_lists.group_resource_type_id%TYPE;
2771:
2772: l_task_id_tbl l_task_id_tbl_typ;
2773: l_top_task_id_tbl l_top_task_id_tbl_typ;
2774: l_res_list_member_id_tbl l_res_list_mem_id_tbl_typ;

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 4544: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE

4540: PROCEDURE Add_resources_automatically
4541: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
4542: ,p_element_type IN pa_fp_elements.element_type%TYPE
4543: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
4544: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
4545: ,p_res_planning_level IN pa_proj_fp_options.cost_res_planning_level%TYPE
4546: ,p_entire_option IN VARCHAR2
4547: ,p_element_task_id_tbl IN pa_fp_elements_pub.l_task_id_tbl_typ
4548: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4563: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;

4559: l_task_tbl_index NUMBER;
4560: l_rlm_tbl_index NUMBER;
4561: l_res_uncategorized_flag VARCHAR2(1);
4562: l_is_resource_list_grouped VARCHAR2(1);
4563: l_group_resource_type_id pa_resource_lists_all_bg.group_resource_type_id%TYPE;
4564:
4565:
4566: /*
4567: The following pl/sql tables are used to store task_id, top_task_id,

Line 4617: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4613: 'UNCLASSIFIED' resource list member is filtered as that
4614: shouldn't be added to the option.
4615: */
4616: CURSOR ungrouped_res_cur
4617: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4618: IS
4619: SELECT resource_list_member_id
4620: FROM pa_resource_list_members
4621: WHERE resource_list_id = c_resource_list_id

Line 4633: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4629: is Resource.'UNCLASSIFIED' resource list member is filtered as that
4630: shouldn't be added to the option.
4631: */
4632: CURSOR grouped_res_level_res_cur
4633: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4634: IS
4635: SELECT resource_list_member_id
4636: FROM pa_resource_list_members
4637: WHERE resource_list_id = c_resource_list_id

Line 4650: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

4646: is Resource Group.'UNCLASSIFIED' resource list member is filtered as that
4647: shouldn't be added to the option.
4648: */
4649: CURSOR grouped_resgrp_level_res_cur
4650: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4651: IS
4652: SELECT resource_list_member_id
4653: FROM pa_resource_list_members
4654: WHERE resource_list_id = c_resource_list_id