DBA Data[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;