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