DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_UTIL_CORE

Line 32: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,

28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
31: -- program specific parameters
32: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
33: p_action IN VARCHAR2,
34: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
35: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
36: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH

Line 50: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,

46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: -- program specific parameters
50: p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
51: p_action IN VARCHAR2,
52: p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
54: );

Line 282: group_id_tab wsh_util_core.id_tab_type,

278: container_instance_id NUMBER,
279: container_flag VARCHAR2(1),
280: delivery_flag VARCHAR2(1),
281: -- Autopack
282: group_id_tab wsh_util_core.id_tab_type,
283: -- Split Line
284: split_quantity NUMBER,
285: split_quantity2 NUMBER,
286: -- Process Deliveries

Line 317: valid_id_tab WSH_UTIL_CORE.id_tab_type,

313: wsh_glbl_var_strct_grp
314: */
315: TYPE action_out_rec_type IS RECORD
316: (
317: valid_id_tab WSH_UTIL_CORE.id_tab_type,
318: selection_issue_flag VARCHAR2(1),
319: delivery_id_tab WSH_UTIL_CORE.id_tab_type,
320: result_id_tab WSH_UTIL_CORE.id_tab_type,
321: split_quantity NUMBER,

Line 319: delivery_id_tab WSH_UTIL_CORE.id_tab_type,

315: TYPE action_out_rec_type IS RECORD
316: (
317: valid_id_tab WSH_UTIL_CORE.id_tab_type,
318: selection_issue_flag VARCHAR2(1),
319: delivery_id_tab WSH_UTIL_CORE.id_tab_type,
320: result_id_tab WSH_UTIL_CORE.id_tab_type,
321: split_quantity NUMBER,
322: split_quantity2 NUMBER);
323:

Line 320: result_id_tab WSH_UTIL_CORE.id_tab_type,

316: (
317: valid_id_tab WSH_UTIL_CORE.id_tab_type,
318: selection_issue_flag VARCHAR2(1),
319: delivery_id_tab WSH_UTIL_CORE.id_tab_type,
320: result_id_tab WSH_UTIL_CORE.id_tab_type,
321: split_quantity NUMBER,
322: split_quantity2 NUMBER);
323:
324: --

Line 385: lpn_ids wsh_util_core.id_tab_type

381: base_number NUMBER,
382: num_digits NUMBER,
383: quantity NUMBER,
384: container_name VARCHAR2(32767),
385: lpn_ids wsh_util_core.id_tab_type
386: );
387:
388: --
389: /* do not use detailOutRecType, use the table defined in wsh_glbl_var_strct_grp */

Line 393: detail_ids WSH_UTIL_CORE.Id_Tab_Type

389: /* do not use detailOutRecType, use the table defined in wsh_glbl_var_strct_grp */
390: TYPE detailOutRecType IS RECORD
391: (
392: --
393: detail_ids WSH_UTIL_CORE.Id_Tab_Type
394: );
395:
396: -- Patchset I: Harmonization Project Changes End
397:

Line 452: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

448: , p_caller IN VARCHAR2 DEFAULT NULL
449: , x_return_status OUT NOCOPY VARCHAR2
450: , x_msg_count OUT NOCOPY NUMBER
451: , x_msg_data OUT NOCOPY VARCHAR2
452: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
453: , p_group_by_header_flag IN VARCHAR2 DEFAULT NULL
454: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
455: );
456:

Line 454: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type

450: , x_msg_count OUT NOCOPY NUMBER
451: , x_msg_data OUT NOCOPY VARCHAR2
452: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
453: , p_group_by_header_flag IN VARCHAR2 DEFAULT NULL
454: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
455: );
456:
457: PROCEDURE Autocreate_del_trip(
458: p_api_version_number IN NUMBER

Line 464: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

460: , p_commit IN VARCHAR2
461: , x_return_status OUT NOCOPY VARCHAR2
462: , x_msg_count OUT NOCOPY NUMBER
463: , x_msg_data OUT NOCOPY VARCHAR2
464: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
465: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
466: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
467: );
468:

Line 465: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type

461: , x_return_status OUT NOCOPY VARCHAR2
462: , x_msg_count OUT NOCOPY NUMBER
463: , x_msg_data OUT NOCOPY VARCHAR2
464: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
465: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
466: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
467: );
468:
469: -- ---------------------------------------------------------------------

Line 466: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type

462: , x_msg_count OUT NOCOPY NUMBER
463: , x_msg_data OUT NOCOPY VARCHAR2
464: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
465: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
466: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
467: );
468:
469: -- ---------------------------------------------------------------------
470: -- Procedure: Delivery_Detail_Action

Line 560: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,

556: --
557: -- Description: This procedure is the new API for wrapping the logic of autcreate_deliveries.
558: -- Usage: Called by WMS code to return carton grouping table.
559: -- -----------------------------------------------------------------------
560: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
561: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
562: x_return_status OUT NOCOPY VARCHAR2);
563:
564:

Line 561: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

557: -- Description: This procedure is the new API for wrapping the logic of autcreate_deliveries.
558: -- Usage: Called by WMS code to return carton grouping table.
559: -- -----------------------------------------------------------------------
560: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
561: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
562: x_return_status OUT NOCOPY VARCHAR2);
563:
564:
565: END WSH_DELIVERY_DETAILS_GRP;