[Home] [Help]
PACKAGE: APPS.PA_FP_ORG_FORECAST_LINES_PKG
Source
1 PACKAGE pa_fp_org_forecast_lines_pkg as
2 /* $Header: PAFPFLTS.pls 120.1 2005/08/19 16:26:45 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : PA_FP_ORG_FORECAST_LINES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row
11 ( px_forecast_line_id IN OUT NOCOPY pa_org_forecast_lines.forecast_line_id%TYPE --File.Sql.39 bug 4440895
12 ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
13 := FND_API.G_MISS_NUM
14 ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
15 := FND_API.G_MISS_NUM
16 ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
17 := FND_API.G_MISS_NUM
18 ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
19 := FND_API.G_MISS_NUM
20 ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
21 := FND_API.G_MISS_CHAR
22 ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
23 := FND_API.G_MISS_DATE
24 ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
25 := FND_API.G_MISS_DATE
26 ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
27 := FND_API.G_MISS_NUM
28 ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
29 := FND_API.G_MISS_NUM
30 ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
31 := FND_API.G_MISS_NUM
32 ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
33 := FND_API.G_MISS_NUM
34 ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
35 := FND_API.G_MISS_NUM
36 ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
37 := FND_API.G_MISS_NUM
38 ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
39 := FND_API.G_MISS_NUM
40 ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
41 := FND_API.G_MISS_NUM
42 ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
43 := FND_API.G_MISS_NUM
44 ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
45 := FND_API.G_MISS_NUM
46 ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
47 := FND_API.G_MISS_NUM
48 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
49 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
50
51 PROCEDURE Update_Row
52 ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
53 := FND_API.G_MISS_NUM
54 ,p_record_version_number IN NUMBER
55 := NULL
56 ,p_forecast_element_id IN pa_org_forecast_lines.forecast_element_id%TYPE
57 := FND_API.G_MISS_NUM
58 ,p_budget_version_id IN pa_org_forecast_lines.budget_version_id%TYPE
59 := FND_API.G_MISS_NUM
60 ,p_project_id IN pa_org_forecast_lines.project_id%TYPE
61 := FND_API.G_MISS_NUM
62 ,p_task_id IN pa_org_forecast_lines.task_id%TYPE
63 := FND_API.G_MISS_NUM
64 ,p_period_name IN pa_org_forecast_lines.period_name%TYPE
65 := FND_API.G_MISS_CHAR
66 ,p_start_date IN pa_org_forecast_lines.start_date%TYPE
67 := FND_API.G_MISS_DATE
68 ,p_end_date IN pa_org_forecast_lines.end_date%TYPE
69 := FND_API.G_MISS_DATE
70 ,p_quantity IN pa_org_forecast_lines.quantity%TYPE
71 := FND_API.G_MISS_NUM
72 ,p_raw_cost IN pa_org_forecast_lines.raw_cost%TYPE
73 := FND_API.G_MISS_NUM
74 ,p_burdened_cost IN pa_org_forecast_lines.burdened_cost%TYPE
75 := FND_API.G_MISS_NUM
76 ,p_tp_cost_in IN pa_org_forecast_lines.tp_cost_in%TYPE
77 := FND_API.G_MISS_NUM
78 ,p_tp_cost_out IN pa_org_forecast_lines.tp_cost_out%TYPE
79 := FND_API.G_MISS_NUM
80 ,p_revenue IN pa_org_forecast_lines.revenue%TYPE
81 := FND_API.G_MISS_NUM
82 ,p_tp_revenue_in IN pa_org_forecast_lines.tp_revenue_in%TYPE
83 := FND_API.G_MISS_NUM
84 ,p_tp_revenue_out IN pa_org_forecast_lines.tp_revenue_out%TYPE
85 := FND_API.G_MISS_NUM
86 ,p_borrowed_revenue IN pa_org_forecast_lines.borrowed_revenue%TYPE
87 := FND_API.G_MISS_NUM
88 ,p_lent_resource_cost IN pa_org_forecast_lines.lent_resource_cost%TYPE
89 := FND_API.G_MISS_NUM
90 ,p_unassigned_time_cost IN pa_org_forecast_lines.unassigned_time_cost%TYPE
91 := FND_API.G_MISS_NUM
92 ,p_row_id IN ROWID
93 := NULL
94 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
95
96 PROCEDURE Lock_Row
97 ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
98 := FND_API.G_MISS_NUM
99 ,p_record_version_number IN NUMBER
100 := NULL
101 ,p_row_id IN ROWID
102 := NULL
103 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
104
105 PROCEDURE Delete_Row
106 ( p_forecast_line_id IN pa_org_forecast_lines.forecast_line_id%TYPE
107 := FND_API.G_MISS_NUM
108 ,p_record_version_number IN NUMBER
109 := NULL
110 ,p_row_id IN ROWID
111 := NULL
112 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
113 END pa_fp_org_forecast_lines_pkg;