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_FIN_PLAN_UTILS

Line 484: l_planning_level := PA_FIN_PLAN_UTILS.get_option_planning_level(p_to_proj_fp_options_id ,l_planning_level);

480: END IF;
481:
482: /* M20-AUG: replaced select with call to fin plan utils */
483:
484: l_planning_level := PA_FIN_PLAN_UTILS.get_option_planning_level(p_to_proj_fp_options_id ,l_planning_level);
485:
486: IF P_PA_DEBUG_MODE = 'Y' THEN
487: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': fetching auto res addition params from option.';
488: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);

Line 1060: l_planning_level := PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(p_proj_fp_options_id,p_element_type);

1056: have not been saved to the Database. */
1057: l_planning_level := p_planning_level;
1058: ELSE
1059:
1060: l_planning_level := PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(p_proj_fp_options_id,p_element_type);
1061: /* M20-AUG replaced by call
1062: SELECT decode(p_element_type,'COST',cost_fin_plan_level_code,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_fin_plan_level_code,
1063: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_fin_plan_level_code,NULL)
1064: INTO l_planning_level

Line 1152: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(

1148: */
1149:
1150: /* Fix for 2586647. Commented the above select. Replaced with the following call. */
1151:
1152: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(
1153: P_RESOURCE_LIST_ID => l_resource_list_id,
1154: X_RES_LIST_IS_UNCATEGORIZED => l_res_list_is_uncategorized,
1155: X_IS_RESOURCE_LIST_GROUPED => l_is_resource_list_grouped,
1156: X_GROUP_RESOURCE_TYPE_ID => l_group_resource_type_id,

Line 2268: PA_FIN_PLAN_UTILS.Get_Uncat_Resource_List_Info

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
2270: ,x_resource_list_member_id => l_uncat_rlmid
2271: ,x_track_as_labor_flag => l_track_as_labor_flag
2272: ,x_unit_of_measure => l_unit_of_measure

Line 2297: l_fp_level_code := pa_fin_plan_utils.get_fin_plan_level_code(

2293: END IF;
2294:
2295: --Fetching the finplan planning level
2296:
2297: l_fp_level_code := pa_fin_plan_utils.get_fin_plan_level_code(
2298: p_fin_plan_version_id => p_plan_version_id);
2299:
2300: /* #2615837: If the resources have been unchecked in the pages, then the elements are
2301: deleted from pa_fp_elements but not from resource_assignments. These records have

Line 2803: ,PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(c_proj_fp_options_id,c_element_type) fin_plan_level_code

2799: ,c_element_type IN pa_fp_elements.element_type%TYPE) IS
2800: SELECT project_id
2801: ,fin_plan_type_id
2802: ,fin_plan_version_id
2803: ,PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(c_proj_fp_options_id,c_element_type) fin_plan_level_code
2804: FROM pa_proj_fp_options
2805: WHERE proj_fp_options_id = c_proj_fp_options_id;
2806:
2807: fp_options_rec fp_options_cur%ROWTYPE;

Line 3046: pa_fin_plan_utils.get_resource_list_info(

3042: CLOSE fp_options_cur;
3043:
3044: --get resourcelist info regarding the categorization and grouping of resourcelist
3045:
3046: pa_fin_plan_utils.get_resource_list_info(
3047: p_resource_list_id => p_resource_list_id
3048: ,x_res_list_is_uncategorized => l_uncategorized_flag
3049: ,x_is_resource_list_grouped => l_grouped_flag
3050: ,x_group_resource_type_id => l_group_resource_type_id

Line 3482: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(

3478: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3479: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3480: END IF;
3481:
3482: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3483: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3484: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST);
3485:
3486: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */

Line 3502: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(

3498: ,x_msg_data => x_msg_data
3499: );
3500:
3501: ELSE /* Bug 2920954 */
3502: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(
3503: P_RESOURCE_LIST_ID => p_cost_resource_list_id,
3504: X_RES_LIST_IS_UNCATEGORIZED => l_res_list_is_uncategorized,
3505: X_IS_RESOURCE_LIST_GROUPED => l_is_resource_list_grouped,
3506: X_GROUP_RESOURCE_TYPE_ID => l_group_resource_type_id,

Line 3575: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(

3571: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3573: END IF;
3574:
3575: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3576: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3577: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE);
3578:
3579: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */

Line 3594: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(

3590: ,x_msg_count => x_msg_count
3591: ,x_msg_data => x_msg_data
3592: );
3593: ELSE /* Bug 2920954 */
3594: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(
3595: P_RESOURCE_LIST_ID => p_rev_resource_list_id,
3596: X_RES_LIST_IS_UNCATEGORIZED => l_res_list_is_uncategorized,
3597: X_IS_RESOURCE_LIST_GROUPED => l_is_resource_list_grouped,
3598: X_GROUP_RESOURCE_TYPE_ID => l_group_resource_type_id,

Line 3662: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(

3658: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3659: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3660: END IF;
3661:
3662: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3663: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3664: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL);
3665:
3666: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */

Line 3681: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(

3677: ,x_msg_count => x_msg_count
3678: ,x_msg_data => x_msg_data
3679: );
3680: ELSE /* Bug 2920954 */
3681: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO(
3682: P_RESOURCE_LIST_ID => p_all_resource_list_id,
3683: X_RES_LIST_IS_UNCATEGORIZED => l_res_list_is_uncategorized,
3684: X_IS_RESOURCE_LIST_GROUPED => l_is_resource_list_grouped,
3685: X_GROUP_RESOURCE_TYPE_ID => l_group_resource_type_id,

Line 4276: l_plan_version_planning_level := Pa_Fin_Plan_Utils.Get_Fin_Plan_Level_Code(

4272: END IF;
4273: RAISE;
4274: END;
4275:
4276: l_plan_version_planning_level := Pa_Fin_Plan_Utils.Get_Fin_Plan_Level_Code(
4277: p_fin_plan_version_id => p_budget_version_id);
4278:
4279: -- Fetch current working approved budget version id
4280: Pa_Fp_Control_Items_Utils.CHK_APRV_CUR_WORKING_BV_EXISTS(

Line 4830: call pa_fin_plan_utils.get_resource_list_info.

4826: END IF; -- entire option 'Y'/'N'
4827:
4828: /*
4829: To know if the given resource list id is grouped/ ungrouped
4830: call pa_fin_plan_utils.get_resource_list_info.
4831: */
4832:
4833: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO
4834: (

Line 4833: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO

4829: To know if the given resource list id is grouped/ ungrouped
4830: call pa_fin_plan_utils.get_resource_list_info.
4831: */
4832:
4833: PA_FIN_PLAN_UTILS.GET_RESOURCE_LIST_INFO
4834: (
4835: p_resource_list_id => p_resource_list_id
4836: ,x_res_list_is_uncategorized => l_res_uncategorized_flag
4837: ,x_is_resource_list_grouped => l_is_resource_list_grouped

Line 6601: l_option_exists := pa_fin_plan_utils.Check_Proj_Fp_Options_Exists(p_project_id => p_project_id);

6597: END IF;
6598:
6599: /* Checking if financial planning option have been setup for the task's project */
6600: /* commented for bug 3342975
6601: l_option_exists := pa_fin_plan_utils.Check_Proj_Fp_Options_Exists(p_project_id => p_project_id);
6602: start of bug 3342975
6603: */
6604: OPEN check_options_exists_cur;
6605: FETCH check_options_exists_cur

Line 6936: IF pa_fin_plan_utils.check_task_in_fp_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' THEN

6932: <> p_impacted_tasks_tbl(i).new_parent_task_id THEN
6933:
6934: /* Check if it exists in pa_fp_elements. If yes, then its a lowest task */
6935:
6936: IF pa_fin_plan_utils.check_task_in_fp_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' THEN
6937: /* Delete planning elements and resource assignments for new parent task id.
6938: Pls note that delete task elements deletes the task and its children from
6939: all plan options. Hence we cannot call it since it might delete a
6940: plannable impacted task also from pa_fp_elements and pa_resource_assignments */

Line 6983: END IF; /* pa_fin_plan_utils.task_exists_in_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' */

6979: END IF;
6980:
6981: l_tasks_removed_tbl(p_impacted_tasks_tbl(i).new_parent_task_id) := 'Y';
6982:
6983: END IF; /* pa_fin_plan_utils.task_exists_in_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' */
6984:
6985: END IF; /* pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)
6986: <> p_impacted_tasks_tbl(i).new_parent_task_id */
6987: