[Home] [Help]
35: , x_uom_deviation_low OUT NOCOPY NUMBER
36: ) IS
37: l_api_name CONSTANT VARCHAR2(30) := 'Get_Catch_Weight_Attributes';
38: l_api_version CONSTANT NUMBER := 1.0;
39: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
40: l_progress VARCHAR2(10) := '0';
41:
42: l_wms_org_flag BOOLEAN;
43: l_secondary_uom_code VARCHAR2(3);
163: , p_inventory_item_id IN NUMBER
164: ) RETURN VARCHAR2 IS
165: l_api_name CONSTANT VARCHAR2(30) := 'Get_Ont_Pricing_Qty_Source';
166: l_api_version CONSTANT NUMBER := 1.0;
167: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
168: l_progress VARCHAR2(10) := '0';
169:
170: l_wms_org_flag BOOLEAN;
171: l_ont_pricing_qty_source VARCHAR(30);
255: , x_secondary_quantity OUT NOCOPY NUMBER
256: ) IS
257: l_api_name CONSTANT VARCHAR2(30) := 'Get_Default_Secondary_Quantity';
258: l_api_version CONSTANT NUMBER := 1.0;
259: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
260: l_progress VARCHAR2(10) := '0';
261:
262: l_wms_org_flag BOOLEAN;
263: l_default_ind VARCHAR(30);
410: , p_uom_deviation_low IN NUMBER := NULL
411: ) RETURN NUMBER IS
412: l_api_name CONSTANT VARCHAR2(30) := 'Check_Secondary_Qty_Tolerance';
413: l_api_version CONSTANT NUMBER := 1.0;
414: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
415: l_progress VARCHAR2(10) := '0';
416:
417: l_tracking_quantity_ind VARCHAR2(30);
418: l_ont_pricing_qty_source VARCHAR2(30);
560: , p_secondary_uom_code IN VARCHAR2 := NULL
561: ) IS
562: l_api_name CONSTANT VARCHAR2(30) := 'Update_Shipping_Secondary_Qty';
563: l_api_version CONSTANT NUMBER := 1.0;
564: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
565: l_progress VARCHAR2(10) := '0';
566:
567: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
568: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
785: , p_secondary_uom_code IN VARCHAR2
786: ) IS
787: l_api_name CONSTANT VARCHAR2(30) := 'Update_Parent_Delivery_Sec_Qty';
788: l_api_version CONSTANT NUMBER := 1.0;
789: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
790: l_progress VARCHAR2(10) := '0';
791:
792: CURSOR wdd_cur IS
793: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
987: , p_secondary_uom_code IN VARCHAR2
988: ) IS
989: l_api_name CONSTANT VARCHAR2(30) := 'Update_LPN_Secondary_Quantity';
990: l_api_version CONSTANT NUMBER := 1.0;
991: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
992: l_progress VARCHAR2(10) := '0';
993:
994: CURSOR mmtt_cur IS
995: SELECT rowid, transaction_temp_id, transaction_quantity, transaction_uom
1243: , p_outermost_lpn_id IN NUMBER
1244: ) RETURN NUMBER IS
1245: l_api_name CONSTANT VARCHAR2(30) := 'Check_LPN_Secondary_Quantity';
1246: l_api_version CONSTANT NUMBER := 1.0;
1247: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1248: l_progress VARCHAR2(10) := '0';
1249:
1250: CURSOR wdd_nested_lpn_cur IS
1251: SELECT wlpn.lpn_id, wdd.delivery_detail_id
2162: l_to_sec_qty NUMBER := 0;
2163: l_from_item_pri_qty NUMBER := 0 ;
2164: l_to_item_picked_qty NUMBER := 0;
2165: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_CT_WT_FOR_SPLIT';
2166: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2167: l_progress VARCHAR2(30) := '0';
2168: itemRec itemCur%ROWTYPE;
2169:
2170:
2316:
2317: l_progress VARCHAR2(20) := '0';
2318: l_api_name CONSTANT VARCHAR2(30) := 'IS_CT_WT_SPLIT_VALID';
2319: l_api_version CONSTANT NUMBER := 1.0;
2320: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2321: l_pri_qty NUMBER := 0;
2322: l_sec_Qty NUMBER := 0;
2323: l_pri_remaining_qty NUMBER := 0;
2324: l_sec_remaining_qty NUMBER := 0;
2467:
2468: l_progress VARCHAR2(20) := '0';
2469: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CT_WT_FOR_DELIVERYNUM';
2470: l_api_version CONSTANT NUMBER := 1.0;
2471: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2472: l_uom_conv_rate NUMBER;
2473: l_return NUMBER := G_CHECK_SUCCESS;
2474:
2475: BEGIN