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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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