1: PACKAGE pa_fp_excluded_elements_pkg AUTHID CURRENT_USER as
2: /* $Header: PAFPXELS.pls 120.1 2005/08/19 16:32:11 mwasowic noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPEXLS.pls';
1: PACKAGE pa_fp_excluded_elements_pkg AUTHID CURRENT_USER as
2: /* $Header: PAFPXELS.pls 120.1 2005/08/19 16:32:11 mwasowic noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPEXLS.pls';
6:
7: PROCEDURE Insert_Row
8: (
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PAFPEXLS.pls';
6:
7: PROCEDURE Insert_Row
8: (
9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
6:
7: PROCEDURE Insert_Row
8: (
9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
14: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
7: PROCEDURE Insert_Row
8: (
9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
14: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
15: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
8: (
9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
14: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
15: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
16: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
14: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
15: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
16: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
17:
10: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
14: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
15: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
16: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
17:
18: PROCEDURE Update_Row
16: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
17:
18: PROCEDURE Update_Row
19: (
20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
17:
18: PROCEDURE Update_Row
19: (
20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
18: PROCEDURE Update_Row
19: (
20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%TYPE := Null
19: (
20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%TYPE := Null
27: ,p_row_id IN ROWID := Null
20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%TYPE := Null
27: ,p_row_id IN ROWID := Null
28: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
21: ,p_project_id IN pa_fp_excluded_elements.project_id%TYPE := Null
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%TYPE := Null
27: ,p_row_id IN ROWID := Null
28: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29:
22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_id%TYPE := Null
23: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null
25: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%TYPE := Null
27: ,p_row_id IN ROWID := Null
28: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29:
30: PROCEDURE Delete_Row
27: ,p_row_id IN ROWID := Null
28: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29:
30: PROCEDURE Delete_Row
31: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
32: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
33: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
34: ,p_row_id IN ROWID
35: ,p_record_version_number IN NUMBER := Null
28: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29:
30: PROCEDURE Delete_Row
31: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
32: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
33: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
34: ,p_row_id IN ROWID
35: ,p_record_version_number IN NUMBER := Null
36: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
29:
30: PROCEDURE Delete_Row
31: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null
32: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null
33: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null
34: ,p_row_id IN ROWID
35: ,p_record_version_number IN NUMBER := Null
36: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37:
39: ( p_row_id IN ROWID
40: ,p_record_version_number IN NUMBER := Null
41: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
42:
43: END pa_fp_excluded_elements_pkg;