DBA Data[Home] [Help]

APPS.PA_FP_ADJ_ELEMENTS_PKG dependencies on PA_FP_ADJ_ELEMENTS

Line 1: PACKAGE pa_fp_adj_elements_pkg as

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 :

Line 4: -- Package name : pa_fp_adj_elements_pkg

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

Line 11: ( px_adj_element_id IN OUT NOCOPY pa_fp_adj_elements.adj_element_id%TYPE --File.Sql.39 bug 4440895

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

Line 12: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE

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

Line 14: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE

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

Line 16: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE

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

Line 18: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE

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

Line 20: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE

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

Line 22: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE

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:

Line 28: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE

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

Line 30: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE

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

Line 32: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE

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

Line 34: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE

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

Line 36: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE

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

Line 38: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE

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

Line 40: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE

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

Line 47: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE

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

Line 54: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE

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

Line 59: End pa_fp_adj_elements_pkg;

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;