DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_DATA_TYPE_DEFINITIONS_PUB

Line 3127: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;

3123:
3124: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
3125:
3126: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3127: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3128: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3129:
3130: cursor lpn_cur is
3131: select lpn_id, organization_id

Line 3128: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;

3124: l_freight_costs WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
3125:
3126: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3127: l_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
3128: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3129:
3130: cursor lpn_cur is
3131: select lpn_id, organization_id
3132: from wms_license_plate_numbers

Line 8007: l_lpn_cur WMS_Data_Type_Definitions_PUB.LPNRecordType;

8003: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8004:
8005: -- Release 12 (K): LPN Synchronization/Convergence
8006: -- Types needed for WSH_WMS_LPN_GRP.Create_Update_Containers
8007: l_lpn_cur WMS_Data_Type_Definitions_PUB.LPNRecordType;
8008: l_wsh_dd_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8009: l_wsh_dd_upd_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8010: wsh_create_tbl WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;
8011: wsh_update_tbl WSH_GLBL_VAR_STRCT_GRP.delivery_details_Attr_tbl_Type;

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

8015:
8016: BEGIN
8017: x_return_status := fnd_api.g_ret_sts_success;
8018:
8019: /* Release 12(K), changed to use l_lpn_cur as type of WMS_Data_Type_Definitions_PUB.LPNRecordType; */
8020: OPEN lpn_details;
8021: LOOP
8022: l_lpn_cur := null;
8023: FETCH lpn_details INTO