14:
15: PROCEDURE Cascade_To_Child_Entities
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT VARCHAR2,
22: x_msg_count OUT NUMBER,
15: PROCEDURE Cascade_To_Child_Entities
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT VARCHAR2,
22: x_msg_count OUT NUMBER,
23: x_msg_data OUT VARCHAR2,
16: (
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
21: x_return_status OUT VARCHAR2,
22: x_msg_count OUT NUMBER,
23: x_msg_data OUT VARCHAR2,
24: p_cp_id IN NUMBER,
34:
35: PROCEDURE Record_Split_In_Audit
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
35: PROCEDURE Record_Split_In_Audit
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
43: x_msg_data OUT VARCHAR2,
36: (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
41: x_return_status OUT VARCHAR2,
42: x_msg_count OUT NUMBER,
43: x_msg_data OUT VARCHAR2,
44: p_split_cp_id IN NUMBER,
144: -- p_revision IN VARCHAR2 Required
145: -- p_serial_number IN VARCHAR2 Required
146: -- p_lot_number IN VARCHAR2 Required
147: -- p_actual_ship_to_site_use_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- p_current_cp_rev_id_of_cp IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_shipped_order_line_id IN NUMBER Optional
152: -- Default = FND_API.G_MISS_NUM
146: -- p_lot_number IN VARCHAR2 Required
147: -- p_actual_ship_to_site_use_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- p_current_cp_rev_id_of_cp IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_shipped_order_line_id IN NUMBER Optional
152: -- Default = FND_API.G_MISS_NUM
153: -- p_unshipped_order_line_id IN NUMBER Optional
154: -- Default = FND_API.G_MISS_NUM
148: -- Default = FND_API.G_MISS_NUM
149: -- p_current_cp_rev_id_of_cp IN NUMBER Optional
150: -- Default = FND_API.G_MISS_NUM
151: -- p_shipped_order_line_id IN NUMBER Optional
152: -- Default = FND_API.G_MISS_NUM
153: -- p_unshipped_order_line_id IN NUMBER Optional
154: -- Default = FND_API.G_MISS_NUM
155:
156: -- OUT parameters:
150: -- Default = FND_API.G_MISS_NUM
151: -- p_shipped_order_line_id IN NUMBER Optional
152: -- Default = FND_API.G_MISS_NUM
153: -- p_unshipped_order_line_id IN NUMBER Optional
154: -- Default = FND_API.G_MISS_NUM
155:
156: -- OUT parameters:
157: -- None
158: --
169: p_shipped_date IN DATE,
170: p_revision IN VARCHAR2,
171: p_serial_number IN VARCHAR2,
172: p_lot_number IN VARCHAR2,
173: p_actual_ship_to_site_use_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
174: p_current_cp_rev_id_of_cp IN NUMBER DEFAULT FND_API.G_MISS_NUM,
175: p_shipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_unshipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
177: ) IS
170: p_revision IN VARCHAR2,
171: p_serial_number IN VARCHAR2,
172: p_lot_number IN VARCHAR2,
173: p_actual_ship_to_site_use_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
174: p_current_cp_rev_id_of_cp IN NUMBER DEFAULT FND_API.G_MISS_NUM,
175: p_shipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_unshipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
177: ) IS
178:
171: p_serial_number IN VARCHAR2,
172: p_lot_number IN VARCHAR2,
173: p_actual_ship_to_site_use_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
174: p_current_cp_rev_id_of_cp IN NUMBER DEFAULT FND_API.G_MISS_NUM,
175: p_shipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_unshipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
177: ) IS
178:
179:
172: p_lot_number IN VARCHAR2,
173: p_actual_ship_to_site_use_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
174: p_current_cp_rev_id_of_cp IN NUMBER DEFAULT FND_API.G_MISS_NUM,
175: p_shipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
176: p_unshipped_order_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
177: ) IS
178:
179:
180: BEGIN
208:
209: PROCEDURE Create_Base_Product
210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
214: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT VARCHAR2,
216: x_msg_count OUT NUMBER,
209: PROCEDURE Create_Base_Product
210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
214: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT VARCHAR2,
216: x_msg_count OUT NUMBER,
217: x_msg_data OUT VARCHAR2,
210: (
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
213: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
214: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
215: x_return_status OUT VARCHAR2,
216: x_msg_count OUT NUMBER,
217: x_msg_data OUT VARCHAR2,
218: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
216: x_msg_count OUT NUMBER,
217: x_msg_data OUT VARCHAR2,
218: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
219: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
220: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
221: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
222: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
223: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
217: x_msg_data OUT VARCHAR2,
218: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
219: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
220: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
221: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
222: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
223: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
225: x_cp_id OUT NUMBER,
218: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
219: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
220: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
221: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
222: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
223: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
225: x_cp_id OUT NUMBER,
226: x_object_version_number OUT NUMBER
219: p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
220: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
221: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
222: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
223: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
225: x_cp_id OUT NUMBER,
226: x_object_version_number OUT NUMBER
227: ) IS
220: p_create_revision IN VARCHAR2 DEFAULT FND_API.G_TRUE,
221: p_create_contacts IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- 1787841 srramakr
222: p_notify_contracts IN VARCHAR2 DEFAULT FND_API.G_TRUE,
223: p_allow_cp_with_ctr_qty_gt_one IN VARCHAR2 DEFAULT FND_API.G_FALSE,
224: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
225: x_cp_id OUT NUMBER,
226: x_object_version_number OUT NUMBER
227: ) IS
228: BEGIN
232:
233: PROCEDURE Create_Revision
234: (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
239: x_return_status OUT VARCHAR2,
240: x_msg_count OUT NUMBER,
233: PROCEDURE Create_Revision
234: (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
239: x_return_status OUT VARCHAR2,
240: x_msg_count OUT NUMBER,
241: x_msg_data OUT VARCHAR2,
234: (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
239: x_return_status OUT VARCHAR2,
240: x_msg_count OUT NUMBER,
241: x_msg_data OUT VARCHAR2,
242: p_cp_id IN NUMBER,
242: p_cp_id IN NUMBER,
243: p_rev_inv_item_id IN NUMBER,
244: p_order_info IN CS_InstalledBase_PUB.OrderInfo_Rec_Type,
245: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
246: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
247: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
248: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: x_cp_rev_id OUT NUMBER,
250: x_curr_rev_of_cp_updtd OUT VARCHAR2,
243: p_rev_inv_item_id IN NUMBER,
244: p_order_info IN CS_InstalledBase_PUB.OrderInfo_Rec_Type,
245: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
246: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
247: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
248: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: x_cp_rev_id OUT NUMBER,
250: x_curr_rev_of_cp_updtd OUT VARCHAR2,
251: x_object_version_number OUT NUMBER
244: p_order_info IN CS_InstalledBase_PUB.OrderInfo_Rec_Type,
245: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
246: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
247: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
248: p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249: x_cp_rev_id OUT NUMBER,
250: x_curr_rev_of_cp_updtd OUT VARCHAR2,
251: x_object_version_number OUT NUMBER
252: ) IS
259:
260: PROCEDURE Update_Revision
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
266: x_return_status OUT VARCHAR2,
267: x_msg_count OUT NUMBER,
260: PROCEDURE Update_Revision
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
266: x_return_status OUT VARCHAR2,
267: x_msg_count OUT NUMBER,
268: x_msg_data OUT VARCHAR2,
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
266: x_return_status OUT VARCHAR2,
267: x_msg_count OUT NUMBER,
268: x_msg_data OUT VARCHAR2,
269: p_cp_rev_id IN NUMBER,
267: x_msg_count OUT NUMBER,
268: x_msg_data OUT VARCHAR2,
269: p_cp_rev_id IN NUMBER,
270: p_object_version_number IN NUMBER,
271: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
272: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
273: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
274: x_object_version_number OUT NUMBER
275: ) IS
268: x_msg_data OUT VARCHAR2,
269: p_cp_rev_id IN NUMBER,
270: p_object_version_number IN NUMBER,
271: p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
272: p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
273: p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
274: x_object_version_number OUT NUMBER
275: ) IS
276:
280:
281: PROCEDURE Record_Shipment_Info
282: (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
286: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT VARCHAR2,
288: x_msg_count OUT NUMBER,
281: PROCEDURE Record_Shipment_Info
282: (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
286: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT VARCHAR2,
288: x_msg_count OUT NUMBER,
289: x_msg_data OUT VARCHAR2,
282: (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
286: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
287: x_return_status OUT VARCHAR2,
288: x_msg_count OUT NUMBER,
289: x_msg_data OUT VARCHAR2,
290: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
287: x_return_status OUT VARCHAR2,
288: x_msg_count OUT NUMBER,
289: x_msg_data OUT VARCHAR2,
290: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
291: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
292: x_new_cp_id OUT NUMBER,
293: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
294: ) IS
295: BEGIN
300:
301: PROCEDURE Upgrade_Product
302: (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
305: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT VARCHAR2,
308: x_msg_count OUT NUMBER,
301: PROCEDURE Upgrade_Product
302: (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
305: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT VARCHAR2,
308: x_msg_count OUT NUMBER,
309: x_msg_data OUT VARCHAR2,
302: (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
305: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
307: x_return_status OUT VARCHAR2,
308: x_msg_count OUT NUMBER,
309: x_msg_data OUT VARCHAR2,
310: p_cp_id IN NUMBER,
309: x_msg_data OUT VARCHAR2,
310: p_cp_id IN NUMBER,
311: p_old_cp_status_id IN NUMBER,
312: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
313: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_new_cp_id OUT NUMBER,
316: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
310: p_cp_id IN NUMBER,
311: p_old_cp_status_id IN NUMBER,
312: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
313: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_new_cp_id OUT NUMBER,
316: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
318: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
312: p_cp_rec IN CS_InstalledBase_PUB.CP_Prod_Rec_Type,
313: p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_new_cp_id OUT NUMBER,
316: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
318: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
319: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
320: ) IS
314: p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_new_cp_id OUT NUMBER,
316: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
318: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
319: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
320: ) IS
321: BEGIN
322:
315: x_new_cp_id OUT NUMBER,
316: p_move_upg_in_tree IN VARCHAR2 DEFAULT FND_API.G_FALSE,
317: p_savepoint_rec_lvl IN NUMBER DEFAULT 1,
318: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
319: p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
320: ) IS
321: BEGIN
322:
323: null;
326:
327: PROCEDURE Update_Product
328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
332: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT VARCHAR2,
334: x_msg_count OUT NUMBER,
327: PROCEDURE Update_Product
328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
332: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT VARCHAR2,
334: x_msg_count OUT NUMBER,
335: x_msg_data OUT VARCHAR2,
328: (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
331: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
332: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
333: x_return_status OUT VARCHAR2,
334: x_msg_count OUT NUMBER,
335: x_msg_data OUT VARCHAR2,
336: p_cp_id IN NUMBER,
339: p_ship_rec IN CS_InstalledBase_PUB.CP_Ship_Rec_Type,
340: p_comments IN VARCHAR2 DEFAULT NULL,
341: p_split_cp_id IN NUMBER DEFAULT NULL,
342: p_split_reason_code IN VARCHAR2 DEFAULT NULL,
343: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
345: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
346: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
347: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
342: p_split_reason_code IN VARCHAR2 DEFAULT NULL,
343: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
345: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
346: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
347: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
348: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
349: ) IS
350: BEGIN
343: p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
344: p_abort_on_warn_flag IN CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
345: p_cascade_updates_flag IN CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
346: p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
347: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
348: p_savepoint_rec_lvl IN NUMBER DEFAULT 1
349: ) IS
350: BEGIN
351:
356:
357: PROCEDURE Specify_Contact
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
361: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
362: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
363: x_return_status OUT VARCHAR2,
364: x_msg_count OUT NUMBER,
357: PROCEDURE Specify_Contact
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
361: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
362: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
363: x_return_status OUT VARCHAR2,
364: x_msg_count OUT NUMBER,
365: x_msg_data OUT VARCHAR2,
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
361: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
362: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
363: x_return_status OUT VARCHAR2,
364: x_msg_count OUT NUMBER,
365: x_msg_data OUT VARCHAR2,
366: p_contact_rec IN CS_InstalledBase_PUB.CP_Contact_Rec_Type,