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