1 PACKAGE Pv_Pg_Invite_Headers_PVT AS
2 /* $Header: pvxvpihs.pls 120.1 2005/08/29 14:18:51 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- Pv_Pg_Invite_Headers_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- invite_headers_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- invite_header_id
29 -- object_version_number
30 -- qp_list_header_id
31 -- invite_type_code
32 -- invite_for_program_id
33 -- created_by
34 -- creation_date
35 -- last_updated_by
36 -- last_update_date
37 -- last_update_login
38 -- partner_id
39 -- invite_end_date
40 -- order_header_id
41 -- invited_by_partner_id
42 --
43 -- Required
44 --
45 -- Defaults
46 --
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51
52 --===================================================================
53 TYPE invite_headers_rec_type IS RECORD
54 (
55 invite_header_id NUMBER,
56 object_version_number NUMBER,
57 qp_list_header_id VARCHAR2(30),
58 invite_type_code VARCHAR2(30),
59 invite_for_program_id NUMBER,
60 created_by NUMBER,
61 creation_date DATE,
62 last_updated_by NUMBER,
63 last_update_date DATE,
64 last_update_login NUMBER,
65 partner_id NUMBER,
66 invite_end_date DATE,
67 order_header_id NUMBER,
68 invited_by_partner_id NUMBER,
69 trxn_extension_id NUMBER,
70 EMAIL_CONTENT VARCHAR2(4000):= FND_API.G_MISS_CHAR
71 );
72
73 g_miss_invite_headers_rec invite_headers_rec_type := NULL;
74 TYPE invite_headers_tbl_type IS TABLE OF invite_headers_rec_type INDEX BY BINARY_INTEGER;
75 g_miss_invite_headers_tbl invite_headers_tbl_type;
76
77 -- ==============================================================================
78 -- Start of Comments
79 -- ==============================================================================
80 -- API Name
81 -- Create_Invite_Headers
82 -- Type
83 -- Private
84 -- Pre-Req
85 --
86 -- Parameters
87 --
88 -- IN
89 -- p_api_version_number IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
93 -- p_invite_headers_rec IN invite_headers_rec_type Required
94 --
95 -- OUT
96 -- x_return_status OUT VARCHAR2
97 -- x_msg_count OUT NUMBER
98 -- x_msg_data OUT VARCHAR2
99 -- Version : Current version 1.0
100 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
101 -- and basic operation, developer must manually add parameters and business logic as necessary.
102 --
103 -- History
104 --
105 -- NOTE
106 --
107 -- End of Comments
108 -- ==============================================================================
109
110 PROCEDURE Create_Invite_Headers(
111 p_api_version_number IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119
120 p_invite_headers_rec IN invite_headers_rec_type := g_miss_invite_headers_rec,
121 x_INVITE_HEADER_ID OUT NOCOPY NUMBER
122 );
123
124 -- ==============================================================================
125 -- Start of Comments
126 -- ==============================================================================
127 -- API Name
128 -- Update_Invite_Headers
129 -- Type
130 -- Private
131 -- Pre-Req
132 --
133 -- Parameters
134 --
135 -- IN
136 -- p_api_version_number IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140 -- p_invite_headers_rec IN invite_headers_rec_type Required
141 --
142 -- OUT
143 -- x_return_status OUT VARCHAR2
144 -- x_msg_count OUT NUMBER
145 -- x_msg_data OUT VARCHAR2
146 -- Version : Current version 1.0
147 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
148 -- and basic operation, developer must manually add parameters and business logic as necessary.
149 --
150 -- History
151 --
152 -- NOTE
153 --
154 -- End of Comments
155 -- ==============================================================================
156
157 PROCEDURE Update_Invite_Headers(
158 p_api_version_number IN NUMBER,
159 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166
167 p_invite_headers_rec IN invite_headers_rec_type
168 );
169
170 -- ==============================================================================
171 -- Start of Comments
172 -- ==============================================================================
173 -- API Name
174 -- Delete_Invite_Headers
175 -- Type
176 -- Private
177 -- Pre-Req
178 --
179 -- Parameters
180 --
181 -- IN
182 -- p_api_version_number IN NUMBER Required
183 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
184 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
185 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
186 -- p_INVITE_HEADER_ID IN NUMBER
187 -- p_object_version_number IN NUMBER Optional Default = NULL
188 --
189 -- OUT
190 -- x_return_status OUT VARCHAR2
191 -- x_msg_count OUT NUMBER
192 -- x_msg_data OUT VARCHAR2
193 -- Version : Current version 1.0
194 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
195 -- and basic operation, developer must manually add parameters and business logic as necessary.
196 --
197 -- History
198 --
199 -- NOTE
200 --
201 -- End of Comments
202 -- ==============================================================================
203
204 PROCEDURE Delete_Invite_Headers(
205 p_api_version_number IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_INVITE_HEADER_ID IN NUMBER,
213 p_object_version_number IN NUMBER
214 );
215
216 -- ==============================================================================
217 -- Start of Comments
218 -- ==============================================================================
219 -- API Name
220 -- Lock_Invite_Headers
221 -- Type
222 -- Private
223 -- Pre-Req
224 --
225 -- Parameters
226 --
227 -- IN
228 -- p_api_version_number IN NUMBER Required
229 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232 -- p_invite_headers_rec IN invite_headers_rec_type Required
233 --
234 -- OUT
235 -- x_return_status OUT VARCHAR2
236 -- x_msg_count OUT NUMBER
237 -- x_msg_data OUT VARCHAR2
238 -- Version : Current version 1.0
239 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
240 -- and basic operation, developer must manually add parameters and business logic as necessary.
241 --
242 -- History
243 --
244 -- NOTE
245 --
246 -- End of Comments
247 -- ==============================================================================
248
249 PROCEDURE Lock_Invite_Headers(
250 p_api_version_number IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256
257 p_INVITE_HEADER_ID IN NUMBER,
258 p_object_version IN NUMBER
259 );
260
261
262 -- ==============================================================================
263 -- Start of Comments
264 -- ==============================================================================
265 -- API Name
266 -- Validate_Invite_Headers
267 --
268 -- Version : Current version 1.0
269 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
270 -- For create: G_CREATE, for update: G_UPDATE
271 -- Note: 1. This is automated generated item level validation procedure.
272 -- The actual validation detail is needed to be added.
273 -- 2. We can also validate table instead of record. There will be an option for user to choose.
274 --
275 -- History
276 --
277 -- NOTE
278 --
279 -- End of Comments
280 -- ==============================================================================
281
282
283 PROCEDURE Validate_Invite_Headers(
284 p_api_version_number IN NUMBER,
285 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
286 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
287 p_invite_headers_rec IN invite_headers_rec_type,
288 p_validation_mode IN VARCHAR2,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2
292 );
293
294 -- ==============================================================================
295 -- Start of Comments
296 -- ==============================================================================
297 -- API Name
298 -- Invite_Headers_Items
299 --
300 -- Version : Current version 1.0
301 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
302 -- For create: G_CREATE, for update: G_UPDATE
303 -- Note: 1. This is automated generated item level validation procedure.
304 -- The actual validation detail is needed to be added.
305 -- 2. Validate the unique keys, lookups here
306 --
307 -- History
308 --
309 -- NOTE
310 --
311 -- End of Comments
312 -- ==============================================================================
313
314
315 PROCEDURE Check_Invite_Headers_Items (
316 P_invite_headers_rec IN invite_headers_rec_type,
317 p_validation_mode IN VARCHAR2,
318 x_return_status OUT NOCOPY VARCHAR2
319 );
320
321 -- ==============================================================================
322 -- Start of Comments
323 -- ==============================================================================
324 -- API Name
325 -- Validate_Invite_Headers_Rec
326 --
327 -- Version : Current version 1.0
328 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 -- 2. Developer can manually added inter-field level validation.
333 --
334 -- History
335 --
336 -- NOTE
337 --
338 -- End of Comments
339 -- ==============================================================================
340
341
342 PROCEDURE Validate_Invite_Headers_Rec (
343 p_api_version_number IN NUMBER,
344 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 p_invite_headers_rec IN invite_headers_rec_type
349 );
350 END Pv_Pg_Invite_Headers_PVT;