[Home] [Help]
PACKAGE: APPS.IBE_DELIVERABLE_GRP
Source
1 PACKAGE IBE_Deliverable_GRP AUTHID CURRENT_USER AS
2 /* $Header: IBEGDLVS.pls 115.4 2003/08/26 19:52:56 abhandar ship $ */
3 /* Declare externally visible types, cursor, exception */
4 /*
5 ====================================================================
6 -- Copyright (c) 1999 Oracle Corporation --
7 -- Redwood Shores, California, USA --
8 -- All rights reserved. --
9 ------------------------------------------------------------------
10
11
12 -----------------------------------------------------------
13 -- PACKAGE
14 -- IBE_Deliverable_GRP
15 --
16 -- PROCEDURES
17 -- save_deliverable
18 -- delete_deliverable
19 -- list_deliverable
20 --
21 -- ERROR MESSAGES
22 -- IBE_DSP_DLV_ACCNAME_REQ
23 -- IBE_DSP_DLV_ACCNAME_EXISTS
24 -- IBE_DSP_DLV_NOT_EXISTS
25 -- IBE_DSP_DLV_ATH_INVLD
26 -- IBE_DSP_QUERY_INVLD
27 -- IBE_DSP_AVAIL_INVLD
28 --
29 -- HISTORY
30 -- 11/27/99 wxyu Created
31 -- 05/17/01 G. Zhang Modified to support DB Media
32
33 =============================================================================
34 */
35 TYPE DELIVERABLE_REC_TYPE IS RECORD (
36 deliverable_id NUMBER,
37 access_name VARCHAR2(40),
38 display_name VARCHAR2(240),
39 item_type VARCHAR2(40),
40 item_applicable_to VARCHAR2(40),
41 keywords VARCHAR2(240),
42 description VARCHAR2(2000),
43 object_version_number NUMBER,
44 x_action_status VARCHAR2(1)
45 );
46
47 TYPE DELIVERABLE_TBL_TYPE IS TABLE OF DELIVERABLE_REC_TYPE
48 INDEX BY BINARY_INTEGER;
49
50 TYPE DLV_ATH_REC_TYPE IS RECORD (
51 deliverable_id NUMBER,
52 access_name VARCHAR2(40),
53 display_name VARCHAR2(240),
54 item_type VARCHAR2(40),
55 item_applicable_to VARCHAR2(40),
56 keywords VARCHAR2(240),
57 description VARCHAR2(2000),
58 object_version_number NUMBER,
59 x_action_status VARCHAR2(1),
60 ath_file_name VARCHAR2(240),
61
62 --added by G. Zhang 05/17/01 5:42PM
63 ath_file_id NUMBER,
64
65 x_ath_action_status VARCHAR2(1)
66 );
67
68 TYPE DLV_ATH_TBL_TYPE IS TABLE OF DLV_ATH_REC_TYPE
69 INDEX BY BINARY_INTEGER;
70
71 TYPE DLV_ID_VER_REC_TYPE IS RECORD (
72 deliverable_id NUMBER,
73 display_name VARCHAR2(240),
74 object_version_number NUMBER,
75 x_action_status VARCHAR2(1)
76 );
77
78 TYPE DLV_ID_VER_TBL_TYPE IS TABLE OF DLV_ID_VER_REC_TYPE
79 INDEX BY BINARY_INTEGER;
80
81 TYPE NUMBER_TABLE IS TABLE OF NUMBER;
82
83 TYPE VARCHAR2_TABLE_100 IS TABLE OF VARCHAR2(100);
84
85 TYPE VARCHAR2_TABLE_300 IS TABLE OF VARCHAR2(300);
86
87 TYPE VARCHAR2_TABLE_2000 IS TABLE OF VARCHAR2(2000);
88
89 G_API_VERSION CONSTANT NUMBER := 1.0;
90 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Deliverable_GRP';
91
92 /* Declare externally callable subprograms */
93
94 PROCEDURE list_deliverable (
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_item_type IN VARCHAR2,
101 p_item_applicable_to IN VARCHAR2,
102 p_search_type IN VARCHAR2,
103 p_search_value IN VARCHAR2,
104 p_start_id IN NUMBER,
105 p_batch_size IN NUMBER,
106 x_row_count OUT NOCOPY NUMBER,
107 x_dlv_id_tbl OUT NOCOPY NUMBER_TABLE,
108 x_acc_name_tbl OUT NOCOPY VARCHAR2_TABLE_100,
109 x_dsp_name_tbl OUT NOCOPY VARCHAR2_TABLE_300,
110 x_item_type_tbl OUT NOCOPY VARCHAR2_TABLE_100,
111 x_appl_to_tbl OUT NOCOPY VARCHAR2_TABLE_100,
112 x_keyword_tbl OUT NOCOPY VARCHAR2_TABLE_300,
113 x_desc_tbl OUT NOCOPY VARCHAR2_TABLE_2000,
114 x_version_tbl OUT NOCOPY NUMBER_TABLE,
115 x_file_name_tbl OUT NOCOPY VARCHAR2_TABLE_300,
116
117 --added by G. Zhang 05/17/01 5:42PM
118 x_file_id_tbl OUT NOCOPY NUMBER_TABLE);
119
120 PROCEDURE list_deliverable (
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_category_id IN NUMBER,
127 p_item_type IN VARCHAR2,
128 p_item_applicable_to IN VARCHAR2,
129 p_search_type IN VARCHAR2,
130 p_search_value IN VARCHAR2,
131 p_start_id IN NUMBER,
132 p_batch_size IN NUMBER,
133 x_row_count OUT NOCOPY NUMBER,
134 x_dlv_id_tbl OUT NOCOPY NUMBER_TABLE,
135 x_acc_name_tbl OUT NOCOPY VARCHAR2_TABLE_100,
136 x_dsp_name_tbl OUT NOCOPY VARCHAR2_TABLE_300,
137 x_item_type_tbl OUT NOCOPY VARCHAR2_TABLE_100,
138 x_appl_to_tbl OUT NOCOPY VARCHAR2_TABLE_100,
139 x_keyword_tbl OUT NOCOPY VARCHAR2_TABLE_300,
140 x_desc_tbl OUT NOCOPY VARCHAR2_TABLE_2000,
141 x_version_tbl OUT NOCOPY NUMBER_TABLE,
142 x_file_name_tbl OUT NOCOPY VARCHAR2_TABLE_300,
143
144 --added by G. Zhang 05/17/01 5:42PM
145 x_file_id_tbl OUT NOCOPY NUMBER_TABLE);
146
147 -- Start of comments
148 -- API name: save_deliverable
149 -- Type: Private
150 -- Function: Save a logical deliverable
151 -- Pre-reqs: None
152 -- Parameters:
153 -- IN:
154 -- p_api_version IN NUMBER Required
155 -- p_init_msg_list IN VARCHAR2 Optional
156 -- Default = FND_API.g_false
157 -- p_commit IN VARCHAR2 Optional
158 -- Default = FND_API.g_false
159 -- x_return_status OUT NOCOPY VARCHAR2
160 -- x_msg_count OUT NOCOPY NUMBER
161 -- x_msg_data OUT NOCOPY VARCHAR2
162 -- p_deliverable_rec IN OUT NOCOPY DELIVERABLE_REC_TYPE
163 -- Required
164 -- Version: Current Version 1.0
165 -- Initial version 1.0
166 -- Notes: None
167 -- End of comments
168
169 PROCEDURE save_deliverable (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
172 p_commit IN VARCHAR2 := FND_API.g_false,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_deliverable_rec IN OUT NOCOPY DELIVERABLE_REC_TYPE );
177
178
179 -- Start of comments
180 -- API name: save_deliverable
181 -- Type: Private
182 -- Function: Save a collection of logical deliverables
183 -- Pre-reqs: None
184 -- Parameters:
185 -- IN:
186 -- p_api_version IN NUMBER Required
187 -- p_init_msg_list IN VARCHAR2 Optional
188 -- Default = FND_API.g_false
189 -- p_commit IN VARCHAR2 Optional
190 -- Default = FND_API.g_false
191 -- x_return_status OUT NOCOPY VARCHAR2
192 -- x_msg_count OUT NOCOPY NUMBER
193 -- x_msg_data OUT NOCOPY VARCHAR2
194 -- p_deliverable_tbl IN OUT NOCOPY DELIVERABLE_TBL_TYPE
195 -- Required
196 -- Version: Current Version 1.0
197 -- Initial version 1.0
198 -- Notes: None
199 -- End of comments
200
201 PROCEDURE save_deliverable (
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204 p_commit IN VARCHAR2 := FND_API.g_false,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_deliverable_tbl IN OUT NOCOPY DELIVERABLE_TBL_TYPE );
209
210
211 -- Start of comments
212 -- API name: save_deliverable
213 -- Type: Private
214 -- Function: Save a logical deliverable with the default attachment
215 -- for all-site and all-language
216 -- Pre-reqs: None
217 -- Parameters:
218 -- IN:
219 -- p_api_version IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Optional
221 -- Default = FND_API.g_false
222 -- p_commit IN VARCHAR2 Optional
223 -- Default = FND_API.g_false
224 -- x_return_status OUT NOCOPY VARCHAR2
225 -- x_msg_count OUT NOCOPY NUMBER
226 -- x_msg_data OUT NOCOPY VARCHAR2
227 -- p_dlv_ath_rec IN OUT NOCOPY DLV_ATH_REC_TYPE
228 -- Required
229 -- Version: Current Version 1.0
230 -- Initial version 1.0
231 -- Notes: None
232 -- End of comments
233
234 PROCEDURE save_deliverable (
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
237 p_commit IN VARCHAR2 := FND_API.g_false,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_dlv_ath_rec IN OUT NOCOPY DLV_ATH_REC_TYPE );
242
243
244 -- Start of comments
245 -- API name: save_deliverable
246 -- Type: Private
247 -- Function: Save a collection of logical deliverables with the default
248 -- attachment for all-site and all-language
249 -- Pre-reqs: None
250 -- Parameters:
251 -- IN:
252 -- p_api_version IN NUMBER Required
253 -- p_init_msg_list IN VARCHAR2 Optional
254 -- Default = FND_API.g_false
255 -- p_commit IN VARCHAR2 Optional
256 -- Default = FND_API.g_false
257 -- x_return_status OUT NOCOPY VARCHAR2
258 -- x_msg_count OUT NOCOPY NUMBER
259 -- x_msg_data OUT NOCOPY VARCHAR2
260 -- p_dlv_ath_tbl IN OUT NOCOPY DLV_ATH_TBL_TYPE
261 -- Required
262 -- Version: Current Version 1.0
263 -- Initial version 1.0
264 -- Notes: None
265 -- End of comments
266
267 PROCEDURE save_deliverable (
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
270 p_commit IN VARCHAR2 := FND_API.g_false,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_dlv_ath_tbl IN OUT NOCOPY DLV_ATH_TBL_TYPE );
275
276
277 -- Start of comments
278 -- API name: delete_deliverable
279 -- Type: Private
280 -- Function: Delete a collection of logical deliverable and
281 -- associations
282 -- Pre-reqs: None
283 -- Parameters:
284 -- IN:
285 -- p_api_version IN NUMBER Required
286 -- p_init_msg_list IN VARCHAR2 Optional
287 -- Default = FND_API.g_false
288 -- p_commit IN VARCHAR2 Optional
289 -- Default = FND_API.g_false
290 -- x_return_status OUT NOCOPY VARCHAR2
291 -- x_msg_count OUT NOCOPY NUMBER
292 -- x_msg_data OUT NOCOPY VARCHAR2
293 -- p_dlv_id_ver_tbl IN OUT NOCOPY DLV_ID_VER_TBL_TYPE
294 -- Required
295 -- Version: Current Version 1.0
296 -- Initial version 1.0
297 -- Notes: None
298 -- End of comments
299
300 PROCEDURE delete_deliverable(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303 p_commit IN VARCHAR2 := FND_API.g_false,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_dlv_id_ver_tbl IN OUT NOCOPY DLV_ID_VER_TBL_TYPE );
308
309
310
311 END IBE_Deliverable_GRP;
312