DBA Data[Home] [Help]

APPS.PA_FP_EXCLUDED_ELEMENTS_PKG dependencies on PA_FP_EXCLUDED_ELEMENTS

Line 1: PACKAGE pa_fp_excluded_elements_pkg as

1: PACKAGE pa_fp_excluded_elements_pkg 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';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_FP_EXCLUDED_ELEMENTS_PKG';

1: PACKAGE pa_fp_excluded_elements_pkg 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: (

Line 9: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null

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

Line 10: ,p_project_id IN pa_fp_excluded_elements.project_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

Line 11: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_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

Line 12: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := Null

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

Line 13: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := Null

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:

Line 14: ,p_task_id IN pa_fp_excluded_elements.task_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:
18: PROCEDURE Update_Row

Line 20: p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%TYPE := Null

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

Line 21: ,p_project_id IN pa_fp_excluded_elements.project_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

Line 22: ,p_fin_plan_type_id IN pa_fp_excluded_elements.fin_plan_type_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

Line 23: ,p_element_type IN pa_fp_excluded_elements.element_type%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

Line 24: ,p_fin_plan_version_id IN pa_fp_excluded_elements.fin_plan_version_id%TYPE := 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

Line 25: ,p_task_id IN pa_fp_excluded_elements.task_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
29:

Line 26: ,p_record_version_number IN pa_fp_excluded_elements.record_version_number%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:
30: PROCEDURE Delete_Row

Line 31: ( p_proj_fp_options_id IN pa_fp_excluded_elements.proj_fp_options_id%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
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

Line 32: ,p_element_type IN pa_fp_excluded_elements.element_type%TYPE := 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

Line 33: ,p_task_id IN pa_fp_excluded_elements.task_id%TYPE := Null

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:

Line 43: END pa_fp_excluded_elements_pkg;

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;