DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on WSH_INTERFACE_EXT_GRP

Line 567: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

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;
569: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
570:
571: l_msg_details VARCHAR2(3000);

Line 568: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

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;
569: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
570:
571: l_msg_details VARCHAR2(3000);
572: l_pricing_ind VARCHAR2(30);

Line 569: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

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;
569: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
570:
571: l_msg_details VARCHAR2(3000);
572: l_pricing_ind VARCHAR2(30);
573: l_tolerance NUMBER;

Line 711: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (

707:
708: l_shipping_in_rec.caller := 'WMS';
709: l_shipping_in_rec.action_code := 'UPDATE';
710:
711: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
712: p_api_version_number => 1.0
713: , p_init_msg_list => fnd_api.g_false
714: , p_commit => fnd_api.g_false
715: , x_return_status => x_return_status

Line 803: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;

799: AND wdd.inventory_item_id = p_inventory_item_id
800: AND NVL(wdd.revision, '@') = NVL(p_revision, '@')
801: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
802:
803: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
804: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
805: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
806: l_msg_details VARCHAR2(3000);
807: l_attr_counter NUMBER := 1;

Line 804: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;

800: AND NVL(wdd.revision, '@') = NVL(p_revision, '@')
801: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
802:
803: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
804: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
805: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
806: l_msg_details VARCHAR2(3000);
807: l_attr_counter NUMBER := 1;
808: l_del_det_id NUMBER;

Line 805: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;

801: AND NVL(wdd.lot_number, '@') = NVL(p_lot_number, '@');
802:
803: l_shipping_attr WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
804: l_shipping_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
805: l_shipping_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
806: l_msg_details VARCHAR2(3000);
807: l_attr_counter NUMBER := 1;
808: l_del_det_id NUMBER;
809: l_line_quantity NUMBER;

Line 909: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (

905: IF (l_debug = 1) THEN
906: print_debug('Calling Create_Update_Delivery_Detail count='||l_shipping_attr.count, 9);
907: END IF;
908:
909: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail (
910: p_api_version_number => 1.0
911: , p_init_msg_list => fnd_api.g_false
912: , p_commit => fnd_api.g_false
913: , x_return_status => x_return_status