[Home] [Help]
PACKAGE: APPS.PA_FP_ADJ_ELEMENTS_PKG
Source
1 PACKAGE pa_fp_adj_elements_pkg as
2 /* $Header: PAFPAETS.pls 120.1 2005/08/19 16:23:53 mwasowic noship $*/
3 -- Start of Comments
4 -- Package name : pa_fp_adj_elements_pkg
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row
11 ( px_adj_element_id IN OUT NOCOPY pa_fp_adj_elements.adj_element_id%TYPE --File.Sql.39 bug 4440895
12 ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
13 := FND_API.G_MISS_NUM
14 ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
15 := FND_API.G_MISS_NUM
16 ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
17 := FND_API.G_MISS_NUM
18 ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
19 := FND_API.G_MISS_NUM
20 ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
21 := FND_API.G_MISS_CHAR
22 ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
23 := FND_API.G_MISS_CHAR
24 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
25 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
26
27 PROCEDURE Update_Row
28 ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
29 := FND_API.G_MISS_NUM
30 ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
31 := FND_API.G_MISS_NUM
32 ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
33 := FND_API.G_MISS_NUM
34 ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
35 := FND_API.G_MISS_NUM
36 ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
37 := FND_API.G_MISS_NUM
38 ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
39 := FND_API.G_MISS_CHAR
40 ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
41 := FND_API.G_MISS_CHAR
42 ,p_row_id IN ROWID
43 := NULL
44 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
45
46 PROCEDURE Lock_Row
47 ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
48 := FND_API.G_MISS_NUM
49 ,p_row_id IN ROWID
50 := NULL
51 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
52
53 PROCEDURE Delete_Row
54 ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
55 := FND_API.G_MISS_NUM
56 ,p_row_id IN ROWID
57 := NULL
58 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
59 End pa_fp_adj_elements_pkg;