DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_UTIL_CORE

Line 1916: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

1912: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1913: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1914:
1915: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1916: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
1917: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1918: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
1919: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1920:

Line 1924: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;

1920:
1921: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1922: -- Need 2 different tables one for lpns that need to be unpacked one for
1923: -- lpns thatn need to be deleted
1924: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1926:
1927: -- Variables used to store LPN information
1928: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

Line 1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;

1921: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
1922: -- Need 2 different tables one for lpns that need to be unpacked one for
1923: -- lpns thatn need to be deleted
1924: l_wsh_unpack_lpn_id_tbl wsh_util_core.id_tab_type;
1925: l_wsh_delete_lpn_id_tbl wsh_util_core.id_tab_type;
1926:
1927: -- Variables used to store LPN information
1928: l_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;
1929: l_outer_lpn_ids WMS_Data_Type_Definitions_PUB.NumberTableType;

Line 3460: WSH_UTIL_CORE.GET_DELIVERY_STATUS(

3456: where wlpn.outermost_lpn_id = p_lpn_table(1).lpn_id);
3457:
3458: IF (l_delivery_id <> 999) THEN
3459:
3460: WSH_UTIL_CORE.GET_DELIVERY_STATUS(
3461: p_entity_type => 'DELIVERY'
3462: ,p_entity_id => l_delivery_id
3463: ,x_status_code => l_status_code
3464: ,x_return_status => l_return_status);

Line 4629: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

4625: L_CORRECT CONSTANT NUMBER := 3;
4626: L_UNPACK_ALL CONSTANT NUMBER := 4;
4627:
4628: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4629: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4630: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4631: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

Line 4630: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;

4626: L_UNPACK_ALL CONSTANT NUMBER := 4;
4627:
4628: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
4629: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;
4630: l_wsh_del_det_id_tbl wsh_util_core.id_tab_type;
4631: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
4634:

Line 9384: l_delivery_id_tab wsh_util_core.id_tab_type;

9380: x_msg_data OUT nocopy VARCHAR2,
9381: x_msg_count OUT nocopy NUMBER) IS
9382:
9383: l_action_prms wsh_interface_ext_grp.del_action_parameters_rectype;
9384: l_delivery_id_tab wsh_util_core.id_tab_type;
9385: l_delivery_out_rec wsh_interface_ext_grp.del_action_out_rec_type;
9386: l_delivery_id NUMBER;
9387:
9388: l_return_status VARCHAR2(1);