[Home] [Help]
PACKAGE: APPS.AMS_ASSOCIATIONS_PVT
Source
1 PACKAGE AMS_Associations_PVT AUTHID CURRENT_USER AS
2 /*$Header: amsvasss.pls 115.12 2002/12/02 20:30:46 dbiswas ship $*/
3
4 TYPE association_rec_type IS RECORD(
5 OBJECT_ASSOCIATION_ID NUMBER,
6 LAST_UPDATE_DATE DATE,
7 LAST_UPDATED_BY NUMBER,
8 CREATION_DATE DATE,
9 CREATED_BY NUMBER,
10 LAST_UPDATE_LOGIN NUMBER,
11 OBJECT_VERSION_NUMBER NUMBER,
12 MASTER_OBJECT_TYPE VARCHAR2(30),
13 MASTER_OBJECT_ID NUMBER,
14 USING_OBJECT_TYPE VARCHAR2(30),
15 USING_OBJECT_ID NUMBER,
16 PRIMARY_FLAG VARCHAR2(1),
17 USAGE_TYPE VARCHAR2(30),
18 QUANTITY_NEEDED NUMBER,
19 QUANTITY_NEEDED_BY_DATE DATE,
20 COST_FROZEN_FLAG VARCHAR2(1),
21 PCT_OF_COST_TO_CHARGE_USED_BY NUMBER,
22 MAX_COST_TO_CHARGE_USED_BY NUMBER,
23 MAX_COST_CURRENCY_CODE VARCHAR2(15),
24 METRIC_CLASS VARCHAR2(30),
25 FULFILL_ON_TYPE_CODE VARCHAR2(30),
26 ATTRIBUTE_CATEGORY VARCHAR2(30),
27 ATTRIBUTE1 VARCHAR2(150),
28 ATTRIBUTE2 VARCHAR2(150),
29 ATTRIBUTE3 VARCHAR2(150),
30 ATTRIBUTE4 VARCHAR2(150),
31 ATTRIBUTE5 VARCHAR2(150),
32 ATTRIBUTE6 VARCHAR2(150),
33 ATTRIBUTE7 VARCHAR2(150),
34 ATTRIBUTE8 VARCHAR2(150),
35 ATTRIBUTE9 VARCHAR2(150),
36 ATTRIBUTE10 VARCHAR2(150),
37 ATTRIBUTE11 VARCHAR2(150),
38 ATTRIBUTE12 VARCHAR2(150),
39 ATTRIBUTE13 VARCHAR2(150),
40 ATTRIBUTE14 VARCHAR2(150),
41 ATTRIBUTE15 VARCHAR2(150),
42 CONTENT_TYPE VARCHAR2(30),
43 SEQUENCE_NO NUMBER
44 );
45 ---------------------------------------------------------------------
46 -- PROCEDURE
47 -- create_association
48 --
49 -- PURPOSE
50 -- Create a new object association.
51 --
52 -- PARAMETERS
53 -- p_association_rec: the new record to be inserted
54 -- x_object_association_id: return the object_association_id of the new association
55 --
56 -- NOTES
57 -- 1. object_version_number will be set to 1.
58 -- 2. If object_association_id is passed in, the uniqueness will be checked.
59 -- Raise exception in case of duplicates.
60 -- 3. If object_association_id is not passed in, generate a unique one from
61 -- the sequence.
62 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
63 -- Raise exception for invalid flag.
64 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
65 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
66 ---------------------------------------------------------------------
67 PROCEDURE create_association(
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 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76
77 p_association_rec IN association_rec_type,
78 x_object_association_id OUT NOCOPY NUMBER
79 );
80
81
82 --------------------------------------------------------------------
83 -- PROCEDURE
84 -- delete_association
85 --
86 -- PURPOSE
87 -- Delete a association.
88 --
89 -- PARAMETERS
90 -- p_object_association_id: the object_association_id
91 -- p_object_version: the object_version_number
92 --
93 -- NOTES
94 -- 1. Raise exception if the object_version_number doesn't match.
95 --------------------------------------------------------------------
96 PROCEDURE delete_association(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99 p_commit IN VARCHAR2 := FND_API.g_false,
100 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
101
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105
106 p_object_association_id IN NUMBER,
107 p_object_version IN NUMBER
108 );
109
110
111 -------------------------------------------------------------------
112 -- PROCEDURE
113 -- lock_association
114 --
115 -- PURPOSE
116 -- Lock a association.
117 --
118 -- PARAMETERS
119 -- p_object_association_id: the object_association_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_association(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
129
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133
134 p_object_association_id IN NUMBER,
135 p_object_version IN NUMBER
136 );
137
138
139 ---------------------------------------------------------------------
140 -- PROCEDURE
141 -- update_association
142 --
143 -- PURPOSE
144 -- Update a association.
145 --
146 -- PARAMETERS
147 -- p_association_rec: the record with new items
148 --
149 -- NOTES
150 -- 1. Raise exception if the object_version_number doesn't match.
151 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
152 -- that column won't be updated.
153 ----------------------------------------------------------------------
154 PROCEDURE update_association(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
157 p_commit IN VARCHAR2 := FND_API.g_false,
158 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
159
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_association_rec IN association_rec_type
164 );
165
166 ---------------------------------------------------------------------
167 -- PROCEDURE
168 -- validate_association
169 --
170 -- PURPOSE
171 -- Validate a association record.
172 --
173 -- PARAMETERS
174 -- p_association_rec: the association record to be validated
175 --
176 -- NOTES
177 -- 1. p_association_rec should be the complete association record. There
178 -- should not be any FND_API.g_miss_char/num/date in it.
179 ----------------------------------------------------------------------
180 PROCEDURE validate_association(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
184
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188
189 p_association_rec IN association_rec_type
190 );
191
192 ---------------------------------------------------------------------
193 -- PROCEDURE
194 -- check_association_items
195 --
196 -- PURPOSE
197 -- Perform the item level checking including unique keys,
198 -- required columns, foreign keys, domain constraints.
199 --
200 -- PARAMETERS
201 -- p_association_rec: the record to be validated
202 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
203 ---------------------------------------------------------------------
204 PROCEDURE check_association_items(
205 p_association_rec IN association_rec_type,
206 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
207 x_return_status OUT NOCOPY VARCHAR2
208 );
209
210
211 ---------------------------------------------------------------------
212 -- PROCEDURE
213 -- check_association_record
214 --
215 -- PURPOSE
216 -- Check the record level business rules.
217 --
218 -- PARAMETERS
219 -- p_association_rec: the record to be validated; attributes
220 -- as FND_API.g_miss_char/num/date completed
221 ---------------------------------------------------------------------
222 PROCEDURE check_association_record(
223 p_association_rec IN association_rec_type,
224 x_return_status OUT NOCOPY VARCHAR2
225 );
226
227 ---------------------------------------------------------------------
228 -- PROCEDURE
229 -- complete_association_rec
230 --
231 -- PURPOSE
232 -- For update_association, some attributes may be passed in as
233 -- FND_API.g_miss_char/num/date if the user doesn't want to
234 -- update those attributes. This procedure will replace the
235 -- "g_miss" attributes with current database values.
236 --
237 -- PARAMETERS
238 -- p_association_rec: the record which may contain attributes as
239 -- FND_API.g_miss_char/num/date
240 -- x_complete_rec: the complete record after all "g_miss" items
241 -- have been replaced by current database values
242 ---------------------------------------------------------------------
243 PROCEDURE complete_association_rec(
244 p_association_rec IN association_rec_type,
245 x_complete_rec OUT NOCOPY association_rec_type
246 );
247
248 PROCEDURE init_association_rec(
249 x_association_rec OUT NOCOPY association_rec_type
250 );
251
252 END AMS_Associations_PVT;