[Home] [Help]
PACKAGE: APPS.AMS_DELIVERABLE_PUB
Source
1 PACKAGE AMS_Deliverable_PUB AS
2 /* $Header: amspdels.pls 120.0 2005/05/31 17:02:59 appldev noship $ */
3
4 -- Default number of records fetch per call
5 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
6
7
8 TYPE deliv_rec_type IS RECORD
9 (
10 deliverable_id NUMBER,
11 last_update_date DATE,
12 last_updated_by NUMBER,
13 creation_date DATE,
14 created_by NUMBER,
15 last_update_login NUMBER,
16 object_version_number NUMBER,
17 language_code VARCHAR2(4),
18 version VARCHAR2(10),
19 application_id NUMBER,
20 user_status_id NUMBER,
21 status_code VARCHAR2(30),
22 status_date DATE,
23 active_flag VARCHAR2(1),
24 private_flag VARCHAR2(1),
25 owner_user_id NUMBER,
26 fund_source_id NUMBER,
27 fund_source_type VARCHAR2(30),
28 category_type_id NUMBER,
29 category_sub_type_id NUMBER,
30 kit_flag VARCHAR2(1),
31 inventory_flag VARCHAR2(1),
32 inventory_item_id NUMBER,
33 inventory_item_org_id NUMBER,
34 pricelist_header_id NUMBER,
35 pricelist_line_id NUMBER,
36 actual_avail_from_date DATE,
37 actual_avail_to_date DATE,
38 forecasted_complete_date DATE,
39 actual_complete_date DATE,
40 transaction_currency_code VARCHAR2(15),
41 functional_currency_code VARCHAR2(15),
42 budget_amount_tc NUMBER,
43 budget_amount_fc NUMBER,
44 replaced_by_deliverable_id NUMBER,
45 can_fulfill_electronic_flag VARCHAR2(1),
46 can_fulfill_physical_flag VARCHAR2(1),
47 jtf_amv_item_id NUMBER,
48 non_inv_ctrl_code VARCHAR2(30),
49 non_inv_quantity_on_hand NUMBER,
50 non_inv_quantity_on_order NUMBER,
51 non_inv_quantity_on_reserve NUMBER,
52 chargeback_amount NUMBER,
53 chargeback_uom VARCHAR2(3),
54 chargeback_amount_curr_code VARCHAR2(15),
55 deliverable_code VARCHAR2(100),
56 deliverable_pick_flag VARCHAR2(1),
57 currency_code VARCHAR2(15),
58 forecasted_cost NUMBER,
59 actual_cost NUMBER,
60 forecasted_responses NUMBER,
61 actual_responses NUMBER,
62 country VARCHAR2(240),
63 default_approver_id NUMBER,
64 attribute_category VARCHAR2(30),
65 attribute1 VARCHAR2(150),
66 attribute2 VARCHAR2(150),
67 attribute3 VARCHAR2(150),
68 attribute4 VARCHAR2(150),
69 attribute5 VARCHAR2(150),
70 attribute6 VARCHAR2(150),
71 attribute7 VARCHAR2(150),
72 attribute8 VARCHAR2(150),
73 attribute9 VARCHAR2(150),
74 attribute10 VARCHAR2(150),
75 attribute11 VARCHAR2(150),
76 attribute12 VARCHAR2(150),
77 attribute13 VARCHAR2(150),
78 attribute14 VARCHAR2(150),
79 attribute15 VARCHAR2(150),
80 deliverable_name VARCHAR2(240),
81 description VARCHAR2(4000),
82 start_period_name VARCHAR2(15),
83 end_period_name VARCHAR2(15),
84 deliverable_calendar VARCHAR2(15),
85 country_id NUMBER,
86 setup_id NUMBER,
87 item_Number VARCHAR2(2000),
88 associate_flag VARCHAR2(1),
89 master_object_id NUMBER,
90 master_object_type VARCHAR2(150),
91 email_content_type VARCHAR2(30)
92 );
93
94 ---------------------------------------------------------------------
95 -- PROCEDURE
96 -- create_Deliverable
97 --
98 -- PURPOSE
99 -- Create a new Deliverable.
100 --
101 -- PARAMETERS
102 -- p_deliv_rec: the new record to be inserted
103 -- x_deliv_id: return the deliverable_id of the new Deliverable
104 --
105 -- NOTES
106 -- overloading the existing create_deliverable api with public rec_type for rosetta generation.
107 ---------------------------------------------------------------------
108
109
110
111 PROCEDURE create_Deliverable(
112 p_api_version_number IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
114 p_commit IN VARCHAR2 := FND_API.g_false,
115 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
116
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120
121 p_deliv_rec IN deliv_rec_type,
122 x_deliv_id OUT NOCOPY NUMBER
123 );
124
125
126
127
128 ---------------------------------------------------------------------
129 -- PROCEDURE
130 -- create_Deliverable
131 --
132 -- PURPOSE
133 -- Create a new Deliverable.
134 --
135 -- PARAMETERS
136 -- p_deliv_rec: the new record to be inserted
137 -- x_deliv_id: return the deliverable_id of the new Deliverable
138 --
139 -- NOTES
140 -- 1. object_version_number will be set to 1.
141 -- 2. If Deliverable_id is passed in, the uniqueness will be checked.
142 -- Raise exception in case of duplicates.
143 -- 3. If Deliverable_id is not passed in, generate a unique one from
144 -- the sequence.
145 ---------------------------------------------------------------------
146 PROCEDURE create_Deliverable(
147 p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
149 p_commit IN VARCHAR2 := FND_API.g_false,
150 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
151
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155
156 p_deliv_rec IN AMS_Deliverable_PVT.deliv_rec_type,
157 x_deliv_id OUT NOCOPY NUMBER
158 );
159
160
161 --------------------------------------------------------------------
162 -- PROCEDURE
163 -- delete_Deliverable
164 --
165 -- PURPOSE
166 -- Delete a Deliverable.
167 --
168 -- PARAMETERS
169 -- p_deliv_id: the Deliverable_id
170 -- p_object_version: the object_version_number
171 --
172 -- NOTES
173 -- 1. Raise exception if the object_version_number doesn't match.
174 -- 2. Will set the Deliverable to be inactive, instead of remove it
175 -- from database.
176 --------------------------------------------------------------------
177 PROCEDURE delete_Deliverable(
178 p_api_version_number IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
180 p_commit IN VARCHAR2 := FND_API.g_false,
181 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
182
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186
187 p_deliv_id IN NUMBER,
188 p_object_version_number IN NUMBER
189 );
190
191
192 -------------------------------------------------------------------
193 -- PROCEDURE
194 -- lock_Deliverable
195 --
196 -- PURPOSE
197 -- Lock a Deliverable.
198 --
199 -- PARAMETERS
200 -- p_deliv_id: the Deliverable_id
201 -- p_object_version: the object_version_number
202 --
203 -- NOTES
204 -- 1. Raise exception if the object_version_number doesn't match.
205 --------------------------------------------------------------------
206 PROCEDURE lock_Deliverable(
207 p_api_version_number IN NUMBER,
208 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
209 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
210
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214
215 p_deliv_id IN NUMBER,
216 p_object_version_number IN NUMBER
217 );
218
219 ---------------------------------------------------------------------
220 -- PROCEDURE
221 -- update_Deliverable
222 --
223 -- PURPOSE
224 -- Update a Deliverable.
225 --
226 -- PARAMETERS
227 -- p_deliv_rec: the record with new items
228 --
229 -- NOTES
230 -- overloading the existing create_deliverable api with public rec_type for rosetta generation.
231 ----------------------------------------------------------------------
232 PROCEDURE update_Deliverable(
233 p_api_version_number IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235 p_commit IN VARCHAR2 := FND_API.g_false,
236 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
237
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241
242 p_deliv_rec IN deliv_rec_type
243 );
244
245 ---------------------------------------------------------------------
246 -- PROCEDURE
247 -- update_Deliverable
248 --
249 -- PURPOSE
250 -- Update a Deliverable.
251 --
252 -- PARAMETERS
253 -- p_deliv_rec: the record with new items
254 --
255 -- NOTES
256 -- 1. Raise exception if the object_version_number doesn't match.
257 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
258 -- that column won't be updated.
259 ----------------------------------------------------------------------
260 PROCEDURE update_Deliverable(
261 p_api_version_number IN NUMBER,
262 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
263 p_commit IN VARCHAR2 := FND_API.g_false,
264 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
265
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269
270 p_deliv_rec IN AMS_Deliverable_PVT.deliv_rec_type
271 );
272
273
274
275 ---------------------------------------------------------------------
276 -- PROCEDURE
277 -- validate_Deliverable
278 --
279 -- PURPOSE
280 -- Validate a Deliverable record.
281 --
282 -- PARAMETERS
283 -- p_deliv_rec: the Deliverable record to be validated
284 --
285 -- NOTES
286 -- 1. p_deliv_rec should be the complete Deliverable record. There
287 -- should not be any FND_API.g_miss_char/num/date in it.
288 ----------------------------------------------------------------------
289 PROCEDURE validate_Deliverable(
290 p_api_version_number IN NUMBER,
291 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
292 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
293 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297
298 p_deliv_rec IN AMS_Deliverable_PVT.deliv_rec_type
299 );
300
301
302 END AMS_Deliverable_PUB;