DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 347: RETURN WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type IS

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

Line 350: l_wsh_dd_rec WSH_Glbl_Var_Strct_GRP.Delivery_Details_Rec_Type;

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

Line 791: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;

787: l_input_param_tbl inv_label.input_parameter_rec_type;
788: l_return_status VARCHAR2(30);
789:
790: -- Variables used for Creating LPNs in shipping
791: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
792: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
793: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
794:
795: BEGIN

Line 792: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

788: l_return_status VARCHAR2(30);
789:
790: -- Variables used for Creating LPNs in shipping
791: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
792: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
793: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
794:
795: BEGIN
796: -- Standard Start of API savepoint

Line 793: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

789:
790: -- Variables used for Creating LPNs in shipping
791: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
792: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
793: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
794:
795: BEGIN
796: -- Standard Start of API savepoint
797: SAVEPOINT CREATE_LPNS_PVT;

Line 1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;

1906: ORDER BY wlc.inventory_item_id;
1907: --End of changes for Bug #3516547
1908:
1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1912: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1913: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1914:

Line 1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;

1907: --End of changes for Bug #3516547
1908:
1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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

Line 1912: l_IN_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;

1908:
1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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;

Line 1913: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;

1909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
1910: wsh_update_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_Type;
1911: wsh_create_tbl WSH_Glbl_Var_Strct_GRP.delivery_details_Attr_tbl_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;

Line 1917: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

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

Line 1918: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

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

Line 1919: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

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

Line 4631: l_wsh_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

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

Line 4632: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;

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

Line 4633: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;

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:
4635: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
4636: l_new WMS_Data_Type_Definitions_PUB.LPNRecordType;
4637: l_cont_new WMS_Data_Type_Definitions_PUB.LPNRecordType;