1 PACKAGE AMS_CHANNEL_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvchas.pls 115.14 2002/11/22 23:38:11 dbiswas ship $ */
3
4
5 TYPE chan_rec_type IS RECORD(
6 CHANNEL_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 CHANNEL_TYPE_CODE VARCHAR2(30),
14 ORDER_SEQUENCE NUMBER,
15 MANAGED_BY_PERSON_ID NUMBER,
16 OUTBOUND_FLAG VARCHAR2(1),
17 INBOUND_FLAG VARCHAR2(1),
18 ACTIVE_FROM_DATE DATE,
19 ACTIVE_TO_DATE DATE,
20 RATING VARCHAR2(30),
21 PREFERRED_VENDOR_ID NUMBER,
22 PARTY_ID NUMBER,
23 ATTRIBUTE_CATEGORY VARCHAR2(30),
24 ATTRIBUTE1 VARCHAR2(150),
25 ATTRIBUTE2 VARCHAR2(150),
26 ATTRIBUTE3 VARCHAR2(150),
27 ATTRIBUTE4 VARCHAR2(150),
28 ATTRIBUTE5 VARCHAR2(150),
29 ATTRIBUTE6 VARCHAR2(150),
30 ATTRIBUTE7 VARCHAR2(150),
31 ATTRIBUTE8 VARCHAR2(150),
32 ATTRIBUTE9 VARCHAR2(150),
33 ATTRIBUTE10 VARCHAR2(150),
34 ATTRIBUTE11 VARCHAR2(150),
35 ATTRIBUTE12 VARCHAR2(150),
36 ATTRIBUTE13 VARCHAR2(150),
37 ATTRIBUTE14 VARCHAR2(150),
38 ATTRIBUTE15 VARCHAR2(150),
39 CHANNEL_NAME VARCHAR2(120),
40 DESCRIPTION VARCHAR2(4000),
41 --rrajesh added on 12/07/00
42 COUNTRY_ID NUMBER
43 -- removed by Rahul Sharma on 01/18/2001
44 -- INTERNAL_RESOURCE VARCHAR2(120)
45 -- end 01/18/2001
46 --end 12/07/00
47 );
48
49
50 ---------------------------------------------------------------------
51 -- PROCEDURE
52 -- create_channel
53 --
54 -- PURPOSE
55 -- Create a new channel.
56 --
57 -- PARAMETERS
58 -- p_chan_rec: the new record to be inserted
59 -- x_chan_id: return the channel_id of the new channel
60 --
61 -- NOTES
62 -- 1. Please don't pass in any FND_API.g_mess_char/num/date.
63 -- 2. object_version_number will be set to 1.
64 -- 3. If channel_id is passed in, the uniqueness will be checked.
65 -- Raise exception in case of duplicates. If channel_id is not
66 -- passed in, generate a unique one from the sequence.
67 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
68 -- Raise exception for invalid flag. If a flag column is not
69 -- passed in, default it to 'Y' or 'N'.
70 ---------------------------------------------------------------------
71 PROCEDURE create_channel(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
74 p_commit IN VARCHAR2 := FND_API.g_false,
75 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
76
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80
81 p_chan_rec IN chan_rec_type,
82 x_chan_id OUT NOCOPY NUMBER
83 );
84
85
86 --------------------------------------------------------------------
87 -- PROCEDURE
88 -- delete_channel
89 --
90 -- PURPOSE
91 -- Set the channel to be inactive so that it won't be available
92 -- to users.
93 --
94 -- PARAMETERS
95 -- p_chan_id: the channel_id
96 -- p_object_version: the object_version_number
97 --
98 -- NOTES
99 -- 1. Raise exception if the object_version_number doesn't match.
100 -- 2. Will set the channel to be inactive, instead of remove it
101 -- from database.
102 --------------------------------------------------------------------
103 PROCEDURE delete_channel(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
106 p_commit IN VARCHAR2 := FND_API.g_false,
107
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111
112 p_chan_id IN NUMBER,
113 p_object_version IN NUMBER
114 );
115
116
117 -------------------------------------------------------------------
118 -- PROCEDURE
119 -- lock_channel
120 --
121 -- PURPOSE
122 -- Lock a channel.
123 --
124 -- PARAMETERS
125 -- p_chan_id: the channel_id
126 -- p_object_version: the object_version_number
127 --
128 -- NOTES
129 -- 1. Raise exception if the object_version_number doesn't match.
130 --------------------------------------------------------------------
131 PROCEDURE lock_channel(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
134
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138
139 p_chan_id IN NUMBER,
140 p_object_version IN NUMBER
141 );
142
143
144 ---------------------------------------------------------------------
145 -- PROCEDURE
146 -- update_channel
147 --
148 -- PURPOSE
149 -- Update a channel.
150 --
151 -- PARAMETERS
152 -- p_chan_rec: the record with new items
153 --
154 -- NOTES
155 -- 1. Raise exception if the object_version_number doesn't match.
156 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
157 -- that column won't be updated.
158 ----------------------------------------------------------------------
159 PROCEDURE update_channel(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
162 p_commit IN VARCHAR2 := FND_API.g_false,
163 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
164
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168
169 p_chan_rec IN chan_rec_type
170 );
171
172
173 ---------------------------------------------------------------------
174 -- PROCEDURE
175 -- validate_channel
176 --
177 -- PURPOSE
178 -- Validate a channel record.
179 --
180 -- PARAMETERS
181 -- p_chan_rec: the record to be validated
182 --
183 -- NOTES
184 -- 1. p_chan_rec should be the complete channel record wothout
185 -- any FND_API.g_miss_char/num/date items.
186 ----------------------------------------------------------------------
187 PROCEDURE validate_channel(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
190 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
191
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195
196 p_chan_rec IN chan_rec_type
197 );
198
199
200 ---------------------------------------------------------------------
201 -- PROCEDURE
202 -- check_chan_items
203 --
204 -- PURPOSE
205 -- Perform the item level checking including unique keys,
206 -- required columns, foreign keys, domain constraints.
207 --
208 -- PARAMETERS
209 -- p_chan_rec: the record to be validated
210 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
211 ---------------------------------------------------------------------
212 PROCEDURE check_chan_items(
213 p_chan_rec IN chan_rec_type,
214 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
215 x_return_status OUT NOCOPY VARCHAR2
216 );
217
218
219
220 ---------------------------------------------------------------------
221 -- PROCEDURE
222 -- init_chan_rec
223 --
224 -- PURPOSE
225 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
226 ---------------------------------------------------------------------
227 PROCEDURE init_chan_rec(
228 x_chan_rec OUT NOCOPY chan_rec_type
229 );
230
231
232 ---------------------------------------------------------------------
233 -- PROCEDURE
234 -- complete_chan_rec
235 --
236 -- PURPOSE
237 -- For update_channel, some attributes may be passed in as
238 -- FND_API.g_miss_char/num/date if the user doesn't want to
239 -- update those attributes. This procedure will replace the
240 -- "g_miss" attributes with current database values.
241 --
242 -- PARAMETERS
243 -- p_chan_rec: the record which may contain attributes as
244 -- FND_API.g_miss_char/num/date
245 -- x_complete_rec: the complete record after all "g_miss" items
246 -- have been replaced by current database values
247 --
248 -- NOTES
249 -- 1. If a valid status_date is provided, use it. If not, set it
250 -- to be the original value or SYSDATE depending on whether
251 -- the user_status_id is changed or not.
252 ---------------------------------------------------------------------
253 PROCEDURE complete_chan_rec(
254 p_chan_rec IN chan_rec_type,
255 x_complete_rec OUT NOCOPY chan_rec_type
256 );
257
258
259 ---------------------------------------------------------------------
260 -- FUNCTION
261 -- get_party_name
262 -- DESCRIPTION
263 -- Given a party id, returns the party_name from
264 -- HZ_PARTIES.
265 ---------------------------------------------------------------------
266 FUNCTION get_party_name (
267 p_party_id IN NUMBER
268 )
269 RETURN VARCHAR2;
270 PRAGMA RESTRICT_REFERENCES(get_party_name, WNDS);
271
272
273 ---------------------------------------------------------------------
274 -- FUNCTION
275 -- get_party_number
276 -- DESCRIPTION
277 -- Given a party id, returns the party_number from
278 -- HZ_PARTIES.
279 ---------------------------------------------------------------------
280 FUNCTION get_party_number (
281 p_party_id IN NUMBER
282 )
283 RETURN VARCHAR2;
284 PRAGMA RESTRICT_REFERENCES(get_party_number, WNDS);
285
286
287 ---------------------------------------------------------------------
288 -- FUNCTION
289 -- get_party_type
290 -- DESCRIPTION
291 -- Given a party id, returns the party_type from
292 -- HZ_PARTIES.
293 ---------------------------------------------------------------------
294 FUNCTION get_party_type (
295 p_party_id IN NUMBER
296 )
297 RETURN VARCHAR2;
298 PRAGMA RESTRICT_REFERENCES(get_party_type, WNDS);
299
300
301
302 ---------------------------------------------------------------------
303 -- FUNCTION
304 -- get_vendor_name
305 -- DESCRIPTION
306 -- Given a party id, returns the vendor_name from
307 -- po_vendors.
308 ---------------------------------------------------------------------
309 FUNCTION get_vendor_name (
310 p_vendor_id IN NUMBER
311 )
312 RETURN VARCHAR2;
313 PRAGMA RESTRICT_REFERENCES(get_vendor_name, WNDS);
314
315 ---------------------------------------------------------------------
316 -- FUNCTION
317 -- get_country_name
318 -- DESCRIPTION
319 -- Given a country id, returns the country_name from
320 -- jtf_loc_areas_vl.
321 ---------------------------------------------------------------------
322 FUNCTION get_country_name (
323 p_country_id IN NUMBER
324 )
325 RETURN VARCHAR2;
326 --PRAGMA RESTRICT_REFERENCES(get_country_name, WNDS);
327
328 END AMS_CHANNEL_PVT;
329