DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 387: and migration_code to pa_resource_lists_all_bg */

383: Adding Procedure Get_Resource_List_Info below.
384: Please note that this proceedure is a overloaded procedure.
385: The reason behind overloading this procedure below is the
386: is the addiditon of three fields use_for_wp_flag,control_flag
387: and migration_code to pa_resource_lists_all_bg */
388: PROCEDURE Get_Resource_List_Info
389: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
390: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
391: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 393: ,x_use_for_wp_flag OUT NOCOPY pa_resource_lists_all_bg.use_for_wp_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895

389: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
390: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
391: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
392: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
393: ,x_use_for_wp_flag OUT NOCOPY pa_resource_lists_all_bg.use_for_wp_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
394: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
395: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
396: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
397: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 394: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895

390: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
391: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
392: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
393: ,x_use_for_wp_flag OUT NOCOPY pa_resource_lists_all_bg.use_for_wp_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
394: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
395: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
396: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
397: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
398: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 395: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895

391: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
392: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
393: ,x_use_for_wp_flag OUT NOCOPY pa_resource_lists_all_bg.use_for_wp_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
394: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
395: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
396: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
397: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
398: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
399:

Line 877: pa_resource_lists_all_bg.resource_list_id%TYPE)

873: /* Used by Resource foundation team to know the resource lists used in WP */
874: FUNCTION is_wp_resource_list
875: (p_project_id IN pa_projects_all.project_id%TYPE
876: ,p_resource_list_id IN
877: pa_resource_lists_all_bg.resource_list_id%TYPE)
878: RETURN VARCHAR2;
879:
880: /* Used by Resource foundation team to know the resource lists used in FP */
881: FUNCTION is_fp_resource_list

Line 884: pa_resource_lists_all_bg.resource_list_id%TYPE)

880: /* Used by Resource foundation team to know the resource lists used in FP */
881: FUNCTION is_fp_resource_list
882: (p_project_id IN pa_projects_all.project_id%TYPE
883: ,p_resource_list_id IN
884: pa_resource_lists_all_bg.resource_list_id%TYPE)
885: RETURN VARCHAR2;
886:
887: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project