[Home] [Help]
18:
19: --==============DECLARE RECORD/TABLE STRUCTURES=======================================
20:
21: /* Do not use Delivery_Details_Rec_Type, use the record defined in
22: wsh_glbl_var_strct_grp
23: */
24: TYPE Delivery_Details_Rec_Type IS RECORD
25: (delivery_detail_id NUMBER,
26: source_code VARCHAR2(30),
248: TYPE VARCHAR2(30)
249: );
250:
251: /* Do not use Delivery_Details_Attr_Tbl_Type, use the table defined in
252: wsh_glbl_var_strct_grp
253: */
254: TYPE Delivery_Details_Attr_Tbl_Type is TABLE of Delivery_Details_Rec_Type index by binary_integer;
255:
256: --========================================================================
271: -- Prereq: Use initialize_detail() to initialize the record type
272: -- Then (optionally) modify whichever attributes you need to in that record
273: -- And then pass it along with the old delivery delivery detail id to be copied from
274: PROCEDURE create_new_detail_from_old(
275: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
276: p_delivery_detail_id IN NUMBER,
277: x_row_id OUT NOCOPY VARCHAR2,
278: x_delivery_detail_id OUT NOCOPY NUMBER,
279: x_return_status OUT NOCOPY VARCHAR2);
280:
281: -- This API has been created for
282: -- BULK OPERATION in Auto Packing
283: PROCEDURE create_dd_from_old_bulk(
284: p_delivery_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
285: p_delivery_detail_id IN NUMBER,
286: p_num_of_rec IN NUMBER,
287: x_dd_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
288: x_return_status OUT NOCOPY VARCHAR2
315:
316:
317: -- added new parameter to use this API
318: PROCEDURE Create_Delivery_Details(
319: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
320: x_rowid OUT NOCOPY VARCHAR2,
321: x_delivery_detail_id OUT NOCOPY NUMBER,
322: x_return_status OUT NOCOPY VARCHAR2
323: );
322: x_return_status OUT NOCOPY VARCHAR2
323: );
324:
325: PROCEDURE Create_Delivery_Details_Bulk(
326: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
327: p_num_of_rec IN NUMBER,
328: -- lpn conv
329: p_container_info_rec IN WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype,
330: x_return_status OUT NOCOPY VARCHAR2,
325: PROCEDURE Create_Delivery_Details_Bulk(
326: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
327: p_num_of_rec IN NUMBER,
328: -- lpn conv
329: p_container_info_rec IN WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_dd_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type
332: );
333:
353: --
354:
355: PROCEDURE Lock_Delivery_Details(
356: p_rowid IN VARCHAR2,
357: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type);
358:
359:
360: --
361: -- Procedure: Update_Delivery_Line
366:
367:
368: PROCEDURE Update_Delivery_Details(
369: p_rowid IN VARCHAR2 := NULL,
370: p_delivery_details_info IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
371: x_return_status OUT NOCOPY VARCHAR2
372: );
373: --
374: -- Procedure: Create_Delivery_Assignments
445: -- Return_Status,Valid_index_id_tab out
446: -- Description: This procedure will lock multiple delivery details.
447:
448: procedure Lock_Delivery_Details(
449: p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
450: p_caller IN VARCHAR2,
451: p_valid_index_tab IN wsh_util_core.id_tab_type,
452: x_valid_ids_tab OUT NOCOPY wsh_util_core.id_tab_type,
453: x_return_status OUT NOCOPY VARCHAR2
484:
485:
486: Procedure Table_To_Record(
487: p_delivery_detail_id IN NUMBER,
488: x_delivery_detail_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
489: x_return_status OUT NOCOPY VARCHAR2);
490:
491:
492: -- Locks wsh_delivery assignments based on delivery or delivery detail entered.