[Home] [Help]
PACKAGE: APPS.PA_ORG_FCST_ELEMENTS_PKG
Source
1 PACKAGE pa_org_fcst_elements_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPFETS.pls 120.1 2005/08/19 16:26:37 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : pa_org_fcst_elements_pkg
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row
11 ( px_forecast_element_id IN OUT NOCOPY pa_org_fcst_elements.forecast_element_id%TYPE --File.Sql.39 bug 4440895
12 ,p_organization_id IN pa_org_fcst_elements.organization_id%TYPE
13 := FND_API.G_MISS_NUM
14 ,p_budget_version_id IN pa_org_fcst_elements.budget_version_id%TYPE
15 := FND_API.G_MISS_NUM
16 ,p_project_id IN pa_org_fcst_elements.project_id%TYPE
17 := FND_API.G_MISS_NUM
18 ,p_task_id IN pa_org_fcst_elements.task_id%TYPE
19 := FND_API.G_MISS_NUM
20 ,p_provider_receiver_code IN pa_org_fcst_elements.provider_receiver_code%TYPE
21 := FND_API.G_MISS_CHAR
22 ,p_other_organization_id IN pa_org_fcst_elements.other_organization_id%TYPE
23 := FND_API.G_MISS_NUM
24 ,p_txn_project_id IN pa_org_fcst_elements.txn_project_id%TYPE
25 := FND_API.G_MISS_NUM
26 ,p_assignment_id IN pa_org_fcst_elements.assignment_id%TYPE
27 := FND_API.G_MISS_NUM
28 ,p_resource_id IN pa_org_fcst_elements.resource_id%TYPE
29 := FND_API.G_MISS_NUM
30 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
31 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32
33 PROCEDURE Update_Row
34 ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE
35 := FND_API.G_MISS_NUM
36 ,p_record_version_number IN NUMBER
37 := NULL
38 ,p_organization_id IN pa_org_fcst_elements.organization_id%TYPE
39 := FND_API.G_MISS_NUM
40 ,p_budget_version_id IN pa_org_fcst_elements.budget_version_id%TYPE
41 := FND_API.G_MISS_NUM
42 ,p_project_id IN pa_org_fcst_elements.project_id%TYPE
43 := FND_API.G_MISS_NUM
44 ,p_task_id IN pa_org_fcst_elements.task_id%TYPE
45 := FND_API.G_MISS_NUM
46 ,p_provider_receiver_code IN pa_org_fcst_elements.provider_receiver_code%TYPE
47 := FND_API.G_MISS_CHAR
48 ,p_other_organization_id IN pa_org_fcst_elements.other_organization_id%TYPE
49 := FND_API.G_MISS_NUM
50 ,p_txn_project_id IN pa_org_fcst_elements.txn_project_id%TYPE
51 := FND_API.G_MISS_NUM
52 ,p_assignment_id IN pa_org_fcst_elements.assignment_id%TYPE
53 := FND_API.G_MISS_NUM
54 ,p_resource_id IN pa_org_fcst_elements.resource_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
60 PROCEDURE Lock_Row
61 ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE
62 := FND_API.G_MISS_NUM
63 ,p_record_version_number IN NUMBER
64 := NULL
65 ,p_row_id IN ROWID
66 := NULL
67 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
68
69 PROCEDURE Delete_Row
70 ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE
71 := FND_API.G_MISS_NUM
72 ,p_record_version_number IN NUMBER
73 := NULL
74 ,p_row_id IN ROWID
75 := NULL
76 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
77 End pa_org_fcst_elements_pkg;