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_PLANNING_TRANSACTION_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

83: =======================================================================*/
84: PROCEDURE Get_Res_Class_Rlm_Ids
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
91: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

84: PROCEDURE Get_Res_Class_Rlm_Ids
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
91: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
92: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
91: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
92: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
93: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
91: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
92: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
93: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
94: IS

Line 108: FROM pa_resource_list_members,

104: --End of variables used for debugging
105:
106: CURSOR c_rlm_ids IS
107: SELECT resource_list_member_id, resource_class_code
108: FROM pa_resource_list_members,
109: (SELECT control_flag
110: FROM pa_resource_lists_all_bg
111: WHERE resource_list_id = p_resource_list_id) rl_control_flag
112: WHERE resource_list_id = p_resource_list_id