[Home] [Help]
43: , x_uom_deviation_low OUT NOCOPY NUMBER
44: ) IS
45: l_api_name CONSTANT VARCHAR2(30) := 'Get_Catch_Weight_Attributes';
46: l_api_version CONSTANT NUMBER := 1.0;
47: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
48: l_progress VARCHAR2(10) := '0';
49:
50: l_wms_org_flag BOOLEAN;
51: l_secondary_uom_code VARCHAR2(3);
171: , p_inventory_item_id IN NUMBER
172: ) RETURN VARCHAR2 IS
173: l_api_name CONSTANT VARCHAR2(30) := 'Get_Ont_Pricing_Qty_Source';
174: l_api_version CONSTANT NUMBER := 1.0;
175: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
176: l_progress VARCHAR2(10) := '0';
177:
178: l_wms_org_flag BOOLEAN;
179: l_ont_pricing_qty_source VARCHAR(30);
270: , x_secondary_quantity OUT NOCOPY NUMBER
271: ) IS
272: l_api_name CONSTANT VARCHAR2(30) := 'Get_Default_Secondary_Quantity';
273: l_api_version CONSTANT NUMBER := 1.0;
274: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
275: l_progress VARCHAR2(10) := '0';
276:
277: l_wms_org_flag BOOLEAN;
278: l_default_ind VARCHAR(30);
425: , p_uom_deviation_low IN NUMBER := NULL
426: ) RETURN NUMBER IS
427: l_api_name CONSTANT VARCHAR2(30) := 'Check_Secondary_Qty_Tolerance';
428: l_api_version CONSTANT NUMBER := 1.0;
429: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
430: l_progress VARCHAR2(10) := '0';
431:
432: l_tracking_quantity_ind VARCHAR2(30);
433: l_ont_pricing_qty_source VARCHAR2(30);
574: , p_secondary_uom_code IN VARCHAR2 := NULL
575: ) IS
576: l_api_name CONSTANT VARCHAR2(30) := 'Update_Shipping_Secondary_Qty';
577: l_api_version CONSTANT NUMBER := 1.0;
578: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
579: l_progress VARCHAR2(10) := '0';
580:
581: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
582: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
799: , p_secondary_uom_code IN VARCHAR2
800: ) IS
801: l_api_name CONSTANT VARCHAR2(30) := 'Update_Parent_Delivery_Sec_Qty';
802: l_api_version CONSTANT NUMBER := 1.0;
803: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
804: l_progress VARCHAR2(10) := '0';
805:
806: CURSOR wdd_cur IS
807: SELECT wdd.delivery_detail_id, wdd.picked_quantity, wdd.requested_quantity_uom,
980:
981: FUNCTION wdd_src_line_id RETURN numset_t PIPELINED
982: IS
983: l_api_name VARCHAR2(30) := 'wdd_src_line_id';
984: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
985: l_count NUMBER;
986: BEGIN
987: l_count := g_src_line_id.COUNT;
988: FOR i IN 1..l_count LOOP
1017: , p_sec_uom_code IN VARCHAR2
1018: ) IS
1019:
1020: l_api_name CONSTANT VARCHAR2(30) := 'process_ctwt_adj';
1021: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1022:
1023: l_txn_temp_id NUMBER;
1024: l_txn_hdr_id NUMBER;
1025: l_txn_type_id NUMBER;
1316: ) IS
1317:
1318: l_api_name CONSTANT VARCHAR2(30) := 'update_lpn_primary_quantity';
1319: l_api_version CONSTANT NUMBER := 1.0;
1320: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1321:
1322: CURSOR c_ds_lpn_qty IS
1323: SELECT SUM(wlc.primary_quantity)
1324: , SUM(wlc.secondary_quantity)
3318: , p_secondary_uom_code IN VARCHAR2
3319: ) IS
3320: l_api_name CONSTANT VARCHAR2(30) := 'Update_LPN_Secondary_Quantity';
3321: l_api_version CONSTANT NUMBER := 1.0;
3322: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3323: l_progress VARCHAR2(10) := '0';
3324:
3325: CURSOR mmtt_cur IS
3326: SELECT rowid, transaction_temp_id, transaction_quantity, transaction_uom
3574: , p_outermost_lpn_id IN NUMBER
3575: ) RETURN NUMBER IS
3576: l_api_name CONSTANT VARCHAR2(30) := 'Check_LPN_Secondary_Quantity';
3577: l_api_version CONSTANT NUMBER := 1.0;
3578: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3579: l_progress VARCHAR2(10) := '0';
3580:
3581: CURSOR wdd_nested_lpn_cur IS
3582: SELECT wlpn.lpn_id, wdd.delivery_detail_id
4661: l_to_sec_qty NUMBER := 0;
4662: l_from_item_pri_qty NUMBER := 0 ;
4663: l_to_item_picked_qty NUMBER := 0;
4664: l_api_name CONSTANT VARCHAR2(30) := 'SHOW_CT_WT_FOR_SPLIT';
4665: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4666: l_progress VARCHAR2(30) := '0';
4667: itemRec itemCur%ROWTYPE;
4668:
4669:
4815:
4816: l_progress VARCHAR2(20) := '0';
4817: l_api_name CONSTANT VARCHAR2(30) := 'IS_CT_WT_SPLIT_VALID';
4818: l_api_version CONSTANT NUMBER := 1.0;
4819: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4820: l_pri_qty NUMBER := 0;
4821: l_sec_Qty NUMBER := 0;
4822: l_pri_remaining_qty NUMBER := 0;
4823: l_sec_remaining_qty NUMBER := 0;
4966:
4967: l_progress VARCHAR2(20) := '0';
4968: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CT_WT_FOR_DELIVERYNUM';
4969: l_api_version CONSTANT NUMBER := 1.0;
4970: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4971: l_uom_conv_rate NUMBER;
4972: l_return NUMBER := G_CHECK_SUCCESS;
4973:
4974: BEGIN
5072: , p_inventory_item_id IN NUMBER
5073: , p_uom_code IN VARCHAR2
5074: ) IS
5075: l_code VARCHAR2(20) := p_uom_code;
5076: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5077: BEGIN
5078: IF ( l_debug = 1 ) THEN
5079: print_debug('Entered get_primary_uom_class:' ||
5080: ' p_organization_id: ' || p_organization_id ||
5143: , p_tare_weight IN NUMBER
5144: , p_tare_uom_code IN VARCHAR2
5145: , p_update_tare_flag IN VARCHAR2
5146: ) IS
5147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5148: l_api_return_status VARCHAR2(1);
5149:
5150: l_lpn_tbl wms_data_type_definitions_pub.lpntabletype;
5151: l_lpn_rec wms_data_type_definitions_pub.lpnrecordtype;