1 PACKAGE AMS_St_Assoc_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvstas.pls 115.5 2002/11/22 08:56:25 jieli ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_St_Assoc_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- st_assoc_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- list_source_type_assoc_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- master_source_type_id
33 -- sub_source_type_id
34 -- sub_source_type_pk_column
35 -- enabled_flag
36 -- description
37 -- security_group_id
38 --
39 -- Required
40 --
41 -- Defaults
42 --
43 -- Note: This is automatic generated record definition, it includes all columns
44 -- defined in the table, developer must manually add or delete some of the attributes.
45 --
46 -- End of Comments
47
48 --===================================================================
49 TYPE st_assoc_rec_type IS RECORD
50 (
51 list_source_type_assoc_id NUMBER := FND_API.G_MISS_NUM,
52 last_update_date DATE := FND_API.G_MISS_DATE,
53 last_updated_by NUMBER := FND_API.G_MISS_NUM,
54 creation_date DATE := FND_API.G_MISS_DATE,
55 created_by NUMBER := FND_API.G_MISS_NUM,
56 last_update_login NUMBER := FND_API.G_MISS_NUM,
57 object_version_number NUMBER := FND_API.G_MISS_NUM,
58 master_source_type_id NUMBER := FND_API.G_MISS_NUM,
59 sub_source_type_id NUMBER := FND_API.G_MISS_NUM,
60 sub_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR,
61 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
62 description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
63 master_source_type_pk_column VARCHAR2(30) := FND_API.G_MISS_CHAR
64 );
65
66 g_miss_st_assoc_rec st_assoc_rec_type;
67 TYPE st_assoc_tbl_type IS TABLE OF st_assoc_rec_type INDEX BY BINARY_INTEGER;
68 g_miss_st_assoc_tbl st_assoc_tbl_type;
69
70 -- ==============================================================================
71 -- Start of Comments
72 -- ==============================================================================
73 -- API Name
74 -- Create_St_Assoc
75 -- Type
76 -- Private
77 -- Pre-Req
78 --
79 -- Parameters
80 --
81 -- IN
82 -- p_api_version_number IN NUMBER Required
83 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_st_assoc_rec IN st_assoc_rec_type Required
87 --
88 -- OUT
89 -- x_return_status OUT VARCHAR2
90 -- x_msg_count OUT NUMBER
91 -- x_msg_data OUT VARCHAR2
92 -- Version : Current version 1.0
93 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
94 -- and basic operation, developer must manually add parameters and business logic as necessary.
95 --
96 -- End of Comments
97 -- ==============================================================================
98 --
99
100 PROCEDURE Create_St_Assoc(
101 p_api_version_number IN NUMBER,
102 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109
110 p_st_assoc_rec IN st_assoc_rec_type := g_miss_st_assoc_rec,
111 x_list_source_type_assoc_id OUT NOCOPY NUMBER
112 );
113
114 -- ==============================================================================
115 -- Start of Comments
116 -- ==============================================================================
117 -- API Name
118 -- Update_St_Assoc
119 -- Type
120 -- Private
121 -- Pre-Req
122 --
123 -- Parameters
124 --
125 -- IN
126 -- p_api_version_number IN NUMBER Required
127 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130 -- p_st_assoc_rec IN st_assoc_rec_type Required
131 --
132 -- OUT
133 -- x_return_status OUT VARCHAR2
134 -- x_msg_count OUT NUMBER
135 -- x_msg_data OUT VARCHAR2
136 -- Version : Current version 1.0
137 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
138 -- and basic operation, developer must manually add parameters and business logic as necessary.
139 --
140 -- End of Comments
141 -- ==============================================================================
142 --
143
144 PROCEDURE Update_St_Assoc(
145 p_api_version_number IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE,
148 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153
154 p_st_assoc_rec IN st_assoc_rec_type,
155 x_object_version_number OUT NOCOPY NUMBER
156 );
157
158 -- ==============================================================================
159 -- Start of Comments
160 -- ==============================================================================
161 -- API Name
162 -- Delete_St_Assoc
163 -- Type
164 -- Private
165 -- Pre-Req
166 --
167 -- Parameters
168 --
169 -- IN
170 -- p_api_version_number IN NUMBER Required
171 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- p_LIST_SOURCE_TYPE_ASSOC_ID IN NUMBER
175 -- p_object_version_number IN NUMBER Optional Default = NULL
176 --
177 -- OUT
178 -- x_return_status OUT VARCHAR2
179 -- x_msg_count OUT NUMBER
180 -- x_msg_data OUT VARCHAR2
181 -- Version : Current version 1.0
182 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
183 -- and basic operation, developer must manually add parameters and business logic as necessary.
184 --
185 -- End of Comments
186 -- ==============================================================================
187 --
188
189 PROCEDURE Delete_St_Assoc(
190 p_api_version_number IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_list_source_type_assoc_id IN NUMBER,
198 p_object_version_number IN NUMBER
199 );
200
201 -- ==============================================================================
202 -- Start of Comments
203 -- ==============================================================================
204 -- API Name
205 -- Lock_St_Assoc
206 -- Type
207 -- Private
208 -- Pre-Req
209 --
210 -- Parameters
211 --
212 -- IN
213 -- p_api_version_number IN NUMBER Required
214 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217 -- p_st_assoc_rec IN st_assoc_rec_type Required
218 --
219 -- OUT
220 -- x_return_status OUT VARCHAR2
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2
223 -- Version : Current version 1.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 -- ==============================================================================
229 --
230
231 PROCEDURE Lock_St_Assoc(
232 p_api_version_number IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238
239 p_list_source_type_assoc_id IN NUMBER,
240 p_object_version IN NUMBER
241 );
242
243
244 -- Start of Comments
245 --
246 -- validation procedures
247 --
248 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
249 -- For create: G_CREATE, for update: G_UPDATE
250 -- Note: 1. This is automated generated item level validation procedure.
251 -- The actual validation detail is needed to be added.
252 -- 2. We can also validate table instead of record. There will be an option for user to choose.
253 -- End of Comments
254
255 PROCEDURE Validate_st_assoc(
256 p_api_version_number IN NUMBER,
257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259 p_st_assoc_rec IN st_assoc_rec_type,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2
263 );
264
265 -- Start of Comments
266 --
267 -- validation procedures
268 --
269 -- p_validation_mode is a constant defined in AMS_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. Validate the unique keys, lookups here
274 -- End of Comments
275
276 PROCEDURE Check_st_assoc_Items (
277 P_st_assoc_rec IN st_assoc_rec_type,
278 p_validation_mode IN VARCHAR2,
279 x_return_status OUT NOCOPY VARCHAR2
280 );
281
282 -- Start of Comments
283 --
284 -- Record level validation procedures
285 --
286 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
287 -- For create: G_CREATE, for update: G_UPDATE
288 -- Note: 1. This is automated generated item level validation procedure.
289 -- The actual validation detail is needed to be added.
290 -- 2. Developer can manually added inter-field level validation.
291 -- End of Comments
292
293 PROCEDURE Validate_st_assoc_rec(
294 p_api_version_number IN NUMBER,
295 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_st_assoc_rec IN st_assoc_rec_type
300 );
301 END AMS_St_Assoc_PVT;
[Home] [Help]