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_FIN_PLAN_UTILS dependencies on PA_RESOURCE_LISTS

Line 3638: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

3634: END enable_auto_baseline;
3635:
3636:
3637: PROCEDURE Get_Resource_List_Info
3638: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3639: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3640: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3641: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3642: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3641: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895

3637: PROCEDURE Get_Resource_List_Info
3638: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3639: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3640: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3641: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3642: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3643: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3644: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3645:

Line 3695: FROM pa_resource_lists

3691: ,group_resource_type_id
3692: INTO x_res_list_is_uncategorized
3693: ,x_is_resource_list_grouped
3694: ,x_group_resource_type_id
3695: FROM pa_resource_lists
3696: WHERE resource_list_id = p_resource_list_id ;
3697:
3698: IF P_PA_DEBUG_MODE = 'Y' THEN
3699: pa_debug.reset_err_stack;

Line 3763: and migration_code to pa_resource_lists_all_bg */

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

Line 3765: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

3761: The reason behind overloading this procedure below is the
3762: is the addiditon of three fields use_for_wp_flag,control_flag
3763: and migration_code to pa_resource_lists_all_bg */
3764: PROCEDURE Get_Resource_List_Info
3765: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
3766: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3767: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3768: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
3769: ,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

Line 3768: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895

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

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

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

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

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

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

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

Line 3831: FROM pa_resource_lists_all_bg

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

Line 3894: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895

3890: END Get_Resource_List_Info ;
3891:
3892: /* This api should be used only for budgets created using self-service. */
3893: PROCEDURE Get_Uncat_Resource_List_Info
3894: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895
3895: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895
3896: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895
3897: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895
3898: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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

Line 3951: from pa_resource_lists_all_bg pbg,

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

Line 3969: FROM pa_resource_lists_all_bg pbg

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

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

10940:
10941: FUNCTION is_wp_resource_list
10942: (p_project_id IN pa_projects_all.project_id%TYPE
10943: ,p_resource_list_id IN
10944: pa_resource_lists_all_bg.resource_list_id%TYPE) RETURN VARCHAR2 IS
10945: l_wp_resource_list_flag VARCHAR2(1);
10946: BEGIN
10947: BEGIN
10948: select 'Y'

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

10965: END is_wp_resource_list;
10966:
10967: FUNCTION is_fp_resource_list
10968: (p_project_id IN pa_projects_all.project_id%TYPE
10969: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE)
10970: RETURN VARCHAR2 IS
10971: l_fp_resource_list_flag VARCHAR2(1);
10972: BEGIN
10973: BEGIN