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 373: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

369: (p_project_id IN pa_projects_all.project_id%TYPE)
370: return VARCHAR2;
371:
372: PROCEDURE Get_Resource_List_Info
373: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
374: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
375: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
376: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
377: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

372: PROCEDURE Get_Resource_List_Info
373: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
374: ,x_res_list_is_uncategorized OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
375: ,x_is_resource_list_grouped OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
376: ,x_group_resource_type_id OUT NOCOPY pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE --File.Sql.39 bug 4440895
377: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
378: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
379: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
380:

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 389: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

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
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

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

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
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

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 402: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895

398: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
399:
400:
401: PROCEDURE Get_Uncat_Resource_List_Info
402: (x_resource_list_id OUT NOCOPY pa_resource_lists.RESOURCE_LIST_ID%TYPE --File.Sql.39 bug 4440895
403: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE --File.Sql.39 bug 4440895
404: ,x_track_as_labor_flag OUT NOCOPY pa_resource_list_members.TRACK_AS_LABOR_FLAG%TYPE --File.Sql.39 bug 4440895
405: ,x_unit_of_measure OUT NOCOPY pa_resources.UNIT_OF_MEASURE%TYPE --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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