DBA Data[Home] [Help]

APPS.PA_ORG_FCST_ELEMENTS_PKG dependencies on PA_ORG_FCST_ELEMENTS

Line 1: PACKAGE pa_org_fcst_elements_pkg AUTHID CURRENT_USER as

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 :

Line 4: -- Package name : pa_org_fcst_elements_pkg

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

Line 11: ( px_forecast_element_id IN OUT NOCOPY pa_org_fcst_elements.forecast_element_id%TYPE --File.Sql.39 bug 4440895

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

Line 12: ,p_organization_id IN pa_org_fcst_elements.organization_id%TYPE

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

Line 14: ,p_budget_version_id IN pa_org_fcst_elements.budget_version_id%TYPE

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

Line 16: ,p_project_id IN pa_org_fcst_elements.project_id%TYPE

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

Line 18: ,p_task_id IN pa_org_fcst_elements.task_id%TYPE

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

Line 20: ,p_provider_receiver_code IN pa_org_fcst_elements.provider_receiver_code%TYPE

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

Line 22: ,p_other_organization_id IN pa_org_fcst_elements.other_organization_id%TYPE

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

Line 24: ,p_txn_project_id IN pa_org_fcst_elements.txn_project_id%TYPE

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

Line 26: ,p_assignment_id IN pa_org_fcst_elements.assignment_id%TYPE

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

Line 28: ,p_resource_id IN pa_org_fcst_elements.resource_id%TYPE

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:

Line 34: ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE

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

Line 38: ,p_organization_id IN pa_org_fcst_elements.organization_id%TYPE

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

Line 40: ,p_budget_version_id IN pa_org_fcst_elements.budget_version_id%TYPE

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

Line 42: ,p_project_id IN pa_org_fcst_elements.project_id%TYPE

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

Line 44: ,p_task_id IN pa_org_fcst_elements.task_id%TYPE

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

Line 46: ,p_provider_receiver_code IN pa_org_fcst_elements.provider_receiver_code%TYPE

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

Line 48: ,p_other_organization_id IN pa_org_fcst_elements.other_organization_id%TYPE

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

Line 50: ,p_txn_project_id IN pa_org_fcst_elements.txn_project_id%TYPE

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

Line 52: ,p_assignment_id IN pa_org_fcst_elements.assignment_id%TYPE

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

Line 54: ,p_resource_id IN pa_org_fcst_elements.resource_id%TYPE

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

Line 61: ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE

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

Line 70: ( p_forecast_element_id IN pa_org_fcst_elements.forecast_element_id%TYPE

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

Line 77: End pa_org_fcst_elements_pkg;

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;