DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 3761: and migration_code to pa_resource_lists_all_bg */

3757: Adding Procedure Get_Resource_List_Info below.
3758: Please note that this proceedure is a overloaded procedure.
3759: The reason behind overloading this procedure below is the
3760: is the addiditon of three fields use_for_wp_flag,control_flag
3761: and migration_code to pa_resource_lists_all_bg */
3762: PROCEDURE Get_Resource_List_Info
3763: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3764: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3765: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3767: ,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

3763: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3764: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3765: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3766: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3767: ,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
3768: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3769: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3770: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3771: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

3764: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3765: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3766: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3767: ,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
3768: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3769: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3770: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3771: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3772: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

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

3765: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3766: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3767: ,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
3768: ,x_control_flag OUT NOCOPY pa_resource_lists_all_bg.control_flag%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3769: ,x_migration_code OUT NOCOPY pa_resource_lists_all_bg.migration_code%TYPE /*New Column added for FPM */ --File.Sql.39 bug 4440895
3770: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3771: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3772: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3773:

Line 3829: FROM pa_resource_lists_all_bg

3825: ,x_group_resource_type_id
3826: ,x_use_for_wp_flag
3827: ,x_control_flag
3828: ,x_migration_code
3829: FROM pa_resource_lists_all_bg
3830: WHERE resource_list_id = p_resource_list_id ;
3831:
3832: IF P_PA_DEBUG_MODE = 'Y' THEN
3833: pa_debug.reset_err_stack;

Line 3901: l_business_group_id pa_resource_lists_all_bg.business_group_id%TYPE; -- bug 2760675

3897: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3898: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3899:
3900: l_debug_mode VARCHAR2(30);
3901: l_business_group_id pa_resource_lists_all_bg.business_group_id%TYPE; -- bug 2760675
3902:
3903: BEGIN
3904:
3905: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3949: from pa_resource_lists_all_bg pbg,

3945: into x_resource_list_id,
3946: x_track_as_labor_flag,
3947: x_resource_list_member_id,
3948: x_unit_of_measure
3949: from pa_resource_lists_all_bg pbg,
3950: pa_resource_list_members prlm
3951: where pbg.business_group_id = l_business_group_id and -- bug 2760675 pa_utils.business_group_id and
3952: pbg.uncategorized_flag = 'Y' and
3953: prlm.resource_list_id = pbg.resource_list_id and

Line 3967: FROM pa_resource_lists_all_bg pbg

3963: INTO x_resource_list_id
3964: ,x_track_as_labor_flag
3965: ,x_resource_list_member_id
3966: ,x_unit_of_measure
3967: FROM pa_resource_lists_all_bg pbg
3968: ,pa_resource_list_members prlm
3969: ,pa_resources pr
3970: WHERE prlm.resource_list_id = pbg.resource_list_id
3971: AND pbg.resource_list_id = prlm.resource_list_id

Line 10938: pa_resource_lists_all_bg.resource_list_id%TYPE) RETURN VARCHAR2 IS

10934:
10935: FUNCTION is_wp_resource_list
10936: (p_project_id IN pa_projects_all.project_id%TYPE
10937: ,p_resource_list_id IN
10938: pa_resource_lists_all_bg.resource_list_id%TYPE) RETURN VARCHAR2 IS
10939: l_wp_resource_list_flag VARCHAR2(1);
10940: BEGIN
10941: BEGIN
10942: select 'Y'

Line 10963: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE)

10959: END is_wp_resource_list;
10960:
10961: FUNCTION is_fp_resource_list
10962: (p_project_id IN pa_projects_all.project_id%TYPE
10963: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE)
10964: RETURN VARCHAR2 IS
10965: l_fp_resource_list_flag VARCHAR2(1);
10966: BEGIN
10967: BEGIN