[Home] [Help]
PACKAGE: APPS.CE_FORECAST_COLUMNS_PKG
Source
1 PACKAGE CE_FORECAST_COLUMNS_PKG as
2 /* $Header: cefcols.pls 120.1 2002/11/12 21:20:11 bhchung ship $ */
3 --
4 -- Package
5 -- CE_FORECAST_COLUMNS_PKG
6 -- Purpose
7 -- To group all the procedures/functions for table handling of the
8 -- ce_forecast_columns table.
9 -- History
10 -- 07.10.96 C. Kawamoto Created
11 --
12 G_spec_revision VARCHAR2(1000) := '$Revision: 120.1 $';
13
14 FUNCTION spec_revision RETURN VARCHAR2;
15
16 FUNCTION body_revision RETURN VARCHAR2;
17
18 --
19 -- Procedure
20 -- Check_Unique
21 -- Purpose
22 -- Checks the uniqueness of the forecast column inserted.
23 -- History
24 -- 07.10.96 C. Kawamoto Created
25 -- Example
26 -- CE_FORECAST_COLUMNS_PKG.Check_Unique(...);
27 -- Notes
28 --
29 PROCEDURE Check_Unique(
30 X_rowid VARCHAR2,
31 X_forecast_header_id NUMBER,
32 X_column_number NUMBER);
33
34 --
35 -- Procedure
36 -- Check_Unique_Aigng
37 -- Purpose
38 -- Checks the uniqueness of the forecast column aging inserted.
39 -- History
40 -- 07.10.96 C. Kawamoto Created
41 -- Example
42 -- CE_FORECAST_COLUMNS_PKG.Check_Unique_Aging(...);
43 -- Notes
44 --
45 PROCEDURE Check_Unique_Aging(
46 X_rowid VARCHAR2,
47 X_forecast_header_id NUMBER,
48 X_days_from NUMBER,
49 X_days_to NUMBER);
50
51 --
52 -- Procedure
53 -- insert_row
54 -- Purpose
55 -- To insert new row to ce_forecast_columns.
56 -- History
57 -- 07.10.96 C. Kawamoto Created
58 -- Example
59 -- CE_FORECAST_COLUMNS_PKG.Insert_Row(...)
60 -- Notes
61 --
62
63 PROCEDURE Insert_Row(
64 X_rowid IN OUT NOCOPY VARCHAR2,
65 X_forecast_column_id IN OUT NOCOPY NUMBER,
66 X_forecast_header_id NUMBER,
67 X_column_number NUMBER,
68 X_days_from NUMBER,
69 X_days_to NUMBER,
70 X_developer_column_num NUMBER,
71 X_created_by NUMBER,
72 X_creation_date DATE,
73 X_last_updated_by NUMBER,
74 X_last_update_date DATE,
75 X_last_update_login NUMBER,
76 X_attribute_category VARCHAR2,
77 X_attribute1 VARCHAR2,
78 X_attribute2 VARCHAR2,
79 X_attribute3 VARCHAR2,
80 X_attribute4 VARCHAR2,
81 X_attribute5 VARCHAR2,
82 X_attribute6 VARCHAR2,
83 X_attribute7 VARCHAR2,
84 X_attribute8 VARCHAR2,
85 X_attribute9 VARCHAR2,
86 X_attribute10 VARCHAR2,
87 X_attribute11 VARCHAR2,
88 X_attribute12 VARCHAR2,
89 X_attribute13 VARCHAR2,
90 X_attribute14 VARCHAR2,
91 X_attribute15 VARCHAR2);
92
93 --
94 -- Procedure
95 -- lock_row
96 -- Purpose
97 -- To lock a row from ce_forecast_columns.
98 -- History
99 -- 07.10.96 C. Kawamoto Created
100 -- Example
101 -- CE_FORECAST_COLUMNS_PKG.Lock_Row(...)
102 -- Notes
103 --
104
105
106 PROCEDURE Lock_Row(
107 X_rowid VARCHAR2,
108 X_forecast_column_id NUMBER,
109 X_forecast_header_id NUMBER,
110 X_column_number NUMBER,
111 X_days_from NUMBER,
112 X_days_to NUMBER,
113 X_developer_column_num NUMBER,
114 X_created_by NUMBER,
115 X_creation_date DATE,
116 X_last_updated_by NUMBER,
117 X_last_update_date DATE,
118 X_last_update_login NUMBER,
119 X_attribute_category VARCHAR2,
120 X_attribute1 VARCHAR2,
121 X_attribute2 VARCHAR2,
122 X_attribute3 VARCHAR2,
123 X_attribute4 VARCHAR2,
124 X_attribute5 VARCHAR2,
125 X_attribute6 VARCHAR2,
126 X_attribute7 VARCHAR2,
127 X_attribute8 VARCHAR2,
128 X_attribute9 VARCHAR2,
129 X_attribute10 VARCHAR2,
130 X_attribute11 VARCHAR2,
131 X_attribute12 VARCHAR2,
132 X_attribute13 VARCHAR2,
133 X_attribute14 VARCHAR2,
134 X_attribute15 VARCHAR2);
135
136 --
137 -- Procedure
138 -- Update_Row
139 -- Purpose
140 -- To update ce_forecast_columns with changes made.
141 -- History
142 -- 07.10.96 C. Kawamoto Created
143 -- Example
144 -- CE_FORECAST_COLUMNS_PKG.Update_Row(...);
145 -- Notes
146 --
147 PROCEDURE Update_Row(
148 X_rowid VARCHAR2,
149 X_forecast_column_id NUMBER,
150 X_forecast_header_id NUMBER,
151 X_column_number NUMBER,
152 X_days_from NUMBER,
153 X_days_to NUMBER,
154 X_developer_column_num NUMBER,
155 X_created_by NUMBER,
156 X_creation_date DATE,
157 X_last_updated_by NUMBER,
158 X_last_update_date DATE,
159 X_last_update_login NUMBER,
160 X_attribute_category VARCHAR2,
161 X_attribute1 VARCHAR2,
162 X_attribute2 VARCHAR2,
163 X_attribute3 VARCHAR2,
164 X_attribute4 VARCHAR2,
165 X_attribute5 VARCHAR2,
166 X_attribute6 VARCHAR2,
167 X_attribute7 VARCHAR2,
168 X_attribute8 VARCHAR2,
169 X_attribute9 VARCHAR2,
170 X_attribute10 VARCHAR2,
171 X_attribute11 VARCHAR2,
172 X_attribute12 VARCHAR2,
173 X_attribute13 VARCHAR2,
174 X_attribute14 VARCHAR2,
175 X_attribute15 VARCHAR2);
176
177 --
178 -- Procedure
179 -- Delete_Row
180 -- Purpose
181 -- To delete a row from ce_forecast_columns.
182 -- History
183 -- 07.10.96 C. Kawamoto Created
184 -- Example
185 -- CE_FORECAST_COLUMNS_PKG.Delete_Row(...);
186 -- Notes
187 --
188 PROCEDURE Delete_Row(X_rowid VARCHAR2);
189
190 --
191 -- Procedure
192 -- Delete_Forecast_Cells
193 -- Purpose
194 -- To delete all forecast cells belonging the forecast template column
195 -- History
196 -- 07.10.96 C. Kawamoto Created
197 -- Example
198 -- CE_FORECAST_COLUMNS_PKG.Delete_Forecast_Cells(...)
199 -- Notes
200 --
201 PROCEDURE Delete_Forecast_Cells(X_rowid VARCHAR2);
202
203
204 END CE_FORECAST_COLUMNS_PKG;