1 PACKAGE BOM_ALTERNATE_DESIGNATORS_PKG AUTHID CURRENT_USER as
2 /* $Header: bompbads.pls 120.3 2007/02/27 10:44:09 vhymavat ship $ */
3
4 PROCEDURE Check_Unique(X_Organization_Id NUMBER,
5 X_Alternate_Designator_Code VARCHAR2);
6
7
8 PROCEDURE Check_References(X_Organization_Id NUMBER,
9 X_Alternate_Designator_Code VARCHAR2);
10
11 FUNCTION Check_References_wrapper(X_Organization_Id NUMBER,
12 X_Alternate_Designator_Code VARCHAR2)
13 RETURN VARCHAR2 ;
14
15 -------------------------------
16 -- Alternate Designator APIs --
17 -------------------------------
18
19 PROCEDURE Insert_Row (
20 p_api_version IN NUMBER
21 ,p_alt_desig_code IN VARCHAR2
22 ,p_organization_id IN NUMBER
23 ,p_description IN VARCHAR2
24 ,p_disable_date IN DATE
25 ,p_structure_type_id IN NUMBER
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_errorcode OUT NOCOPY NUMBER
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY VARCHAR2);
30
31 PROCEDURE Update_Row (
32 p_api_version IN NUMBER
33 ,p_alt_desig_code_old IN VARCHAR2
34 ,p_organization_id IN NUMBER
35 ,p_alt_desig_code_new IN VARCHAR2
36 ,p_description IN VARCHAR2
37 ,p_disable_date IN DATE
38 ,p_structure_type_id IN NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_errorcode OUT NOCOPY NUMBER
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2);
43
44 PROCEDURE Delete_Row (
45 p_api_version IN NUMBER
46 ,p_alt_desig_code IN VARCHAR2
47 ,p_from_struct_alt_page IN VARCHAR2 DEFAULT 'N'
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_errorcode OUT NOCOPY NUMBER
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2);
52
53 PROCEDURE Delete_Row (
54 p_api_version IN NUMBER
55 ,p_alt_desig_code IN VARCHAR2
56 ,p_organization_id IN NUMBER
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_errorcode OUT NOCOPY NUMBER
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2);
61
62 PROCEDURE Create_Association(
63 p_api_version IN NUMBER
64 -- ,p_organization_id IN NUMBER
65 ,p_alternate_designator_code IN VARCHAR2
66 ,p_structure_type_id IN NUMBER
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_errorcode OUT NOCOPY NUMBER
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE Add_Language;
74
75 PROCEDURE Insert_Row (
76 p_api_version IN NUMBER
77 ,p_alt_desig_code IN VARCHAR2
78 ,p_organization_id IN NUMBER
79 ,p_display_name IN VARCHAR2
80 ,p_description IN VARCHAR2
81 ,p_disable_date IN DATE
82 ,p_structure_type_id IN NUMBER
83 ,p_is_preferred IN VARCHAR2
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_errorcode OUT NOCOPY NUMBER
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2);
88
89 PROCEDURE Update_Row (
90 p_api_version IN NUMBER
91 ,p_alt_desig_code_old IN VARCHAR2
92 ,p_organization_id IN NUMBER
93 ,p_alt_desig_code_new IN VARCHAR2
94 ,p_display_name_new IN VARCHAR2
95 ,p_description IN VARCHAR2
96 ,p_disable_date IN DATE
97 ,p_structure_type_id IN NUMBER
98 ,p_is_preferred IN VARCHAR2
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_errorcode OUT NOCOPY NUMBER
101 ,x_msg_count OUT NOCOPY NUMBER
102 ,x_msg_data OUT NOCOPY VARCHAR2);
103
104 ---- For forms ----
105
106 procedure INSERT_ROW ( --- called by forms
107 P_ALTERNATE_DESIGNATOR_CODE in VARCHAR2,
108 P_ORGANIZATION_ID in NUMBER,
109 P_STRUCTURE_TYPE_ID in NUMBER,
110 P_DISABLE_DATE in DATE,
111 P_ATTRIBUTE_CATEGORY in VARCHAR2,
112 P_ATTRIBUTE1 in VARCHAR2,
113 P_ATTRIBUTE2 in VARCHAR2,
114 P_ATTRIBUTE3 in VARCHAR2,
115 P_ATTRIBUTE4 in VARCHAR2,
116 P_ATTRIBUTE5 in VARCHAR2,
117 P_ATTRIBUTE6 in VARCHAR2,
118 P_ATTRIBUTE7 in VARCHAR2,
119 P_ATTRIBUTE8 in VARCHAR2,
120 P_ATTRIBUTE9 in VARCHAR2,
121 P_ATTRIBUTE10 in VARCHAR2,
122 P_ATTRIBUTE11 in VARCHAR2,
123 P_ATTRIBUTE12 in VARCHAR2,
124 P_ATTRIBUTE13 in VARCHAR2,
125 P_ATTRIBUTE14 in VARCHAR2,
126 P_ATTRIBUTE15 in VARCHAR2,
127 P_REQUEST_ID in NUMBER,
128 P_DISPLAY_NAME in VARCHAR2,
129 P_DESCRIPTION in VARCHAR2,
130 P_CREATION_DATE in DATE,
131 P_CREATED_BY in NUMBER,
132 P_LAST_UPDATE_DATE in DATE,
133 P_LAST_UPDATED_BY in NUMBER,
134 P_LAST_UPDATE_LOGIN in NUMBER);
135
136 procedure LOCK_ROW (
137 P_ALTERNATE_DESIGNATOR_CODE in VARCHAR2,
138 P_ORGANIZATION_ID in NUMBER,
139 P_STRUCTURE_TYPE_ID in NUMBER,
140 P_DISABLE_DATE in DATE,
141 P_ATTRIBUTE_CATEGORY in VARCHAR2,
142 P_ATTRIBUTE1 in VARCHAR2,
143 P_ATTRIBUTE2 in VARCHAR2,
144 P_ATTRIBUTE3 in VARCHAR2,
145 P_ATTRIBUTE4 in VARCHAR2,
146 P_ATTRIBUTE5 in VARCHAR2,
147 P_ATTRIBUTE6 in VARCHAR2,
148 P_ATTRIBUTE7 in VARCHAR2,
149 P_ATTRIBUTE8 in VARCHAR2,
150 P_ATTRIBUTE9 in VARCHAR2,
151 P_ATTRIBUTE10 in VARCHAR2,
152 P_ATTRIBUTE11 in VARCHAR2,
153 P_ATTRIBUTE12 in VARCHAR2,
154 P_ATTRIBUTE13 in VARCHAR2,
155 P_ATTRIBUTE14 in VARCHAR2,
156 P_ATTRIBUTE15 in VARCHAR2,
157 P_REQUEST_ID in NUMBER,
158 -- P_DISPLAY_NAME in VARCHAR2,
159 P_DESCRIPTION in VARCHAR2
160 );
161
162 procedure UPDATE_ROW ( --- called by forms
163 P_ALTERNATE_DESIGNATOR_CODE in VARCHAR2,
164 P_ORGANIZATION_ID in NUMBER,
165 P_STRUCTURE_TYPE_ID in NUMBER,
166 P_DISABLE_DATE in DATE,
167 P_ATTRIBUTE_CATEGORY in VARCHAR2,
168 P_ATTRIBUTE1 in VARCHAR2,
169 P_ATTRIBUTE2 in VARCHAR2,
170 P_ATTRIBUTE3 in VARCHAR2,
171 P_ATTRIBUTE4 in VARCHAR2,
172 P_ATTRIBUTE5 in VARCHAR2,
173 P_ATTRIBUTE6 in VARCHAR2,
174 P_ATTRIBUTE7 in VARCHAR2,
175 P_ATTRIBUTE8 in VARCHAR2,
176 P_ATTRIBUTE9 in VARCHAR2,
177 P_ATTRIBUTE10 in VARCHAR2,
178 P_ATTRIBUTE11 in VARCHAR2,
179 P_ATTRIBUTE12 in VARCHAR2,
180 P_ATTRIBUTE13 in VARCHAR2,
181 P_ATTRIBUTE14 in VARCHAR2,
182 P_ATTRIBUTE15 in VARCHAR2,
183 P_REQUEST_ID in NUMBER,
184 P_DISPLAY_NAME in VARCHAR2,
185 P_DESCRIPTION in VARCHAR2,
186 P_LAST_UPDATE_DATE in DATE,
187 P_LAST_UPDATED_BY in NUMBER,
188 P_LAST_UPDATE_LOGIN in NUMBER
189 );
190
191 procedure DELETE_ROW (
192 P_ALTERNATE_DESIGNATOR_CODE in VARCHAR2,
193 P_ORGANIZATION_ID in NUMBER
194 );
195
196 -- Start of comments
197 -- API name : copy_to_org
198 -- Type : private
199 -- Pre-reqs : Source organization structure name should exist.
200 -- Function : Copies structure name to the target organization from source organization
201 -- Parameters :
202 -- IN : p_alt_desig_code IN VARCHAR2 Required
203 -- Alternate Designator Code of the structure name
204 -- p_from_org_id IN NUMBER Required
205 -- Organization from which the structure name should be copied
206 -- p_to_org_id IN NUMBER Required
207 -- Organization to which the structure name should be copied
208 -- End of comments
209 PROCEDURE copy_to_org(
210 p_alt_desig_code IN VARCHAR2,
211 p_from_org_id IN NUMBER,
212 p_to_org_id IN NUMBER
213 );
214
215 PROCEDURE LOAD_ROW ( --- called from bomalt.lct
216 p_alternate_designator_code IN VARCHAR2,
217 p_organization_id IN NUMBER,
218 p_description IN VARCHAR2,
219 p_display_name IN VARCHAR2,
220 p_disable_date IN DATE,
221 p_structure_type_id IN NUMBER,
222 p_attribute_category IN VARCHAR2,
223 p_attribute1 IN VARCHAR2,
224 p_attribute2 IN VARCHAR2,
225 p_attribute3 IN VARCHAR2,
226 p_attribute4 IN VARCHAR2,
227 p_attribute5 IN VARCHAR2,
228 p_attribute6 IN VARCHAR2,
229 p_attribute7 IN VARCHAR2,
230 p_attribute8 IN VARCHAR2,
231 p_attribute9 IN VARCHAR2,
232 p_attribute10 IN VARCHAR2,
233 p_attribute11 IN VARCHAR2,
234 p_attribute12 IN VARCHAR2,
235 p_attribute13 IN VARCHAR2,
236 p_attribute14 IN VARCHAR2,
237 p_attribute15 IN VARCHAR2,
238 p_request_id IN NUMBER,
239 p_program_application_id IN NUMBER,
240 p_program_id IN NUMBER,
241 p_program_update_date IN DATE,
242 p_creation_date IN DATE,
243 p_created_by IN NUMBER,
244 p_last_update_date IN DATE,
245 p_last_updated_by IN NUMBER,
246 p_last_update_login IN NUMBER,
247 p_custom_mode IN VARCHAR2,
248 p_is_preferred IN VARCHAR2);
249
250 PROCEDURE LOAD_ALTERNATE_DESIGNATOR (
251 p_alternate_designator_code IN VARCHAR2,
252 p_organization_id IN NUMBER,
253 p_description IN VARCHAR2,
254 p_display_name IN VARCHAR2,
255 p_disable_date IN DATE,
256 p_structure_type_id IN NUMBER,
257 p_attribute_category IN VARCHAR2,
258 p_attribute1 IN VARCHAR2,
259 p_attribute2 IN VARCHAR2,
260 p_attribute3 IN VARCHAR2,
261 p_attribute4 IN VARCHAR2,
262 p_attribute5 IN VARCHAR2,
263 p_attribute6 IN VARCHAR2,
264 p_attribute7 IN VARCHAR2,
265 p_attribute8 IN VARCHAR2,
266 p_attribute9 IN VARCHAR2,
267 p_attribute10 IN VARCHAR2,
268 p_attribute11 IN VARCHAR2,
269 p_attribute12 IN VARCHAR2,
270 p_attribute13 IN VARCHAR2,
271 p_attribute14 IN VARCHAR2,
272 p_attribute15 IN VARCHAR2,
273 p_request_id IN NUMBER,
274 p_program_application_id IN NUMBER,
275 p_program_id IN NUMBER,
276 p_program_update_date IN DATE,
277 p_creation_date IN DATE,
278 p_created_by IN NUMBER,
279 p_last_update_date IN DATE,
280 p_last_updated_by IN NUMBER,
281 p_last_update_login IN NUMBER,
282 p_custom_mode IN VARCHAR2,
283 p_is_preferred IN VARCHAR2);
284
285 PROCEDURE TRANSLATE_ROW ( --- called from bomalt.lct
286 p_alternate_designator_code IN VARCHAR2,
287 p_organization_id IN NUMBER,
288 p_description IN VARCHAR2,
289 p_display_name IN VARCHAR2,
290 p_last_update_date IN DATE,
291 p_last_updated_by IN NUMBER,
292 p_last_update_login IN NUMBER,
293 p_custom_mode IN VARCHAR2);
294
295 END BOM_ALTERNATE_DESIGNATORS_PKG;