DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_UTIL_CORE

Line 1723: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

1719: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1720: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1721:
1722: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1723: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
1724: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1725: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1726: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1727:

Line 1731: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;

1727:
1728: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1729: -- Need 2 different tables one for lpns that need to be unpacked one for
1730: -- lpns thatn need to be deleted
1731: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1732: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1733:
1734: -- Variables used to store LPN information
1735: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

Line 1732: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;

1728: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1729: -- Need 2 different tables one for lpns that need to be unpacked one for
1730: -- lpns thatn need to be deleted
1731: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1732: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1733:
1734: -- Variables used to store LPN information
1735: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1736: l_outer_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

Line 3160: WSH_UTIL_CORE.GET_DELIVERY_STATUS(

3156: where wlpn.outermost_lpn_id = p_lpn_table(1).lpn_id);
3157:
3158: IF (l_delivery_id <> 999) THEN
3159:
3160: WSH_UTIL_CORE.GET_DELIVERY_STATUS(
3161: p_entity_type => 'DELIVERY'
3162: ,p_entity_id => l_delivery_id
3163: ,x_status_code => l_status_code
3164: ,x_return_status => l_return_status);

Line 4187: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

4183: L_CORRECT CONSTANT NUMBER := 3;
4184: L_UNPACK_ALL CONSTANT NUMBER := 4;
4185:
4186: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4187: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4188: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4189: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4190: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4191: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 4188: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

4184: L_UNPACK_ALL CONSTANT NUMBER := 4;
4185:
4186: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4187: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4188: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4189: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4190: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4191: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
4192:

Line 8811: l_delivery_id_tab wsh_util_core.id_tab_type;

8807: x_msg_data OUT nocopy VARCHAR2,
8808: x_msg_count OUT nocopy NUMBER) IS
8809:
8810: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
8811: l_delivery_id_tab wsh_util_core.id_tab_type;
8812: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
8813: l_delivery_id NUMBER;
8814:
8815: l_return_status VARCHAR2(1);