324:
325: procedure Lock_Delivery(
326: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
327: p_caller IN VARCHAR2,
328: p_valid_index_tab IN wsh_util_core.id_tab_type,
329: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
330: x_return_status OUT NOCOPY VARCHAR2,
331: p_action IN VARCHAR2 DEFAULT NULL -- Added for bug fix 2657182
332: );
325: procedure Lock_Delivery(
326: p_rec_attr_tab IN Delivery_Attr_Tbl_Type,
327: p_caller IN VARCHAR2,
328: p_valid_index_tab IN wsh_util_core.id_tab_type,
329: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
330: x_return_status OUT NOCOPY VARCHAR2,
331: p_action IN VARCHAR2 DEFAULT NULL -- Added for bug fix 2657182
332: );
333:
354: p_delivery_id IN NUMBER,
355: p_copy_legs IN VARCHAR2 DEFAULT 'N',
356: x_delivery_id OUT NOCOPY NUMBER,
357: x_rowid OUT NOCOPY VARCHAR2,
358: x_leg_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
359: x_return_status OUT NOCOPY VARCHAR2
360: ) ;
361:
362: -- Bug 3292364
370: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
371: x_return_status OUT NOCOPY VARCHAR2);
372:
373: --OTM R12
374: PROCEDURE UPDATE_TMS_INTERFACE_FLAG (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
375: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
376: x_return_status OUT NOCOPY VARCHAR2);
377:
378: --
371: x_return_status OUT NOCOPY VARCHAR2);
372:
373: --OTM R12
374: PROCEDURE UPDATE_TMS_INTERFACE_FLAG (p_delivery_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
375: p_tms_interface_flag_tab IN WSH_UTIL_CORE.COLUMN_TAB_TYPE,
376: x_return_status OUT NOCOPY VARCHAR2);
377:
378: --
379: