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_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_FP_ELEMENTS

Line 12: ,p_from_element_type IN pa_fp_elements.element_type%TYPE

8: --them from those of p_from_proj_fp_options_id. If the project ids are different for the two
9: --options the records are mapped based on task numbers.
10: PROCEDURE Copy_Excluded_Elements
11: ( p_from_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
12: ,p_from_element_type IN pa_fp_elements.element_type%TYPE
13: ,p_to_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
14: ,p_to_element_type IN pa_fp_elements.element_type%TYPE
15: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 14: ,p_to_element_type IN pa_fp_elements.element_type%TYPE

10: PROCEDURE Copy_Excluded_Elements
11: ( p_from_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
12: ,p_from_element_type IN pa_fp_elements.element_type%TYPE
13: ,p_to_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
14: ,p_to_element_type IN pa_fp_elements.element_type%TYPE
15: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
18:

Line 261: ,p_element_type IN pa_fp_elements.element_type%TYPE

257: ==================================================================*/
258:
259: PROCEDURE Synchronize_Excluded_Elements
260: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
261: ,p_element_type IN pa_fp_elements.element_type%TYPE
262: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
263: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
264: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
265: AS

Line 316: FROM pa_fp_elements pfe

312: DELETE FROM pa_fp_excluded_elements fee
313: WHERE fee.proj_fp_options_id = p_proj_fp_options_id
314: AND fee.element_type = p_element_type
315: AND fee.task_id IN (SELECT pfe.task_id
316: FROM pa_fp_elements pfe
317: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id
318: AND pfe.element_type = p_element_type
319: AND pfe.plannable_flag = 'Y'
320: AND pfe.resource_list_member_id = 0);