[Home] [Help]
PACKAGE: APPS.AMS_AGENDAS_PVT
Source
1 PACKAGE AMS_AGENDAS_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvagns.pls 115.4 2003/03/28 23:20:09 soagrawa ship $*/
3
4 TYPE agenda_rec_type IS RECORD(
5 AGENDA_ID NUMBER,
6 SETUP_TYPE_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 APPLICATION_ID NUMBER,
14 ACTIVE_FLAG VARCHAR2(1),
15 DEFAULT_TRACK_FLAG VARCHAR2(1),
16 AGENDA_TYPE VARCHAR2(30),
17 ROOM_ID NUMBER ,
18 START_DATE_TIME DATE,
19 END_DATE_TIME DATE,
20 COORDINATOR_ID NUMBER,
21 TIMEZONE_ID NUMBER,
22 PARENT_TYPE VARCHAR2(30),
23 PARENT_ID NUMBER,
24 ATTRIBUTE_CATEGORY VARCHAR2(30),
25 ATTRIBUTE1 VARCHAR2(150),
26 ATTRIBUTE2 VARCHAR2(150),
27 ATTRIBUTE3 VARCHAR2(150),
28 ATTRIBUTE4 VARCHAR2(150),
29 ATTRIBUTE5 VARCHAR2(150),
30 ATTRIBUTE6 VARCHAR2(150),
31 ATTRIBUTE7 VARCHAR2(150),
32 ATTRIBUTE8 VARCHAR2(150),
33 ATTRIBUTE9 VARCHAR2(150),
34 ATTRIBUTE10 VARCHAR2(150),
35 ATTRIBUTE11 VARCHAR2(150),
36 ATTRIBUTE12 VARCHAR2(150),
37 ATTRIBUTE13 VARCHAR2(150),
38 ATTRIBUTE14 VARCHAR2(150),
39 ATTRIBUTE15 VARCHAR2(150),
40 AGENDA_NAME VARCHAR2(240),
41 DESCRIPTION VARCHAR2(4000)
42 );
43
44 ---------------------------------------------------------------------
45 -- PROCEDURE
46 -- create_agenda
47 --
48 -- PURPOSE
49 -- Create a new agenda item (Track/Session) for the event offer.
50 --
51 -- PARAMETERS
52 -- p_agenda_rec: the new record to be inserted
53 -- x_agenda_id: return the agenda_id of the new agenda
54 --
55 -- NOTES
56 -- 1. object_version_number will be set to 1.
57 -- 2. If agenda_id is passed in, the uniqueness will be checked.
58 -- Raise exception in case of duplicates.
59 -- 3. If agenda_id is not passed in, generate a unique one from
60 -- the sequence.
61 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
62 -- Raise exception for invalid flag.
63 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
64 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
65 ---------------------------------------------------------------------
66
67 PROCEDURE create_agenda(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
70 p_commit IN VARCHAR2 := FND_API.g_false,
71 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
72
73 p_agenda_rec IN agenda_rec_type,
74
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78
79 x_agenda_id OUT NOCOPY NUMBER
80 );
81
82
83 --------------------------------------------------------------------
84 -- PROCEDURE
85 -- delete_agenda
86 --
87 -- PURPOSE
88 -- Delete an agenda.
89 --
90 -- PARAMETERS
91 -- p_agenda_id: the agenda_id
92 -- p_object_version: the object_version_number
93 --
94 -- NOTES
95 -- 1. Raise exception if the object_version_number doesn't match.
96 --------------------------------------------------------------------
97 PROCEDURE delete_agenda(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
100 p_commit IN VARCHAR2 := FND_API.g_false,
101
102 p_agenda_id IN NUMBER,
103 p_object_version IN NUMBER,
104
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110
111 -------------------------------------------------------------------
112 -- PROCEDURE
113 -- lock_agenda
114 --
115 -- PURPOSE
116 -- Lock the agenda.
117 --
118 -- PARAMETERS
119 -- p_agenda_id: the agenda_id
120 -- p_object_version: the object_version_number
121 --
122 -- NOTES
123 -- 1. Raise exception if the object_version_number doesn't match.
124 --------------------------------------------------------------------
125 PROCEDURE lock_agenda(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128
129 p_agenda_id IN NUMBER,
130 p_object_version IN NUMBER,
131
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137
138 ---------------------------------------------------------------------
139 -- PROCEDURE
140 -- update_agenda
141 --
142 -- PURPOSE
143 -- Update the agenda.
144 --
145 -- PARAMETERS
146 -- p_agenda_rec: the record with new items
147 --
148 -- NOTES
149 -- 1. Raise exception if the object_version_number doesn't match.
150 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
151 -- that column won't be updated.
152 ----------------------------------------------------------------------
153 PROCEDURE update_agenda(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
156 p_commit IN VARCHAR2 := FND_API.g_false,
157 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
158
159 p_agenda_rec IN agenda_rec_type,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166
167 ---------------------------------------------------------------------
168 -- PROCEDURE
169 -- validate_agenda
170 --
171 -- PURPOSE
172 -- Validate the agenda record.
173 --
174 -- PARAMETERS
175 -- p_agenda_rec: the agenda record to be validated
176 --
177 -- NOTES
178 -- 1. p_agenda_rec should be the complete agenda record. There
179 -- should not be any FND_API.g_miss_char/num/date in it.
180 ----------------------------------------------------------------------
181 PROCEDURE validate_agenda(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185
186 p_agenda_rec IN agenda_rec_type,
187
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2
191 );
192
193
194 ---------------------------------------------------------------------
195 -- PROCEDURE
196 -- check_agenda_items
197 --
198 -- PURPOSE
199 -- Perform the item level checking including unique keys,
200 -- required columns, foreign keys, domain constraints.
201 --
202 -- PARAMETERS
203 -- p_agenda_rec: the record to be validated
204 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
205 ---------------------------------------------------------------------
206 PROCEDURE validate_agenda_items(
207 p_agenda_rec IN agenda_rec_type,
208 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
209 x_return_status OUT NOCOPY VARCHAR2
210 );
211
212
213 ---------------------------------------------------------------------
214 -- PROCEDURE
215 -- check_agenda_record
216 --
217 -- PURPOSE
218 -- Check the record level business rules.
219 --
220 -- PARAMETERS
221 -- p_agenda_rec: the record to be validated; may contain attributes
222 -- as FND_API.g_miss_char/num/date
223 -- p_complete_rec: the complete record after all "g_miss" items
224 -- have been replaced by current database values
225 ---------------------------------------------------------------------
226 PROCEDURE validate_agenda_record(
227 p_agenda_rec IN agenda_rec_type,
228 p_complete_rec IN agenda_rec_type := NULL,
229 x_return_status OUT NOCOPY VARCHAR2
230 );
231
232
233 ---------------------------------------------------------------------
234 -- PROCEDURE
235 -- init_agenda_rec
236 --
237 -- PURPOSE
238 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
239 ---------------------------------------------------------------------
240 PROCEDURE init_agenda_rec(
241 p_agenda_rec IN agenda_rec_type,
242 x_agenda_rec OUT NOCOPY agenda_rec_type
243 );
244
245
246 ---------------------------------------------------------------------
247 -- PROCEDURE
248 -- complete_agenda_rec
249 --
250 -- PURPOSE
251 -- For update_agenda, some attributes may be passed in as
252 -- FND_API.g_miss_char/num/date if the user doesn't want to
253 -- update those attributes. This procedure will replace the
254 -- "g_miss" attributes with current database values.
255 --
256 -- PARAMETERS
257 -- p_agenda_rec: the record which may contain attributes as
258 -- FND_API.g_miss_char/num/date
259 -- x_complete_rec: the complete record after all "g_miss" items
260 -- have been replaced by current database values
261 ---------------------------------------------------------------------
262 PROCEDURE complete_agenda_rec(
263 p_agenda_rec IN agenda_rec_type,
264 x_agenda_rec OUT NOCOPY agenda_rec_type
265 );
266
267
268 PROCEDURE ADD_LANGUAGE;
269
270 END AMS_AGENDAS_PVT;