[Home] [Help]
PACKAGE: APPS.PA_FP_EXCLUDED_ELEMENTS_PKG
Source
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 (
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
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
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
36 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37
38 PROCEDURE Lock_Row
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;