DBA Data[Home] [Help]

APPS.PA_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 11: ( p_from_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

7: --This api will creates record for p_to_proj_fp_options_id in pa_fp_excluded_elements copying
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

Line 13: ,p_to_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

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
17: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 20: (c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)

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:
19: CURSOR fp_options_info_cur
20: (c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
21: IS
22: SELECT project_id
23: ,fin_plan_type_id
24: ,fin_plan_version_id

Line 25: FROM pa_proj_fp_options

21: IS
22: SELECT project_id
23: ,fin_plan_type_id
24: ,fin_plan_version_id
25: FROM pa_proj_fp_options
26: WHERE proj_fp_options_id = c_proj_fp_options_id;
27: l_from_fp_option_info_rec fp_options_info_cur%ROWTYPE;
28: l_to_fp_option_info_rec fp_options_info_cur%ROWTYPE;
29:

Line 260: ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE

256: while copying actuals etc., from pa_fp_excluded_elements.
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