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