DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 344: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS

340:
341: FUNCTION To_DeliveryDetailsRecType (
342: p_lpn_record IN WMS_Data_Type_Definitions_PUB.LPNRecordType
343: )
344: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS
345:
346: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
347: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;
348:

Line 347: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;

343: )
344: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS
345:
346: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
347: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;
348:
349: BEGIN
350:
351: l_wsh_dd_rec.lpn_id := p_lpn_record.lpn_id;

Line 736: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;

732: l_input_param_tbl inv_label.input_parameter_rec_type;
733: l_return_status VARCHAR2(30);
734:
735: -- Variables used for Creating LPNs in shipping
736: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
737: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
738: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
739:
740: BEGIN

Line 737: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

733: l_return_status VARCHAR2(30);
734:
735: -- Variables used for Creating LPNs in shipping
736: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
737: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
738: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
739:
740: BEGIN
741: -- Standard Start of API savepoint

Line 738: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

734:
735: -- Variables used for Creating LPNs in shipping
736: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
737: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
738: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
739:
740: BEGIN
741: -- Standard Start of API savepoint
742: SAVEPOINT CREATE_LPNS_PVT;

Line 1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;

1713: ORDER BY wlc.inventory_item_id;
1714: --End of changes for Bug #3516547
1715:
1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1719: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1720: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1721:

Line 1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;

1714: --End of changes for Bug #3516547
1715:
1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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

Line 1719: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1715:
1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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;

Line 1720: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1716: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1717: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1718: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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;

Line 1724: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

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:
1728: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action

Line 1725: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

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:
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

Line 1726: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

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:
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

Line 4189: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

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:
4193: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

Line 4190: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

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:
4193: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4194: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;

Line 4191: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

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:
4193: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4194: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4195: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;