DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_DATA_TYPE_DEFINITIONS_PUB

Line 2970: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

2966:
2967: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2968:
2969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2970: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
2971: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
2972:
2973: cursor lpn_cur is
2974: select lpn_id, organization_id

Line 2971: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

2967: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2968:
2969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2970: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
2971: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
2972:
2973: cursor lpn_cur is
2974: select lpn_id, organization_id
2975: from wms_license_plate_numbers

Line 6910: l_lpn_cur WMS_Data_Type_Definitions_PUB.LPNRecordType;

6906: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6907:
6908: -- Release 12 (K): LPN Synchronization/Convergence
6909: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
6910: l_lpn_cur WMS_Data_Type_Definitions_PUB.LPNRecordType;
6911: l_wsh_dd_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
6912: l_wsh_dd_upd_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
6913: wsh_create_tbl WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
6914: wsh_update_tbl WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;

Line 6922: /* Release 12(K), changed to use l_lpn_cur as type of WMS_Data_Type_Definitions_PUB.LPNRecordType; */

6918:
6919: BEGIN
6920: x_return_status := fnd_api.g_ret_sts_success;
6921:
6922: /* Release 12(K), changed to use l_lpn_cur as type of WMS_Data_Type_Definitions_PUB.LPNRecordType; */
6923: OPEN lpn_details;
6924: LOOP
6925: l_lpn_cur := null;
6926: FETCH lpn_details INTO