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